PART A
Lesson 1 — Course Overview
Welcome to this course.
In this course, you will learn how to build a complete School Result Management
System using modern programming and web technologies.
Many schools still manage student results manually.
Teachers often collect marks from different subjects, calculate totals and averages by
hand, and prepare report cards one student at a time.
This process can be slow, repetitive, and prone to errors.
In this course, we will solve that problem by building an automated system that
manages student results efficiently.
We will develop a web-based application where teachers can enter student marks
through an easy-to-use interface, and the system will automatically process the
results and generate academic reports.
To build this system, we will use several powerful technologies.
Our backend logic will be written in Python, a popular programming language used
for automation, data processing, and web development. Make sure you have
installed it in your computer.
We will use Flask as our web framework to create the application server that handles
requests from users.
For storing and managing student data, we will use Google Sheets, which will act as
our cloud-based database.
On the frontend, we will design the user interface using HTML, CSS, and JavaScript.
By the end of this course, you will have built a fully working system that can:
• Allow teachers to log into the system
• Automatically retrieve student names using their student ID numbers
• Record subject scores through a web interface
• Update marks directly in Google Sheets
,• Automatically calculate totals, averages, and results
• Generate professional PDF progress reports for students
This project closely simulates a real school management system used in
production environments.
More importantly, it will help you understand how different technologies work
together to build practical, real-world software systems.
In the next lesson, we will explore how the entire system works and look at the
workflow of the application.
Lesson 2 — How the System Works
Before we begin writing code, it is important to understand how the entire system
works.
In this lesson, we will explore the workflow of the application and see how each
component of the system interacts with the others.
Our system follows a simple and logical process.
First, a teacher logs into the system through the web interface.
After logging in, the teacher enters a student’s identification number on the results
entry page.
Once the student ID is submitted, the system searches for the student record in
Google Sheets, which we are using as our cloud-based database.
If the student exists in the database, the system automatically retrieves the student’s
information and displays the student’s name on the page.
This helps confirm that the correct student record has been selected.
Next, the teacher enters the student’s score for a particular subject.
The system also allows teachers to enter scores for multiple students in a single
session, making it easy to record results for an entire class.
Once the scores are submitted, the backend application—built with Python and
Flask—performs several automated operations.
First, the submitted scores are written to the appropriate columns in the Google
Sheets database.
,Next, the spreadsheet formulas automatically process the data and calculate
important academic metrics.
These calculations include:
subject total marks
student averages
final grades
subject rankings
class rankings
After all calculations are completed, the system generates a PDF progress report for
each student.
These reports summarize the student’s academic performance and present the
results in a clean and professional format.
Finally, teachers and students can download the generated reports directly from the
system.
This automated workflow dramatically reduces the time required to prepare report
cards and helps ensure that the results are accurate and consistent.
In the next lesson, we will take a closer look at the architecture of the system and
understand how the different technologies work together to power this application.
Lesson 3 — Architecture of the Application
In this lesson, we will examine the architecture of our result management system.
Understanding the architecture of an application is important because it shows how
different components work together to create a complete system.
Our application is built using a multi-layer architecture, where each layer has a
specific responsibility.
Let’s begin with the frontend layer.
The frontend is the part of the system that users interact with directly through their
web browser.
In this project, the frontend is built using three core web technologies:
HTML is used to create the structure of the web pages.
It defines elements such as forms, input fields, tables, and buttons.
, CSS is used to style the interface and make the application visually appealing.
JavaScript adds interactivity to the web pages.
It allows the system to respond to user actions and update information dynamically.
Next, we have the backend layer.
The backend is responsible for processing requests, executing application logic, and
communicating with external services.
In this course, the backend is built using Python and the Flask web framework.
Flask receives requests from the browser, processes the data, and sends responses
back to the user interface.
The backend also connects to our database.
For this project, we will use Google Sheets as our cloud-based database.
This allows us to store student information, subject scores, and academic results in an
accessible and flexible format.
Another important component of the system is our external services layer.
To generate downloadable reports, we will use the Google Drive API, which allows
our application to export spreadsheets as PDF documents.
Now let’s look at how data flows through the system.
First, a teacher interacts with the system through their web browser.
The browser sends a request to the Flask web server, which is running our Python
application.
The Flask server then communicates with the Google Sheets API to read or update
student data stored in the spreadsheet.
Inside the spreadsheet, built-in formulas automatically perform calculations such as
totals, averages, grades, and class rankings.
Once the results are calculated, the system exports the report as a PDF document.
Finally, the generated report is delivered back to the user so it can be downloaded
and shared.
Lesson 1 — Course Overview
Welcome to this course.
In this course, you will learn how to build a complete School Result Management
System using modern programming and web technologies.
Many schools still manage student results manually.
Teachers often collect marks from different subjects, calculate totals and averages by
hand, and prepare report cards one student at a time.
This process can be slow, repetitive, and prone to errors.
In this course, we will solve that problem by building an automated system that
manages student results efficiently.
We will develop a web-based application where teachers can enter student marks
through an easy-to-use interface, and the system will automatically process the
results and generate academic reports.
To build this system, we will use several powerful technologies.
Our backend logic will be written in Python, a popular programming language used
for automation, data processing, and web development. Make sure you have
installed it in your computer.
We will use Flask as our web framework to create the application server that handles
requests from users.
For storing and managing student data, we will use Google Sheets, which will act as
our cloud-based database.
On the frontend, we will design the user interface using HTML, CSS, and JavaScript.
By the end of this course, you will have built a fully working system that can:
• Allow teachers to log into the system
• Automatically retrieve student names using their student ID numbers
• Record subject scores through a web interface
• Update marks directly in Google Sheets
,• Automatically calculate totals, averages, and results
• Generate professional PDF progress reports for students
This project closely simulates a real school management system used in
production environments.
More importantly, it will help you understand how different technologies work
together to build practical, real-world software systems.
In the next lesson, we will explore how the entire system works and look at the
workflow of the application.
Lesson 2 — How the System Works
Before we begin writing code, it is important to understand how the entire system
works.
In this lesson, we will explore the workflow of the application and see how each
component of the system interacts with the others.
Our system follows a simple and logical process.
First, a teacher logs into the system through the web interface.
After logging in, the teacher enters a student’s identification number on the results
entry page.
Once the student ID is submitted, the system searches for the student record in
Google Sheets, which we are using as our cloud-based database.
If the student exists in the database, the system automatically retrieves the student’s
information and displays the student’s name on the page.
This helps confirm that the correct student record has been selected.
Next, the teacher enters the student’s score for a particular subject.
The system also allows teachers to enter scores for multiple students in a single
session, making it easy to record results for an entire class.
Once the scores are submitted, the backend application—built with Python and
Flask—performs several automated operations.
First, the submitted scores are written to the appropriate columns in the Google
Sheets database.
,Next, the spreadsheet formulas automatically process the data and calculate
important academic metrics.
These calculations include:
subject total marks
student averages
final grades
subject rankings
class rankings
After all calculations are completed, the system generates a PDF progress report for
each student.
These reports summarize the student’s academic performance and present the
results in a clean and professional format.
Finally, teachers and students can download the generated reports directly from the
system.
This automated workflow dramatically reduces the time required to prepare report
cards and helps ensure that the results are accurate and consistent.
In the next lesson, we will take a closer look at the architecture of the system and
understand how the different technologies work together to power this application.
Lesson 3 — Architecture of the Application
In this lesson, we will examine the architecture of our result management system.
Understanding the architecture of an application is important because it shows how
different components work together to create a complete system.
Our application is built using a multi-layer architecture, where each layer has a
specific responsibility.
Let’s begin with the frontend layer.
The frontend is the part of the system that users interact with directly through their
web browser.
In this project, the frontend is built using three core web technologies:
HTML is used to create the structure of the web pages.
It defines elements such as forms, input fields, tables, and buttons.
, CSS is used to style the interface and make the application visually appealing.
JavaScript adds interactivity to the web pages.
It allows the system to respond to user actions and update information dynamically.
Next, we have the backend layer.
The backend is responsible for processing requests, executing application logic, and
communicating with external services.
In this course, the backend is built using Python and the Flask web framework.
Flask receives requests from the browser, processes the data, and sends responses
back to the user interface.
The backend also connects to our database.
For this project, we will use Google Sheets as our cloud-based database.
This allows us to store student information, subject scores, and academic results in an
accessible and flexible format.
Another important component of the system is our external services layer.
To generate downloadable reports, we will use the Google Drive API, which allows
our application to export spreadsheets as PDF documents.
Now let’s look at how data flows through the system.
First, a teacher interacts with the system through their web browser.
The browser sends a request to the Flask web server, which is running our Python
application.
The Flask server then communicates with the Google Sheets API to read or update
student data stored in the spreadsheet.
Inside the spreadsheet, built-in formulas automatically perform calculations such as
totals, averages, grades, and class rankings.
Once the results are calculated, the system exports the report as a PDF document.
Finally, the generated report is delivered back to the user so it can be downloaded
and shared.
