Cal Poly DegreeWorks

1
Cal Poly - DegreeWorks
2
CLA Orientation May 14th, 2001 Cal Poly UU220

• Session one 900 - 1000 a.m.
• Session two 1000 - 1100 a.m.
• Cal Poly project goals -- Kimi Ikeda
• Overview of the bridge -- Richard Grise
• Overview of the WEB interface OnLineDemo
• Questions/comments/concerns -- Kimi Ikeda

3
Cal Poly DegreeWorks Project Goals
Kimi Ikeda , Team Lead
4
Project Goals Phase I Background

• Accurate and timely progress to degree advice
  for students, advising staff, and faculty
• Provide a statement of requirements remaining,
  with advice
  regarding how to complete those requirements.
• Indicate requirements satisfied,
  with
  information regarding how they were completed.
• Degree credit evaluation tool for use in
  Academic Records
• SRN Presentations on campus
• Site visits
• Software choice POWER BOOST

5
Project Goals Phase I Background

• Phase I Objectives
• complete undergraduate population ( Cal Poly
  and transfer coursework )
• opportunity to support knowledge transfer for
  retiring staff
• Analysis of student population across colleges
  and catalogs
• choice of starting catalog ( 1998 )
• Roll-out Plan by College by major by
  Catalog
• Timeline 18 Months Fall 2000 - Spring 2002

6
Project Structure Background

• Steering Committee
• membership David Conn, Linda Dalton, Joe
  Grimes, Harry Hellenbrand, Kimi Ikeda (chair),
  Euel Kennedy, David Ross, George Yelland.
• Implementation Team
  membership Donna Amos, David Conn,
  Kimi Ikeda (chair), Jennifer Thoma, Dee Ann
  Wells, Mary Whiteford, Dean Wittke
• DGW Advisory Subcommittee
• membership Shelley Aleshire, Stacey
  Breitenbach, Matt Harris, Doug Keesey, Kimi Ikeda
  (chair), Cindy Jelinek, Bonnie McKim, Ellen
  Notermann, Wendy Spradlin, Patricia Stoneman,
  Dave Wehner, Dee Ann Wells, Peggy Smith-Anderson.

7
DegreeWorks for Academic Advising
Richard Grise, OAR

• The Bridge

8
INTERFACE between Cal Poly SIS Student Data and
DegreeWorks
9
SIS SOURCE DegreeWorks
TARGET

• Student Data is extracted from SIS databases
  using Initial Aggregate Paradigm
  
  .
  
  ( Primary Operational
  Datastore )
• Coordination of SIS data amongst Bridge
  Data occurs
  intra-dependencies
• Opportunities for Data Transformation have been
  considered and explored

10
SIS Data is extracted and formatted and initial
data integrity checks performed
Student Master (R010, R050, R020)
PrimaryStudent USCP, GWR ID, Name.. Student
TERM HS/TR Pointers
Degree Detail (R030)
SIS
College, Degree, Major, Catalog...
Class Term Detail(R070)
Term, Course-ID, Grade Info, Flags Cumulative
term-specific info..
Transfer Detail (R080)
Course Info, Equivalency mappings, Credit, Grade
Catalog...
Other (R190DEQV, R130NOTE, R700ETSM,R800UCXT, )
UCX, ETS, Transfer Eqv, Flags, Notes, DELID,
CHGID...
11
DegreeWorks Bridge Data
Relationships
RAD-PRIM-MST Master Record Basic Info
STU-ID NAME ASSOC-TYPESTU
RAD-STUDENT-MST Last-Active-Term
STU-ID TR-CRED/DEG HS-DATE/GPA TERM
RAD-DEGREE-DTL Student Goal APS
RAD-CLASS-DTL Courses taken this TERM
STU_ID CRS-ID GRADE/INSUFF/AUDIT/..flags TERM
12
Cal Poly Data is sent to the DegreeWorks Host via
File Transfer (FTP) and Loaded into DAP/RAD
DegreeWorks Audit Process (DAP)
CalPoly
RAD11 Bridge Processor
Repository for Audit (RAD)
DegreeWorks Applications
13
Cal Poly Data is sent to the DegreeWorks Host via
File Transfer (FTP) and Loaded into DAP/RAD
DegreeWorks Audit Process (DAP)
CalPoly
RAD11 Bridge Processor
Repository for Audit (RAD)
DegreeWorks Applications
14
Overview of the DegreeWorks WEB Interface
Rosa Jones, OAR EVAL
15
Topics covered during Training

• Audit Results
• What-If Panel
• Notes
• Exception Processing
• Other Data

16
Presentation Wrap-Up
Kimi Ikeda
Questions
Comments
Concerns . . .