ASU Building an Identical Solution in Perl Scripting Language Programming Task

In this lab, you will be re-implementing your solution from Lab 3 in Perl. Use your Lab 3 submission to aid you in building an identical solution in the Perl scripting language.

The data file and requested outputs are the same. The extra credit opportunity is also the same as Lab 3.

Task 1

Generate a report containing the lowest, highest and average scorefor each assignment in the data file. The name of the assignment islocated in column 3. Your report should be in a tabular format as shownin 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 abovesample data and use Perl to print it to the console. Provide the commandused to run your script against the lab03 data file along with yourcompleted Perl script. If you do not include your Perl script file you will recieve an automatic 0.

Task 2

Calculate the grade for each student that appears in the data file.You may calculate the grade based on total earned points, divided bytotal 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 Perl.

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 Perl command needed to run it. If you do not include your Perl script file you will recieve an automatic 0.

Task 3

Select either Task 1 or Task 2 and write a shell script that takes adata file name as an argument. The shell script then uses that file nameto run your Perl script and sort the resultsalphabetically, 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 it’s a Bash script!

Deliverables

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