Make a python program that peruses the understudy data from a tab isolated values (tsv) record. The python program then, at that point, must makes a text document that will records the course grades of the understudies. Each line of the tsv record contains the Last Name, First Name, Midtrm1 score, Midtrm2 score, and the Last score of an understudy. An example of the understudy data is given in StudentInfoScore.tsv. Accept the quantity of understudies is somewhere around 1 and at generally 20. The program plays out the accompanying undertakings: Peruse the record name of the tsv document from the client. Open the tsv record and read the understudy data. Register the typical test score of every understudy. Dole out a letter grade to every understudy in light of the typical test score in the accompanying scale: A: 90 =< X B: 80 < x < 90 C: 70 < x < 80 D: 60 < x < 70 F: x < 60 Figure the normal of every test. Yield the last names, first names, test scores, and letter grades of the understudies into a text record named report.txt. Yield one understudy for each line and separate the qualities with a tab character. Yield the normal of every test, with two digits after the decimal point, toward the finish of report.txt. Answer: Utilize the arrangement detail to set the accuracy of the result.

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

 

 

 

resu
GIVEN "StudentInfoScore.tsv":
Brenda Edan 70 45 59
Brad Reagan 96 97 88
Charlotte Caius 73 94 80
Maria Tyrese 88 61 36
Steven Brenda 90 86 45
Should Result "Student Report.txt"
Brenda Edan 70 45 59 F
Brad Reagan 96 97 88 A
Charlotte Caius 73 94 80 B
Maria Tyrese 88 61 36 D
Steven Brenda 90 86 45 C
Midpoints: midtrm1 83.40, midtrm2 76.60, last 61.60
Transcribed Image Text:resu GIVEN "StudentInfoScore.tsv": Brenda Edan 70 45 59 Brad Reagan 96 97 88 Charlotte Caius 73 94 80 Maria Tyrese 88 61 36 Steven Brenda 90 86 45 Should Result "Student Report.txt" Brenda Edan 70 45 59 F Brad Reagan 96 97 88 A Charlotte Caius 73 94 80 B Maria Tyrese 88 61 36 D Steven Brenda 90 86 45 C Midpoints: midtrm1 83.40, midtrm2 76.60, last 61.60
PYTHON
If it's not too much trouble, Likewise Offer CODE THROUGH
Connection: online-python(dot)com
Likewise screen capture code with right space
Make a python program that peruses the understudy data
from a tab isolated values (tsv) record. The python
program then, at that point, must makes a text document
that will records the course grades of the understudies.
Each line of the tsv record contains the Last Name, First
Name, Midtrm1 score, Midtrm2 score, and the Last score of
an understudy. An example of the understudy data is given
in StudentInfoScore.tsv. Accept the quantity of
understudies is somewhere around 1 and at generally 20.
The program plays out the accompanying undertakings:
Peruse the record name of the tsv document from the
client.
Open the tsv record and read the understudy data.
Register the typical test score of every understudy.
Dole out a letter grade to every understudy in light of the
typical test score in the accompanying scale:
A: 90 =< X
B: 80
C: 70
D: 60
F: x < 60
Figure the normal of every test.
Yield the last names, first names, test scores, and letter
grades of the understudies into a text record named
< x < 90
< x < 80
< x < 70
report.txt. Yield one understudy for each line and separate
the qualities with a tab character.
Yield the normal of every test, with two digits after the
decimal point, toward the finish of report.txt. Answer:
Utilize the arrangement detail to set the accuracy of the
result.
GIVEN "StudentInfoScore.tsv":
Brenda Edan 70 45 59
Transcribed Image Text:PYTHON If it's not too much trouble, Likewise Offer CODE THROUGH Connection: online-python(dot)com Likewise screen capture code with right space Make a python program that peruses the understudy data from a tab isolated values (tsv) record. The python program then, at that point, must makes a text document that will records the course grades of the understudies. Each line of the tsv record contains the Last Name, First Name, Midtrm1 score, Midtrm2 score, and the Last score of an understudy. An example of the understudy data is given in StudentInfoScore.tsv. Accept the quantity of understudies is somewhere around 1 and at generally 20. The program plays out the accompanying undertakings: Peruse the record name of the tsv document from the client. Open the tsv record and read the understudy data. Register the typical test score of every understudy. Dole out a letter grade to every understudy in light of the typical test score in the accompanying scale: A: 90 =< X B: 80 C: 70 D: 60 F: x < 60 Figure the normal of every test. Yield the last names, first names, test scores, and letter grades of the understudies into a text record named < x < 90 < x < 80 < x < 70 report.txt. Yield one understudy for each line and separate the qualities with a tab character. Yield the normal of every test, with two digits after the decimal point, toward the finish of report.txt. Answer: Utilize the arrangement detail to set the accuracy of the result. GIVEN "StudentInfoScore.tsv": Brenda Edan 70 45 59
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Computational Systems
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.
Similar questions
  • SEE MORE QUESTIONS
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