All help topics

Timetable

Master View

View all grades side-by-side in a single scrollable grid, organized by bell time schedule. Compare timetables across all classes at a glance, see subject assignments and teacher coverage for every period. Switch between By Class and By Teacher views, and export to Excel.

Start from the left sidebar navigation menu:

  1. Look for the "Timetable" menu item in the left sidebar
  2. Click to expand and find "Master View" submenu item
  3. Click on "Master View" to navigate to this page
  4. The page loads with two tabs: By Class (default) and By Teacher
  5. By Class displays: "Master View" header with subtitle "All grades side-by-side, organized by schedule", and a grid card for each bell time schedule
  6. By Teacher displays: "Teacher Master View" header with subtitle "All teachers at a glance, organized by schedule", with teachers as rows

Overview

The Master View page displays all published timetables in a single wide grid, organized by bell time schedule. It has two views accessible via tabs: By Class and By Teacher. Both views support Excel export.

By Class (default): Grades are grouped by their assigned schedule, with each group shown in its own card. The grid uses a 3-level header: grade names at the top, sections below, and day abbreviations at the bottom. Period rows show times on the left with subject and teacher information in each cell. Subjects are color-coded for easy identification, with a legend at the bottom. Click any cell to see full details in a popup.

By Teacher: Teachers are listed as rows, with days and periods as columns. Each cell shows the subject and grade assignment for that teacher at that time slot. This view makes it easy to see each teacher's full schedule at a glance.

Tasks

Read - View Master View Grid

Navigation: Start from sidebar → Click "Timetable" → Click "Master View" → Page loads

Display Format:

  • Header: Title "Master View" with subtitle "All grades side-by-side, organized by schedule"
  • Schedule Cards: One card per bell time schedule containing all grades on that schedule
  • Grid Layout: Wide horizontally-scrolling table inside each card

Grid Structure:

  • 3-Level Header:
    • Level 1: Grade names spanning all their sections and days (e.g., "Grade 5")
    • Level 2: Section labels with publication status (e.g., "5A", "5B"). Shows "Not Published" badge if timetable hasn't been published
    • Level 3: Day abbreviations for each section (Sun, Mon, Tue, Wed, Thu, Fri, Sat — only working days shown)
  • Period Column (sticky left): Period name in bold with time range below (e.g., "Period 1" / "8:00 AM - 8:45 AM")
  • Data Cells: Subject name (bold) with teacher initials below. Color-coded left border and light background by subject
  • Break Rows: Light gray row spanning all columns showing the break period name

Auto-Load: The grid loads automatically with all published timetable data.

Example: "Open the page to see all grades. Grade 5A's Monday Period 1 shows 'Mathematics' with 'JS' (John Smith) in a blue-tinted cell, while Grade 5B has 'Science' with 'AB' in a green-tinted cell."

Read - Navigate Between Grade Groups

Navigation: Start from sidebar → Click "Master View" → Use horizontal scroll

Steps:

  1. View Grid: See the wide grid with all grades
  2. Scroll Horizontally: Use the horizontal scrollbar or scroll navigation to move between grade groups
  3. Scroll Navigation: Use the scroll navigation component at the top to jump to specific grade groups
  4. Period Column Stays: The period/time column on the left stays fixed as you scroll

Example: "If you have 10 grades, scroll right to see Grade 6, 7, 8 etc. The period times on the left stay visible so you always know which period you're looking at."

Read - View Cell Details

Navigation: Start from sidebar → Click "Master View" → Click any cell in the grid

Steps:

  1. Find Cell: Locate any subject cell in the grid
  2. Click Cell: Click on the cell to open the detail dialog
  3. View Details: A dialog appears showing:
    • Title: Subject name
    • Description: Period name and time range
    • Class: Grade and section (e.g., "Grade 5 A")
    • Day: The day of the week
    • Subject: Full subject name
    • Teacher: Teacher name or initials
  4. Close: Click X or outside the dialog to close

Example: "Click on a 'MATH - JS' cell to see: Subject 'Mathematics', Class 'Grade 5 A', Day 'Monday', Teacher 'John Smith'."

Read - View Subject Color Legend

Navigation: Start from sidebar → Click "Master View" → Scroll to bottom of grid

