** This is for the Assessment Solution. You will not have this option if you are a free user.
IMPORTANT NOTE: you will need to include the word Classlist in the name of the CSV file when you upload it. We highly recommend uploading all four CSVs at once when you initially upload data into Chalk to ease the teacher experience. Click here for information on how to save your file as a CSV.
The Classlist CSV will create the classes in your school year and assign teachers to them. There are also additional features such as Terms, Grading Scales and Reporting Classes you can add to each individual class. It is important to note that if you haven't uploaded the Teacher CSV first then the Classlist CSV will not work.
In the Classlist CSV file there are nine different fields:
- Three of these fields are Required Fields which must be included in the Classlist CSV
- Six of these fields are Optional Fields which you don't have to include
- ClassID: A unique number or code to identify each individual section that will be taught. This will only be displayed to administrators and teachers will not see this information.
- ClassName: The name/title of each class as you want it to appear in your teachers' accounts.
- TeacherID: A unique number or code to identify each individual teacher. This will be the same TeacherID you assigned in your Teacher CSV.
If you don't want to use an optional field please make sure not to include the column header at all
- SubjectID: In most cases you will not use this field. This field will group similar classes together so they are two Sections of the same Subject rather than two separate Subjects. This only applies when it's the same teacher teaching both classes (ex: Two different Grade 9 Math Classes taught by the same teacher). Learn more about the difference between Subjects and Sections here. To use SubjectID you will want to put the same value across multiple rows to group those rows together.
- ReportingClass: This is a True or False value and helps when printing student reports as an administrator for the whole school. It works similarly to Grade Level which is found on the Student CSV. Instead of grouping by Grade Level you can group by Reporting Class which groups student reports by all classes that have a ‘True’ value here. True means that you do want a report printed, while False or leaving this blank means that it will not print reports. Learn more about progress reports here.
- TermID: This is the ID that you gave your terms when setting them up for your Marking Periods. Learn more about where to find your TermID here. This is an optional column if you do not have Terms set up.
- GradingScaleID: This field will let you assign a specific Grading Scale to a specific class. If this isn't set (i.e. you don't include this column in your CSV or leave the value blank for a given class) then the Grading Scale will automatically be set to the default Grading Scale for the school. Learn more about Grading Scales here.
- isArchived: Set this to TRUE if you need to archive a class from the entire school. Leaving this blank or setting it to FALSE will not have any impact on that class. Archiving a class will hide it's information from all student, guardian and teacher accounts. This applies to all students enrolled in the class as well as the teacher managing the class. Archiving can be undone from the Admin panel. Learn more about Archiving here.
- isDeleted: Set this to TRUE if you would like to delete a class from an entire school. Leaving this blank or setting it to FALSE will not have any impact on that class. Deleting completely removes this class from all student, guardian and teacher accounts. Once a class is deleted this cannot be undone.
We highly recommend using isArchived and not isDeleted for most circumstances to ensure you can recover information for a class if you ever need it in the future.
Your Classlist CSV file should look similar to the image below:
Click here to download a Sample Classlist CSV.
Visit these articles on how to create the other three CSVs for your school: