Maths 123 Quantitative Reasoning Project.
Weighted Grade Book
GROWS Math 123 Quantitative Reasoning Project 1 5. Given the student's final grade, what is the lowest possible score for Exam 3 that the student could have had to keep the same letter grade? Justify how you came to this conclusion. 6. If the student failed both projects by earning 50% on each, would they still have the same grade they have currently? Explain how you came to your conclusion for this answer. What if the student did not turn in either project? Submit both an Excel and Word file following your instructor's directions for submission. Weighted Average Use the following parameters and scores in your Excel spreadsheet Methods of Evaluation: There will be an Exam 1, Exam 2, and Exam 3 in this class. A total of 20 homework papers are given and 10 total quizzes are assigned. The course has 2 projects and 3 online test reviews. Grading Scale: 90 - 100 80 - 89 70 - 79 60 - 69 0-59 A student has the following grades in each category: Exam 92 Exam 2 89 Exam 3 84 Online Test Review 85 65 0 Project 72 88 Quiz 0 60 79 77 80 88 100 90 90 100 Homework 100 100 65 70 95 100 75 76 95 83 80 100 85 90 92 100 55 100Math 123 Quantitative Reasoning Project 1 Weighted Grade Book Project Understanding how weighted averages work will be a very important topic for you in this course, since your grades are determined in this way. In this project, you will create an Excel spreadsheet that can calculate a student's final grade in a course. You will then submit a WORD document answering several questions regarding your project. WORD and Excel documents ONLY. In this project you are required to do the following: Create an Excel spreadsheet that will be capable of calculating a student's final grade in a given course. Keep in mind that weighting is involved in determining the final grade. You should NOT be using a template for this project. You will be required to CREATE the gradebook from a blank worksheet. Your Excel spreadsheet should contain the following: Your name, course name and project name. A data table labeled by Category using the category headings and scores on the next page for a MATH 123 class (DO NOT use any your own scores). A table to calculate the overall grade with headings Categories, Category Weights, Category Average and Category Percentage Points. Category Weights used to determine the final weighted grade for a MATH 123. (Where can you find the weights for this course?) A Final course grade, Labeled cell, at the bottom of your grade book calculation table that uses a formula to calculate the weighted OVERALL COURSE grade. If a value is changed in your spreadsheet, your final calculation should recalculate. Please limit your use of Excel functions to those used in the course-packet (for a list see the 'Excel Reference sheet' in Ivy Learn's 'Excel Help' Module.) Highlight the final course percentage cell. Your written portion of the project will consist of answering the short answer questions given below. Each short answer response should be a minimum of 3 sentences and 50 words. Use proper quantitative reasoning and wording to address the solution. This should include sophisticated and elegant solutions to clearly convey your message to the reader. Make sure to use you spreadsheet to answer the "what if" questions with specific values and provide support for your statements. Questions are not cumulative - return to your original spreadsheet to answer the next question. 1. Explain how you set up your excel worksheet. Make sure to address any formula used by showing an example but avoid using cell references (B5, A3, G12, etc.). What final course percentage (to 1 decimal) did you calculate? What letter grade in the course did this student earn? 2. At the end of the semester, the instructor decides to drop any zero in the course for the student. Which would you choose and why? How does this affect the final grade? Will they reach the next letter grade? 3. What score on Exam 3 that would raise the student's overall class score to the next letter grade? How many more points did they need? 4. If the instructor allows the student to correct any homework or quiz, what is the best possible score in the class if s/he gets a perfect score on every homework and quiz assignment? Is this enough to raise the student's class score to the next letter grade
