Question: Create a worksheet that calculates your average for this class for all 8 assignments past and future. The point values can be found in the
Create a worksheet that calculates your average for this class for all assignments past and
future. The point values can be found in the course syllabus. Add your own personal data that
has been graded through at least You can then either temporarily enter or
for the rest of your grades whichever you prefer.
There are many possible ways of setting this spreadsheet up but it must be professionally
formatted so that it is easy to follow, clearly labeled, displays correct results, and demonstrates
that you know how to correctly format an Excel table and cells, use Excels adding and percent
formulas correctly, and use cell references in your formulas. At a minimum, this worksheet must
include the following:
a cell for each of the graded assignments
an Excelcalculated percentage for your points earned on every assignment versus the
assignment value with the cell formatted in percent form to decimal place
an Excelcalculated total for all your points earned
an Excelcalculated percentage for your total points earned on each assignment with the
cell formatted in percent form to decimal place and
a letter grade based on that percentage and the grading scale shown in the syllabus
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
