Question

1. Create a model that calculates the course grade for a student in in a class....

1. Create a model that calculates the course grade for a student in in a class. Suppose the course grade is calculated as 30% Midterm, 30% Final and 40% Homework. As inputs for the model suppose a student had a 79 on the Midterm, a 85 on the Final, and a 90 on their Homework. In a blank cell, label and write the answer to question 1.

2. Answer the following question using Goal Seek, "What grade does a student need on the final exam to get a 80% overall in the course?". Assume 79 on Midterm and 90 on Homework. In a blank cell, label and write the answer to question 2.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A statistics class has the following activities and weights for determining a grade in the course:...
A statistics class has the following activities and weights for determining a grade in the course: test 1 worth 15% of the grade, test 2 worth 15% of the grade, test 3 worth 15% of the grade, homework worth 10% of the grade, semester project worth 20% of the grade, and the final exam worth 25% of the grade. If a student receives an 85 on test 1, a 76 on test 2, an 83 on test 3, a 74...
In Python... Write a program that calculates a student’s final grade in this course. The program...
In Python... Write a program that calculates a student’s final grade in this course. The program should: Display a message stating its goal Prompt the user to enter a student’s average grade for the weekly assignments, grade for mid-course project and grade for final project Calculate the final grade based on these percentages... Assignments = 60% Mid-course & Final Project = 40% (20% each) A A- B+ B B- C+ C C- D+ D D- E 100-94 93-89 88-85 84-82...
Suppose that you are taking a course. There are two midterms and a final exam. Each...
Suppose that you are taking a course. There are two midterms and a final exam. Each midterm impacts 25% of the course grade while final exam impacts 50% of the grade. The first and second midterm scores follow a normal distribution with mean 84 points and the standard deviation of 9 points and mean 85 points and the standard deviation of 6. Assume that the final exam is also normally distributed with mean 87 and standard deviation of 6 points....
Using the accompanying Student Grades​ data, construct a scatter chart for midterm versus final exam grades...
Using the accompanying Student Grades​ data, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the​ model? If a student scores 7878 on the​ midterm, what would you predict her grade on the final exam to​ be? Student Midterm Final Exam 1 75 64 2 85 91 3 80 68 4 88 83 5 76 60 6 67 80 7 78 74 8 95 94 9 67 61 10 93 87 11...
Suppose a course has the following grading scheme: Homework: 25% Tests: 40% Final Exam: 35% If...
Suppose a course has the following grading scheme: Homework: 25% Tests: 40% Final Exam: 35% If a student had a 68% homework average, 72% test average and got 89% on the final exam, determine their course grade. Answer: %
1. An instructor has set a grading policy as follows in their class: Homework is worth...
1. An instructor has set a grading policy as follows in their class: Homework is worth 10% Quizzes are worth 20% The midterm exam is worth 30% The final exam is worth 40% Chris' score is 80.86 for the homework, 67.87 on the quizzes, 80.14 on the midterm exam, and 63.24 on the final exam. What was Chris' final grade in the class? Report your answer to two decimal places, and include the score only. An example answer is: 87.65
1。James is taking a computer science course. The mark breakdown is as follows: • Midterm Exam...
1。James is taking a computer science course. The mark breakdown is as follows: • Midterm Exam 1 – 20% • Midterm Exam 2 – 30% • Final Exam – 50% All exams are out of 100 marks. James received scores of 70 on Midterm Exam 1 and 60 on Midterm Exam 2. To receive a final grade of B+ in the course, a student requires a final grade of 75% or higher. What is the minimum score James must get...
The following model can be used to predict what grade G a student will earn on...
The following model can be used to predict what grade G a student will earn on the next Math exam, given their current GPA x and average time they study each week t in hours: G = x + 0.24xt^2 + 5. Assuming the desired grade G is constant among a group of students. Compute dx/dt for a 3.0 student wanting to earn a B (80%) on the next exam. Label and interpret your answer. Then use the result to...
Question 1 1. A set of final examination grades in an introductory statistics course is normally...
Question 1 1. A set of final examination grades in an introductory statistics course is normally distributed with a mean of 85 and a standard deviation of 12. a) What is the probability of getting a grade of 95 on this exam? b) What is the probability that a student scored less than 55 and more than79? c) The probability is 8% that a student taking the test scores higher than than what grade? d) If the professor grades on...
A study was conducted to determine whether the final grade of a student in an introductory...
A study was conducted to determine whether the final grade of a student in an introductory psychology course is linearly related to his or her performance on the verbal ability test administered before college entrance. The verbal scores and final grades for 10 students are shown in the table below. Student, Verbal Score x, Final Grade y 1 80 77 2 65 98 3 45 96 4 30 60 5 56 64 6 56 73 7 49 84 8 52...