Using Microsoft Excel, build a spreadsheet for calculating grades in a hypothetical class. Enter test data for 10 students with the following fields. All grades for assignments, exams and class participation are numeric and on a grading range of 0 to 100

5 homework assignments: 10 points (%) each (graded as 0 to 100 points) 2 mid-term exams: 10 Points (%) each (graded as 0 to 100 points) Class participation: 10 Points (%) (graded as 0 to 100 points) 1 final exam: 20 Points (%) (graded as 0 to 100 points)

Set your spreadsheet up to do the following: a. calculate individual students overall grades; b. calculate class averages for each homework, mid-term exams, class participation, final exam, and the overall grade; c. calculate individual students averages for homework, and exams; d. convert the overall course numeric final grade to a letter grade for each student automatically within your spreadsheet using the LOOKUP function; (i.e. a numeric grade of 89 = letter grade of B+)

97-100 A+ 77-79 C+ 59 or less F 94-96 A 74-76 C 90-93 A- 70-73 C- 87-89 B+ 67-69 D+ 84-86 B 64-66 D 80-83 B- 60-63 D-

e. Develop three charts to illustrate homework results, exam results, and overall course results for the class. Please utilize three different types of graphic representation for the charts (line, bar/column, and pie). All charts should be linked to your spreadsheet so that a grade change will change the chart output