• 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... 

misis ad hoc reporting

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...
  • What's New

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

  • Updates - July 20, 2017 *Not part of regular release schedule

    Posted by MiSiS Ad Hoc Reporting and Dashboards at 7/20/2017

    School Year Prompt Added to all Dashboards - A School Year prompt has been added to all dashboards so that users can select between 2015-2016, 2016-2017 and 2017-2018 school years. All dashboards will be defaulted to 2016-2017 until August 15, 2017, and users have the option to view 2017-2018 data by selecting 2017-2018 in the School Year Prompt.

    Comments (-1)
  • Updates - July 12, 2017

    Posted by MiSiS Ad Hoc Reporting and Dashboards at 7/17/2017

    Apologies for the delay in posting these release notes. There was an issue with access to this website.

    Decommissioning MiSiS Explorer – MiSiS Explorer will be retired by the end of the 2017 calendar year (December 31st, 2017). 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 at http://achieve.lausd.net/Page/11879.

    School Year Prompt on Dashboards for Summer Users – Due to the fact school is not in session and the current amount of available data is limited, a Prompt for School Year has been added to all dashboard pages (except Grad Progress) so that users can view the final data capture of 2016-2017. Graduation Progress automatically displays 2016-2017 data until the first day of school, 2017-2018.

    New Local District Report: Homeless Count – This report is now available, displaying a count of homeless students for each school. It can be found by clicking Dashboards in the navigational menu > Local District Reports > Local District Reports > Homeless Count tab.

    New Summer School Report: Attendance Summary – This report is now available in the Summer School Reports. It displays the cumulative attendance of all students and total count of teachers. It can be accessed by clicking Dashboards in the navigational menu > Local District Reports > Summer School Reports > Attendance Summary tab.

    New Summer School Report: Perfect Attendance – This report is now available in the Summer School Reports. The report shows all students who have a Present, Left Early, or Tardy for every day of summer school. It can be accessed by clicking Dashboards in the navigational menu > Local District Reports > Summer School Reports > Perfect Attendance tab.

    Updates to Summer School - School Summary Report – On this report, users can now drill down to view counts by Department. It can be accessed by clicking Dashboards in the navigational menu > Local District Reports > Summer School Reports. The Summary Report is the default tab.

    Marks Folder Added to Student Detail Subject Area – A new Marks folder has been added to this subject area which consists of three subfolders. Secondary Grading Period Marks and Secondary Final Marks can be used to create reports showing the number of Ds, Fs, Us, and other marks for each student. The A-G Progress subfolder can be used to create reports showing whether specific graduation requirements have been met. The updated Subject Area Guide is available at http://achieve.lausd.net/Page/11833.

    New Schoology - Assignments Subject Area – This subject area is now available. It contains data regarding Assignments in Schoology. More Schoology data will be added to the application in future releases. A subject area guide is available on the MiSiS Ad Hoc Reporting job aids webpage http://achieve.lausd.net/Page/11833.

    New ITI Flag Column – This column is now available to identify schools designated as ITI 1:1 schools. It can be in the Additional Information – Current School folder in all applicable subject areas. Updated subject area guides are available on the MiSiS Ad Hoc Reporting job aids webpage http://achieve.lausd.net/Page/11833.

    New CFA Flag Column – This column is now available to identify students currently enrolled in a CFA (Conservatory of Fine Arts) class. It can be found in the Program Participation folder in all subject areas. Updated subject area guides are available on the MiSiS Ad Hoc Reporting job aids webpage http://achieve.lausd.net/Page/11833.

    New Condom Availability Program Columns – Two new columns are available for identifying students who have been opted out of the Condom Availability Program by a parent/guardian. The new columns are CAP Opted Out Flag and CAP Parent Waiver Date, and they can be found in the Program Participation folder in all subject areas. Updated subject area guides are available on the MiSiS Ad Hoc Reporting job aids webpage http://achieve.lausd.net/Page/11833.

    New Poverty Flag Column – This column is now available to identify students who are economically disadvantaged. It can be found in the Program Participation folder in all subject areas. The updated subject area guide is available on the MiSiS Ad Hoc Reporting job aids webpage http://achieve.lausd.net/Page/11833.

    New PSEL Indicator Column – The PSEL (Probable Standard English Learners) Indicator column is now available to identify students with a language classification of IFEP or EO and who identify as one of the following ethnicities: African American/Black, Hispanic, Pacific Islander, or American Indian/Alaskan Native. This column can be found in the Program Participation folder in all subject areas. Updated subject area guides are available on the MiSiS Ad Hoc Reporting job aids webpage http://achieve.lausd.net/Page/11833.

    Updates to Academic Records Subject Area – Two additional folders and two new columns have been added to this subject area. The new folders are Programs and Attendance. The new columns are A-G Tier, LAUSD A-G Status Code, and LAUSD A-G Status Description and can be found in the Graduation folder. The updated Subject Area Guide is available at http://achieve.lausd.net/Page/11833.

    Updates to Enrollment and Withdrawal History Subject Area – Two additional folders have been added to this subject area: Programs and Attendance. The updated Subject Area Guide is available at http://achieve.lausd.net/Page/11833.

    Updates to Period Prompts– On all dashboards and canned reports, updates have been made to the Prompts for Period so that they sort in the correct order.

    Updates to Schools for Advanced Studies Subject Area – Updates have been made to the Schools for Advanced Studies Subject Area so that duplicate records which were appearing on ad hoc reports are no longer appearing.

    Comments (-1)
  • Updates - June 14, 2017

    Posted by MiSiS Ad Hoc Reporting and Dashboards at 6/14/2017

    Decommissioning MiSiS Explorer – MiSiS Explorer will be retired by the end of the 2017 calendar year (December 31st, 2017). 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 at https://achieve.lausd.net/Page/11879.

     

    New Local District Report – Class Size– This report is now available for users to view selected course class sizes. To access the report, navigate to Dashboards in the navigational menu > Local District Reports > select the Class Size tab. 

     

    New Local District Report – EL Service – This report is now available, displaying school sections where an EL student is enrolled and the section term has an attribute of EL Service. To access the report, navigate to Dashboards in the navigational menu > Local District Reports > select EL Service tab.

     

    Updates to Summer School Monitoring Reports – The Summer School Monitoring Reports now include a parameter for program as well as a column to display the program to distinguish the various summer programs. To access the reports, navigate to Dashboards in the navigational menu > Summer School Reports.

     

    New Enrollment History Subject Area – A new subject area is available to create reports using enrollment data from previous school years, as well as withdrawal data events for students. A subject area guide is available on the MiSiS Ad Hoc Reporting job aids webpage at https://achieve.lausd.net/Page/11833.

     

    New Graduation Requirements Columns – The following columns are now available in the Student Detail and Student Graduation Progress Subject Areas to assist in identifying students eligible for graduation: Probation/Foster Eligibility Option Type Description, Probation/Foster Eligibility Option Type Code, Post Secondary Plan, Homeless Eligibility Option Type Description, and Homeless Eligibility Option Type Code. These columns can be found in the Student Detail Subject Area > Graduation folder or the Student Graduation Subject Area > Graduation Requirement folder. The MiSiS Ad Hoc Reporting subject area guides have been updated at https://achieve.lausd.net/Page/11833.

     

    New DIBELs Composite Performance Level Columns – These columns are now available in the Student Detail Subject Area to summarize a student’s performance on the DIBELs test. The columns include DIBELs Composite Performance Code, DIBELs Composite Performance Description, DIBELs Composite Performance Display Code, and DIBELs Composite Score. They can be found by navigating to the Student Detail Subject Area > Latest Test Scores folder > DIBELs Assessment subfolder. The MiSiS Ad Hoc Reporting subject area guides have been updated at https://achieve.lausd.net/Page/11833.

     

    New Curriculum Type Code and Description Columns – These columns are now available within the Programs folder in all subject areas. These columns display the Curriculum Type of a Special Education Program. Options include “Alternate Curriculum,” “General Education with Modification,” etc. The columns can be found by navigating to the Programs folder > Special Education subfolder. The MiSiS Ad Hoc Reporting subject area guides have been updated at https://achieve.lausd.net/Page/11833.

     

    AEA (American Evaluation Association) Ethnicity Prompt Now Available – On the Launch Pad and the Graduation Progress Dashboard, a new prompt has been added to the top of the page with which users can drill down to a specific AEA Ethnicity.

     

    Updated Attendance Bands and Tiers – Calculations used in these columns have been updated to align with the District. These columns can be found in the Student Detail Subject Area > Attendance folder.

    Comments (-1)
  • more