Grade
Book Spreadsheet Project
1. Open a new
spreadsheet
2.
Using both text and data to create a gradebook that monitors the work of five
students in a fictional class. Each student must receive at least five grades
(can be more).
3.
See the sample for this project:
4.
Use formulas to find the individual averages as well as the class averages.
5.
All formulas begin with = and use the cell names
(such as B4) to define the operation. Discover how to use the AutoSum toolbar
button to your advantage by first highlighting the box where you would like your
sum total to appear and then dragging the mouse over the numbers you would like
totaled.
6.
Use formulas to find the individual averages as
well as the class averages. The formula for creating averages is AVERAGE(b3:f3),
where b3 to f3 is the range of the numbers to be averaged. Use the Function
option on the Insert menu to help you easily figure averages.
7.
Your final copy that you turn in should include your name typed onto the final
copy and a word processing document where the spreadsheet and chart have both
been copied so that this is turned in as one document.
8. You have two class periods to work on this project.