Home School Scheduler

The Schedules table serves as the core for organizing daily educational activities. It tracks assignments for each student, the subject, the period, and the teacher responsible, along with grading details. This table ensures that each student has a clear schedule of tasks and deadlines, helping parents and educators monitor completed work and student progress.

The Students table stores information about each student, including their name, student number, and a color code for identification. This table helps personalize the experience and provides a centralized place for storing student details, ensuring effective tracking of individual student profiles within the system.

The Subjects table lists the various subjects being taught. Each subject has a unique identifier to help organize the curriculum and assign specific subjects to students in their schedules. This table is essential for ensuring that students are studying a broad and balanced range of topics.

The Periods table defines the start and end times for class periods during the day. This is crucial for organizing a structured schedule, allowing the system to allocate time slots for subjects, and ensuring the day is well-planned and students know their daily routines.

The Billing table manages financial transactions related to the homeschooling program. It tracks fees issued to students, payment statuses, discounts, and total amounts owed. This table helps keep the financial aspect of homeschooling organized, making it easy for administrators to track invoices and payments.

The Teachers table contains the personal and professional information of teachers involved in homeschooling. It stores data such as teacher names, degrees, and addresses, ensuring that teacher profiles are well-documented for efficient staff management and assignment purposes.

The Teachers Assigned to Class table links teachers to specific projects or subjects, tracking their work schedule, hourly rates, and total duration of the class. This table ensures that teachers are properly assigned to the correct subjects and periods, facilitating accurate class scheduling and compensation.

The Teachers Skills table tracks the skills and proficiency levels of each teacher. This table is valuable for ensuring that teachers are assigned to the appropriate subjects based on their expertise, contributing to high-quality education for the students.

This database provides a comprehensive solution for managing all aspects of homeschooling, from academic scheduling and teacher assignments to administrative tasks like billing, creating a highly organized and efficient system for homeschooling families and educators.