0.011/15/91 DIANE LIVELY 1.0 INTRODUCTION ------------ THE STUDENT TRACKING SUBSYSTEM IS DESIGNED TO STORE, MAINTAIN, PROCESS, AND REPORT INFORMATION IN FOUR MAIN AREAS: STUDENT PLACEMENT TESTS ----------------------- THE PLACEMENT TEST AREA OF THE SUBSYSTEM WAS DESIGNED TO BE FLEXIBLE BY ALLOWING EACH SCHOOL TO SET UP ITS OWN MASTER TEST DATA. IT GIVES DEPARTMENTS AND DISCIPLINES THAT GIVE PLACEMENT TESTS A WAY TO WORK WITH TESTS, SCORES, AND COURSE RECOMMENDATIONS AS THEY ARE ADMINISTERED AND TO TRACK THEIR STUDENTS TO ASCERTAIN THE STUDENTS' SUCCESS AT THE COLLEGE. A STUDENT'S TEST DATA, INCLUDING COURSE RECOMMENDATIONS (IF ANY), IS MAINTAINED BY AN ONLINE SCREEN. DATA IS REPORTED VIA SEVERAL BATCH PROGRAMS AND ONE ON-LINE INQUIRY PROGRAM. THERE IS ALSO A BATCH UPDATE PROGRAM TO REMOVE OUT-DATED DATA. HIGH SCHOOL/GED INFORMATION --------------------------- THE HIGH SCHOOL/GED COMPONENT OF THE TRACKING SYSTEM ALLOWS THE ADMISSIONS AND RECORDS OFFICE TO RECORD HIGH SCHOOL DATA OBTAINED FROM THE STUDENTS' HIGH SCHOOL TRANSCRIPTS. THIS INFORMATION IS THEN READILY AVAILABLE TO ADVISORS. THERE ARE TWO ON-LINE PROGRAMS FOR CAPTURING THIS DATA. THE FIRST GIVES THE OPERATOR AN OPPORTUNITY TO UPDATE THE HIGH SCHOOL OR GED YEAR AND CODE WHICH WAS CAPTURED WHEN THE STUDENT APPLIED FOR ADMISSION TO THE COLLEGE. OTHER FIELDS INCLUDE ABILITY TO BENEFIT, TYPE OF HIGH SCHOOL DEGREE (SUCH AS BUSINESS, COLLEGE PREP, ETC.), GED SCORES, SAT SCORES, AND CLASS STANDING AND SIZE. THE OTHER PROGRAM ALLOWS HIGH SCHOOL COURSES (CARNEGIE UNITS) TO BE STORED. THERE IS ONE ON-LINE INQUIRY WHICH SHOWS ALL THIS INFORMATION AND ONE BATCH REPORT PROGRAM. CURRICULUM PROGRESS ------------------- THIS ASPECT OF THE TRACKING SYSTEM PROVIDES A WAY TO DETERMINE A STUDENT'S PROGRESS IN A CURRICULUM. THE CURRICULUM DATA BASE STORES ALL OF THE INFORMATION ABOUT THE CURRICULUM THAT IS NEEDED. THE STUDENT MASTER RECORD HAS THE STUDENT'S CURRICULUM CODE. IN ADDITION, IT STORES THE CATALOG YEAR AND SPECIALIZATION, SINCE CATALOGS CHANGE OVER TIME AND SOME CURRICULA OFFER MORE THAN ONE PROGRAM OF STUDY. IN THE CURRICULUM DATA BASE, UNDER EACH CURRICULUM, THERE IS ONE OR MORE SPECIALIZATIONS WITH THE CATALOG YEARS UNDER THE SPECIALIZATION. THE COURSE REQUIREMENTS ARE ENTERED AS THEY APPEAR IN THE COLLEGE CATALOG WITH THE TERM AND SEQUENCE NUMBER AS THE KEY. A REQUIRED COURSE CAN HAVE EQUIVALENT COURSES, WHICH ARE COURSES THAT WOULD ALSO SATISFY THE REQUIREMENT. ADVISORS CAN READILY VIEW THIS CURRICULUM DATA ONCE IT IS ENTERED WITH THE ADDED CAPABILITY OF HAVING THE COMPUTER ALMOST INSTANTANEOUSLY MATCH THE CURRICULUM AGAINST THE STUDENT'S REGISTRATIONS, TRANSFER COURSES, AND NON-TRANSFER ADVANCED STANDING. THERE IS ALSO THE ABILITY TO POST A WAIVER OR SUBSTITUTION FOR A PARTICULAR STUDENT'S CURRICULAR REQUIREMENT. THIS SYSTEM IS ABLE TO HANDLE QUARTER-TO-SEMESTER CONVERSION VIA CURRICULUM EQUIVALENTS AND/OR STUDENT SUBSTITUTIONS. ADVISORS ARE ABLE TO ANSWER THE 'WHAT IF I SWITCH TO CURRICULUM ...' QUESTION WITH THE PRESS OF AN ENTER KEY AND CAN HAVE THE ANSWER PRINTED OUT FOR THE STUDENT TO TAKE. TRANSFER ASSISTANCE PROFILES ---------------------------- STUDENTS ATTENDING COMMUNITY COLLEGES FOR THE PURPOSE OF TRANSFERING TO FOUR-YEAR INSTITUTIONS FREQUENTLY SEEK ADVICE FROM ADVISORS AND COUNSELORS REGARDING THE COURSES THAT SHOULD BE TAKEN. THIS COMPONENT OF THE TRACKING SYSTEM PROVIDES ONLINE ACCESS TO TRANSFER INFORMATION FOR THE FOUR-YEAR INSTITUTIONS. THE TRANSFER ASSISTANCE PROFILE SHOWS THE TRANSFERABLE VCCS COURSES THAT ARE RECOMMENDED FOR COMPLETION PRIOR TO TRANSFER AND WHAT THE STUDENT HAS COMPLETED SO FAR. THE TRANSFER DATA BASE CONSISTS OF A COLLEGE SEGMENT WITH MAJORS DEFINED UNDERNEATH. EACH MAJOR HAS RECOMMENDED COURSES AND TEXT DATA. THE TEXT SEGMENTS CONTAIN GENERAL INFORMATION WHICH IS HELPFUL, SUCH AS ADMISSIONS POLICIES. EQUIVALENT COURSES CAN BE SPECIFIED FOR THE RECOMMENDED COURSES. 2.0 SYSTEM NARRATIVE ---------------- STUDENT PLACEMENT TESTS PLACEMENT TEST DATA CONSISTS OF THE TEST ID, TEST SCORE, TERM, AND UP TO THREE ADDITIONAL RECOMMENDED COURSES (IF ANY). THIS DATA IS STORED IN STUDENT PLACEMENT TEST SEGMENTS IN THE STUDENT DATA BASE. TRK010 IS THE ONLINE UPDATE PROGRAM THAT MAINTAINS THIS DATA. TRK011 DISPLAYS THIS DATA AND ALSO WILL SHOW THE REGISTRATION STATUS OF THE RECOMMENDED COURSES. TEST DATA IS SHOWN ON REG040, REG351, REG550, TRK040, TRK540, TRK800, AND TRK820. REG220 ADDS AND DELETES ADDITIONAL RECOMMENDED COURSES WHICH ARE NOT RECOMMENDED AS A RESULT OF A PLACEMENT TEST. THE ADDITIONAL REQUIRED COURSE SEGMENT THAT THIS PROGRAM MAINTAINS IS NO LONGER USED FOR STORING PLACEMENT TEST COURSE RECOMMENDATIONS. HIGH SCHOOL/GED INFORMATION AND HIGH SCHOOL COURSES TRK020 IS USED TO VALIDATE HIGH SCHOOL DEGREE, GED, AND ABILITY- TO-BENEFIT DATA. AS HIGH SCHOOL TRANSCRIPTS ARE RECEIVED BY THE COLLEGE, THE INFORMATION CAN BE ENTERED AND MARKED AS RECEIVED BY ENTERING AN 'R' IN THE HIGH SCHOOL VALIDATION TYPE. AFTER AN EVALUATION IS DONE OF THE HIGH SCHOOL INFORMATION, THE VALIDATION CAN BE CHANGED TO ONE OF SEVEN OTHER IDENTIFICATION TYPES (G-GENERAL, B-BUSINESS, C-COLLEGE PREP, S-SPECIAL ED, V-VOC/TECH, U-UNCLASSIFIED, N-NOT GRADUATED). THE GED VALIDATION CAN BE Q-QUALIFIED OR N-NOT QUALIFIED. THE PROGRAM WILL ALSO UPDATE THE HIGH SCHOOL CODE AND YEAR IN THE STUDENT MASTER SEGMENT. THE HIGH SCHOOL CODE MUST AGREE WITH THE VALIDATION. SAT SCORES, GED SCORES, AND CLASS STANDING AND SIZE FIELDS ARE OPTIONALLY KEYED. TRK030 IS USED TO UPDATE HIGH SCHOOL COURSE INFORMATION. COURSE DATA INCLUDES COURSE DEPARTMENT, SEQUENCE NUMBER, YEAR, UNITS, COURSE LEVEL, COURSE TITLE, HIGH SCHOOL CODE, AND NUMERIC AND/OR ALPHABETIC GRADE RECEIVED. TRK120 SHOWS ALL THE HIGH SCHOOL DATA AVAILABLE FOR THE STUDENT. TRK520 PRINTS HIGH SCHOOL DATA FOR SELECTED STUDENTS. CURRICULUM PROGRESS EACH CURRICULUM HAS A MASTER RECORD MAINTAINED BY REF030. REF031 RESEMBLES REF030 BUT MAINTAINS SPECIALIZATION DATA (SPECIALIZATION NAME, FULL AND SHORT NAMES, ABBREVIATION, UP TO 5 DIVISION CODES, AND AN ACTIVE-INACTIVE CODE). IF THE CURRICULUM DOES NOT HAVE SPECIALIZATIONS, THIS SEGMENT IS STILL REQUIRED. ALL DATA WILL DEFAULT FROM THE CURRICULUM MASTER AND THE SPECIALIZATION CODE SHOULD BE SPACES. IF A CURRICULUM DOES HAVE SPECIALIZATIONS, A SPECIALIZATION CODE OF '00' THROUGH '99' CAN BE USED. STANDARDIZATION OF CODES TO BE USED ARE DETERMINED AT EACH COLLEGE. UNDER THE SPECIALIZATION SEGMENT IS ONE OR MORE CATALOG-YEAR SEGMENTS. THIS SEGMENT CONTAINS THE NUMBER OF CREDITS REQUIRED FOR THE DEGREE AND IS MAINTAINED AUTOMATICALLY BY TRK100. TRK100 UPDATES THE COURSE REQUIREMENTS. A CURRICULUM, SPECIALIZATION, AND CATALOG YEAR CAN HAVE REQUIREMENTS FOR A MAXIMUM OF EIGHT TERMS WITH UP TO NINE REQUIREMENTS PER TERM. THE TERM AND SEQUENCE NUMBERS CORRESPOND TO THE COLLEGE CATALOG. THE REQUIREMENT SEGMENT CONTAINS THE COURSE ID, CREDITS, DESCRIPTION, AND MINIMUM GRADE (IF ANY). CREDITS AND DESCRIPTION CAN DEFAULT FROM THE COURSE MASTER. COURSE EQUIVALENTS FOR EACH REQUIREMENT ARE MAINTAINED BY TRK110. THE EQUIVALENT SEGMENT CONTAINS COURSE ID, CREDITS, AND MINIMUM GRADE. THESE SEGMENTS ARE PART OF THE CURRICULUM DATA BASE. THERE ARE TWO BATCH PROGRAMS FOR PRINTING THE CURRICULUM DATA. REF521 PRODUCES A CURRICULUM REFERENCE LIST WHICH SHOWS CURRICULUM DATA, SPECIALIZATION DATA, AND CATALOG YEARS. TRK500 PRINTS CURRICULUM CATALOG OUTLINES FOR ALL OR SELECTED CURRICULA. IF THE CURRICULUM CHANGES WHEN A NEW CATALOG COMES OUT, TRK320 CAN BE RUN TO COPY THE PREVIOUS CATALOG TO THE NEW; THEN THE NEW ONE CAN BE UPDATED AS NECESSARY. THERE IS ALSO AN ONLINE PROGRAM, TRK060, THAT COPIES UP TO FOUR REQUIREMENTS AT A TIME TO ANOTHER CURRICULUM OR CATALOG YEAR. THE CATALOG YEAR IN THE DATA BASE IS THE FIRST YEAR THAT CATALOG WENT INTO EFFECT. THERE WOULD NOT NECESSARILY BE A NEW CATALOG INPUT EVERY YEAR. TRK050 ALLOWS COURSE SUBSTITUTIONS TO BE SPECIFIED FOR A PARTICULAR STUDENT FOR A PARTICULAR CURRICULUM, SPECIALIZATION, AND CATALOG YEAR. THE SUBSTITUTION SEGMENT CONTAINS THE COURSE ID OF THE SUBSTITUTION, THE CREDITS, AND A REQUIREMENT WAIVED CODE. THERE CAN BE MULTIPLE SUBSTITUTIONS PER REQUIREMENT. THE WAIVED CODE IS USED TO INDICATE THE COMPLETION OF A COURSE REQUIREMENT. TRK041S IS A SUBPROGRAM WHICH MATCHES CURRICULAR COURSE REQUIRE- MENTS AND EQUIVALENTS TO A STUDENT'S REGISTRATIONS, TRANSFER COURSES, NON-TRANSFER ADVANCE STANDING COURSES, AND INDIVIDUAL SUBSTITUTIONS. IT BUILDS A TABLE IN THE FORMAT OF A COLLEGE CATALOG. THE TABLE IS PASSED BACK TO THE CALLING PROGRAM TO BE FORMATTED AND PRINTED EITHER IN BATCH OR ONLINE. THE CURRICULUM REQUIREMENTS ARE SHOWN ON ONE SIDE AND THE COURSES SATISFYING THE REQUIREMENTS ARE SHOWN ON THE OTHER. AFTERWARDS, THE CALCULATED CURRICULAR GPA AND TOTALS FOR CREDITS EARNED, CREDITS TRANSFERRED, AND/OR CREDITS GIVEN FOR ADVANCED STANDING ARE PRINTED. ANY COURSES WHICH ARE NOT USED ABOVE ARE SHOWN NEXT. PLACEMENT TEST DATA INCLUDING ADDITIONAL RECOMMENDED COURSES ARE SHOWN AT THE END. A DISCLAIMER AND/OR AN AUDIT CONTROL MESSAGE MAY BE DEFINED AND PRINTED. THERE ARE ALSO OPTIONS TO PRINT CURRENT STATUS AND DIVISION CHAIRMAN SIGNATURE LINES. THE FOLLOWING ASSUMPTIONS HAVE BEEN USED IN THE DESIGN AND PROGRAM DEVELOPMENT OF TRK041S: - THE LAST REGISTRATION, TRANSFER, OR ADVANCED STANDING RECORD A STUDENT HAS WILL BE USED TO SATISFY THE COURSE REQUIREMENT, EQUIVALENT OR SUBSTITUTION. THE PROGRAM COMPARES THE TERMS TO ENSURE THE LATEST ONE IS USED, REGARDLESS OF THE TYPE. - WHEN A STUDENT COMPLETES BOTH AN EQUIVALENT AND THE REQUIREMENT, THE REQUIREMENT WILL BE USED. - WHEN A SUBSTITUTION HAS BEEN POSTED FOR A COURSE REQUIREMENT AND THE STUDENT TAKES THE ORIGINAL REQUIREMENT, THE SUBSTITUTION IS DISREGARDED. THIS APPLIES TO COURSE WAIVERS AS WELL. THE EX- CEPTION IS WHEN THE SUBSTITUTION IS A COURSE COMPLETED MORE RECENTLY THAN THE REQUIREMENT. - COURSE REQUIREMENTS AND EQUIVALENTS FOR WHICH A MINIMUM GRADE HAS BEEN POSTED WILL NOT APPEAR AS COMPLETED WHEN THE STUDENT TAKES THE CLASS BUT DOES NOT EARN A GRADE GREATER THAN OR EQUAL TO THE MINIMUM. EXCEPTIONS TO THIS ARE WHEN THE STUDENT IS CURRENTLY ENROLLED, HAS A TRANSFER OR ADVANCE STANDING RECORD OR WHEN A COURSE SUBSTITUTION HAS BEEN POSTED. - A COURSE SUBSTITUTION POSTED TO WAIVE THE COURSE REQUIREMENT WILL APPEAR WITH ZERO CREDITS EARNED, UNLESS THE STUDENT DOES COMPLETE THE COURSE. - COURSE REQUIREMENTS DEFINED AS 'PHEDEEE' OR 'PED EEE' PERMIT A MATCH ON ANY REGISTRATION, ADVANCE STANDING OR TRANSFER RECORD BEARING THE DEPARTMENTS OF 'PHED', 'HLTH', 'PED ' OR 'HLT '. - CATALOGS DEFINED WITH THE YEARS OF 1988 OR GREATER, ARE CON- SIDERED TO BE SEMESTER-BASED CATALOGS. THE CREDITS COMPLETED ON THE QUARTER SYSTEM ARE CONVERTED TO SEMESTER VALUES. CATALOGS DEFINED WITH YEARS PRIOR TO 1988 ARE QUARTER-BASED. THE CREDITS COMPLETED UNDER THE SEMESTER SYSTEM ARE CONVERTED BACK TO QUAR- TER VALUES. - WHEN A TRANSFER COURSE FULFILLS A SUBSTITUTED COURSE REQUIREMENT THE DESIGNATION 'SB' IS USED INSTEAD OF 'TR'. IN THIS CASE, THE TERM IDENTIFIES THAT THE REQUIREMENT HAS BEEN MET. THERE ARE TWO PROGRAMS THAT CALL TRK041S AND SHOW CURRICULUM PROGRESS. TRK040 IS AN ONLINE INQUIRY PROGRAM WHICH CAN ALSO ROUTE THE OUTPUT TO AN IMS PRINTER. TRK540 IS A BATCH PROGRAM WHICH PRODUCES CURRICULUM PROGRESS REPORTS (CPR'S) FOR SELECTED STUDENTS. IT PROCESSES A FILE OF SELECTED STUDENTS, WHICH CAN BE KEYED INSTREAM OR PREPARED BY A FRONT-END PROGRAM, SUCH AS DYL280. THERE ARE OTHER BATCH PROGRAMS WHICH CALL TRK041S. TRK700 USES IT TO MONITOR STUDENTS WHO HAVE APPLIED FOR GRADUATION. TRK710 USES IT TO GET THE CURRICULUM GPA SO CLASS RANK CAN BE DETERMINED. GRP380 USES IT TO DETERMINE IF THE STUDENT IS READY TO GRADUATE. STU030 IS USED TO RECORD THE STUDENT'S CURRICULUM, SPECIALIZATION, AND CATALOG YEAR. IT IS NECESSARY TO HAVE THIS INFORMATION STORED IN THE STUDENT MASTERS IF YOU WANT TO GENERATE CPR'S IN BATCH. IT ALSO ENABLES TRK040 TO DEFAULT THE CURRICULUM KEY. TO ENABLE BATCH PROCESSING OF PENDING GRADUATES, USE GRD020 TO STORE THE SPECIALIZATION AND CATALOG YEAR AS WELL AS THE CURRICULUM. THE SUBPROGRAM, GRP325S, IS CALLED BY TRK041S TO CONVERT QUARTER CREDITS TO SEMESTER-EQUIVALENT VALUES. THE SUBPROGRAM, REG742S, IS CALLED BY TRK700 AND TRK720 TO PRODUCE MAILING LABELS. THE CPR'S PRODUCED BY THE TRACKING SUBSYSTEM ARE USEFUL TO ADVISORS WHEN ADVISING STUDENTS AND TO STUDENTS AS A TANGIBLE RECORD OF THEIR PROGRESS. IN ADDITION, IT IS AN EFFICIENT TOOL FOR ADMISSIONS AND RECORDS PERSONNEL WHEN EVALUATING PENDING GRADUATES. TRANSFER ASSISTANCE TRANSFER INFORMATION CAN BE ENTERED FOR ANY FOUR-YEAR INSTITUTION IN THE COMMUNITY COLLEGE'S SERVICE AREA. TRK200 MAINTAINS COLLEGE MASTER SEGMENTS AND THE MAJORS THAT ARE DEFINED. COLLEGE AND MAJOR CODES ARE FOUR-CHARACTER ACRONYMS. GENERAL INFORMATION CAN BE ENTERED VIA TRK230, WHICH IS PRINTED AT THE BOTTOM OF THE TRANSFER ASSISTANCE PROFILE. TRK210 MAINTAINS RECOMMENDED COURSES WHICH ARE KEYED BY A SEQUENCE NUMBER. EACH RECOMMENDED COURSE CAN HAVE ONE OR MORE EQUIVALENT COURSES, WHICH ARE MAINTAINED WITH TRK220. EACH EQUIVALENT SEGMENT SPECIFIES ONE OR TWO COURSES THAT CAN SUBSTITUTE FOR THE RECOMMENDATION. THIS DATA IS STORED IN THE TRANSFER ASSISTANCE DATA BASE. IT CAN BE VIEW VIA TRK250 AND PRINTED VIA TRK600 AND TRK610. WHEN A STUDENT REQUESTS TRANSFER INFORMATION FROM THEIR ADVISOR OR COUNSELOR, THEIR SOCIAL SECURITY NUMBER AND COLLEGE CODE AND MAJOR CAN BE ENTERED ON TRK240 TO PRODUCE A TRANSFER ASSISTANCE PROFILE. THE PROFILE CONTAINS UP-TO-DATE INFORMATION ABOUT THE SENIOR INSTITUTION THAT CAN BE VIEWED ON-LINE OR PRINTED ON AN IMS PRINTER FOR THE STUDENT TO HAVE. THE PROFILE LISTS COURSES WHICH CAN BE COMPLETED HERE AT THE COMMUNITY COLLEGE IN PREPARATION FOR TRANSFER. A SUBPROGRAM, TRK241S, IS CALLED TO MATCH THE STUDENT'S REGISTRATIONS AGAINST THESE COURSES TO SHOW WHAT HAS BEEN COMPLETED AND WHAT REMAINS TO BE TAKEN. THERE IS AN OPTION TO USE ADVANCED STANDING AND TRANSFER COURSES TO FULFILL THE RECOMMENDATIONS. ALL SIS COURSES WILL BE INCLUDED ON THE PROFILE. COURSES WHICH DO NOT TRANSFER ARE SHOWN AT THE END. THE FOLLOWING ASSUMPTIONS HAVE BEEN USED IN THE DESIGN AND PROGRAM DEVELOPMENT OF TRK241S: 1. COURSES COMPLETED ON THE QUARTER SYSTEM ARE CONVERTED TO SEMESTER-EQUIVALENT CREDIT PRIOR TO BEING ADDED TO THE TOTAL OF RECOMMENDATIONS COMPLETED. 2. A RECOMMENDED COURSE WILL ALWAYS BE USED INSTEAD OF ANY EQUIV- ALENT COURSES, INCLUDING SEQUENCE COURSES. 3. WHEN A MIX OF QUARTER AND SEMESTER COURSES ARE SPECIFIED AS EQUIVALENTS, THE PROGRAM WILL USE THE QUARTER COURSES FIRST BECAUSE OF THE WAY THE REGISTRATION DATA IS ORGANIZED IN THE DATA BASE. CARE SHOULD BE TAKEN WHEN THE EQUIVALENT DATA IS INPUT, AS CERTAIN STUDENTS MAY HAVE SEQUENCED COURSES IN BOTH QUARTER AND SEMESTER-BASED TERMS, AND THE SEMESTER COURSES ARE PREFERRED. 4. TWO COURSES TO BE TAKEN AS A SEQUENCE CAN BE INPUT AS EQUIVA- LENTS ON THE SAME RECORD. WHEN THE PROGRAM ENCOUNTERS THESE RECORDS IT ATTEMPTS TO USE THEM BOTH; HOWEVER IF THE STUDENT HAS TAKEN ONLY ONE, OR FAILED TO EARN AT LEAST A 'C' IN BOTH, ONLY ONE WILL BE SHOWN. 5. THE PROGRAM WILL ATTEMPT TO USE THE COURSE ONLY WHEN THE GRADE IS AN 'A', 'B', 'C' OR BLANK (INDICATING CURRENT ENROLLMENT). ALL COURSES THE STUDENT HAS TAKEN OR TRANSFERRED IN OR RECEIVED COLLEGE CREDIT FOR, WILL APPEAR SOMEPLACE ON THE PROFILE. 3.0 DATA BASE DESIGN ---------------- S T U D E N T D A T A B A S E ------------ ] STUDENT ] ] MASTER ] ] ] ------------ ________]________ ] ] ] ------------ ------------ ] REGIS- ] ] PLACEMENT] ] TRATIONS ] ] TESTS ] ] ] ] ] ------------ ------------ H I S T O R Y D A T A B A S E ---------- ]STUDENT ] ]HISTORY ] ] ROOT ] ---------- _____________________________]_____________________________ ] ] ] ] ] ] ] -------- -------- -------- -------- -------- -------- -------- ]STUDENT ]]REGIS- ]] ]]ADVANCED]] COURSE ]] HIGH ]] HIGH ] ] MASTER ]]TRATIONS]]TRANSFER]]PLACEMNT]]SUBSTI- ]] SCHOOL/]] SCHOOL ] ] ]] ]] TYPE ]] TYPE ]] TUTIONS]] GED ]] COURSES] -------- -------- -------- -------- -------- -------- -------- ] ] -------- -------- ]TRANSFER]]ADVANCED] ] COURSE ]]PLACEMNT] ] ]] COURSE ] -------- -------- * C U R R I C U L U M D A T A B A S E ------------ ]CURRICULUM] ] MASTER ] ] ] ------------ ] ------------ ] SPECIAL- ] ] IZATION ] ] ] ------------ ] ------------ ] CATALOG ] ] YEAR ] ] ] ------------ ] ------------ ] COURSE ] ] REQUIRE- ] ] MENT ] ------------ ] ------------ ] COURSE ] ]EQUIVALENT] ] ] ------------ * T R A N S F E R D A T A B A S E ------------ ] TRANSFER ] ] COLLEGE ] ] ] ------------ ] ------------ ] ] ] MAJOR ] ] ] ------------ _______]_______ ] ] ------------ ------------ ] RECOM- ] ] TRANSFER ] ] MENDATION] ] TEXT ] ] ] ] ] ------------ ------------ ] ------------ ] ] ]EQUIVALENT] ] ] ------------ * 4.0 PROGRAMS SUMMARIES ------------------ 4.1 REF031 - ENTER CURRICULUM SPECIALIZATIONS THIS ONLINE PROGRAM IS USED TO MAINTAIN THE SPECIALIZATION SEGMENTS FOR CURRICULA. 4.2 REF085 - ENTER MASTER TEST CODES THIS ONLINE PROGRAM IS USED TO MAINTAIN THE PLACEMENT TEST MASTER DATA. 4.3 REF521 - CURRICULUM MASTER REFERENCE LIST THIS BATCH PROGRAM PRINTS A CURRICULUM MASTER REFERENCE LIST TO SHOW DATA FOR THREE SEGMENTS IN THE CURRICULUM DATA BASE. INFORMATION IS SHOWN FOR EACH CURRICULUM, SPECIALIZATION, AND CATALOG YEAR IN CURRICULUM-CODE ORDER. 4.4 REF585 - TEST CODE REFERENCE LIST THIS BATCH PROGRAM PRINTS A MASTER REFERENCE LIST OF TEST CODES SHOWING THE TEST NAME AND MINIMUM REQUIRED SCORE. 4.5 TRK010 - STUDENT PLACEMENT TEST UPDATE THIS ONLINE PROGRAM ADDS AND DELETES STUDENT PLACEMENT TEST RECORDS FOR A STUDENT. THE SCREEN WILL ALLOW UP TO TWELVE UNIQUE TESTS PER STUDENT, WITH UP TO THREE COURSE RECOMMENDATIONS PER TEST. 4.6 TRK011 - STUDENT PLACEMENT TEST INQUIRY THIS ONLINE PROGRAM DISPLAYS PLACEMENT TEST DATA FOR A STUDENT. THE REGISTRATION STATUS IS SHOWN FOR THE ADDITIONAL RECOMMENDED COURSES. 4.7 TRK020 - HIGH SCHOOL DEGREE/GED UPDATE THIS ONLINE PROGRAM IS USED TO UPDATE HIGH SCHOOL DEGREE, GED, AND ABILITY-TO-BENEFIT DATA. IT INSERTS, UPDATES AND DELETES THE STUHEXTE SEGMENT (COPY MEMBER STUXHSDG) IN THE HISTORY DATA BASE. THE PROGRAM WILL ALSO UPDATE HIGH SCHOOL CODE AND HIGH SCHOOL DEGREE/GED YEAR IN THE STUDENT MASTER RECORD. 4.8 TRK030 - HIGH SCHOOL COURSE UPDATE THIS PROGRAM IS USED TO UPDATE STUDENT HISTORY HIGH SCHOOL COURSE SEGMENTS. THE DATA UPDATED INCLUDES COURSE DEPART- MENT, SEQUENCE NO., YEAR, UNITS, GRADE, COURSE LEVEL, COURSE TITLE, AND HIGH SCHOOL CODE. THE PROGRAM CAN DISPLAY MORE THAN ONE PAGE OF COURSES, WITH UP TO 15 COURSES PER PAGE. THE HIGH SCHOOL CODE WILL DEFAULT FROM THE STUDENT MASTER. 4.9 TRK040 - STUDENT TRACKING INQUIRY THIS PROGRAM IS USED TO INQUIRE ON A STUDENT'S CURRICULUM PROGRESS. INFORMATION PASSED BACK FROM TRK041S IS PRESENTED ON THE SCREEN AND CAN BE ROUTED TO A PRINTER. THE CURRICULUM REQUIREMENTS ARE SHOWN ON ONE SIDE AND THE COURSES SATISFYING THE REQUIREMENTS ARE SHOWN ON THE OTHER. 4.10 TRK041S - CURRICULUM PROGRESS REPORT SUBPROGRAM TRK041S IS A SUBPROGRAM WHICH MATCHES CURRICULAR COURSE REQUIREMENTS AND EQUIVALENTS TO A STUDENT'S REGISTRATIONS, TRANSFER COURSES, NON-TRANSFER ADVANCE STANDING COURSES, AND INDIVIDUAL SUBSTITUTIONS. IT BUILDS A TABLE IN THE FORMAT OF A COLLEGE CATALOG. THE TABLE IS PASSED BACK TO THE CALLING PROGRAM TO BE FORMATTED AND PRINTED EITHER IN BATCH OR ONLINE. 4.11 TRK050 - CURRICULUM COURSE SUBSTITUTION THIS ONLINE PROGRAM IS USED TO ADD, UPDATE, AND DELETE COURSE SUBSTITUTIONS. 4.12 TRK060 - CURRICULUM CATALOG COURSE COPY UPDATE THIS ONLINE PROGRAM IS USED TO COPY REQUIREMENTS AND EQUIVALENTS FROM ONE CURRICULUM TO ANY OTHER CURRICULUM OR CATALOG YEAR. 4.13 TRK100 - CURRICULUM COURSE REQUIREMENTS THIS ONLINE PROGRAM IS USED TO ADD, UPDATE AND DELETE COURSE REQUIREMENTS IN THE CURRICULUM DATA BASE. 4.14 TRK110 - CURRICULUM COURSE EQUIVALENTS THIS ONLINE PROGRAM IS USED TO ADD, UPDATE AND DELETE COURSE EQUIVALENTS IN THE CURRICULUM DATA BASE. 4.15 TRK120 - HIGH SCHOOL/GED INQUIRY THIS PROGRAM IS USED AS AN INQUIRY TO VIEW A STUDENT'S HIGH SCHOOL OR GED DATA, INCLUDING HIGH SCHOOL COURSES. 4.16 TRK130 - CURRICULUM CATALOG INQUIRY THIS ONLINE PROGRAM IS USED TO VIEW CURRICULUM CATALOG REQUIREMENTS OR THE EQUIVALENT COURSES FOR A REQUIREMENT. 4.17 TRK200 - TRANSFER ASSISTANCE COLLEGE/MAJOR UPDATE THIS ONLINE PROGRAM IS USED TO UPDATE THE TRANSFER ASSISTANCE COLLEGE SEGMENT AND THE TRANSFER ASSISTANCE MAJOR SEGMENT IN THE TRANSFER DATA BASE. 4.18 TRK210 - TRANSFER ASSISTANCE RECOMMENDATION UPDATE THIS ONLINE PROGRAM IS USED TO ADD, UPDATE, AND DELETE COURSE RECOMMENDATIONS IN THE TRANSFER DATA BASE FOR THE COLLEGE CODE AND MAJOR. 4.19 TRK220 - TRANSFER ASSISTANCE COURSE EQUIVALENT UPDATE THIS ONLINE PROGRAM IS USED TO ADD, UPDATE, AND DELETE COURSE EQUIVALENTS IN THE TRANSFER DATA BASE. 4.20 TRK230 - TRANSFER ASSISTANCE TEXT UDPATE THIS ONLINE PROGRAM ALLOWS THE USER TO ENTER TRANSFER ASSISTANCE TEXT FOR A PARTICULAR COLLEGE AND MAJOR. THE PROGRAM WILL ALLOW UP TO THREE TEXT LINES OF DATA PER RECORD WITH UP TO 99 RECORDS ALLOWED. 4.21 TRK240 - TRANSFER ASSISTANCE INQUIRY THIS PROGRAM IS USED TO PRODUCE TRANSFER ASSISTANCE PROFILES. INFORMATION PASSED BACK FROM TRK241S IS PRESENTED ON THE SCREEN AND CAN BE ROUTED TO A PRINTER. THE TRANSFER RECOMMENDATIONS ARE SHOWN ON ONE SIDE AND THE COURSES SATISFYING THE RECOMMENDATIONS ARE SHOWN ON THE OTHER. 4.22 TRK241S - TRANSFER ASSISTANCE PROFILE SUBPROGRAM TRK241S IS A SUBPROGRAM WHICH MATCHES TRANSFER RECOMMENDATIONS TO A STUDENT'S REGISTRATIONS, AND OPTIONALLY TO TRANSFER COURSES AND ADVANCED STANDING COURSES. IT BUILDS A TABLE THAT IS PASSED BACK TO THE CALLING PROGRAM TO BE FORMATTED FOR DISPLAY AND/OR PRINT. 4.23 TRK250 - TRANSFER ASSISTANCE CATALOG THIS ONLINE PROGRAM IS USED TO VIEW TRANSFER INFORMATION, INCLUDING COURSE RECOMMENDATIONS AND THEIR EQUIVALENTS, FOR A COLLEGE AND MAJOR. IT ALSO DISPLAYS MAJORS FOR A COLLEGE. 4.24 TRK300 - DELETE STUDENT TRACKING RECORDS THIS BATCH UPDATE PROGRAM DELETES PLACEMENT TESTS. CHOOSE ONE OR MORE OF THREE DELETION-CRITERIA OPTIONS. OPTION "G" DELETES DATA FOR GRADUATES. OPTION "I" DELETES DATA FOR INACTIVE STUDENTS. A STUDENT IS CONSIDERED INACTIVE IF THEY HAVE NOT ENROLLED DURING A SPECIFIED RANGE OF TERMS. OPTION "T" DELETES DATA FOR STUDENTS WHO TOOK THEIR PLACEMENT TESTS PRIOR TO A SPECIFIC TERM AND NEVER ENROLLED. DELETED RECORDS ARE SHOWN ON A REPORT AND ARE WRITTEN TO TAPE. 4.25 TRK320 - CURRICULUM CATALOG CREATE THIS PROGRAM WILL CREATE A NEW CURRICULUM CATALOG FROM A PREVIOUS CATALOG. THE PROGRAM CAN BE RUN TO COPY ALL CURRICULA FOR THE YEAR OR ONE SELECTED CURRICULUM. 4.26 TRK330 - UPDATE CURRICULUM LEVEL THIS PROGRAM WILL UPDATE THE CURRICULUM LEVEL. 4.27 TRK500 - CURRICULUM CATALOG REPORT THIS PROGRAM PRODUCES A LISTING OF CURRICULUM CATALOG OUTLINES. THE PROGRAM CAN BE RUN FOR ALL CURRICULA, CURRICULA OF A PARTICULAR DEGREE TYPE, OR SELECTED CURRICULA. 4.28 TRK520 - STUDENT HIGH SCHOOL/GED HISTORY THIS PROGRAM READS A FILE OF SELECTED STUDENTS AND PRODUCES A REPORT WHICH SHOWS STUDENT HIGH SCHOOL AND GED DATA. 4.29 TRK540 - BATCH CURRICULUM PROGRESS REPORT THIS BATCH PROGRAM READS A FILE OF SELECTED STUDENTS AND PRINTS CURRICULAR PROGRESS REPORTS BY CALLING TRK041S TO FORMAT THE OUTPUT. 4.30 TRK600 - TRANSFER ASSISTANCE REPORT THIS BATCH PROGRAM PRODUCES A LISTING OF TRANSFER INFORMATION FOR COLLEGE/MAJORS, INCLUDING COURSE RECOMMENDATIONS AND EQUIVALENTS. 4.31 TRK610 - TRANSFER ASSISTANCE COLLEGES AND MAJORS THIS BATCH PROGRAM PRODUCES A LISTING OF TRANSFER COLLEGES AND MAJORS. 4.32 TRK700 - PENDING GRADUATES WITH UNMET REQUIREMENTS THIS BATCH PROGRAM PRINTS A LISTING OF STUDENTS WHO HAVE APPLIED FOR GRADUATION SHOWING THE UNMET REQUIREMENTS. 4.33 TRK710 - GRADUATE HONORS AND CLASS STANDING THIS BATCH PROGRAM PRINTS A LISTING OF STUDENTS WHO HAVE APPLIED FOR GRADUATION AND HAVE COMPLETED OR ARE ENROLLED IN COURSES WHICH SATISFY ALL CURRICULAR REQUIREMENTS. THE PROGRAM DETERMINES HONOR STUDENTS BASED ON CURRICULAR GPA AND RANKS THE STUDENTS BY GRADUATE CURRICULUM. 4.34 TRK720 - STUDENTS IN SELECTED CURRICULA THIS IS A BATCH PROGRAM WHICH PROVIDES AN EVALUATION OF REQUIREMENTS AND EQUIVALENTS FOR A SELECTED CURRICULUM PROGRAM AGAINST A STUDENT'S REGISTRATION AND ADVANCED STANDING COURSES. 4.35 TRK730 - REMEDIAL CLASS MISMATCH REPORT THIS BATCH PROGRAM PRODUCES A LIST OF REMEDIAL COURSE RECOM- MENDATIONS AND REMEDIAL COURSE REGISTRATIONS. 4.36 TRK740 - GRADUATE REMEDIATION ASSESSMENT THIS BATCH PROGRAM PRODUCES A GRADUATE REMEDIATION ASSESSMENT REPORT BY DEGREE TYPE. 4.37 TRK800 - STUDENT PLACEMENT TEST RESULTS THIS PROGRAM PRODUCES LABELS (IF DESIRED) AND A REPORT SHOWING NAME, SOCIAL SECURITY, ADVISOR, TEST CODE, SCORE, EVALUATION TERM, COURSE RECOMMENDATIONS, AND THE COMPLETION STATUS FOR THE COURSE RECOMMENDATIONS (COMPLETED, ENROLLED, OR PENDING WITH THE NUMBER OF ATTEMPTS SHOWN). THE DATA CAN BE SELECTED FOR A PARTICULUAR TERM, CAMPUS, OR TEST. 4.38 TRK820 - STUDENT PLACEMENT SCORES BY CLASS THIS PROGRAM PRODUCES A LIST OF ALL STUDENTS REGISTERED IN SELECTED COURSES (UP TO 500) FOR A TERM. THE REPORT SHOWS THE PLACEMENT TEST DATA (IF ANY) ALONG WITH COURSE INFORMATION (CREDITS, DIVISION, INSTRUCTOR, AND CLASS TITLE). THE DATA IS SORTED BY COURSE ID. WITHIN DIVISION. 4.39 TRK840 - SELECTED STUDENTS WITHOUT TEST SCORES THIS PROGRAM SELECT STUDENTS WITHOUT TEST SCORES. 5.0 IMPLEMENTATION PROCEDURE ------------------------ DATA CANNOT BE ENTERED FOR A STUDENT WHO DOES NOT HAVE AN ACTIVE, VALID APPLICATION TO THE COLLEGE. BEFORE STUDENT PLACEMENT TESTS CAN BE ENTERED, THE MASTER TEST CODES AND TITLES MUST BE DECIDED AND ENTERED VIA REF085. THIS DATA CAN BE PRINTED WITH REF585. HIGH SCHOOL MASTER DATA IS NEEDED FOR THE HIGH SCHOOL/GED PART OF THE SUB-SYSTEM. TRANSFER COLLEGE FICE CODES ARE USED IN THE TRANSFER ASSISTANCE PART AND FOR THE CURRICULUM PROGRESS COMPONENT. ADVANCED STANDING CODES ARE ALSO READ. THE CAMPUS MASTER IS USED. OTHER CONTROL DATA USED INCLUDES THE MESSAGE MASTER AND PROGRAM OPTION SEGMENTS. TO RUN CPR'S, THE CURRICULUM DATA MUST BE ENTERED USING REF031, TRK100, AND TRK110. YOU MAY WANT TO START WITH THE CURRICULA FOR WHICH STUDENTS HAVE APPLIED TO GRADUATE. BEFORE RUNNING TRK540, STU030 IS USED TO ASSIGN THE CURRICULUM, SPECIALIZATION, AND CATALOG YEAR FOR EACH STUDENT. GRD020 IS USED TO ASSIGN CURRICULUM, SPECIALIZATION, AND CATALOG YEAR ON STUDENT GRADUATE SEGMENTS. PRIOR TO USING TRK240, THE TRANSFER ASSISTANCE DATA MUST BE ENTERED VIA TRK200, TRK210, TRK220, AND TRK230. 8.0 CHANGE HISTORY -------------- 8.1 VERSION NO: V3.07 CHANGE DATE: 02/17/88 PROGRAMMER NAME: DIANE LIVELY, JSRCC PROGRAM CHANGE REQUEST NO: NEW RELEASE 8.2 VERSION NO: V4.09 CHANGE DATE: 01/11/90 PROGRAMMER NAME: S. EDMONDS PROGRAM CHANGE REQUEST NO: 00004497 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION BY ADDING THE FOLLOWING PROGRAMS TO THE 4.0 PROGRAM SUMMARY SECTION: TRK020 TRK030 TRK040 TRK041S TRK050 TRK100 TRK110 TRK120 TRK130 TRK320 TRK500 TRK520 TRK540 8.3 VERSION NO: V4.11 CHANGE DATE: 03/16/90 PROGRAMMER NAME: DIANE LIVELY, JSRCC PROGRAM CHANGE REQUEST NO: 00005019 DESCRIPTION OF CHANGE: EXPANDED DOCUMENTATION TO INCLUDE A DISCUSSION ON THE HIGH SCHOOL/GED INFORMATION THAT CAN NOW BE STORED AND THE CURRICULUM PROGRESS PART OF THE SYSTEM. ADDED PROGRAM SUMMARIES FOR REF031, TRK700, TRK710, AND REF521. 8.4 VERSION NO: V4.20 CHANGE DATE: 12/12/90 PROGRAMMER NAME: DIANE LIVELY, JSRCC PROGRAM CHANGE REQUEST NO: 00007069 DESCRIPTION OF CHANGE: EXPANDED DOCUMENTATION TO INCLUDE A DISCUSSION ON TRANSFER TRACKING. ADDED TRN DATA BASE AND PROGRAM SUMMARIES FOR TRK200, TRK210, TRK220, TRK230, TRK240, TRK241S, TRK250, TRK600, TRK720, AND TRK740. 8.5 VERSION NO: V4.28 CHANGE DATE: 11/15/91 PROGRAMMER NAME: DIANE LIVELY, JSRCC PROGRAM CHANGE REQUEST NO: 00008705 DESCRIPTION OF CHANGE: REVISED THE DOCUMENTATION TO REFLECT THE CHANGES MADE TO THE PLACEMENT-TEST AREA OF TRACKING IN V4.26. TWO ADDITIONAL RECOMMENDED COURSES WERE ADDED TO THE COPYLIB MEMBER FOR THE PLACEMENT TEST SEGMENT, AND THE PROGRAMS WERE CHANGED TO NO LONGER USE THE RECOMMENDED COURSE SEGMENT IN THE STUDENT DATA BASE. ADDED PROGRAM SUMMARIES FOR TRK011, TRK060, TRK610, AND TRK730.