1 / 20

Adding and Receiving IGETC, CSU GE Areas on Transcripts

Learn how to add and receive IGETC and CSU GE areas on transcripts, including data gathering, setup, and attribute conversion.

tjimmie
Télécharger la présentation

Adding and Receiving IGETC, CSU GE Areas on Transcripts

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. Session Number: Adding and Receiving IGETC, CSU GE Areas on Transcripts Lee McDonald Ahsen Baig College of the Sequoias California Community Colleges Banner Group • 2012

  2. Where do I find the data? • Articulation Officer • Catalogs • Those doing CSU GE and IGETC Certification • Degree Audit system California Community Colleges Banner Group • 2012

  3. Where does it go in Banner • SCADETL – Degree Attributes • scrattr • SSADETL – Degree Program Attributes • ssrattr • SHATCKN – Person Course Attributes – Pre Banner • shrattr • SHATCKN – Course Section Attributes – Banner • shrattc

  4. What is involved? • Will involve many individuals cooperation across campus/district • Articulation team to verify and review the data • Review the data for logical errors such as term conversions. Can be useful to have excel do formatting, filtering, checking and converting. • Everyone has a different environment, setup and data, so evaluate each step and modify as needed

  5. Setup • Initial data gathering • Excel ideal program to setup for initial input. Basic setup: • Verify data with articulation team, this is very critical since this will affect many records.

  6. Setup – part 2 • Run the procedure from package: BEGIN     COS_GE_VALIDATION.COS_GE_VAL(); END;Note: Please modify the file to adjust for your needs.  Our pre-Banner catalog was 200310 (Fall 2002) term and started using Banner catalog 200320 (Spring 2003).  Schedules and course work in Banner began 200420 (Spring 2004). Also we stored the old course names in the shrtckn_course_comment, please read the notes in the package body for more details.

  7. COS GE Validation Issue • If articulation isn’t entered properly can result in bad data and cleanup will become difficult. • The process creating the attributes is a very processor intensive process will take several hours so set a time for it to run when load is minimal.

  8. Adding it to the transcript • Modified shrtrtc.pc • Created package with functions to support • Uses function COS_GE_ATTR for institutional courses creates the text that is printed • Added table to map Banner attributes to the CSU or IGETC code. • Since the logic for formatting the line is in the function, the mod to shrtrtc.pc is simple

  9. Banner Attribute Conversion

  10. Next Step • Add GE Summary to the transcript • First try was not accepted • Approach was simple, but too general • Didn’t handle exclusions • Didn’t use some courses as desired (US History)

  11. The Electronic Transcript • We use Credentials – they take the shrtrtc.lis file and build the eTransCA transcript • Shouldn’t be too hard to create the code to populate the appropriate fields in the file • They go in the 08E – Course Detail record • Populate the Eligible fields even if you populate the applied fields

  12. The Electronic Version (GE View)

  13. Importing Attributes – Banner Way • SHREDIP process loads the transcript • The applied attributes are in the RAP record • The eligible attributes are in the NTE record • SHREDIP can read the RAP and NTE records but only loads the data into the transcript image view

  14. Importing Attributes – COS Way • Created table SZRCRAP for the applied attributes • In SHREDIP – added insert into SZRCRAP • Created table SZRCNTE for the eligible attributes • In SHREDIP – added insert into SZRCNTE • The attributes are now available for usage

  15. I Have Attributes, Now What? • Need to add functionality to SHATAEQ • Read SZRCNTE table • Save the local attribute code in SHATRTA (shrtrta) • Use the Attribute Conversion table • Modify our Local Ed Plan to incorporate the transfer work and attributes

  16. Transfer Work on Transcripts • Banner prints articulated course, not original • We want the course as taken at original school • We will need to add the attributes • In the GE summary • Do we include transfer work – Pass Along? • If so, how do we distinguish?

  17. One Big Problem • Currently, for many colleges (but not all), we get bad attribute data from XAP • Every course has a RAP record for CSU American Instituions • Happens with both Banner and non-Banner schools • Doesn’t happen for all Banner schools • If you see the problem, report it XAP • More complaints, faster action, maybe?

  18. What should you do? • Get the mini-grants for transcripts • Free money!! • Two grants • One for putting attributes in your transcripts • One for loading attributes into you SIS (Banner) • Get your attributes into your transcripts • Helps receiving institutions and hence students • We share code to make it easier

  19. Contact Us • College of the Sequoias • Lee McDonald • leem@cos.edu • 559-737-6189 • Ahsen Baig • ahsenb@cos.edu • 559-737-6192

More Related