Undergraduate Course Reservation System (UCRS)

1
Undergraduate Course Reservation System (UCRS)

• Department of Computer Science
• University of Wisconsin - Madison
• Qi Su

2
Overview

• Motivation
• History
• Prototype
• CS706 Project

3
Motivation

• Comp Sci undergrad majors getting into required
  classes they need and graduating in 4 years
• Forecast enrollment demand for classes
• Streamline undergrad course plan process

4
The Solution

• UCRS
• Web based
• Students Fill out course plan to request courses
• Advisors Approve student plan if it fulfills
  requirements
• Admin Authorize CS majors for classes, review
  enrollment demand

5
Overview

• Motivation
• History
• Prototype
• CS706 Project

6
History

• Idea conceived by Professor DeWitt
• Fall 2000
• 3 grad students system design
• Spring 2001
• I implemented a prototype
• Fall 2001
• CS706 course project - redesign

7
Overview

• Motivation
• History
• Prototype
• CS706 Project

8
Prototype
9
Prototype Implementation

• Database IBM DB2
• User Interface
• Implemented using Java servlets
• Use JDBC calls to interact with the database
• Dynamically produce plain HTML output

10
Prototype Database Schema
11
Prototype Functionality

• Student
• Submit course plan for approval
• Receive feedback if plan does not meet req
• Advisor
• Approve student plans
• View student plans
• Admin
• View course enrollment forecast

12
Student Workflow
13
Advisor Workflow
14
Admin Workflow
15
Prototype Problems

• JDBC code not optimized
• No shared connection pool to database
• StringA StringA
• Update queries sent one at a time

16
Overview

• Motivation
• History
• Prototype
• CS706 Project

17
CS706
Analysis of Software Artifacts

• An introduction to the analysis of a variety of
  artifacts arising in the context of software
  engineering

18
CS706 Project Requirements

• Brower based interface
• Allow students to declare CS major, create/modify
  course plans
• Handle grad student course plans
• Maintain course listing/description
• Provide course enrollment projection

19
Implementation

• Database
• IBM DB2 or PostgreSQL depending on CSL
  migration decision
• User Interface
• Java Servlet or PHP ??

20
Future Works

• Link with ISIS to automatically authorize
  students for sections
• Allow non-CS majors to request courses
• DARS report type functionality to keep track of
  student progress
• Usability testing by real students, advisors and
  administrators