Question

Wk 4 - Write a Ruby Program (due Mon] Assignment Content The college IT department manager no longer wants to use spreadsheets to calculate grades. Instead, 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

solution:

Given data:

Code :

require 'csv'   #required to read the data in csv file

table = CSV.parse(File.read("input.csv"), headers: true)   # reads a file input.csv and creates a table of data

puts "Student Assignment Average"   #output line as described in question
$i = 0   #will be used for iterating the table
$length = table.length()   #stores number of students in table
$assignments = table[0].length()-1   #stores number of assignments

while $i < $length do   #loop over each student record
   $j = 0  
   $sum = 0.0   #initilize sum to 0.0
   while $j < $assignments do   #loop over each assignment of a particular student
       $sum = $sum + (table[$i][$j+1]).to_f   #add the grade to sum
       $j += 1
   end
   puts table[$i][0] + " " + (($sum/$assignments).round(1)).to_s   #display name and average grade of students
   $i +=1
end

Code screenshot :

1 require csy! #required to read the data in csv file table = CSV.parse (File.read("input.csv"), headers: true) # reads a file input.csv and creates a table of data puts "Student Assignment Average" #output line as described in question $i = 0 #will be used for iterating the table $length = table.length() #stores number of students in table Şassignments = table[0] .length()-1 #stores number of assignments 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Çwhile $i < $length do #loop over each student record $j - 0 $sum = 0.0 #initilize sum to 0.0 A while $j < $assignments do #loop over each assignment of a particular student $sum = $sum + (table[$i] [$]+1]).to_f #add the grade to sum $j += 1 end puts table [Si] [O] + (($sum/$assignments).round(1)).to_s #display name and average grade of students $i =1 -end

input file :

1 2 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, 90 3 4

output screenshot :

>ruby widgets.rb Student Assignment Average John Adams 94.5 Paul Newman 92.3 Mary Smith 95.0

thank you .....................

please give me thumb up