Skip to Content

EdInsight - Data Warehouse

Contact(s)

On this page...

Educators in Iowa are harnessing the power of EdInsight, Iowa’s education data warehouse to transform data into information.

Iowa Education Portal Implementation

EdInsight access can be regulated by a self-service security portal under the control of local Security Officers. The portal, also known as EdPortal applies EdInsight’s security model in accordance with Family Educational Rights and Privacy Act (FERPA) and under the approval of local Security Officers.  Access to small cell size, individual student level and Free and Reduced Lunch (FRL) is regulated by the portal’s security engine.

EdInsight Report Menu

EdInsight offers pre-formatted reports which are designed to answer an educational question quickly, with a minimum of training. EdInsight also contains multiple data cubes providing end users the ability to do ad hoc analyses. The table below defines the reports as of the current release. For a more thorough and complete description of each report’s purpose, the specific data that are included, data calculations and interpretation guidance, users are encouraged to view the report definitions in EdInsight. 

EdInsight Report Report Definition/Purpose Addresses Questions Such As...
ASMT 1.1.1 - Individual Student Assessment This report displays a graphical representation and a table of values for Iowa Assessments (National Standard Score, National Percentile Rank, Grade Equivalent) and/or Iowa Alternate Assessments for the specified year and specific student.
  • Was Mary Doe not proficient, proficient or advanced in Reading?
  • In which assessments is the student proficient?
ASMT 1.1.2 - Individual Student Assessment – Trend This report displays a graphical representation and a table of values for Iowa Assessments (National Standard Score, National Percentile Rank, Grade Equivalent) and/or Iowa Alternate Assessments for a specific student over time.
  • How has a student’s performance over time changed?
  • Is the student making the growth that is expected?
ASMT 1.1.3 - Individual Student List by Grade This report provides a list of all students for a particular grade and Iowa Assessment subtest, with NGE, NSS, and NPR scores. This report also contains bar code elements and drill through to ASMT 1.1.1 - Individual Student reports. This report can produce a list of students at either a district or building level, with an optional filter on grade.
  • Which 10th grade students are performing in the advanced range of performance on the mathematics test and therefore might need to be encouraged to take XXXX math class as 11th graders?
  • What is the range of performance on the mathematics test for 5th grade students?
  • How many IEP students in 10th grade are proficient on the Reading Test? (after exporting to Excel and completing some additional steps)
ASMT 1.1.4 - Individual Student List by Grade – NSS History

This report displays a list of students' National Standard Scores (NSS) beginning with the prompted School Year and returning all available historical NSS information for a specified grade level and test area.

Exporting this report to Excel will provide users with greater ability analyze individual student and group growth patterns.

  • Which students grew less than a typical amount between 7th and 8th grade in Reading? (after exporting to Excel and completing some additional steps)
  • What percent of students in 4th grade grew at a rate that was at or greater than the typical amount of expected growth between 3rd and 4th grade? (after exporting to Excel and completing some additional steps)
ASMT 1.1.5 - Alternate Assessment This report displays the individual student's performance on the Iowa Alternate Assessment based on the availability of the data within EdInsight.
  • In which assessments is the student proficient?
ASMT 1.1.6 – Alternate Assessment - Student List This report returns a list of students, along with basic demographic information, that took the Iowa Alternate Assessment in Iowa for a given school year.
  • What students took at least one Iowa Alternate Assessment subtest?
ASMT 1.1.7 – Alternate Assessment Count by District or AEA This report displays a count of students that took the Iowa Alternate Assessment. The counts can be grouped either by the District name or the AEA name.
  • How many students (in an AEA or District) took at least one Iowa Alternate Assessment subtest?
ASMT 1.2.1 - Group Assessment Report

This report displays a given group's average (building, district, AEA, or State) performance on the Iowa Assessments and allows comparison of this average to national student norms data for the prompted date parameters.

For the specific group testing period, and subtest selected, the report displays a graphical representation of the data and a table of the values for the following score types: Grade Equivalent and National Standard Score

This report displays simple cohort data. A simple cohort is ALL STUDENTS present in the years and grades selected, including move-ins and move-outs.

  • What is the average NSS for our 4th students on the most recent reading test?
  • How many NSS units have our 7th grade students grown over each of the last 3 years?  Has this growth kept pace with typical growth amounts?

    Please note: Typical growth amounts between grade levels are obtained using other supporting documents and are not currently available on EdInsight.
ASMT 1.2.2 - Group Achievement Context This report displays aggregate AEA, District, and Building (allowing comparisons) percent proficient data across all NCLB Subjects and grades 3-8, 11. Sorted by percent proficient, this report allows you to select specific grades and subject for analyses. Users with Small Cell Size access will see non-redacted data for their specific area.
  • How does my district’s percent of student proficient in 4th grade science compare to other districts within my AEA?
  • Which districts are doing better than us and might be able to provide us with ideas for improvement? 
