Tutorial: How to Generate a State Tables Report

1. To begin, you must select one, many, or all states, as shown in Figure 1.

• To easily select all states, select the All States checkbox. To deselect all states, simply deselect the All States checkbox.
• If you want to compare the selected states to the nation, be sure to select the National checkbox.

Figure 1: Select one, many or all states

2. Next, specify whether you want to display the State names on the top or left side of the data tables by selecting either “Horizontally” or “Vertically” radio button under Select to display state names horizontally or vertically, as shown in Figure 2.

• If you select “Horizontally”, the States will be displayed on the x-axis (on the top of the data table), and groups/sub-groups/data elements on the y-axis (on the left of the data table).
• If you select “Vertically”, the States will be displayed on the y-axis (on the left of the data table) and groups/sub-groups/data elements on the x-axis (on the top of the data table).

Figure 2: Select to display state names horizontally or vertically

• ---

  NOTE: If you have selected ten or more states, it is recommended that you select the “Vertically” radio button. This will help to prevent horizontal scrolling. However, if you have selected a large number of data elements, horizontal scrolling may still occur.

  ---

3. Next, you must select one, many or all data elements. Each data element is only in one sub-group, each sub-group is only in one group and each group is only in one category.

• Initially, all categories appear collapsed with a plus icon () in front of each category as shown in Figure 3. Select the plus icon to expand the category. To collapse the category, select the minus icon ().
• When you mouse-over the Category name, you will see the Category's name and description.
• If you select a category, the system will automatically select all groups, sub-groups and data elements in that category.
• If you select a group, the system will automatically select all sub-groups and data elements in that group.
• If you select a sub-group, the system will automatically select all data elements in that sub-group.
• The system displays groups that contain more than one sub-group with a plus icon (). Select the plus icon to display the group’s sub-groups. To then hide the sub-groups, select the minus icon ().
• The system displays sub-groups that contain more than one data element with a plus icon (). Select the plus icon to display the sub-group’s data elements. To hide the data elements, select the minus icon ().

Figure 3: Select one, many or all data elements

• As shown in Figure 4, if you select either the All Reading or All Math group in the Annual Measurable Objectives category, the system will by default select all academic years and grades in those groups. You can select just one academic year and/or grade by selecting an individual option in these fields. You can also select multiple academic years and/or grades by ctrl-clicking multiple options in these fields.

Figure 4: All academic years and grades are selected by default when you select the Reading or Math groups, but you can refine this selection to one or a few.

• The system limits the number of Data Elements you can select at one time to 200. A box below the selections keeps a count of the Data Elements selected at a given time. If the number of Data Elements you select exceeds 200, the box will be surrounded by a red border, as shown in Figure 5.

Figure 5: Selected data elements

• If, having selected more than 200 Data Elements, you click Display Report, a message will appear stating that too many have been selected, as shown in Figure 6. You may then click OK for the opportunity to de-select some data elements.

Figure 6: Too many data elements selected

• ---

  Note: If at any point you want to reset the form, select the Clear Selections button at the bottom of the page.

  ---