Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Introduction In this lab, you will be re-implementing your solution from Lab 3 in Perl. Use toyr Lab 3 submission to aid you in building

Introduction In this lab, you will be re-implementing your solution from Lab 3 in Perl. Use toyr 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.

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;

image text in transcribedYour solution must generate the report using the data file given (Lab03-data.csvimage text in transcribed). No points will be awarded for solutions that copy-paste the above sample data and use awk to print it to the console. Provide the command used to run your script against the lab03 data file along with your completed awk 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.csvimage text in transcribed file. No points will be awarded to solutions that are based on copy-pasting the sample output and printing it with awk.

image text in transcribed

Lab03-data.csv FILE (couldn't load file so here are screenshots of the file)

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

8862 668 8682 74256047156115569 786787697668987 6 6 0 09605505700010000990 H995-98999899-9191111991 0 0 0 156 58848 74556714745525843058554 80797064852413 m65 a00S00000000000000000-00 NQLWQLLHHHHHHQHQLQLQLFQL 767123456172-3243N54 Name Percent Letter Andrew 75.21 C Chelsey 92.21A Shane 77.64 C Ava 79.76 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 8862 668 8682 74256047156115569 786787697668987 6 6 0 09605505700010000990 H995-98999899-9191111991 0 0 0 156 58848 74556714745525843058554 80797064852413 m65 a00S00000000000000000-00 NQLWQLLHHHHHHQHQLQLQLFQL 767123456172-3243N54 Name Percent Letter Andrew 75.21 C Chelsey 92.21A Shane 77.64 C Ava 79.76 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

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

Database Concepts

Authors: David M. Kroenke, David J. Auer

7th edition

133544621, 133544626, 0-13-354462-1, 978-0133544626

More Books

Students also viewed these Databases questions

Question

1. Explain reasons for rules.

Answered: 1 week ago