Student Management System (SMS): Overview and Exercises
Download
Report
Transcript Student Management System (SMS): Overview and Exercises
Student Management System (SMS): Overview and Exercises
Carol F. Kallfelz, Renton Technical College
TTT Training
10/22/02
•
•
•
•
•
•
Documentation and resources for SMS:
http://www.cis.ctc.edu/pub/smshome.asp
Used to house and manage all student-related data
Interfaces with other CIS and SBCTC applications
• PPMS (e.g., FTEF calculation)
• FMS (e.g., calculate student fees)
• FAS (e.g., verify enrollment)
• SBCTC
• MIS reporting
• W.A.B.E.R.S.
SMS is made up of seven different modules
1.
SMS data are stored in 9 different databases
2.
SMS data are stored in 171 datasets
3.
4.
5.
1.
2.
3.
4.
5.
6.
7.
ADM
MAGWL
SM
SMIS
TRNSFR
Course Management
Student Biographic
Admissions
Registration
Program Enrollment
Grades and Records
Student Progress
6.
7.
8.
TRAN
TBL3
TBL4
9.
REGDB
Student Management System (SMS): Overview and Exercises
•
•
•
•
ADM (Admissions): used to track student progress from initial contact
• 32 datasets
• Key table: ADM-STU-D
• Relation to STU-D:
MAGWL (Waitlist): data concerning class waiting lists.
• 8 datasets
• Key tables: WAITLISTS, STUDENTS, CLASSES
SM (Student Management): data concerning students, enrollments, course, classes
• 107 datasets
• “Live” data (real time)
• Key tables: STU-D, COURSE-D
• Key tables – Quarterly: CLASS-D, STU-CLASS-D, STU-YRQ-D, STU-YRQ-XREF,
STU-YRQ-M
SMIS (Student Management Information System): end-of-quarter data submitted SBCTC
• 7 datasets
• “Snapshot” data
• Basis for the SBCTC’s Datawarehouse
• Key tables: MIS-COL-YRQ-M, MIS-CLASS-D, MIS-STU-D, MIS-STU-CLASS-D
Student Management System (SMS): Overview and Exercises
•
•
•
•
•
•
TRNSFER (transfer): data received from other colleges regarding courses taken, grades
• 6 datasets
• Key tables: TRNSFR-EVAL-D, TRNSFR-COURSE-D
TRAN (Transcript): student grades and degrees
• 11 datasets
• Key tables: TRAN-CLASS-D, TRAN-DEGREE-D
TBL3 (Table 3): contains system-controlled tables
• 49 (non-modifiable) datasets
TBL4 (Table 4): contains user-defined tables and process-defined data
• 61 datasets @ RTC
REGDB: data used in degree audits
Exercise: Write a procedure that will pull all student enrolled in professional/technical
programs in a given YRQ; ideally it would include biographic information, email,
placement test scores, program status, and any certificate/degrees awarded.
Student Management System (SMS): Overview and Exercises
CLASS-D
TEST-SCORE-D
CLASS-ID
STU-CLASS-D
STU-QTR
TRAN-DEGREE-D
STU-YRQ-XREF
SID
STU-D
SID
STU-PRG-XREF-D
STU-PRG-SECT-D
STU-PRG-ENR-D
SID
SID-SSN-XREF-D
ALT-ADDRESS-M
1999-2000 CAREER TRAINING PROGRAM STATISTICS
Program
CAREER TRAINING PROGRAMS (FT)
Dean
FT/PT
Enrollment
Approximate Annual Capacity:
1874
Enrolled - Total:
1835
Enrolled for less than 10 days:
67
Enrolled for 10 or more days:
1768
For students enrolled 10 or more days:
E - continued enrollment:
491
T - transferred programs:
50
W - withdrew from RTC:
481
# days to withdrawl (median): 110
C - received certificate/degree:
746
# days to completion (median): 325
Retention Rate:
72.8%
Completion Rate:
60.8%
# days to transfer (median):
For leavers (W) only:
87
1998-1999 and 1999-2000 combined
USE FOR EXTERNAL REPORTING
Student
Outcomes
Job-Out Rate:
Hourly wage - Leavers:
N = 156
55.3%
N = 319
$10.42 N = 187
47.1%
$10.34
N = 390
For completers (C) only:
# Certificates Awarded:
# Degrees Awarded:
733
69
1998-1999 and 1999-2000 combined
USE FOR EXTERNAL REPORTING
Placement Rate - Broad:
90.1%
N = 548
89.9%
N = 1150
Hourly wage - Completers:
$12.39
N = 280
$12.43
N = 701
Placement Rate - Narrow:
94.8%
N = 429
93.2%
N = 869
Student Demographics:
Student Preparedness - ASSET Test:
% Tested (prior to enrollment): 52.1%
Student
Profile
"Passing"
Age in years (median):
28
% Of Color:
36.7%
Write Score (median):
38
35
% Female:
47.9%
Read Score (median):
40
35
% Immigrants/Refugees:
17.2%
Numerical Score (median):
38
33
NOTE: Blank fields indicate data are not available
Score
RTC Office of Research and Development, 9/1/02