Create a spreadsheet that automatically calculates your grade in this class as you enter the grades that you receive.
statistics
Description
| Create a spreadsheet that automatically calculates your grade in this class as you enter the grades that you receive. | |||||||||
| It should include: 1) the weights of each graded assignment, 2) your grade in each assignment, | |||||||||
| and 3) your final grade. Be sure to label everything: such as the places where the information, | |||||||||
| is stored; the names of each assignment; and where to add the actual grades that you receive. | |||||||||
| Make this sheet user friendly; especially for users that see the sheet for the first time. | |||||||||
| To use this for your benefit, you may want to design it so that it can be used to calculate your interim grade | |||||||||
| before you have all the grades. After this week, you will receive the solution from your professor | |||||||||
| and you will be able to use your solution or our solution for future classes. | |||||||||
| To test your calculator, make up grades for all assignments. This will allow you to test it and make sure that you get the correct final grade. | |||||||||
| 1) “give yourself” 85 on all assignments, make sure the final is 85. Now change all grades to 90 and verify that your final grade is 90. | |||||||||
| 2) Next change one of the quizzes from 90 to 80, and make sure the final grade is lower. | |||||||||
| 3) Then change the 80 back to 90 and change the mid term grade to 80. Make sure that the result is different. | |||||||||
