Assignment 2: System Implementation
In this course, you will progressively work on a system implementation process in six stages:
· Week 1: System planning
· Week 2: System analysis
· Week 3: System selection
· Week 4: System implementation
· Week 5: User training and system maintenance
You can use Internet resources, peer-reviewed journals, and reputable, published articles, and you may interview an executive of a healthcare facility that has implemented an electronic medical record system/electronic health record system or similar system to describe the six implementation steps.
This week you will work on the system implementation phase of the final project, which requires completion of the following steps:
· Site preparation: What are the physical locations where workstations, printers, servers, and other hardware will be installed?
· User preparation: How will you provide users enough information about the system being installed to gain their confidence?
· Installing hardware and software: How will you place and connect the hardware? How will you go about installing, configuring, customizing, and testing specific software?
Complete the assignment in a 3–5-page Word document and name it SUO_HCM3008_W4_A2_yourinitials.
Submit it to the W4: Assignment 2 Dropbox by Tuesday, November 29, 2016.
Cite any sources in the APA format.
Assignment 2 Grading Criteria |
Maximum Points |
What are the physical locations where workstations, printers, servers, and other hardware will be installed? |
10 |
How will you provide users enough information about the system being installed to gain their confidence? |
20 |
Installing hardware and software: How will you place and connect the hardware? How will you go about installing, configuring, customizing, and testing specific software? |
10 |
Presented a structured document free of spelling and grammatical errors. |
5 |
Properly cited sources using APA format. |
5 |
Total |
50 |
Sheet1
Data Set: Temperature Data, Both the Lake and the Land Temperatures | |||||||||||||||||
Long term trends in Great Lakes temperatures. | |||||||||||||||||
Data Source: NOAA-GLERL Great Lakes Monthly Hydrologic Data (1860-1990), Frank Quinn, NOAA GLERL. See: http://www.glerl.noaa.gov/data/arc/hydro/mnth-hydro.html | |||||||||||||||||
Water surface temperatures (Celsius) | Mean Daily Average Overlake Air Temperature (Cel) | Monthly Evaporation (inches/yr over lake) | |||||||||||||||
Superior | Huron | Erie | Superior | Huron | Erie | Superior | Huron | Erie | |||||||||
1968 | 5 | 8 | 10 | 4 | 6 | 9 | 1968 | 21 | 25 | 34 | |||||||
1969 | 6 | 9 | 10 | 4 | 6 | 9 | 1969 | 23 | 25 | 33 | |||||||
1970 | 5 | 8 | 10 | 4 | 6 | 9 | 1970 | 23 | 26 | 32 | |||||||
1971 | 6 | 9 | 11 | 4 | 6 | 9 | 1971 | 23 | 24 | 32 | |||||||
1972 | 5 | 8 | 10 | 2 | 5 | 8 | 1972 | 24 | 26 | 33 | |||||||
1973 | 7 | 9 | 12 | 5 | 7 | 10 | 1973 | 22 | 25 | 37 | |||||||
1974 | 6 | 8 | 11 | 3 | 6 | 9 | 1974 | 23 | 25 | 35 | |||||||
1975 | 6 | 8 | 11 | 4 | 7 | 10 | 1975 | 25 | 27 | 37 | |||||||
1976 | 6 | 9 | 11 | 3 | 6 | 8 | 1976 | 29 | 30 | 37 | |||||||
1977 | 6 | 8 | 11 | 4 | 6 | 9 | 1977 | 18 | 21 | 33 | |||||||
1978 | 6 | 8 | 10 | 3 | 5 | 8 | 1978 | 24 | 24 | 32 | |||||||
1979 | 5 | 7 | 10 | 3 | 6 | 8 | 1979 | 18 | 22 | 32 | |||||||
1980 | 6 | 8 | 10 | 3 | 5 | 8 | 1980 | 24 | 26 | 35 | |||||||
1981 | 6 | 8 | 11 | 4 | 6 | 9 | 1981 | 22 | 22 | 33 | |||||||
1982 | 5 | 7 | 11 | 3 | 6 | 9 | 1982 | 22 | 21 | 31 | |||||||
1983 | 7 | 10 | 12 | 4 | 7 | 10 | 1983 | 25 | 29 | 41 | |||||||
1984 | 6 | 8 | 10 | 4 | 6 | 9 | 1984 | 22 | 22 | 30 | |||||||
1985 | 6 | 8 | 11 | 3 | 6 | 9 | 1985 | 24 | 27 | 37 | |||||||
1986 | 6 | 8 | 11 | 4 | 6 | 9 | 1986 | 20 | 24 | 33 | |||||||
1987 | 8 | 9 | 12 | 6 | 8 | 10 | 1987 | 23 | 27 | 39 | |||||||
1988 | 7 | 9 | 11 | 4 | 7 | 9 | 1988 | 27 | 29 | 38 | |||||||
1989 | 6 | 8 | 11 | 3 | 6 | 9 | 1989 | 25 | 28 | 36 | |||||||
1990 | 6 | 8 | 12 | 5 | 7 | 10 | 1990 | 22 | 23 | 35 | |||||||
1991 | 7 | 9 | 13 | 4 | 7 | 11 | 1991 | 24 | 28 | 40 | |||||||
1992 | 7 | 9 | 11 | 4 | 6 | 9 | 1992 | 23 | 26 | 36 | |||||||
1993 | 6 | 9 | 11 | 3 | 6 | 9 | 1993 | 23 | 25 | 37 | |||||||
1994 | 6 | 8 | 11 | 4 | 6 | 9 | 1994 | 20 | 23 | 32 | |||||||
1995 | 7 | 9 | 12 | 4 | 6 | 9 | 1995 | 28 | 30 | 40 | |||||||
1996 | 4 | 8 | 11 | 3 | 6 | 9 | 1996 | 20 | 25 | 32 | |||||||
1997 | 5 | 8 | 12 | 4 | 6 | 9 | 1997 | 20 | 26 | 36 | |||||||
1998 | 9 | 11 | 14 | 7 | 8 | 12 | 1998 | 24 | 30 | 41 | |||||||
1999 | 9 | 11 | 13 | 6 | 8 | 10 | 1999 | 27 | 34 | 42 | |||||||
2000 | 8 | 9 | 11 | 5 | 7 | 10 | 2000 | 27 | 30 | 31 | |||||||
2001 | 7 | 9 | 11 | 6 | 8 | 11 | 2001 | 23 | 27 | 28 | |||||||
2002 | 7 | 8 | 12 | 5 | 7 | 10 | 2002 | 27 | 31 | 30 | |||||||
2003 | 5 | 11 | 10 | 4 | 6 | 9 | 2003 | 28 | 26 | 36 | |||||||
2004 | 6 | 7 | 11 | 4 | 6 | 10 | 2004 | 27 | 29 | 39 |
Sheet2
Sheet3
UST 289 Fall 2016 Due November 16,2016 Quantitative Assignment 2
Quantitative Assignment 2 Only use these instructions with EXCEL. Other
spreadsheet programs might require you entering the formulas a bit differently.
In this assignment you will learn how to enter formulas into Excel and then graph the
data that results. You will then use your graphs to answer questions regarding the
relationship that you see in the data.
The Great Lakes are the largest fresh water source in the world. We are fortunate to
live on the shore of one of them. The lake provides us with a ready source of water for
our daily lives and for the businesses that are located here. It also provides a cooling
effect during hot summer days and a warming effect during the winter. It also can give
us a steady supply of both lake effect snow and lake effect rain as well.
In this assignment, you will look at the possible effect on the evaporation of water from 3
selected Great Lakes due to temperature of the water and the overlake air temperature.
The three lakes have been chosen due to their differences in depth. Lake Superior has
a depth of slightly over 482 feet, Lake Huron has a depth of slightly over 193 feet, and
Lake Erie has a depth of slightly over 62 feet.
I have provided you with a basic Excel spreadsheet with the base information that you
will need for the assignment. It is a file in the Quantitative Folder named “Data for
Quantitative 2”. Follow the directions and answer all of the questions at the end of this
assignment. Your 4 graphs and written answers should be all in one Word document.
You may submit your assignment via email or print the hard copy and turn in at class.
While the assignment has a due date of March 5 th , you are free to submit it early. I will
grade it and return it. As long as I receive the assignment no later than March 19 th
, you
will be able to accept the grade, or revise the assignment and resubmit for regarding by
March 5 th
.
CAUTION: BE SURE TO SAVE YOUR WORK FREQUENTLY. YOU WILL REDUCE
YOUR AGGRAVATION THAT CAN OCCUR WHEN SOMETHING HAPPENS TO
CLOSE EXCEL AS YOU WORK!!!!!
1. To begin, open the Excel spreadsheet named “Data for quantitative 2”. You will
begin by converting the temperatures from Celsius to Fahrenheit. The formula for
converting Celsius to Fahrenheit is F o =C
o *9/5+32.
We will need to enter the formula in the cell in Excel. We will begin with Lake Superior
and in cell C7 (which is next to the first temperature) we will enter the following. Type
=((B7*9)/5))+32. then “Enter”. (What you are doing is telling Excel to multiply the value
in B7 by 9, then divide that answer by 5 and then to add 32 to the result.) Once we
have entered the formula, then we can copy it down the column. Click back on cell C7.
Rest your cursor in the lower right hand corner of the cell until a +sign appears. Click
UST 289 Fall 2016 Due November 16,2016 Quantitative Assignment 2
and hold down your left mouse button and drag the information down to the bottom of
the data. This should result in the values appearing as you move down the column.
Repeat the above for each of the columns. Each formula will start with a new column
identifier for row 7. (i.e. for Lake Huron, the identifier would be D7 instead of B7). You
also can copy and paste the formula in the beginning row of each cell for water surface
and Overlake air temperature. Click on cell C7 and then click on “copy”. “Home” tab
and then click on the copy symbol or click with your right mouse button and then choose
“copy”. When the cell highlights and flashes then hold down the control (marked Ctrl)
key and then click on cell E7, G7,I7,K7, and M7. Release the control key. Then click
“paste”. The formula will be duplicated in the chosen cells. Click on cell E7. Notice that
the formula changed to correct the first position to D7. If you check the other cells, you
will find that the formula autocorrected for the changes in position. Once you have the
correct formula in all of the starting cells, then repeat what you did above to drag the
formula down the column.
2. Now that you have converted your temperatures to Fahrenheit, you can set up
the data to make your graphs. First, put the Lake names in the columns above the new
Fahrenheit data. Now you are ready to begin to copy the data that you will use for the
graph. Click on cell A6, hold down the left mouse key and drag down to 2004. This will
highlight that column. (NOTE: Do NOT go to the lower right corner, if you do, then all
cells will lose their value.) Now hold down the control key (Ctrl) and click on the cell that
reads Superior above the Fahrenheit temperatures. While holding down the control key
hold down your left mouse button and drag down to the bottom value. Then repeat this
for Huron and Erie data. Release the cntrl key. Then click copy. The highlighted cells
should be framed and blink. Scroll down below the data and click on a cell A46. Click
on the “Home” tab. Then click on the down arrow under the “paste” clipboard. Choose
the first option under “paste values” and click. This will copy your highlighted data.
Now you are ready to make the graph for “Water Surface Temperatures”.
3. Highlight the four columns containing the data. Go to the “insert” tab. Choose
the graphic for “Line” and then the first choice under “2D Line”. This will make your
graph appear. Click on the design tab and then click on “quick layout” to the left.
Choose the first option on the drop down menu. Then change “Chart Title” to “Water
Surface Temperatures” by clicking on the words and deleting them. Change “Axis Title”
to “Degrees Fahrenheit” in the same manner. You’ve now completed your first graph.
Move the graph under the data. (Click in the corner of the graph, you should see a 4
way arrow before you go to move the graph.)
4. Repeat the above instructions from 2 and 3 to transfer data and make a chart for
Average Overlake Air Temperature. Be sure to adjust labels as necessary. You now
will have 2 of your graphs done.
UST 289 Fall 2016 Due November 16,2016 Quantitative Assignment 2
5. Now you will compute the difference in Water Surface Temperatures and
Average Overlake Air Temperature. Working with the data you transferred to make
your graphs, first copy the years to column K. Copy the “Superior, Huron, and Erie”
headers over, beginning in column L one cell above the starting date. Now you can
compute the difference in Water Surface Temperature and the Average Overlake Air
Temperature. In cell L47 enter =B47-G47 and then “enter”. These cells should contain
the temperatures for Lake Superior. Click back on cell L47 and then drag the formula
under Huron and Erie. The cell numbers should change to reflect their respective
temperatures. When done hit “enter”. Go back to cell L47 and highlight the next two
cells as well. Then go to the right hand corner and when you get the + sign, left click
and drag the formulas down to the bottom. You now will have the differences computed
and following the directions in step 3, make a graph showing these differences. You
have now completed the 3 rd
graph for this assignment.
6. For your last graph, use the data supplied for Evaporation and graph the amount
over time. See step 3 for directions on graphing and labeling. You can use the data as
it is set up. Highlight it and begin the graphing process. Be sure to correct the chart
title to show what the graph is presenting to us.
7. Copy and paste your graphs into a Word Document and answer the following
questions.
A. In looking at your graphs for Water and Overlake Air Temperature, what do you
see? Are the graphs consistent with each other? Are there any unusual years? Which
lake has the highest temperatures, which lake has the lowest? What are some factors
that might affect water temperature?
B. In looking at your graph of the differences between the Water and Overlake Air
Temperature, what do you see? Are the differences consistent lake to lake? Which
lake has the highest difference? Which appears to have the least difference? Why do
you think this might occur? Is there an anomaly in the data? Which lake has this
anomaly if there is one? Is there something in the previous graphs that might have
alerted you to this if there is one?
C. In looking at your graph for Evaporation, what do you see? Which lake had the
highest amount of Evaporation? Which had the least? Would you expect this given the
temperature data that you graphed? What might be some other factors, other than
temperature that might cause this difference?
Assignment 1: Discussion Assignment
The discussion assignment provides a forum for discussing relevant topics for this week based on the course competencies covered.
For this assignment, make sure you post your initial response to the Discussion Area by Saturday, November 26, 2016.
To support your work, use your course and text readings and also use outside sources. As in all assignments, cite your sources in your work and provide references for the citations in APA format.
Start reviewing and responding to the postings of your classmates as early in the week as possible. Respond to at least two of your classmates. Participate in the discussion by asking a question, providing a statement of clarification, providing a point of view with a rationale, challenging an aspect of the discussion, or indicating a relationship between two or more lines of reasoning in the discussion. Complete your participation for this assignment by Wednesday, November 30, 2016.
Privacy vs. Quality of Healthcare
The goal of protecting patient information privacy often conflicts with the goal of providing the improved healthcare that EMRs can support. Provisions in HIPAA provide some confidentiality protection, but not enough. Potential for a major privacy breach lies in the system of primary or secondary users.
What privacy and security issues are hindering the adoption of EMR systems? In your opinion, which of these issues is the most important to address first? Drawing on course readings or outside scholarly sources, support your answer with examples and clear rationales.

Get help from top-rated tutors in any subject.
Efficiently complete your homework and academic assignments by getting help from the experts at homeworkarchive.com