Community Needs Analysis Paper

The goal of this assignment is to conduct a community mental health needs and resources assessment that also familiarizes you with the overall mental health needs in your community. Having assessed the most pressing local mental health needs, you will focus on one of the major identified issues involving a specific, marginalized population and evaluate what services are offered and by what organizations.

The paper must be 10-12 pages (not including title page, abstract, or reference page; however, these are required as well). You must use current APA style 7th edition (write in third person) and integrate references to at least 10 recent and relevant sources

 

Note: Your assignment will be checked for originality via the SafeAssign plagiarism tool.

Sample paper:  https://apastyle.apa.org/style-grammar-guidelines/paper-format/professional-annotated.pdf

Video by Dr. Simmons:   https://watch.liberty.edu/media/1_pwjtmc3s

Perdue Owl:  https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/apa_changes_7th_edition.html

EDCO 705

Community Needs Analysis Paper Assignment Instructions

The goal of this assignment is to conduct a community mental health needs and resources assessment that also familiarizes you with the overall mental health needs in your community. Having assessed the most pressing local mental health needs, you will focus on one of the major identified issues involving a specific, marginalized population and evaluate what services are offered and by what organizations.

 

Your paper must be 10-12 pages (not including title page, abstract, or reference page; however, these are required as well). You must use current APA style (write in third person) and integrate references to at least 10 recent and relevant sources. Ideally, include both June & Black and Scott & Wolfe in a meaningful way. You may use scholarly journal articles, but your most important sources will be (local and state) government reports, census data, hospital records research, news reports, information from CDC and DHHS, and professional organizations. Sources cited must be specific and relevant to your immediate locality. Include the following content, using appropriate headings:

 

1. Introduction of your community: Describe its location, populations, demographics, and relevant trends, etc.

2. Local needs assessment: Articulate the overall, big picture of your community’s mental health needs and at-risk populations. Be sure to give clear attribution to your sources.

3. Identification of a specific population or issue: Explain why you chose to focus on this particular group.

4. Local resources assessment: Identify the specific organizations that work with this specific population/ issue. Include government, for-profit, and nonprofit organizations in your analysis. How are these organizations addressing this specific need in the community? Your goal is to briefly describe what they do, not to evaluate their effectiveness.

5. Personal reflection: Reflect on how this project has changed your view of your community and/or aided you in better understanding your community. You may use first person in this section.

 

Note: Your assignment will be checked for originality via the SafeAssign plagiarism tool.

 

Hello Class –

I have graded your initial thread to your first discussion board.  I really appreciated the insight that you each shared the case you chose and reflection questions.  You were able to share your wisdom as we begin to learn through our reading and from one another.  The class as a whole did a great job following the rubric and including at least two additional resources to Sue et al. (2014).  Be sure that your citations and resources are in APA format.  I know that we have recently switched from the 6th to the 7th edition and there are some changes.  As a graduate student, you should also be following the professional (not student) format.

Sample paper:  https://apastyle.apa.org/style-grammar-guidelines/paper-format/professional-annotated.pdf

Video by Dr. Simmons:   https://watch.liberty.edu/media/1_pwjtmc3s

Perdue Owl:  https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/apa_changes_7th_edition.html

Page 1 of 1

EPA Strategy is: antecedent-based interventions.

EPA Strategy is: antecedent-based interventions.

1. Develop a thesis and 2-3 main ideas based on the peer-reviewed articles related to your strategy. You may use meta-analyses and comprehensive literature reviews to support your thesis. However, research articles must be used to support your main ideas. Specifically, the research articles must be a report of an experimental research design.

a. A thesis is more than just a presentation of the professional literature about the topic. It is a one-sentence statement that is an argument or claim about the research findings on the strategy based on a thorough level of analysis of the professional literature. Before finalizing your thesis, be sure that there is enough research in the professional literature to support it.

b. Your main ideas are two to three ideas, or conclusions, represented across the studies you have reviewed. It is also appropriate to focus one of your main ideas on critical gaps, or points of disagreement, in the research. Each main idea must be supported by four studies.

2. Complete the synthesis matrix using the format presented below. This synthesis matrix includes:

a. Information describing the findings in each research article that support your main ideas (thus supporting your thesis). This is content you will put in the tables. You are to write this information in your own words so that you can avoid plagiarizing the authors’ works.

b. Summary paragraphs written in your own words describing the support for each main idea. In your summary paragraphs, which will be placed beneath the tables, you should avoid summarizing each article separately. Your goal is to identify common themes/conclusions across articles related to your main ideas and, if appropriate, to identify any points of disagreement across articles.

Submission guidelines:

o Your assignment must be formatted in the Synthesis Matrix Template (provided at the end of this document)

