|
CSIS 2101 Sections 03 and 05 Assignment 5: Create an Excel Spreadsheet Due: 10:00 PM Thursday, October 12 Your grade in this course depends upon your performance in five areas: contribution, coursework, quizzes, a midterm exam and a final exam. Design a spreadsheet with which you can track your progress throughout the term. In the spreadsheet, compute averages using functions and formulas as needed. For example, a formula that includes multiple functions is needed to compute the quiz average (which drops the two lowest quizzes). Also determine the coursework average (a weighted average based on the weights of each assignment as indicated in the sample), overall course average (another weighted average), and letter grade assigned (the IF function determines the letter grade based on the course average). Two alternative calculation methods are shown: Format each cell that contains either a number or the result of a calculation as follows: choose Format|Cells|Number|Category: Number, and then specify zero decimal places. Make sure that the equation to compute the overall course average is rounded to the nearest whole number. Submission Guidelines: Save your spreadsheet as "2101 Grades for YourName.xls" (for example, "2101 Grades for Joe Student.xls") and submit it as an assignment in WebCT. You will need to attach the spreadsheet when you submit the assignment in WebCT. E-mailed assignments will not be accepted. |
