Instructions for editing the SchoolDesk Grades xlsx files

What you should NOT do:

1. Grades for first half of the session go into "Term 1", for the second term in "Term 2", and so on. Do not change the order of Sheets within the excel file.
2. Do not edit the content in the blue coloured area.
3. Do not merge or move the position of the cells and columns.
4. If you need to edit the student name, student number, or roll number — please ask the admins to change it in SchoolDesk and download a fresh excel copy. (The grades import system does a strict match on student names. This will fail if you change the values. Strict matching is necessary so that one student's marks don't get updated for another student.)
5. If you need to correct a subject name/marks split, then please ask the admins to do the change in SchoolDesk. Don’t change "GK" to "G.K." etc.
6. Totals and percentages are automatically calculated using excel formulae and are highlighted in blue — don't change these values.

What you can do:

1. You can Add/edit the students grades related data in the white/light grey columns
2. You may change the width of the columns in the excel file.
3. If you've already prepared an xlsx file which fails the upload to SchoolDesk, the fastest way to fix the issue would be to download a fresh xlsx and paste the data part into the new file.
4. Request a fresh xlsx file from the admins at anytime instead of trying to fix an old file.

Excel Basics:

1. Please save your files in th .xlsx format. The .xls file format is outdated.
2. An excel file can have multiple sheets inside a single file. (Each sheet is used to record grades of one term for a single classroom in SchoolDesk.)
3. The vertical series of cells is called a 'column'.
4. The horizontal series of cells is called a 'row'.