Viewing Data

From VCAT WIKI
Jump to: navigation, search

Options to View Data

To View Data, you need to have selected the Students, and selected the Information you are interested in viewing for those students.

There are many options to view data in VCAT. Data can be viewed not only where you enter the data, but also using the following reports:

• Student Unit Report

• Student Criterion Report

• Cohort Unit Report

• Cohort Criterion Report

• Custom Reports

Student Unit Report

VCAT2 StudentUnitReport sample.png

In this sample, one group of students is selected with one piece of information. Students are listed in alphabetical order using their last name. This Student Unit Report displays one student per row with one summarized value for the unit. The summarized value is dependent on the weight assigned to the criteria in the unit. If one criterion has all of the weight (100%), then that score will be used as the summary value to give a quick snapshot for that unit. If more criteria share the weight equally distributed (by default), the summarized value will be an average of the weighted criteria. Occasionally, none of the criteria are weighted. When that is the case, no summarized value can be calculated therefore, the Student Unit Report can't be generated. The bottom row highlighted in blue gives you the Mean (average) scores for the group of students you have selected. Many options are available to refine this report.

Student Criterion Report

VCAT2 StudentCriterionReport sample.png

In this sample, one group of students is selected with one piece of information. Students are listed in alphabetical order using their last name. This Student Unit Report displays one student per row with the detailed scores for each of the criteria in the unit in individual columns. The bottom row highlighted in blue gives you the Mean (average) scores for the group of students you have selected. Many options are available to refine this report.

Criterion Detail Report

1.When running a criterion report (student criterion report or cohort criterion report), hover over the criterion name (column header) with your mouse to see the little blue i appear on the left.

Wiki2 i criterionDetail.png

2.Click on the i to create the Criterion Detail report. If you wish to print this report, click on the print button at the top right corner.

Wiki2 CriterionDetail print.png

Cohort Unit Report

VCAT2 CohortUnitReport sample.png

In this sample, one group of students is selected with one piece of information. This report displays one cohort per row with the mean of the summarized values for the cohort. The 'N' of 4 indicates that there are 4 students with data included in the Mean. Many options are available to refine this report.

Cohort Criterion Report

VCAT2 CohortCriterionReport sample.png

In this sample, one group of students (cohort) is selected with one piece of information. This report displays one cohort per row with the mean score for each of the criteria with numeric scores in the unit. The 'N' indicates the number of students with data included in each of the criterion mean. Many options are available to refine this report.

Criterion Detail Report

1.When running a criterion report (student criterion report or cohort criterion report), hover over the criterion name (column header) with your mouse to see the little blue i appear on the left.

Wiki2 i criterionDetail.png

2.Click on the i to create the Criterion Detail report. If you wish to print this report, click on the print button at the top right corner.

Wiki2 CriterionDetail print.png


Custom Reports

Custom Reports are reports specifically created and customized for your SU/district, and ready to download/print. Report Cards, Progress Reports, Placement Forms, and Student Accommodation Plan would be some examples of custom reports.

How to run a custom report for a group of students

1. Select the students.

VCAT2 StudentsSelected.png


2. Click on Custom Reports to get the list of custom reports available to you.

VCAT2 CustRep button2.png or VCAT2 CustRep button.png


3. Select the custom report of your choice. The list can be filtered by Type, Grade, and/or Subject to narrow down the selection. Use the Clear button to the right of the Subject filter to cancel all filters.

Wiki2 CustomReports filterBar.png


4. After you have selected a report, you will be prompted with a calendar to select the date you wish to run the report for. Often times in custom reports, some values come straight from the student selection, like Year, School, Course, and Section. If the current student selection does not include any of these elements part of the report, the fields will be shown blank. Type in the information you wish to show on the report for those fields. Click on Create PDF to run the report.

Wiki2 CustomReports YearSchoolSection.png


How to run a custom report for Individual Student(s)

1. By default, you are under Groups tab where you can select the Year, School, Course, and Section. Click on Individual tab, to the right of the Groups tab.

Wiki VCAT2 IndividualTab.png


2. Type first name OR last name (or part of either one) in the Search field. Click on the student name from the list displayed to select that student.

Wiki VCAT2 IndividualTab typePartName selectIndiv.png


3. Now, the student's name shows up in the Students box and also on the right, with a little minus sign in a red circle. If you wish to remove that student, click on the red circle.

VCAT2 1IndivStud.png


