Los Angeles Unified School District

Investing in LAUSD

can’t find something?
misis ad hoc reporting
Home page
Support page
Support
FAQs page
FAQs
Status page
Status

Click here for information about system status.

 
Click here for direct links to dashboards and guides.   

Register for ad hoc reporting training.

Click here to continue.

About the Project 

LAUSD is committed to implementing a new self-service approach to ad hoc reporting for MiSiS, MyData, and Welligent users. This approach empowers central office, local district, and school administrators to easily access, create, and share reports to support data-driven initiatives. The new approach requires replacing the existing ad hoc reporting capability, MiSiS Explorer, with a more robust ad hoc reporting tool – Oracle Business Intelligence Foundation Suite – which enables end users to create personalized reports with minimal or no IT involvement.

Learn More... 

Frequently Asked Questions

Q. Why is LAUSD switching to the new Ad Hoc Reporting tool?
A. LAUSD is making the switch to provide a self-service approach to producing reports and data extracts that LAUSD school, local district, and central office staff can use in data-driven initiatives. There are limitations in MiSiS Explorer, which the new ad hoc reporting tool will address, such as limited historical data, lack of dashboard capability, and inability to extract data for multiple schools, to name a few. MiSiS Ad Hoc Reporting and Dashboards also provides more data to choose from than the old MiSiS Explorer and SIS systems, providing greater flexibility in creating reports.

 

 

Q. What are the benefits of this project?
A. Implementing the new ad hoc reporting tool will improve the experience of generating reports using data found in MiSiS. Some of the major benefits include:
  • Flexibility – Provides more flexibility in MiSiS ad hoc reporting, now allowing users to create reports at the local district and LAUSD levels if they have access to that data.
  • Self-Service Approach – Eliminates the need to request new reports to be created by IT – users can create and personalize their own reports.
  • Dashboards – Provides dashboards to various types of users (administrators, central office staff, school officials, etc.) consisting of the information those users need to have to succeed.
  • Historical Data – Provides the ability to produce reports on historical student data, so users can look at information on a student’s previous enrollment and course history.
  • Up-to-Date Data – Data will be updated nightly; some data, such as attendance and scheduling, will be available in real-time.

 

 

Q. What is ad hoc reporting?
A. Ad hoc reporting is a method of creating reports in which users can select the data and format of a report to fit their needs. This method of reporting does not require a developer to take the time to build a report. In MiSiS Ad Hoc Reporting, the user selects the data for a report from a subject area and then formats the report in a way that best presents the information.

 

 

Q. How does the tool work?
A. MiSiS Ad Hoc Reporting and Dashboards consists of two major capabilities: dashboards and ad hoc reporting.

 

A dashboard is a collection of related reports that are displayed together on one page. Each dashboard provides a snapshot of information on a specific subject, such as Norm Day Enrollment or English Learner. When users log in, they immediately see a Dashboard populated with central office, local district, or school-level data, depending on the user's role in LAUSD.

 

Ad hoc reporting provides users with the ability to create and share their own reports. This method of reporting does not require a developer to take the time to build a report. Users can also select a canned template report from the Catalog. Canned template reports are created and shared by other ad hoc reporting users. Note that only designated Super Users are able to save report to the Catalog to share with other users.

 

 

More...
misis ad hoc reporting

Click here to identify your Publishers (Super Users).

 

Coming Soon

Upcoming Subject Areas
The following data is coming soon to ad hoc reporting:
  • Student Support - Interventions
  • Summer School
  • GATE - Testing
  • Athletic Eligibility
  • Special Education (Welligent)
