The Colorado Department of Education

Offices | Staff Contacts | Colorado.gov

SchoolVIEW Data Lab FAQs


General Questions


Why is BOCES not a grouping variable option?

The BOCES variable has been created but not yet put into the Data Lab tool, because CDE wants to consult with Colorado BOCES leadership before releasing the data grouped in this way.

Return to Top


What do I need to know about the Region Grouping Variable?

Colorado is divided into eight regions when grouping its local education agencies. The Charter School Institute is also shown as belonging to a particular region, even though its schools are located throughout the state.

Return to Top


What do I need to know about the Online Grouping Variable?

A full-time Online Education Program in Colorado is defined as a non-religious, non-sectarian full-time online education program or school that delivers a sequential program of synchronous or asynchronous instruction from a teacher to a student primarily through the use of technology via the internet in a virtual or remote setting. More information about these programs in Colorado is available here.

Return to Top


What do I need to know about the Title I Grouping Variable?

Title I schools receive federal Title I funds, and they can be elementary, middle, or high schools. More information about this program is available here.

Return to Top


What do I need to know about the LEA Grouping Variable?

LEAs are Local Education Agencies. In Colorado these are typically local school districts, but the Charter School Institute, the Colorado School for the Deaf and Blind, and in some cases BOCES are also authorized to operate public schools.

Return to Top


What do I need to know about the Charters Grouping Variable?

In the state of Colorado charter schools are public schools that operate via a contract with an authorizer such as the local school district or, in some cases, the Colorado Charter School Institute. You can get more information about Colorado public charter schools here.

Return to Top


What do I need to know about the Administrative Unit Grouping Variable?

Administrative Units (AUs) are entities that provide additional educational services, such as for special education. Large districts typically are their own administrative units, but small districts in the same area band together under a single AU, most often a BOCES, to provide such services.

Return to Top


What do I need to know about the AECs Grouping Variable?

AECs are Alternative Education Campus schools. Information about this designation is available on this website.

Return to Top


Why is the n-count different for achievement and scale score calculations?

Achievement (the percent proficient and advanced) calculations include students who have no scores (such as parental refusals to participate, incomplete tests, etc.) as "not proficient." This is how CSAP data are reported officially in July-August to the public. Scale score calculations only include students with valid scores, which will always be the same or a a smaller number than the former.

Return to Top


Why can't I use Internet Explorer 8 with the Data Lab?

This is an IE8 configuration issue involving Cross Site Scripting. IE8 is modifying the URL to help protect users from clicking on links to malicious sites, and therefore only allows Cross Site Scripting from trusted locations. Here is the solution - you need to have Administrator rights on your system to make the following changes.

1. Open IE8, go to Tools > Internet Options > Security tab > Trusted Sites zone, click on Sites button and add http://elm.cde.state.co.us to the trusted site list. As Elm (http:) is not a secure server app, uncheck the box to Require server verification (https:) for all sites in this zone. Close the Sites box. Because this is a trusted site, there is no risk.

2. Still on the Security tab, click on Custom level and scroll down down 90% of the way down to the Enable XSS filter setting. Click the Disable option, click OK and confirm you want to apply the change to this zone. Close the Internet Options and all IE8 windows. When you re-open IE8, you should be able to run and re-run the Data Lab report.

Return to Top


What are those "Exclusions" for, and when should I apply a particular one of those?

These options tell the database which students you want included in the calculations. If you want to generate a report that exactly matches the official public numbers, you have to use them appropriately. Here are some details:

  • To match the CSAP official reporting that comes out at the beginning of August (i.e., the percentage of students in particular achievement levels by grade and school), you should choose Included in state calculations (no exclusions), because that will include all students that took the test for that administration. The official percentage of students scoring at the proficiency/advanced levels uses all students, including those whose scores were not valid, so this is the appropriate choice to make.
  • To match the growth numbers in the Colorado Growth Model bubble plots, you need to user either Included in District Calculations or Included in School Calculations. This calculation only includes students that were in the district or school by October 1 of that academic year, so it restricts the data to students that were in their seats for about a whole academic year.
  • To match the proficiency or growth numbers reported on the state Performance Frameworks, you need to user either Included in District Calculations or Included in School Calculations. The growth numbers will be the same because they are always reported using this rule; the proficiency calculations can be different from that of the official CSAP reporting, because now the data are restricted to just students that were in their seats for about a whole academic year.
  • To match the data that are in AYP calculations, this tool is not useful. AYP uses different exclusion rules and different minimum n-counts, so this tool will not be useful to you in that effort.

