Create a grade sheet for your students that has column headers or labels. Your spreadsheet should include:
1) 10 student names (Last, First)
2) You must indicate at least 5 assignments — clearly labeled including date given and point value
3) You must provide detailed instructions to your administrator on how your grades are calculated in your class, so that he/she may speak intelligently to a parent in your absence
4) Choose only one subject in which to produce grades.
5) You must use system-generated formulas for calculations
6) You must decide if you are using a percentage-based course or a point-based course (a percentage-based course means you will have different pages for however you decide to divide your 100% total up; for example, an English teacher might decide on the following percentage break up:
Homework 20%
Projects 25%
Tests 25%
Participation 10%
Papers 20%
Remember that you will need grades under each heading and then will add up the points earned in for each subgroup
Homework was averaged at 95% X by .20 (percent) = 19 points towards 100 total
This would be done for each subgroup and then the points would be added to give you the students’ final grade.
7) You must format the cells (decimal places, border and shading, lines, and so forth).
8) You must assign each student a final grade (percentage and letter)
Below are formulas you can copy and paste into your spreadsheet so that your final grade will automatically calculate A, B, C…. Again, you are only doing one subject with 10 students and 5 assignments.
=IF(G7>90,”A”,IF(G7>80,”B”,IF(G7>70,”C”,IF(G7>60,”D”,”F”))))
=IF(G11>89.99,”A”,IF(G11>79.99,”B”,IF(G11>69.99,”C”,IF(G11>59.99,”D”,IF(G11>42.99,”PC”,IF(G11>=0.1,”F”))) )))
Additional help in using Excel can be found at: http://office.microsoft.com/en-us/excel-help/
0 comments