Project 1: Gradebook
In this project you will create a spreadsheet which keeps track of your grade in this Math 50 class. In addition to simply recording all of your grades for the course, it 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 50 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 2 projects and make up 1 exam grade). There should be nicely labeled spaces J for all of the following work:
3. (10%) Create cells which will compute the average HW grade, average quiz grade, average project grade, and average 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%) Create cells which will compute the max and min grades for each of the 4 categories: HW, quiz, project, and exam.
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 get 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 get 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.
10. (5%) Enter ONLY your grades for the semester so far, your total grade formula should give you your grade at this point in the semester. If you get an error try again!