Use the Student/Classroom spreadsheet to create students and classrooms in DreamBox Math, and assign teachers and students to classrooms. This article walks through what data is required or optional in each column of the spreadsheet and how to submit your file successfully.
Getting Started
The directions below will help you complete and verify the information required in each column of the Student/Classroom spreadsheet before you submit your file in the dashboard.
If you are using the Student spreadsheet to create or adjust a handful of students inside an existing Math classroom, you can do this directly from the Roster tab inside the Teacher Settings tabs in your dashboard. If you want to create a new classroom, you need to use the Student spreadsheet. |
What do I need?
- Student and classroom roster information from your district or school that include:
- Students: Student first and last names, grade levels, and school student IDs.
- Teachers: Email addresses
- Classrooms: Classroom name, associated teachers, student roster
- The Student/Classroom spreadsheet template. If you haven't already downloaded the spreadsheet, click here to jump to the bottom of this article and download the spreadsheet.
The Student/Classroom spreadsheet will not create teacher accounts. You will need to prepare the Educator spreadsheet and either submit it before you submit the Student/Classroom spreadsheet or submit them at the same time. |
Completing the Student/Classroom Spreadsheet
- Open the Student/Classroom spreadsheet.
- Delete the sample data shown in the top rows.
Click the image to enlarge it
- Add student and classroom information to the spreadsheet, using the table below as a guide.
Columns that must be completed are marked with an *. If you do not see a *, you can leave the column blank, but you need to keep all columns on the spreadsheet. |
Column Header | What information belongs here? | |||
---|---|---|---|---|
A* | Student First Name | The student's first name as it should appear in DreamBox Math.
|
||
B* | Student Last Name | The student's last name as it should appear in DreamBox Math.
|
||
C | Gender | You can leave the entire Gender column blank if you do not wish to designate students’ genders. Do not delete this column.
|
||
D* | Grade | The students’ enrolled grade levels. Use the following numbers:
|
||
E | Initial Placement |
The grade level which represents where the student should be placed in the DreamBox curriculum.
Example: A 5th-grade student is working at the 5th-grade level. You would leave the cell for this student in this column blank.
Example: An intervention student enrolled in 5th grade who is working through 4th grade standards might benefit from an initial placement at 4th grade. You would add “4” to the cell for this student in this column. |
||
F* | School Student ID | The student's unique school ID number. DreamBox Math tracks progress using this ID, so this information is essential.
|
||
G* | DreamBox Math Classroom Nam | This is the classroom name students will select when logging in to DreamBox Math, and the name teachers will see on their dashboards.
|
||
H*-K* | School Information |
School name, city, address, and zip code.
|
||
L* | Primary Teacher Email | Classroom teacher’s email address.
|
||
M | Language | Leave the entire Language column blank if you want students to start playing DreamBox Math in English. Do not delete this column.
|
||
N | Username | Leave this column blank if you want DreamBox to create usernames based on each student’s first and last name. Do not delete this column.
|
||
O | Password | Leave this column blank if you want DreamBox to create four-letter passwords for each student. Do not delete this column. PreK-1 students will choose their picture passwords the first time they sign in to DreamBox Math. Tips when adding text passwords.
|
- When you have completed the spreadsheet, save the spreadsheet as a Comma-delimited file (.csv), including the school name and “Student” in the file name. Example: "McAuliffe Academy_Students_2022".
Click here to open directions on how to save your file as a CSV. |
- Upload both the Educator and Student/Classroom spreadsheets through your Insight dashboard.
Click here to open directions on how to upload your spreadsheets. |
After you upload your spreadsheets, we will review your roster data and contact you if we have any questions. If not, we will process your rosters and send you a confirmation email. Teacher invitations will be sent upon completion. If you have any questions, please contact DreamBox Customer Support.
What Happens If I Don’t Complete the Spreadsheet Correctly Before I Submit It?
If your spreadsheet is missing or contains conflicting information, like two students sharing the same student ID, your file will not continue processing and you will see a list of errors that need to be fixed on your spreadsheet. You will need to resolve each item and upload the spreadsheet again.
Next Steps & Additional Resources
- Click here to learn how to prepare the Educator. spreadsheet.
- Click here to return to the Insight Roster Upload overview article.
Download the Student/Classroom Spreadsheet
Click the attachment below to download the Student/Classroom spreadsheet template. Click here to jump back to the Completing the Student/Classroom Spreadsheet section.
- Student Upload Template.csv659 Bytes
Updated