When using DreamBox ARM, you may export school and roster information into two CSV spreadsheet files or a single file, depending on which option works best for your district. The roster information in the files will create the schools, educators, students, classrooms, classroom memberships, and enrollments.
When building your files, use a CSV (comma-separated value) format. Each file must contain a header row. Headers must be named exactly as specified in the templates at the bottom of this page and use line breaks between rows. Field values must be separated by commas. If a field value contains a comma, then the field value itself must be enclosed in double quotes. If a field value contains a double quote, then two double quotes should be substituted ("").
Every time you transmit the files, they must contain all schools, educators, classrooms, and students that will be using DreamBox. All changes will be processed during the upload, but the files must be complete each time. If your files contain only updated information rather than all of your schools and rosters, then any object that is no longer included on the files will be deleted in DreamBox.
The two tables below (one for classrooms/students and the other for educators) detail the type of data that should be contained in each column of the files.
CLASSROOM/STUDENT SPREADSHEET PREPARATION INSTRUCTIONS
1) Open the student spreadsheet attached at the bottom of this page (dbl-students.csv) in Excel. Do not make any changes to the Column Headers.
2) Fill in the columns of the spreadsheet for each student you wish to add to DreamBox. Required fields are marked with an asterisk (*). If any of the required fields are not complete, we will not be able to upload your students.
|Column||Header Row||What data should be entered in this cell?|
|A||Student First Name*||Type the student’s first name as it should appear in DreamBox.|
|B||Student Last Name*||Type the student’s last name as it should appear in DreamBox.|
|C||Gender*||Type M or F to indicate the student’s gender. Our system will accept only M or F.|
|D||Grade*||Type the student’s enrolled grade level. Please use 1-12 (0 = K, -1 = PreK).|
|E||Initial Placement||Type the grade level that represents where the student should be placed in the DreamBox curriculum (i.e. 5th grade Intervention student, working at the 2nd grade level). Please use 1-12 (0 = K, -1 = PreK).|
|F||saml id||The ID you have set for your saml ID will need to be added to the saml id column. If you are not using DreamBox SSO, leave the column blank.|
|G||School Student ID*||Type the student’s school ID number. You may substitute an alternate number, but the ID must be unique for each student across the district. DreamBox tracks progress using this ID, so this information is essential. Please do not reuse IDs.|
|H||DreamBox Math Classroom Name*||The DreamBox classroom name is the classroom students will select when logging in to DreamBox. Each classroom name must be unique, especially if an instructor teaches multiple classes and you would like each classroom to remain unique in DreamBox. We suggest using the format “School name – Grade – Teacher Last Name”.|
|I-L||School information*||Type the school name, city, address, and zip code. Use the Excel Drag and Copy or Fill Down functions to save time. The school name should match the exact spelling and capitalization of the school name on the far left column of your Insight Dashboard.|
|M||Primary Teacher Email*||Type the email address of the classroom teacher. You can use the Excel Drag and Copy function to save time. If you would like to associate two teachers with the same DreamBox Math Classroom, make sure each of their emails are added as the primary teacher for at least one student in the classroom.|
|N||Language||If you would like the student to play DreamBox in English, leave this cell blank. Type “Spanish” into this cell if you would like the student to play DreamBox in Spanish.|
|O||Username||Type the username you would like the student to use when signing into DreamBox. Each student username must be unique across the district. If you leave this column blank, DreamBox will create usernames based on the students’ first and last name.|
|P||Password||Type the password you would like the student to use when signing in to DreamBox. Passwords must be at least four characters long, and do not have to be unique. If you leave this column blank, DreamBox will create four-character passwords for each student. K-2 students will choose their picture passwords the first time they sign in to DreamBox.|
3) When complete, save the spreadsheet as a Comma delimited file (.csv). The file must retain the same name, dbl-students.csv, in order to be processed.
The teacher spreadsheet will need to be sent for existing educators, to create new teachers and administrators, assign administrative permissions to an existing teacher account, and associate teachers and administrators with the correct district and school.
TEACHER SPREADSHEET PREPARATION DIRECTIONS
1) Open the teacher spreadsheet attached at the bottom of this page (dbl-educators.csv) in Excel. Do not make any changes to the column headers.
2) Fill in the columns of the spreadsheet for each teacher that exists and that you wish to add to DreamBox. Required fields are marked with an *.
3) Type a “Y or an “N” in the District and School Administrator columns to establish if you want to grant district or school-level administrative permissions to that teacher.
|Column||Header Row||What data should be entered in this cell?|
|A||Teacher email address*||Type the teacher’s school email address|
|B||Teacher first name*||Type the teacher’s first name as it should appear in DreamBox.|
|C||Teacher last name*||Type the teacher’s last name as it should appear in DreamBox.|
|D||saml id||The ID you have set for your saml ID will need to be added to the saml id column. If you are not using DreamBox SSO, leave the column blank.|
|E||School name*||Type the school’s name. The school name should match the exact spelling and capitalization of the school name on the far left column of your Insight Dashboard.|
|F||District Administrator||Type “Y” or "N" to indicate whether the staff member needs district-level administrative access.|
|G||School Administrator||Type “Y” or "N" to indicate whether the staff member needs school-level administrative access. If the staff member needs administrative access to multiple schools, please list each in unique rows.|
If you have any questions, please contact Client Success via email at firstname.lastname@example.org or by phone at ext. 3. We are available Monday through Friday from 5AM to 5PM PT.