Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

****************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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions