HOW TO DO SEMESTER GRADES IN IGPRO

STEP BY STEP INSTRUCTIONS THAT MUST BE DONE FOR EACH CLASS.

NOTE THAT ALTHOUGH THIS LIST OF STEPS IS HORRIBLY LONG IT’S ONLY BECAUSE IT’S SO DETAILED.

 

1.  CREATE A NEW SPREADSHEET TO CALCULATE SEM GRADE.

 

A.  CLICK ‘SETUP’ ON TOP TOOLBAR, ‘SPREADSHEETS’, ‘NEW’ BUTTON

 

            B.  DOT ‘CREATE A NUMERIC SPREADSHEET’, CLICK NEXT

 

            C.  NAME IT ‘SEM 1’ OR SOMETHING, CLICK NEXT

 

            D.  DOT ‘WEIGHTED TYPE’, CLICK ‘CREATE’ AND ‘CLOSE’ BUTTON.

 

2.  CREATE TASKS ON NEW SPREADSHEET

 

A..  UNDER ‘CLASS’ LINE AT TOP, IN ‘SPREADSHEET’ LINE PULL DOWN MENU AND CLICK ON THE NEW SPREADSHEET ‘SEM 1’

 

B.  ON TOP TOOLBAR CLICK ‘TASKS’ AND THEN ‘NEW’.  NAME TASK ‘Q1’ OR SOMETHING FOR QUARTER 1.

 

C.  IN ‘OUT OF RAW’ BOX MAKE SURE ‘100’ IS THERE.  IN SCALE FACTOR TYPE IN ‘.45’ (NOTE DECIMAL POINT) AND CLICK ON ‘OUT OF SCALED’ BOX SO IT PUTS IN THE CORRECT ANSWER – ‘45’.  IGNORE ALL OTHER BOXES.  CLICK ‘CREATE’

 

D.  REPEAT THE ABOVE STEP BUT NAME THIS TASK ‘Q2’.

 

E.  REPEAT THE CREATION OF A NEW TASK A THIRD TIME BUT NAME IT ‘EXAM’ AND MAKE THE ‘SCALE FACTOR’ BOX HAVE A ‘.1’ (NOTE DECIMAL POINT) IN IT INSTEAD OF THE ‘.45’.  THE ‘OUT OF SCALED’ BOX SHOULD SAY ‘10’ WHEN YOU CLICK ON IT TO UPDATE THE CALCULATION. 

 

3. AUTO - POPULATE THESE NEW TASK COLUMNS ON YOUR NEW SEM 1 SPREADSHEET

 

A.  RIGHT CLICK ON THE VERY TOP OF THE TASK COLUMN FOR Q1, WHERE IT SAYS ‘Q1’ AND CLICK ‘REPLACE TASK’

 

B.  IN THE ‘REPLACE TASK’ WINDOW CHECK TO MAKE SURE YOU’RE IN THE RIGHT CLASS AT THE TOP AND BELOW IS A LIST OF ALL THE SPREADSHEETS YOU HAVE IN THAT CLASS.  CLICK TO HIGHLIGHT THE ONE FROM FIRST QUARTER WHICH WAS NAMED FOR YOU…’WEIGHTED TYPE [NUMERIC WEIGHTED TYPE]   THIS SHOULD BE YOUR 1ST QUARTER GRADE SPREADSHEET WITH ALL THE FIRST QUARTER GRADES ON IT. (NOT ‘FIRST QUARTER ENDTERM 10/21/2004’)  CLICK ‘NEXT’.

 

C.  CLICK TO HIGHLIGHT THE ‘WEIGHTED TYPE SPREADSHEET GRADE’ WHICH IS PROBABLY AT THE TOP OF THE LIST. CLICK ‘NEXT’.

 

D.  CLICK ‘RAW SCORE’ TO HIGHLIGHT IT AND CLICK ‘NEXT’.

 

