HOW TO WEIGHT GRADES IN IGPRO

 

THE WAY YOU WEIGHT GRADES IN IGPRO DEPENDS ON HOW YOU SETUP YOUR SPREADSHEET. (See How to Create a New Spreadsheet in IGPro  ) THE SPREADSHEET CAN BE A “WEIGHTED TYPE” SPREADSHEET OR A “TOTAL POINTS” SPREADSHEET.  BELOW IS A DESCRIPTION OF EACH.

 

WEIGHTED TYPE - EVERY GRADE YOU WILL ENTER WILL HAVE TO BE A PERCENTAGE OUT OF 100.  THE QUARTER’S FINAL GRADE WILL BE A PERCENTAGE GRADE OUT OF 100.  THE PROGRAM WILL ALWAYS REPORT THE CURRENT QUARTER GRADE AVERAGE AS A NUMBER BETWEEN 0 AND 100.  YOU CAN CATEGORIZE GRADES AS QUIZZES, TESTS, HOMEWORK, OR WHATEVER YOU CHOOSE AND “WEIGHT” EACH CATEGORY DIFFERENTLY SO THAT TESTS COUNT MORE THAN QUIZZES, AND SO ON.  SEE “WEIGHTING GRADES” TUTORIAL FOR DOING THAT.

 

TOTAL POINTS – HERE YOU WILL DECIDE HOW MANY POINTS EACH GRADED ASSIGNMENT SHOULD HAVE WHEN YOU CREATE THE ASSIGNMENT.  FOR EXAMPLE, YOU MAY MAKE A TEST WORTH 23 POINTS.  A PERFECT SCORE ON THAT TEST WOULD HAVE A GRADE OF 23.  THE PROGRAM WILL REPORT THE CURRENT QUARTER GRADE BOTH AS A TOTAL NUMBER OF POINTS EARNED FROM ALL ASSIGNMENTS AND IT WILL ALSO CONVERT IT TO THE CONVENTIONAL PERCENTAGE TYPE GRADE AVERAGE FOR YOU.  PLEASE READ THE “WEIGHTING GRADES” TUTORIAL TO SEE HOW TO SET UP THE NUMBER OF POINTS FOR EACH ASSIGNMENT.

 

AFTER DECIDING WHICH METHOD OF GRADING YOU’LL USE GO TO THE APPROPRIATE INSTRUCTIONS BELOW. CAUTION: ONLY USE A WEIGHTED TYPE SPREADSHEET FOR THE WEIGHTED TYPE WEIGHTING METHOD AND ONLY USE A TOTAL POINT SPREADSHEET FOR THE TOTAL POINTS WEIGHTING METHOD. IF YOU MIS-MATCH THEM YOU'LL GET INCORRECT GRADE AVERAGES THAT ARE CLOSE ENOUGH TO LOOK CORRECT AT A GLANCE.

 

WEIGHTING GRADES FOR WEIGHTED TYPE SPREADSHEETS

 

HOW IT WORKS

 SINCE ALL GRADES ARE ENTERED AS PERCENTAGES OUT OF 100% THE WEIGHTING IS DONE BY CATEGORIZING THE GRADES INTO “TYPES”.  FOR EXAMPLE SOME “TYPES” MIGHT BE QUIZZES, TESTS, EXAMS AND CLASSWORK.  EACH “TYPE” CAN BE A CERTAIN PERCENTAGE OF THE TOTAL GRADE.  FOR EXAMPLE, QUIZZES COULD BE 20%, TESTS 30%, CLASSWORK 30% AND EXAMS 20%.  (NOTE THAT THEY ADD UP TO 100%)

 

IN THIS EXAMPLE, IGPRO WILL TAKE THE AVERAGE OF ALL QUIZ GRADES FOR A STUDENT AND MAKE THAT 20% OF THE FINAL GRADE.  LIKEWISE IT WILL TAKE THE AVERAGE OF ALL TEST GRADES FOR A STUDENT AND MAKE THAT 30% OF THE FINAL GRADE…AND SO ON.  HERE’S A CHART TO ILLUSTRATE HOW THE MATH IS DONE WITH A SIMPLE EXAMPLE.

 

 

 

TYPE

GRADES

AVERAGE

MULT. BY FACTOR

 

QUIZZES

100, 90, 80

90

90 X .2 =

18% OUT OF 20%

TESTS

90, 80, 70

80

80 X .3 =

24% OUT OF 30%

CLASSWORK

70, 70, 90, 90

80

80 X .3 =

24% OUT OF 30%

EXAMS

