ELECTRONIC GRADE GATHERING

1. ELECTRONIC GRADE GATHERING “EGG”

3. SYSTEM REQUIREMENTS: A COMPUTER RUNNING WINDOWS XP and Microsoft EXCEL 2003.

4. WHY USE ELECTRONIC GRADE GATHERING (EGG) ???? THE ELECTRONIC GRADE GATHERING FORM IS AN EXCEL SPREADSHEET THAT RESEMBLES THE HSST GRADE SCAN FORM. IT ALLOWS YOU TO ENTER YOUR GRADES ELECTRONICALLY. EGG ELIMINATES PROBLEMS CAUSED BY LOST SCAN SHEETS AS WELL AS SHEETS LEFT AT HOME WHEN THEY ARE DUE. SIMPLE DATA ENTRY PROCESS ELIMINATES “BUBBLING EYE FATIGUE”.

5. WHEN YOU OPEN YOUR DOE EMAIL YOU SHOULD SEE

6. HIGHLIGHT THE “GRADE DATA” E-MAIL

7. RIGHT CLICK ON THE ATTACHMENT

8. YOU SHOULD SEE THIS BOX

9. LEFT CLICK ON SAVE TARGET AS ….

10. YOU SHOULD SEE THIS BOX

11. SELECT THE LOCATION THAT YOU WANT TO SAVE THE FILE TO

12. HIGHLIGHT IT

13. AND PRESS SAVE

14. THE FILE SHOULD NOW APPEAR WHEREVER YOU SAVED IT

15. To Open the File: HIGHLIGHT THE FILE AND DOUBLE CLICK TO OPEN

16. WHEN THE FILE IS OPENED THE MAIN PAGE APPEARS, IT CONTAINS EGG GENERATION DATA. NOTICE THAT THERE ARE 3 TABS AT THE BOTTOM OF THE SPREADSHEET (MAIN, GRADE DATA, LOOKUP).

17. NOTICE THE “LOOKUP” TAB IN THE FILE. THIS PAGE INCLUDES ALL VALID GRADES, ALONG WITH COMMENT CODES/COMMENTS.

18. CLICK ON IT TO OPEN

19. YOU WILL SEE THIS PAGE IT IS A GOOD IDEA PRINT THIS PAGE BEFORE ENTERING GRADES.

20. TO ACCESS THE EGG EXCEL FORM, SELECT… THE “GRADE DATA” TAB AT THE BOTTOM OF THE “MAIN” PAGE.

21. THE FILE IS SORTED BY COURSE AND SECTION. STUDENTS ARE LISTED IN ALPHABETICAL ORDER FOR EACH COURSE AND SECTION.

22. NOTE: THE FIELDS FOR CONDUCT AND LEVEL WILL DISPLAY ON THE REPORT CARD. LEVEL IS DESIGNED FOR MIDDLE SCHOOL USE. CONDUCT CAN BE USED BY HIGH SCHOOLS

23. AFTER ALL THE GRADES AND COMMENTS ARE ENTERED

24. “SAVE” THE DATA. ***** DO NOT CHANGE THE NAME OF THE FILE.!!!*****

25. It is a good idea to PRINT 2 COPIES OF THIS FILE. ONE FOR YOURSELF AND ONE FOR THE PROGRAM OFFICE.

26. WHEN THE YOU ARE READY TO SUBMIT THE GRADE DATA GO BACK TO YOUR DOE E-MAIL.

27. HIGHLIGHT THE ORIGINAL E-MAIL

28. SELECT REPLY

29. THE E-MAIL WILL OPEN TO THIS SCREEN

30. TO ATTACH THE SAVED EGG FORM FILE SELECT THE “PAPER CLIP”

31. CLICK ON BROWSE AND …

32. …YOU WILL NOW BE AT THIS SCREEN

33. FIND THE FILE, HIGHLIGHT IT AND CLICK ON OPEN

34. THIS WILL SELECT THE FILE TO ATTACH

35. CLICK ON ATTACH TO ….

36. …ATTACH THE FILE

37. CLICK ON CLOSE TO COMPLETE ATTACHMENT

38. THE EGG FILE IS NOW ATTACHED

39. CLICK ON SEND TO COMPLETE THE EGG PROCESS

40. SCRAMBLED EGGS Here are a few tips you should know when using the Electronic Grade Gathering (EGG) function. If you are using the cut and paste feature to enter marks or exam grades, the data must be integers. HSST and the EGG upload process are designed to accept only integers. The cells in the EGG spreadsheets are designed to display integers.  If a non-integer value (i.e. 95.7) is entered in the cell, it will appearrounded off to the nearest integer on the spreadsheet (96), however the actual value is stored by Excel in the cell.  Non-integer data will not be accepted by the EGG upload process. If data is being “pasted” from a spreadsheet and the data value was determined by a formula, please make sure that you use the “Special Paste” feature in Excel. It will paste the value, NOT the formula. ALL ENTRIES MUST BE LEFT JUSTIFIED. When using a letter grade, please do not have any leading spaces. This also includes grades of ZERO “0” and Comments.

41. THE END