If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Class Offering Analysis

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-27-06, 16:05
hiphop_fc hiphop_fc is offline
Registered User
 
Join Date: Nov 2006
Posts: 2
Class Offering Analysis

Hi guys,

I need 5 powerpoint slides describing plan of action based on the case below.

Thank you



Class Offerings Analysis
The mission of the UCF Division of Graduate Studies is to provide leadership and services to create high-quality learning environments
for graduate students. In support of this mission, the Division of Graduate Studies is client-centered and focused on providing the
information and services that students need to enhance their experience with UCF and that faculty and staff need to effectively carry
out their responsibilities to students. In an effort to continually improve the student experience, the division of Graduate Studies often
conducts focus groups and other means by which to collect feedback from students regarding areas for improvement. Recently, there
have been complaints heard in these focus groups of graduate students unable to register for required classes. The administration
would like to be responsive to this growing concern; however, an action plan needs to be put into place to investigate if this antidotal
evidence has any foundation. If it is an issue, the magnitude of the problem needs to be clarified along with the root causes.
It has been suggested that additional focus groups and surveys of graduate students be conducted to collect more detailed information
regarding the specifics of this issue. One administrator believes that the issue is due to departments not offering courses with enough
frequency to meet demand (for example, some courses are offered only once a year). Another administrator believes that the classes
are being scheduled in classroom space that is simply too small for demand and should be offered in larger classrooms. These two
administrators conducted an initial analysis that demonstrated an increasing trend in the average number of semesters until graduation.
However, at the same time, there has been growth in programs that are attracting an increasing number of part-time working
professional students.
Before money and resources are expended to create, distribute and analyze survey data, it is believed that some initial analysis may be
conducted on already existing data sources. These data sources include:
Student admissions data: Contains by admit term each newly admitted students major area of study, intent to enroll part-time or fulltime,
if they are offered an assistantship, if they are an international student, and expected graduation term
Student record data: Contains each students’ academic history, including semesters enrolled, major area of study, student status
(Graduate assistant or International student, Full-time or Part-time), and graduation term
Student class data: Contains for each student the classes enrolled including if the class was passed, failed or withdrawn from
Master schedule data: Contains a list of all scheduled classes, times, number of students enrolled, and their capacity limits
All four of these data sets are available for every historical semester and can be linked together. Student record data and student
class data can be merged by student id. Student class data and master schedule data can be merged by course id.
It is noteworthy that some students are required to be registered full-time, such as international students or those with graduate
assistantship positions who have a tuition waiver.
Reply With Quote
  #2 (permalink)  
Old 11-27-06, 16:12
hiphop_fc hiphop_fc is offline
Registered User
 
Join Date: Nov 2006
Posts: 2
Class Offerings Analysis

Hi guys,

I got this case to present,I need 5 power point slides for plan of action based on this scenario.
I would appreciate it, if anyone could help.

Thanks in advance.


Class Offerings Analysis
The mission of the UCF Division of Graduate Studies is to provide leadership and services to create high-quality learning environments
for graduate students. In support of this mission, the Division of Graduate Studies is client-centered and focused on providing the
information and services that students need to enhance their experience with UCF and that faculty and staff need to effectively carry
out their responsibilities to students. In an effort to continually improve the student experience, the division of Graduate Studies often
conducts focus groups and other means by which to collect feedback from students regarding areas for improvement. Recently, there
have been complaints heard in these focus groups of graduate students unable to register for required classes. The administration
would like to be responsive to this growing concern; however, an action plan needs to be put into place to investigate if this antidotal
evidence has any foundation. If it is an issue, the magnitude of the problem needs to be clarified along with the root causes.
It has been suggested that additional focus groups and surveys of graduate students be conducted to collect more detailed information
regarding the specifics of this issue. One administrator believes that the issue is due to departments not offering courses with enough
frequency to meet demand (for example, some courses are offered only once a year). Another administrator believes that the classes
are being scheduled in classroom space that is simply too small for demand and should be offered in larger classrooms. These two
administrators conducted an initial analysis that demonstrated an increasing trend in the average number of semesters until graduation.
However, at the same time, there has been growth in programs that are attracting an increasing number of part-time working
professional students.
Before money and resources are expended to create, distribute and analyze survey data, it is believed that some initial analysis may be
conducted on already existing data sources. These data sources include:
Student admissions data: Contains by admit term each newly admitted students major area of study, intent to enroll part-time or fulltime,
if they are offered an assistantship, if they are an international student, and expected graduation term
Student record data: Contains each students’ academic history, including semesters enrolled, major area of study, student status
(Graduate assistant or International student, Full-time or Part-time), and graduation term
Student class data: Contains for each student the classes enrolled including if the class was passed, failed or withdrawn from
Master schedule data: Contains a list of all scheduled classes, times, number of students enrolled, and their capacity limits
All four of these data sets are available for every historical semester and can be linked together. Student record data and student
class data can be merged by student id. Student class data and master schedule data can be merged by course id.
It is noteworthy that some students are required to be registered full-time, such as international students or those with graduate
assistantship positions who have a tuition waiver.
Reply With Quote
  #3 (permalink)  
Old 11-27-06, 17:29
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
so sorry, we do not do homework assignments on this site

show us what you can come up with on your own, and we might be able to offer suggestions to improve it

but we won't do it for you
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #4 (permalink)  
Old 11-27-06, 18:00
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
Dupe threads merged.

Great site for making presentations (I presume it is a presentation since you are using Powerpoint):
http://www.garrreynolds.com/Presentation/index.html

HTH
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On