Name: Course Name: Project name : Homework 80 84 82 82 80 86 88 87 86 94 88 83 92 89 92 Average Weightage: Weight score Total Weight score Final Course Grade: 86.2 5% 4.31 Quiz 96 97 98 95 92 95 96 98 92 94 95.3 15% 14.295 80.405 B Projects Midterm 50 60 80 98 76 30% 22.8 60 20% 12 Final 90 90 30% 27 An explanation of your process for using Excel to calculate the weighted average final grade. If you encountered any difficulties, how did you overcome them? What is the final course score you determined based on the initial data provided? What letter grade is this? The student wishes to know what changes she could have made to increase her grade to the next higher letter grade. Is it possible for the student to have improved in any individual category in order to receive the next higher letter grade? If it is possible, what was the minimum increase and category(s) that would achieve this increase of a letter grade? If not possible, explain why. The student also has questions about how projects were scored. The projects were initially graded out of varying points to reflect the increasing difficulty of the projects. The student initially received scores of 25/50, 60/75, and 98/100. Note that the scores for these projects are given in the data as percentages. Could scoring the projects out of points rather than percentages affect the category average? Explain why or why not. This student feels that the homework is undervalued in the course grading. Create a new weighting system and explain why/how you chose your new weight values. What final course grade would the student earn under your new category weighting system? Reflect on the results of your project. What have you learned from doing this project? In addition to addressing the given statements, your project should: Contain a paper that is well organized and in paragraph form (not just bulleted answers!). Contain a paper that is clear to someone who is not familiar with the project. (i.e. don't assume that you are writing this to your instructor, make sure anyone could understand your statements.) Give specific values (i. e. quantify statements). Provide support for your statements (e.g. explain how values were found and justify statements). Contain a spreadsheet using the original grade values given below. Use appropriate representations (tables, color, formatting) that will help the reader understand the project. Have sophisticated and elegant solutions. Grading for Psychology: Methods of Evaluation: There will be a Midterm and Final Exam in this class. Three Labs will also be assigned. Homework and ten quizzes will also be part of the course grade. This course requires a C or better for transfer requirements. Final Grade Calculation: Homework Projects30% Quizzes Midterm Exam Final Exam Grading Scale: 5% 80 - 89 15% 20% 30% A student has the following grades in each category: 90 - 100 B 70 - 79 60 - 69 0 - 59 A C D F Homework: Quiz: Projects: Midterm Exam: Final Exam: 80, 84, 82, 82, 80, 86, 88, 87, 86, 94, 88, 83, 92, 89, 92 96, 97, 98, 95, 92, 95, 96, 98, 92, 94 50, 80, 98 60 90