Milestone 1

This page lists the goals and tasks for LearnSQL Milestone M1. Tasks completed in this checkpoint contribute to first release of LearnSQL with the primary goal of setting base functionality.

Topics which are struck-through have either been moved to a future checkpoint or have been deprecated.

Bootstrap Conversion

The following sections need to be converted to Bootstrap. Also all future pages will be based on Bootstrap

• Home Section -- Kelly
• Student Control Panel -- Torres
• Teacher Control Panel -- Kelly
• Admin Control Panel -- Kelly
• Profile Section -- Innaco
• Learn Section -- Torres
• Workshop Section
• Quiz Section

User login

• User authentication and session persistence -- Kelly
• User Database -- Kelly
• User roles (Student, Teacher, Admin) -- Kelly
• Forgot and reset password functionality -- Kelly

Contact Page

• Contact Form -- Torres
• Support Email -- Torres

Profile Page

• Display user information -- Innaco

Student Section

• Display enrolled classes -- Torres
• Enroll in classes -- Torres and Kelly

Admin Section

• Unit tests to check core functionality -- Kelly

Teacher Section

• Making ClassDB schemas for classes -- Kelly
• Add students, classes and teachers -- Kelly

Documentation Section

• Add documentation on how each section of the website works, focusing heavily on Workshop and related sections.
• Standardize code and comment formatting -- Kelly
• Guide to aid local installation -- Innaco
• Define Node.js modules currently used -- Kelly and Innaco
• ER diagram -- Kelly
• Class Section Overview flowchart -- Kelly

Security

• Using Passport.js, bcryptjs and crypto-random-string to salt and hash user passwords -- Kelly
• User account verification through e-mail -- Kelly and Torres

Learn Section

• Update Content for all pages
• Be aware of and remove plagiarism

Workshop Section

• ClassDB schemas for each class
• Secure Login
• CMD console emulator
• File System
• Backups

Quiz Section

• Large variety of questions
• Selectable topics