70

70

70 X .2 =

14% OUT OF 20%

QUARTER GRADE

 

ADD ABOVE:

80% OUT OF 100%

 

 

HOW TO SET IT UP

1.  OPEN IGPRO GRADEBOOK, CLICK ON TOP TOOLBAR, CLICK “SETUP”, CLICK “GRADING RULES” AND CLICK ON THE “TYPE SETS” TAB.  YOU WILL SEE ARBITRARY “TYPES” AND  “SETS” ALREADY LOADED.  YOU PROBABLY WON’T WANT THESE.  YOU CAN DELETE THEM AND ADD THE ONES YOU WANT.  “TYPES” ARE CATEGORIES LIKE QUIZZES AND TESTS AND “SETS” ARE CLASSES.  YOU CAN HAVE DIFFENTLY WEIGHTED TYPES FOR EACH CLASS.  FOR A TYPE YOU DON’T WANT IN A GIVEN CLASS JUST WEIGHT IT TO ZERO.  I WOULD SUGGEST ALL TYPES ADD UP TO 100 FOR EACH SET TO KEEP IT SIMPLE.   WHEN YOU ARE DONE, CLICK CLOSE AND THOSE SETTINGS ARE SAVED.

 

2.  CLICK ON TOP TOOLBAR, CLICK “SETUP”, CLICK “GRADING RULES” AND CLICK ON THE “GRADE TABLES” TAB.  ON THE LEFT WINDOW MAKE SURE “REGULAR” IS HIGH LIGHTED.  ON THE RIGHT MAKE SURE YOU HAVE THE GRADES A, B, C, D, AND F WITH CORRESPONDING LOWER LIMITS AS 90, 80, 70, 60, AND 0.  YOU CAN SET THE NUMBER OF DECIMAL PLACES DISPLAYED FOR A GRADE AVERAGE IN THE LOWER RIGHT IF YOU LIKE.  WHEN YOU CLICK “CLOSE” SETTINGS ARE SAVED.

 

