Dataset: University Exam Scheduling

About this Dataset

University Exam Scheduling

Dataset Description:

This dataset simulates university data essential for developing and optimizing exam scheduling algorithms using machine learning methodologies. It includes detailed information on students, instructors, courses, classrooms, and timeslots, facilitating comprehensive analysis and algorithmic development for educational planning.

Key Features:

Students: Unique identifiers, personal details, program enrollment, and academic year.
Instructors: Identification, contact information, and department affiliation.
Courses: Course specifics such as ID, title, department, credit allocation, and detailed descriptions.
Classrooms: Facilities information including ID, building designation, room numbers, capacity metrics, and room type categorization.
Timeslots: Timeframes categorized by ID, day of the week, commencement, and conclusion timings.
Intended Use:

Educational Research: Suitable for academics and researchers focusing on optimizing educational scheduling systems.
Machine Learning Development: Ideal for developing algorithms to automate and enhance exam scheduling processes.
Educational Policy Planning: Supports decision-making processes in educational institutions for better resource utilization and scheduling efficiency.
License: CC0 - Public Domain Dedication

Update Frequency: One-time dataset creation

Tables

Classrooms

@kaggle.smrezwanulazad_exam_schedule.classrooms

4.52 KB
30 rows
5 columns


CREATE TABLE classrooms (
  "classroom_id" BIGINT,
  "building_name" VARCHAR,
  "room_number" BIGINT,
  "capacity" BIGINT,
  "room_type" VARCHAR
);

Courses

@kaggle.smrezwanulazad_exam_schedule.courses

8.82 KB
22 rows
5 columns


CREATE TABLE courses (
  "course_id" BIGINT,
  "course_name" VARCHAR,
  "department" VARCHAR,
  "credits" BIGINT,
  "description" VARCHAR
);

Instructors

@kaggle.smrezwanulazad_exam_schedule.instructors

9.48 KB
50 rows
6 columns


CREATE TABLE instructors (
  "instructor_id" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "email" VARCHAR,
  "phone_number" VARCHAR,
  "department" VARCHAR
);

Schedule

@kaggle.smrezwanulazad_exam_schedule.schedule

149.82 KB
9082 rows
5 columns


CREATE TABLE schedule (
  "student_id" VARCHAR,
  "course_id" BIGINT,
  "instructor_id" VARCHAR,
  "classroom_id" BIGINT,
  "timeslot_id" BIGINT
);

Students

@kaggle.smrezwanulazad_exam_schedule.students

322.54 KB
3000 rows
8 columns


CREATE TABLE students (
  "student_id" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "email" VARCHAR,
  "phone_number" VARCHAR,
  "address" VARCHAR,
  "program_name" VARCHAR,
  "year" VARCHAR
);

Timeslots

@kaggle.smrezwanulazad_exam_schedule.timeslots

4 KB
100 rows
4 columns


CREATE TABLE timeslots (
  "timeslot_id" BIGINT,
  "day" VARCHAR,
  "start_time" VARCHAR,
  "end_time" VARCHAR
);