Return to Top


Why does the Excel report link not work when I'm using Safari?

Safari is not supported, and produces incomplete results when you export to Excel. The HTML pages appear to be fine from Safari. If you need to download large sets of results, please download Mozilla Firefox, it is free, very secure, and works perfectly using on both PCs and Macs.

Return to Top


Are the growth data rounded in any way?

Yes, median growth percentiles having a .5 are rounded up. This is consistent with the way growth is reported in other places on SchoolVIEW.

Return to Top


I am looking for data from a school that is now closed, so it doesn't appear in the schools list for the district I selected. How can I get those data?

If you include years from when that school was open in your query, and choose "School" as a grouping variable, you will get data from that school (as long as it had public CSAP or growth results). The schools list for each district is based on the most recent year of data, so closed schools do not appear there (but the data are there).

Return to Top


Do the data match the official reporting?

As far as we can tell, the data match when the query is set up correctly. But we cannot guarantee that until we do a lot more testing, so we will maintain the disclaimer on the main page until we are sure. There may be occasional differences due to rounding.

In terms of proficiency in academic indicators on the School or District Performance Framework reports, the numbers will not match because those indicators also include CSAPA and the Spanish language versions of the CSAP tests; this tool does not contain those data.

Return to Top


I am a researcher and would like to know more about where these scores come from. Can you point me to technical documentation about the assessments, the scoring model, and the growth calculations?

Most or all of the information is already public. CSAP technical manuals and other such resources can be downloaded here. Technical papers about the Colorado Growth Model can be found here. FAQs, videos, and other resources around growth can be found here.

Return to Top


I asked for a lot of data, but I only saw one page of output on my web page. Where is the rest?

You can use the "Page Down" link at the bottom of your first web page to scroll down to the next page. If you asked for a lot of data, it is generally better to run the report again and export the results to Excel using the link provided. Then you can manipulate the data and formatting in a much more flexible way.

Return to Top


How can I combine Reading and Math scores into one set of results for a school?

The state does not typically report data in this way, so we do not allow you to do that either in the current version of this report.

Return to Top


Where are CSAP Science/Lectura/Escritura/ACT/CSAPA scores?

These scores are not currently available in the Data Lab tool, primarily because growth is not calculated for these assessments.

Return to Top


Why do some schools have data listed without a code designating them as elementary, middle, or high school (EMH)?

When districts submit their student CSAP data, sometimes they list students in grades that are not within the official range for their school. For example, in a high school's CSAP data could appear the data from a student in 7th grade. CDE's data system does not know what to do with these students' data because they cannot be reported in a high school grade range, so the students appear in a group unassociated with an EMH code. In a few cases there are enough students that this group's proficiency or growth are reported publicly in the Data Lab.

Return to Top


What do I need to know about the ELL Grouping Variable?

In this report, as for the state as a whole, an ELL (English Language Learner) is defined as a student who, at some point, as determined by the district, had a primary home language other than English and who as a result demonstrated limited English proficiency.

Return to Top


What do I need to know about the EMH Grouping Variable?

In this report, EMH (Elementary Middle High) code is based on CDE's definitions for these school levels based on the grade range in a building in a particular academic year. For example, a school may have grades Kindergarten through 8th grade, but a single school number. CDE divides this school up into two levels, and elementary and a middle portion. The complete set of definitions can be accessed in this spreadsheet.

Return to Top


