Excel Progam level Walkthrough + Hierarchy Chart

profileScampuss
Project1walkthrough.xlsx
Home>Computer Science homework help>Excel Progam level Walkthrough + Hierarchy Chart

HLWT

CIS 2110 Project 1 Walkthrough
Exam Scores
Inputs Working Storeage Outputs
nrStuds psIOwt wlkThruWt essenMdlWt impMdlWt codeWt studId psIOScr wlkThruScr essenMdlScr impMdlScr codeScr studId prcntGrd ltrGrd classAvg highScore highStud lowScore lowStud
8 10% 25% 15% 20% 30%
901 100% 98% 90% 95% 93% 901 94.90% A
902 98% 90% 100% 92% 92% 902 93.30% A
903 95% 99% 99% 97% 93% 903 96.40% A
904 100% 86% 84% 93% 80% 904 86.70% B
905 96% 99% 89% 98% 97% 905 96.40% A
906 80% 76% 70% 94% 100% 906 86.30% B
907 89% 92% 98% 77% 50% 907 77.00% C
908 92% 95% 97% 80% 45% 908 77.00% C
88.5% 96.40% 903 77.00% 907