PART II

PART III

Generate a report containing the lowest, highest and average score for each assignment in the data file. The name of the assignment is located in column 3. Your report should be in a tabular format as shown in the sample below; NameLow 006 77 05 WS HighAverage 95 96 86.80 46.60 40 78.80 61 64.80 47.80 74.60 82.20 65 76.60 80.60 74.80 67 91.60 75 66.80 61.40 81 95.80 85.60 76.80 79.20 100 58 60 007 06 L07 H01 H02 H03 H04 H05 H06 001 25 H07 02 84 01 003 33 02 004 55 L03 FINAL 58 005 54 04 86 90 95 95 80 95 97 100 90 100 91 100 100 100 100 19 47 70 46 54 58 52 41 48 100 Table 1 Student Catehory Assignment Score Possible 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 ChelseyHomework H01 Chelsey Homework H02 ChelseyHomework H03 ChelseyHomework H04 Chelsey Homework H05 ChelseyHomework H06 ChelseyHomework H07 L01 L02 L03 L04 LO5 LO6 L07 Q01 Q02 Q03 Q04 Q05 Q06 90 89 Chelsey Lab ChelseyLab ChelseyLab ChelseyLab ChelseyLab ChelseyLab Chelsey Lab ChelseyQuiz Chelsey Quiz Chelsey Quiz Chelsey Quiz Chelsey Quiz Chelsey Quiz 80 82 84 86 91 100 100 100 96 80 81 100 100 98 93 100 100 Q07 FINAL WS ChelseyQuiz ChelseyFinal Chelsey Survey Sam Sam Sam Sam Sam Sam Sam Sam Sam 82 100 19 82 95 46 82 97 52 100 100 100 100 100 Homework H01 Homework H02 Homework H03 HomeworkH04 Homework H05 Homework H06 Homework HO7 L01 02 L03 04 05 06 07 100 100 100 100 100 100 100 100 100 100 100 100 Lab Lab Lab Lab Lab Lab Lab 85 Sam Sam Sam Sam Sam Sam Sam Sam Sam Sam Sam Quiz Quiz Quiz Quiz Quiz Quiz Q01 Q02 Q03 Q04 Q05 Q06 85 64 54 95 100 100 100 68 100 Q07 FINAL WS Quiz Sam Sam Sam 58 100 Final Survey Andrew Homework H01 Andrew Homework H02 Andrew Homework H03 Andrew HomeworkH04 Andrew Homework H05 Andrew HomeworkH06 Andrew Homework H07 100 100 100 100 100 100 100 100 25 47 85 65 54 58 52 87 45 92 48 42 L01 Andrew Lab Andrew Lab Andrew Lab Andrew Lab Andrew Lab Andrew Lab Andrew Lab Andrew |Quiz Andrew Quiz AndrewQuiz 100 02 100 03 100 04 05 06 07 Q01 Q02 Q03 Q04 Q05 100 100 100 86 25 84 59 93 85 100 100 100 100 100 Andrew |Quiz AndrewQuiz Q06 Andrew Quiz AndrewQuiz Andrew Final Andrew Survey 100 100 100 94 Q07 58 FINAL WS Homework HO1 Homework H02 Homework H03 Homework H044 Homework H05 Homework H06 Homework H07 L01 02 03 04 LO5 06 07 Q01 Q02 Q03 Q04 5 Ava Ava Ava Ava Ava Ava Ava Ava Ava Ava Ava 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 95 84 74. 95 84 Lab Lab Lab Lab Lab Lab Lab Quiz Quiz Quiz Quiz Ava Ava Ava Ava Ava Ava Ava 44. Q05 Q06 Q07 FINAL WS 100 100 100 100 Ava Ava Ava Ava Ava Shane Homework H01 Shane Homework H02 Shane Homework H03 Shane HomeworkH04 Shane Homework H05 Shane Homework H06 Shane HomeworkH07 Shane Lab ShaneLab Shane Lab Shane Lab Shane Lab ShaneLab Shane Lab Shane Quiz ShaneQuiz Shane Quiz Quiz Quiz Quiz Final Survey L01 02 03 04 05 06 07 Q01 Q02 Q03 50 60 70 60 70 80 90 90 0 100 50 40 60 80 70 90 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 ShaneQuiz UIz Shane Quiz ShaneQuiz ShaneQuiz Q04 Q05 Q06 Q07 FINAL WS 100 80 80 80 90 5 100 100 100 100 100 5 UIz ShaneFinal ShaneSurvey Calculate the weighted grade for each student that appears in the data file. You may calculate the grade based on total earned points, divided by total possible points. Or, for 10 points extra credit; Use the weighted totals for this course; available in the syllabus and on the course home page. Output a list of students, their grade as a percentage and a letter grade. For simplicity; use this letter grade scale; A 90grade100 B 80grade= grade