Prevention against African American Male Drop outs in high school The evidence-based practice paper should be 9-13 pages in length (not including references) and must follow APA 6th format guidelines. The paper must be written in an academic tone in accordance with APA guidelines. Define your practice problem/issue and your population of interest. Use reliable sources to provide standardized definitions of your problem and describe the prevalence of the problem in the general population. Present your EBP question in a clear and concise manner. Keep in mind: the purpose of this section is to educate your reader on your issue and population, and make an argument for why your practice problem needs to be addressed. Describe how you went about searching for the evidence you present in the paper (include your search terms, what search engines/databases you used, about how many studies or articles were available for the problem you identified and how you decided on the research articles you selected). Your goal is to identify three evaluation studies (quantitative, qualitative or mixed methods) of social work interventions for your issue, and when possible, your population. Studies that identify risk factors for / correlates of a social work problem, or attempt to explain pathways that lead to the problem are not good fits for this section (although they may provide good information for your Background section). When you submit your draft of this section, you will also submit the three (or more) articles you intend to review with a very brief 2-4 sentence summary of the article (for example: "The Smith, et al. (2007) article is a quasi-experimental study that evaluates the ABC intervention for women with depression. I chose it because the sample closely aligns with my population of interest and it is one of very few studies on the topic that uses an experimental design.") Briefly describe and critique the three intervention evaluation studies you identified. Include a brief (1-2 paragraphs) description of the intervention. Use the skills you have learned in class to provide thoughtful critiques of the evaluation research that has been conducted on these interventions (e.g., identify and discuss the study methodology, identify the studies' strengths and weaknesses and discuss how they are important for interpreting the results, discuss issues of internal and external validity and why they are important, etc.). You are expected to go beyond what the authors provide to you in the manuscripts. Make an argument for one intervention approach (from those you presented in Part III) that you believe presents a viable solution to your practice problem. This intervention should be both relevant to your target population, and rigorous enough to be implemented with your population of interest. Describe how and why this intervention is the most appropriate for your issue and population. • What aspects of the supporting research have led you to believe this intervention will be successful in practice? • Assess and describe the fit of this practice solution/intervention for your client. Does it seem applicable to your client’s preferences, culture and values? Does it seem realistic (time needed or cost of intervention)? Why or why not? • What considerations will be necessary for successful implementation of this intervention in practice? Conclude your paper by briefly restating your EBP question and your primary findings. Identify gaps in the literature and suggest areas for additional research.
03 June, 2015
Microsoft Access Database Design and Implementation Business Scenario Your company has been using Excel to track customer orders. They are having difficulty analyzing the data and producing meaningful reports. They have asked you to implement an Access database which will allow them to add, modify and delete data as well as generate reports based on the information contained in the database. 1. Create Database ?Your first task is to create a database in Microsoft Access populated with data from OriginalData.xlsx spreadsheet which includes: ?§??the material worksheet?§??the customer worksheet?§??the salesorder worksheet?§??the salesorderitem worksheet ?Start with a “blank” Access database, name this database YourName.accdb. Import data from each worksheet in the Excel file OriginalData.xlsx. Note that each worksheet should be imported as a new Access table and given the same name as the Excel worksheet. Hint: Be careful in setting the datatypes of each field during the import process – remember foreign keys (an example is the CustomerID in the SalesOrder table) MUST be of the same data type as the corresponding primary key in a related table. Use text for ID numbers in all tables. 2. Create Relationships & Forms for Data Entry?a. Build the relationships for the three tables per the model shown in Figure 1. ?Figure 1: Model of the Relationships ITM 220 Access Assignment Dr. Papp 3. Create Forms for Data Entry a. Create a data input form (name it “customerFRM”) for customers that can be used to update the customer table. Use the Create form wizard with “split form”. Add one company to the database as a new customer that is a Hypermart in Fulda (Germany) with postal code of 36048. Use your UT student ID for the customerID. Figure 2 b. Create a form to display each salesorder as well as salesorderitem details on a subform. (Use the Forms Wizard, style “office”.) The form should look like Figure 3 below. For Order number 10 add an additional line item using your new form as follows: MaterialID: AA-02 Quantity: 100 Price: 525 Figure 3 ITM 220 Access Assignment Dr. Papp 4. Create Queries to Analyze Information (a) Create a query called Q1-ListAllCustomers which displays each customer’s ID, postal code, city, and searchterm. Sort the list alphabetically by city (hint change setting in “Sort” row of query design grid). (b) Create a query called Q2-ListCustomersFulda that displays the ID, postal code, city, and searchterm for each customer in Fulda. Sort this list from largest to smallest by customerID. (c) Create a new query called Q3-PriceStatistics that displays price in six columns but computes different values for each display. Display 1) the sum, 2) the minimum, 3) the maximum value, 4) a count, 5) the average, and 6) the standard deviation of price. (Hint: use the Sigma summation symbol to display the “Total:” row in the query grid) (d) Create a query called Q4-CustomerOrderbyItem that displays data from all four tables. Specifically include: Customer, City, SearchTerm, SalesOrderDate, SalesOrderID, MaterialID, Quantity, Price, and Material description. Sort by MaterialID. This query will be used as an input to the next query and to show we can reassemble the data from the original document used to build the system. (e) Create a query called Q5-OrderDetailsCrosstab, which produces a table such as is shown below (Hint: use the crosstab function in the Query Wizard and the previous query as your input to create this query) (f) Create a query called Q6-CustomersLessThan15000. Start by copying Q4 and modify the name. Display only data for total prices less than 15000 Euros. (Hint: use the “criteria” row by entering the appropriate inequality and numeric value to generate the correct data.) ITM 220 Access Assignment Dr. Papp 5. Create Reports for Management (a) Create a report “R1-CustomerbyCity” that looks like the one below. • Use the Create | Report with Customer table. (Don’t use Report Wizard.) • Change the title to include your name. • Use “layout view” to customize report (column order, width and sort by city,) ?(b) Create a second report “R2-SalesReport” as shown below using Q4 as your input source. ?•?Use Create | Report again but with Q4 as your source. You can use Report Wizard or create the report manually. Note: “right click” is your friend as you modify the default report format to achieve: ?o Group on MaterialID?o Group on MaterialDescription?o Adjust layout to “Stack MaterialDescription” as shown?o Sort by OrderDate?o Compute subtotals and grand totals for price and quantity?o Adjust format to align columns and change labels as necessary
03 June, 2015
Wilson Disease Describe the disorder, making sure to answer the following questions in your discussion of the disorder: 1.Which parts of the brain are believed to be involved in this disorder, and how do these areas of the brain influence the development and behavior of the individual? 2.Briefly describe at least one method which has been used to study this disorder (EEG, fMRI, etc.), and what this method involves. 3.Describe at least one neurotransmitter(s) that is believed to function abnormally in this disorder, and how this impacts on the behavior of the individual. You will need a cover page, which includes your name, the name of the class and section, and the date. In completing this Assignment, be sure to use specific information from the text or other outside sources as needed to support your answers when defining the different terms and concepts. When referencing the text or outside sources, you need to use APA formatting. Information regarding APA formatting can be found in the Writing Center and should be reviewed thoroughly. APA formatting dictates how your paper should appear on each page.
03 June, 2015
