Task $1(40$ points$)$

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

Q$06779586\mathrm{.}80$

L$05409646\mathrm{.}60$

WS $555$

Q$075810078\mathrm{.}80$

L$06609961$

L$07778664\mathrm{.}80$

H$01199047\mathrm{.}80$

H$02479574\mathrm{.}60$

H$03709582\mathrm{.}20$

H$04468065$

H$05549576\mathrm{.}60$

H$06589780\mathrm{.}60$

Q$012510074\mathrm{.}80$

H$07529067$

Q$028410091\mathrm{.}60$

L$01419175$

Q$033310066\mathrm{.}80$

L$02010061\mathrm{.}40$

Q$045510081$

L$038810095\mathrm{.}80$

FINAL $589985\mathrm{.}60$

Q$05549976\mathrm{.}80$

L$044810079\mathrm{.}20$

Your solution must generate the report using the data file given $($Lab$03-$data.csv Download Lab$03-$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 lab$03$ data file along with your completed awk script.

Task $2(50$ points$)$

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.

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 Lab$03-$data.csv Download Lab$03-$data.csvfile. 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\mathrm{.}21$ C

Chelsey $92\mathrm{.}21$ A

Shane $77\mathrm{.}64$ C

Ava $79\mathrm{.}76$ C

Sam $62\mathrm{.}34$ D

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

Task $3(10$ points$)$

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!