Skip Navigation Links
General
System Overview
 
Options
The Home page
Select a question
View and modify a table
Content Area

HEALTHY YOUTH: YOUTH ONLINE

Viewing and modifying table information

Introduction

When you select options for displaying data, the system displays the data in a table. To sort data by a specific column, click the following graphic next to the specific column heading.

You can access a table by doing one of the following:

  • On the Youth Online home page, select a survey (high school or middle school) and select a location.
  • On the Youth Online home page, select a health topic and select a question from the Questions page.

You can choose to view data in table or graph format.

Selecting a question(s), location(s), and year(s)

Modifying content to display in a table

Viewing Data

 

Selecting a question(s), location(s), and year(s)

Use the Choose Table Content section at the top of the page to select the question (one or all), location(s), or year(s) for which to display responses. You can use this section to do the following in several different combinations:

Selecting Table Content

Screenshot of Choose Table Content section

To select table content for one location:

  1. To select a question, do one of the following:
    • To view responses for all questions, select All Questions.
    • To view responses for a specific question, click the Question dropdown list. The system expands the list to show the question categories.
      Screenshot of Questions dropdown.
    • Click the arrow next to the desired category, for example, Unintentional Injuries and Violence. The system displays the questions for the category.
      Screenshot of Questions list expanded.
    • Select the desired question, for example, Wore seat belt.

  2. Select a location from the Location dropdown list, for example Georgia.

  3. Select a year from the Year dropdown list.

  4. Click GO. The system displays information in the table based on the options selected in the Choose Table Content section.
    Notes:
    The system auto-populates the Year field with the latest year for which data is available for the selected state. When viewing just one question by one location, you can also choose to view all years (in rows).
    The Map tab is disabled and available only when viewing All Locations for one question and one year.

    Screenshot of one location one year

Viewing two locations and/or two years:

  1. Click the View two locations link on the right hand side of the Choose Table Content section. The system displays the fields for viewing 2 Locations and 2 Years.
    Sreeenshot of select locations

  2. Select a location from the Location 1 dropdown list.
    Note: To select a location, click on the desired Location dropdown list and select either All Locations, United States, or click on a specific category, for example States, to select from the category.

    Screenshot of explanded location list.

  3. Select a location from the Location 2 dropdown list.
    Note: To view two years for the same location, select the same location in Location 1 and Location 2 dropdown lists.
  4. Select a year from the Year 1 dropdown list and a year from the Year 2 dropdown list.
  5. Click GO. The system displays information on the page based on the options selected.
    Note: To remove a previously selected location, click the Remove Location/Year 2 link.

Screenshot of two locations, two years.

Viewing all locations for one year and one question:

  1. In the Question drop down, select the desired question.
  2. n the Location drop down, select All Locations.
  3. In the Year drop down, select the desired year.
  4. Click GO. Note that the system displays the data in Table, Graph, and Map formats. The Map tab is available only if you select one question, all locations, and one year.

    Screenshot for all locations, one year, one question with map tab.

 

Viewing all questions

Viewing all questions for one location:

  1. Select All Questions from the Question dropdown list.
  2. Select a location from the Location 1 dropdown list.
  3. Select a year from the Year dropdown list or select All Years.
  4. Click GO. The system displays information on the page based on the options selected.
    Note: All questions are displayed under the Question column. Each category has the associated questions displayed under it.

Screenshot for all questions one location.

 

Viewing all questions for two locations:

  1. Select All Questions from the Question dropdown list.
  2. Select a location from the Location 1 dropdown list.
  3. Select a year from the Year 1 dropdown list.
  4. Select a location the Location 2 dropdown list.
  5. Select a year from the Year 2 dropdown list.
  6. Click GO. The system displays information on the page based on the options selected.
    Note: All questions are displaed under the Question column. Each category has the associated questions displayed under it.

Screenshot of all questions, two locations.

Viewing all years:

