50 likes | 247 Views
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
E N D
Student Management System (SMS): Overview and ExercisesCarol F. Kallfelz, Renton Technical CollegeTTT Training10/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 • Course Management • Student Biographic • Admissions • Registration • Program Enrollment • Grades and Records • Student Progress • ADM • MAGWL • SM • SMIS • TRNSFR • TRAN • TBL3 • TBL4 • 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 SID STU-PRG-XREF-D SID-SSN-XREF-D ALT-ADDRESS-M STU-PRG-SECT-D STU-PRG-ENR-D