Student Information System SIS Report Presentation to the

Student Information System (SIS) Report Presentation to the UTFAB December 1, 2020 D Tobiassen Baitinger, Director, Office of the Registrar Josh Clark, Director, Information Systems Chris Seng, Special Advisor, Vice President Enrollment and Access

SIS Project Background • Partnership with UTFAB began in 2004 • Includes hardware, software and staffing for the Project • SIS = RAMweb, ARIESweb, FAMweb, RAM Mobile, Banner and more systems • The SIS and staff serve: – Students – Faculty, advisors – Applicants, Alumni

Credential Solutions Oracle Application Server Banner Forms Oracle IAS Oracle Application Server Self Service Banner Oracle IAS Transferology Paradigm u. direct Sunapsis u. achieve Academic Works EMS Next. Gen Course. Leaf(CAT, CIM) Terra Dotta BDMSPROD sql. PROD Slate (Admissions) e. ID Aetna (Health Ins) Semester at Sea Ascension (Hlth Ins) RMS (Housing) Notifi (housing mail) Campus Loan Mgr Kuali Finance Maxient (Conduct) Beacon Web. Focus Clock. Works (RDS) SAN ALMA (Library) Canvas ODSPROD BANPROD Oracle H/R e. Thority Everfi (Alcohol edu) Ram. Mobile Sales. Force (INTO) Education Adv Bd BDMS IIS USPS Address Verify RAMweb/ARIESweb IIS /. Net Shib Svc Provider Authenticated via Shibboleth Authenticated via e. ID Server IIS /. Net SIS Ecosystem RAMweb IIS /. Net Shib Svc Provider Load Balancers User Active Directory LDAP Shibboleth Identity Provider

SIS Ecosystem

Login Count for 2020 Application RAMweb Login Count 4, 100, 348 RAMrecords 79, 563 RAMmobile 892, 470 FAMweb 605, 267 ARIESweb 252, 481

Magnitude of the SIS – AY 19/20 • Registrations per Academic Year ~77, 600 • Financial Aid - $358 M • RAMweb logins 4. 1 M • Tuition and Fee Assessment - $621 M • Degree Audits run – 223, 284 • Electronic Graduation Contracts – 7, 119 • Spring 2020 Ce. Diploma Download – 1, 571

Magnitude of the SIS – AY 19/20 • College transcripts received and reviewed – 16, 303 – Domestic: 15, 398 – International: 905 • Grades collected – 298, 538 • Course sections managed – 20, 336 • BDM academic records – 194 K documents; 1. 1 M pages • Local Address collected – 22, 034 22 K off campus + 5 K dormitory = 27 K total local address

CSU System Joint Banner Project • Project initiated by Board of Governors and Chancellor Tony Frank • Migrate CSU Pueblo from their in-house developed SIS to CSU Banner system • Consolidation to reduce costs and create opportunities for sharing over the long term • 34 -month project, project team and staff from both institutions, three vendors • Upgrade the CSU Banner environment to a Multi Entity Platform (MEP) – Done! • CSU Pueblo Milestones – Admissions – August 2020 – Financial Aid – October 2020 – Registration – March 2021 – Accounts Receivable – June 2021

Completed Projects - RAMweb • Developed S/U Grade request page (SP 20) – Grade of “A”, “B”, “C” changed to “S” – Grade of “D” and “F” changed to “U” • Implemented CARES Act Fund ($8. 7 M in Emergency Fin Aid Grants) • Implemented Ce. Diploma • Implemented Live Chat • Daily Symptom Tracker/Reporter • Added “Basic Needs” link in My Success Panel • No contact ASCSU Election result delivery

Completed Projects - RAMweb • Improved versions of Weekly Class Schedule – FTF/hybrid/online class delivery • Accessibility improvements • Added Campus Safety Questions • Direct deposit sign up - 2, 500+ students have completed • Multi factor authentication/DUO is in place for direct deposit • Payment Plan - Over 1, 000 students and families

Completed Projects – ARIESweb/Other • Upgraded Excel version for all reports • Updated text to use “Legal Gender or Sex Marker” • Created S/U grade change processing tool (SP 20 only) Nearly 8, 600 grades changes were processed, 4, 600 students took advantage of this system • Contact Tracer Tool

New Additions to RAMweb Homepage Daily Symptom Reporter Basic Needs (undergrad only)

Ce. Diploma Credential Validation Page Ce. Diploma Overview Page

Weekly Class Schedule

Live Chat

Live Chat Statistics • Went live in April 2020 • 8, 385 chats were answered as of November 30, 2020

Banner Quarterly Upgrades 2020 (as of 12/6/2020) • BA AR 8. 7 • BA STUDENT 8. 20 • BA AR 9. 3. 16 • BA STUDENT 8. 20. 0. 1 • BA DMS INT 9. 2. 1 (BDM) • BA STUDENT 8. 20. 1 • BA DMS INT 8. 7. 4. 1 (BDM) • BA STUDENT 9. 3. 20 • BA GENERAL 8. 12. 2 • Ethos Identity 5. 10. 0 • BA GENERAL 9. 3. 18 • BA GENERAL CMN DB 9. 21 • BA Extensibility-Page Builder 9. 7 • • BA GEN ADMIN COMMON 9. 3. 22 BA GENERAL COMMGMT 9. 7. 1 (BCM) • BA GEN APPNAV 3. 3. 1 • BA ETHOS API DB UPGRADE 9. 21 • BA STU API 9. 21

Projects Under Way… • Seating Chart & Solution for Contact Tracer Team • Electronic Major/Minor Changes • ARIESweb New Design

FY 21 Funding Request: $833, 363 FY 21 Budget Difference $ % FY 21 Actuals Software (incl. maintenance) $ 384, 786 $ 12, 344 3. 2% $ 372, 442 Staff salary increases + fringe $ 438, 577 $ (2, 244) (. 05)% $ 440, 821 Student salaries $ Subtotals $ 10, 000 $ - 0% $ 10, 000 833, 363 $ 10, 100 1. 2% $ 823, 263

Sharing the costs. . . • FY 21 request: • FY 21 Spend: $833, 363 $823, 264 – UTFAB + Univ match + I. S. support – Any additional costs absorbed centrally – University matches UTFAB support and more

SIS Budget Projection thru FY 24

Thank You for the Partnership • Collaboration with UTFAB began in 2004 • We appreciate your support of the project – SIS is critical core infrastructure – Systems are performing exceptionally well Contact: christopher. seng@colostate. edu