DAT 210 Week 4 Process Files using Ruby (2020 New)

The college IT department manager no longer wants to use spreadsheets to calculate grades. The manager has asked you to create a program that will input the teachers’ files and output the students’ grades.  

Write a Ruby program which can be run by typing ruby widgets.rb. The program name must contain your name and week. Example: bobroberts_wk4.rb.

In your Ruby environment, the program must read an input file formatted in CSV format. The file name should contain your name and week #. Example: alicegarcia_wk4.csv. Each record contains data about a student and their corresponding grades.

The data will look similar to the following:

Student Name, assignment 1, assignment 2, assignment 3, assignment 4

Use the following data according to your assigned scenario from week 1

Scenario 1

John Adams, 90, 91, 99, 96

Paul Newman, 90, 92, 93, 88

Mary Smith, 95, 96, 74

Scenario 2

Robert Adams, 85, 91, 99, 66

Paul Wilson, 77, 92, 93, 88

Alice Smith, 65, 96, 74

Scenario 3

Jack Jones, 90, 91, 88, 96

Mary Newman, 90, 99, 93, 88

Jessica McDermott, 85, 96, 84

Be careful to follow the output format exactly, including spacing. The output of your program must look like the following:

Student Assignment Average

John Adams    94.5

Include a program header with your name, date, week # and program purpose.

Compress your files into a ZIP folder with your name and week # in the file name. Do not compress into any format other than .zip.

Review the readings for this week from Ruby on Rails Tutorial if you have additional questions on deploying Ruby applications. 

Submit the ZIP file. Please submit your own work. Submissions that duplicate the submission of another student (comments, formatting, variable names, coding standards, formulas, etc.) are not eligible for credit.