I’ve attached all the files needed for the HW.PLEASE review them before accepting or making an offer!!.
data_files_hw6_hdp.zip
instructions_hw6_hdp.pdf
Unformatted Attachment Preview
HOMEWORK INSTRUCTIONS
Homework #6
Hurricane Damages Problem
Background Information
Every year from June 1 to November 30 is hurricane season in the
United States. Rescue relief agencies such as FEMA and the Red
Cross are ready to assist when a hurricane comes ashore.
Unfortunately, hurricanes cause billions of dollars of damage every
year, and deaths are not unusual. The National Weather Service
makes its best guess as to when and where the storm will hit. Due to
constraints on technology and the overall unpredictable nature of weather,
however, damage is often inevitable.
Problem Statement
In this assignment, students will explore data about hurricanes and related storms
from 1950 onward. Using the tools available, predictions can be made about the
cost of a hurricane if it makes landfall.
Instructions
IMPORTANT: This assignment requires the Windows version of Microsoft Office.
IMPORTANT: Complete the steps below in the order they are given. Completing the
steps out of order may complicate the assignment or result in an incorrect result.
1.
Download and extract the provided Data Files ZIP file. It contains the following
files for use in this assignment:
a.
cpifactors.xml – Listing of Consumer Price Index adjustment factors [1].
Table: CPIFactors
Field Name
HurricaneYear
CPIFactor
b.
Type
Number
Number
Description
Primary key. Year of CPI adjustment factor.
CPI adjustment factor for 2011-valued
dollars.
hurricanescale.xml – Information on the Saffir-Simpson Hurricane Scale
[3].
Table: HurricaneScale
Field Name
Type
CategoryAbbrv
Short Text
CategoryName
Short Text
LowerWindSpeed
Number
UpperWindSpeed
Number
Introduction to Computer Applications
West Virginia University
Page 1 of 9
Description
Primary key. Abbreviation for the category.
Full name of the category (e.g., “Tropical
Storm”, “Category 3 Hurricane”).
The lower bound wind speed for a storm of
this category.
The upper bound wind speed for a storm of
this category.
Version 9.19
Modified 5/23/2018
HOMEWORK INSTRUCTIONS
Homework #6
Hurricane Damages Problem
c.
hurricanes.xml – Statistics on hurricanes from 1950 to 2011 [2].
Table: Hurricanes
Field Name
HurricaneID
Type
AutoNumber
HurricaneName
HurricaneYear
StartDate
EndDate
MaxCategoryAbbrv
Short Text
Number
Date
Date
Short Text
MaxWindSpeed
MinPressure
Number
Number
Deaths
Damage
Number
Currency
RetiredName
Yes/No
Description
Primary key. Unique identifier for the
hurricane.
Name given to the storm.
Year the storm took place.
Date the storm developed.
Date the storm diminished.
Maximum category as which the storm was
classified on the Saffir-Simpson Hurricane
Scale.
Maximum wind speed recorded for the storm.
Minimum air pressure recorded for the
storm.
Number of deaths attributed to the storm.
Estimated damage caused in the United
States.
If yes, this storm resulted in the hurricane
name being retired.
d.
hurricanes.rtf – Report text file to format in Word.
e.
hurricane.png – Image of a hurricane for use in PowerPoint.
Microsoft Access Portion
2.
Create a new Microsoft Access database named
lastname_firstname_hw6_hdp.accdb.
3.
Import the following items into the database:
4.
a.
cpifactors.xml file – Import structure and data into a new table.
b.
hurricanes.xml file – Import structure and data into a new table.
c.
hurricanescale.xml file – Import structure and data into a new table.
Create the appropriate relationships for the following tables. Enforce referential
integrity, but do not enable cascade updates or cascade deletes.
a.
Hurricanes and HurricaneScale
b.
Hurricanes and CPIFactors
Introduction to Computer Applications
West Virginia University
Page 2 of 9
Version 9.19
Modified 5/23/2018
HOMEWORK INSTRUCTIONS
Homework #6
Hurricane Damages Problem
5.
Create separate queries to provide the information requested below. Name
each query after the step in which it appears (e.g., name the query in Step 5a
as Query5A).
HINT: Run your queries to test them. Make sure that they display all and only
the records that you would expect to appear.
a.
Create a query to display statistics on each hurricane. List the hurricane
name, year, start date, and number of deaths. Also, include a field to
calculate the estimated damage in inflation-adjusted 2011 dollars.
You can calculate the estimated damage in inflation-adjusted 2011 dollars
using the formula:
[𝐻𝑢𝑟𝑟𝑖𝑐𝑎𝑛𝑒𝑠. 𝐷𝑎𝑚𝑎𝑔𝑒] ∗ [𝐶𝑃𝐼𝐹𝑎𝑐𝑡𝑜𝑟𝑠. 𝐶𝑃𝐼𝐹𝑎𝑐𝑡𝑜𝑟]
Format the calculated field as currency with no decimal places. Sort by
start date in ascending order.
HINT: This query will show 686 records and 5 fields.
b.
We wish to summarize statistics on the most powerful hurricanes. Create
a query listing, for each year and storm category, the number of
hurricanes, total number of deaths, and total cost of damage.
Only include records for Category 4 Hurricanes and Category 5
Hurricanes.
Format the total cost of damage as currency with no decimal places.
HINT: This query will show 53 records and 5 fields.
c.
We would like to generate statistics on retired hurricane names. Copyand-paste this SQL code into a new query:
SELECT Hurricanes.HurricaneYear,
(Count(HurricaneName)-Retired) AS [Non-Retired],
Sum(IIf(RetiredName,1,0)) AS Retired
FROM Hurricanes
GROUP BY Hurricanes.HurricaneYear
ORDER BY Hurricanes.HurricaneYear;
IMPORTANT: Do not make any modifications to this query other than
entering the above SQL code.
HINT: This query will show 62 records and 3 fields.
Introduction to Computer Applications
West Virginia University
Page 3 of 9
Version 9.19
Modified 5/23/2018
HOMEWORK INSTRUCTIONS
Homework #6
Hurricane Damages Problem
d.
We need to gather statistics on all our recorded hurricanes. Copy-andpaste this SQL code into a new query:
SELECT Hurricanes.HurricaneName, Hurricanes.HurricaneYear,
Hurricanes.StartDate, Hurricanes.EndDate,
HurricaneScale.CategoryName, Hurricanes.MaxWindSpeed,
Hurricanes.MinPressure, Hurricanes.Deaths, Hurricanes.Damage
FROM HurricaneScale INNER JOIN Hurricanes ON
HurricaneScale.[CategoryAbbrv] = Hurricanes.[MaxCategoryAbbrv]
ORDER BY Hurricanes.StartDate;
IMPORTANT: Do not make any modifications to this query other than
entering the above SQL code.
HINT: This query will show 686 records and 9 fields.
6.
Run the Compact and Repair Database utility on your database. Ignore any
errors you receive when running the utility.
Microsoft Excel Portion
7.
Create a new Microsoft Excel workbook named
lastname_firstname_hw6_hdp.xlsx.
8.
We must adjust the sheets in our workbook.
9.
a.
Rename Sheet1 to Retired Names.
b.
Add a new sheet named Hurricanes.
Import the following items into the workbook:
a.
Query5C query from the Microsoft Access database – Import as a table
starting in cell A1 of the Retired Names sheet.
NOTE: Microsoft Access must be closed before importing the query.
b.
Query5D query from the Microsoft Access database – Import as a table
starting in cell A1 of the Hurricanes sheet.
NOTE: Microsoft Access must be closed before importing the query.
Introduction to Computer Applications
West Virginia University
Page 4 of 9
Version 9.19
Modified 5/23/2018
HOMEWORK INSTRUCTIONS
Homework #6
Hurricane Damages Problem
10. We would like to create a chart to display information on the retired hurricane
names.
Create a new 2-D clustered column chart based on cells A1 through C63 of the
Retired Names sheet. Move the chart to a new sheet named Retired Names
Chart.
Ensure the years are shown as labels for the horizontal (category) axis, not
plotted as chart data. Specify appropriate chart and axis titles. Format the
vertical (value) axis as a number with 1 decimal place.
11. To better understand our data, we wish to create a PivotTable.
a.
Create a new PivotTable based on the data in cells A1 through I687 of
the Hurricanes sheet. Place the PivotTable on a new sheet named
Hurricanes PivotTable.
b.
On the PivotTable, do the following:
c.
i.
Add the year as a Rows field.
ii.
Add the category name as a Columns field.
iii.
Add the deaths as a Values field.
There is nothing to do for this step. Please proceed to the next step.
Microsoft Word Portion
12. Create a new Microsoft Word document named
lastname_firstname_hw6_hdp.docx.
13. At the beginning of the document, insert a cover page using either of the builtin Sideline or Whisp styles. On the cover page, include the information noted
below.
a.
Company: The words Computer Science 101 Section followed by the
section number in which you are enrolled.
b.
Title: Hurricanes
c.
Subtitle: Causes, Effects, and Classification
d.
Author: Your first and last name.
e.
Date: The current date.
14. Add a second page if one does not already exist. On it, insert the contents of
the hurricanes.rtf file.
NOTE: The inserted text contains instructions (inside of “<>” symbols) for use
in formatting the document. You should remove these instructions once you
have applied the specified formatting.
Introduction to Computer Applications
West Virginia University
Page 5 of 9
Version 9.19
Modified 5/23/2018
HOMEWORK INSTRUCTIONS
Homework #6
Hurricane Damages Problem
15. Where indicated, include the chart from the Retired Names Chart sheet in your
Microsoft Excel workbook. Size the chart to be 4-inches high by 6.5-inches
wide. Add a caption for the chart.
16. Where indicated, insert a new equation using the Microsoft Word equation tool
representing the formula below. Your formula must identically reproduce:
𝐷𝑎𝑚𝑎𝑔𝑒
𝐷𝑒𝑎𝑡ℎ𝑠
17. At the end of the document, we wish to create a bibliography page.
a.
Define the following sources as references for your report.
i.
ii.
iii.
b.
Type: Web site

