Skip Navigation U.S. Department of Health and Human Services www.hhs.gov
Agency for Healthcare Research Quality www.ahrq.gov
Archive print banner
Administrator's Guide

Public Health Emergency Preparedness

This resource was part of AHRQ's Public Health Emergency Preparedness program, which was discontinued on June 30, 2011, in a realignment of Federal efforts.

This information is for reference purposes only. It was current when produced and may now be outdated. Archive material is no longer maintained, and some links may not work. Persons with disabilities having difficulty accessing this information should contact us at: https://info.ahrq.gov. Let us know the nature of the problem, the Web address of what you want, and your contact information.

Please go to www.ahrq.gov for current information.

2.3.  How to Download and Import Data

The individual who is responsible for downloading and analyzing the data may be either the Questionnaire Administrator or a data analyst. For convenience, we will use the term "analyst" here. 

A screen shot shows the instruction screen for the Questionnaire for Health Care Facilities, Survey Response Summary Report.  The site menu in the left-hand margin of the screen lists the following items: 'Home,' 'Change Password,' 'Download Data,' and 'Log Out.'  Download Data is circled to indicate selection. The Survey Response Summary Report is a table containing three attributes: Organization, State, POC (point of contact) E-mail.

There are two distinct steps associated with downloading and importing data. First, the data must be downloaded from the Web site onto the analyst's hard drive. 

Second, that downloaded data must be imported into a tool for analysis. The downloaded questionnaire response data can be imported into three tools. These include Microsoft® (MS) Excel, MS Access, or various statistical analysis packages, such as SPSS®. Because of the large amount of data collected from the questionnaire, MS Excel and MS Access will not accommodate the data export in one file; the analyst will need to import the data into two separate files. Most statistical packages, including SPSS, will accept the volume of data in one file. Instructions for these three options are included in the sections below. For those using a statistical analysis package, we provide import instructions only for SPSS, which is one of the most common analysis packages. If another analysis package will be used, the analyst should consult the help function of that tool for instructions on importing data.

2.3.1.  Downloading and Importing Data into MS Excel

As described above, the large volume of data will not import into one Excel spreadsheet. For that reason, the data is divided into two comma separated values (.csv) files. To use MS Excel, simply select "Download Data Part 1," and save the .csv file to your hard drive. This file will contain data for the unique ID number, all the demographic questions, and questionnaire questions 1 through 20. To view and manipulate this data in MS Excel, double click the .csv file, and it will open in MS Excel. Next, select "Download Data Part 2," and save the .csv file to your hard drive. Open the saved .csv file in MS Excel. The file will provide the data for the unique ID number and questionnaire questions 21 through 43.

A screen shot shows the instruction screen for the Questionnaire for Health Care Facilities, Survey Response Summary Report. The site menu in the left-hand margin of the screen lists the following items: 'Home,' 'Change Password,' 'Download Data Part 1,' 'Download Data Part 2,' and 'Log Out.'  Download Data Parts 1 and 2 are circled with black arrows pointing to them to indicate selection. Download Data Part 1 is labeled 'For demographics and survey questions 1-20', and Download Data Part 2 is  labeled 'For survey ID and survey questions 21-43.'

Return to Contents
Proceed to Next Section

The information on this page is archived and provided for reference purposes only.

 

AHRQ Advancing Excellence in Health Care