You are here

WISEdash How-To: Use Dynamic Crosstabs

Introduction

Definitions

Introduction

Crosstabs allow you to change the way you view the data. WISEdash's crosstabs are dynamic because they update when you change the filters. This is particularly useful when you want to quickly compare specific or detailed data. For example, last year, your high school's teachers invited local farmers to come speak to certain agriculture and food-related classes. It took a lot of effort to coordinate this with the farmers' busy schedules, and so they want to know if the effort was worth it. Specifically, they want to know if more students have enrolled in those classes for this year. If so, they will continue the program and even expand their efforts to additional classes.

  1. If the crosstab shows no data at first, read the message at the top of the crosstab that indicates which filter you need to select for the crosstab to display data.
  2. Click Filter data at the top of the crosstab to apply one or more filters. 
    • Some filters are only available in certain dashboards.
    • For example, in the Course Enrollment dashboard, select the Course Subject filter to Agriculture, Food, and Natural Resources.
  3. Notice the filters, or "data items," under the header Available data.
    • There are more options than the filter(s) you selected from the Filter data dropdown at the top of the crosstab.
    • For example, you set the Course Subject filter from the Filter data dropdown, but there is additionally a Course Name data item under Available data.
  4. Drag and drop desired data items from Available data under the headers Columns and Rows.
    • For example, drag and drop Course Name under Rows.
  5. Continue to drag and drop data items from Available data into Columns and Rows until you have the data combinations you would like to view.
  6. Continue to filter the data as needed. To quickly filter in the crosstab, click the filter icon filter icon on the right side of each data box.
  7. Choose the Function that meets your needs.
    • Only Sum provides meaningful results for certain data sets, such as enrollment.
  8. If the table's layout does not suit your needs:
    • swap the data in rows for the data in columns to change the layout
    • click filter iconin a data item and unselect the options that you do not need to analyze
    • change the Render as selection at the top of the crosstab
  9. For example, to make the table shorter, click the filter iconin the Course Name data item and unselect the checkbox at the top, which had selected all courses in this subject. Then, only select the checkbox for the specific courses on which you need data.
  10. Click an underlined data point or data item to drill into the details.
    • Details only display individual students if your user role authorizes this.
    • An empty data cell means that no data is available for that combination of dimensions.
  11. Click Save and name the configuration to use this table's layout and filters again in future sessions.

Definitions of Applicable Crosstab Data Filters

 

Each subtab displays a unique dashboard with ‘available data’ filters that specifically apply to it. They are defined in detail on their respective ATD Dashboard pages.

The most commonly occurring filters are defined in detail below:

  • Acctbl Sch/Acctbl School
  • Att Sch/Att School Name
  • Disability
  • Econ
  • EL/status & ELP Code
  • Gender
  • Grade
  • Homeless
  • Race
  • SPED
  • Acctbl School - Accountable School Name: The fully spelled out name of each school, for example, Lincoln Early Learning or Sojourner Elementary. This filter works best for large(r) districts with many schools.

  • Acctbl Sch - Abbreviated Accountable School Name: Abbreviated names of each school, for example, Lincoln Ear or Sojourner E; maximum of 10 characters. This abbreviated name filter works better for smaller districts with fewer schools.

    • Accountable schools are schools that include students who are accountable (or were at the effective date of the snapshot) to their school/district, but attending a different school. For example, a student is attending a public school in their district of residence, but is temporarily attending a day-treatment facility for half-day treatment. The resident district school is accountable and attending. The day-treatment agency is only attending, and is not the accountable agency.

    • Refer to the data element page on District Accountability for more details.

  • Att School Name - Attending School Name: The fully spelled out name of each school, for example, Memorial High or Carver Intermediate. This filter works best for large(r) districts with many schools.

  • Att Sch - Abbreviated Attending School Name: Abbreviated names of each school, for example, Memorial H or Carver Int; maximum of 10 characters. This filter works best for small(er) districts with fewer schools.

    • Attending school counts exclude students accountable to the school/district but who are attending elsewhere. Attending school count displays the students attending this (selected) school.

    • Refer to the data element page on Submitting District for more details.

  • Disability - Checklist options for disabilities, also referred to as Special Ed program areas.

    • Options include:

      • A - Autistic

      • DB - Deafblind

      • EBD - Emotional Behavioral Disability

      • H - Deaf and Hard of Hearing

      • ID - Intellectual Disability

      • LD - Learning Disability

      • OHI - Other Health Impairment

      • OI - Orthopedic Impairment

      • SDD - Significant Developmental Delay

      • SL - Speech and Language

      • TBI - Traumatic Brain Injury

      • V - Blind and Visually Impaired

    • Visit the Disability data element page for more information.

  • Econ - Economic Disadvantaged Status - A yes/no/unknown indicator stating whether a child faces economic disadvantages (Econ Disadv) or does not face economic disadvantages (Not Econ Disadv).

  • EL /EL Status - A yes/no/unknown indicator stating whether a student is currently identified as an English Learner who is receiving EL services. EL is preferred instead of ELL.

  • ELP Code - Indicated with a number 1-7, each number indicating a student’s degree of English Language proficiency (ELP). ELP code or classifications are defined in PI 13.08 Wis. Admin Code. Students with English language proficiency classifications of 1-5 are considered Limited English Proficient (LEP). For students in grade levels KG to 12, the value reported is expected to correspond to the results from the most recent administration of the ACCESS for ELLs exam. Students identified as English Learners (ELs) are assessed annually to determine their level of English language proficiency (ELP), ensuring that they are progressing to achieve full English proficiency. This would refer to a student who has an ELP code of 1-5. An ELP code of 6 indicates a student has succeeded in attaining full English proficiency, and an ELP code of 7 refers to a student who was never EL.

  • Gender - The sex type of a students in WISEdata is referred to as gender in WISEid and WISEdash. Gender can be reported as male, female, or non-binary. Prior to the 22-23 school year, non-binary was not a reporting option.

  • Grade - The grade level a student is placed in, indicated as: PK, K3, K4, KG, or 1-12.

  • Homeless - Indicates whether a child is homeless (Homeless), or not homeless (Not Homeless). Homeless students lack a fixed, regular, and adequate nighttime residence.

  • Race - The racial group of a student, indicated as American Indian, Asian, Black, Hispanic, Pacific Isle, White, or two or more.

  • SPED - Indicates whether this is a student with a disability (SwD), or a student without a disability (SwoD).