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 'studentdata.csv with data for at least students.
#CSV Data Requirements
#The CSV should include the following column headers:
firstname
lastname
studentid
homework homework homework homework
exam exam midtermexam, finalexam
Fill in the table with arbitrary names, student IDs, and realistic scores values from
#Write a New Python Program: 'gradestatistics.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 ClassWide Statistics
Calculate the class average for each assessment type homeworks and exams
Print these averages, identifying them by assessment type Homework Average: etc.
e
Grade Distribution
Implement code to categorize each students mean score into letter grades:
ABCDFbelow 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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