o Your strategy description and summary paragraphs must be written in APA 7th edition format (formatting, in-text citations, and a references page).

o Use peer-reviewed articles from the library databases to support your thesis and main ideas.

o NO direct quotes allowed. Summarize in your own words.

o Submit your assignment to the appropriate assignment links in the course.

** You are to focus on only one evidence-based strategy.** Antecedent-based interventions**

For this strategy, you are to write about two main ideas.

You are to identify four references for each main idea. Thus, you will identify a total of 8 references.

The references must be reports of experimental research studies about the evidence-based strategy.

You will construct one table for each main idea. The content that is presented in each reference is to be summarized in one column of the table to which the reference applies. The summary should closely match the relevant information that is presented in the reference’s Abstract section. Specifically, your summary needs to address the following items only: the study’s participants, strategy (meaning the independent variable), and findings.

The evidence-based strategy does not have to be specific to an exceptionality. In other words, the evidence-based strategy can apply across students who have been identified with the various categories of disability that are listed and defined in the IDEA. Conversely, it is okay if the strategy has been investigated with only one student population, such as students with autism.

It is very important that you get the assistance you need to understand how to put this assignment together, properly, since (a) its format is unique and (b) we want to be certain that you learn as much as possible from it.
Once you have read all of the instructions and have agreed to it I will send the articles. This is a graduate class so the writing must be as so.

Article:1 https://journals.sagepub.com/doi/abs/10.1177/10883576050200040401

Article 2: https://journals.sagepub.com/doi/abs/10.1177/019874290903400402

Article 3: https://journals.sagepub.com/doi/abs/10.1177/019874290002500307

Article 4: https://www.jstor.org/stable/24827523?seq=1

Article 5: https://www.tandfonline.com/doi/abs/10.1080/00405841.2011.534935

Article 6: https://journals.sagepub.com/doi/abs/10.1177/10983007050070030301

Article 7: https://link.springer.com/article/10.1007/s10803-009-0693-8

Article 8: https://journals.sagepub.com/doi/abs/10.1177/10983007070090020501

Article 9: https://journals.sagepub.com/doi/abs/10.3102/0034654313498621

RELATIONAL DATABASE DESIGN

ITNPB3 Assignment ONE

 

RELATIONAL DATABASE DESIGN

 

Introduction

“It’s a Dog’s Life” is a kennel which operates just outside the village of Newtown. The kennel’s function is to look after dogs while their owners are out of town. To help with the running of the kennel, they maintain a spreadsheet of the name, breed, and age of each dog who is staying with them, as well as the name, address and phone number of each dog’s owners. The database also stores special instructions for the care of each dog, as well as which kennel room the dog is staying in, and a note of the unique microchip number which each dog has implanted in their neck. Every dog must have a chip number. Vet notes are added to the spreadsheet if a dog is seen by the vet and vet notes must be associated with a single dog.

The current way in which the data are stored is shown in the table below. Note that each person can own more than one dog and each dog can have more than one owner. The vet columns are empty unless the dog has been seen by the vet. A vet visit cannot exist without a dog, of course.

 

Dog Name DogBreed Dog Age Owner Owner Address Owner Phone DogChipNo Note Room Vet ID Vet Date Vet Note
 

Fido

 

Labrador

 

10

Sarah Smith The Meadows Newtown FK40 7LL 01234

567890

 

545682

 

None

 

1

     
 

Fido

 

Labrador

 

10

John Smith The Meadows Newtown FK40 7LL 01234

567890

 

545682

 

None

 

1

     
 

Sheba

 

Labrador

 

9

Sarah Smith The Meadows Newtown FK40 7LL 01234

567890

 

356784

 

None

 

2

76 20.05.18 Worming tablets given
 

Pat

 

Labradoodle

 

3

Sarah Smith The Meadows Newtown FK40 7LL 01234

567890

 

746587

Enjoys petting  

3

     
 

Paddy

Golden retriever  

7

Frank Jones 14 Main Street Newtown FK40 6TT 0376

458015

 

546875

 

Enjoys all

 

6

     
 

Rex

 

Mongrel

 

6

Frank Jones 14 Main Street Newtown FK40 6TT 0376

458015

 

546888

Requires pills  

12

     

 

 

( Page 1 of 3 )

 

 

Your assignment

You have been tasked to turn these data into a relational database. You will need to build the database and write a report about what you did. You only need to submit the report. It should have the following sections:

a. Introduction – Introduce the business requirements and describe one business rule and one use case you can identify from the scenario given above.

10 marks

b. ER Diagram – Identify the entities and relationships in the scenario given above and draw an ER diagram showing the entities, attributes, relationships, and cardinality. Do not decompose any of the relationships at this point.

