Spreadsheet Gradebook Project

Spreadsheet Gradebook Project

Some schools provide teachers with software to use to collect and calculate grades. Many do not. You can create your own grade keeping records with spreadsheet tools. For this project you will use Microsoft Excel. Advantages of using spreadsheet software for grade keeping are that the software calculates the grades for you any time you need them and you can quickly access the grades of an individual student and print them for parents or school personnel who might need them.

ASSIGNMENT

Imagine that you have a class of 15 students at the grade level and in a subject area you plan to teach. Set up 9 learning activities that you would assign and grade in one school quarter. The average of the grades for these 9 activities will be the final grade for the quarterly report card.

Design a spreadsheet that will calculate the average grade for each student. Develop an understandable label for each assignment and format the spreadsheet effectively (background color, text style and color, etc.).

Include:

Calculation of the average class grade for each assignment
Calculation of each student's quarter progress
Calculation of a class average
Print one copy of your spreadsheet sorted alphabetically and one sorted by the average grade. Include a header that identifies each.
Create an appropriate graph of your spreadsheet.
Insert a graphic.
Print either landscape or portrait.
Save as spreadsheet.htm
Upload your spreadsheet and graph to your web site.

Scoring Rubric

		possible
Spreadsheet gradebook is uploaded to web site and labeled correctly.		1
Includes at least 15 students and 9 grades.		1
An average grade for each student is computed by the spreadsheet		2
A class average for each of the 9 assignments is calculated.		2
A class average calculated for the student average grade (overall)		1
Attractive and well formatted. A title appears in the HEADER		1
Appropriate graph of the class grades.		1
Graphic is inserted		1
Total		10