ASMT 1.3 - Cohort Performance Report This report permits you to review performance for a group of students over time and to choose among one of three cohort types. This report provides a drill down report to student level (ASMT 1.3.1) for each of the NCLB performance bands (not proficient, proficient and advanced) for users with Individual Student Level privileges.
Cross Sectional Cohort:
The Cross Sectional cohort is the SAME GRADE over time. For example, a cross sectional cohort for 3 years would include 5th graders in 2005-2006, 5th graders in 2006-2007 and 5th graders in 2007-2008.
Simple Cohort:
The Simple cohort is ALL STUDENTS present in the grades selected. This group includes move-ins and move-outs. For example, a simple cohort is the 3rd grade class in 2005-2006, 4th grade in 2006-2007 and 5th grade in 2007-2008.
Matched Cohort:
The Matched cohort is the SAME STUDENTS over time. For example, a matched cohort is the same students from 3rd grade in 2005-2006, 4th grade in 2006-2007 and 5th grade in 2007-2008.
  • Have the percent of students who are proficient in 3rd grade during the 2011-12 school year improved in comparison to previous 3rd grade students since we began the new reading program in 1st and 2nd grade during the 2009-10 school year? (Cross Sectional Cohort)
  • Have the percent of students performing in the advanced achievement level increased or decreased over the last three years for our current 10th grade students in the area of reading? (Simple Cohort)
  • Is our steady decline in math computational skills from 3rd grade until 8th grade the result of the influx of at-risk students or a systemic curriculum and instruction issue for all students even for those who have attended in our district between those grades? (Matched Cohort)
ASMT 1.5.3 – IELDA Crosstabs

This report displays counts and percentages of IELDA assessment results for the selected location (District or Subgrantee). The counts presented within this report are counts based on students’ subtest scores, grouped by Subtest (e.g., "Reading", "Writing", etc.) and Grade Level.

IELDA is an acronym for "Iowa-English Language Development Assessment", and is the growth measure used to assess English language proficiency (it is not a placement test).

  • How many students took the IELDA at a district?
  • Which grade in the district had the highest percentage of IELDA test takers?
EQTY 2.1/2.2 - District /AEA Equity Report

This report examines student, employment, and course data for the purposes of reporting race, ethnicity, and other subgroup equity in the selected district or AEA.

All student and course data on this report are disaggregated by gender, race, special education, 504 plan, English language learner status, and low SES (free reduced lunch status). All employment data is disaggregated by gender and race.

  • How diverse is my district student and staff makeup with respect to race/ethnicity?  How has this changed over the last 3 years?
  • What is the demographic makeup of our district’s special education program?
  • Which gender is more prevalent in higher level science classes?
  • Which classes are special education students most frequently being integrated into?
SI 2.5 – School Improvement Data Report The School Improvement Data Report allows users to display district-level data on many different topics that are commonly reviewed during school improvement site visits. When available, five years of historical data are displayed in the report.
  • What is the projected enrollment for this district?
  • What is the trend for average daily attendance?
  • What percent of 11th graders are college ready?
APR 4.1 - Student Achievement

This report is designed to report publicly the progress towards proficiency for the Reading, Mathematics and Science in grade levels 3-8 and 11. Current year “preliminary” data is available.

Data are provided for a selected building, year and subtest with corresponding data at the district, AEA and state to allow for easy comparisons. Public and non-public school data is available.

EdInsight currently contains data for Iowa Alternate Assessments starting in the 2011-2012 school year.  Any years of data presented on this report prior to the 2011-2012 school year reflect data for Iowa Testing Programs only.

  • What percent of 8th grade students are proficient in reading in each of the NCLB reported subgroups?  How does this compare to AEA and State rates?
  • Which 8th grade subgroup has the largest achievement gap in reading, math and science?
  • What are the achievement rates of XXX school district in reading?
APR 4.2 – Annual Progress Report

This report is designed to report publicly the progress towards proficiency for the Reading, Mathematics and Science in grade levels 3-8 and 11 for the past five years. Public and non-public school data is available.

EdInsight currently contains data for Iowa Alternate Assessments starting in the 2011-2012 school year.  Any years of data presented on this report prior to the 2011-2012 school year reflect data for Iowa Testing Programs only.

  • How has proficiency for a particular grade or cohort of students changed over time?
CURR 6.1 - Curriculum Accreditation Report This report allows the user to explore all courses that are being offered and taught for a selected district and building.  The resulting report displays a column chart for the selected school year that compares the number of Carnegie Units broken down by accreditation area for all courses the selected building offers and teaches, in comparison to the state, AEA, or district enrollment category. The report also displays all data for the selected year span in table format.
  • Does our school comply with state minimum expectations for courses offered and taught in the area of Social Studies?
  • What subject areas offer the most courses and credit hours?
  • Is our school offering more than the average number of Vocational Courses?
