Return to Lesson Menu

Make Cross-Tabulations

Slide 1

The View Results screen in Quick Start Mode. The querry parameters displayed are Grade 8, Reading, National Public, Student classified as limited English proficient, Gender, and Year 2003. The Cross-Tabulation radio button is highlighted and the table displays  cross-tabulated results.

Description:

This slide displays an animation of the View Results screen in Quick Start Mode. The querry parameters displayed are Grade 8, Reading, National Public, Student classified as limited English proficient, Gender, and Year 2003. View Results shows two independent tables for the two selected variables. Next, the Cross-tabulation radio button is highlighted and the display fades into one with the button selected and the results cross-tabulated.

Narration:

By default, NDE compiles individual data tables for each variable. However, you can cross-index two or more variables and combine them into a single table. Cross-tabulation is not possible when only one variable is selected.

Slide 2

In the Cross Two Variables popup window the cursor selects 'Student classified as limited English proficient' as the first variable to cross-tabulate.

Description:

This slide displays an animation of the Select Criteria page in Quick Start Mode. The querry parameters displayed are Grade 8, Reading, and National Public. The cursor moves to select Gender and Student classified as limited English proficient, then moves to select Go To Results. On the View Results page, the cursor then moves to select the Cross-Tabulate radio button, after which the Cross Two Variables popup window appears. In this dialog window the cursor first selects Student classified as limited English proficient and then Gender, then presses the Update Table button. A cross-tabulated table then appears.

Narration:

Quick Start mode can only cross-tabulate two variables at one time in 2-way tables. Begin by selecting "cross-tabulation" on View Results. On the popup window, select the two variables you want to cross-tabulate. The first column selected will be the first column in the table. Click "Update Table."

Slide 3

Format Table view in Advanced Mode with the table updated automatically after the cursor clicks the cross-tabulation radio button.

Description:

This slide displays an animation of options on Format Table page in Advanced Mode. The cursor moves to the cross-tabulation radio button and selects it. The screen changes to a cross-tabulation format. The cursor then moves to the Go To Results button and selects it. The screen changes to the resulting cross-tabulation results page.

Narration:

Advanced mode can cross-tabulate two or more variables in "n-way tables." Just click "cross-tabulation" on Format Table. The table is generated automatically. Move columns to the left or right by clicking the arrow links atop the columns.

Slide 4

The Cross Two Variables popup window in Quick Start with Gender and Student classified as limited English proficient in the variables list. Above the list is the Update Graph button.

The Cross Two Variables popup window after variables are selected. The cursor is prepared to click the Update Graph button.

Description:

This slide displays an animation of the View Results page in Quick Start Mode. The querry parameters displayed are Grade 8, Reading, and National Public. The radio button for "I want results in a graphic" is checked and a bar-chart graphic is displayed. The cursor then moves to select the Cross-Tabulate radio button, after which the Cross Two Variables popup window appears. In this dialog window the cursor first selects Student classified as limited English proficient and then Gender, then presses the Update Graph button. The cross-tabulated graphic appears.

Narration:

You can create 2-way and n-way cross-tabulations for graphic data, as well as for table data. Select the cross-tabulation radio button for a graphic. If using Quick Start, continue by making selections on the popup window.

 

Return to Lesson Menu