furs1da/Google-Solution-Challenge

Diploma project for ITStep written in ReactJS (Client-Side) and Asp.Net Core 3.1 Server Side, database MSSQL

School Management System

Video Demonstration of this project - Link to YouTube Video

This project is dedicated to help and make online part of education more scructered and comfortable.

Most of the school in my home country (Ukraine) use 3 different services to make online education be possible: Google Site (for posting materials), Gmail (for submitting assignments) and Atoms (for grades). I thought that all these processes should be structured and accessible only in 1 app and it might be free, so I decided to make this project.

---

This project is made using ReactJS as a client-side, ASP.Net Core 3.1 as a server-side and SQL Server from Google Cloud as a database engine. Authorization is made by implementing JWT-tokens using Microsoft.AspNetCore.Authorization library.

Things I have learned while developing this project ⬇

List of roles:

• School Administration
• Teacher - Classroom Teacher
• Student
• Parent

List of functionality:

• School Administration
  • View, add, edit and delete teachers', students', administrators' accounts and class (group) entities;
  • View and delete parents of children;
  • View, publish, edit and delete announcements for certain groups with uploading files (for students, for teacher, for other administrators, for parents, etc);
  • Create a timetable for each class;
  • Send and view messages across the system;
  • View attendance and calculate number of absences for each student;
  • Change personal information;
• Teacher - Classroom Teacher
  • Submit attendance for each class (group);
  • View announcements;
  • View and send messages;
  • View, publish, edit and delete posts (with uploading files);
  • View, publish, edit, delete and give a mark for homework assignment;
  • Give a final mark for a certain term and for whole year;
  • Change personal information;
  • View attendance and marks of students of your class (group) as a classroom teacher;
• Student
  • View homework assignments and submit them by uploading text and files;
  • View marks (grades);
  • View announcements;
  • View and send messages;
  • View attendance;
  • View teachers' posts;
  • Change personal information;
• Parent
  • View announcements;
  • View attendance of their children;
  • View marks (grades) of their children;
  • View and add their children to their accounts;
  • View and send messages;
  • Change personal information;

---

1. School Administration

• View, add, edit and delete teachers', students', administrators' accounts and class (group) entities;
• View and delete parents of children;
• View, publish, edit and delete announcements for certain groups with uploading files (for students, for teacher, for other administrators, for parents, etc);
• Create a timetable for each class;
• Send and view messages across the system;
• View attendance and calculate number of absences for each student;
• Change personal information;

2. Teacher - Classroom Teacher

• Submit attendance for each class (group)
• View announcements
• View and send messages
• View, publish, edit and delete posts (with uploading files)
• View, publish, edit, delete and give a mark for homework assignment
• Give a final mark for a certain term and for whole year
• Change personal information
• View attendance and marks of students of your class (group) as a classroom teacher

3. Student

• View homework assignments and submit them by uploading text and files
• View marks (grades)
• View announcements
• View and send messages
• View attendance
• View teachers' posts
• Change personal information

4. Parent

• View announcements
• View attendance of their children
• View marks (grades) of their children
• View and add their children to their accounts
• View and send messages
• Change personal information

---

Things I have learned or enhanced while developing this project:

License and copyright

© Dmytrii Furs, furs1268@gmail.com