| Import Classes |
|
Admins can import courses, sections, and student schedules for the whole school or district. See Import Data for general data format requirements.
This section describes the columns accepted to import class data: School/Building Code — This code should match whatever you enter on the screen. If you haven't entered those codes yet, it will ask which code matches which school and save those codes during the import. You must have permission at each school. This column is optional; if omitted it assumes the school you currently have selected in the tab-bar. Teacher — The name or district code for the teacher. If it's a code, it should match the code on the screen. If you haven't entered or imported those codes yet, it will ask which code matches which teacher and save those codes during the import. The teachers must already exist in the database. For new teachers you must Import Staff before you import classes. If a class is team-taught by two or more teachers, you can import it for just one of the teachers, or you can import redundant copies of the class for each teacher. Either way, you must manually correct the schedule after you import the data. See Team Teaching for detailed instructions. Subject/Course Title — The name of the course or subject, like "World History" or "Reading" (elementary schools require subjects to be specified). The limit is 50 characters, so they can be complete titles instead of abbreviations. Period — The period/hour of the day. This must match the periods you have defined on the screen. If a section has multiple periods, like block periods, the periods must be comma-delimited, like "3,4". Period is optional and may not apply for elementary or college. Course Code — The course number, like "BIO-101". This is optional. Section Code — The section number, like "002". Do not include the Course Code in the same column. This is optional. Credits/Units — How many credits the course is worth for GPA calculations and graduation requirements. If not specified it defaults to 1. Room — Room number (12 characters max) Student ID — To identify which student is in which class.
You can import courses, sections, and student schedules in a single file, like below. Notice each row represents one student (ID) in one class. (The order doesn't matter.) ID Course Sect Subject Per Teacher 9024 MATH-3 001 Algebra 1 G.Breyer 9024 PE-B9 002 PE 2 R.Smithers 9024 SCI-B 003 Biology 3 M.Graham 9711 SOC-10 001 US History 1 L.Bauers 9711 ART-1 002 Art I 2 D.Raney 9711 SCI-B 003 Biology 3 M.Graham ...Or you can import just a course list separately, like this: Course Subject Credits MATH-1 Geometry 4 MATH-2 Pre-Algebra 4 MATH-3 Algebra 4 ...Then the sections separately: Course Sect Per Teacher MATH-2 001 1 G.Breyer MATH-3 002 2 G.Breyer MATH-3 003 3 G.Breyer MATH-1 001 1 S.Riley MATH-1 002 2 S.Riley ...Then the student schedules: ID Course Sect 9024 MATH-3 001 9024 PE-B9 002 9024 SCI-B 003 9711 SOC-10 001 9711 ART-1 002 9711 SCI-B 003 ...Notice for elementary school you must import each subject for each teacher: Teacher Subject Course G.Breyer Reading RE-3 G.Breyer Language Arts LA-3 G.Breyer Math MA-3 G.Breyer Social Studies SS-3 G.Breyer Science SC-3 D.Raney Reading RE-4 D.Raney Language Arts LA-4 ...It is also possible to import student data along with class data in the same file. Notice the student data is repeated for each class: ID Last First Phone Course Subject Per Teacher 9024 Doe John 736-1417 MATH-3 Algebra 1 Breyer 9024 Doe John 736-1417 PE-B9 PE 2 Smith 9024 Doe John 736-1417 SCI-B Biology 3 Graham 9711 Ladd Laura 735-2901 SOC-10 History 1 Bauers 9711 Ladd Laura 735-2901 ART-1 Art I 2 Raney 9711 Ladd Laura 735-2901 SCI-B Biology 3 Graham ...Download a sample file for testing. When Done Courses are imported into the database immediately. Go to the screen to view, edit, or delete them. Sections & Schedules are not imported immediately. Instead they go into a Draft Schedule on the screen so you can review them and make manual corrections. Then you must click the Draft button to Publish the schedule to teachers' gradebooks.
Student data is imported immediately into the database, so any new students or changes to contact information are available immediately to everyone. It is okay to re-import data. This does not create duplicate courses, sections, or students. If a Course already exists in the database, it does not change it. You must make changes manually on the screen. Importing Sections & Schedules always creates a new Draft Schedule. You must make changes manually on the screen, or click the Drafts button to Delete the draft and re-import. Be sure to Delete any old drafts before your re-import to avoid confusion.
If a Student already exists in the database, it will merge their contact information, etc., but their scheduling information is in the Draft Schedule. See Import Students. If you accidentally import bad data, you must go to different places to delete it: Sections are on the screen as a Draft. Click the Draft button to delete it. If you had already published the draft, select any class and click "Delete Section" to Purge all unused sections. Courses are on the screen. Click any course then click Delete to Purge all unused courses. (Do this after you delete the Draft Schedule, if any). Students are on the screen. Click the "Delete/Withdraw" button to Purge any new students not yet scheduled in any classes (after you delete the Draft Schedule, if any).
For training, it's recommended to import only small sets of data so you can easily undo mistakes, then add more classes and more fields as you get more experienced. |
