1 / 38

Working with data for mental health court practitioners Part One: Data collection manipulation

2. Today's Presentation. 2. Develop strategic perspective on data collectionLearn practical approaches for implementing data collection in a MHCLearn concrete skills for working with data in Microsoft Excel. Learning Objectives. 3. Why collect Mental Health Court data?.

asis
Download Presentation

Working with data for mental health court practitioners Part One: Data collection manipulation

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. Working with data for mental health court practitioners Part One: Data collection & manipulation 1

    2. 2 Today’s Presentation

    3. Develop strategic perspective on data collection Learn practical approaches for implementing data collection in a MHC Learn concrete skills for working with data in Microsoft Excel Learning Objectives 3

    4. Why collect Mental Health Court data? “Data are collected and analyzed to demonstrate the impact of the mental health court, its performance is assessed periodically (and procedures are modified accordingly), court processes are institutionalized, and support for the court in the community is cultivated and expanded” “Element 10: Sustainability,” Essential Elements of a Mental Health Court

    5. Content

    6. Collecting Mental Health Court Data Useful fields to capture data: What’s most important Client Demographics Last Name and First Name (divided into separate fields) Gender Date of Birth Social Security Number Race and Ethnicity Criminal Justice Identification Number Administrative Data about Your Program Referrals and from where Assessment (by a Case Manager, or Psychiatrist, note date and person conducting assessment) Assessment and/or Report Findings and MH Diagnosis Acceptances (include date, month and day) Rejections (include date and reasons why)

    7. Collecting Mental Health Court Data Useful fields to capture data : What’s most important (continued) Client Criminal Justice and Mental Health Information Prior Arrests Hospitalizations (while in program) Warrants (while in program) Re-arrests (while in program) Program Placement (name and type – outpatient, residential, etc.) Program Entry and Exit Dates Graduation and Termination Information (including, dates and reasons for termination) Ensuring Data Consistency Standardized Coding and Drop-Down Menus vs. Free-Form Entry Code-Books

    8. Collecting Mental Health Court Data

    9. 9

    10. Collecting Mental Health Court Data Capturing qualitative data elements Case Studies Symptom Inventories Building team processes to collect data: whose entering all of this data anyway? Court or Program Personnel Externs/Interns or Volunteers Training on data collection and data entry Case Notes & Qualitative Notations vs. Database Entry Missing data: if it’s missing did it even exist in the first place?

    11. Collecting Mental Health Court Data Take-Aways Planning Sessions with key stakeholders Breakdown data into content areas Client Demographics Administrative/Programmatic Data Client Criminal Justice and/or Mental Health Information Process implementation with program staff Who is collecting the data? When is the data being collected? Where is the data being inputted?

    12. Working with Data in Excel Discussion of functions Functions will be listed here. Use the webinar to understand how the function can be used, and remember you can always look up the individual steps by Googling the function name, using Help, or reviewing the webinar Follow along on your own computer, if you can, using the dummy dataset Where we show you something in Excel 2003, we will also mention where the function exists in Excel 2007 Likely similar functions for other spreadsheet programs- now that you know it exists, you can look for it

    13. Working with Data in Excel Tools to sort data Single criterion Two criteria Tools to filter data Tools to analyze data Sum Min/Max Average Number of Days Between Dates Pivot Tables

    14. Working with Data in Excel: Know the “Menu” and Other Basics

    15. Working with Data in Excel: Know the “Menu” and Other Basics

    16. Working with Data in Excel: Important Menu Choices – “Tools”

    17. Working with Data in Excel: Important Menu Choices – “Tools” (con’t.)

    18. Working with Data in Excel: Important Menu Choices – “Data”

    19. Working with Data in Excel: Example Dataset

    20. Working with Data in Excel: Sorting Data

    21. Working with Data in Excel: Sorting Data – Single Criterion

    22. Working with Data in Excel: Sorting Data – Multiple Criteria

    23. Working with Data in Excel: Filtering Data

    24. Working with Data in Excel: Filtering Data (con’t.)

    25. Working with Data in Excel: Filtering Data (con’t.)

    26. Working with Data in Excel: Calculating Summary Stats – Sum

    27. Working with Data in Excel: Calculating Summary Stats – Sum (con’t.)

    28. Working with Data in Excel: Calculating Summary Stats – Average

    29. Working with Data in Excel: Span of Days Between Dates

    30. Working with Data in Excel: Pivot Tables

    31. Working with Data in Excel: Pivot Tables (con’t.)

    32. Working with Data in Excel: Pivot Tables (con’t.)

    33. Working with Data in Excel: Pivot Tables (con’t.)

    34. Working with Data in Excel: Pivot Tables (con’t.)

    35. Working with Data in Excel: Pivot Tables (con’t.)

    36. Working with Data in Excel: Pivot Tables (con’t.)

    37. Working with Data in Excel: Pivot Tables (con’t.)

    38. Resources A Guide to Collecting Mental Health Court Outcome Data, available online at: http://www.consensusproject.org/jc_publications/guide-to-collecting-mental-health-court-outcome-data/MHC-Outcome-Data.pdf Improving Responses to People with Mental Illnesses: The Essential Elements of a Mental Health Court, available online at: http://www.consensusproject.org/jc_publications/essential-elements-of-a-mental-health-court/mhc-essential-elements.pdf Mental Health Courts: A Guide to Research-Informed Guide Policy and Practice, available online at: http://www.consensusproject.org/jc_publications/mental-health-courts-a-guide-to-research-informed-policy-and-practice/Mental_Health_Court_Research_Guide.pdf The webinar recording and PowerPoint presentation will be available on www.consensusproject.org within a few days.

    39. Thank you Join us next time for: Working with data for mental health court practitioners Part Two: Data evaluation & communication Questions? Comments? Please contact: Hallie Fader-Towe Hfader@csg.org This material was developed by presenter for this webinar. Presentations are not externally reviewed for form or content and as such, the statements within reflect the views of the authors and should not be considered the official position of the Bureau of Justice Assistance, Justice Center, the members of the Council of State Governments, or funding agencies supporting the work.

More Related