Analyze

IT 4713 Class Project Business Scenario

The following only provides some preliminary and partial description of the scenario. It is enough to

get you started to understand the type of data and the analysis we want to see from data. But you need

to analyze, and design based on your experience and understanding of the case. This is critical in any

data modeling and design.

Be like an analyst and inquire more!

Data explanation

1. CRN is course section offering id, and should be unique across semesters (not exactly sure)

2. Course section codes: 9xx – online, 8xx – hybrid, 0xx – in-classroom

3. Course number: 1xxx-4xxx (undergraduate, 1 to 4 for freshman, sophomore, junior, and

senior), 5xxx and above for graduate

4. CCSE courses have five prefixes: IT, CS, SWE, CGDD, CSE

5. The last column are the three types of enrollment headcounts:

actual enrollment number in the end/initial enrollment number before registration deadline/max

available seats.

Sample expected queries and analysis – these are samples not exactly hard requirements.

1. We want to focus on CCSE the college as well as the IT department.

2. Class registration analysis: providing a view of registration head counts from different

perspectives.

a. Total registration head counts as a whole, and by department and class level (graduate

or undergraduate).

b. Registration history (all semesters in the database) of key courses.

c. Data in current semester compared to those in the same semester of last year.

d. Online course registration trend (by computing subjects like IT, CS, Security, etc.).

e. Other metrics like withdraw rate, average class size, classroom utilization etc.

f. [Challenge] Prediction of class enrollment and number/type of sections offering.

3. Degree program analysis

a. Growth as a whole or in certain aspects like MSIT

b. Comparison of departments in areas like course number, class size, faculty workload,

trend, etc.

4. Faculty performance and workload. Some key analysis include:

a. Individual faculty member’s most recent academic year.

i. Total number of courses, and by semester

ii. Total number of sections, and by semester

iii. Total registration head counts, and by semester and course

iv. Withdraw rate for each course section.

b. Faculty as a whole group

i. Registration head count total by employment status (full time or part time), rank

(professor, associate prof, lecturer, etc.), and by department

ii. Number of course sections total by employment status, and by department