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

Decision Support System PowerPoint PPT Presentation


  • 124 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


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

  • 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

  • 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

  • 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

  • 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

  • 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


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

  • 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 Targeting


Annual Targeting


Annual Targeting


Annual Targeting


Annual Targeting

  • Just one catch . . .


Moving Target


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


Does the projection work?


Does the projection work?


Does the projection work?


Does the projection work?


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


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

  • 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


Response?


Waitlists


Registration Acceleration


Lagging Courses


Lagging Courses


Room Usage


Excluded CRNs From 320


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Sandbox


Future

  • Building Predictive Model

  • Room/Space Efficiency

  • Reporting Off Sandboxes

  • Task/Directive Assignment


  • Login