Imagine Math

Imagine Math file specifications

schools.csv

The schools.csv file provides school information, such as the names and addresses of schools.

Field

Required

Description

school_id

Yes

Alphanumeric ID for the school within the district. Must be unique across the district. Case insensitive.

school_name

Yes

Name of the school.

school_address

Yes

Address of the school. If the address includes one or more commas, the entire address must be enclosed in double quotes. Used to set the time zone of the school.

school_city

Yes

City in which the school resides. Used to set the time zone of the school in Imagine Math.

school_state

Yes

Two letter state abbreviation for the state in which the school resides (i.e. CA, TX). Used to set the time zone of the school.

school_zip

Yes

Numeric 5 or 9 digit zip code for the school (i.e. 90210 or 902103907). school_zip must not contain punctuation (i.e. hyphens). Used to set the time zone of the school.

students.csv

The students.csv file provides student information, such as the names and student information numbers of students.

Field

Required

Description

school_id

Yes

Alphanumeric ID for the primary school of enrollment. school_id must match school_id in schools.csv.

classroom_id_1

Yes

Unique ID for the primary classroom. classroom_id_1 must match a classroom_id provided in classrooms.csv.

classroom_id_2

No

Unique ID for an additional classroom. classroom_id_2 must match a classroom_id provided in classrooms.csv.

classroom_id_3

No

Unique ID for an additional classroom. classroom_id_3 must match a classroom_id provided in classrooms.csv.

student_id

Yes

Unique ID for the student. Must be unique across the district. Can be the same as student_number.

student_number

Yes

Local identifier for the student. Used to set the Student Information Number. Must be unique across the district. Can be the same as student_id.

state_id

No

State identifier for the student. Used to set the Alt. Student Information Number.

last_name

Yes

Last name of the student. Cannot begin with numbers (i.e. 1, 2, 3). Cannot begin with—or contain—commas or special characters (i.e., &, @, #, $, ?)

first_name

Yes

First name of the student. Cannot begin with numbers (i.e. 1, 2, 3). Cannot begin with—or contain—commas or special characters (i.e., &, @, #, $, ?)

grade

Yes

Nominal grade level of the student. Acceptable values are integers (3, 4, 5, 6, 7, 8) or strings (Algebra Readiness, Algebra I, Geometry, HS Math I, HS Math II). For the Imagine Math K-2 Benchmark Series, acceptable values are K, 1, 2.

ell_status

No

English Language Learner status for the student. Acceptable values are Y, N. If left blank, N is assumed.

iep_status

No

Individualized Education Program status for the student. Acceptable values are Y, N. If left blank, N is assumed.

username

No

Alphanumeric username for the student. If left blank, username will be generated. Must be unique across all Imagine Math customers.

password

No

Password for the student. Must be a minimum of 4 characters. If left blank, password will be generated.

second_language

No

Sets ability for the student to hear audio in Spanish. Acceptable value is es to allow Spanish audio. If left blank, student will be unable to hear Spanish audio.

teachers.csv

The teachers.csv file provides teacher information, such as the names of teachers and associated schools.

Field

Required

Description

school_id

Yes

Alphanumeric ID for the school of employment for the teacher. school_id must match school_id in schools.csv.

teacher_id

Yes

Unique ID for the teacher. teacher_id must match the teacher_id provided in classrooms.csv. Must be unique across the district.

teacher_email

Yes

Email address for the teacher. Must follow the proper format of username@domain (joe@example.com) and characters must be all lowercase. Must be unique across the district.

last_name

Yes

Last name of the teacher.

first_name

Yes

First name of the teacher.

classrooms.csv

The classrooms.csv file provides classroom information, such as classroom names and the teachers are associated with classrooms.

Field

Required

Description

school_id

Yes

Alphanumeric ID for the primary school of enrollment. school_id must match school_id in schools.csv.

classroom_id

Yes

Unique ID for the classroom. classroom_id must match a classroom_id provided in enrollments.csv. Must be unique across the district.

teacher_id

Yes

Unique ID for the primary teacher. teacher_id must match a teacher_id provided in teachers.csv. Must be unique across the district.

teacher_2_id

No

Unique ID for an additional co-teacher. teacher_2_id must match a teacher_id provided in teachers.csv. Must be unique across the district.

teacher_3_id

No

Unique ID for an additional co-teacher. teacher_3_id must match a teacher_id provided in teachers.csv. Must be unique across the district.

teacher_4_id

No

Unique ID for an additional co-teacher. teacher_4_id must match a teacher_id provided in teachers.csv. Must be unique across the district.

name

Yes

Unique name for the classroom.

allow_ttm_managed_enrollments

No

Sets whether or not students will be enrolled in default grade-level pathways when student accounts are created in the classroom. Acceptable values are Y, N. Set the field to Y to enroll students in default pathways when student accounts are created. Set the field to N to create students without enrolling them in default pathways. If left blank, Y will be assumed.

school_admins.csv

The school_admins.csv file provides school administrator information, such as names of school administrators and schools they manage. This file is optional.

School administrators new to Imagine Math will receive an email invitation to register for an Imagine Math account and will be asked to establish a password upon registration.

Field

Required

Description

school_id

Yes

Alphanumeric ID for the school of employment for the teacher. school_id must match school_id in schools.csv.

staff_id

Yes

Unique ID for the school administrators. staff_id must match a staff_id provided in schools.csv. Must be unique across the district.

admin_email

Yes

Email address for the school administrator. Must follow the proper format of username@domain.com. Must be unique across the district.

last_name

Yes

Last name of the school administrator.

first_name

Yes

First name of the school administrator.

Tags