1 / 18

MIS REFERENTIAL DATA WEBSITE

MIS REFERENTIAL DATA WEBSITE. (a.k.a Data on Demand). What You Get. Student Identifier and Student Basic files Term files Annual files (Financial Aid, Program Award, Assessment) Employee files All files are tab-delimited Available one business day after request is submitted. The Website.

mckenzie-coleman
Download Presentation

MIS REFERENTIAL DATA WEBSITE

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. MIS REFERENTIAL DATA WEBSITE (a.k.a Data on Demand)

  2. What You Get • Student Identifier and Student Basic files • Term files • Annual files (Financial Aid, Program Award, Assessment) • Employee files • All files are tab-delimited • Available one business day after request is submitted

  3. The Website Log in with your MIS submissions user name and password, or with your DAT user name and password.

  4. Instructions

  5. Request Your Data

  6. Pick ‘em Up the Next Day

  7. It is strongly recommended that you ‘Save’ the file to your own computer, rather than ‘Open’ from the Website.

  8. You will be prompted to select the directory on your local machine where you want to save the .zip files. Also, if you prefer, you can rename the .zip archive at this time. The default archive name is the date the archive was created (mm-dd-yy) followed by the MIS term identifier (yyt).

  9. When you double-click your saved .zip archive, it will automatically open with whatever zip utility you have installed on your local computer. If you then double-click one of the text files, it will open with whatever .txt utility you have installed on your local computer.

  10. When you download your .zip archive, it is also suggested that you download the most recent readme.xls file. This file will provide file and field definitions for the .txt files shown in the previous slide.

  11. This is an example of the SD .txt file The record description from the readme.xls file.

  12. The record description from the readme.xls file. This is an example of a typical course. This is an example of a course with a problem

  13. The Student Identifier File The Student Identifier file provides the cross-reference key between the District’s Student ID and the CCCC Assigned ID. All files created by the new Referential processing will include CCCC Assigned ID. Consequently, a change in the District’s ID will only need to be changed in CCCC ID file in order to correlate to the same student throughout all CCCC other files.

  14. Fun With Data • Import SD.txt file into Access, SPSS, SAS, SQL Server, etc. • Change/correct data SD • Join imported files using Student ID File • Export joined query as fixed length text file for MIS submission

  15. The Referential Data Website will be available on January 25th.

  16. Summer 20083 Regional TrainingsUsing Referential FilesNorth, Central, South

More Related