Steps:

  1. Scroll Down: Scroll below the grid table
  2. View Legend: See the subject color legend showing all unique subjects
  3. Identify Colors: Each subject has a colored square matching its cell color in the grid
  4. Sorted: Subjects are sorted alphabetically with "Homeroom" always listed first

Example: "The legend shows a blue square for Mathematics, green for Science, red for English, etc. Use it to quickly identify subjects across the grid without reading cell text."

Read - Check Publication Status

Navigation: Start from sidebar → Click "Master View" → View section headers

Steps:

  1. View Headers: Look at the second level of headers showing section labels
  2. Check Badges: Sections without published timetables show a "Not Published" badge
  3. Published Sections: Show timetable data in cells normally
  4. Unpublished Sections: Show dashes in cells instead of subject/teacher data

Example: "If Grade 5A has been published but 5B hasn't, 5A shows full timetable data while 5B's header shows 'Not Published' and cells show dashes."

Read - View Teacher Master View (By Teacher Tab)

Navigation: Start from sidebar → Click "Master View" → Click "By Teacher" tab

Display Format:

  • Header: Title "Teacher Master View" with subtitle "All teachers at a glance, organized by schedule"
  • Schedule Cards: One card per bell time schedule
  • Grid Layout: Wide horizontally-scrolling table inside each card

Grid Structure:

  • 2-Level Header:
    • Level 1: Day names spanning all their periods (e.g., "Monday", "Tuesday")
    • Level 2: Period names with time ranges (e.g., "Period 1 / 8:00 - 8:45")
  • Teacher Column (sticky left): Teacher name in bold, sorted alphabetically
  • Data Cells: Subject name with grade labels (e.g., "Math - IIIA, IIIB" or "PE - VA / CLUB - VB")
  • Break Columns: Light gray column for break periods

Example: "Switch to By Teacher tab to see all teachers listed as rows. Mr. Smith's row shows 'Mathematics - 9A' on Monday Period 1, 'Mathematics - 10B' on Monday Period 2, etc."

Read - Export Master View to Excel (By Class)

Navigation: Start from sidebar → Click "Master View" → By Class tab → Click "Export Excel"

Steps:

  1. Find Button: Locate the "Export Excel" button (FileSpreadsheet icon) in the top-right of each schedule card
  2. Click Export: Click the button. It changes to "Exporting..." while processing
  3. Download: An Excel file downloads automatically

File Details:

  • Filename: MasterView_<ScheduleName>.xlsx
  • Main Sheet: Grid with grade headers spanning days, day sub-headers, and period rows with subject + teacher initials in each cell
  • Teachers Sheet: A legend sheet mapping teacher initials to full names

Example: "Click 'Export Excel' on the Default Schedule card. A file 'MasterView_Default Schedule.xlsx' downloads with the full grid and a Teachers legend sheet."

Read - Export Teacher Master View to Excel (By Teacher)

Navigation: Start from sidebar → Click "Master View" → By Teacher tab → Click "Export Excel"

Steps:

  1. Find Button: Locate the "Export Excel" button (FileSpreadsheet icon) in the top-right of each schedule card
  2. Click Export: Click the button. It changes to "Exporting..." while processing
  3. Download: An Excel file downloads automatically

File Details:

  • Filename: TeacherMasterView_<ScheduleName>.xlsx
  • Main Sheet: Grid with day headers spanning periods, period sub-headers, and one row per teacher (sorted alphabetically) with subject + grade labels in each cell
  • Teachers Sheet: A legend sheet mapping teacher initials to full names

Example: "On the By Teacher tab, click 'Export Excel'. A file 'TeacherMasterView_Default Schedule.xlsx' downloads with all teachers' schedules in a spreadsheet."

Buttons & Controls

  • By Class / By Teacher Tabs: Tab navigation to switch between grade-based and teacher-based master views.
  • Export Excel Button (Secondary Button, FileSpreadsheet Icon): Downloads the current view as an Excel file. One button per schedule card. Shows "Exporting..." while processing.
  • Scroll Navigation: Horizontal navigation component for jumping between grade groups in the grid.
  • Cell Click: Any subject cell in the grid is clickable to open the detail dialog.
  • Detail Dialog Close (X Button): Closes the cell detail popup.

