Question

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 named format file.rb, which can be run by typing ruby widgets.rb.

In your Ruby environment, the program must read an input file formatted in CSV format, named input.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

John Adams, 90, 91, 99, 98

Paul Newman, 90, 92, 93, 94

Mary Smith, 95, 96, 99

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

Answer 1

Programm:

OUTPUT:

Code to copy:

# formatfile.rb
require 'CSV'
# print the header for output
puts "%s %s" % ["Student", "Assignment Average"]
# read each row in the data
guests = CSV.foreach('input.csv',headers: true) do |row|
# find the sum of four assignments first
sum=row[1].to_f+row[2].to_f+row[3].to_f+row[4].to_f
# calcualte average
avg=sum/4
# print the name(i.e, row[0]) and
puts "%-11s %.1f"%[row[0],avg]
end

Note:

to read rows by skipping header, set headers: true
to_f converts the value to float value.