Video Tutorial: Online School or Student Results Management System
This video tutorial demonstrates how to create an Online School or Student Results Management System using Google Apps Script. The system includes features for both Admin and Student logins. Students can view their results, while Admins can manage all the results data, including performing CRUD (Create, Read, Update, Delete) operations. The tutorial covers the implementation of various functions in the script to achieve these functionalities, including login verification, dynamic HTML generation, and data manipulation in Google Sheets.
Key Features
Dual Login System
- The application supports both Admin and Student logins.
- Admins have access to manage and manipulate the results data.
- Students can view their individual results.
CRUD Operations for Admin
- Admins can perform Create, Read, Update, and Delete operations on the results data.
- This ensures that the results data can be managed efficiently.
Dynamic HTML Generation
- The application generates HTML content dynamically based on the user type (Admin or Student).
- This allows for a personalized interface for each user type.
Results Display for Students
- Students can view their results, including details like subject names, obtained marks, total marks, percentage, grade, and status.
- The results include additional information like teacher's and principal's signatures, and important notes about the results.
Data Integration with Google Sheets
- The application integrates with Google Sheets to store and retrieve results data.
- This allows for easy data management and ensures that the data is always up-to-date.
| Step | Instructions |
|---|---|
| Step 1 | Open the web app link provided. |
| Step 2 |
If you see a Google Sheet in view-only mode:
|
| Step 3 |
If you see a page with two options (Make a Copy and AppScript File):
|
| Step 4 | Follow the on-screen instructions to complete the setup. |
| Step 5 | Click on the Extensions menu at the top of the Google Sheet. |
| Step 6 | Select Apps Script from the dropdown menu. |
| Step 7 | In the Apps Script editor, click on the Deploy button. |
| Step 8 | Select New deployment from the dropdown menu. |
| Step 9 | In the deployment configuration, click on Select type and choose Web app. |
| Step 10 | Fill in the required fields and click on Deploy. |
| Step 11 | Grant the necessary permissions when prompted. |
| Step 12 | Once deployed, copy the web app URL provided. |