CURR 6.2 - Curriculum Accreditation Report - Detail

This report is a drill down report to the CURR 6.1 report that allows users to view specific courses that the selected building is offering and teaching.

The report displays the local course number, local course name, NCES course code, number of Carnegie Units, providing institution, course type, and number of students enrolled for each course in the selected building.

  • How many sections of US History does our school offer?
  • How many students are in our Spanish III and IV classes?
  • How do our high school science offerings compare to other schools our size? (initially use the UTIL9.2 report to identify schools of similar size)
SPED 7.1/7.2 - AEA/District Part B Special Education Data Profiles The Special Education AEA/District Profiles Report allows users to display AEA-level data on many of the special education indicators that are required based on Iowa’s State Performance Report that is required by the Office of Special Education Programs (OSEP) under the Individuals with Disabilities Act (IDEA) of 2004. Annual outcomes and targets are displayed graphically for each indicator.
  • How are the students with IEPs performing on the Iowa assessments?
  • What percentage of students with IEPs is graduating in 4 years?
  • What percentage of students with IEPs is spending 80% or more of their day in general education classrooms?
UTIL 9.2 - School and District Comparison Report

This report allows the user to find comparable schools or districts in terms of size (enrollment), and/or other demographic variables.

Comparisons are based upon the selected school year, District and School (optional) and the user selected variables such as: Enrollment, Race/Ethnicity, Free and Reduced (FRL) eligible, ELL, IEP.

  • What other buildings in the state of Iowa have similar enrollment and Free and Reduced rates as our building and what is their achievement rates in reading?  (once buildings are identified, the second part of this question can be answer via using the 4.1 APR report)
IND 11.1- Graduation Report This report defines the Graduation Rate(s) for selected School Year(s) by State, AEA, District and Building.
  • How does our district’s graduation rates compare to AEA and state rates?
  • Have efforts to meet the needs of our At-Risk students resulted in improved graduation rates over the last three years?
IND 11.2 - Dropout Report

This report defines the dropout count (7-12), enrollment and dropout rate for selected School Year(s) by State, AEA, District and Building from 2005-06 until the current year. With disaggregations and trending, this report will provide insight into the quantity and content of dropouts.

The District Dropout report will allow users with Individual Student Level (ISL) privileges to drill down to student level.

  • What is our district’s dropout rate for the 2010-11 school year?
  • Have our dropout prevention plans decreased the number and percent of dropouts in our district over the last three years?

IND 11.6 - C11 Indicator (% of students who attend college within 16 months of graduation)

The purpose of this report is to comply with the State Fiscal Stabilization Fund Program – Phase II, by providing for each high school in the State, by student subgroup, the students who graduate from high school and who enroll in an Institution of Higher Education (IHE) within 16 months of receiving a regular high school diploma.
  • What is the percentage of IEP students from our district who enrolled in postsecondary school within 16 months of graduating?  How does this compare to AEA 267 rates
  • Which subgroup of students from AEA 267 had the highest percentage of postsecondary enrollment?
IND 11.6.1 – C11 Indicator – All Locations Same as 11.6 – returns values on all locations on one report for comparison.
  • How does my district compare to other districts in the percentage of students who enroll in postsecondary education opportunities following high school graduation?
FIN 14.1 School District Financial Report Card The purpose of the School District Financial Report Card is to assist school boards in satisfying the requirements as required by Iowa code 279.63. Each school district is required to develop, maintain and distribute a financial report on an annual basis. The objective is to facilitate public access to a variety of information and statistics relating to the education funding received by the school district, enrollment and employment figures, and additional information.
  • What are the district administrators’ average salaries?
  • What is the district’s cost per pupil?

 

AEA Contacts

Support for the EdInsight project is provided by a network of trainers and site coordinators in our AEA's.  The network provides valuable professional development in data use and literacy, and EdInsight reporting and analysis training.

To sign up for training and access to EdInsight, contact your AEA liaison.

 

AEA Contact Email
1 Marcia Kruse mkruse@aea1.k12.ia.us
267 Jon McKenzie
Joe Kremer
jmckenzie@aea267.k12.ia.us
jkremer@aea267.k12.ia.us
8    
9 Edward Gronlund
Faith Kroger
Jessica Giovannini
Nick Conklin

aeadata@aea9.k12.ia.us

 

10 Michelle Tressel mtressel@gwaea.org
11 Karla Day kday@heartlandaea.org
GH Sherry Huffman shuffman@ghaea.org
GP Evan McCormick
Cory Johnson
Mike Stiemsma
evan.mccormick@gpaea.org
cory.johnson@gpaea.org
mike.stiemsma@gpaea.org
 
NW Sue Chartier
Jordan Menning
schartier@nwaea.org
jmenning@nwaea.org 

 

Printed from the Iowa Department of Education website on February 10, 2016 at 12:58am.