Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a python assignment. Read a CSV file called grades.c sv Download grades.csv. Part 1. Print the file line by line. Each student has

This is a python assignment.

Read a CSV file called grades.csv Download grades.csv.

image text in transcribed

Part 1. Print the file line by line. Each student has two courses. The grade for each course has 50% for homework, 20% midterm, and 30% for the final exam. Calculate the final grade of each course. Create a text file called 'gpa.txt' and write the name of the student and their GPA in that file.

Part 2. Create a nested dictionary called records where each student is a key. Each student is a dictionary that has multiple courses. Each course is a key in the student dictionary. Each course is a dictionary containing key homework: which is a list, midterm:, and final:

We need to create the dictionary records and fill it in by the content of grades.csv Download grades.csv.

Part 3. Give the user the ability to search the records for data of a student by printing their courses and grades. Prompt the user: Type in student name. If no match: student not in our records.

Part 4. Give the user the ability to search or add a student. Prompt the user: 1: search for a student, 2: add a student.' For option 1 if no match, the student is not in our records'. For option 2 if the student is in the record: student already in the records.

Part 5. Give the user the ability to search or add a student. When adding the student, if the name is new, ask the user to add a course, then ask them to add homework grades, then midterm, and final scores.

Part 6. Give the user the ability to modify a students record. Should follow the prompts shown below. First, the user sees the four options on the left. The user enters a number between 1 and 4. Based on the user's choice, another prompt appears. For example, if the initial choice of the user is 2, then we do as we did in part 5. If the user's choice is 3, then another prompt of 5 choices will appear.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Conceptual Database Design An Entity Relationship Approach

Authors: Carol Batini, Stefano Ceri, Shamkant B. Navathe

1st Edition

0805302441, 978-0805302448

More Books

Students also viewed these Databases questions

Question

Ty e2y Evaluate the integral dy

Answered: 1 week ago

Question

What is the Definition for Third Normal Form?

Answered: 1 week ago

Question

Provide two examples of a One-To-Many relationship.

Answered: 1 week ago