HOW TO CREATE A NEW SPREADSHEET FOR A NEW QUARTER IN IGPRO

(you’ll need to choose whether you will use the Total Points method of grading or Weighted Type - percentages method as described in step 8)

1.  OPEN IGPRO ON YOUR TEACHER COMPUTER BY DOUBLE CLICKING ON THE IGPRO ICON ON YOUR DESKTOP.  (IF NO SUCH ICON EXISTS YOU’LL NEED TO HAVE DAVE CREATE IT- 492-4359)

2.  DOT THE RADIO BUTTON “OPEN A GRADEBOOK ON YOUR COMPUTER” AND CLICK “OK”.

3.  A WINDOW COMES UP WITH  A FILE NAMED  “yourlastname0X.gbf” WHERE “0X” IS THE YEAR THAT THE SCHOOL YEAR STARTS.  DOUBLE CLICK ON THAT FILENAME.  (IF YOU DON’T SEE THIS FILENAME IT HASN’T BEEN CREATED YET AND YOU NEED TO CALL DAVE AT 492-4359)

4.  TYPE IN YOUR PASSWORD.  THIS SHOULD BE THE SAME PASSWORD THAT YOU USE TO LOG ON TO THE NETWORK.  IF YOU CHANGED YOUR LOG-ON PASSWORD, IT WILL BE THE SAME PASSWORD YOU HAD AT THE BEGINNING OF THE SCHOOL YEAR AS IT WILL NOT HAVE CHANGED FOR IGPRO.  YOUR GRADEBOOK WILL NOW OPEN.

5.  CHOOSE THE CLASS YOU WISH TO CREATE A NEW SPREADSHEET FOR BY PULLING DOWN THE “CLASS” PULL-DOWN MENU AND CLICKING ON THE CLASS YOU WANT.

6.  ON THE TOP TOOLBAR, CLICK “SETUP”, THEN CLICK “SPREADSHEETS” AND THEN, ON THE NEW WINDOW CLICK THE “NEW” BUTTON.  ALWAYS DOT THE “NUMERIC SPREADSHEET” RADIO BUTTON WHETHER YOU WANT TO GRADE BY PERCENTAGES OR BY TOTAL POINTS.  CLICK NEXT.

7.  NAME THE SPREADSHEET…QTR1 OR SOMETHING.  I WOULD SUGGEST YOU DON’T MAKE A SPREADSHEET FOR THE WHOLE SEMESTER, JUST FOR A QUARTER.  CLICK NEXT.

8.  HERE IS WHERE YOU MUST CHOOSE WHETHER YOU WILL HAVE THE IGPRO CALCULATE THE QUARTER GRADE BY “WEIGHTED TYPE” AVERAGING PERCENTAGE GRADES OR BY AVERAGING INDIVIDUALLY WEIGHTED “TOTAL POINTS” GRADES.

LET ME CLARIFY…

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 How to Weight 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 How to Weight Grades TUTORIAL TO SEE HOW TO SET UP THE NUMBER OF POINTS FOR EACH ASSIGNMENT.

SO, NOW, HAVING MADE YOUR CHOICE WHETHER YOU WANT TO USE THE “TOTAL POINTS” METHOD OR THE “WEIGHTED TYPE” SYSTEM, DOT THE APPROPRIATE RADIO BUTTON ON THIS WINDOW AND CLICK “CREATE” AND THEN “CLOSE”