4. Repeat step 2 for each individual student you want to add.

The individual students selected show in one student box therefore, they are considered as one cohort.

Wiki VCAT2 IndividualTab typePartName selectIndiv+ cohort.png


5. Click on Custom Reports to get the list of custom reports available to you.

VCAT2 CustRep button2.png or VCAT2 CustRep button.png


6. Select the custom report of your choice. The list can be filtered by Type, Grade, and/or Subject to narrow down the selection. Use the Clear button to the right of the Subject filter to cancel all filters.

Wiki2 CustomReports filterBar.png


7. After you have selected a report, you will be prompted with a calendar to select the date you wish to run the report for. Often times in custom reports, some values come straight from the student selection, like Year, School, Course, and Section. If your current student selection does not include any of these elements part of the report, the fields will be shown blank. Type in the information you wish to show on the report for those fields. Click on Create PDF to run the report.

Wiki2 CustomReports YearSchoolSection.png


Active / Inactive Custom Reports

Under the A tab, go to the Custom Reports section. Select the custom report. Under Info, there is an Active checkbox.

Wiki VCAT2 Atab Active CustomReports.png


If you uncheck the Active box for the custom report selected, that report will become inactive. Every inactive custom reports will be marked with [Inactive] and shaded gray.

Wiki VCAT2 Atab INACTIVE CustomReports marked and shaded.png


Under the Data tab, the Custom Reports list has an Active Only checkbox in the filter bar, at the top. By default, the Active Only box is checked and the list will only display the custom reports that are active.

Wiki VCAT2 DataTab CustomReports ActiveOnly default wList.png


If you uncheck the Active Only box, all inactive custom reports will be included in the Custom Reports list.

Wiki VCAT2 DataTab CustomReports ActiveOnlyUNCHECKED wList.png

Options to Refine Reports

  • Here are the options available in the top menu bar to help refine the reports:

Wiki VCAT2 ReportMenuBar.png


Display Options (Horizontal Series by Default)

Filters

Percentages

Scales

Terms

Groups & Demographics

Student Fields

Options

Export

? --> clicking the question mark (?) in the top menu bar of the report will open a separate wingow and bring you directly to this section of the Wiki.


Display Options

Depending on the information, an option might be more suitable than another one to view that information. BEFORE changing the display, make any adjustments or modifications while in Horizontal Series.

Horizontal Series

VCAT2 Options bar Report Display.png

• By default, you are on the 'Horizontal Series', which displays students on the left, in rows, and data in columns. It is recommended you make all adjustments needed prior to selecting a different display option.

• The dark grey shaded options in the drop-down when clicking on Horizontal Series indicate that they are not available, based on the selection.

Wiki VCAT2 HorizontalSeries.png

Vertical Series

• The Vertical Series displays the information in rows and the students in columns.

Wiki VCAT2 Vertical Series.png


Individual Series

• The Individual Series displays the information grouped by student.

Wiki VCAT2 Individual Series.png


Bar Graph and 3D Bar Graph

  • Depending on the report you create, this type of graph can be used to display the information for individual students or student cohorts.


Wiki VCAT2 3D bar graph.png


Wiki CohortUnitReport CompositeCohort w GendeDemographics Percentages 3D BarGraph.png


  • At the top of the graph, you'll find the key to each color.
  • If you wish to make changes to the settings for the report, select Horizontal Series to go back to the initial display and make the changes.

Pie Chart and 3D Pie Chart

  • The ability to create pie charts in VCAT is very basic and colors are not consistent. It is strongly recommended that you export the data from your report to excel and use excel to build your pie charts with custom colors and settings.

Wiki VCAT2 Pie chart.png

Filters

VCAT2 Options bar Filters.png

• Click on the green '+' button to add a row that will give you options to filter the data.


• You have the option to 'Keep' or 'Hide' certain criteria based on their value/score in comparison to another value or item itself.

VCAT2 Options bar Filters keepHide.png


  • You have the option to choose which criteria you want to focus on.

VCAT2 Options bar Filters Criteria.png


  • You have the option to pick on the condition (equal, greater than, ...) to be met to isolate the students you want to focus on.

VCAT2 Options bar Filters EqualGreaterThan.png


  • You have the option to select a Number to focus on specific scores/values or an Item to compare two different criteria.

VCAT2 Options bar Filters NumberItem.png


  • The filter allows you to keep (or hide) students that may be just within a certain score range (example + or - 3 pts of a certain score).

