Write a program that reads the student information from a comma separated values (csv) file. The program then creates a text file that records the course grades of the students. Each row of the file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and the Final score of a student each separated by a comma. A sample of the student information is provided in StudentInfo.txt. Assume the number of students is at least 1 and at most 20. The program performs the following tasks: • Read the file name of the file from the user. • Open the text file and read the student information. • Compute the average exam score of each student. Assign a letter grade to each student based on the average exam score in the following scale: o A: 90 =< x o B: 80 =< x < 90

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

In python please

14.5 LAB^: Course Grade
Write a program that reads the student information from a comma separated values (csv) file. The program then creates a text file that
records the course grades of the students. Each row of the file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and
the Final score of a student each separated by a comma. A sample of the student information is provided in Studentlnfo.txt. Assume the
number of students is at least 1 and at most 20. The program performs the following tasks:
• Read the file name of the file from the user.
Open the text file and read the student information.
Compute the average exam score of each student.
Assign a letter grade to each student based on the average exam score in the following scale:
o A: 90 =< x
o B: 80 =< x < 90
o C: 70 =< x < 80
o D: 60 =< x < 70
o F:x< 60
• Compute the average of each exam.
• Output the last names, first names, exam scores, and letter grades of the students into a text file named report.txt. Output one
student per row and separate the values with a tab character.
• Output the average of each exam, with two digits after the decimal point, at the end of report.txt. Hint: Use the precision sub-specifier
to format the output.
Ex: If the input of the program is:
StudentInfo.txt
and the contents of Studentlnfo.txt are:
Barrett,Edan,70,45,59
Bradshaw, Reagan, 96,97,88
Charlton, Caius,73,94, 80
Mayo, Tyrese, 88,61,36
Stern, Brenda,90,86,45
the file report.txt should contain:
Barrett
Edan
70
45
59 F
Bradshaw
Reagan
96
97
88
A
Charlton
Caius
73
94
80
B
Mayo
Tyrese
88
61
36 D
Stern
Brenda
06
86
45
Averages: Midterm1 83.40, Midterm2 76.60, Final 61.60
Transcribed Image Text:14.5 LAB^: Course Grade Write a program that reads the student information from a comma separated values (csv) file. The program then creates a text file that records the course grades of the students. Each row of the file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and the Final score of a student each separated by a comma. A sample of the student information is provided in Studentlnfo.txt. Assume the number of students is at least 1 and at most 20. The program performs the following tasks: • Read the file name of the file from the user. Open the text file and read the student information. Compute the average exam score of each student. Assign a letter grade to each student based on the average exam score in the following scale: o A: 90 =< x o B: 80 =< x < 90 o C: 70 =< x < 80 o D: 60 =< x < 70 o F:x< 60 • Compute the average of each exam. • Output the last names, first names, exam scores, and letter grades of the students into a text file named report.txt. Output one student per row and separate the values with a tab character. • Output the average of each exam, with two digits after the decimal point, at the end of report.txt. Hint: Use the precision sub-specifier to format the output. Ex: If the input of the program is: StudentInfo.txt and the contents of Studentlnfo.txt are: Barrett,Edan,70,45,59 Bradshaw, Reagan, 96,97,88 Charlton, Caius,73,94, 80 Mayo, Tyrese, 88,61,36 Stern, Brenda,90,86,45 the file report.txt should contain: Barrett Edan 70 45 59 F Bradshaw Reagan 96 97 88 A Charlton Caius 73 94 80 B Mayo Tyrese 88 61 36 D Stern Brenda 06 86 45 Averages: Midterm1 83.40, Midterm2 76.60, Final 61.60
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Function Arguments
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education