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

Creating a Table from Multiple Data Sources

Skip page help
Page Help

The following task tutorial presents a scenario in which a user creates a WebCASPAR table using multiple data sources: Total R&D Expenditures in All Fields (from the NSF Survey of Research and Development Expenditures at Universities and Colleges/Higher Education Research and Development Survey) and Number of Graduate Students (from the NSF-NIH Survey of Graduate Students & Postdoctorates in Science and Engineering); broad Academic Discipline (all values); and Academic Institution (public, doctorate-granting institutions in the District of Columbia, Maryland, and Virginia, including total).

Modify Analysis Variables

For this exercise, you will select variables from multiple data sources using the Add analysis variable(s) dropdown list on the Modify Analysis Variables screen.


Modify Classification Variables

The only available classification variables will be those applicable to the selected analysis variables. By default, WebCASPAR selects Year as a required classification variable.


Selecting Additional Classification Variables

The only available classification variables will be those applicable to the selected analysis variables. 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. For this exercise you will select Academic Institution (standardized), Academic Discipline, Broad (standardized), and State as analysis variables (to go with the default variable, Year).

Change Value Selections for the Academic Institution (standardized) Classification Variable

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 Edit Classification Variable function. For this exercise, you will use the Institution Search feature to locate several specific institutions to replace the default value for Academic Institution (standardized), which is “All values.”

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.

Select State as a Classification Variable

Format the Table

The Format Output Table screen allows you to change the visual arrangement of elements within the table. 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

You have made the necessary selections to generate a WebCASPAR table. The minimum selection requirements for a complete table are one data source, one analysis variable, and one classification variable.

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