What do I need to know about the Race/Ethnicity Grouping Variable?

In the academic years 2003-2010, ethnicity was coded as membership in one category: American Indian or Alaskan Native, Asian or Pacific Islander, Black, Hispanic, or White. In some cases data are coded as Unreported.

The reporting of data for race/ethnicity changed in 2011. The new categories are American Indian or Alaskan Native, Asian, Black, Hispanic, White, Hawaiian/Pacific Islander, and Two or More Races.

When you select a year of data prior to 2011, you are getting the data broken out using the old method, but the labels used are the new ones. This means that Hawaiian/Pacific Islanders were included in the Asian group of data, just as they were before - there is just no explicit label that tells you that. They have their own category label starting in 2011.

The Two or More Races category did not exist before, so those students in the past were included in one of the five original groupings. As you can see, if you select data prior to 2011, no Two or More Races data appear in your results.

Return to Top


What do I need to know about the Free and Reduced Grouping Variable?

In this report, Free and Reduced (shorthand for Eligible for Free or Reduced Priced Meal, a federal program) is a variable representing poverty. Students can either be eligible for it (and therefore are presumed to be a part of a family in poverty), ineligible, or Unreported.

Return to Top


What do I need to know about the Gender Grouping Variable?

In this report, Gender is coded as Male, Female, or Unreported.

Return to Top


What do I need to know about the Gifted and Talented Grouping Variable?

In this report, Gifted and Talented students are identified as such by their districts in conformity with state law. In some cases data are coded as Unreported.

The level of detail of this category changed in 2010, with specific areas of giftedness being newly reported. For the moment CDE cannot report the simpler Gifted/Not category in the 2010 or 2011 years - doing so will involve substantial changes to the programming underlying this tool. We hope to be able to do this at a later date.

Return to Top


What do I need to know about the Grade Grouping Variable?

CSAP is grade-specific, even though there is an overall scale used for all grades. If you are creating a report using the scale scores as your output and ignore the Grade grouping variable, your results may be difficult to interpret because they will consist of students taking different tests, in varying amounts. Therefore we always recommend using the Grade grouping variable when looking at scale scores. In many cases other output is also typically presented at the grade level.

Return to Top


What do I need to know about the IEP Grouping Variable?

Students identified by districts as having a disability are coded with a Yes in this field; otherwise with a No. In some cases data are coded as Unreported. IEP stands for Individualized Education Plan.

Return to Top


What do I need to know about the Minority Grouping Variable?

In this report, minority is defined as not having a code of White or Unreported in the Ethnicity section on the CSAP data collection.

Return to Top


What do I need to know about the School Grouping Variable?

This grouping is based on having a unique CDE school number in a particular year. The same school number may be associated with different EMH levels, however (see EMH definition above). So you should generally include the EMH grouping variable whenever you choose to display data by school. If you do not do so, you will get data aggregated for all grades in a school. This is especially a problem when you are trying to compare data from two schools, one which only has grades 1-5 and another which is a K-12 schools. Using the EMH grouping variable along with School will break up the K-12 school into its elementary, middle, and high school portions.

Return to Top


I've made my selections but I don't know how to tell the system to generate my report.

Hit the Finish button at the bottom of the web page. You may have to scroll down to see it, depending on your computer's hardware and settings.

Unfortunately, at this time the system does not allow us to change the name of this button to something more intuitive like "Done."

Return to Top


What are those little "information" icons?

Those indicate to you that there is a definition or some information available when you mouse your pointer over it. In Internet Explorer these "data tips" disappear after a couple of seconds, but in Firefox they will stay up as long as you leave your pointer there.

Return to Top


When I select a bunch of schools and districts, I get the following error message:

This error means you have selected too many schools or districts. You can usually get the analysis that you want without getting this error if you make your selections more judiciously.

For example, you do not need to check the box next to each district name if you would like all districts included. By default, all students in all schools and districts will be selected. You should only use the checkboxes if you are selecting out a particular set of schools or districts.

Return to Top