In this project you are required to do the following:

1 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:

Your name, course name and project name.

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 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

Include a pie chart to represent the weights of each category.

In addition to correctly calculating the final grade, your spreadsheet should be well-organized, with clear labels

2. typed reflection paper (minimum one page).Remember that we are looking for elegant and sophisticated reasoning. It must include the following information: Your name, course name and project name.

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?

Analyze and reflect on the results for the student data provided. 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 (this means you must check in each category 1 at a time) in order to receive the next higher letter grade? If it is possible, what was the minimum increase and category that would achieve this increase of a letter grade? If not possible, explain why. Leave your work on the tab labeled Higher Grade.

The student also has questions about how dropping the lowest homework scores would affect the grade. If the lowest 2 homework scores were dropped from the total, how would this change the grade? Leave your work on the tab labeled Drop Low HW.

This student feels that the homework is undervalued in the course grading. Cnew 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? Leave your work on the tab labeled New Weights.

Compare this to your current MATH 123 course. Based on the percentage of each category in your class, what can you conclude about your MATH 123 grade? What category is more important? If your teacher were to give you 5 extra points (not %, but points), where would you want them to be applied and why? Leave your work on the tab labeled Points.

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.

Include a pie chart that represents how much each weighted category includes.

Use appropriate representations (tables, color, formatting) that will help the reader understand the project.

Have sophisticated and elegant solutions.

Project should be your original work. Copying someone else's work is cheating. Sharing your work with someone else is cheating.

These instructions cover the MINIMUM expectations of this project. Students are encouraged to make additions beyond these items.

3. Submit both an Excel and Word file following your instructor's directions for submission.

Use the following parameters and scores in your Excel spreadsheet

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 EDUC 250 Educational 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 graduation requirements.

Final Grade Calculation: Grading Scale:

Homework5%90 - 100A

Projects30%80 - 89B

Quizzes15%70 - 79C

Midterm Exam20%60 - 69D

Final Exam30%0 - 59F

A student has the following grades in each category:

Homework: 80, 84, 82, 82, 80, 86, 88, 87, 86, 94, 88, 83, 92, 89, 92

Quiz:96, 97, 98, 95, 92, 95, 96, 98, 92, 94

Projects:50, 80, 98

Midterm Exam: 60

Final Exam:90

I really need help with this project. because I don't know how to use excel . how to do homework. please help me with this.