Institution Analytics #USGRockEagle13

Janice Hill, Columbus State University

  • Process:
    • Define KPI’s : grades,  starting degree, ending degree, and many more.
    • Design and Implement : ODI integrator
      • Subject area example : summation helps reports only pull one row per student.
      • Updating : degrees awarded only loaded at end of term.
    • Validation of data : Work with Institutional Research to figure out where wrong. Consulting with individuals who think data did not look right.
    • Production release : Start a new cycle.
  • Data elements:
    • Banner, PeopleSoft, Excel spreadsheets
    • student head count, student attempted credit hours, and about 30 others.
  • Dashboards : 8 in production, 2 in completed validation, 2 subject areas ready to be built. Changes to a dashboard not saved across sessions, so users need to export to a file.
  • Structure of Dashboard : Level prompts : College, department, program, major, term. Analysis. Footnotes.
  • Users with access : President, VP, Deans, Dept heads.
  • Export types : PDF, Excel, Web,
  • Errors: BI data loaded at 6am, so local data pulled at 9am WILL result in very small differences.
  • Progression dashboard : credit hours by term, avg GPA by class, avg GPA vs credit hours earned, demographic breakdowns, grades by academic level, grades by section
  • Retention and Graduation dashboard : after 1 year, after 6 years. Use both counts and percentages.
  • Talk with faculty about their data needs so can show it exists or build it into a report.
  • Individualized training. Understanding how to filter is a challenging concept.
  • User tracking enabled, so know how long they stay on a dashboard, filters used, the SQL used.
  • Try to use as little filters as possible. Her job to get the data. User’s job is to interpret.
  • Decisions and policy affected by this data.
  • Trying to get grade data to improve early warning.
  • What are the products for which they want analytics?
  • Using University System of Georgia requirements for retention, so pegged to Fall enrollment. “Some times you have to go past what makes sense to you and implement the rule.”

Excellent session!

Columbus State Degreein3 #USGRockEagle13

Web site:

Mary Covington, Executive Director, IT Services, Columbus State University

Notes from session:

    • Program:
      • Bill and Melinda Gates Foundation grant.
      • Degree in 3 years. 1st year get a certificate. 2nd year get an Associates. 3rd year get a degree.
      • $18,000 degree.
      • At least 1/3rd low income.
      • Early intervention.
      • All online courses. Standardization of course design.
    • Session talk:
      • Columbus State University owns computers and loan to students for 3 years. (After graduation, student keeps the computer.)
      • Proctored tests. Google Chromebooks, but Lockdown browser does not work on them. ProctorU used instead.
      • Since all the data really is up in the cloud, easily exchange the machine.
      • Students signed commitment letter to send the machine back. Only close call, the student changed mind after talking to an advisor.
      • 100% online degree technical support, 24/7 campus support, outsource after hours.
    • Lessons learned:
      • Know the funding plan
      • Do not specify type of technology in the grant.
      • IT people make IT decisions.
      • Vendors will try to coerce.
      • Know purchasing processes.
      • Just in time purchasing is hard.
      • Warranty process not well understood.
      • Students already have access to a computer or library already.
    • Next steps
      • In year 3 of 3.
      • 4 more sessions.

Got to explain what is Collaborative Programs, Georgia ONmyLINE, and Ingress for the presenter.