Class Schedules

This dataset provides a comprehensive record of academic class schedules, detailing course codes, meeting times, instructor assignments, room locations, and enrollment capacities for each section. It enables effective timetable management, resource allocation, and conflict detection for educational institutions. Ideal for academic planning, student registration systems, and institutional reporting.

  • opened 12 times
  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Automated timetable generation and conflict detection

Sample rows

preview · 8 of 200 rows · all 17 columns
schedule_idintegertermstringroom_capacityintegerstart_timestringcourse_codestringcourse_titlestringsection_numberstringinstructor_idintegerinstructor_namestringmeeting_daysstringend_timestringroom_idstringbuilding_namestringenrollment_capacityintegercurrent_enrollmentintegerstart_datedateend_datedate
1Fall 202412009:00MATH101Introduction to Mathematics0011001Dr. Helen MorrisMon,Wed,Fri10:15A101Anderson Hall1101082024-08-262024-12-13
2Fall 20248010:30CHEM110General Chemistry IA1002Dr. Samuel PikeTue,Thu11:45C202Chemistry Complex75602024-08-272024-12-12
3Fall 20246513:00ENGR240Statics and DynamicsB1003Dr. Angela LiMon,Wed14:15E301Engineering Center60502024-08-262024-12-13
4Fall 20249008:00BIOL201Principles of Biology0021004Dr. Parker SmithTue,Thu09:15B103Biology Building80782024-08-272024-12-12
5Fall 202415011:00PSYC101Introduction to Psychology0031005Dr. Lila ReynoldsMon,Wed,Fri12:15P105Psychology Annex1401402024-08-262024-12-13
6Fall 20247015:00PHYS210Physics for Scientists and EngineersC1006Dr. Kevin ZhouTue,Thu16:15S201Science Hall65582024-08-272024-12-12
7Fall 20246010:00ENGL120English Composition1A1007Prof. Maria GentryMon,Wed11:15L108Liberal Arts Hall55542024-08-262024-12-13
8Fall 20245009:30HIST130World Civilizations0021008Prof. Carl ElliottTue,Thu10:45H210Humanities Center45392024-08-272024-12-12

What the 200 rows show

from the 200-row sample
  • 35median room_capacity
  • 9meeting dayses
  • 49end times
  • 52building names
  • 54sections
  • 30median enrollment_capacity
term200 rows by value
060120116Spring 2…58%64Fall 202432%14Winter 2…7%6Summer 2…3%
room_capacity200 rows, in bands of 20
040803773382017771080160room_capacity →

Median 35, from 8 to 150.

start_time200 rows · top 10 of 29 values
  1. 11:0015
  2. 09:0014
  3. 14:0014
  4. 08:0013
  5. 13:0012
  6. 10:0012
  7. 15:0011
  8. 09:3011
  9. 13:3010
  10. 18:0010
17 columns by typefrom the column list below
  • string 10
  • integer 5
  • date 2

Columns

17 columns in three groups
blueprint · 17 columns
columntypedescriptionexample
Text 10 columns
course_codestringOfficial code for the course (e.g., MATH101)MATH101
course_titlestringFull title of the courseGeneral Chemistry I
section_numberstringCourse section identifier (e.g., 001, A)001
instructor_namestringFull name of the instructorDr. Helen Morris
meeting_daysstringDays of the week the class meets (e.g., 'Mon,Wed,Fri')9 daysesMon,Wed,Fri
start_timestringClass start time in 24-hour format (e.g., '09:00')09:00
end_timestringClass end time in 24-hour format (e.g., '10:15')10:15
room_idstringUnique identifier for the classroom (e.g., 'B101')A101
building_namestringName of the building where the class is heldAnderson Hall
termstringAcademic term (e.g., 'Fall 2024')4 termsFall 2024
Numbers 5 columns
schedule_idintegerUnique identifier for each scheduled class meetingunique · 1 or more1
instructor_idintegerUnique identifier for the instructor assigned to the class1 or more1001
room_capacityintegerMaximum number of students the room can accommodate1 or more120
enrollment_capacityintegerMaximum number of students allowed to enroll in the class section1 or more110
current_enrollmentintegerNumber of students currently enrolled in the class section0 or more108
Dates and times 2 columns
start_datedateDate when the class section begins2024-08-26
end_datedateDate when the class section ends2024-12-13

15 SQL practice questions for the Class Schedules

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    Fall 2024 Mon/Wed/Fri sections

    From the class_schedules table, return schedule_id, course_code, and section_number for every section in the term 'Fall 2024' whose meeting_days is exactly 'Mon,Wed,Fri'. Order the results by schedule_id ascending.

    Tables: class_schedules · your result: 3 columns, 16 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct buildings

    Return each distinct building_name found in class_schedules as a single column named building_name, sorted alphabetically.

    Tables: class_schedules · your result: 1 columns, 52 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Sections per term

    Count the sections in each term. Return term and section_count, ordered by section_count descending and then by term ascending.

    Tables: class_schedules · your result: 2 columns, 4 rows
  1. 04Average enrollment by meeting patternBeginner
  2. 05Total enrollment by term tablePower BI
  3. 06Buildings with at least 5 sectionsIntermediate
  4. 07Fill level bucketsIntermediate
  5. 08Sections above average enrollmentIntermediate
  6. 09Terms with above-average room capacityIntermediate
  7. 10Near-capacity sections by buildingPower BI
  8. 11Top 3 sections per termAdvanced
  9. 12Running enrollment by start dateAdvanced
  10. 13Share of total enrollment by termAdvanced
  11. 14Start time versus previous sectionAdvanced
  12. 15Enrollment share by meeting patternPower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • median room ca…35200 rowsmean room capacity by…44.6Spri…44.9Fall…44.0Wint…24.8Summ…

    An education dashboard

    Room_capacity by term and a breakdown of start_time. Excel, Power BI or Tableau.

  • What pattern can you find in 200 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

    Believable rows with course_code, course_title and section_number to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows17 columns
Yours1,000 rows17 columns

blueprint · class-schedules

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 17 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Meeting days and times non-overlapping
  • Room capacity sufficient for enrolled students
  • Instructor assigned to each section
  • Time blocks follow institutional schedule
  • Lab sections linked to lecture sections
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
class-schedules

What should your data show?

Preview 20 rows free
No signup. No card.