Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Unix Calculate the weighted grade for each student that appears in the data file. Use the weighted totals for this course; available in the syllabus

Unix

Calculate the weighted grade for each student that appears in the data file. 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 grades.txt file.

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

grades.txt

Student,Catehory,Assignment,Score,Possible Chelsey,Homework,H01,90,100 Chelsey,Homework,H02,89,100 Chelsey,Homework,H03,77,100 Chelsey,Homework,H04,80,100 Chelsey,Homework,H05,82,100 Chelsey,Homework,H06,84,100 Chelsey,Homework,H07,86,100 Chelsey,Lab,L01,91,100 Chelsey,Lab,L02,100,100 Chelsey,Lab,L03,100,100 Chelsey,Lab,L04,100,100 Chelsey,Lab,L05,96,100 Chelsey,Lab,L06,80,100 Chelsey,Lab,L07,81,100 Chelsey,Quiz,Q01,100,100 Chelsey,Quiz,Q02,100,100 Chelsey,Quiz,Q03,98,100 Chelsey,Quiz,Q04,93,100 Chelsey,Quiz,Q05,99,100 Chelsey,Quiz,Q06,88,100 Chelsey,Quiz,Q07,100,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,Homework,H04,46,100 Sam,Homework,H05,82,100 Sam,Homework,H06,97,100 Sam,Homework,H07,52,100 Sam,Lab,L01,41,100 Sam,Lab,L02,85,100 Sam,Lab,L03,99,100 Sam,Lab,L04,99,100 Sam,Lab,L05,0,100 Sam,Lab,L06,0,100 Sam,Lab,L07,0,100 Sam,Quiz,Q01,91,100 Sam,Quiz,Q02,85,100 Sam,Quiz,Q03,33,100 Sam,Quiz,Q04,64,100 Sam,Quiz,Q05,54,100 Sam,Quiz,Q06,95,100 Sam,Quiz,Q07,68,100 Sam,Final,FINAL,58,100 Sam,Survey,WS,5,5 Andrew,Homework,H01,25,100 Andrew,Homework,H02,47,100 Andrew,Homework,H03,85,100 Andrew,Homework,H04,65,100 Andrew,Homework,H05,54,100 Andrew,Homework,H06,58,100 Andrew,Homework,H07,52,100 Andrew,Lab,L01,87,100 Andrew,Lab,L02,45,100 Andrew,Lab,L03,92,100 Andrew,Lab,L04,48,100 Andrew,Lab,L05,42,100 Andrew,Lab,L06,99,100 Andrew,Lab,L07,86,100 Andrew,Quiz,Q01,25,100 Andrew,Quiz,Q02,84,100 Andrew,Quiz,Q03,59,100 Andrew,Quiz,Q04,93,100 Andrew,Quiz,Q05,85,100 Andrew,Quiz,Q06,94,100 Andrew,Quiz,Q07,58,100 Andrew,Final,FINAL,99,100 Andrew,Survey,WS,5,5 Ava,Homework,H01,55,100 Ava,Homework,H02,95,100 Ava,Homework,H03,84,100 Ava,Homework,H04,74,100 Ava,Homework,H05,95,100 Ava,Homework,H06,84,100 Ava,Homework,H07,55,100 Ava,Lab,L01,66,100 Ava,Lab,L02,77,100 Ava,Lab,L03,88,100 Ava,Lab,L04,99,100 Ava,Lab,L05,55,100 Ava,Lab,L06,66,100 Ava,Lab,L07,77,100 Ava,Quiz,Q01,88,100 Ava,Quiz,Q02,99,100 Ava,Quiz,Q03,44,100 Ava,Quiz,Q04,55,100 Ava,Quiz,Q05,66,100 Ava,Quiz,Q06,77,100 Ava,Quiz,Q07,88,100 Ava,Final,FINAL,99,100 Ava,Survey,WS,5,5 Shane,Homework,H01,50,100 Shane,Homework,H02,60,100 Shane,Homework,H03,70,100 Shane,Homework,H04,60,100 Shane,Homework,H05,70,100 Shane,Homework,H06,80,100 Shane,Homework,H07,90,100 Shane,Lab,L01,90,100 Shane,Lab,L02,0,100 Shane,Lab,L03,100,100 Shane,Lab,L04,50,100 Shane,Lab,L05,40,100 Shane,Lab,L06,60,100 Shane,Lab,L07,80,100 Shane,Quiz,Q01,70,100 Shane,Quiz,Q02,90,100 Shane,Quiz,Q03,100,100 Shane,Quiz,Q04,100,100 Shane,Quiz,Q05,80,100 Shane,Quiz,Q06,80,100 Shane,Quiz,Q07,80,100 Shane,Final,FINAL,90,100 Shane,Survey,WS,5,5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Oracle Solaris 11 System Administration

Authors: Bill Calkins

1st Edition

0133007170, 9780133007176

Students also viewed these Databases questions