Instructor Assignment & Management System
Designed & developed an instructor management tool for client Dreams For Schools.
Client & Project Overview
Dreams for Schools is a non-profit organization that oversees programs and initiatives
that contribute to educating youth about STEM.
As the organization scaled up its operations, there was a significant increase in the workload
required for manually assigning instructors to programs.
Our goal was to design and develop an app that allows DFS to easily manage their
instructors/programs and create automatic assignments based preference, location, and
availability.
During the design process, I worked closely with stakeholders to conduct product
definition/research, develop wireframes to high-fidelity designs, and validate the final product
with user testing. During the second quarter, I focused on implementing the front and back-end
systems for the application.
Feature Set
- Ability to import instructor data through bulk CSV upload
- Ability to add/edit instructors, schools, programs and classes
- Intuitive drag and drop assignment for adding instructors to classes
- Auto-assign functionality to assign instructors based on optimal distance and preference
Design Process & Case Study
Live Demo
Tech Stack
- React for our front end since it allows for easy modularity
and reusable components.
- Express and MySql database for our backend.
- Used SQL as we needed to define constraints and relationships between students, instructors
and programs.
- All authentication was handled through firebase. Users must be signed in and front end
requests send a token in the header which are being validated in the back end before
providing access.
Database Architecture