Assignment 7.1: Using Spreadsheets to Determine Risks

Value: 30 points

Introduction

As a DNP leader, you will be called on to determine the relative importance of various types of data. Sometimes what looks significant, may not be, and vice versa. In this lesson, you will learn to determine the incidence rate, attributable risk, and relative risk of populations.

Before you begin this assignment, review this week’s Learning Materials, Instructional Materials, and complete Practice Quiz 7.1: Determining Risk.

Scenario

A cohort study following a group of 2,000 randomly selected adolescent females over four years finds the results shown in the following table.

	Drops Out of High School	Finishes High School	Totals
Pregnancy	370	246	616
No Pregnancy	550	834	1384
Totals	920	1080	2000

Assignment Guidelines

Review the data provided in Table 1.
Download the Determining Risk (Excel)

Links to an external site. spreadsheet.
Use the formulas in Excel to complete these requests. Use cell locations, and not the actual numbers:
1. Calculate the incidence rate (IR) for dropping out of high school for all three groups (pregnant, not pregnant, and total).
2. Calculate the attributable risk (AR) of dropping out of high school for adolescent females who become pregnant.
3. Calculate the relative risk (RR) of dropping out of high school for adolescent females who become pregnant.
4. Create a Word document where you will embed the Excel file (see instructions in the “Formatting and Mechanics” section), then add the interpretations of these results for each request in your own words..

Click here to ORDER an A++ paper from our Verified MASTERS and DOCTORATE WRITERS: Assignment 7.1: Using Spreadsheets to Determine Risks

Formatting and Mechanics

Create a Word document.
Use landscape orientation for the page layout.
Embed into the Word document the Excel file with the formulas you used to calculate the answers. (Open the Word document and select insert on the ribbon; select object. The object dialog box will appear. Select create from file. Choose Browse and select the Excel file you want to embed.)
Under the Excel table, add three bullets with your interpretations of these results in your own words.
In the Word document, include:
- Your embedded Excel file
- Your interpretations of the results in your own words

Submit

The Word document with the embedded Excel file and a bulleted list with interpretations

Submission

Submit your assignment and review full grading criteria on the Assignment 7.1: Using Spreadsheets to Determine Risk page.

Assignment 7.1: Using Spreadsheets to Determine Risks

Select Grader

Week 7 Using Spreadsheets to Determine Risk Rubric

Week 7 Using Spreadsheets to Determine Risk Rubric
Criteria	Ratings	Pts
Question 1 Excel	4 pts 4 points Formulas in Excel used 0 pts 0 points Formulas in Excel not used Comments No evidence of formulas used provided.	4 / 4 pts
Calculation	3 pts 3 points Calculations correct 0 pts 0 points Calculations incorrect	3 / 3 pts
Interpretation	3 pts 3 points Interpretation correct 0 pts 0 points Interpretation incorrect	3 / 3 pts
Question 2 Excel	4 pts 4 points Formula in Excel used 0 pts 0 points Formula in Excel not used	4 / 4 pts
Calculation	3 pts 3 points Calculation correct 0 pts No Marks Calculation incorrect	3 / 3 pts
Interpretation	3 pts 3 points Interpretation correct 0 pts 0 points Interpretation incorrect	3 / 3 pts
Question 3 Excel	4 pts 4 points Formula in Excel used 0 pts 0 points Formula in Excel not used	4 / 4 pts
Calculation	3 pts 3 points Calculation correct 0 pts 0 points Calculation incorrect	3 / 3 pts
Interpretation	3 pts 3 points Interpretation correct 0 pts 0 points Interpretation incorrect	3 / 3 pts
Format	0 pts (No Deduction) Word document with table and bullets is saved as directed. 0 pts -4 Point Deduction Incorrect file types submitted, or mechanics are not followed as directed.	0 / 0 pts
Total Points: 30

Grading Rubric

