Task 1

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
Q06     77      95      86.80
L05     40      96      46.60
WS      5       5       5
Q07     58      100     78.80
L06     60      99      61
L07     77      86      64.80
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
Q02     84      100     91.60
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
Q05     54      99      76.80
L04     48      100     79.20

Your solution must generate the report using the data file given (Lab03-data.csv). No points will be awarded for solutions that copy-paste the above sample data and use awk to print it to the console. Provide the command used to run your script against the lab03 data file along with your completed awk script.

Task 2

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 = 90 >= grade <= 100
• B = 80 >= grade < 90
• C = 70 >= grade < 80
• D = 60 >= grade < 70
• E = grade < 60

The following sample output has been provided as a guide. Your solution must be based on the data in the Lab03-data.csv file. No points will be awarded to solutions that are based on copy-pasting the sample output and printing it with awk.

Name    Percent Letter
Andrew  75.21   C
Chelsey 92.21   A
Shane   77.64   C
Ava     79.76   C
Sam     62.34   D

Submit your completed script and the awk command needed to run it.

Task 3

Select either Task 1 or Task 2 and write a Bash shell script that takes a file name as an argument. The Bash shell script then uses that file name to run your awk script and sort the results alphabetically, either by assignment name (Task 1) or student name (Task 2). Remember to account for the headers in these outputs. Please don’t forget to do this part, and make sure you use a Bash script!

Deliverables

Use the text box provided, or submit a Word or PDF document containing your solutions to Tasks 1, 2 and 3. You must also include your scripts must be in in .awk format. Screenshots will not be accepted. Your submission must be copyable into a terminal for testing.