Wiki ViewData Reports Filter within.png


  • The filter is helpful to isolate students you want to look at. In the example below, the filter will keep students that had their proficiency dropped in their Winter assessment compared to their Fall assessment.

Wiki ViewData Reports Filter ComparingItems.png

Percentages

  • It can be helpful to look at the data from the report using Percentages. The example below is using Percentages to get the percentage of student cohorts for each proficiency level (1-4).


  • Click on Percentages at the top.

VCAT2 Percentages.png


  • Click on + Add Percentage for each proficiency and set each row.

VCAT2 Percentages 1to1-2to2.png


  • Hit Apply to update the report.

Wiki ViewData Reports Percentages HorizontalSeries.png


  • The default display of the report is in Horizontal Series. Click on Horizontal Series and select 3D Bar Graph.

Wiki CohortUnitReport CompositeCohort w GendeDemographics Percentages 3D BarGraph.png


  • The key for the specific colors is at the top of the graph.

Scales

VCAT2 Scales.png

  • Depending on what information you have selected when running reports, there is a variety of different scales that may be part of the report: Numeric, Code, Note, Proficiency, Stanine, Percentile,... , just to list the most common ones.
  • By default, the report will include all the scales. To customize the selection, click on Scales in the menu bar at the top of the report, uncheck the ones you want to remove from the report, and click Apply.

Terms

  • This feature can be used to limit the data you are looking at. For example, if a student has two pieces of data due to taking the assessment this year and the previous year, checking the current year under Terms would isolate his data and only the data coming from this year would be displayed. The student's last year's data would be ignored.


Sample of student with 2 years of data. By default, the system averages the student's scores:

Wiki StudentUnitReport Student w 2pces of data.png


  • To limit the displayed data to the current year (or a specific year), go to Terms, in the option bar at the top, select the Year, and click on Apply:

WIKI VCAT2 Terms1.png

WIKI VCAT2 Terms2.png


  • The data is then displayed for the year selected only:

Wiki StudentUnitReport Student SetTerms 1pce of data.png

  • Notice that because there is only one piece of data for each student, the N values aren't showing. The default setting is for the N values to only show if there is more than 1. In this case, because one student had more than one piece of data (coming from 2 separate years), the N column appeared on the report.
  • Note that, in this case, the curriculum rubric was using 'Year' as the term. If yours is using trimesters, for example, you may also want to check the Trimerster 1, 2, and 3 boxes before clicking Apply.

Groups & Demographics

  • This feature is used to add student group information or demographic information to the student reports, if demographics information is kept in VCAT.
  • This feature will not give you a 'mean' for a particular group, like Male vs Female for example. In order to get that information, you would need to select the students using a composite cohort with the gender.


  • In the example below, the students were selected at the Grade level (all 4th graders):

Wiki StudentUnitReport Student SetTerms 1pce of data.png


Add Student Group

  • Selecting the Year only, will allow the School name to show on the student report. Make your selection and click on Apply to see the student group on the student report. In this example, Elementary School is the actual name of the school.

Wiki StudentUnitReport AddGroups Year School Showing.png


  • Selecting the Year, and the School, will allow the Course name to be displayed on the student report. Make your selection and click on Apply to see the student group on the student report. In this example, Grade 4 is the actual course name of the group selected.

Wiki StudentUnitReport AddGroups Year School Course Showing.png


  • Selecting the Year, and the School, and the Course will allow the Section names to be displayed on the student report. Make your selection and click on Apply to see the student group on the student report. In this example, Dick Persing and Julie Fourth are the section names. In the Grade 4 course selected, these are the two sections.

Wiki StudentUnitReport AddGroups Year School Course Sections Showing.png

Add Demographic

  • To add a demographic - like Male and Female - to the students selected, click on Groups & Demographics. In this demo, the demographic set is called 'STATE' but, in reality, it would most likely be found under a demographic set called 'Permanent' for Gender and Race, or under a year specific demographic set (Current, 2015-2016, 2014-2015,...) for demographics like IEP, 504, SES,... In this example, I picked the demographic set (STATE), then the demographic name within that set (Gender), and F and M (the demographic values in this case) are displayed on the student report after I clicked on Apply:

