College Planner

A handy website that helps to organize your assignments, marks, and notes in your College written in Angular using WebSQL.

Live Demo - https://furs1da.github.io/College-Planer/

List of functionality:

• Add, edit, and delete courses;
• Add, edit, and delete assignments;
• Add, edit, and delete marks. Calculate the final grade for each course;
• Add, edit, and delete notes;
• Using API for generating daily quotes;
• Using cross-table queries to calculate the final grade for each course and top 3 due assignments;
• About and Settings page;
• Fully responsive, using WebSQL to manage the work with tables.

Things I have learned while developing this project ⬇

Demonstration of the work of the website:

1. Add, edit, and delete courses
   

2. Add, edit, and delete assignments
   

3. Add, edit, and delete marks. Calculate the final grade for each course
   

4. Add, edit, and delete notes
   

5. Using API for generating daily quotes
   

6. Using cross-table queries to calculate the final grade for each course and top 3 due assignments
   

7. About and Settings page
   

8. Fully responsive, using WebSQL to manage the work with tables
   

---

Things I have learned or enhanced while developing this project:

• Angular;
• Typescript;
• Enhanced my skill of using Bootstrap;
• Usage of WebSQL in Angular;
• Usage of API;
• CRUD operations using WebSQL;
• Enhanced my skills of making cross-table queries;
• Deploying Angular application to Github Pages.