Question: I need this for Python 5.15 Professor Jiraiya spreadsheet Professor Jiraiya likes to keep the records for his class in a spreadsheet containing a list

 I need this for Python 5.15 Professor Jiraiya spreadsheet Professor Jiraiyalikes to keep the records for his class in a spreadsheet containinga list of student's IDs, names, labs, and scores. Your task is

to help professor Jiraiya build his spreadsheet and calculate the average scoresI need this for Python

5.15 Professor Jiraiya spreadsheet Professor Jiraiya likes to keep the records for his class in a spreadsheet containing a list of student's IDs, names, labs, and scores. Your task is to help professor Jiraiya build his spreadsheet and calculate the average scores of the students per lab and for the whole class We suggest that you create a namedtuple Student to handle the inputs and a list for storing all the students. You may need to use different structures to compute the averages per lab and per class. You first need to read the spreadsheet, student per student. For every student added print the current spreadsheet. For example, when the nput is: 123 John 1 67 132 Paul 1 75 890 George 100 321 Ringo 98 The output is: Do you want to add another student? (Y/N What's his/her ID? What's his/her nane? What's his/her lab? What's his/her score? Current spreadsheet: ID 123 SCORE 67 NAME LAB John Do you ant to add another student? (Y/N What's his/her ID? What's his/her nane? What's his/her lab? What's his/her score? Current spreadsheet: ID 123 132 LAB SCORE 67 75 NAME John Paul Do you ant to add another student? (Y/N) What's his/her ID? What's his/her nane? What's his/her lab? What's his/her score? Current spreadsheet: ID 123 132 890 NAME LAB John Paul George5 SCORE 67 75 100 Do you want to add another student? (/N) What's his/her ID What's his/her nane? What's his/her lab? What's his/her score? Current spreadsheet: ID 123 132 890 321 NAME LAB John Paul George Ringo SCORE 67 75 100 98 Do you vant to add another student?N) The average on Lab 1 is 71.00 The average score on Lab 5 is 100.00 The average score on Lab 2 is 98.00 The average score of the class is 85.00 We will not be testing invalid inputs IDs are always numbers between 3 and 10 digits long. Labs are always numbers between 0 and 10, but there's no order or completeness guaranteed. There may be only students from lab 3 and no students from other labs, for example Scores are in the range between 0 and 100 The scores are printed in ascending order in the summary at the end LAB ACTIVITY 55.1: Professor Jiraiya spreadsheet 0/10 main.py Load default template. 1 printCinputC'Do you want to add another student? CY/ND Run your program as often as you'd like, before submitting for grading. Below, type any needed input values in the first box, then click Run program and observe the program's output in the second box Develop mode mit mode input Enter program input (optional) If your code requires input values, provide them here. Run program Input (from above) main.py (Your program) Output (shown below) Program output displayed here

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!