Student Records Management

**Student Records Management System – Microsoft Excel**

Designed and developed a comprehensive student records management system for a college using Microsoft Excel. The project managed data for 200 students, including personal information, departments, academic levels, course grades, and attendance records.

Created automated formulas to calculate total marks, average scores, pass/fail status, letter grades, and student rankings. Built a management report to summarize key performance indicators such as pass rates, subject performance, attendance statistics, and grade distribution.

**Key Skills Used:**

* Microsoft Excel

* Data Entry & Data Management

* Data Analysis

* SUM, AVERAGE, IF, AND, IFS, COUNTIF, MAX, MIN, RANK.EQ

* Percentage Calculations

* Report Generation

* Data Organization and Validation