1 / 21

ILLUMINOUS

ILLUMINOUS. RP Group Conference 2013 April 2 nd , 2013. Daniel Lamoree Educational Research Assessment Analyst Mt. San Antonio College dlamoree@mtsac.edu. Outcomes. E ffortlessly automate the import process of external data. COMIS – Data On Demand – Referential Files Cal-PASS Plus

loe
Download Presentation

ILLUMINOUS

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ILLUMINOUS RP Group Conference 2013 April 2nd, 2013 Daniel Lamoree Educational Research Assessment Analyst Mt. San Antonio College dlamoree@mtsac.edu

  2. Outcomes • Effortlessly automate the import process of external data. • COMIS – Data On Demand – Referential Files • Cal-PASS Plus • Rapidly construct two types (for now!) of cohorts • Entry Point • Course Pattern • Build a community of users, developers and designers

  3. Why use Illuminous to import COMIS and Cal-PASS Plus data? It’s simple and easy, unlike using a tape measure!

  4. Why use Illuminous to import data into Access? • Very easy, requires only a few mouse clicks • Standardization of external data. • COMIS DED • Cal-PASS Plus DED • Standardization begets a common language • Variable names are more descriptive • Removal of jargon from the CA IR lexicon • Standardization of data begets standardization of past, present, future queries and reports!

  5. Why use Illuminous to import data into Access? Cont. • Generates helpful materialized views for future use! • Ex1. Course Materialized View • Reduces CB table to 1 record per cb.course_id using the most recently submitted term_id. • Uses? • Ex2. Student Demographic Materialized View • Reduces ST table to 1 record per st.cccco_assigned_student_id using the most recently submitted term_id. • Uses? • What would YOU like to see?!

  6. Why use Illuminous to import data into Access? Cont. • Overcomes the most infuriating deficiency of MS Access! • 2 GB data limit per MS Access Database! • Imports each table into its own database and links to each of them. • If the individual table databases are housed on a network directory, allows multiple users to access the data simultaneously – instant makeshift Data Warehouse for your research office!

  7. Why use Illuminous to import data into Access? Cont. • Build a seamless dataset between high school data (Cal-PASS Plus), community college data (COMIS), and your local enterprise resource planner (e.g., Banner, Datatel) • SURELY THIS IS NOT POSSIBLE?!? • By replicating the Cal-PASS Plusderived key for students in theStudent Identifier (SI) table!

  8. Getting your COMIS data Login to Request and Retrieve your COMIS Data

  9. Raw COMIS data • Tips! • Save to any local folder • Do NOT rename! No need! Import code will fail!

  10. Getting your Cal-PASS Plus data Login to Request and Download your Cal-PASS Plus Data

  11. Raw Cal-PASS Plus data • Tips! • Save to any local folder • Do NOT rename! No need! Import code will fail!

  12. Importing at a glance

  13. Importing at a glance

  14. Importing at a glance

  15. Importing at a glance

  16. Importing at a glance

  17. Hands On! • Download a copy of Illuminous today! • https://dl.dropbox.com/u/355799/Illuminous.accde • Build a cohort of your own!

  18. All Things Cohort • What other types of cohorts do you typically create? • Exit Point? • Grads and applying retroactive success metrics? • Special programs? • ARISE, AANIPISI, etc? • Specific Sections of students • Supplemental instruction, Learning Communities

  19. All Things Success • Current success metrics (not in this build. See: YouTube) • Progression through sequence • X Credits accumulated • Certificate / Degree • Transfer (First File) • What would you like to see added?

  20. Future Development • Workflow? • Track, tag and organize projects and tasks • Outcomes? • Reporting? • Longitudinal Instructor analyzer • Course analyzer • Popular research to replicate?

  21. Future • Help me, help you! • Test out the Illuminous. • Send me ideas, criticisms, reports to integrate • Contact: dlamoree@gmail.com • Updates – Automated update script within Illuminous! • Future Communication:Google Grouporhttp://rpgroup.org/community/forum. . . ?

More Related