Basic Analytics Projects: Grade Analyzer
Grade Analysis
The School Management System project aims to develop a Python-based system for analyzing student, course, and grade data. The system facilitates the loading of data from CSV files, conducts various analyses on the data, and generates comprehensive reports to provide insights into student performance.
Objectives:
Task Description
Load and Analyze Data: The system will load student, course, and grade data from CSV files into memory, allowing for subsequent analysis.
Calculate Class Averages: It will calculate and display the average grade for each course, providing an overview of class performance.
Identify Top-Performing Students: The system will identify and display the top-performing student for each course based on their grades.
Generate Performance Report: It will generate a detailed report of student performance, including class averages, individual grades, and top-performing students, presented in a tabular format.
Step-by-Step Task Description:
Step 1: Project Setup
Create Project Structure:
Create a directory named school_management_analysis.
Inside this directory, create a subdirectory named data.
Inside the data directory, create three CSV files: grades.csv, students.csv, and courses.csv.
CSV File Templates:
grades.csv: student_id,course_id,grade
students.csv: student_id,name,age
courses.csv: course_id,name,credits
Step 2: Implement GradeAnalyzer Service
GradeAnalyzer Class (services/grade_analyzer.py):
Attributes:
grades_file: Path to the grades CSV file.
students_file: Path to the students CSV file.
courses_file: Path to the courses CSV file.
students: Dictionary to store students.
courses: Dictionary to store courses.
grades: List to store grades.
Methods:
__init__(self, grades_file, students_file, courses_file): Initialize the grade analyzer with file paths.
load_data(self): Load data from CSV files.
load_students(self): Load students from the students CSV file.
load_courses(self): Load courses from the courses CSV file.
load_grades(self): Load grades from the grades CSV file.
class_average(self): Calculate and display the class average for each course.
top_students(self): Identify and display the top-performing student for each course.