1 / 25

The DataDude

The DataDude is a simple program that allows you to download and summarize reports from the UCB CWS/CMS reports website, as well as graph the data. It is a helpful tool for researchers in the field of child welfare.

dustinl
Download Presentation

The DataDude

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. The DataDude A Simple Program to Simplify Your Life Child Welfare Research Center Center for Social Services Research University of California, Berkeley Barbara Needell, Principal Investigator – California Children’s Services Archive Bill Dawson, Associate Research Specialist Colleen Henry, MSWStudent Research Assistant Wendy Piccus, Children’s Archive Research Assistant Daniel Webster, Research Specialist

  2. What is the DataDude? An Excel file that allows you to: • Download a series of reports from the UCB CWS/CMS reports website • Summarize selected information in a form suitable for review and or graphing • Graph the data

  3. Downloading a Series of Reports from the UCB CWS/CMS Reports Website The DataDude allows you to: Download a series of reports (i.e.,all available time periods) for a CWS/CMS report of your choosing

  4. Download a Series of Reports from the UCB CWS/CMS Reports Website in 3 Steps:

  5. Results: The DataDude Downloads a Series of Reports to an Excel Workbook

  6. The DataDude allows you to: Summarize selected information in a form suitable for review and or graphing Examine All Time Periods for a CWS/CMS Report On One Easy To Read Excel Worksheet Reviewing and Summarizing Data Across Periods of Time

  7. Review and Summarize Data Across Periods of Time in 4 Steps:

  8. Summarize Data in One Table

  9. Results: Summarize Data from All Points in Time to One Table

  10. Review Data

  11. Graphing Data MS Excel allows you to: • Take the data that you have summarized using the DataDude and create a graph

  12. Graph Data: Select Time Periods & Rows

  13. Select the MS Excel Graphing Wizard:

  14. How Do I Get My Own Copy of the DataDude? 1. Go to: http://cssr.berkeley.edu/datadude 2. Right-Click “DataDude Tool*” 3. Choose the “Save Target As” Option 4. Save the DataDude to a location on your computer 5. Open the DataDude

  15. Potential Problems with Downloading your own version of the DataDude • Wrong Version of MS Excel • Unable to Enable Macros: Security Settings • Formatting

  16. Wrong version of MS Excel • Although resources have not allowed extensive testing, the DataDude should operate on all versions of MS Windows 95 and above and all versions of MS Excel 2000 and above.

  17. Unable to Enable Macros

  18. Troubleshooting What if I have a summary table where the columns do not have the same titles? • If a column in a summary table has an incorrect title, this indicates that the source worksheet has a different layout or different number of columns than others in the series. • Identify the problem time period by the date indicated for the column in the first row. • Either remove the time period from the summary table by deleting the column or replace it with the correct column by manually copying the correct column into the summary table (and replacing the incorrect data).

  19. Troubleshooting (continued) What if I have a summary table where the rows don’t line up or where it seems like there are missing rows? • Ensure that data columns are aligned at the top. In some cases, slight variations in page layout will result in columns in your summary table having different start rows for the data. Correct by cutting and pasting the problem columns so that they are top aligned with others in the table. • If a column is missing rows, refer to the source worksheet. Determine which row(s) are missing. Cut and paste the appropriate portions of the column on the summary sheet to correct the problem

  20. Troubleshooting (continued) If you have difficulty determining which row(s) are missing for which time periods: • Create a summary table for column A. This will create a table containing the row headings from each of your source worksheets. • Examine this summary and determine which worksheets are missing which row headings. • Adjust the data summary table by cutting and pasting the appropriate portions of the column.

  21. For More Information Contact datadudehelp@lists.berkeley.edu or go to http://cssr.berkeley.edu/datadude

More Related