1 / 8

Using the Interview Tracking Workbooks

Using the Interview Tracking Workbooks. The Interview Tracking Workbook. Interview_Tracking_Form.xls is the tool used to enter the Interview Tracking Form. The workbook contains 3 different spreadsheets: Instructions Enter Information Data Entry Example.

maine
Download Presentation

Using the Interview Tracking Workbooks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using the Interview Tracking Workbooks

  2. The Interview Tracking Workbook • Interview_Tracking_Form.xls is the tool used to enter the Interview Tracking Form. • The workbook contains 3 different spreadsheets: • Instructions • Enter Information • Data Entry Example

  3. Purpose of the Interview Tracking Workbook • The Interview Tracking Form Workbook is used to • enter the Interview Tracking Form and • format the data entered for Epi Info.

  4. Using the Interview Tracking Workbook • The data from the Interview Tracking Form is entered into the Enter Information spreadsheet. • The values for the Interview Tracking Form are detailed on the bottom of the Interview Tracking Form used by the Data Collection Team.

  5. Data Entry Example Values entered as y/n Values are entered as an X

  6. Formatting the Data For Epi Info • Once data collection has been completed and all the Interview Tracking Forms have been entered the data needs to be formatted for Epi Info. • To Format the data click on the button on the Instructions spreadsheet. • A macro will be activated that will create a new spreadsheet called Epi Info.

  7. Epi Info Spreadsheet The spreadsheet looks almost identical to the Enter Information spreadsheet, only the labels for the columns have changed (to be compatible with Epi Info).

  8. Importing into Database • Once data collection and data entry are complete you can create your STEPS database. • The STEPS database has automated programmes that perform a variety of functions, including importing the information from the Interview Tracking Spreadsheet into the database.

More Related