Can I get teacher and homeroom information imported to speed the set process?
ClassroomParent provides several upload formats. This make getting your school set up and ready to use a simple as filling out a few spread sheets.
The building blocks on which all other CP data stands are the homerooms. In CP, these are referred to as Classrooms. With the teachers_classrooms.xls import format, you can provide a single file that sets up your school’s grades, homerooms, and initial set of teachers (you can always add additional teachers, grades, homerooms separately).
There are two tabs in the spreadsheet. The first, called teachers_classrooms is a sample of what a completed teachers_classrooms import file looks like. You can use this to start your import file by deleting all but the first row.
The second tab, called Column Descriptions lists what each column in the import format means, and whether or not it is a required format. The information in that tab is also listed below:
|year||The school year to apply the record to. The format is YYYY-YYYY, eg 2008-2009||Yes|
|class_code||The identifier for the classroom/homeroom. This identifier is used on the student import file to place the student in a particular homeroom/classroom||Yes|
|teacher_role||A text description of the role the teacher will play. In most cases this will be “Teacher” but could be “Assistant Teacher”, “Substitute Teacher” etc||No – Teachers can be assigned to a homeroom/classroom after it has been created|
|salutation||Teacher’s salutation (Ms., Mr., Mrs., Dr. etc)||No – Teachers can be assigned to a homeroom/classroom after it has been created|
|full_name||The full name of the teacher (i.e Janet Smith, Earl Jones, etc)||No – Teachers can be assigned to a homeroom/classroom after it has been created|
|grade||The name of the grade associated with the home/room. All classrooms in the same grade must use the same grade name. The grade name is used to create a grade, if a grade with the same name doesn’t exist, or look up the grade if one with the same name already exists.||Yes|
|class_room||The room number or other descriptive text that is associated with the classroom/homeroom||Yes|
|street_address||Teacher street address||No – Teachers are not required to have addresses|
|street_address2||Teacher’s street address 2||No – Teachers are not required to have addresses|
|city||Teacher’s city||No – Teachers are not required to have addresses|
|state||Teacher’s state||No – Teachers are not required to have addresses|
|postalcode||Teacher’s zipcode||No – Teachers are not required to have addresses|
|home_phone||Teacher’s home phone number||No – Teachers are not required to have phone numbers|
|work_phone||Teacher’s work phone number||No – Teachers are not required to have phone numbers|
|cell_phone||Teacher’s cell phone number||No – Teachers are not required to have phone numbers|
|Teacher’s email address||No – If the teacher name is included, it is suggested that the teacher email address also be included so the teacher can be included in class/grade emails and can log into Classroom parent to send their own messages|
Categories: teachers, classrooms, getting started, imports
Return to all help subjects