Performance Category	100% or highest level of performance 100% 16 points	Very good or high level of performance 88% 14 points	Acceptable level of performance 81% 13 points	Inadequate demonstration of expectations 68% 11 points	Deficient level of performance 56% 9 points	Failing level of performance 55% or less 0 points
Total Points Possible= 50	16 Points	14 Points	13 Points	11 Points	9 Points	0 Points
Scholarliness Demonstrates achievement of scholarly inquiry for professional and academic topics.	Presentation of information was exceptional and included all of the following elements: Provides evidence of scholarly inquiry relevant to required TD topic(s). Presents specific information from scholarly sources to develop a comprehensive presentation of facts. Uses at least one outside scholarly reference that is relevant, less than 5 years old (use of older references requires instructor permission) and reliable for the required topic.* Uses in-text citation and full reference at end of posting when presenting another person’s thoughts as quotes or paraphrase of information.	Presentation of information was good, but was superficial in places and included all of the following elements: Provides evidence of scholarly inquiry relevant to required TD topic(s). Presents specific information from scholarly sources to develop a comprehensive presentation of facts. Uses at least one outside scholarly reference that is relevant, less than 5 years old (use of older references requires instructor permission) and reliable for the required topic.* Uses in-text citation and full reference at end of posting when presenting another person’s thoughts as quotes or paraphrase of information.	Presentation of information was minimally demonstrated in all of the following elements: Provides evidence of scholarly inquiry relevant to required TD topic(s). Presents specific information from scholarly sources to develop a comprehensive presentation of facts. Uses at least one outside scholarly reference that is relevant, less than 5 years old (use of older references requires instructor permission) and reliable for the required topic.* Uses in-text citation and full reference at end of posting when presenting another person’s thoughts as quotes or paraphrase of information.	Presentation of information is unsatisfactory in one of the following elements: Provides evidence of scholarly inquiry relevant to required TD topic(s). Presents specific information from scholarly sources to develop a comprehensive presentation of facts. Uses at least one outside scholarly reference that is relevant, less than 5 years old (use of older references requires instructor permission) and reliable for the required topic.* Uses in-text citation and full reference at end of posting when presenting another person’s thoughts as quotes or paraphrase of information.	Presentation of information is unsatisfactory in two of the following elements: Provides evidence of scholarly inquiry relevant to required TD topic(s). Presents specific information from scholarly sources to develop a comprehensive presentation of facts. Uses at least one outside scholarly reference that is relevant, less than 5 years old (use of older references requires instructor permission) and reliable for the required topic.* Uses in-text citation and full reference at end of posting when presenting another person’s thoughts as quotes or paraphrase of information.	Presentation of information is unsatisfactory in three or more of the following elements Provides evidence of scholarly inquiry relevant to required TD topic(s). Presents specific information from scholarly sources to develop a comprehensive presentation of facts. Uses at least one outside scholarly reference that is relevant, less than 5 years old (use of older references requires instructor permission) and reliable for the required topic.* Uses in-text citation and full reference at end of posting when presenting another person’s thoughts as quotes or paraphrase of information
	16 Points	14 Points	13 Points	11 Points	9 Points	0 Points
Application of Course Knowledge Demonstrate the ability to analyze and apply principles, knowledge and information learned in the outside readings and relate them to real-life professional situations	Presentation of information was exceptional and included all of the following elements: Applies principles, knowledge and information from scholarly resources to the required topic. Applies facts, principles or concepts learned from scholarly resources to a professional experience. Application of information is comprehensive and specific to the required topic.	Presentation of information was good, but was superficial in places and included all of the following elements: Applies principles, knowledge and information from scholarly resources to the required topic. Applies facts, principles or concepts learned from scholarly resources to a professional experience. Application of information is comprehensive and specific to the required topic.	Presentation of information was minimally demonstrated in the all of the following elements: Applies principles, knowledge and information from scholarly resources to the required topic. Applies facts, principles or concepts learned from scholarly resources to a professional experience. Application of information is comprehensive and specific to the required topic.	Presentation of information is unsatisfactory in one of the following elements: Applies principles, knowledge and information from scholarly resources to the required topic. Applies facts, principles or concepts learned from and scholarly resources to a professional experience. Application of information is comprehensive and specific to the required topic.	Presentation of information is unsatisfactory in two of the following elements: Applies principles, knowledge and information from scholarly resources to the required topic. Applies facts, principles or concepts learned from scholarly resources to a professional experience. Application of information is comprehensive and specific to the required topic.	Presentation of information is unsatisfactory in three of the following elements Applies principles, knowledge and information and scholarly resources to the required topic. Applies facts, principles or concepts learned scholarly resources to a professional experience. Application of information is comprehensive and specific to the required topic.
	10 Points	9 Points			6 Points	0 Points