E.  CLICK ‘OK’ AND WATCH THE PERCENTAGE OVERALL 1ST QUARTER GRADES POPULATE THE ‘Q1’ COLUMN.  ALSO NOTICE THAT THE NAME ‘Q1’ HAS BEEN CHANGED.  THIS IS OK.

 

F.  NOW, GO THROUGH THE PERCENTAGE GRADES FOR QUARTER 1 AND CHANGE ANY THAT YOU CHANGED IN YOUR GRADEBOOK.  IN-OTHER-WORDS, YOU MAY HAVE GIVEN A STUDENT WITH A 79% AVERAGE A POINT TO MAKE IT 80% OR RAISED THE PERCENTAGE OF A SPED STUDENT ABOVE THE ACTUAL CALCULATED PERCENTAGE.  YOU NEED TO PUT IN A PERCENTAGE NUMBER FOR ANY KID WHO’S GRADE WAS DIFFERENT THAN THE CALCULATED GRADE.  HOPEFULLY THIS IS JUST A FEW KIDS.

 

G.  REPEAT THIS PROCESS FOR THE ‘Q2’ TASK COLUMN. (STEPS A-F)

 

4.  PUT IN THE EXAM GRADES

 

A.  IN THE ‘EXAM’ TASK COLUMN, MANUALLY TYPE IN EACH STUDENT’S EXAM GRADE AS A PERCENTAGE GRADE.  (IF YOU ALREADY TYPED THIS DATA IN SOMEWHERE ELSE YOU CAN USE THE ‘REPLACE TASK’ PROCEDURE ABOVE TO AVOID TYPING THEM IN AGAIN.  IF A STUDENT WAS EXCUSED FROM THE EXAM THEN TYPE IN THE WORD ‘EXCUSED’.)

 

5.  TRANSFERRING DATA TO THE 2ND QUARTER ENDTERM SPREADSHEET

 

A.  BACK ON THE MAIN IGPRO SCREEN, IN THE SAME CLASS YOU’VE BEEN WORKING ON, PULL DOWN THE ‘SPREADSHEET’ MENU AND SELECT ‘SECOND SEMESTER [ENDTERM 12/16/2004]’ SPREADSHEET.

 

B.  RIGHT CLICK ON THE TOP OF THE TASK COLUMN CALLED ‘2ND Qtr Grade’ AND CLICK ‘REPLACE’

 

C.  CLICK ON ‘SEM 1 [NUMRERIC WEIGHTED TYPE]’ TO HIGHLIGHT IT AND CLICK ‘NEXT’.

 

D.  CLICK ON ‘2ND QUARTER SPREADSHEET GRADE’ (MAY NOT BE EXACTLY THIS NAME BUT IT WILL BE WHATEVER YOU NAMED THE 2ND QUARTER SPREADSHEET BACK WHEN YOU CREATED IT AT THE BEGINNING OF 2ND QUARTER) TO HIGHLIGHT IT AND CLICK ‘NEXT’.

 

E.  CLICK ON ‘LETTER GRADE’ TO HIGHLIGHT IT AND CLICK ‘NEXT’.

 

F.  YOU MAY HAVE TO CLICK ‘OK’ FOR SOME INVALID SCORES OF KIDS WHO WERE NOT REALLY IN YOUR CLASS AND HAVE NO GRADES BUT OTHERWISE THE COLUMN IS POPULATED WITH LETTER GRADES FOR THE SECOND QUARTER.

 

G.  TYPE IN A CONDUCT NUMBER 1 – 4 WHERE 1 IS BEST IN THE CONDUCT COLUMN.

 

H.  IN THE COMMENT COLUMNS, IF YOU RIGHT CLICK ON THE CELL WHERE THE STUDENT’S COMMENT NUMBER GOES A LIST OF ALL POSSIBLE COMMENTS COMES UP AND YOU CAN CLICK ON THE ONE YOU WANT.  PLEASE FILL IN AT LEAST ONE COMMENT.  FOR THE 2ND COMMENT YOU COULD GIVE EVERYONE #4 (ENJOY HAVING IN CLASS) EASILY BY JUST RIGHT CLICKING AT THE TOP OF THE COLUMN AND CLICKING ‘FILL COLUMN’ AND THEN TYPING A 4 IN THE ‘NEW SCORE’ BLANK AND THEN CLICKING THE ‘FILL’ BUTTON. THIS SHORTCUT WORKS NICE ALSO WHEN YOU ARE GIVING JUST ABOUT EVERYONE THE SAME COMMENT BUT A FEW.  THEN JUST GO BACK AND CHANGE THE FEW MANUALLY.

 

