Capstone II�Senior Design Project:

Tutoring Lab Scheduling

By: Alex Bethencourt, Melissa Tablada, Lian Perez, Daniel Linares, Janera Stringer

The Problem

• Difficulty tracking appointments
• Inefficient
• Tedious

​

​

The Solution

• Centralized database
• Email system
• Simple record management and storage
• User friendly for both students and tutors
• A personalized report for the entire semester

​

Key Features (Student)

• Students can easily schedule appointments with a tutor of their choice.
• Students have the choice to choose a time comfortable for them
• Students input what courses they need help with
• Students can choose to meet in person or online

• Students can also view their total amount of tutoring hours.
• Requires student to input their panther ID and email registered in the DB
• Shows the student a list of all their appointments and their status’s
• Students can also cancel upcoming appointments if they wish.

Key Features (Professors/Tutors)

• Professors can create accounts for themselves and trusted tutors
• Account passwords are encrypted within the database
• These accounts are used to log in as an admin
• As an admin, you can view and manage the appointments for students
• Mark appointments as complete to add a tutor hour to the student

​

​

More features

• Management page for adding courses and other information
• Generate reports with statistics for the semester

​

Database Design

• Centralized database
• Simple design
• Efficient
• Easy to remove/add records

Software/Tools Used

• XAMPP (for local testing)
• PHP + PHPMailer
• SQL
• Apache
• phpMyAdmin
• HTML/CSS
• JavaScript

​

​

Conclusion

• User-friendly design
• Easy to use for both students and instructors
• Simple way to manage large amount of student appointments and records

Thank you

Project by: Alex Bethencourt, Melissa Tablada, Daniel Linares, Lian Perez, and Janera Stringer