10 marks

c. Database Schema – Decompose the design to create a schema to store the data in a suitable normal form (2NF or 3NF). Say which normal form the design is in and justify your choice. List the tables and show the fields, primary keys, and any foreign keys in your schema. Describe any assumptions you have made or any additional fields you have added to your design. Make sure all the primary keys are a sensible choice and introduce new fields if needed. Draw a schema diagram to illustrate your design.

20 marks

d. Create Tables – Create a MySQL database to store the schema that you designed in part c. above. Create the tables using SQL statements and reproduce the code in your answer report. Define the keys and choose appropriate data types and any other restrictions you think are required.

20 marks

e. Insert the Data – Insert the data given above into the appropriate tables. Give a single example of an SQL statement that you used to insert one row of data into one of the tables.

10 marks

f. SQL Queries – Carry out the appropriate SQL queries of answering the following questions. For each query, give the SQL code and the result of running the query on the data in your database. Marks are given by each question.

i. Return a list of all dog names (2).

ii. Return a list of all dog breeds, showing each breed only once (3).

iii. Write a query to count how many dogs have the string “Labr” in their breed (2).

iv. Calculate the average age of all dogs in the kennel (2).

v. Calculate the average age of dogs by breed (3).

vi. Find the breed of dog that has an average age of more than 8 (4).

vii. List all the dog names along with their owners’ names (4).

viii. List all the dogs who have had a vet note recorded. Give the name of the dog and the date of the vet note (5).

ix. List all dogs, giving their name, and if a dog has had a vet visit, give the note for the visit, otherwise, if the dog has not visited the vet, return null in the vet note field (5).

 

 

 

Submission

Please write your answers, save them to PDF and upload them in the assignment submission area on iStirling. Include your student number on the front page of the report, but DO NOT PUT YOUR NAME ANYWHERE on the report.

Late penalties of three marks per calendar day you are late in submitting will be applied, up to a maximum of seven calendar days, after which you will receive no grade for the assignment.

 

 

 

Plagiarism

Plagiarism is presenting somebody else’s work as your own. Plagiarism is a form of academic misconduct and is taken very seriously by the University. Students found to have plagiarised work can have marks deducted and, in serious cases, even be expelled from the University. Do not submit any work that is not entirely your own.

The University’s full guidance on academic integrity and misconduct can be found here: https:// www.stir.ac.uk/about/professional-services/student-academic-and-corporate-services/academic- registry/academic-policy-and-practice/quality-handbook/academic-integrity-policy-and-academic- misconduct-procedure/

Please make sure you have read through this guidance.

Clinical Field Experience C : Social Studies Mini-Lesson Plan

Allocate at least 4 hours in the field to support this field experience.

Part 1: Mini-Lesson Plan           

Prior to going into your clinical field experience classroom this week, use the data received from the pre-assessment to complete the “Social Studies Mini-Lesson Plan” template. This mini-lesson plan will be administered to the selected group of students to support instruction to meet the selected standards. The “Social Studies Mini-Lesson Plan” includes:

  • Social Studies standard, arts standard, and grade level
  • Learning objective(s)
  • Instructional Strategy
  • 100-150 word description of a learning activity that successfully integrates social studies and the arts
  • Formative assessment

Part 2: Mini-Lesson Implementation

After completing the “Social Studies Mini-Lesson Plan,” share it with your mentor teacher for feedback. Provided permission, teach the mini-lesson plan to the small group of selected students. During your lesson, ensure you are answering questions from your students, asking questions that support critical thinking and problem-solving, and observing to see if each student understands the content (this might require formative assessments before, during, and after the lesson to determine understanding).

Part 3: Reflection

In 250-500 words, reflect on the process of using pre-assessment data to develop a lesson plan, and on your experiences teaching the lesson (if applicable).

Include:

  • How you used the data to develop the instruction, selected strategies, and differentiation strategies to meet learning needs.
  • Other accommodations that would have supported the learning.
  • How integrating other content areas might engage students.
  • How this lesson could support short-term and long-term instructional planning.
  • How you will use your findings in your future professional practice.

Submit your reflection and “Social Studies Mini-Lesson Plan” as one deliverable.

Clinical Field Experience C: Social Studies Mini-Lesson Plan

 

Part 1: Social Studies Mini-Lesson Plan

Social studies standard:

Arts standard:

Grade level:

Learning objective:

 

 

1-2 learning objectives:

 

 

Instructional strategy:

 

Description of the learning activity that successfully integrates social studies and the arts (100-150 words):

 

 

 

 

Formative assessment:

 

 

 

Part 3: Reflection