Import Students

Please note: Only a School Administrator is able to import students and this functionality is not available for tablets and mobile devices.

IMPORT NEW STUDENT DETAILS

1. Select Import New Student Details from the drop-down menu in Step 1 and click the Submit button.

2. Download the Import New Student Details CSV file by clicking the Download CSV File Template button.

• All classes need to have been created before importing new students.
• Do not delete any rows from the downloaded template.
• All classes need to be created before you import new students.
• Begin entering user data in the eleventh row (cell A13).
• For free trial accounts, fill in the "SUBSCRIPTION TYPE" as "CS-TA" for CARS & STARS and/or "FR-TA" for FOCUS READING modules.
• Each CARS & STARS Online student subscription consists of a combination of the modules (CARS & STARS and FOCUS READING), and the subscription type, which is based on duration (3-, 6- and 12-months). You can assign the relevant subscription(s) to students by filling in the "SUBSCRIPTION TYPE" for each module, separated by commas.
• For a CARS & STARS subscription, "SUBSCRIPTION TYPE" should be entered as "CS-3M", "CS-6M" or "CS-12M" with the number indicating duration. FOCUS READING subscriptions should be entered as "FR-3M", "FR-6M" or "FR-12M" in the same way. You can have a CS-3M and a FR-3M for a single student, but not two subscriptions for the same module (e.g. a CS-12M and a CS-3M subscription) for the same student at the same time. For a CARS & STARS + FOCUS Reading bundled subscription, this should be entered as "CS-FR-3M", "CS-FR-6M" or "CS-FR-12M".
• For a virtual account, "SUBSCRIPTION TYPE" should be "VA".
• If a student belongs to multiple classes, enter all the relevant class names, each separated by commas.
• If a student is not assigned to any classes, 'CLASS' column should be filled in as 'N/A'.
• All fields are required.
• Please ensure that all columns do not contain illegal characters (' " `).

3. Select the completed .csv file by clicking Select File in Step 3 and then the Upload button.

Please note: Please do not refresh the page or press the back button when the system is processing your data. Additionally, the Student Subscription will be deducted from your school account once you have added the students using the Subscription Account (SA) option.

UPDATE EXISTING STUDENT DETAILS

1. Select Update Existing Student Details from the drop-down menu in Step 1 and click the Submit button.

2. Select student status from either All (excluding discontinued students), Active, Inactive, Virtual, Expired or Discontinued.

3. Download and fill in the .csv file by clicking the Download CSV File Template button.

• All classes need to be created before importing new students.
• Please ensure all columns do not contain illegal characters (' " `).
• Do not alter the DATABASE ID, ACCESS CODE, STATUS, ACCOUNT TYPE, SUBSCRIPTION STATUS or EXISTING CLASS fields as they are linked to each user.
• You may modify FIRST NAME, LAST NAME, NEW CLASS and SUBSCRIPTION ACTION for the students, if required.
• Annual subscription account cannot be downgraded to a free trial account or a VA (virtual account). A free trial account cannot be downgraded to a VA (virtual account).
• The SUBSCRIPTION STATUS column gives you information about the account expiry and will be marked as EXPIRING for accounts expiring within 30 days, as EXPIRED for accounts that have already expired or as ACTIVE otherwise. For a virtual account, the SUBSCRIPTION STATUS will always be N/A.
• When an account is renewed, the account type will be changed to SA and status will be changed to ACTIVE.

TRANSFER STUDENTS

• To transfer students from an existing class, update the NEW CLASS column for each student.
• For a student belonging to multiple classes, enter all the relevant class names, each separated by commas.
• For a student who is not assigned to any classes, the NEW CLASS column should be filled in as N/A.
• If you would like to remove the student from all their existing classes, the NEW CLASS column should be filled in as N/A.
• If the student remains in the same class, fill in the NEW CLASS column with their existing class name.

EXPIRED ACCOUNTS

• Expired accounts should be either renewed or discontinued.
• If you do not wish to renew/upgrade an expired account, mark the SUBSCRIPTION ACTION as DISCONTINUE. The discontinued accounts will be deleted after the account has expired for 6 months.

SUBSCRIPTION RENEWAL/UPGRADE

• Each CARS & STARS Online student subscription consists of a combination of the modules (CARS & STARS and FOCUS READING), and the subscription type, which is based on duration (3-, 6- and 12-months). You can assign the relevant subscription(s) to students by filling in the "SUBSCRIPTION TYPE" for each module, separated by commas.
• For a CARS & STARS subscription account, "SUBSCRIPTION TYPE" should be entered as "CS-3M", "CS-6M" or "CS-12M" with the number indicating duration. FOCUS READING subscriptions should be entered as "FR-3M", "FR-6M" or "FR-12M" in the same way. You can have a CS-3M and a FR-3M for a single student, but not two subscriptions for the same module (e.g. a CS-12M and a CS-3M subscription) for the same student at the same time. For a CARS & STARS + FOCUS Reading bundled subscription, this should be entered as "CS-FR-3M", "CS-FR-6M" or "CS-FR-12M".
• If the account does not need to be renewed/upgraded, 'SUBSCRIPTION ACTION' should be filled in as 'N/A'.

STUDENTS WHO LEFT SCHOOL

• For students who have left the school, specify the SUBSCRIPTION ACTION as DISCONTINUE and fill in their NEW CLASS column as N/A. The discontinued accounts will be deleted after the account has expired for 6 months. Please note that any existing classes for the discontinued students will be deleted.

REACTIVATE INACTIVE/DISCONTINUED ACCOUNTS

• To reactivate an inactive/discontinued TA or SA that has not expired, 'SUBSCRIPTION ACTION' should be filled in as 'REACTIVATE'. Expired accounts can only be renewed, not reactivated.
• To reactivate an inactive/discontinued CARS & STARS subscription that has not expired, 'SUBSCRIPTION ACTION' should be filled in as 'CS-REACTIVATE'. Expired accounts can only be renewed, not reactivated.
• To reactivate an inactive/discontinued FOCUS Reading subscription that has not expired, 'SUBSCRIPTION ACTION' should be filled in as 'FR-REACTIVATE'. Expired accounts can only be renewed, not reactivated.
• To reactivate a discontinued VA, 'SUBSCRIPTION ACTION' should be filled in as 'REACTIVATE'.

DEACTIVATE ACTIVE ACCOUNTS

• To deactivate an active trial or subscription account, fill in the 'SUBSCRIPTION ACTION' as 'DEACTIVATE'. A virtual account cannot be deactivated.
• To deactivate an active CARS & STARS subscription, fill in the 'SUBSCRIPTION ACTION' as 'CS-DEACTIVATE'.
• To deactivate an active FOCUS Reading subscription, fill in the 'SUBSCRIPTION ACTION' as 'FR-DEACTIVATE'.

4. Select the completed .csv file by clicking Select File in Step 3 and then the Upload button.

The Number of Student Subscriptions remaining is also listed in Step 3.

Please note: Please do not refresh the page or press the back button when the system is processing your data.