Student Management System SMS Overview and Exercises Carol

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 SMS data are stored in 9 different databases SMS data are stored in 171 datasets 1. 2. 3. 4. 5. 6. 7. 1. 2. 3. 4. 5. ADM MAGWL SM SMIS TRNSFR Course Management Student Biographic Admissions Registration Program Enrollment Grades and Records Student Progress 6. 7. 8. TRAN TBL 3 TBL 4 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-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-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 TBL 3 (Table 3): contains system-controlled tables • 49 (non-modifiable) datasets TBL 4 (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-SSN-XREF-D ALT-ADDRESS-M