I.  WHEN YOUR COMMENTS ARE DONE RIGHT CLICK ON THE TOP OF THE TASK COLUMN CALLED ‘SEM EXAM GRADE’ AND CLICK ‘REPLACE’

 

J.  CLICK ON ‘SEM 1 [NUMRERIC WEIGHTED TYPE]’ TO HIGHLIGHT IT AND CLICK ‘NEXT’.

 

K.  CLICK ON ‘EXAM’  TO HIGHLIGHT IT AND CLICK ‘NEXT’.

 

L.  CLICK ON ‘LETTER GRADE’ TO HIGHLIGHT IT AND CLICK ‘NEXT’.

 

M.  THE COLUMN IS POPULATED WITH LETTER GRADES FOR THE EXAM.

 

N.  RIGHT CLICK ON THE TOP OF THE TASK COLUMN CALLED ‘1st Sem Grade’AND CLICK ‘REPLACE’

 

O.  CLICK ON ‘SEM 1 [NUMRERIC WEIGHTED TYPE]’ TO HIGHLIGHT IT AND CLICK ‘NEXT’.

 

P.  CLICK ON ‘SEM 1 SPREADSHEET GRADE’ (SHOULD BE AT TOP)  TO HIGHLIGHT IT AND CLICK ‘NEXT’.

 

Q.  CLICK ON ‘LETTER GRADE’ TO HIGHLIGHT IT AND CLICK ‘NEXT’.

 

R.  THE COLUMN IS POPULATED WITH LETTER GRADES FOR THE SEMESTER.

 

 

WHEN ALL CLASSES ARE DONE AND ANY STUDENTS’ GRADES THAT YOU WANTED TO ARBITRARILY CHANGE HAVE BEEN EDITED YOU ARE READY TO EXPORT.  SIMPLY CLICK ‘FILE’ ON THE TOP TOOLBAR AND THEN ‘EXPORT FROM GRADEBOOK’.  IN THE RESULTING WINDOW MAKE SURE THE PROPER QUARTER IS INDICATED AND CLICK ‘NEXT’.  IN THE NEXT WINDOW JUST CLICK ‘EXPORT’.  IN THE NEXT WINDOW, THE ‘EXPORT DIRECTORY WINDOW’, IT SHOULD READ AT THE TOP…

 

FOLDER NAME

Z:\502\your number

 

YOU PROBABLY DON’T KNOW YOUR NUMBER BUT THAT’S OK BECAUSE WHEN I SET UP YOUR GRADEBOOK AT THE BEGINNING OF THE YEAR I DID IT RIGHT SO THE NUMBER IS RIGHT. (OR I’M AN IDIOT)

 

CLICK ‘OK’.

A PROGRESS BAR APPEARS AND IN A SECOND IT EXPORTS AND YOU’RE DONE WITH IGPRO.  SAVE AND EXIT.

 

12.  PRINT YOUR NAME ON THE LOWEST BLANK ON CATHY’S PAPER AND GIVE IT TO HER BY THE DEADLINE.  SLIP IT UNDER HER DOOR IF HER OFFICE IS LOCKED.  THIS LETS CATHY KNOW YOU’VE DONE THE EXPORT AND SHE WILL THEN PRINT YOUR GRADES.  WHEN YOU RECEIVE THIS VERIFICATION REPORT CHECK FOR ANY MISTAKES.  CORRECT THEM OR WRITE ON THE FRONT THAT THERE WERE NONE AND PASS THAT IN TO CATHY.  NOW YOU ARE REALLY DONE!