ward

WARD Gradebook Project Instructions

WARD Gradebook Project uses features that you have had in class or that

you can look up in Google.

1. Save the document with your name.

2. Take some time to look at the spreadsheet to get an idea of what is going on in the spreadsheet. As you work through the sheet, think what you might do to accomplish what is expected in this spreadsheet.

a. There is no formula in cell Q2. Make a formula in cell Q2 to add the possible points that were assigned during the semester. Make changes in the appropriate cells so the formula will work.

3. Sort the list of students by Last Name, then by First Name by using a Custom Sort. Note that you should not include Row 2 b/c that row has information in it that is not a person’s name.

4. Calculate mean (Row 24) and median (Row 25) for each exam.

5. Format Rows 24 and 25 in a different color. (They may both be the same color.)

6. Students need 60% on the Final Exam to pass the course; Use an IF-statement to indicate PASS/FAIL based on the grade the student made on the Final Exam. Show this information in Column T.

a. Use Conditional Formatting to highlight the FAIL results. You may use any color you like.

7. In Column Q figure each student’s final average based on the test scores and the total number of points for the semester.

a. Note: Any “curve” numbers shown in the range should be added into the total number of points that the student earned. They are like extra points.

8. In Column R use a VLOOKUP formula to determine the final grade for each student based on the final average for that student.

9. Change the Final Grade to a D for any student who has a FAIL for the Final Exam.

a. Note: If the student already has an F, leave the grade as an F.

b. Apply a conditional format for a D to match the color you chose in Column T for the “Fail” condition.

c. Apply a conditional format for a grade of F in any color you choose.

10. Use COUNTIF to determine how many of each letter grade were assigned.

11. Insert a chart showing the distribution of letter grades. Make sure you have chosen the correct type of chart to show what is asked for. You may choose any colors you like. Move the chart so it does not cover any of the other information on the sheet. Do not place the chart on a separate Chart Sheet.

12. In the Document Properties add the Title as WARD, the Subject as Gradebook, and the Authors as you and T. Bundy.

13. Save your document. Upload to Moodle.

***