Excel Challenge help

profilelsctt7
l7-ex2013-fixit-4-6_1.xlsx
Home>Business & Finance homework help>Excel Challenge help

Grades

Look Up Table For Grades
table located in cells B5:C9
table column # 1 2
0% F
60% D
70% C
80% B
90% A

Scores

Grade Book 7 Week grading scale
Drop Deadline 90 - 100% A
80 - 89% B
70 - 79% C
Number of Students 19 60 - 69% D
Below 60% F
Possible 0 0 10 20 20 20 20 8 20 20 9 20 10 20 60 40 20 20 20 10 20 20 10 20 75 25 10 547
Assignment Coupon Extra Credit Extra Credit Pretest Asmnt #1 Windows A Asmnt #2 IE7 Asmnt #3 Com Ccpts Email Assignment #4 File Mgt Print Screen and Save Quiz Assignment#5 Offic Assignment #6 Word Unit A Microsoft Word Quiz Assignment 7 Word Unit B Microsoft Word Quiz 2 Assignment #8 Word Unit C & D MidTerm Hands On Midterm Exam Multiple Choice Warning below C grade Assignment #9 Excel:UnitA Assignment #10 Excel Unit B Assignment #11 Excel: Unit C Excel Quiz Assignment #12 Assignment #13 Access Grade SS Quiz Assignment #14 Integration HO Final Exam Final Multiple Choice Post Test total percent Letter Grade
Last Name First Name
ABERNETHY JUSTIN 10 20 20 20 20 8 19 20 7 20 8 20 45 42 19 20 20 10 20 20 9 20 63 20 10 510 93.2% A
BLACKWELL JENNIFER 10 20 18 20 20 5 20 20 0 15 9 18 54 42 10 20 18 10 19 20 0 14 72 18 10 482 88.1% B
BOHNET MOLLY 30 10 20 19 20 20 8 20 20 8 20 9 20 58 42 20 20 20 9 20 20 10 20 70 23 10 566 103.5% A
BRYAN CHARLES 10 20 19 19 20 8 20 20 8 20 9 18 46 40 19 14 18 10 20 19 8 16 72 21 10 504 92.1% A
CARPENELLO RIC 15 10 10 20 17 15 8 20 20 7 19 8 18 32 32 20 16 17 10 20 19 6 9 61 15 10 454 83.0% B
DONOHOE LINDSAY 0 20 20 10 0 7 15 16 6 4 10 0 30 32 Warning 11 0 0 6 0 0 0 0 0 0 0 187 34.2% F
GILMORE DAVID 10 20 5 5 0 6 0 0 7 16 8 0 55 38 Warning 0 0 0 0 3 0 0 0 69 0 242 44.2% F
HANNAH CORY 10 19 5 5 0 0 0 0 0 0 0 0 0 0 Warning 3 0 0 0 0 0 0 0 0 0 0 42 7.7% F
JONES KAITLYN 30 10 20 20 16 20 7 20 20 8 18 8 19 51 36 20 16 19 8 16 17 9 16 50 24 10 508 92.9% A
KAWAMURAS HENRY 15 10 20 15 20 20 6 18 19 7 16 9 17 53 38 17 9 18 9 19 17 10 17 65 20 10 494 90.3% A
KEIM KARA 10 20 20 20 20 8 20 20 9 20 10 20 45 34 20 20 19 10 18 20 0 20 69 17 10 499 91.2% A
LINAREZ YOUHA 10 18 20 18 18 8 20 20 7 18 8 20 58 36 20 20 20 10 20 19 10 20 65 23 8 514 94.0% A
LOPEZ CHRISTIAN 10 20 19 20 20 8 20 20 9 20 10 20 45 44 14 18 17 9 20 20 10 17 69 22 10 511 93.4% A
MCGRATH ANTOINETTE 30 10 20 20 20 20 7 20 20 9 20 10 20 57 42 20 20 20 10 19 20 10 19 71 21 10 565 103.3% A
MORRISON NINA 30 10 18 15 10 17 5 13 17 2 10 5 17 10 24 Warning 4 0 0 0 10 7 0 3 25 15 4 271 49.5% F
MOSKALET IAN 15 10 10 18 20 14 20 8 20 20 8 20 0 18 40 34 17 20 20 9 20 20 10 20 71 24 10 516 94.3% A
PONOMARENK RAMAN 10 20 20 16 15 8 20 20 0 20 8 19 60 42 19 20 20 9 18 20 0 19 73 24 10 510 93.2% A
PRICE SYDNEY 30 10 20 20 20 20 6 20 20 7 18 8 20 50 36 20 20 20 8 20 20 0 20 61 17 10 521 95.2% A
ROMIG LAVONN 30 10 20 20 20 20 8 20 20 9 20 9 18 57 38 20 20 19 10 16 20 10 19 65 23 10 551 100.7% A

Sheet2