Text Alternative for Custom Tables Instructional Video

Video Actions Audio Transcription
The AGID home page. The cursor moves over the Custom Tables link in the middle of the home page. The following tutorial will take an in-depth look at the Custom Tables section of AGID.
The Custom Tables landing page. This section allows users to generate detailed data tables for multiple years, geographies, and data elements within a data set. The first page lists the A o A and Census databases that are available.
The cursor selects the first link "State Program Reports (SPR) 2005-2011" on the Custom Tables landing page. The data below expands to show a brief description and a "Continue to SPR Custom Tables" link. For this tutorial, we will look at the State Program Reports and cover the basic steps in building a data table.
The State Program Reports (SPR) page. Below the heading, the links "Years", "Data Elements", "Stratifiers", "Geography", and "Display Table" links are available to select specific data for the report. The Custom Tables section is a multi-step process where users select years, data elements, stratifiers, geographies, and then generate a data table. We will use these links to navigate through the steps.
The State Program Reports (SPR) page. The cursor is moving through the years checkboxes and selecting years. On the initial screen users can select one or more years using the check boxes. The All Years checkbox allows users to select all years with a single click. Once you finalize your selection for years, click the Data Elements link to process to the next step. The years selected will be automatically saved.
The State Program Reports (SPR) page. The "Data Elements" link is chosen in the group of links below the heading. On the Data Elements screen, users can select one or more data elements within a topic area. Click the triangles to expand a group.
The State Program Reports (SPR) page. On the "Data Elements" page, the cursor moves through and clicks the "i" icon next to totals. A popup window appears with help about the Client Totals. Information about the data elements is available by clicking on the 'i' icon.
The State Program Reports (SPR) page. On the "Data Elements" page, the cursor moves through and expands the "Grandparents - Characteristics by Age" section, the "Totals" section, and various options under "Totals". For this example we will choose data elements from Grandparents Characteristics by age.
The State Program Reports (SPR) page. The "Stratifiers" link is chosen in the group of links below the heading. Next, I will click on the Stratifiers link to continue building the table. The stratifiers screen shows all possible stratifiers, if available, for the selected data elements.
The State Program Reports (SPR) page. On the "Stratifiers" page, the cursor moves to select the "All Age Groups" option. For this example we will select all age groups to use as statifiers.
The State Program Reports (SPR) page. The "Geography" link is chosen in the group of links below the heading. Next, we will move to the Geography section.
The State Program Reports (SPR) page. On the "Geography" page, the cursor moves through and expands some of the lists under the options and selects some states. Use the triangle to see individual geographies within a group. To select all geographies within a group, use the check box beside the group name. For this example, I will select a few states.
The State Program Reports (SPR) page. The "Display Table" link is chosen in the group of links below the heading. Finally, produce a table by clicking on the Display Table link.
The State Program Reports (SPR) page in the "Display Table" page. The table is being navigated by clicking on the arrows below the table to see more data. Use the arrows below the table to scroll through the pages of data.
The State Program Reports (SPR) page. On the "Display Table" page, the page size is changed at the bottom of the table to change the number of records per page. Change the number of records per page using the Page Size drop-down list.
The State Program Reports (SPR) page in the "Display Table" page. The first column, "Year", table head is right clicked to display grouping and sorting options for the table. The "Sort Descending" option is chosen. Right click on a column head to access additional options such as sorting and grouping. For this example I will sort year in descending order.
The State Program Reports (SPR) page in the "Display Table" page. The first column, "Year", table head is right clicked to display grouping and sorting options for the table. The "Group By" option is chosen. Use the 'Group By' option to group a column by its values.
The State Program Reports (SPR) page in the "Display Table" page. The "Restore Defaults" link at the top of the table is chosen. Use the restore defaults command to return the table to its original state.
The State Program Reports (SPR) page in the "Display Table" page. The right most column is right clicked on to display the sorting list. The "Columns" option is chosen which expands to show which columns are displayed. The cursor then unchecks some of the columns. To remove columns from the display, right click on any column and choose the Columns menu. From there, un-check the unwanted columns.
The State Program Reports (SPR) page in the "Display Table" page. The "Save" link in the top above the first heading. The "Save" link expands to show "Excel" and "C S V" links. Use the Save menu to export the table to Excel or to a comma separated file.
The State Program Reports (SPR) page. This concludes the Custom Tables tutorial on the basic steps for creating a table.