MTH 154: Project 1 - Calculating Your Grade Project Directions: In this project yvou 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. 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. What does \"running tally\" mean? To help vou understand this, compute the grade of a student with an 82 MyMathLab Homework average, 84 Activities average, 73 Quiz average, a 92 on Project 1 and a 93 on Test 1 (label the cell sample student average). 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 vou surprised by their grades? Explain what weights dominate at this point in the semester. 2. Create a new sheet (tab) in the spreadsheet from part 1 which will allow you to enter all of your grades for this Math 154 course. Enter all your current grades for MyMathl.ab Homework, Activities, Quizzes. and Tests you already have. Enter a grade of 90% for Project 1. There should be nicely labeled spaces for all of the following work: % Assume there will be 31 MyMathLab Homework assignments. % Assume there will be 6 Activities. % Assume there will be 6 Quizzes. % There will be 2 Projects. % There will be 3 Tests. 3. Create cells which will compute the average MyMathLab Homework grade, average Activities grade. average Quiz grade. average Project grade, and average Test grade. Name these cells appropriately. 4. Create cells which will count the number of MyMathLab Homework grades entered so far. count the number of Activities grades, and count the number of Quiz grades. Name these cells appropriately. 5. Create cells which will compute the max and min grades for each of the 5 categories: MyMathLab Homework, Activities. Quiz, Project, and Test. 6. Create a Column Chart of your MyMathLab Homework grades average, Activities grades average, and average of your Quiz grades (put all on one chart). The chart should update as you enter new scores. 7. Format all of this nicely with borders and shading. 8. Create a cell which computes your total grade using the ideas of weighted average. 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 categories as counting for the full weight of that category. 9. Create a cell which computes the highest possible average you can get in the class. Assume your MyMathLab Homework, Activity, and Quiz averages are fixed (use the averages on the sheet) but you should assume that you get a 100 on all projects and remaining exams. Rubric: Fxcel File Running Talley Calculation and Explanation Spreadshest with Space for | all Grades Averages by Category Grade Counts Mazx and Min Grads | Calculations Column Chart | Total Grade Calculation Highest Grade | Calculation Entering Current Grades Formatting and Labeling Reflection Paragraph I Paragraph II Each individual entry properly displaved and labeled. Each properly displayved and calculated. Completely labeled, including axes, title and legend. Accurately reflects the data. The total grade is computed correctly and updates to additional and modified individual entries. Labeling, Lavout, Borders, Background color, Font, Font size, and Font style all work to enhance the spreadsheet. Spreadsheet layout makes any and all items easy to locate. Reflection is well written in orgamzation and grammatical structure. Demonstrate both deep thought and comprehensive overview of the project. 7 Points Correct calculation and questions are thorowghly answered. Incorrect calculation or questions are not thoroughly answered. Incorrect calculation and questions are not thoroughly answered. Mizsing one to three entries and 'or labels. One missing or incorrectly calculated. Each properly displaved and calculated. Each properly displaved and calculated. The chart is missing a legend or onie of the axis has not been labeled. Single error in computing the total grade or single enfry modification does not update the value. Correctly calculated. Correctly completed. Labeling, Lavout, Borders, Background color, Font, Font size, and Font style mostly effective but there is some confision about the lavout. Some hurting 1= required to locate a specific item. visual Reflection is written with poor organization or lacking grammatical structure. Demenstrate some thought and comprehensive overview of the project Missing four to six entries and''or labels. Two are missing or incorrectly calculated. One missing or incorrectly calculated. One missing or incorrectly calculated. The chart is missing two of more labels or legend. Two errors in computing the total grade and'or tiwo entries modification does not update the | value. Minor error. Missing one or one i3 incorrect. MNoticeable visual confusion about the lavout. Some hunting is equired to locate several specific items. Reflection iz written with poor organization | and lacking srammatical structure. Demonstrate little thought and no overview of the project. Miszing one to three entries and'or labels. More than two are missing or incorractly calculated. More than one is missing or incorrectly calculated. More than one is missing or incorrectly calculated. The chart 15 missing two or more labels or a legend and the chart does not accurately reflect the data. Multiple errors in calculation and'or modifications do not update the total grade. Incorrectly calculated. Several are missing or incorrect. There 15 a great deal of visual confusion about the lavout. Most tems are mizlabeled or vaguely labeled and a great deal of hunting is requirad to located most items. 0 No reflection submitted