Quantitative Reasoning

In this project you will create a spreadsheet which keeps track of your grade in this Math 154 class.  In addition to simply recording all of your grades for the course, your gradebook will provide you with a “running tally” of how you are doing in the course at any point in time during the semester.

1. (5%) What does “running tally” mean? To help you understand this, compute the grade of a student with an 8.2 HW average, 7.3 Quiz average, a 92 on Project 1 and a 93 on the first exam.  Use the syllabus to determine the appropriate weights for each category and enter a formula in a spreadsheet to compute their grade.  Re-compute their grade assuming they get a 95 on Project 2.  Insert a textbox into the spreadsheet and record both grades in the textbox.  Are you surprised by their grades?  Explain what weights dominate at this point in the semester.
2. (10%) Create a new sheet in the spreadsheet from part 1 which will allow you to enter all of your grades for this Math 154 course. To start, you may make up grades for some but not all of the possible assignments (so enter the HW and quiz grades you already have, and make up 1 project and make up 1 exam grade).  There should be nicely labeled spaces J for all of the following work:

• Assume there will be 12 Excel HW assignments for Excel Problems and 12 MML HW assignments through MML. HW graded 0-10 points.  (*Note: there are more of each but for the sake of this project, we will just use 12 for each)
• Assume there will be 6 quizzes at the end of each chapter. Quizzes graded 0-10 points.
• There will be 2 projects. Projects graded 0-100 points.
• Midterm Exam graded 0-100 points.
• Final Exam graded 0-100 points

3. (10%) Create cells which will compute the average Excel HW, average MML HW grade, average quiz grade, average project grade, and average miterm exam and average final exam grade. Name these cells appropriately, so if used in a formula the name will appear not the cell reference.
4. (10%) Create cells which will count the number of HW grades entered so far, count the number of quiz grades, number of project grades, and number of exam grades.  Name these cells appropriately, so if used in a formula the name will appear not the cell reference.
5. 5. (5%) Create cells which will compute the max and min grades for each of the 6 categories: Excel HW, MML HW, quiz, project, and the 2 exams.
6. (20%) Create a Histogram of your HW grades and your Quiz grades (you may put both in one chart).  You must choose appropriate bin sizes so that there is more than one column in your chart.  Keep the chart next to where you enter grades, not on a separate sheet, so when you enter your grades the columns will change… WOOOHOOOO!
7. (5%) Format all of this nicely with borders and shading J Try to arrange so that it all fits onto one screen when Excel is opened to the max width of the monitor screen.
8. (20%) Create a cell which computes your total grade using the ideas of weighted average as discussed in class. The formula must take into account the “counts” of your grades.  This formula must be linked to all of your input cells, so when you enter a grade it automatically updates.

You may use the average for the HW and Quizzes as counting for the full weight of that category, but you must weight each project and exam individually.

9. (10%) Create a cell which computes the highest possible average you can earn in the class.  You may assume your HW and Quiz averages are fixed (you can use the averages on the sheet) but you should assume that you earn a 100 on all remaining projects and exams.  To do this you will once again have to count the number of projects and exam grades entered so far.