Visual Elements

  • Tab Navigation: "By Class" and "By Teacher" tabs at the top of the page for switching views.
  • Export Excel Button: Secondary button with FileSpreadsheet icon in the top-right of each schedule card header.
  • Schedule Card: Card with header showing schedule name, containing the master grid for all grades on that schedule.
  • 3-Level Header: Three-tier column header: Grade → Section → Day. Borders separate grade groups visually.
  • Period Column (Sticky): Left-most column stays fixed during horizontal scroll. Shows period name (bold) and time range (smaller, gray).
  • Subject Cells: Color-coded cells with subject name (bold, 11px) and teacher initials (10px). Left border and light background in subject's color.
  • Break Rows: Light gray background row spanning all columns. Period name shown in italics.
  • Free Period Cells: Show "Free" text in the cell.
  • Non-Working Day Cells: Gray background with a dash.
  • Unpublished Cells: Show a dash instead of subject/teacher data.
  • "Not Published" Badge: Small badge on section headers for grades without published timetables.
  • Subject Color Legend: Row of colored squares with subject names below the grid. Sorted alphabetically, Homeroom first.
  • Cell Detail Dialog: Modal showing full details (class, day, subject, teacher) when a cell is clicked.
  • Loading State: Centered spinner with "Loading master view..." text.
  • Error State: Red alert box showing error message.
  • Empty State (No Published Timetables): Message indicating no timetables have been published yet.
  • Empty State (No Bell Times): Message indicating no bell time schedules have been configured.

Alerts & Errors

  • "Loading master view...": Shown while fetching grade, schedule, and timetable data.
  • "Failed to load master view": Red error alert if data cannot be fetched.
  • No Published Timetables: Empty state when no grades have published timetable data.
  • No Bell Times: Empty state when no bell time schedules exist in the system.
  • "Not Published": Badge on grade sections that don't have a published timetable yet.

Rules & Constraints

  • Published Timetable Required: Only grades with published timetables show data in the grid

    • What Happens: Unpublished grades show dashes in cells and "Not Published" badge
    • How to Fix: Generate and publish timetable from the Timetable Generation page

  • Organized by Schedule: Grades are grouped by their bell time schedule

    • What Happens: Each schedule gets its own card with a separate grid
    • Example: If Grade 5 uses "Default Schedule" and Grade 10 uses "Senior Schedule", they appear in separate cards

  • Grades Sorted Numerically: Grades appear in numerical order (1, 2, 3...) then alphabetically by section (A, B, C)

  • Read-Only View: Master View is for viewing only — no editing is possible from this page

    • To Make Changes: Use the Timetable Generation page to regenerate
    • Export: Use the Export Excel button to download data for offline use

  • Bell Times Required: At least one bell time schedule must exist to show the grid

    • What Happens: Empty state shown if no schedules exist
    • How to Fix: Create a bell time schedule on the Bell Times page

Tips & Notes

  • Two Views for Different Needs: Use By Class to compare grades side-by-side. Use By Teacher to see each teacher's full weekly schedule.
  • Export for Sharing: Use Export Excel to download the master view as a spreadsheet for printing, sharing with staff, or offline reference. The Teachers legend sheet helps identify teacher initials.
  • Compare Grades at a Glance: Use Master View to quickly see what all grades are doing at any given period. Scan down a period row to compare across classes.
  • Color-Coded Subjects: Subject colors are consistent across the entire grid, making it easy to spot patterns like which periods are heavy on Math vs Science.
  • Sticky Period Column: The period/time column stays fixed as you scroll horizontally, so you always know which time slot you're looking at.
  • Click for Details: If a cell's text is truncated, click it to see the full subject name and teacher in the detail popup.
  • Check Publication Status: Look for "Not Published" badges to identify grades that still need their timetable published.
  • Use Legend: The color legend at the bottom helps identify subjects when the grid is too dense to read individual cell text.
  • Scroll Navigation: Use the scroll navigation to quickly jump to specific grade groups rather than scrolling through the entire grid.
  • Schedule Groups: If your school uses multiple bell schedules, each schedule gets its own grid section, making it clear which grades share the same timing.