I’m trying to study for my Excel course and I need some help to understand this question.
Goal is to compare how your state in doing compared to national averages in
terms of several healthcare statistics such as ALOS, Costs etc.
You will also look at top 5 DRGs for your state and compare them to national level
top DRGs
INTRODUCTION
Include the state and the year you are evaluating.
Include the tools you used to complete the report (Access and/or
Excel)
Explain the purpose of the report
Describe your role – e.g.: HR manager, Policy Analyst or Financial
Analyst
Explain from your role’s perspective, how you would use the
information and the analysis from this report
TABLES
Number formats:
All numbers greater than 999.99 must have the one thousand comma separators
All percentages must be decimal formatted to the 100
Currency formats:
All cost results must have the currency sign
Must be formatted to include cents
Data analysis outputs:
Must be formatted to the include the correct, modified headings. That is, they
must not have headings such as “sumOfALOS”
Tables should have borders
GRAPHS
Do not use strange colors that are unreadable
Labels and Headings:
Graph must have a heading and bars, or section should be labeled
Vertical and horizontal axes must be labeled with the units. i.e. “Days”
If the graph is a pie chart, must include the legend
If the graph is a bar chart, must label each bar with the measure.
All bar or pie sections must have the value label
Make sure value label and chart color are contrasting and labels are
readable (e.g.: black letters on dark red/maroon background are not
very readable)
ANALYSIS
Compare your state with national averages for the SAME YEAR
Compare DRGs and ALOS and compare your state with National statistics for the same
year
Compare the differences in top 5 DRGs by total discharges
Compare the differences in top 5 DRGs by ALOS
Compare the differences in % distribution of each of the above
Discuss the potential reasons for these differences
It is NOT ENOUGH to just provide tables and graphs, YOU MUST EXPLAIN IN WORDS the
tables and graphs as well as your ANALYSIS
Make sure to provide some literature references for your reasoning. For example, if you
are in FL and ALOS are really high, it may be because of the older population. Provide
some reference for this.
CONCLUCION
What did you discover about your state?
In your role what do you intend to do with this information?
What programs/services do you think your state might need?
What programs/services do you think you could recommend for
change?
What additional research do you need to do to complete your
decision making process?
Do you suggest using any performance measurement or quality
improvement processes and what are those
Excel Data & an Example paper will be provided
/in /by CarlosI’m trying to study for my Excel course and I need some help to understand this question.
Goal is to compare how your state in doing compared to national averages in
terms of several healthcare statistics such as ALOS, Costs etc.
You will also look at top 5 DRGs for your state and compare them to national level
top DRGs
INTRODUCTION
Include the state and the year you are evaluating.
Include the tools you used to complete the report (Access and/or
Excel)
Explain the purpose of the report
Describe your role – e.g.: HR manager, Policy Analyst or Financial
Analyst
Explain from your role’s perspective, how you would use the
information and the analysis from this report
TABLES
Number formats:
All numbers greater than 999.99 must have the one thousand comma separators
All percentages must be decimal formatted to the 100
Currency formats:
All cost results must have the currency sign
Must be formatted to include cents
Data analysis outputs:
Must be formatted to the include the correct, modified headings. That is, they
must not have headings such as “sumOfALOS”
Tables should have borders
GRAPHS
Do not use strange colors that are unreadable
Labels and Headings:
Graph must have a heading and bars, or section should be labeled
Vertical and horizontal axes must be labeled with the units. i.e. “Days”
If the graph is a pie chart, must include the legend
If the graph is a bar chart, must label each bar with the measure.
All bar or pie sections must have the value label
Make sure value label and chart color are contrasting and labels are
readable (e.g.: black letters on dark red/maroon background are not
very readable)
ANALYSIS
Compare your state with national averages for the SAME YEAR
Compare DRGs and ALOS and compare your state with National statistics for the same
year
Compare the differences in top 5 DRGs by total discharges
Compare the differences in top 5 DRGs by ALOS
Compare the differences in % distribution of each of the above
Discuss the potential reasons for these differences
It is NOT ENOUGH to just provide tables and graphs, YOU MUST EXPLAIN IN WORDS the
tables and graphs as well as your ANALYSIS
Make sure to provide some literature references for your reasoning. For example, if you
are in FL and ALOS are really high, it may be because of the older population. Provide
some reference for this.
CONCLUCION
What did you discover about your state?
In your role what do you intend to do with this information?
What programs/services do you think your state might need?
What programs/services do you think you could recommend for
change?
What additional research do you need to do to complete your
decision making process?
Do you suggest using any performance measurement or quality
improvement processes and what are those
US Economy
/in /by CarlosI’m working on a Economics question and need guidance to help me study.
The paper needs to be not less then 2 pages- about 650 words (not including reference page, graphs, charts,etc).
Using the following resources and adding other credible ones analyze the current US economy and its future, even add how it was impacted by the COVID-19. Include numbers. Think GDP, population growth, currency risk, inflation, unemployment, housing, discretionary income, etc.
Please make sure that you don’t copy and paste.Your analysis should be your own understanding and words. You could copy and paste tables or graphs but with proper referencing. You could download charts and data into Word documents but NO PLAGIARISM! Cite your work an include references
Visual design
/in /by CarlosI’m studying and need help with a Communications question to help me learn.
Hello,
I need help with this assignment which is looking at different Visual design for persuasive campaign and evaluate its effectiveness.
I need 3-5 sentences per classmate. Don’t take the surveys, you just need to take a look at it to try understanding the message of the campaign.
Please find attached the visual designs and example of the responses
From the file upload create a PowerPoint presentation similar to the group stages video from the movie "Remember The Titans". You need to include these elements in your presentation:
/in /by CarlosI don’t know how to handle this Powerpoint question and need guidance.
create a PowerPoint presentation similar to the group stages video from the movie “Remember The Titans”. You need to include these elements in your presentation:
Define each stage.
Make sure spelling is correct.
The presentation would be better if it ran like a movie, but you can use pictures and then describe the scene and how it relates to the 5 Stages of Group Development.
You can use movie clips that you find on YouTube. Some possible movies are:
The Avengers
Captain America: Civil War
Lord of the Rings
The Hobbit
Fast and the Furious
Ocean’s 11, 12, 13, etc.
The Italian Job
Armageddon
Miracle
Glory Road
Now You See Me
The Mighty Ducks
Mulan
Facing The Giants
Toy Story
Justice League
The Incredibles
Guardians of the Galaxy
Pitch Perfect
This list could go for ever, but the point is to find a movie, then use it to build a PowerPoint presentation of the 5 stages of group dynamics from
CMR211 Module 9 Assignment
/in /by CarlosI don’t understand this Business question and need help to study.
This task has a purpose to illustrate the concept of monopoly and price discrimination. The video shows how monopoly power arises and how it might disappear.
You are to watch a video clip from the Economics of Seinfeld (The Soup Nazi)
Here is the video (http://yadayadayadaecon.com/clip/67/)
Then you are to answer the following questions.