Question: ****************PERL************ Generate a report containing the lowest, highest and average score for each assignment in the data file. The name of the assignment is located

****************PERL************

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;

Name Low High Average WS 5 5 5 H01 19 90 47.80 H02 47 95 74.60 H03 70 95 82.20 H04 46 80 65 H05 54 95 76.60 H06 58 97 80.60 Q01 25 100 74.80 H07 52 90 67 L01 41 91 75 Q03 33 100 66.80 L02 0 100 61.40 Q04 55 100 81 L03 88 100 95.80 FINAL 58 99 85.60 L04 48 100 79.20 Provide the command used to run your script against the data along with your completed awk script. 
NAME Category Assignment Score Possible
Chelsey Homework H01 90 100
Chelsey Homework H02 89 100
Chelsey Homework H03 77 100
Chelsey Lab L01 91 100
Chelsey Lab L02 100 100
Chelsey Lab L03 100 100
Chelsey Quiz Q01 100 100
Chelsey Quiz Q02 100 100
Chelsey Quiz Q03 98 100
Chelsey Final FINAL 82 100
Chelsey Survey WS 5 5
Sam Homework H01 19 100
Sam Homework H02 82 100
Sam Homework H03 95 100
Sam Lab L01 41 100
Sam Lab L02 85 100
Sam Lab L03 99 100
Sam Quiz Q01 91 100
Sam Quiz Q02 85 100
Sam Quiz Q03 33 100
Sam Final FINAL 58 100
Sam Survey WS 5 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!