IGPro Training

Session III

FINAL GRADE SUMMARY

(SETTING UP TO ENTER MID YEAR/ FINAL AVERAGES)

Allyson Tempest & Jesse Lubinsky

In order for IGPro to calculate averages for multiple grading periods you must set up another Spreadsheet called “Final Grade Summary.” Below are the steps to take in order to complete this and copy each respective quarters’ grades to the sheet. Please Hot Link your Quarter 4 grades to the “Q4 End Term” spreadsheet before you begin. Do NOT Export “Q4 End Term” spreadsheet until you have completed your final grades.

I. CREATE NEW TYPE: “QUARTERS”

• Open your gradebook

• From your first class select Setup, Grading Rules, & Type Sets

• You must enter 1 new type titled “Quarters”

• FOR EACH CLASS you must type 100 for the Quarters Type (this means Quarters are 100% of the final grade)

II. CREATE “FINAL GRADE SUMMARY” SPREADSHEETS

• Click Setup, Spreadsheets

• Click New, Create A Numeric Spreadsheet and name it “Final Grade Summary”

• Select Weighted Type because each quarter is weighted at 25% of the final grade for the total of 100%

• You must create a “Final Grade Summary” spreadsheet for each of your classes

III. COPY FINAL QUARTER GRADES INTO “FINAL GRADE SUMMARY” SPREADSHEET

• Select the first class you want to work with

• Select Final Grade Summary spreadsheet

• Click Tasks, Copy Tasks and select Quarter 1 (Numeric) spreadsheet

• Click Quarter 1 Spreadsheet Grade

• Click Raw Score (so the average is calculated)

• Click Tasks, Edit Tasks and change the long name to simply “Quarter 1”

• Click on the Points tab

• In the Type field you must select Quarters.

• Check that the Point Values equal 100 x 1.0= 100

*** BE ABSOLUTELY SURE the task window on this screen shows “Quarters” and not one of your classroom types!

YOU MUST DO THIS FOR ALL 4 QUARTERS!

YOU MUST DO THIS FOR ALL CLASSES!

IV. HOT LINK FINAL GRADES TO “Q4 End Term”SPREADSHEET

• Return to the first class

• Select Q4 End Term spreadsheet

• Right click on the gray bucket titled Fnl Mk Grade

• Select Replace Task...

• Click Final Grade Summary (Numeric Weighted Type) and click Next

• Select Final Grade Summary Spreadsheet Grade and click Next

• Click Letter Grade and click Next

• Click box for Hot Link Grades

***If you had changed any of the Q__ End Term spreadsheet quarter grades manually during any of the 4 quarters, these overrides are not reflected in the grades being copied into the Final Grade Summary spreadsheet. Q__ End Term spreadsheets are where you made the manual changes, however, the final grades are calculated numerically from the Quarter 1 (Numeric), Quarter 2 (Numeric), Quarter 3 (Numeric), and Quarter 4 (Numeric) spreadsheets. Numeric grades you see on the Final Grade Summary spreadsheets may not represent letter grades you gave students on report cards. You may want to adjust the final letter grade in the Fnl Mk Grade bucket. You will break the Hot Link but that is OK! It is simply a manual override.

V. SAVE AND PRINT

• Remember to save. You only need to save once since it will save the entire gradebook

• Print your Q4 End Term and Final Grade Summary spreadsheets for each class

VI. EXPORT QUARTER GRADES TO SASI

You are exporting all classes. You only have to export once since it automatically includes every class in your gradebook.

• Click File

• Click Export from Gradebook

• Click 6/17/2006: Q4

• 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