Living Room Tutors was originally launched in 2020 by then high school student Jinglin Li. It is a free web-based peer-to-peer tutoring service for K-12 students that matches volunteer tutors with students who need academic support. It was originally intended to help mitigate the strain of school closures due to COVID-19 and so far, over 500 people have gone through the program.
Living Room Tutors was looking for a more efficient way to match tutors and students. To help alleviate this administrative load, we created an application and database that suggests matches based on the data submitted, sends confirmation emails and generates template emails for successful matches. Go into application here!
With auto-generated template emails and recommended matches based on subject, grade and language, Living Room Tutors will be able to match and respond to applicants much more efficiently, and with much less room for user error. Admin will now have much more time to spend networking, getting the word out to people who could benefit from their services, and applying for grants and other resources using the well-organized data within their new application
This application will fully support Chrome browser. All other browsers are considered out of scope. Be sure to check out the prerequisites and database.sql files for install instructions and database requirements.
To properly host this application, NPM, nodemon, brew and Postico should be installed and available.
A full list of requirements can be found in the dependencies section of the package.json file, including:
Express, Postgresql, Bootstrap, FontAwesome, Nodemailer, GoogleAPIs, Passport, Axios
There is a database.sql file to use to set up a database. After that, once you fork and clone the repository to your local machine, you should be able to run npm install, then run the server and client to be able to use the app locally.
- Users who want to apply to be a tutor or recieve tutoring through LRT will click the corresponding button from the /home and enter all required fields on the subsequent pages.
- Users can go back and edit their information as needed until they click SUBMIT on the final page.
- The user will recieve an automatic confirmation email letting them know that their application has been recieved.
-
Admin can log on with a username and password from /admin.
-
On the landing page, admin can navigate between Tutees, Tutors, and Records pages.
-
On the Tutors page, admin can view all active and deactivated tutors by toggling between two pages. On the active page, admin can click open a tutors's card to view all information, including special subjects and languages that are starred in their profile. Admin can also deactivate a tutor.
-
On the deactivated page, admin can view tutors that have been deactivated, and reactive the tutor if necessary.
-
On the Tutees page, admin can view all active and deactivated tutees by toggling between two pages. On the active page, admin can click open a tutee's card to view all information, including special subjects and languages needed that are starred in their profile. Admin can also deactivate a tutee, or click "Match".
- When "Match" is clicked, the admin is navigated to the Match page. From here, admin can view tutors that are matched with the tutee based on their grade level and subjects they need tutoring in.
- The admin can filter these matches further by language if the tutee is in need of tutoring in a specific language.
- Once the admin finds the best match an clicks "Complete Match", a modal pops up with two emails drafted for the tutor and the tutee/tutee's parent/guardian. The admin can click "Copy" which copies the email to clipboard. From there, they can paste the email into their account, check for typos and other information accuracy, and then send them.
- Once both emails are sent and the admin clicks "Confirm", the match is added to the database which pulls the tutor and tutee out of the active/deactive pool, and the admin is navigated to the Records page.
-
On the deactivated tutees page, admin can view tutees that have been deactivated, and reactive the tutee if necessary.
-
On the Records page, admin can view all matched tutors and tutees, displayed by match date. If the admin clicks on the match card to open it, they can view detailed information about the matched tutor and tutee.
-
Admin can also filter matches by year to view how many matches have been made in a given year since LRT began.
Thank you so much to Living Room Tutors and Jinglin Li for giving us the opportunity to work on this project. Thank you to Prime Digital Academy, Dev Jana and Casie Siekman for the instructional support. Thank you to all of the Ionian cohort, and especially to our incredible team that saw this application through from concepualization to deployment: Laura Burbank, Claire Thallon, Hannah Fligel and Miriam McNamara.
Laura Burbank
Claire Thallon
- [email protected]
- https://github.com/clairethallon/
- https://www.linkedin.com/in/claire-thallon-201553122/
Hannah Fligel
- [email protected]
- https://github.com/hannahfligel
- https://www.linkedin.com/in/hannah-fligel-480a0599/
Miriam McNamara