MoreExcelExamples in Class

# MoreExcelExamples - Professor's Grade Book Final Semester Averages Grading Assistant Your Name Goes Here Name Soc Sec Num Student ID Coulter Sara

This preview shows pages 1–6. Sign up to view the full content.

Professor's Grade Book - Final Semester Averages Grading Assistant: Your Name Goes Here Name Soc Sec Num Student ID Test 1 Test 2 Test 3 Test 4 Test Average Homework Bonus Penalty Coulter, Sara 100000000 Coulter 60 50 40 79 61.6 OK 2 Stutz, Joel 111223333 Stutz 80 71 70 84 77.8 Poor -2 Ford, Judd 200000000 Ford 90 90 80 90 88 Poor -2 Fegin, Richard 222222222 Fegin 75 70 65 95 80 OK 2 Moldof, Adam 300000000 Moldof 92 78 65 84 80.6 OK 2 Glassman, Kris 444444444 Glassman 82 78 66 81 77.6 OK 2 Barber, Maryann 444556666 Barber 96 98 97 90 94.2 OK 2 Jones, Sam 555555555 Jones 85 84 83 82 83.2 Poor -2 Laquer, Linda 666666666 Laquer 94 92 86 84 88 OK 2 Pons, Alex 777777777 Pons 65 65 68 80 71.6 Poor -2 Simon, Eric 777889999 Simon 78 81 70 78 77 Good 4 Edwards, Melissa 800000000 Edwards 84 88 92 96 91.2 Good 4 Martin, Shelly 888888888 Martin 85 85 80 89 85.6 Good 4 Brown, James 999999999 Brown 92 95 79 80 85.2 Good 4 Average HW Bonus/Penalty Grading Criteria Highest Grade Poor -2 0 Lowest Grade OK 2 60 Range Good 4 70 80 Exam Weights 0.2 0.2 0.2 0.4 90 NB: 1) get just the last 4 for each student ID (try RIGHT() function) 2) compute appropriate Test Average according to weights 3) include unweighted average column for comparison 4) Nested IF to compute Homework Bonus/Penalty 5) Compute Total Semester Average 6) Use VLOOKUP for letter grade; make sure anything w/in one % point is rounded up 7) Determine class rank for each student

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
7) Determine class rank for each student 8) Determine Averages, Max, Min, and Range for each exam.
Semester Average Grade Rank 63.6 D 14 75.8 C 12 86 B 6 82 B 8 82.6 B 7 79.6 C 11 96.2 A 1 81.2 B 9 90 A 3 69.6 D 13 81 B 10 95.2 A 2 89.6 B 4 89.2 B 5 F D C B A

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Year AFC Team AFC Score NFC Team NFC Score Winner 1967 Kansas City 10 Green Bay 35 NFC 1968 Oakland 14 Green Bay 33 NFC 1969 New York 16 Baltimore 7 AFC 1970 Kansas City 23 Minnesota 7 1971 Baltimore

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 04/07/2008 for the course BSAD ECON 040 011 taught by Professor Boveemora during the Spring '08 term at Vermont.

### Page1 / 11

MoreExcelExamples - Professor's Grade Book Final Semester Averages Grading Assistant Your Name Goes Here Name Soc Sec Num Student ID Coulter Sara

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online