Question: I need some assistance with this script: Write an awk script which reads the provided data file and outputs the highest and lowest grave, as

I need some assistance with this script: Write an awk script which reads the provided data file and outputs the highest and lowest grave, as well as the average and median grade for the online and onsite sections. Your output should be separated with a single space. Format floating point numbers to 2 decimal places

Input data:

Name,Final Grade,Section

Andrew,95,online

Brandon,100,online

Chelsey,100,onsite

Deborah,72,online

Erik,65,online

Arielle,88,onsite

Shaun,91,onsite

Ninette,82,online

Nguyen,80,onsite

Need output data:

Section Average

online 82.80

onsite 89.75

Highest grade: 100

Lowest grade: 65

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

First Instead of initializing the structure with given data, you will write an input function that reads in the data from a file for one location. Second a data file to be read is name...

Task 01 (10 points) Write an awk script that will take the following data file process each record based on the keyword in the first field. You will start with 0 and then either add or subtract the...

1. Write an awk script that will take the following data file process each record based on the keyword in the first field. You will start with 0 and then either add or subtract the numbers from it....

- DO NOT SEND CODE THAT HAS ALREADY BEEN POSTED ON CHEGG. THOSE ANSWERS DON'T WORK - DO NOT HAVE COMMENTS IN THE CODE - WRITE CODE IN JAVA Objectives This is one of two major programming projects...

Lab D - AWK 100 lab points possible - 7 graded tasks (Rev. FA 2023) Introduction This lab assignment will assess what you have learned from the module's learning materials. Ensure that your distro is...

Task 1 ( 4 0 points ) 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...

What I have so far from the previous project: ********************************************************************************* Song.java...

Programming Assignment 5 Note: When you turn in an assignment to be graded in this class you are making the claim that you neither gave nor received assistance on the work you turned in (except, of...

PROJECT 2 INSTRUCTIONS BELOW (THIS IS FOR REFERENCE, THERE'S NO NEED TO HELP WITH PROJECT 2 SINCE IT IS ALREADY OVER) Programming Assignment 3 Note: When you turn in an assignment to be graded in...

Should male managers wear a tie during the workday to command respect and demonstrate professionalism? Suppose a measurement scale has been developed that generates a management professionalism...

The policies of the Malaysian government that would encourage and contribute towards international business are (GIVE 5 policies and explanation with example)

As a financial counselor, you have selected to utilze "time zero problem solving approach for jane and connor, Explain why this approach could be effective for the clinets

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

How do Data Types perform data validation?

How does Referential Integrity work?

What are Dimensional Relational Databases designed to hold primarily?