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.

Instruction Files

Related Questions in statistics category


Disclaimer
The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.