Name of web page: Weather Underground Home Page

Name of web site: Weather Underground

Date: November 8, 2008

Date accessed: November 8, 2008

URL: http://www.weatherunderground.com
Type: Web site

Name of web page: USAToday.com

Name of web site: USA Today

Date: May 17, 2005

Date accessed: November 8, 2008

URL:
http://www.usatoday.com/weather/hurricane/whscale.htm
Type: Book

Author: Douglas Brinkley

Title: The Great Deluge: Hurricane Katrina, New
Orleans, and the Mississippi Gulf Coast

Year: 2006

City: New York City

Publisher: HarperCollins
Where indicated on the last page, insert a Bibliography-style bibliography
using an APA style.
18. We must finish formatting our document.
Introduction to Computer Applications
West Virginia University
Page 6 of 9
Version 9.19
Modified 5/23/2018
HOMEWORK INSTRUCTIONS
Homework #6
Hurricane Damages Problem
a.
Apply the formatting and changes to your report text as specified by the
included comments.
Remove the included comments from your document once you have
applied the required formatting.
b.
Ensure your document conforms to the following requirements:
i.
Modify the Normal formatting style to specify Verdana 11-point as
the default font.
ii.
In the right-hand corner of the header on all pages after the cover
page, list your last name followed by the page number. The page
number should begin at 1 on the first actual page of text (the page
after the cover page).
iii.
The first line of your text paragraphs should be indented by 0.5inch. Do not indent the cover page, headings, images, captions,
equations, or bibliography.
iv.
Except on the cover page, use double line spacing.
v.
Ensure there is no (0-point) line spacing before and after each
paragraph except on the cover page.
vi.
Use 1.0-inch margins on all sides.
Microsoft PowerPoint Portion
19. Create a new Microsoft PowerPoint presentation named
lastname_firstname_hw6_hdp.pptx.
20. In the presentation, create the following slides:
a.
Title Slide-type slide listing a title for the presentation, your name, course
section, and an automatically updating date.
b.
Title and Content-type slide titled Retired Hurricane Names. Add the
chart from the Retired Names Chart sheet of your Microsoft Excel
workbook to the content area of the slide.
21. Create Title and Content-type slides to answer four of the five analysis
questions below. Respond to one question per slide. Title each slide with the
name of the question being answered (e.g., “Question A”).
a.
The Hurricanes PivotChart chart reveals several spikes in deaths during
the early 1960s, 1970s and late 1990s. Identify the key hurricanes that
comprise the majority of these spikes.
b.
Why do most hurricanes form during the so-called Hurricane Season,
lasting from June 1 to November 30?
Introduction to Computer Applications
West Virginia University
Page 7 of 9
Version 9.19
Modified 5/23/2018
HOMEWORK INSTRUCTIONS
Homework #6
Hurricane Damages Problem
c.
The Saffir-Simpson Hurricane Scale is a method of measuring the
intensity of a hurricane based on maximum wind speed. Is the SaffirSimpson category of a hurricane, as determined by its maximum wind
speed, a good predictor of the damages it will cause? Why or why not?
d.
Hurricane detection and tracking tools have become significantly more
sophisticated over the last 50 years of hurricane history. Give examples of
at least two technologies that have improved hurricane detection and
tracking.
e.
Are there any weather or climate phenomena associated with increased
hurricane activity? Explain your answer.
22. We wish to apply formatting to the presentation. Use your best judgment to
create a professional-looking presentation.
a.
Apply one slide design of your choice to all slides.
b.
Apply an animation of your choice to the Retired Hurricane Names chart.
c.
Apply slide transitions of your choice to all slides.
d.
Edit the parent (top-most) slide master to add the hurricane.png image to
the bottom left corner of the slides. Size the image to be 0.5-inches high
by 0.5-inches wide.
NOTE: Depending on the slide design used, the image may not appear on
title slides. This is acceptable as long as the image is correctly added to
the slide master.
e.
Add your name, an automatically updating date, and the slide number to
the footer of all slides except the title slide.
Assignment Requirements
You must submit all four files (Microsoft Access, Microsoft Excel, Microsoft
PowerPoint, and Microsoft Word) for this assignment.
Introduction to Computer Applications
West Virginia University
Page 8 of 9
Version 9.19
Modified 5/23/2018
HOMEWORK INSTRUCTIONS
Homework #6
Hurricane Damages Problem
Grading Rubric
This assignment is worth 50 points. It will be graded by your instructor using this
rubric, with partial credit awarded as appropriate:
Step 3
Step 4
Steps 5a-b
Steps 5c-d
Steps 8a-b
Steps 9a-b
Step 10
Steps 11a-c
Steps 13a-e
2 points
1.5 points
2.5 points each
1 points each
1 points total
1.5 points total
3 points
5 points total
2.5 points total
Step 14
Step 15
Step 16
Steps 17a-b
Steps 18a-b
Steps 20a-b
Steps 21a-e (pick 4 of 5)
Steps 22a-e
2.5 points
1.5 points
1.5 points
2.5 points total
3.5 points total
2.5 points total
2.5 points each
2.5 points total
The analysis questions in Steps 21a-e will be evaluated using this rubric:
Standard
Answer is reasonable.
Answer is supported.
Meets Requirements
(1.25 points)
Answer addresses the
question prompt and is
factually correct or a
reasonable interpretation of
available data.
Logical rationale is provided
to support the given
answer.
Does Not Meet
Requirements (0 points)
Answer does not address
the question prompt, is
factually incorrect, or is an
unreasonable interpretation
of available data.
Logical rationale is not
provided to support the
given answer.
Acknowledgments
The image in the introduction appears courtesy of NASA [4].
References
[1] “Consumer Price Index (CPI),” U.S. Bureau of Labor Statistics. Available:
http://www.bls.gov/cpi/.
[2] “Hurricane and Tropical Cyclones,” Weather Underground. Available:
http://www.wunderground.com/hurricane/hurrarchive.asp.
[3] “Saffir–Simpson hurricane wind scale,” Wikipedia, the free encyclopedia, Oct.
01, 2015. Available:
https://en.wikipedia.org/w/index.php?title=Saffir%E2%80%93Simpson_hurrica
ne_wind_scale&oldid=683683350. Accessed: Oct. 01, 2015.
[4] J. Schmaltz, Hurricane Katrina: August 28, 2005. 2005. Available:
https://commons.wikimedia.org/wiki/File:Hurricane_Katrina_August_28_2005_
NASA.jpg.
Introduction to Computer Applications
West Virginia University
Page 9 of 9
Version 9.19
Modified 5/23/2018

Purchase answer to see full
attachment

Are you having trouble with the above assignment or one similar?

To date, 239 students have ordered this same assignment from us and received 100% original work. We can do the same for you!

We offers 100% original papers that are written from scratch.We also have a team of editors who check each paper for plagiarism before it is sent to you.

Click this “order now” button to see free Cost Breakdown!