Wiki StudentUnitReport AddDemographics STATE Gender MF Showing.png


  • As mentioned at the very beginning of this Groups & Demographics section, this feature will not give you a 'mean' for a particular group, like Male vs Female for example. In order to get that information, you would need to select the students using a composite cohort with the gender.

Student Fields

Wiki VCAT2 Reports StudentFields newOnesIncluded .png

  • By default, student reports display Last Name and First Name, but other student fields are also available: Full Name, Local ID, State ID, Graduation Year, Current Grade, and Middle Name, Birth Date, and Email as well if the information is in VCAT.
  • Click on Student Fields in the top menu bar - above the report, to edit.
  • To add a new student field, click on the green circle with the + . Hit Apply to update the report.
  • To remove a student field, click on the red circle with the - . Hit Apply to update the report.
  • To change the order displayed on the report, click any selected student field (with the white background) and drag to reorder. Hit Apply to update the report.
  • Click the Clear button to reset to the default student fields of Last Name and First Name.

Options

Show Students Without Data

  • When running a student criterion report, you have the options to hide students without data. By default, Show Students Without Data is checked. To hide the students without data, just remove that check and it will update the report.

Wiki2 VCAT2 ShowStudentsWithoutData default.png

Show Category Range

  • This option allows you to display on the report the range of the scores for each criterion.

VCAT2 ShowCategory Range.png

Show Category Mean

  • This option is checked by default. It shows the mean (average) score for each criterion for the student cohort selected.

VCAT2 ShowCategory Mean.png

Show Empty Criteria

  • If there is no data for the information selected, the report will show those criteria anyway but, if part of the information selected has data and part of it doesn't, the criteria that do not have data will be hidden by default. In order to make them visible, 'Show Empty Criteria' has to be checked.

Show Date Assessed

  • This option displays the Date Assessed on record for each data point.

VCAT2 ShowDateAssessed.png

Show Date Entered

  • This option displays the date when each data point was actually entered.

VCAT2 ShowDateEntered display.png

Combine Versions

  • This option is checked by default and combines versions. When unchecked, it will display in the header the detail of the version for which it found data. See the example below with NECAP data.

VCAT2 Combine Versions Checked.png


VCAT2 Combine Versions Unchecked.png

Show Scale Color

  • This option is checked by default. It displays the colors associated with the proficiency scale if the criterion has defined proficiency levels for its values (scores/ratings).

VCAT2 ScaleColor.png

Show 'N' Values

  • By default, the 'N' column will only be displayed on the report if there is at least one 'N' value greater than 1, but you also have the option to hide or show all 'N' Values.

VCAT2 Show N values.png

Manage Categories

  • This option gives you the ability to quickly manually select criteria by checking or unchecking individual ones or all at once with 'Check All' or 'Uncheck All'. It includes a drag and order feature to let you sort the criteria as well. To do so, just click on the criterion and drag to where you want it.

VCAT2 Manage Categories.png

Reset

  • Reset to Default will show up under Options when custom settings are used. This option gives you the ability to remove at once all changes you have made using the filter bar. It will remove those settings and reset the report to its initial state.

Wiki Options ResetToDefault.png


  • Another quick way to reset all settings applied to the report is by clicking on the Reset blue link, showing under Horizontal Series, in the top left corner of the report. The Reset blue link ONLY shows up if custom report settings have been used.

Wiki VCAT2 Reports Reset.png

Export

  • If you wish to export the report, click on Export, on the top right on the menu bar.
  • Depending on the report, you may have all the export options or only some of them.

VCAT2 Export.png


  • For any graph, the only option available will be Export to PNG - which only provides a link to this Wiki to inform you that it can't be exported like the others.
  • To save the graph, you will need to place your mouse over it, right-click to be able to save the image, OR copy and paste into a document, OR select your image and drag into a word document.

VCAT2 ExportToPNG.png

Options to Export Reports

Export to PDF

  • This feature will export the report into a pdf format. Beware that if there is too much information on the report (what you currently have displayed on the screen), the information might not lay out correctly and may very well be illegible. If that's the case, return to the report and adjust the information selected and/or settings to reduce its size.

Export to Excel

  • This feature allows you to export to excel (spreadsheet format) to give you the ability to manipulate the data file if needed. In excel, you can also create some custom reports like pie charts for example.

Export to PNG

Graphic reports and charts are simply pictures on a webpage. To export, right-click (control-click on Mac) on the picture and save the image to your disc. You can also copy and paste the image directly to a document editor like Microsoft Word.