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.
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
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!
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.
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
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