Decision support system
This presentation is the property of its rightful owner.
Sponsored Links
1 / 51

Decision Support System PowerPoint PPT Presentation


  • 105 Views
  • Uploaded on
  • Presentation posted in: General

RP Group Conference 2014 April 10 th , 2014. Decision Support System. Dr. William Scroggins President Dr. Irene Malmgren Vice President of Instruction Bob Hughes Director, Enterprise Applications Systems Daniel Lamoree Sr. Systems Analyst/Programmer. The Role of Executive Leadership.

Download Presentation

Decision Support System

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Decision support system

RP Group Conference 2014

April 10th, 2014

Decision Support System

Dr. William Scroggins

President

Dr. Irene Malmgren

Vice President of Instruction

Bob Hughes

Director, Enterprise Applications Systems

Daniel Lamoree

Sr. Systems Analyst/Programmer


The role of executive leadership

The Role of Executive Leadership

  • President’s Cabinet

    • Decision Support System given high priority

    • Regular updates to Cabinet

  • Instruction Team

    • Demonstration of application to Deans

    • Gather Feedback


It and research collaboration

IT and Research Collaboration

  • Information Technology staff goal – protect the data; restrict access

  • Researchers goal – more data leads to better decision-making

  • When these units are in different divisions, the need for cooperation and collaboration is critical


The approach at mt sac

The approach at Mt. SAC

  • Data Users Group (DUG) meeting – every 2 weeks

  • Researchers Data Warehouse (RDW) instance of the Banner Database

  • Report Designer access to Argos DEV

  • SQL training of Researchers by IT Staff


Leveraging talent

Leveraging Talent

  • Director of RIE recognized a team member with a unique aptitude for programming

  • Director of EAS (Enterprise Resource Applications) responded to a need for a Decision Support System

  • Best solution – temporary reassignment of a researcher to IT as a programmer

    • Located in IT

    • Build trust with other IT staff

    • Improved access to data


Learning objectives

Learning Objectives

  • How Mt. SAC calculates FTES Targets

  • How Mt. SAC decides sections to add or cut

  • How Mt. SAC Deans develop prospective schedules


Mt sac story lost ftes

Mt. SAC Story: Lost FTES


Scheduling 2014 2015 overview

Scheduling 2014-2015 Overview

  • Top-Down Approach

    • Get Annual FTES Target

    • Distribute Annual Target between CR, ENHC_NC, NC

      • Grow only Credit? Distribute as before?

    • Distribute CR, ENHC_NC, NC among Terms

      • Grow Summer (yes, please)? Fall? Winter? Spring?

    • Distribute FTES among Divisions . . .


Annual targeting

Annual Targeting

  • Example

    • Funded FTES for Prior Year = 29371.99

    • Growth = 3.5%

    • Unfunded FTES for Prior Year = 400

    • ((29371.99 * 1.035) – 400) = 30000

    • CR: 27000 (90%), 2400 ENHC_NC (8%), 600 NC (2%)

    • 10% Summer; 42% Fall; 8% Winter; 40% Spring

    • Of 10% Summer: 36.22% HSS; . . .


Annual targeting1

Annual Targeting


Annual targeting2

Annual Targeting


Annual targeting3

Annual Targeting


Annual targeting4

Annual Targeting


Annual targeting5

Annual Targeting

  • Just one catch . . .


Moving target

Moving Target


Minimizing spring uncertainty

Minimizing Spring Uncertainty

  • Knowns

    • Sections Scheduled for Spring

    • Scheduled Hours per Section for Spring

    • Historical Fill Rate for Spring

  • Unknowns

    • Future Contact Hours (Fill Rate for WSCH/DSCH or PACH)

  • Mt. SAC Decision

    • Projection


Projection weighted averages

Projection: Weighted Averages


Does the projection work

Does the projection work?


Does the projection work1

Does the projection work?


Does the projection work2

Does the projection work?


Does the projection work3

Does the projection work?


What happened

What happened?

  • No variance in pervious years; easy to project when fill rates hover around 100% (after drops and adds)

  • What now?

    • More robust model, an actual predictive model

      • Will that help given downward trends? Always 1 year or term behind?

    • Maintain Agility

      • Reporting via Argos and APEX

      • Sandboxing via APEX


Decision support system

APEX

  • Highlights

    • Oracle’s primary tool for developing Web applications using SQL and PL/SQL

    • Only requires web browser to develop

    • No cost option of the Oracle Database


Reports

Reports

  • What sections should we add?

    • Demand

      • 90%+ Fill

      • Waitlists

    • Registration Acceleration

  • What sections should we cut?

    • Lagging Sections

    • Registration Acceleration

  • What else?

    • Room Usage

    • Excluded CRNs


Demand 90 fill

Demand 90%+ Fill


Response

Response?


Waitlists

Waitlists


Registration acceleration

Registration Acceleration


Lagging courses

Lagging Courses


Lagging courses1

Lagging Courses


Room usage

Room Usage


Excluded crns from 320

Excluded CRNs From 320


Sandbox

Sandbox


Sandbox1

Sandbox


Sandbox2

Sandbox


Sandbox3

Sandbox


Sandbox4

Sandbox


Sandbox5

Sandbox


Sandbox6

Sandbox


Sandbox7

Sandbox


Sandbox8

Sandbox


Sandbox9

Sandbox


Sandbox10

Sandbox


Sandbox11

Sandbox


Sandbox12

Sandbox


Sandbox13

Sandbox


Sandbox14

Sandbox


Sandbox15

Sandbox


Sandbox16

Sandbox


Sandbox17

Sandbox


Future

Future

  • Building Predictive Model

  • Room/Space Efficiency

  • Reporting Off Sandboxes

  • Task/Directive Assignment


  • Login