Question: Create a folder named 'GradeAnalysis'. Inside this folder, create a new CSV file called 'student _ data.csv ' with data for at least 1 5

Create a folder named 'GradeAnalysis'.
Inside this folder, create a new CSV file called 'student_data.csv' with data for at least 15 students.
'''
#CSV Data Requirements
#The CSV should include the following column headers:
'''
first_name
last_name
student_id
homework_1, homework_2, homework_3, homework_4**
exam_1, exam_2, midterm_exam, final_exam**
Fill in the table with arbitrary names, student IDs, and realistic scores (values from 0-100).
'''
#Write a New Python Program: 'grade_statistics.py'
#Save the program in the 'GradeAnalysis' folder.
#Assignment Tasks
'''
Implement code to complete the following tasks:
a.
Load the CSV File
Import the data from the CSV file.
Print each student's full name and student ID for verification.
b.
Calculate Mean Scores
Calculate and print the mean (average) score for each student.
Display the full name, student ID, and mean score for each student.
c.
Identify Top and Bottom Performers
Identify the student with the highest average score and the student with the lowest average score.
Print these students' full names, student IDs, and average scores.
d.
Calculate Class-Wide Statistics
Calculate the class average for each assessment type (homeworks and exams).
Print these averages, identifying them by assessment type (Homework 1 Average: 76.2, etc.).
e.
Grade Distribution
Implement code to categorize each students mean score into letter grades:
'A'(90-100),'B'(80-89),'C'(70-79),'D'(60-69),'F'(below 60). YOU'VE DONE THIS BEFORE!!!
Print each student's full name, student ID, mean score, and letter grade.
'''
#Output Requirements
'''
Organize the output for clarity, with labels for each section (Top Performer, Class Averages, Grade Distribution).
Hints:
Use the 'csv' module to read data from the CSV file.
Skip the header row when processing data.
You may find it helpful to store scores in lists to calculate averages and distributions efficiently.
This assignment can be written in about 20-25 lines of code, depending on your approach.

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 Programming Questions!