1. What does running tally mean? To help you understand this, compute the grade of a...

 

 

Transcribed Image Text:

1. What does "running tally" mean? To help you 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 you 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 MyMathLab 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, Excel Homework, Workbook, 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. 1. What does "running tally" mean? To help you 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 you 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 MyMathLab 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, Excel Homework, Workbook, 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.