The CDG Data extract report will be used to gather all information together for preparing the Course Design Guide used in new developments/revisions.

The report can be accessed via the Reports tab in CIMS.

Types of Reports

CDG Prep Report - WIll include the data from the most current records for all courses with open projects in MPS for the selected term. 

Required Parameter - select term (options from CIMS timeline)

Report will include data for all courses with open projects in MPS for the specified term. 

On Demand Report - WIll include the data from the most recent records and open projects in the MPS for all active and not yet active courses for the selected parameters.

Select from following Parameters

School - multi-select from options 

Select All or 

Select specific Schools (options from CIMS Schools List)

Course - multi-select from options 

All Active or 

Select specific Courses (options from Active and Not Yet Active Courses in course list for School(s) selected)

Format for Both Reports

Report Title - CDG Data Extract [Date of Report] [List any selected parameters i.e.[Term]; [School]; [Coruse]] 

Note: In the case that all courses are selected in an On jDemand Report, then the Course will show as ALL.  If less than all but more than ten courses are selected, then the Course will show as the number of courses selected:Course(s): [12]

Report includes the following fields for excel format export with all fields as text format 

Report Columns:

School (From Course List School field)

Course (List course number of all courses with open projects on MPS term selected for CDG Prep Report OR All Active and Not Yet Active Catalog Courses in Course List for parameters selected in On Demand Report)

Course Title (From Course List)

Course Description (From Course List)

Prerequisites (From Course List)

Credit Hours (From Course List)

Degree Type (From Course List)

Course Type (From Course List)

Related Courses (From Course List)

Department Chair (From Course List)

Department Chair email (From Course List)

Third-Party Tools (From Course List)

UTA Status (From Course List)

ADOC (From Course List)

ADOC email (from the user list) 

The below Outcomes will pull from the Outcome Repository's current outcome data for the associated course.  The number of columns that will have data will vary depending on the number of outcomes within a course.   There should be 1 column for each outcome (including GELs and PCs) associated with the course that contains the following data from Outcomes Repository: [Outcome Code] [Outcome Description] [Blooms Level] 

Course Outcome 1 Example -  HN115-1 Explain the role of the human services professional in serving clients’ needs. 2:Comprehension

Course Outcome 1

Course Outcome 2

Course Outcome 3

Course Outcome 4

Course Outcome 5

Course Outcome 6

GEL Outcome 1 Example: GEL-8.03 Apply critical thinking to formulate a logical solution to a problem. 0:Not Assigned

GEL Outcome 2

PC Outcome 1

PC Outcome 2

Number of the below Textbook columns that will contain data will vary depending on how many current textbooks are associated with course

Text1 Title (from current textbooks associated with course)

Text1 Edition(from current textbooks associated with course)

Text1Author(from current textbooks associated with course)

Text1 Publisher(from current textbooks associated with course)

Text1 Physical ISBN(from current textbooks associated with course)

Text1 eBook ISBN(from current textbooks associated with course)

Text2 Title (from current textbooks associated with course)

Text2 Edition(from current textbooks associated with course)

Text2 Author(from current textbooks associated with course)

Text2 Publisher(from current textbooks associated with course)

Text2 Physical ISBN(from current textbooks associated with course)

Text2 eBook ISBN(from current textbooks associated with course)

Text3 Title (from current textbooks associated with course)

Text3 Edition(from current textbooks associated with course)

Text3 Author(from current textbooks associated with course)

Text3 Publisher(from current textbooks associated with course)

Text3 Physical ISBN(from current textbooks associated with course)

Text3 eBook ISBN(from current textbooks associated with course)

Text4 Title (from current textbooks associated with course)

Text4 Edition(from current textbooks associated with course)

Text4 Author(from current textbooks associated with course)

Text4 Publisher(from current textbooks associated with course)

Text4 Physical ISBN(from current textbooks associated with course)

Text4 eBook ISBN(from current textbooks associated with course)

Text5 Title (from current textbooks associated with course)

Text5 Edition(from current textbooks associated with course)

Text5 Author(from current textbooks associated with course)

Text5 Publisher(from current textbooks associated with course)

Text5 Physical ISBN(from current textbooks associated with course)

Text5 eBook ISBN(from current textbooks associated with course)

Text6 Title (from current textbooks associated with course)

Text6 Edition(from current textbooks associated with course)

Text6 Author(from current textbooks associated with course)

Text6 Publisher(from current textbooks associated with course)

Text6 Physical ISBN(from current textbooks associated with course)

Text6 eBook ISBN(from current textbooks associated with course)

The following columns may be empty in on-demand report.  If the course has any open project(s) on the MPS, the information should be brought in from most recent open project

Revision Type (From MPS record Revision Type)

Project Type (From MPS record Project Type)

Workload (From MPS record Workload)

Project Description (From MPS record Project Description)

Term (From MPS record Term)

Drop (From MPS record Drop Code)

Launch Term (From MPS record Launch Term)

Overall Project Expectations (From MPS record Project Overall Project Expectations)

New Title or Course Number (From MPS record New Title of Course Number)

Outcome Rubric Changes (From MPS record Outcome Rubric Changes)

CS (From MPS record Curriculum Specialist)

CS email (from user list)

CS2 (From MPS record Curriculum Specialist 2 field)

CS2 email (from User List)

Course Lead (From MPS record Course Lead)

CL email (from user list)

SME (SME NCL) (From MPS record SME (SME NOT Course Lead))

SME (SME NCL) email (From MPS record SME (SME NOT Course Lead) email)

MD (From MPS record Multimedia Devloper)

MD Email (from user list)

UTA (From MPS record Need UTA?)

Multimedia Comments (From MPS record Multimedia Comments)

Project ID (From MPS record Project ID)

The exported report can be copied to a tab in the Course Design Guide (CDG) Template that has imbedded formulas to bring in the required data from the report into the appropriate fields of the CDG.