1 / 48

Lecture 3 Databases and Human Services

Lecture 3 Databases and Human Services. Why use a Database. http://www.youtube.com/watch?v=yeVHLTkIXB8. Access Vs Excel.

channer
Download Presentation

Lecture 3 Databases and Human Services

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. Lecture 3 Databases and Human Services

  2. Why use a Database • http://www.youtube.com/watch?v=yeVHLTkIXB8

  3. Access Vs Excel • Access is a database. Excel is a spreadsheet. Both are useful to displaying data systematically, but a database is enormously more flexible. Access is a relational database, which is even more flexible than an ordinary database and permits the data to be manipulated in many ways. http://wiki.answers.com/Q/Why_would_a_company_use_Microsoft_access_instead_of_Microsoft_Excel

  4. Using Access or Excel to manage your data • Microsoft Office Access and Microsoft Office Excel possess many similarities, which can make it difficult to decide which program you should use. For example, both programs can store large amounts of data, run powerful queries and analysis tools to slice and dice that data, and perform sophisticated calculations that return the data that you need. • However, each program has clear advantages — depending on the type of data that you are managing and what you want to do with that data. For example, if it is your goal to maintain data integrity in a format that can be accessed by multiple users, Access is your best choice, whereas Excel is better suited for complex numerical data that you want to analyze in depth. • “If you store your data by using Access and analyze it by using Excel, you can gain the benefits of both programs.” • In many cases, you can use both programs, employing each for the purpose to which it is best suited. In general, Access is better for managing data: helping you keep it organized, easy to search, and available to multiple simultaneous users. Excel is generally better for analyzing data: performing complex calculations, exploring possible outcomes, and producing high quality charts. If you store your data by using Access and analyze it by using Excel, you can gain the benefits of both programs. http://office.microsoft.com/en-us/access-help/using-access-or-excel-to-manage-your-data-HA010210195.aspx

  5. Top 10 reasons to use Access with Excel • Reason 1: Copying an Excel worksheet to an Access datasheet • Reason 2: Sharing data by linking to an Excel worksheet from Access • Reason 3: Moving data by importing Excel data into Access • Reason 4: Connecting to Access data from Excel • Reason 5: Using Access reports with Excel data • Reason 6: Using Access forms with Excel data • Reason 7: Filtering, sorting, and querying in Access is so like Excel • Reason 8: Collecting data for Excel analysis by using Access • Reason 9: Doing a Mail Merge or creating labels • Reason 10: Combining Excel and Access with SharePoint technologies http://office.microsoft.com/en-us/excel-help/top-10-reasons-to-use-access-with-excel-HA010264081.aspx

  6. Database Component Game Match each part with its definition

  7. Video on Relationships • http://www.youtube.com/watch?v=NvrpuBAMddw

  8. Intro to Logic Models • What is a Logic Model? • Basically, a logic model is a systematic and visual way to present and share your understanding of the relationships among the resources you have to operate your program, the activities you plan, and the changes or results you hope to achieve. Kellog Foundation 2004:3

  9. Kellog Foundation 2004:3

  10. Types of Logic Models Theory Approach Models emphasize the theory of change that has influenced the design and plan for the program/ illustrate how and why you think your program will work/ “big picture”/ for grant proposals, planning and design Activities Approach Models emphasize linking the various planned activities together in a manner that maps the process of program implementation /for management planning activities, databases Outcomes Approach Models attempt to connect the resources and/or activities with the desired results in a workable program/ for designing effective evaluation and reporting strategies. Kellog Foundation 2004

  11. Program Planning Logic Model • Imagination Library book distribution program – one book a month to children from birth through age 5 – results demonstrated in literature • Wrap around services and role modeling of reading as delivered by local service provider agencies • Assume our community will respond as others have to the Imagination Library. • Assume funding can be raised • Assume language barriers can be overcome • Assume services offered are sufficient • 50% of children entering Syracuse City Schools are not ready according to DIBELS assessments of pre-literacy skills • Literature reviewed on Imagination library book programs shows favorable results • The Community Foundation completed a 5 year read ahead imitative building literacy capacity of local childcares and literacy providers • A coalition of stakeholders including learners, business, government, nonprofits and institutions of higher education have committed to the value of literacy for the community’s future prosperity • ↑ number of adults who read to their children daily • ↑ percent of children that register on time for kindergarten • ↑ the % of children assessed as ready on the Initial Sound Fluency • ↑ % of kids assessed as ready on Letter Naming Fluency • Increased literacy and school success reaching post school into career and a revitalized economy • Assets: • The Say Yes initiative has been launched to provide a pipeline from k through college but children begin unprepared for kindergarten • Needs: • The community has to focus on preparing children to take advantage of the many resources we have from school age on

  12. Program Implementation Logic Model • PR group to outreach to and enroll families • Database system and mailing and book return system • Nonprofits serving families with youth • Assessment team • Book sign up outreach and PR • Local organizations referring children • Book database and mailing system managed • Wrap around services coordinated • Ongoing assessment and reflective evaluation • # of children enrolled match or exceed projections (20% of population by end of year 1, 40% year 2, 60% year 3, 100% year 4) • # of local organizations referring children (7 or more) • Database and address updates minimize # of returned books (0 books returned from same address more than once) • # of children & families attending/ receiving wrap around services – particularly higher need families (half of all children enrolled) • Ongoing reflective use of dashboard to refine program implementation (monthly dashboard created) • 1-3 year • ↑ number of adults who read to their children daily • ↑ percent of children that register on time for kindergarten • 4-6 year • ↑ the % of children assessed as ready for school on the Initial Sound Fluency DIBELS • ↑ % of kids assessed as ready for school on Letter Naming Fluency DIBELS • Increased literacy and school success reaching post school into career and a revitalized economy • Increased community literacy across the lifespan • Maximized community engagement

  13. 1. # of children enrolled • # of local organizations referring children • Database and address updates • # of children & families attending/ receiving wrap around services 1. to demonstrate how experience can inform learning Partner Agencies Children Enrolled 2. to create a supervised context for students to be social scientists, professionals and citizens • 2. ↑ number of adults who read to their children daily • ↑ percent of children that register on time for kindergarten Distributing Books Books Events • 3. ↑ the % of children assessed as ready for school on the Initial Sound Fluency DIBELS • ↑ % of kids assessed as ready for school on Letter Naming Fluency DIBELS 3. to provide a context for integration of the accumulation of knowledge through the curriculum as a whole and application of that knowledge to job-related settings

  14. Literacy Coalition of Onondaga County Imagination Library Dashboard July 10 ,2010 Space reserved for Pre and post test – read to child daily

  15. 1. to demonstrate how experience can inform learning 1. evaluated through student feedback on field placement Faculty Students 2. to create a supervised context for students to be social scientists, professionals and citizens 2. evaluated by site supervisor evaluation of student work Internships Site Supervisors 3. to provide a context for integration of the accumulation of knowledge through the curriculum as a whole and application of that knowledge to job-related settings Site 3. evaluated through student journals and final paper graded by professor

  16. 1. to demonstrate how experience can inform learning 1. evaluated through student feedback on field placement Faculty Students 2. to create a supervised context for students to be social scientists, professionals and citizens 2. evaluated by site supervisor evaluation of student work Internships Site Supervisors 3. to provide a context for integration of the accumulation of knowledge through the curriculum as a whole and application of that knowledge to job-related settings Site 3. evaluated through student journals and final paper graded by professor

  17. Relationships • Types of Relationships • one to one • one to many • many to many (multiple one to many)

  18. Present your ER diagrams Let’s work on them!

  19. Before we make the E-R diagram, it is important to review the process of completing the logic model.

  20. What is a Logic Model? • Wandersman and Linney (1991) describe the logic model as: • a logical series of statements • linking a condition(s) in the community, • The activities that will be employed to address a specific • condition, short term outcomes resulting from activities • and the long term impacts likely to occur as multiple • outcomes are achieved. • Thus the logic model provides a simple means of presenting a program and establishing process and outcome goals (Julian et al., 1995; Kumpfer • et al., 1993; Wandersman & Linney, 1991). The utilization of the logic model as a system level planning and evaluation device David A. Julian  , *United Way of Franklin County, U.S.A. Available online 10 June 1998. Evaluation and Program Planning Volume 20, Issue 3 , August 1997, Pages 251-257 http://0-www.sciencedirect.com.library.lemoyne.edu/science?_ob=ArticleURL&_udi=B6V7V-3SX0MC6-2&_user=735929&_handle=B-WA-A-W-AY-MsSAYZW-UUA-AAUDEZCWAA-AAUCCVZUAA-YVDVBVZVY-AY-U&_fmt=full&_coverDate=08%2F31%2F1997&_rdoc=2&_orig=browse&_srch=%23toc%235852%231997%23999799996%2312753!&_cdi=5852&view=c&_acct=C000040778&_version=1&_urlVersion=0&_userid=735929&md5=74e18c88c11484c288e50075705c7f03

  21. Welch and Comer p. 9 Independent and Dependent Variables are implicit in Logic Models IV   DV http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6V7V-3WR4K4M-8&_user=735929&_handle=B-WA-A-W-AV-MsSAYZW-UUW-AAUDUAADDV-AAUVCEWCDV-YBACCWCBC-AV-U&_fmt=full&_coverDate=06%2F30%2F1999&_rdoc=8&_orig=browse&_srch=%23toc%235852%231999%23999779998%23102970!&_cdi=5852&view=c&_acct=C000040778&_version=1&_urlVersion=0&_userid=735929&md5=6e6b6f92758532f01a88230d7ec29380

  22. IV  DV • Each Line/Arrow  is a hypothesized linkage of causal relationship. • Each Box is a step counted or monitored http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6V7V-3WR4K4M-8&_user=735929&_handle=B-WA-A-W-AV-MsSAYZW-UUW-AAUDUAADDV-AAUVCEWCDV-YBACCWCBC-AV-U&_fmt=full&_coverDate=06%2F30%2F1999&_rdoc=8&_orig=browse&_srch=%23toc%235852%231999%23999779998%23102970!&_cdi=5852&view=c&_acct=C000040778&_version=1&_urlVersion=0&_userid=735929&md5=6e6b6f92758532f01a88230d7ec29380

  23. Outputs are the products, goods and services provided to the programs direct customers. For example, conducting research is an activity and the reports generated for other researchers and technology developers could be thought of as outputs of the activity. Resources include human and financial resources as well as other inputs required to support the program such as partnerships. Information on customer needs is an essential resource to the program. Activities include all those action steps necessary to produce program outputs. Fig. 1. Elements of the Logic Model. http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6V7V-3WR4K4M-8&_user=735929&_handle=B-WA-A-W-AV-MsSAYZW-UUW-AAUDUAADDV-AAUVCEWCDV-YBACCWCBC-AV-U&_fmt=full&_coverDate=06%2F30%2F1999&_rdoc=8&_orig=browse&_srch=%23toc%235852%231999%23999779998%23102970!&_cdi=5852&view=c&_acct=C000040778&_version=1&_urlVersion=0&_userid=735929&md5=6e6b6f92758532f01a88230d7ec29380

  24. Customers, the users of a product or service. Outcomes are characterized as changes or benefits resulting from activities and outputs. Programs typically have multiple, sequential outcomes across the full program performance story. Fig. 1. Elements of the Logic Model. http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6V7V-3WR4K4M-8&_user=735929&_handle=B-WA-A-W-AV-MsSAYZW-UUW-AAUDUAADDV-AAUVCEWCDV-YBACCWCBC-AV-U&_fmt=full&_coverDate=06%2F30%2F1999&_rdoc=8&_orig=browse&_srch=%23toc%235852%231999%23999779998%23102970!&_cdi=5852&view=c&_acct=C000040778&_version=1&_urlVersion=0&_userid=735929&md5=6e6b6f92758532f01a88230d7ec29380

  25. short term outcomes, those changes or benefits that are most closely associated with or caused by the programs outputs intermediate outcomes, those changes that result from an application of the short term outcomes. Long term outcomes or program impacts, follow from the benefits accrued though the intermediate outcomes. Tip: List out your outcomes them put them in chronological order. Fig. 1. Elements of the Logic Model. http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6V7V-3WR4K4M-8&_user=735929&_handle=B-WA-A-W-AV-MsSAYZW-UUW-AAUDUAADDV-AAUVCEWCDV-YBACCWCBC-AV-U&_fmt=full&_coverDate=06%2F30%2F1999&_rdoc=8&_orig=browse&_srch=%23toc%235852%231999%23999779998%23102970!&_cdi=5852&view=c&_acct=C000040778&_version=1&_urlVersion=0&_userid=735929&md5=6e6b6f92758532f01a88230d7ec29380

  26. Example from reading: • results from a laboratory prototype for an energy saving technology may be a short-term outcome; the commercial scale prototype an intermediate outcome, and a cleaner environment once the technology is in use one of the desired longer term benefits or outcomes. Tip: List out your outcomes them put them in chronological order. Fig. 1. Elements of the Logic Model. http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6V7V-3WR4K4M-8&_user=735929&_handle=B-WA-A-W-AV-MsSAYZW-UUW-AAUDUAADDV-AAUVCEWCDV-YBACCWCBC-AV-U&_fmt=full&_coverDate=06%2F30%2F1999&_rdoc=8&_orig=browse&_srch=%23toc%235852%231999%23999779998%23102970!&_cdi=5852&view=c&_acct=C000040778&_version=1&_urlVersion=0&_userid=735929&md5=6e6b6f92758532f01a88230d7ec29380

  27. 3 Making an Entity-Relationship Diagram

  28. 1. to demonstrate how experience can inform learning 1. evaluated through student feedback on field placement Faculty Students 2. to create a supervised context for students to be social scientists, professionals and citizens 2. evaluated by site supervisor evaluation of student work Internships Site Supervisors 3. to provide a context for integration of the accumulation of knowledge through the curriculum as a whole and application of that knowledge to job-related settings Site 3. evaluated through student journals and final paper graded by professor

  29. 1. to demonstrate how experience can inform learning 1. evaluated through student feedback on field placement Faculty Students 2. to create a supervised context for students to be social scientists, professionals and citizens 2. evaluated by site supervisor evaluation of student work Internships Site Supervisors 3. to provide a context for integration of the accumulation of knowledge through the curriculum as a whole and application of that knowledge to job-related settings Site 3. evaluated through student journals and final paper graded by professor

  30. 1. to demonstrate how experience can inform learning 1. evaluated through student feedback on field placement Faculty Students 2. to create a supervised context for students to be social scientists, professionals and citizens 2. evaluated by site supervisor evaluation of student work Internships Site Supervisors 3. to provide a context for integration of the accumulation of knowledge through the curriculum as a whole and application of that knowledge to job-related settings Site 3. evaluated through student journals and final paper graded by professor

  31. Program Implementation Logic Model

More Related