# InstructionsProject 1, descriptionUnderstanding 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...

## Project 1, description

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 responses to several questions regarding your project in IvyLearn. Excel documents ONLY should be uploaded (xls or xlsx file extensions only).

In this project you are required to do the following:

Create an Excel spreadsheetthat 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 of your own scores).

• A table to calculate the final course percentage with the following headings: Categories, Category Weights, Category Averages and Category Percentage Points.

• Category Weights given on the next page used to determine the final weighted percentage for a MATH 123 class.

• A final course percentage based on the percent weightings. The cell where the final course percentage should be located at the bottom of your grade book calculation table and should be labeled.That cell should contain aformulaused to calculate the weighted final course percentage.If a value is changed in your spreadsheet of individual scores, your final course percentage calculation should immediately recalculate.Please limit your use of Excel functions to those used in the course (for a list see the ‘Excel Reference sheet’ by going to the bottom of the Module page in our IvyLearn course with the heading ‘Resources’ and click on ‘Excel Help’.)Highlight the final course percentage cell.

• Explain how you created the Excel worksheet you have used for this project (an overview as if writing to someone not in this course-explain what you did).

• Make sure to include an example of each of the different functions/formulas you used but avoid using cell references (B5, A3, G12, etc.).

• What final course percentage (expressed in the spreadsheet as a whole percentage) did you calculate?

• What letter grade in the course did this student earn based on the percentage calculated?

1. Increasing project scores:

• If this student could earn more points back on the project scores, what would be the best possible score for the projects to increase their overall class grade to the next letter?

• Explain how you came to your conclusion for this answer. If it is not possible, state this in your response.

• What is the lowest percentage (as a whole number) this student would need to earn on Test 3 to bring their final course percentage (the answer from number 1) up to the next higher letter grade for the overall course?

• If it is not possible, state this in your response. Include in your response how you concluded whether it was possible or not.

• How many zeros in the homework category would it take to lower the overall class grade down one letter grade? (Start from the lowest scores and change them to zero until the overall grade changes. You can count the current zero in the score as 1 value.)

• Do you think this student was at risk of dropping to the next lower letter grade?

• Explain how you came to your conclusion.

• Is it possible for the student to get an A in this class if the weights of each category were different? Change the weights of each category to show that the student could get an A in the course.

• Is your weighted system reasonable for this student?

• Explain how you came to your conclusion.

Methods of Evaluation:There will be a Test 1, Test 2, and Test 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: Category Weights: (NOTE: These are grade weights for a virtual Math 123 course)

90 - 100 A Test 1: 20% Online Test Review: 5%

80 - 89 B Test 2: 20% Project: 10%

70 - 79 C Test 3: 25% Quiz: 10%

60 - 69 D Homework: 10%

0 - 59 F

The following scores are to be used for the sample student in this project. Assume that these scores are percentages.:

 Table of grades for each category Test 1 90 Test 2 87 Test 3 82 Online Test Review 50 80 85 Project 92 98 Quiz 100 90 95 92 84 73 0 80 70 60 Homework(20 scores total) 100 90 80 85 100 90 0 60 64 90 100 100 95 86 91 88 50 78 100 90

Example of a poorly written response:

Yes, I think his score would go up and yes he would be able to reach the next letter grade.

This response is not good and will get a failing grade. This is vague and not quantitative. The response does not indicate the student used their Excel spreadsheet, made the indicated changes, or analyzed the results. The response does not meet minimum sentence or word count. No specific numbers have been used which indicates the student is guessing at the correct answer without numerical evidence to show they have done the problem.

Example of a well written response:

The student’s score increased from 52 to 65%. This is an increase in the highest weighted category of 13%. The Test category is weighted at 40% of the overall grade. The student’s original score in this category earned 20.8 percentage points, but with his improved test score, he now earns 26 percentage points in this category. The overall score went from a 69.9 to a 75.1 - a 5.2% increase in the overall grade. This student raised his overall grade from a D to a C.

Student changed the data in their Excel spreadsheet and reported several changes in category, overall score, and grade. Student analyzed the increase or decrease of the new score and have shown evidence of understanding the question and displayed a correct interpretation of the results.

Answered 1 days AfterMar 05, 2024

## Answer To: InstructionsProject 1, descriptionUnderstanding how weighted averages work will be a very...

Dr Shweta answered on Mar 07 2024
Sheet1
Homework    Quiz    Project    online review    Exam 1    Exam 2    Exam 3    20 scores total            category    catego
ry averages    weights %    category percentage points    category percentage...
SOLUTION.PDF