Assignment 7.1: Using Spreadsheets to Determine Risks

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

  1. Review the data provided in Table 1.
  2. Download the Determining Risk (Excel)
  1. Links to an external site. spreadsheet.
  2. 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

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

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.