Scribd
Upload
29 views1 page

Danest 2

This document provides instructions for creating a grade book spreadsheet in Excel that calculates student grades using weighted averages and nested IF functions. Students' final grades will be determined by averaging their scores on tests, projects, and exams, weighted according to percentages provided. Letter grades will be assigned using a nested IF formula comparing the weighted averages to grade cutoffs. The spreadsheet will also include a column graph of students' scores.

Uploaded by

annamay.buitizon
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
29 views1 page

Danest 2

This document provides instructions for creating a grade book spreadsheet in Excel that calculates student grades using weighted averages and nested IF functions. Students' final grades will be determined by averaging their scores on tests, projects, and exams, weighted according to percentages provided. Letter grades will be assigned using a nested IF formula comparing the weighted averages to grade cutoffs. The spreadsheet will also include a column graph of students' scores.

Uploaded by

annamay.buitizon
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

EXCEL CHALLENGE

This project contains the use of a simple formula a complex formula and a nested IF function.

INSTRUCTIONS:
You will create the following grade book spreadsheet.
Tests = 25% Scale: A is 90 to 100
Projects = 10% B is 80 to 90 This is the information need to create the
Exam = 30% C is 70 – 80 formulas for the grade book sheet. (Hint:
D is 60 – 70 when figuring letter grade, may need to use
F is below 60 decimals like 89.5.

Create a spread sheet in Excel like this. Your job is to figure out the formulas to arrive at the answers as
shown.

What you need to know:


The class average for each assignment is a simple average
The student averages use a formula that weights the grade according to the chart above
The letter grade is a nested IF function. (Go to help and look up “IF Formula”)
Place the formula used to get the answer on the correct line.

B7: _______________________________________ C7 ___________________________________

D7: _______________________________________ E7 ___________________________________

F7: _______________________________________ G7 ___________________________________

G2: _______________________________________ G3 ___________________________________

G4: _______________________________________ G5 ___________________________________

H2: __________________________________________________________________________________

H3 __________________________________________________________________________________

H4: __________________________________________________________________________________

H5 __________________________________________________________________________________

After creating the spreadsheet and figuring out the formulas, create a column graph of the student’s scores.
Turn in the Excel sheet and this sheet together.
Write clearly when recording the formulas. Make sure all commas, parenthesis and everything are included.

You might also like