Viewing all years, all questions for one location

  1. Select all questions from the Question dropdown list.
  2. Select All Years in the Years dropdown list or click the View All Years link.
  3. Click GO. For the available years, the system displays the questions for the selected location.

Screenshot of all questions, all years, one location.

Viewing all years, one question, for all locations:

  1. Select one question from the Question dropdown list.
  2. Select All Locations in the Locations dropdown list.
  3. Select All Years in the Years dropdown list.
  4. Click GO. The system displays data for all the available years and all locations.

Screenshot of all questions, all years, one location.

Modifying content to display in a table

 

Changing column by-variable

You can choose to display a table using the following column variables:

  • Sex (default)
  • Grade
  • Race/Ethnicity
  • Totals only
  • Sexual Orientation (Sexual Identity, Sex of Sexual Contacts)

 

Stratifying a table:

Note: When viewing one question for all locations you can stratify the information displayed by only one column. If you want to further stratify the information displayed by choosing additional row variables, then you must select only one question and one location.

  1. Under the Choose Table Content section, select the desired question from the Question dropdown list.
  2. In the Location dropdown list, select All Locations.
  3. In the Year dropdown list, select the desired year and click GO. The system displays the table based on the options selected.

    Screenshot of stratifying table

  4. Under the View Data by Demographics section, select the column variable to use for stratifying the information displayed, for example, Grade and click GO. The system displays the information according to the selected column variable.

    Screenshot of stratify by grade
  5. After displaying the desired columns, you can proceed to do the following.

Stratifying a table further

When viewing one question for one location, you can further stratify the information displayed by choosing additional row variables. After selecting a question/location

  1. Under the Choose Table Content section, select the desired question from the Question dropdown list.
  2. In the Location dropdown list, select the desired location.
  3. In the Year dropdown list, select the desired year and click GO. The system displays the table based on the options selected.
  4. Under the View Data by Demographics section, select the desired variable, for example, Sex from the Column V dropdown list and click GO. The system displays options for selecting row variables.
  5. Select a row variable, for example, Grade from the Row Variable 1 dropdown list. You may click GO or proceed to step 3 and select another row variable.
  6. If desired, select a row variable for example, Race from the Row Variable 2 dropdown list and click GO. The system displays the table based on the variable selected.

    Screenshot of stratification



  7. After displaying the desired columns, you can proceed to do the following.

 

Managing display options

You can choose display options using the Table Display Options located above the table.

Screenshot of Display Options

Selecting display options:

  1. In the Decimal Place field, select the decimal place to use for numbers. For example, the number 34.75 will be displayed as:
    • 34 if you select 0
    • 34.7 if you select 1
    • 34.75 if you select 2
  2. In the Variance field, select a variance to be displayed. The options are as follows:

    • 95% Confidence Intervals -
    • Standard Error -
    • None -
  3. in the Display Cell Size field, select yes if you want the system to display the cell size or No if you want the information hidden.
  4. In the Question Direction field, indicate by selecting Greater Risk if you want data displayed by greater risk or select Less Risk if you want data displayed by less risk. The system displays the data based on the options selected.
  5. Click GO.

Screenshot of stratification

Viewing differences between two data points using T-tests

After choosing the column and variable rows to display as described in Changing column by-variable, you can proceed to compare any two variables on a table.

To compare column variables:

  1. Select the two variables to compare by selecting the checkboxes at the top of each variable.

    Screenshot of compare checkboxes selected
  2. Click the Compare Two button. The system displays comparison data for the two variables being compared and uses gray dots to depict comparison information.
    Note: The system displays dots under the columns to indicate the results T-test. You can choose to display the p-value by selecting Yes in the Show p-value field.
    When stratified by either Sexual Identity or Sex of Sexual Contacts, “Gay or lesbian” cannot be compared to “Gay, lesbian or bisexual” and “Bisexual” cannot be compared to “Gay, lesbian or bisexual”.

    Screenshot of Compare

  3. After comparing the variables, you can proceed to do the following:

