Grade Sheet Activity
Grade Sheet Activity
Besides being a tool to implement a variety of mathematics topics, a spreadsheet is an excellent way to track student’s progress. It can quickly calculate sums, as well as allow experimenting with “what if” possibilities such as what if a student were to get 100 on the last test?
1. Examine the given spreadsheet file. It contains the grades on quizzes, projects, and test for a simulated class.
2. Select the names and data and use the sort option under the Data menu to alphabetize the names.
3. Add a column for quiz 7 and enter the following grades.
|Brown |Daniel |80 |
|Gilbert |Jason |80 |
|Jones |Susan |90 |
|McDouglas |Patty |75 |
|Shannon |Andrew |75 |
|Smith |Mary |90 |
|Smith |William |75 |
|Snyder |Sharon |80 |
|Williams |Nathan |75 |
|Woo |John |75 |
4. Add the necessary formulas to find the maximum and minimum grade for each quiz.
5. Add the necessary formulas to find each student’s course average with the conditions that the lowest quiz grade is dropped, the average of the remaining quizzes is 40% of the grade, the average of the project grades is 30% and the average of the test grades is 30%.
6. Format the average to be displayed as an integer
7. Calculate what Patty McDouglas’ grade is since she turned in her missing project and it received a grade of 70.
8. Add the necessary formula to find the overall test grade average.
9. Add the necessary formula to find the average of the student averages.
10. Label all values found and displayed.
11. Save file as “Computed Grades.xls”.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- mean— a mathematical average of a group of numbers
- practice final examination
- grade sheet activity
- algebra unit 3 worksheet 6
- schooltool grade book basics
- worksheet for finding the overall grade
- weekly homework sheet 7th grade math d aloisio frye
- letter grade calculator flow chart
- calculating standard deviation worksheet
Related searches
- 3rd grade fun activity worksheets
- homeschool grade sheet printable
- free grade sheet template
- 5th grade writing activity pdf
- 5th grade science activity sheet
- 5th grade fun activity worksheets
- 2nd grade printable activity sheets
- blank grade sheet template printable
- free printable grade sheet teachers
- homework grade sheet for teachers
- teacher grade sheet pdf
- sample grade sheet for teachers