1 / 5

Documentation and resources for SMS: cis.ctc/pub/smshome.asp

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

aira
Download Presentation

Documentation and resources for SMS: cis.ctc/pub/smshome.asp

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. 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

  3. 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.

  4. 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

More Related