ncsesdata.nsf.gov – WebCASPAR|Tutorial for Single Data Source Tables – US National Science Foundation (NSF)
Skip to Content

Creating a Table from a Single Data Source

Skip page help
Page Help

The minimum selection requirements for a complete WebCASPAR table are one data source, one analysis variable, and one classification variable. (By default, WebCASPAR includes Year as a classification variable.) The following task tutorial presents a scenario in which a user creates a WebCASPAR table containing data using a single data source (NSF Survey of Research and Development Expenditures at Universities and Colleges/Higher Education Research and Development Survey), two analysis variables (Total R&D Expenditures in All Fields and Federally Financed R&D Expenditures in All Fields), and two classification variables (the most recent 10 years and Academic Discipline, Detailed).

Select a Data Source

You will select your data source from the options available on the WebCASPAR Home screen.

Modify Analysis Variables

You will select two analysis variables for inclusion in this table. The variables will appear in the table in the order in which they are selected.

Modify Classification Variables

The only classification variables available will be those applicable to the data source and analysis variables that you selected. By default, WebCASPAR selects Year as a required classification variable. The variables will appear in the table in the order in which they are selected.

Change Value Selections for Classification Variables

Each classification variable has a default set of values associated with it. You can add or remove values to create a custom specification using the Modify Classification Variables screen. For this exercise, you will change the value for Year from the default setting, “Most recent year,” to “10 most recent years.”

Change the Position of Classification Variables

By default, WebCASPAR displays classification variables in table rows. You can change a classification variable’s position in the table by selecting one of the options in the Display section.

Display the Totals for Classification Variables in the Table

You can choose to include the totals for the selected classification variables in the table. The default selection for Include Total is “No” for Year and “Yes” for all other classification variables.

Format the Table

You can change the arrangement of elements within the table on the Format Output Table screen. You can change the order and row, column, and heading positions of analysis and classification variables; change the output format of the table; and change the number of rows and columns that appear in the table in the browser view.

View the Table

Export Table to Another Format

WebCASPAR lets you export tables into several file formats. In this exercise, you will export the WebCASPAR table into a formatted Microsoft (MS) Excel file.

E-Mail the Table Link

WebCASPAR allows you to e-mail a link to the table that you generated to a third party, using the E-mail Table Link function.

Save the Table

If you are a registered user, WebCASPAR allows you to save the data source and variables that you selected on the Table Builder screen as a single table specification. Saving your selections as a single table specification allows you to easily retrieve the table at a later date, rather than recreating it.

Back to top