Exporting Quarter Grades and Comments to SASI

Allyson Tempest & Jesse Lubinsky

1. Select appropriate spreadsheet

· In the Class view, select your first class you teach

· In the Spreadsheet viewer, select Q2 (End Term…)

1. Sort student names in each class:

   • Right click on the gray toolbar by Student Name

   • Click Sort Students

   • Check By Student Name

   • Click Sort

   • Click Close

   • DO THIS FOR EVERY CLASS!

3. Enter Letter Grades

· In the first column, Q2 MK Grade, click on the first cell for the first student listed

· Type the letter grade the student earned for Quarter 2

· Continue to enter quarter gardes for each student

· Use the down arrow or mouse to move down the column

**DISREGARD THE NEXT TWO COLUMNS TITLED Q2 MK Yr Att and

Q2 MK Yr Td

4. Add Comments

· For each student, click the cell and enter the number of the comment you wish to give

· You may also click the cell you wish to enter a comment in and choose the comments from the drop down menu in the Comments field

· To fill a column with one comment (same for each student), right click on

Q2 MK Comment # and choose Fill Column …

· In the New Score field type the comment number you wish to use

· Click Fill

7. Export Progress Report Comments to SASI

* You are exporting all classes. DO NOT DO THIS UNTIL YOU ARE COMPLETELY FINISHED ENTERING “Quarter Grades and COMMENTS FOR ALL CLASSES!

· Click File

· Click Export from Gradebook

· Click 1/24/2007: Q2

· Click Next

· A WARNING box will appear. Check Continue with the export anyway

· Click Next

· Click Export

· Click No if an error box appears click