How do I bulk override many course grades?

Perhaps you school has instituted a minimum grade policy toward the end of a grading period, and you want to make sure that any course grades under that minimum are raised to meet it. Or, for some other reason, you need to adjust many course grades. You can use a spreadsheet import to set overrides en masse within Schoolrunner.

If you only need to set (or remove) a handful of course grade overrides, it's easier to do it this way.

Once an override is set, no changes to assessment scores – new or old – will affect the student's course grade. Nothing will change the override until you remove it.

To set course grade overrides in bulk, the steps are:

1. Download the "Report Card Grades" .csv export from the Export page (Setup>Export). Each row represents one student's grade in one course for one grading period. 
2. Delete all rows (except for the header row) that will NOT be getting an override. Your file should only have rows for students who will receive an override. Do not leave rows that aren't supposed to have a course grade override.
3. In the remaining rows, change the value in column J ("Percent") to the override value. Do not change anything else.
4. Save the .csv and drop it into the /import page of your Schoolrunner site. You'll have to manually type this into your web browser's address bar. 
5. Wait for Schoolrunner to process your information and then confirm the changes.
6. Recalculate grades manually.

Overrides are now set!

If you need to remove overrides in bulk, follow these steps:

1. Download the "Report Card Grades" .csv export from the Export page (Setup>Export).
2. Delete all rows (except for the header row) that should NOT have an override removed. Your file should only have rows for students whose overrides are being removed. Do not leave rows that are supposed to have a course grade override.
3. In the remaining rows, delete ALL values in column J ("Percent"). Do not change anything else.
4. Save the .csv and drop it into the /import page of your Schoolrunner site. You'll have to manually type this into your web browser's address bar. 
5. Wait for Schoolrunner to process your information and then confirm the changes.
6. Recalculate grades manually.

A few notes on this process:

1. It's best to do this in your sandbox site first, to make sure things work as you expect. Contact [e-mail] to ensure your sandbox data is up to date.
2. You can only set overrides for course grades that already exist. If a student has no course grade to start with, you cannot set an override for him or her. Give him/her a score on at least one assessment so that Schoolrunner can generate a course grade.
3. It is possible to set overrides for grades in a locked term bin.
4. When you upload the .csv into the /import page, overrides will be set for every row included in your .csv, even if you left some student data as is, with no changes at all. This is why it's important to delete all rows (don't just hide or filter them!) that shouldn't be modified.