Interactive Dialogue Initial post should be a minimum of 300 words (references do not count toward word count) The peer and instructor responses must be a minimum of 150 words each (references do not count toward word count) Responses are substantive and relate to the topic.	Demonstrated all of the following: Initial post must be a minimum of 300 words. The peer and instructor responses must be a minimum of 150 words each. Responses are substantive Responses are related to the topic of discussion.	Demonstrated 3 of the following: Initial post must be a minimum of 300 words. The peer and instructor responses must be a minimum of 150 words each. Responses are substantive Responses are related to the topic of discussion.			Demonstrated 2 of the following: Initial post must be a minimum of 300 words. The peer and instructor responses must be a minimum of 150 words each. Responses are substantive Responses are related to the topic of discussion.	Demonstrated 1 or less of the following: Initial post must be a minimum of 300 words. The peer and instructor responses must be a minimum of 150 words each. Responses are substantive Responses are related to the topic of discussion.
	8 Points	7 Points	6 Points	5 Points	4 Points	0 Points
Grammar, Syntax, APA Points deducted for improper grammar, syntax and APA style of writing. The source of information is the APA Manual 6th Edition Error is defined to be a unique APA error. Same type of error is only counted as one error.	The following was present: 0-3 errors in APA format AND Responses have 0-3 grammatical, spelling or punctuation errors AND Writing style is generally clear, focused on topic,and facilitates communication.	The following was present: 4-6 errors in APA format. AND/OR Responses have 4-5 grammatical, spelling or punctuation errors AND/OR Writing style is somewhat focused on topic.	The following was present: 7-9 errors in APA format. AND/OR Responses have 6-7 grammatical, spelling or punctuation errors AND/OR Writing style is slightly focused on topic making discussion difficult to understand.	The following was present: 10- 12 errors in APA format AND/OR Responses have 8-9 grammatical, spelling and punctuation errors AND/OR Writing style is not focused on topic, making discussion difficult to understand.	The following was present: 13 – 15 errors in APA format AND/OR Responses have 8-10 grammatical, spelling or punctuation errors AND/OR Writing style is not focused on topic, making discussion difficult to understand. AND/OR The student continues to make repeated mistakes in any of the above areas after written correction by the instructor.	The following was present: 16 to greater errors in APA format. AND/OR Responses have more than 10 grammatical, spelling or punctuation errors. AND/OR Writing style does not facilitate communication
	0 Points Deducted					5 Points Lost
Participation Requirements	Demonstrated the following: Initial, peer, and faculty postings were made on 3 separate days					Failed to demonstrate the following: Initial, peer, and faculty postings were made on 3 separate days
	0 Points Lost					5 Points Lost
Due Date Requirements	Demonstrated all of the following: The initial posting to the graded threaded discussion topic is posted within the course no later than Wednesday, 11:59 pm MT. A minimum of one peer and one instructor responses are to be posted within the course no later than Sunday, 11:59 pm MT.					Demonstrates one or less of the following. The initial posting to the graded threaded discussion topic is posted within the course no later than Wednesday, 11:59 pm MT. A minimum of one peer and one instructor responses are to be posted within the course no later than Sunday, 11:59 pm MT.