Create an Excel workbook that computes, for our course, the course percentage grade and course letter grade. The worksheet should: ** List each assessment, the number of points possible, and the number of points earned for each assessment. ** Incorporate formulas/functions to compute the average for each grade category (i.e., activity/assignment and exams) and a weighted course average (using the 40% / 60% weights described in the syllabus) ** Assign the course letter grade based on the standard 10-point scale (HINT: refer to the ′Functions Part 3 lecture for assistance in using a lookup function to determine the letter grade). ** Contain labels for all data and be appropriately organized ** Be dynamic – do not hard code data; instead provide areas in which the user can enter the points earned on each assessment. How much: students can earn up to 5 points for a functional and nicely formatted worksheet. The points earned on this assignment will be added as points earned when computing the ′Activity / Assignment′ portion of the course grade. Effectively, completing this optional activity will allow a student to replace a missing comprehensive review activity or earn additional points added to one of the assignments.
