1 / 108

Advanced MOSIS

Missouri Department of Elementary and Secondary Education 49th Annual Conference for School Administrators August 2010 Amber Castleman, MOSIS Tom Ogle, Core Data. Advanced MOSIS. Agenda. Welcome Overview of MOSIS Website MOSIS Manual R equesting Access MOSIS ID System

ramla
Download Presentation

Advanced MOSIS

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. Missouri Department of Elementary and Secondary Education 49th Annual Conference for School AdministratorsAugust 2010Amber Castleman, MOSISTom Ogle, Core Data Advanced MOSIS

  2. Agenda • Welcome • Overview of MOSIS • Website • MOSIS Manual • Requesting Access • MOSIS ID System • MOSIS Data Collection System

  3. Welcome Introductions Ability to Log On Level of Experience

  4. Overview of MOSIS • MOSIS - Missouri Student Information System • Designed to help DESE better meet the needs for high quality data for decision making and for state and federal reporting. • Replaces aggregate data collections manually entered onto Core Data screens with record-level collections submitted through the MOSIS Data Collection. • The goal is to collect the data once and use them many times, by many people, for many purposes.

  5. Overview, cont. • Three Phases • Phase I – In 2005 the MOSIS ID System was put in place, to generate a randomly generated state identification number for every student receiving service in the public schools. • Phase II – In early 2006 the collection of student level data using the MOSIS ID to pre-code the student’s MAP test booklets with the required demographic and program data. • Phase III – In late 2006 the transition took place of the Core Data Collection system from an aggregate student data collection to a student level data collection.

  6. Website Information • www.dese.mo.gov/MOSIS • File Layouts • Business Rules • Excel Templates • Code Sets • Listserv • MOSIS Manual • Core Data Manual • FAQ System • Training • User Access

  7. MOSIS Manual • Overview • File Layouts • Popular Exhibits: • Exhibit M1: 2010-11 Changes (pg.69) • Exhibit M2: Crosswalk to Core Data (pg.71) • Exhibit M3: Due Dates (pg.83) • Exhibit M6: Web Resources (pg.89) • Exhibit M7: Contact Information (pg.91)

  8. Requesting Access • Request access through MOSIS website: • www.dese.mo.gov/MOSIS • Two levels of access: • Building level (ID system) • District level (ID and Data Collection systems)

  9. Choose ‘User Access’

  10. Enter Information

  11. Fax completed Form to 573-751-1179 Authorized Rep’s Name and Signature Security Pin Code Requesting User’s Name and Signature

  12. MOSIS ID System

  13. Facts • A MOSIS ID is required for any student served by a public school district. • A MOSIS ID is required when submitting all MOSIS Data Collection files collecting individual student data. • The sole purpose of the MOSIS ID is to maintain the state ID of the student. It is NOT used to associate a student with any entity and does not imply any type of ownership.

  14. Facts • It is recommended to upload a batch of students to the ID system periodically to ensure the most current information is listed for a student.

  15. Log In to MOSIS ID System • Access through DESE website: • www.dese.mo.gov

  16. Log In to MOSIS ID System

  17. Log In to MOSIS ID System

  18. Log In to MOSIS ID System

  19. Log In to MOSIS ID System

  20. Log In to MOSIS ID System

  21. State ID Menu • State ID Menu • Upload Batch File • Enter Individual Student • Student Search • Batch Search • Extract and Download Batch • Exit Application

  22. State ID Menu • Upload Batch File • A batch file allows multiple students to be uploaded at once. • This file may be extracted from your local system OR created using our Excel template.

  23. Batch File • In order to upload a batch file there is a format to follow that includes a: • Header Record (TH) • Detail Record (ID) • Trailer Record (TT) • The batch file must be saved in one of these formats: • CSV (comma delimited) • TXT (tab delimited)

  24. Batch File • The header record should always be the first record. • The detail record should appear between the header and trailer record. • The trailer record should always be the last record.

  25. The header should contain the following fields delimited by a single tab or space character:

  26. The detail records should represent individual student data and should contain the following fields:

  27. Detail records, cont.

  28. The trailer should contain the following fields delimited by a single tab or space character:

  29. Sample of Batch File Header Record Trailer Record Detail Record

  30. Batch File

  31. Batch File

  32. Batch File

  33. Batch File

  34. Batch File Assigned State ID

  35. State ID Menu • Enter Individual Student • Allows a user the ability to input the information for one student online and assign an ID. • This function can also allow a user to update an existing ID for a student.

  36. State ID Menu • Student Search • Allows a user to search the ID system for a student by a simple search, advanced search, or search by State ID.

  37. Batch Search • Batch Search • Allows a user to upload a batch file and the system will search for any student who has been assigned an ID. • This process does not actually assign an ID but instead searches the system and will return any IDs found.

  38. Batch Search

  39. Batch Search

  40. Batch Search

  41. Batch Search

  42. Batch Search

  43. State ID Menu • Extract & Download Batch • Allows a user to download previous batches that have been uploaded whether they were processed completely or rejected with errors.

  44. State ID Menu • Exit Application • Allows a user to exit the ID system.

  45. MOSIS Data Collection System

  46. Facts • The MOSIS Data Collection System is a web-based application that allows districts to submit, clean, and certify data reported to DESE. • Data collected is used for populating the Core Data System, state and federal reporting, accountability, and funding purposes. • Data is collected in six cycles. • To access the Data Collection System you must have District Level Access for MOSIS.

  47. Basic Steps • Identify, collect, and enter data into local systems. • Extract data from local systems for upload to MOSIS OR complete Excel Template for upload. • Upload to the online MOSIS Data Collection System creating a ‘Trial’. • Correct errors and review warnings in the MOSIS Data Collection Trial. • Certify, with possibility to Re-Certify if changes need to be made.

  48. File Layouts • The File Layouts available for each file include the data items to be reported. • Data items may be required, optional, conditional, or not allowed depending on the cycle. • The goal is to keep the files collected as constant as possible, therefore collecting the same data items across cycles but only requiring a subset of those dependent on the cycle.

  49. Business Rules • Business Rules are ran each time a trial is uploaded or revalidated in the Data Collection System. • They check for valid codes, formats, etc.

  50. MOSIS Data Collection • Cycle, Collections, Due Dates (pg. 83) • Core Data Screen Crosswalks (pg. 71)

More Related