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.

 

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 - 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 http://lausd.schoolwires.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 http://lausd.schoolwires.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 http://lausd.schoolwires.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 http://lausd.schoolwires.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 http://lausd.schoolwires.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)
  • Updates - May 24, 2017

    Posted by MiSiS Ad Hoc Reporting and Dashboards at 5/24/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 http://lausd.schoolwires.net/Page/11879.

     

    Local District Reports – Incoming Students Report Now Available – This report can be found by navigating to Dashboards > Local District Reports > Local District Reports in the navigational menu. Click the Incoming Students tab at the top of the screen. This report displays a list of incoming students for middle schools and high schools.

     

    Local District Reports – Updates to Students Without Schedules Report – The pivot table in this report now displays a count and percentage of both Students With Schedules and Students Without Schedules. Click the arrow next to a Local District Name to drill down to the campuses in that district. This report can be found by navigating to Dashboards > Local District Reports > Local District Reports > Students Without Schedules.

     

    Local District Reports – Updates to Master Scheduling Commit Status Report A column has been added to this report titled “# of Schools Using Concurrent Term.” This report can be found by navigating to Dashboards > Local District Reports > Local District Reports in the navigational menu. The Master Scheduling tab is selected by default.

     

    Summer School Monitoring Reports Now Available – Reports for summer school are now available and can be found by navigating to Dashboards > Local District Reports > Summer School Monitoring Reports. The first report tab is the School Summary, which provides a breakdown of the number of students enrolled in summer school. The second tab is the Course and Teacher Summary, which provides a summary of the courses and teachers available in summer school. The third tab is Enrollments, which provides an Enrollment Roster. Future enhancements will include a prompt for Summer School Program and pivot tables on the Courses and Teachers Summary and Enrollments report.

     

    Schools for Advanced Studies Subject Area Now Available – This subject area is now available, providing data for students attending schools that are designated as Schools for Advanced Studies (SAS). This subject area includes student demographics, Enrollment, Programs, and Groups data, as well as data about SAS schools and the students attending them. Student data includes whether they are a Resident at the school, their eligibility criteria (i.e., Participation Criteria), and enrollment Start and End Dates. A subject area guide has been created and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage at http://lausd.schoolwires.net/Page/11833.

     

    Date Test Taken Column Now Available in Student Testing Subject Area – A new column has been added to the Student Testing Subject Area. It can be found by navigating to the All Student Tests folder > Date Test Taken. The column provides the date on which the student completed the related test. The Student Testing Subject Area has been updated and can be found on the MiSiS Ad Hoc Reporting job aids webpage at http://lausd.schoolwires.net/Page/11833.

     

    SAS Flag Column Now Available in All Subject Areas – A new column has been added all subject areas and can be found by navigating to the Student folder > Program Participation > SAS Flag or by navigating to the Program folder > Program Participation > SAS Flag. This column is a flag indicating whether a student attends classes at a SAS-designated school. The Subject Area Guides have been updated and can be found on the MiSiS Ad Hoc Reporting job aids webpage at http://lausd.schoolwires.net/Page/11833.

     

    Student No Show Subject Area No Longer Available – This subject area is no longer available in MiSiS Ad Hoc Reporting. For No Show data, see the Unprocessed No Shows Report on the Norm Day Enrollment Dashboard.

     

    Subject Area Descriptions Now Available – To help the user select the appropriate subject area for an analysis, hover text is now available in the tool. To see a subject area description, navigate to New > Analysis in the navigational menu and then hover the mouse over the name of a subject area.

     

    Updates to Attendance Bands and Tiers – Attendance Bands and Tiers have been updated to align with the bands and tiers defined by the District. Attendance Bands and Tiers are found in the Attendance folder in the Student Detail Subject Area. 

     

     

     

    Comments (-1)
  • Updates, May 3, 2017

    Posted by MiSiS Ad Hoc Reporting and Dashboards at 5/3/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 (http://lausd.schoolwires.net/Page/11879).

     

    Ad Hoc Reporting Team Folder Decommissioned – The Ad Hoc Reporting Team folder in Shared Folders in the Catalog has been decommissioned as of today.

     

    All Templates Listed on MiSiS Ad Hoc Reporting and Dashboards Website – All report templates that have been created in MiSiS Ad Hoc Reporting and Dashboards are listed on the Templates page on the MiSiS Ad Hoc Reporting and Dashboards’ Support section. Bookmark this link: http://lausd.schoolwires.net/Page/12830 or navigate to achieve.lausd.net/adhoc, go to the Support section, and click on the link to the List of Report Templates.

     

    Updates to Launchpad Dashboard – The Withdrawals performance tile has been changed to the Withdrawals from School performance tile on the Launchpad. A Withdrawals from LAUSD performance tile has been added to the Launchpad. The Withdrawals from School tile displays the number of students who have withdrawn from any LAUSD school, regardless of whether they have re-enrolled in another LAUSD school. The Withdrawals from LAUSD tile displays the number of students who have withdrawn from LAUSD completely and have not re-enrolled in another LAUSD school. The Launchpad Dashboard Guide has been updated to include these changes, and can be accessed on the Dashboards job aids webpage (http://lausd.schoolwires.net/Page/11829).

     

    Students Without Schedules Report – A new report is available displaying students who do not currently have schedules assigned for the future school year and the count of students without schedules for each school. It can be found by navigating to Dashboards in the navigational menu and click Local District Reports. Navigate to the Students Without Schedules tab in the top left corner of the screen.  

     

    Updates to Master Scheduling Local District Report – This report has been updated to include the number of students who have submitted requests and the number of students with no requests pending. This report can be found by navigating to Dashboards in the navigational menu and click Local District Reports. The Master Scheduling tab is selected by default.

     

    Student Records Request Subject Area – This subject area is now available, providing data on requests to obtain student information submitted to LAUSD schools. The subject area includes student demographic, Enrollment, and Groups data, as well as data about individual requests for student information. It includes information about the Sent/Receipt Dates, Requesting School, Requesting Contact Person, Requestor contact information, Record Requested, Record Request Type, and Comments. A subject area guide has been created and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://lausd.schoolwires.net/Page/11833).

     

    Updated Elementary Marks Subject Areas – The Elementary Marks Subject Areas have been updated to accurately reflect the marks available in elementary grade levels. The subject area guides have been updated and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://lausd.schoolwires.net/Page/11833).

     

    Grades Audit Data Now Available in Marks – Secondary Subject Area – Data regarding changes made to Academic Marks post-commit is now available in the Marks – Secondary Subject Area. Grade Entry End Date and Grade Entry Start Date can be found in the Course Sections folder > Section Details. Modified By, Modified Date, Previous Academic Mark Description, Previous Academic Mark Scale, and Previous Academic Mark are available in the Last Modifications folder. The subject area guide has been updated and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://lausd.schoolwires.net/Page/11833).

     

    CAP ID Number Column – This column is now available in the subject areas that include the student Address folder. It can be found by navigating to the Student folder > Address > CAP ID Number. The column provides the identification number for a student participating in the Confidential Address Program. All subject area guides have been updated and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://lausd.schoolwires.net/Page/11833).

     

    Groups Folder Added to All Subject Areas – The Groups folder has been added to all subject areas. The Groups folder consists of Category Name, Subcategory Name, Group Name, and other relevant Groups information. All subject area guides have been updated and can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://lausd.schoolwires.net/Page/11833).

     

    Learning Communities – In the Groups folder, All Group Names that are Learning Communities display “Learning Community” as the name instead of the Group Name. 

     

    Creating Mailing Labels Using MiSiS Ad Hoc Reporting Job Aid – This job aid is now available, describing the process of using MiSiS Ad Hoc Reporting to produce a data extract with student addresses, and then using that data extract in Microsoft Word to create mailing labels. The job aid can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://lausd.schoolwires.net/Page/11833).

     

    Creating Mailing Labels for Summer School Students Using MiSiS Ad Hoc Reporting Job Aid – This job aid is now available, describing the process of using MiSiS Ad Hoc Reporting to produce a data extract with summer school student addresses, and then using that data extract in Microsoft Word to create mailing labels. The job aid can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://lausd.schoolwires.net/Page/11833).

     

    Creating a Summer School Student Marks Report Job Aid – This job aid is now available, describing the process of using MiSiS Ad Hoc Reporting to create a report that displays summer school students and the marks for their summer school courses. The job aid can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://lausd.schoolwires.net/Page/11833).

     

    Creating a Summer School Student Schedule Report Job Aid – This job aid is now available, describing the process of using MiSiS Ad Hoc Reporting to create a report that displays summer school student schedules. The job aid can be accessed on the MiSiS Ad Hoc Reporting job aids webpage (http://lausd.schoolwires.net/Page/11833).

    Comments (-1)
  • more
CLOSE