Purchase Solution

Excel Gradebook Project

Not what you're looking for?

Ask Custom Question

1. 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.
Your Excel spreadsheet should contain the following:
□ The scores provided on the next page
□ Category averages
□ The weights used to determine the final weighted grade for the course
□ A labeled cell with the Final course grade that uses a formula to calculate the weighted average grade for the course. If a score 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 Blackboard's 'Excel Help' button.

In addition, please assist with:
□ An explanation of your process for using Excel to calculate the weighted average final grade. Were there any assumptions that you made about the scores provided?
□ Analyze and reflect on the results for the student data provided. What is the predicted final course score based on the data provided. What letter grade is this?
□ What is the lowest grade the student would have had to score on the midterm to improve his final course score to the next higher letter grade?
□ Reflect on the impact on the student's final course score for each of the following. Return the changed scores back to the original scores after considering each scenario:
i. If the student received perfect scores on all of the homework?
ii. If the student did not submit the second paper?
iii. If the instructor drops the lowest homework and quiz score for the student?
□ Some students and instructors feel that the weights for the course emphasize the exams too much. Come up with a new weighting system. Explain why you believe the new weights would be an improvement.
□ How would you have to modify (if any) your spreadsheet to calculate grades in a class where scores are out of varying point values for each assignment? For example, in Professor Ivy's class the individual homework grades are recorded as follows: HW1= 6/10, HW2= 36/54, HW3= 25/25... Professor Ivy prefers not want to turn these grades into percentages, because each is out of different points. How else could she find averages for homework in her class?
□ How could you modify your spreadsheet to calculate a math 123 grade?
□ Reflect on your experience creating this spreadsheet - What have you learned from doing this project? Did you encounter any difficulties? What did you notice about Excel spreadsheets and how can this help you in the future?

Use the following parameters and scores in your Excel spreadsheet
Create an Excel spreadsheet that will compute the following sample student's data set for the course described below. Assume all scores are out of 100 and that all grades have been recorded for this student.

Grading and Evaluation Rules for PSYC205 Abnormal Psychology Course:
Methods of Evaluation: There will be a Midterm and Final Exam in this class. Two papers will also be assigned. Homework and ten quizzes will also be part of the course grade.
Final Grade Calculation: Grading Scale:
Midterm 25% 90 - 100 A
Final 30% 80 - 89 B
Homework 10% 70 - 79 C
Papers 25% 60 - 69 D
Quizzes 10% 0 - 59 F

A student has the following grades in each category:
Homework: 80, 90, 86, 87, 89, 99, 0, 87, 88, 78, 96, 93
Quiz: 70, 73, 84, 92, 90, 100, 0, 86, 85, 80
Papers: 86, 68
Midterm: 74
Final: 78

Attachments
Purchase this Solution

Solution Summary

An Excel file containing all computations and formulas is provided. A text file containing an explanation of the solution is provided.

Solution Preview

Refer to the Excel file attached for questions #1 and #2.

2.
□ An explanation of your process for using Excel to calculate the weighted average final grade. Were there any assumptions that you made about the scores provided?

Excel can be used to calculate weighted average grades by first finding the average of each category. the average can be found using Excel's AVERAGE function, or by using Excel's SUM function, then dividing by the number of numbers in that category. These averages are then multiplied by the corresponding weights for that category. The weights used are those supplied in the course syllabus for the class. Make sure to correspond the category with the correct weight given in the syllabus. Do not assign the weights incorrectly or the weighted average grades will be incorrect. The weighted average grade is then summed. This sum gives the Final Course Grade for the student. I assumed that every score in a particular category was worth the same number of points.

□ Analyze and reflect on the results for the student data provided. What is the predicted final course score based on the data provided. What letter grade is this?

The ...

Solution provided by:
Education
  • MSc, California State Polytechnic University, Pomona
  • MBA, University of California, Riverside
  • BSc, California State Polytechnic University, Pomona
  • BSc, California State Polytechnic University, Pomona
Recent Feedback
  • "Excellent work. Well explained."
  • "Can you kindly take a look at 647530 and 647531. Thanks"
  • "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
  • "GREAT JOB!!!"
  • "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution


Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.