1. Engineering
  2. Computer Science
  3. perl calculate the grade for each student that appears in...

Question: perl calculate the grade for each student that appears in...

Question details

**********PERL***********

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 <= 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.csvPreview the document file. No points will be awarded to solutions that are based on copy-pasting the sample output and printing it with awk.

Name    Percent Letter
Chelsey 92.21   A
Sam     62.34   D

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

#NAME? Catehory Assignment Score Possible
Chelsey Homework H01 90 100
Chelsey Homework H02 89 100
Chelsey Homework H03 77 100
Chelsey Lab L01 91 100
Chelsey Lab L02 100 100
Chelsey Lab L03 100 100
Chelsey Quiz Q01 100 100
Chelsey Quiz Q02 100 100
Chelsey Quiz Q03 98 100
Chelsey Final FINAL 82 100
Chelsey Survey WS 5 5
Sam Homework H01 19 100
Sam Homework H02 82 100
Sam Homework H03 95 100
Sam Lab L01 41 100
Sam Lab L02 85 100
Sam Lab L03 99 100
Sam Quiz Q01 91 100
Sam Quiz Q02 85 100
Sam Quiz Q03 33 100
Sam Final FINAL 58 100
Sam Survey WS 5 5
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution