Spreadsheet

Spreadsheet

Gradebook Ms. Holste
	Spelling	Bird Essay	Tech. Project	Book Review Willa Cather	Native Americans	Plants	Planets	Graphs	Money	Average
Ann Animal	100	100	85	100	95	87	100	98	86	95
Beth Bird	95	86	95	100	98	87	99	95	84	93
Cody Counting		86	95	100	96	87	95	94	81	92
Drew Drawing	63	86	65	100	85	87	94	91	81	84
Jena Jumping	98	86	72	100	96	87	91	96	82	90
Jeremy Germ	94	86	82	100	93	87	85	94	80	89
Jill Johnson	93	86	98	100	92	87	94	91	87	92
Joe Jaguar	52	85	98	100	91	87	93	92	89	87
Lilly Loving	86	84	98	100	91	78	91	91	91	90
Sara Slurping	98	98	84	100	78	78	91	91	78	88
Sue Sleeping	98	98	86	100	100	97	90	93	70	92
Tonya Tailor	98	68	95	100	100	78	91	86	96	90
Zak Zinging	98	86	94	100	100	78	89	85	95	92
Assignment Average	89	87	88	100	93	85	93	92	85	90	Average Class Grade

Gradebook Ms. Holste
	Spelling	Bird Essay	Tech. Project	Book Rev. Cather	Native Americans	Plants	Planets	Graphs	Money	Average
Drew Drawing	63	86	65	100	85	87	94	91	81	84
Joe Jaguar	52	85	98	100	91	87	93	92	89	87
Sara Slurping	98	98	84	100	78	78	91	91	78	88
Jeremy Germ	94	86	82	100	93	87	85	94	80	89
Jena Jumping	98	86	72	100	96	87	91	96	82	90
Lilly Loving	86	84	98	100	91	78	91	91	91	90
Tonya Tailor	98	68	95	100	100	78	91	86	96	90
Cody Counting	82	86	95	100	96	87	95	94	81	91
Zak Zinging	98	86	94	100	100	78	89	85	95	92
Jill Johnson	93	86	98	100	92	87	94	91	87	92
Sue Sleeping	98	98	86	100	100	97	90	93	70	92
Beth Bird	95	86	95	100	98	87	99	95	84	93
Ann Animal	100	100	85	100	95	87	100	98	86	95
Assignment Average	89	87	88	100	93	85	93	92	85	90

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