Viewing response details

You can select a question and view the response details for the question.

To view a question:

  1. Click on the desired question. The system displays the responses for the question.

    Screenshot of compare checkboxes selected
  2. Click on the desired response. The system displays the response details.

    Screenshot of response detail
  3. After viewing response details, you can proceed to do the following:

 

Filtering data

Use the section on the left hand side of the page to filter the data that is displayed in a table. The options displayed in this section may vary depending on the type of information that is displayed in the table. For example, if viewing data for all locations for all years, the system displays the following subsections in the Filter Data section:

  • Locations
  • Sex
  • Race/Ethnicity
  • Grade
  • Sexual Orientation (Sexual Identity, Sex of Sexual Contacts)

The options under each subsection can be displayed as checkboxes or radio buttons as seen in the examples below.

When options are displayed as checkboxes, you can select one, multiple, or all the options. Options displayed as checkboxes work in a "show/hide" manner. If an option is selected, it displays in the table. For example, if under Locations you select Display all locations, the system displays all the available locations. If you choose to display only States and Territory, the system hides all other locations; the data displayed does not change.

Example of options displayed as checkboxes

Screenshot of checkboxes

Example of options displayed as radio buttons

When options are displayed as radio buttons, you can select one or all the available options. Unlike checkboxes where the system simply shows and hides data, the system recalculates data on a table each time you change the options.

Screenshot of radio buttons

It is important to remember that an option displayed as checkboxes on one table may be displayed as radio buttons on another table.

To clear all the filters you have selected, click the Remove All Filters filters link at the bottom of the Filter Data section.

The Slider

When you select to view data by all years, a slider appears at the top of the Filter Data section to show you the range of years for which data is being displayed. The range of years is represented at the top of the slider. This is the number of years for which data is displayed in the table. In the example below, the range of years represented is 1991-2015.

Screenshot of the slider.

You can use the slider to change the range of years displayed in a table by moving the left or right slider. Move the left slider to change the starting year or move the right slider to change the ending year, as seen in the example below.

Screenshot of slider.

 

Footnotes

The Footnotes section at the bottom of the page provides more information for the content displayed on the page. The Footnotes section explains the symbols displayed in a table. In the graphic displayed below, the — in a cell in the table indicates that data is not available for that particular entity.

Screenshot of Footnotes section

Viewing Data

Viewing and Printing a table

After choosing table content, i.e. Question, Location(s) and Year(s), you can view summary data in table format (default view). To sort the data displayed in a table, simply click on a column heading, e.g. Location, Total, Female, Male, etc.

Screenshot of table view and sort.

To print a table:

  1. While viewing the table you want to print, click the Print Table link. The system displays a standard Print dialog box.


  2. Use the standard Print dialog box to complete the printing process.

Viewing and printing a graph

Information presented in a table is also depicted in a graph. To view a graph, click on the Graph tab. The system displays a graphical representation for every response or location displayed in the table. If there are a large number or responses, the page can get rather long so be sure to scroll down the page to view all the graphs on the page. The question is displayed at the top of the graph and the legend explaining information displayed in the graph is displayed under the question. Just as in a table, you can use the options available in Choose Table Content or View Data by Demographics sections to determine that data displayed in the graph.

Screenshot of graph.

To print a graph:

  1. While viewing the graph(s) you want to print, click the Print Graph link. The system displays a standard Print dialog box.


  2. Use the standard Print dialog box to complete the printing process.

Viewing and printing a map

The system displays data in map format only if you select one question, all locations and one year. When data is available in this format, the system enables the Map tab. To view data for a location on the map, hover your cursor above the state. The system displays the percentage, confidence interval, and the cell size for the data point.

Screenshot of map for all locations, one year, one question.

To print a map:

  1. While viewing the map you want to print, click the Print Map link. The system displays a standard Print dialog box.


  2. Use the standard Print dialog box to complete the printing process.


Top of Page |