Upcoming Dashboards
The following dashboards are coming soon:
  • Attendance
  • LCAP Scorecard
  • Special Education
  • Counseling
  • GATE
  • And more 

    What's New

    MiSiS Ad Hoc Reporting and Dashboards is updated with software fixes and/or enhancements every other Tuesday night. Browse the notes below to learn about all updates released since November 2016.

    • Updates - March 22, 2017

      Posted by MiSiS Ad Hoc Reporting and Dashboards at 3/22/2017

      Subject Areas

      Note: Attendance data is currently two days behind MiSiS. The issue will be resolved by the week of 3/27/17.

      Attendance Daily Subject Area – This subject area is now available, providing data on Attendance by Period, including Periods Absent or Tardy. It also includes Daily Status codes, Alerts, and Attendance Location data, in addition to general student demographics, Enrollment, Groups, and Programs data. On 3/22/17, 2016-2017 data was loaded, and 2015-2016 data will be loaded on 3/23/17. A subject area guide has been created and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://achieve.lausd.net/Page/11833).

       

      Attendance Folder in Student Detail Subject Area – A new folder has been added to the Student Detail Subject Area that includes YTD Attendance data, in addition to data pertaining to Attendance Bands, Attendance Tiers, Truancy Letters, and Alerts. On 3/22/17, 2016-2017 data was loaded, and 2015-2016 data will be loaded on 3/23/17. The Student Detail Subject Area Guide has been updated and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://achieve.lausd.net/Page/11833).

       

      Additional Special Education Columns – New columns have been added to the Special Education subfolder found in the Programs folder in the English Learner, Enrollment History, Contact Information – Parent Guardian, Contact Information – Additional Contacts, Student Detail, Student Graduation Progress, Student Support, and Student Testing Subject Areas. The subject area guides have been updated and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://achieve.lausd.net/Page/11833).

       

      Attendance Student Section Subject Area – This subject area is now available, providing data on Section Attendance. It also includes Attendance Status codes and Alerts, in addition to general student demographics, Enrollment, Groups, and Programs data. On 3/22/17, 2016-2017 data was loaded, and 2015-2016 data will be loaded on 3/23/17. A subject area guide has been created and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://achieve.lausd.net/Page/11833).

       

      Conservatory of Fine Arts Subject Area – This subject area is available, providing data on students participating in the Conservatory of Fine Arts, including class enrollment and, if applicable, drop data. The available data also includes student demographics, Enrollment, Attendance Permit Details, GPA, Programs, Bus Route Information, Latest Test Scores, Groups and Fund Center data. A subject area guide has been created and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://achieve.lausd.net/Page/11833).

       

      Contact Information – Parent Guardian Subject Area and Contact Information – Additional Contacts Subject Area – The previously available Parent Guardian Subject Area has been divided into these two new subject areas. Contact Information – Parent Guardian consists of all Parent Guardian details, including addresses, phone numbers, email addresses, and information on Military Family Members. Contact Information – Additional Contacts consists of contact information such as addresses and phone numbers for documented contacts that are not the parent and/or guardian. Both subject areas also include student demographics, Enrollment, Groups, Programs, Bus Route Information, Grade Level, and School data. Subject area guides have been created and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://achieve.lausd.net/Page/11833).

       

      GATE - Referrals Subject Area – This subject area is available, providing data on students referred to the Gifted/Talented Program, including Referral, Determination, Evaluation, Notification, and Parent/Guardian Consent data. The available data also includes student demographics, Enrollment, Attendance Permit Details, GPA, Programs, Bus Route Information, Latest Test Scores, Groups and Fund Center data. (GATE – Testing Subject Area, which will include GATE assessment data, will be available in a forthcoming release.) A subject area guide has been created and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://achieve.lausd.net/Page/11833).

       

      Student Exclusion Subject Area – This subject area is available, providing principals and other users with the ability to create Student Exclusion Reports. The available data also includes student demographics, as well as data pertaining to all student exclusions received for every student. A subject area guide has been created and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://achieve.lausd.net/Page/11833).

       

      Student Photos Now Available – Student Photos are now available to be used in reports. The column can be found in every subject area, in the Name folder. Authors must be logged into MiSiS when applying Student Photos to reports. A job aid on Applying Student Photos is available on the MiSiS Ad Hoc Reporting job aids webpage (http://achieve.lausd.net/Page/11833).

       

      Reports

      Attendance Daily TE Report Template – This template provides a TE student count for elementary schools, and can be found by navigating to the Catalog > Shared Folders > Example Reports > Attendance > Attendance_Daily_TE.

       

      Attendance Daily TK Report Template – This template provides a TK student count for elementary schools, and can be found by navigating to the Catalog > Shared Folders > Example Reports > Attendance > Attendance_Daily_TK.

       

      Attendance Do Not Accept Notes Report – This report is now available. It includes a list of all students and whether to accept notes regarding attendance. It can be accessed by navigating to the Catalog > Shared Folders > Example Reports > Attendance > Do Not Accept Notes > AT_Attendance_Do Not Accept Notes. 

       

      Roster CELDT – This report is now available. It includes a roster of all students and their CELDT scores and can be accessed by navigating to the Catalog > Shared Folders > Example Reports > EL Demographics > Roster_CELDT. 

       

      Minor Changes

      Pivot Table Fix – Pivot tables have been fixed to allow thousands of rows, if necessary.

       

      Briefing Books change – The ability to create briefing books is now only available to Publishers. To become a Publisher, you must complete the aforementioned Publisher Training Class.

       

      Announcements

      Using Groups in MiSiS Ad Hoc Reporting Job Aid – This job aid is now available, providing guidance on using Groups in reports created in MiSiS Ad Hoc Reporting. It provides information on the data available, in addition to instructions on how to create basic analyses using Groups, which can be found in these subject areas: Academic Records, Enrollment History, Contact Information – Additional Contacts, Contact Information – Parent Guardian, Student Graduation Progress, Student Support, and Student Testing. This job aid can be found on the MiSiS Ad Hoc Reporting job aids webpage (http://achieve.lausd.net/Page/11833).

       

      Decommissioning Ad Hoc Reporting Team Folder on 4/11/17 – The Ad Hoc Reporting Team folder in Shared Folders in the Catalog will be decommissioned on April 11, 2017. Owners of any reports in the folder must save copies of the reports they wish to keep before everything is deleted on April 11. For directions on how to do this, see the Copying and Pasting an Object in the Catalog Job Aid on the MiSiS Ad Hoc Reporting job aids webpage (http://achieve.lausd.net/Page/11833).  An email communication will be sent out directly to owners.

       

      Publisher Class Available Soon –  Users who wish to share reports with other users in the Shared Folders now have the option to do so once completing the web-based Publisher Training Class. Go to the MiSiS Ad Hoc Reporting webpage (http://achieve.lausd.net/Page/11879) for more information.

       

      Decommissioning MiSiS Explorer – MiSiS Explorer will be retired before the next school year. MiSiS Ad Hoc Reporting provides all capabilities available in MiSiS Explorer. Current users of MiSiS Explorer are encouraged to take the MiSiS Ad Hoc Reporting Basic Training Class, available for registration in the Learning Zone (http://achieve.lausd.net/Page/11879).

       

      Comments (-1)
    • Updates - March 1, 2017

      Posted by MiSiS Ad Hoc Reporting and Dashboards at 3/1/2017

      An issue with Groups has been fixed. All groups for all students now accurately display.

      Score Type Code and Description have been added to the Student Testing Subject Area. These new columns can be found in Student Testing > All Student Tests > Score Type Code/Score Type Description.

      Comments (-1)
    • Updates - February 8, 2017

      Posted by MiSiS Ad Hoc Reporting and Dashboards at 2/8/2017

      The student detail reports on the Eligibility Code Dashboard, also known as the More than a Meal Dashboard, have been updated to include Parent/Guardian contact information. All student detail reports on the Eligibility Code Dashboard now include Parent Name and Parent Contact, or phone number, of the primary parent.

      Comments (-1)
    • more
    CLOSE