How Do I Process a Student Bulk Upload?

This process can be used for the following:

• Create New Students

• Update Personal Student Information

• Assign a Student to a Class

• De-assign (disconnect) a Student from a Class, School, or Community

• Move Students from Class A to Class B

• Change a Student’s Status

• Inactive Students

• Activate Students

• Delete Students

Download the Excel template for specific instructions: https://cliengage.org/resource/XLSX/Student_Template.xlsx

Open

 Instructions

1. Log in to https://public.cliengage.org/

2. Click on “Class & Student Management” under the “Administrative Tools” tab on the CLI Engage dashboard

3. In the left navigation, select “Data Management”

4. On the next screen, select “Student”

5. Click to download the “Student_Template.xlsx”

6. Complete Student Template by following the steps on the Instructions tab of the template. Column A will be either I for Insert or U for Update - please see the Instructions tab for further details.

   Community, School, and Student information can be copied from the Student Results Export https://cliengage.atlassian.net/l/cp/CDVU1y24

   From the Student Results Export, copy/complete the data from the following columns onto the Student template:

   • Community Name

   • Community Engage ID

   • School Name

   • School Engage ID

   • Student First Name

   • Student Middle Name

   • Student Last Name

   • Student Engage ID (Existing Students Needing an Update)

   • Student Internal ID

   • Student Birth Date

   • Student Gender (Optional but recommended)

   • Student Race

   • Student Ethnicity

   • Student State Unique ID (TSDS ID)

   • Student Grade Level, Class Name, Class Engage ID (for existing classes only)

   • Assessment Language

   • Columns U through AC are optional and can be completed at a later date if needed

7. Under “Data Management”, choose the Student option and select the file from your desktop

8. Upload and process your file by clicking on the Play button