Solutions in Perl scripting language.***** NOT AWK

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;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 Perl to print it to the console. Provide the command used to run your script against the lab03 data file along with your completed Perl script.

PART II

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

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 Perl.

***Provide your completed script and the Perl command needed to run it.***

PART III

Select either Task 1 or Task 2 and write a shell script that takes a data file name as an argument. The shell script then uses that file name to run your Perl 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.

HERE IS WHATS IN THE FILE(NOT ABLE TO UPLAOD FILE "Lab03-data.csv"

NameLow 006 77 High Average 95 96 86.80 46.60 05 40 WS 78.80 61 64.80 47.80 74.60 82.20 65 76.60 80.60 74.80 67 91.60 75 66.80 61.40 81 95.80 85.60 76.80 79.20 100 007 58 06 07 H01 H02 H03 H04 H05 H06 001 25 H07 002 84 L01 003 33 L02 004 55 03 FINAL 58 00554 L04 60 86 90 95 95 80 95 97 100 90 100 91 100 100 100 100 19 47 70 46 54. 58 52 41 48 100 Name Percent Letter Andrew 75.21 C Chelsey 92.21 A Shane 77.64 C Ava 79.76 C Sam 62.34 D Student Catehory Assignment Score Possible 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 Chelsey HomeworkH01 Chelsey HomeworkH02 ChelseyHomework H03 Chelsey Homework H04 Chelsey Homework H05 Chelsey Homework H06 Chelsey Homework H07 L01 02 LO3 04 05 LO6 L07 Q01 Q02 Q03 Q04 Q05 Q06 Q07 90 89 80 82 84 86 91 100 100 100 96 80 ChelseyLab ChelseyLab ChelseyLab ChelseyLab ChelseyLab ChelseyLab ChelseyLab Chelsey Quiz Chelsey Quiz Chelsey Quiz Chelsey Quiz Chelsey Quiz Chelsey Quiz Chelsey Quiz Chelsey Final 100 100 98 93 100 FINAL 82 Chelsey Survey WS 5 5 100 Homework HO1 Sam Sam Sam Sam Sam Sam Sam Sam Sam Sam Sam Sam Sam Sam Sam Sam Sam 82 95 46 82 97 52 100 Homework H02 Homework H03 Homework H04 Homework H05 Homework H06 Homework H07 LO1 02 03 04 05 06 07 Lab Lab Lab Lab Lab Lab Lab Quiz Quiz Quiz Quiz Quiz Quiz Quiz Final 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 85 91 Q01 Q02 Q03 Q04 Q05 Q06 Q07 FINAL 85 64 54 95 68 58 Sam Sam Sam Sam Sam 100 100 100 Sam Andrew HomeworkH01 Andrew Homework H02 Andrew HomeworkH03 Andrew HomeworkH04 Andrew Homework H05 Andrew Homework H06 Andrew HomeworkH07 Andrew Lab Andrew Lab Andrew Lab Andrew Lab Andrew Lab Andrew Lab Andrew Lab Andrew Quiz Andrew Quiz Andrew Quiz Andrew Quiz Andrew Quiz Andrew Quiz Andrew Quiz Andrew Final Survey WS L01 02 03 04 05 06 07 Q01 Q02 Q03 Q04 Q05 Q06 Q07 FINAL 5 25 47 85 65 54 58 52 87 45 92 48 42 5 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 86 25 84 59 93 85 94 58 WS Andrew Survey 100 Homework HO1 Ava Ava Ava Ava Ava Ava Ava Ava Ava Ava Ava 100 100 100 100 100 100 100 100 100 100 100 95 84 74 95 84 Homework H02 Homework H03 Homework H04 Homework H05 HomeworkH06 HomeworkH07 L01 02 03 04 Lab Lab Lab Lab Lab Lab Lab Quiz Quiz Quiz Quiz Quiz 05 06 07 Q01 Q02 Q03 Q04 Q05 Q06 Q07 FINAL Ava 100 Ava 100 Ava Ava Ava Ava Ava Ava Ava Ava Ava 100 100 100 100 100 100 100 100 Quiz Quiz Final Ava Shane Homework H01 Shane HomeworkH02 Shane Homework H03 Shane Homework H04 Shane HomeworkH05 Shane Homework H06 Shane Homework H07 Shane Lab Shane Lab Shane Lab Shane Lab Shane Lab Shane Lab Shane Lab Shane Quiz Shane Quiz ShaneQuiz Shane Quiz Shane Quiz ShaneQuiz Shane Quiz Shane Final Survey WS L01 02 03 04 05 06 07 Q01 Q02 Q03 Q04 Q05 Q06 Q07 FINAL 50 60 70 60 70 80 90 90 0 100 50 40 60 80 70 90 100 100 80 80 80 90 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 Shane Survey WS 5 5