Reasonably expand the scope of the sample data to consider additional data that might be beneficial (even though they are not in the sample data), like all departments, past semesters, or more faculty information. Identify facts/measures, dimensions, hierarchies, and potential aggregates.

Data explanation

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

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

Course number: 1xxx-4xxx (undergraduate, 1 to 4 for freshman, sophomore, junior, and senior), 5xxx and above for graduate

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

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

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

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

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

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

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

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

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

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

Degree program analysis

Growth as a whole or in certain aspects like MSIT

Comparison of departments in areas like course number, class size, faculty work load, trend, etc.

Faculty performance and workload. Some key analysis include:

Individual faculty members most recent academic year.

Total number of courses, and by semester

Total number of sections, and by semester

Total registration head counts, and by semester and course

Withdraw rate for each course section

Faculty as a whole group

Registration head count total by employment status (full time or part time), rank (professor, associate prof, lecturer, etc.), and by department

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

21533	ACCT 6030 / 903	Taxation of Entities Second Session - Oct 14 - Dec 2, 2013 Pre-req: ACCT 5009 or Undergraduate Acctg degree	3	ONLINE	7L	ONLINE	Ariail D		26/27/0
21548	ACCT 6075 / 903	Tax Research & Planning Second session - Oct 14 - Dec 2, 2013 Pre-req: Transitional Accounting courses, if required To be added to the wait list, please email: business@spsu.edu	3	ONLINE	7L	ONLINE	Tsay B		23/24/0
21218	ARCH 3011 / 001	Architecture Studio I	4	M W F	16	1:00PM - 4:50PM	Akins E	N 232	10/10/10
21230	ARCH 3011 / 002	Architecture Studio I	4	M W F	16	1:00PM - 4:50PM	Carpenter W	N 232	10/10/10
21231	ARCH 3011 / 003	Architecture Studio I	4	M W F	16	1:00PM - 4:50PM	Carroll M	N 232	9/9/10
21232	ARCH 3011 / 004	Architecture Studio I	4	M W F	16	1:00PM - 4:50PM	Martin E	N 232	11/11/10
21541	ARCH 3116 / 001	Urban Design & Planning Theory	3	M W F	16	9:00AM - 9:50AM	Hashas M	N 173	13/13/13
21542	ARCH 3116 / 002	Urban Design & Planning Theory	3	M W F	16	9:00AM - 9:50AM	Shpuza E	N 174	17/18/16
21543	ARCH 3116 / 003	Urban Design & Planning Theory	3	M W F	16	9:00AM - 9:50AM	Voroneanu M	N 175	18/20/16
21639	ARCH 3211 / 003 3B	Architecture Structures II	4	T R	16	1:00PM - 2:30PM	Hong P	N 003	25/25/20
21643	ARCH 3211 / 004 3C	Architecture Structures II	4	T R	16	1:00PM - 2:30PM	Lagerstrom A	N 175	22/22/20
21641	ARCH 3211 / 059 B3	Architecture Structures II	0	T R	16	2:31PM - 3:50PM	Hong P	N 003	25/25/20
21645	ARCH 3211 / 060 C3	Architecture Structures II	0	T R	16	2:31PM - 3:50PM	Lagerstrom A	N 175	22/22/20
21646	ARCH 3313 / 001 4A	Env.Tech II: Human Comfort	3	M W	16	10:00AM - 12:00PM	Akins E	M 137	14/14/14
21648	ARCH 3313 / 002 4B	Env. Tech II: Human Comfort	3	M W	16	10:00AM - 12:00PM	Carroll M	M 136	12/12/14
21650	ARCH 3313 / 003 4C	Env. Tech II: Human Comfort	3	M W	16	10:00AM - 12:00PM	Zamani P	N 176	13/14/14
21647	ARCH 3313 / 061 A4	Env. Tech II: Human Comfort	0	F	16	11:00AM - 12:00PM	Akins E	M 137	14/14/14
21649	ARCH 3313 / 062 B4	Env. Tech II: Human Comfort	0	F	16	11:00AM - 12:00PM	Carroll M	M 136	12/12/14
21651	ARCH 3313 / 063 C4	Env. Tech II: Human Comfort	0	F	16	11:00AM - 12:00PM	Zamani P	N 176	13/14/14
21703	ARCH 3903 / 001	SpTp-Visual Arts	3	M W F	16	9:00AM - 9:50AM	Mooney K	N 232	17/17/25
21700	ARCH 3923 / 001	SpTp-Material Matters	3	T	16	4:00PM - 6:50PM	Carroll M	N 003	5/6/25
21704	ARCH 3953 / 001	SpTp-Skin & Bones	3	M W	16	6:00PM - 7:20PM	Mooney K	N 176	16/16/25
21705	ARCH 3983 / 001	SpTp-Landscapes & Site-Design	3	T R	16	4:30PM - 5:50PM	Mooney K	N 176	27/27/25
21497	ARCH 4013 / 001	Architecture Studio III	4	M W F	16	1:00PM - 4:50PM	Farooq A	N 232	13/13/14
21498	ARCH 4013 / 002	Architecture Studio III	4	M W F	16	1:00PM - 4:50PM	Shpuza E	N 232	13/14/14
21500	ARCH 4013 / 003	Architecture Studio III	4	M W F	16	1:00PM - 4:50PM	Hashas M	N 232	9/9/11
21501	ARCH 4013 / 004	Architecture Studio III	4	M W F	16	1:00PM - 4:50PM	Voroneanu M	N 232	13/13/14
21544	ARCH 4114 / 001	Cultures IV:1945 to Current	3	M W F	16	10:00AM - 10:50AM	Carpenter W	N 173	21/22/22
				M W F	16	10:00AM - 10:50AM	Rizzuto A	N 173
21545	ARCH 4114 / 002	Cultures IV:1945 to Current	3	M W F	16	10:00AM - 10:50AM	Rizzuto A	N 174	17/17/22
21546	ARCH 4114 / 003	Cultures IV:1945 to Current	3	M W F	16	6:00PM - 7:00PM	Carpenter W	N 175	13/13/22
21706	ARCH 4411 / 001	Design Cost Control	2	T R	16	11:00AM - 11:50AM	Papageorge T	N 175	30/30/30
21755	ARCH 4411 / 002	Design Cost Control	2	T R	16	9:00AM - 9:50AM	Papageorge T	N 175	27/28/28
21702	ARCH 4903 / 001	SpTp-Digital Animation	3	M W	16	9:30AM - 10:50AM	Uddin M	N 003	6/7/17
21707	ARCH 4933 / 001	SpTp-Design Drawing	3	R	16	4:00PM - 6:50PM	Martin T	N 173	11/12/20
21547	ARCH 5313 / 001	Professional Practice & Ethics	3	M W F	16	11:00AM - 11:50AM	Welty C	N 175	30/30/30
21654	ARCH 5313 / 002	Professional Practice & Ethics	3	T R	16	4:00PM - 5:20PM	Papageorge T	N 175	25/25/30