Safe n' Sound Safe n' Sound

Instructions for downloading data to Excel

The data collected by the program can be downloaded into an Excel sheet by following the steps below.

1. Shut down / Exit out of the program. This is what you should see on your screen.


2. Highlight the Safe N’ Sound (SNS) program icon (similar to the one below).

Make sure you press on SHIFT first if you are using a PC and on OPTION if you are using a MAC (for around 5-10 seconds), and then Double Click on the highlighted program icon while holding the SHIFT or OPTION key. Keep the SHIFT or OPTION key held down even after you Double Click on the program icon. The following window will appear and you might think that the procedure did not work but it did.  



3. Hit RUN while still holding the SHIFT or OPTION key down. Keep the SHIFT or OPTION key held down after hitting RUN until the following program icon appears at the bottom of the screen.

Click on the icon. This will bring up the following data extraction page. Your name might appear in the Account Name box.


Enter “tipadmin” for both the Account name and password and hit OK.




4. Once you  type in admin for both username and password, hit OK. The following screen should appear, asking if you would like to remove the doctor’s page from the printout.  If you would like to have the option doctor printout then mark include. If you do not want the optional printout mark exclude.


5. Locate the Tab ‘File’ at the top left (or ‘Script’ if you are using a MAC) of the computer screen. Hit ‘File’ and Scroll down to ‘Export Records’ (or ‘Export Script’ if using a MAC) and Select it.


6. The following screen (a pop-up window) will appear, asking you to choose where you would like to save your data. If you want to save the data on a USB drive, insert a thumb drive into the computer’s USB port. You can choose to save the data on the computer where the program is hosted but we do not recommend that option. It is recommended to save the data on a device to which selected staff only has access.

Change the format of the file saved to “Excel” (.xls) and enter a name for the file, for instance, SNS data 06-06-12.  Hit ‘Save’. 


7. The program will then ask you to specify a Worksheet name, title, Subject and Author This step is optional. You can choose to fill in these cells or simply hit ‘Continue’ and proceed to the next step.


8. On the data screen, you will see two large boxes. All the variables collected by the program can be found in the right side box. Select the ones that you want to see in your Excel Data Sheet and Hit ‘Export’.

Please note that the program collects a lot of variables, some of which will not be useful. You can refer to the code book for a detailed description of the variables in the Excel Spreadsheet that we recommend or assess might be useful to you. QUESTION Q_001 to QUESTION Q_050 (excluding the variables that are labeled as ‘tailored’ or ‘copy’) are the variables that you will most likely want for program evaluation.  In addition, you will probably want to export the demographic variables in order to describe the group of parents that has used the program in that setting. It would be useful to complement these questions with demographic variables.

Use the "Field export order" to arrange the order of the fields you would like to export. The “Group by” option is not available at this time.

You can always add or remove the fields you are exporting. You can choose fields form the layout or the entire table. The programmed/saved lists include the variables that are mostly likely needed for program evaluation or analysis. If you would like to add more you always can at a later point; however the list that is programmed/stored will remain the same.



9. That was the last step. You should now be able to see the dataset where you saved it. 
Click on the USB drive (usually drive E) or the location where you chose to save your data, and make sure you see the excel data file listed and the data has been extracted.

10. The computer you’re using for SNS may not have Excel, so you might need to take the USB drive to an office computer to see the data. Also, we found that sometimes there are some issues with the cells in excel when the data is exported. If you are using excel, we suggest that you format the cell into a number and see if that displays the right format.  You might also need to “stretch” the width of the column to see all of the information.

2012 Copyright Saint Louis University. All Rights Reserved.
Designed,  Hosted, and Maintained by Image Excellence