excel home work

CALIFORNIA STATE UNIVERSITY, NORTHRIDGE

COLLEGE OF ENGINEERING & COMPUTER SCIENCE

Mechanical Engineering Department

ME 101/L: INTRODUCTION TO MECHANICAL ENGINEERING

Homework # 8

Create an Excel Spreadsheet to calculate the final letter grade for any number of students based on inputs

such as homework, test, project grades …etc. Your Excel file should contain the proper formulas and logic

statements so that the final letter grade is automatically updated by changing any grade for any student.

Use these percentages in your calculations:

H.W. is 30% of final grade

Midterm is 10% of final grade

Project is 20% of final grade

Final exam is 40% of final grade

You do not need to turn in a hardcopy for this exercise. You should turn in the Excel file using

Moodle.

No Name HW#1 HW#2 HW#3 HW#4 Wt.Avg.

HW

Midterm

Exam

Wt.Avg.

Midterm

Project Wt.Avg.

Project

Final

Exam

Wt.Avg.

Final

Avg.

Grade

Semester

Grade

Max. 25 25 25 25 30 100 10 100 20 100 40 100

John 20 25 18 20 24.9 98 9.8 85 17 97 38.8 90.5 A

David 22 25 19 25 27.3 78 7.8 78 15.6 95 38 88.7 B

Sally 20 20 21 25 25.8 69 6.9 93 18.6 62 24.8 76.1 C

Paul 10 23 19 16 20.4 91 9.1 94 18.8 50 20 68.3 F