3.  FINALLY, THE ACTUAL WEIGHTING IS CALCULATED BY THE WAY YOU CREATE A NEW TASK.  A NEW TASK IS A NEW GRADED ASSIGNMENT IN A CLASS’S SPREADSHEET.  CHOOSE THE CLASS YOU WANT AND THE SPREADSHEET WITHIN THAT CLASS THAT YOU WANT.  THEN CLICK “TASKS” ON THE TOP TOOLBAR, AND THEN “NEW TASK”.  CLICK NEXT.  NAME THE TASK, YOU CAN PUT IN ASSIGNED AND DUE DATES OR NOT.  (YOU CAN ADD DATES LATER BY CLICKING EDIT TASKS)  UNDER TYPE, PULL DOWN AND CLICK THE TYPE OF TASK IT IS.  NOW, HERE IS THE PART THAT ACTUALLY WIEGHTS IT…  IN THE BOX, “OUT OF RAW” PUT 100 EVERY TIME.  IN THE BOX, “SCALE FACTOR” BUT .2 IF IT COUNTS AS 20% OF THE GRADE, OR .3 FOR 30%, OR .05 FOR 5%, AND SO ON.  THEN, CLICK ON THE BOX “OUT OF SCALED” AND IT WILL DO THE MATH.  (IE… IF YOU HAVE 100 FOR “OUT OF RAW” AND .2 FOR “SCALE FACTOR” A 20 WILL APPEAR IN THE “OUT OF SCALED” BOX.  CLICK “CLOSE” TO SAVE SETTINGS.

 

----------------------------------------------------------------------------------------------------

 

WEIGHTING GRADES FOR TOTAL POINT SPREADSHEETS

 

 

HOW IT WORKS

YOU SPECIFY THE TOTAL NUMBER OF POINTS EACH ASSIGNMENT IS WORTH WHEN YOU CREATE THE ASSIGNMENT (CALLED A TASK IN IGPRO).  YOU ENTER THE ACTUAL NUMBER OF POINTS EACH STUDENT EARNED OUT OF THE TOTAL OF  EACH ASSIGNMENT.  IGPRO KEEPS TRACK OF THE TOTAL NUMBER OF POINTS EARNED AND THE TOTAL NUMBER OF POINTS POSSIBLE AND DIVIDES THE TWO TO GET THE CURRENT PERCENTAGE GRADE.  HERE’S A CHART TO ILLUSTRATE THE MATH WITH SIMPLE NUMBERS…

 

TYPE

GRADES

TOTALS

GRAND TOTAL / GRADE

QUIZZES

15 OUT OF 20 PTS

7 OUT OF 10 PTS

12 OUT OF 15 PTS

34 OUT OF 45 PTS

 

TESTS

20 OUT OF 30 PTS

25 OUT OF 30 PTS

45 OUT OF 60 PTS

CLASSWORK

15 OUT OF 20 PTS

7 OUT OF 10 PTS

12 OUT OF 15 PTS

34 OUT OF 45 PTS

EXAMS

40 OUT OF 50 PTS

40 OUT OF 50 PTS

FINAL QUARTER GRADE

 

153 OUT OF 200 PTS OR 76.5%

 

 

 

 

HOW TO SET IT UP

1.  OPEN IGPRO GRADEBOOK, CLICK ON TOP TOOLBAR, CLICK “SETUP”, CLICK “GRADING RULES” AND CLICK ON THE “TYPE SETS” TAB.  YOU WILL SEE ARBITRARY “TYPES” AND  “SETS” ALREADY LOADED.  YOU PROBABLY WON’T WANT THESE.  YOU CAN DELETE THEM AND ADD THE ONES YOU WANT.  “TYPES” ARE CATEGORIES LIKE QUIZZES AND TESTS AND “SETS” ARE CLASSES.  FOR TOTAL POINTS CALCULATIONS I WOULD SUGGEST LISTING ALL YOUR TYPES AND SETTING THEM TO THE SAME WEIGHT SUCH THAT IT ADDS UP TO 100 FOR EACH SET.  FOR EXAMPLE…IF YOU HAVE FOUR TYPES IN A CLASS, MAKE THEM ALL WORTH 25.  YOU WILL SET THE ACTUAL NUMBER OF POINTS FOR AN ASSIGNMENT LATER BUT THIS WILL GUARENTEE THAT THEY WON’T BE WEIGHTED DIFFERENT THAN THE POINTS YOU SET THEM FOR.  FOR A TYPE YOU DON’T WANT IN A GIVEN CLASS JUST WEIGHT IT TO ZERO.  AGAIN, I WOULD SUGGEST ALL TYPES ADD UP TO 100 FOR EACH SET TO KEEP IT SIMPLE.   WHEN YOU ARE DONE, CLICK CLOSE AND THOSE SETTINGS ARE SAVED.

 

2.  CLICK ON TOP TOOLBAR, CLICK “SETUP”, CLICK “GRADING RULES” AND CLICK ON THE “GRADE TABLES” TAB.  ON THE LEFT WINDOW MAKE SURE “REGULAR” IS HIGH LIGHTED.  ON THE RIGHT MAKE SURE YOU HAVE THE GRADES A, B, C, D, AND F WITH CORRESPONDING LOWER LIMITS AS 90, 80, 70, 60, AND 0.  YOU CAN SET THE NUMBER OF DECIMAL PLACES DISPLAYED FOR A GRADE AVERAGE IN THE LOWER RIGHT IF YOU LIKE.  WHEN YOU CLICK “CLOSE” SETTINGS ARE SAVED.

 

3.  FINALLY, THE ACTUAL WEIGHTING IS CALCULATED BY THE WAY YOU CREATE A NEW TASK.  A NEW TASK IS A NEW GRADED ASSIGNMENT IN A CLASS’S SPREADSHEET.  CHOOSE THE CLASS YOU WANT AND THE SPREADSHEET WITHIN THAT CLASS THAT YOU WANT.  THEN CLICK “TASKS” ON THE TOP TOOLBAR, AND THEN “NEW TASK”.  CLICK NEXT.  NAME THE TASK, YOU CAN PUT IN ASSIGNED AND DUE DATES OR NOT.  (YOU CAN ADD DATES LATER BY CLICKING EDIT TASKS)  UNDER TYPE, PULL DOWN AND CLICK THE TYPE OF TASK IT IS.  NOW, HERE IS THE PART THAT ACTUALLY WIEGHTS IT…  IN THE BOX, “OUT OF RAW” PUT THE TOTAL NUMBER OF POINTS YOU WANT THAT ASSIGNMENT TO COUNT.  IN THE BOX, “SCALE FACTOR” ALWAYS PUT A 1.0.  THEN, CLICK ON THE BOX “OUT OF SCALED” AND IT WILL DO THE MATH.  (IE… IF YOU HAVE 25 FOR “OUT OF RAW” AND 1.0 FOR “SCALE FACTOR” A 25 WILL APPEAR IN THE “OUT OF SCALED” BOX.  CLICK “CLOSE” TO SAVE SETTINGS.