Task $02(10$ points$)$

Write an awk script that will accept the following input file and output data in the following format. Check the example output carefully, we expect your output to match it EXACTLY.

$\backslash$table$[[$Input file $($lab$\_$d$\_01.$csv$),$Example output$],[$Name$,$Final Grade,Course,George is taking IFT$250.],[$George$,$A$,$IFT$250,$Gus is taking IFT$383.],[$Gus$,$C$,$IFT$383,$Samuel is taking IFT$383.],[$Samuel$,$A$,$IFT$383,$Eric is taking IFT$250.],[$Eric$,$A$,$IFT$250,$Sara is taking IFT$488.],[$Sara$,$E$,$IFT$488,$Catalina is taking IFT$488.],[$Catalina$,$A$,$IFT$488,$Fred is taking IFT$383.],[$Fred$,$D$,$IFT$383,]]$ Task $03(10$ points$)$

Write an awk script that will accept the following input file and output the names of the students with a grade of $A.$ Check the example output carefully, we expect your output to match it EXACTLY.

$\backslash$table$[[$Input file $($lab$\_$d$\_01.$csv$),$Example output$],[$Name$,$Final Grade,Course,These are the students who have an A:$],[$George$,$A$,$IFT$250,$George$],[$Gus$,$C$,$IFT$383,$Samuel$],[$Samuel$,$A$,$IFT$383,$Eric$],[$Eric$,$A$,$IFT$250,$Catalina$],[$Sara$,$E$,$IFT$488,],[$Catalina$,$A$,$IFT$488,],[$Fred$,$D$,$IFT$383,]]$ Task $04(10$ points$)$

Write an awk script that will accept the following input file and output each possible final grade $($A$-$E$)$ followed by a comma and then the number of students who have that exact final grade. Check the example output carefully, we expect your output to match it EXACTLY.

$\backslash$table$[[$Input file $($lab$\_$d$\_01.$csv$),$Expected output of script$],[$Name$,$Final Grade,Course,A$,4],[$George$,$A$,$IFT$250,$B$,0],[$Gus$,$C$,$IFT$383,$C$,1],[$Samuel$,$A$,$IFT$383,$D$,1],[$Eric$,$A$,$IFT$250,$E$,1],[$Sara$,$E$,$IFT$488,],[$Catalina$,$A$,$IFT$488,],[$Fred$,$D$,$IFT$383,]]$Task $05(10$ points$)$

Write an awk script that will take the following input file and process each record based on the keyword in the last field. You will start with $0$ and then either add or subtract the numbers from it$.$ Check the example output carefully, we expect your output to match it EXACTLY.

$\backslash$table$[[$Input file $($lab$\_$d$\_05.$csv$),$Example output$],[1,3,5,8,10,11,54,$ ADD,$92],[1,2,3,4,$ SUB,$-10],[15,18,21,42,37,$ ADD,$133],[1,1,1,0,0,3,16,$ ADD,$22],[4,1,8,0,4,6,13,16,17,20,8,6,4,$ ADD,$107],[13,8,$ SUB,$-21]]$Task $01(10$ points$)$

Write an awk script that will accept the following input file and output the name and final grade fields. Check the example output carefully, we expect your output to match it EXACTLY.

$\backslash$table$[[$Input file $($lab$\_$d$\_01.$csv$),$Example output$],[$Name$,$Final Grade,Course,Name Final Grade$],[$George$,$A$,$IFT$250,$George A$],[$Gus$,$C$,$IFT$383,$Gus C$],[$Samuel$,$A$,$IFT$383,$Samuel A$],[$Eric$,$A$,$IFT$250,$Eric A$],[$Sara$,$E$,$IFT$488,$Sara E$],[$Catalina$,$A$,$IFT$488,$Catalina A$],[$Fred$,$D$,$IFT$383,$Fred D$]]$