Introduction
SmartGrade is an innovative academic performance analytical system designed to bridge
the gap between raw academic data and actionable insights. It enables educational
institutions and individual students to track performance trends over time, identify areas of
strength and weakness, and make informed decisions to improve learning outcomes.
The system leverages a robust SQL backend for secure and efficient data storage. Power BI
is integrated for dynamic, real-time visualization, transforming complex datasets into
intuitive dashboards and reports.
Project Overview
SmartGrade consists of multiple modules working in tandem: data collection, data
processing, analytics, and reporting. Each module is optimized for seamless interaction,
ensuring users can input, process, and analyze academic records with minimal effort.
Key features include automated data ingestion from student records, customizable
dashboards for different user roles (students, teachers, administrators), and exportable
reports in PDF and Excel formats.
Objective of the Project
- Automate academic performance tracking across multiple subjects and semesters through
a centralized database.
- Provide real-time analytics and visual feedback to students and educators via interactive
dashboards.
- Simplify data management for administrative staff by generating scheduled and on-
demand reports.
- Enhance decision-making through trend analysis, subject-wise comparison, and predictive
insights.
Problem Statement
Many institutions rely on manual processes for recording and analyzing academic results,
resulting in delays, errors, and limited analytical depth. Students often receive feedback
long after exams, reducing the opportunity for timely improvement.
SmartGrade addresses these challenges by automating data workflows, minimizing human
error, and delivering instant, granular insights to all stakeholders.
Feasibility Study
**Technical Feasibility:** The system uses open-source SQL databases and Power BI
Desktop, both widely supported and documented. Integration through ODBC connections
ensures compatibility with existing infrastructure.
**Operational Feasibility:** Staff training sessions are minimal due to intuitive UI design.
The role-based access control ensures clear responsibilities and secure data handling.
System Analysis
**Functional Requirements:**
- User authentication and role management.
- Data entry, validation, and storage.
- Real-time dashboard generation.
- Report scheduling and export functionality.
**Non-Functional Requirements:**
- System uptime of 99.5%.
- Data encryption at rest and in transit.
- Scalability to support up to 10,000 student records per institution.
Scope of the Project
SmartGrade is targeted at secondary and tertiary educational institutions. It can be
extended to include modules for attendance tracking, behavioral analytics, and personalized
study recommendations.
The system is initially desktop-based, with plans for a future mobile app and cloud
deployment to enable remote access.
System Requirements
**Hardware:** Intel i5 processor, 8 GB RAM, 500 GB storage.
**Software:** Windows 10/11, Microsoft SQL Server 2019, Power BI Desktop.
A stable internet connection is required for fetching live data updates and report exports.
Tools & Technologies Used
- Microsoft SQL Server 2019 for database management.
- Power BI Desktop for data visualization.
- Power Query for ETL processes.
- SQL Server Management Studio (SSMS) for database administration.
All tools are installed on local servers. Future cloud migration will use Azure SQL Database
and Power BI Service.
System Design / Architecture
The architecture follows a three-tier model:
1. Presentation Layer (Power BI dashboards).
2. Business Logic Layer (Power Query transformations).
3. Data Layer (SQL Server database).
Data flow is orchestrated using scheduled refreshes in Power BI and stored procedures in
SQL Server for data cleaning and aggregation.
Data Flow Diagrams (DFD)
Level 0 DFD: Shows data entry by users, storage in the database, and visual output
generation.
Level 1 DFD: Breaks down processes into data validation, ETL, analytics, and report
distribution modules.
Data Relationship Diagram (DRD)
The DRD illustrates how students, subjects, and marks tables are interrelated. Primary and
foreign keys maintain data integrity across tables.
Entities: Student, Subject, Marks, UserRole. Relationships: One-to-Many between Student
and Marks; Many-to-Many between UserRole and Permissions.
Entity Relationship Diagram (ERD)
The ERD provides a visual representation of tables and their relationships, including
attributes and cardinalities.
Key entities include STUDENT(Student_ID, Name), SUBJECT(Subject_ID, Name),
MARKS(Mark_ID, Student_ID, Subject_ID, Score).
Database Design
The database schema follows normalization up to 3NF. Tables include STUDENT, SUBJECT,
MARKS, and USERROLE.
Indexes on Student_ID and Subject_ID fields optimize query performance for large datasets.
Modules Description
1. Data Entry Module: GUI form for entering student records and marks.
2. Data Validation Module: Ensures data accuracy through constraints and triggers.
3. Analytics Module: Prepares aggregated datasets for visualization.
4. Reporting Module: Generates PDFs and Excel exports based on user-selected parameters.
Screenshots
Insert screenshots of SQL table structures and Power BI dashboard views here.
Ensure images are clearly labelled and referenced in the text.
Testing
Test Plan: Unit tests for stored procedures, integration tests for ETL pipelines, and user
acceptance testing for dashboard accuracy.
Test Cases: Validate boundary conditions for marks (0–100), role-based access checks, and
data refresh scheduling.
Limitations
The current version does not support real-time streaming of incoming data. Scheduled
refresh intervals may introduce slight delays.
Report customization options are limited to predefined templates in Power BI.
Future Scope
Implement AI-driven predictive analytics to forecast student performance trends and
suggest study plans.
Develop a web portal and mobile app for on-the-go access by students and parents.
Conclusion
SmartGrade successfully demonstrates how combining SQL and Power BI can transform
educational data into meaningful insights, improving decision-making and student
outcomes.
The system is ready for deployment in educational settings, with clear pathways for future
enhancements.
Bibliography
Microsoft SQL Server Documentation. (2024). [Link]
Power BI Documentation. (2024). [Link]
Smith, J. (2023). Data Analytics in Education. Journal of Educational Technology.
Doe, A. (2022). Implementing BI solutions in academia. TechPress.