Consider the file roster

The format is:

"student ID","Posting ID","First Name","Last Name","Units","Grading Scale","School Major","Academic Level","ASURITE","Residency"

Create an awk script named exam.awk that will output a header of the field names shown below and each of the entries in the following format:

Last Name:First Name:Student ID:School Major:Academic Level:ASURITE:Email

With the Email field of the following format:

In addition to this, your script will display the number of students in the IT program and in each of the academic levels

The script will run from the command prompt using the following command:

awk f exam.awk classroster

"1209480997","0997-464","Anthony","Alvarado","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","aalvar33","Non-Resident", "1201390350","0350-574","Gibran","Alvarez","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","galvare2","Resident", "1000746988","6988-522","Glen","Angus","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","gangus","Non-Resident", "1207146326","6326-608","Cole","Ashby","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","cashby","Non-Resident", "1000548822","8822-019","Allan","Bailey","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","asu41981","Resident", "1208428789","8789-773","Rudy","Barron","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","rrbarron","Non-Resident", "1208427112","7112-644","Jeffrey","Box","3","Standard","Ira A Fulton Engineering - Information Technology","Post-Bacc Undergraduate","jabox1","Non-Resident", "1206996878","6878-146","Nicholas","Burden","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","nbburden","Non-Resident", "1200663364","3364-155","Kurtis","Camiliere","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","kcamilie","Resident", "1000830925","0925-792","Michael","Camp","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","mcamp1","Resident", "1000727027","7027-763","Robert","Carleton","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","rcarleto","Resident", "1001460822","0822-945","Dustin","Cartwright","3","Standard","Ira A Fulton Engineering - Tech Entrepreneurship & Mgmt","Senior","dbcartwr","Resident", "1201860560","0560-486","John","Cook","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","jrcook7","Resident", "1207331615","1615-810","Thomas","Debiasio","3","Standard","Ira A Fulton Engineering - Software Engineering","Post-Bacc Undergraduate","tdebiasi","Non-Resident", "1208487705","7705-285","Jason","Dixon","3","Standard","Ira A Fulton Engineering - Software Engineering","Junior","jadixon5","Non-Resident", "1207627963","7963-539","Jose","Fernandez","3","Standard","Ira A Fulton Engineering - Information Technology","Post-Bacc Undergraduate","jlferna4","Non-Resident", "1207103803","3803-346","Hunter","Hale","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","hehale","Non-Resident", "1207033252","3252-936","Thane","Heisey","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","theisey","Non-Resident", "1000527662","7662-261","Jeremy","Hoyle","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","jhoyle","Resident", "1201654029","4029-669","Parker","Jardine","3","Standard","Ira A Fulton Engineering - Information Technology","Post-Bacc Undergraduate","pjardine","Resident", "1000745321","5321-390","Joshua","Johnson","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","jrjohnso","Resident", "1207997618","7618-802","Chinmingnon","Kone","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","cdkone","Non-Resident", "1208084926","4926-464","Angela","Kronk","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","akronk","Resident", "1205846053","6053-462","Alfonso","Lara","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","alara8","Resident", "1000795984","5984-706","Joseph","Larkin","3","Standard","Ira A Fulton Engineering - Information Technology","Sophomore","jmlarkin","Resident", "1000066932","6932-977","Matthew","Mairel","3","Standard","Ira A Fulton Engineering - Software Engineering","Senior","mrmairel","Non-Resident", "1208396874","6874-323","Christopher","Mandich","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","cmandich","Non-Resident", "1208121079","1079-232","Adam","Martin","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","amart133","Non-Resident", "1208526926","6926-293","Jermaine","Martin","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","jamart77","Resident", "1000452448","2448-531","Lawrence","Merry","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","ldmerry","Resident", "1208590067","0067-143","Willard","Moebest","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","wmoebest","Non-Resident", "1205879060","9060-704","Parsa","Nikpour","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","pnikpour","Resident", "1206928927","8927-936","Roger","Peck","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","repeck1","Resident", "1207841371","1371-850","Viet","Phan","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","vphan1","Non-Resident", "1202761009","1009-255","Jason","Pototsky","3","Standard","Ira A Fulton Engineering - Software Engineering","Post-Bacc Undergraduate","jpototsk","Resident", "1208697460","7460-388","Edmundo","Quinonez","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","eaquinon","Non-Resident", "1205374231","4231-451","Oscar","Reynoso","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","oreynoso","Resident", "1203404028","4028-294","Nader","Sabra","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","nsabra","Resident", "1206879397","9397-136","Rachel","Santillan","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","rsantil2","Resident", "1000210357","0357-675","Kelly","Simer","3","Standard","Ira A Fulton Engineering - Software Engineering","Post-Bacc Undergraduate","kjsimer","Non-Resident", "1207060162","0162-993","Dong","Ta","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","ddta1","Non-Resident", "1208456128","6128-872","Herman","Touchin","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","htouchin","Non-Resident", "1208475927","5927-379","Matthew","Trembly","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","mtrembly","Non-Resident", "1208804125","4125-564","Maria","Wilder","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","mwilder1","Non-Resident", "1208661515","1515-630","Demetrice","Williams","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","dwilli50","Non-Resident", "1202321098","1098-602","Kevin","Williams","3","Standard","Ira A Fulton Engineering - Information Technology","Senior","kmwill12","Non-Resident", "1207010528","0528-189","Erik","Willis","3","Standard","Ira A Fulton Engineering - Information Technology","Junior","ewillis3","Non-Resident",