Decision support system
Download
1 / 51

Decision Support System - PowerPoint PPT Presentation


  • 145 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Decision Support System' - prisca


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



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 targeting5
Annual Targeting

  • Just one catch . . .



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







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




























Future
Future

  • Building Predictive Model

  • Room/Space Efficiency

  • Reporting Off Sandboxes

  • Task/Directive Assignment