Step	Instructions	Point Value
1	Start Excel. Download and open the file named Exp19_Excel_Ch03_Cap_Gym.xlsx. Grader has automatically added your last name to the beginning of the filename.	0
2	You will create a pie chart to focus on the expenses for the current year. Insert a 2-D pie chart using the ranges A11:A19 and D11:D19 on the Income worksheet.	5
3	Move the chart to a new chart sheet named Expenses. Move it to the right of the Membership sheet.	3
4	The chart needs a descriptive, easy-to-read title. Change the chart title to Expenses for Year 3 and change the font size to 20.	5
5	You want to create a clustered bar chart. Insert a clustered bar chart using the ranges A4:D4 and A11:D19 on the Income worksheet.	5
6	You want to place this chart and other charts on a Summary worksheet to look at trends. Move the chart as an object on the Summary worksheet. Cut the bar chart and paste it in cell I1.	3
7	The chart should have a descriptive title to explain which expenses are excluded. Change the bar chart title to Expenses (Without Payroll and Cost of Sales).	3
8	You want to filter out the Payroll and Cost of Sales to focus on other expenses. The bar chart displays expenses the first expense (Advertising) at the bottom of the category axis. You want to reverse the categories to display in the same sequence as the expenses are listed in the worksheet. Apply a chart filter to remove Payroll and Cost of Sales. Select the category axis and use the Format Axis task pane to display categories in reverse order. Change the Maximum Bound to 25000.	8
9	You decide to format the pie chart with data labels and remove the legend because there are too many categories for the legend to be effective. Display the Expenses sheet and remove the legend. Add Percent and Category Name data labels and choose Outside End position for the labels. Change the data labels font size to 10.	8
10	You want to emphasize the Education & Training slice by exploding it. Explode the Education & Training slice by 12%.	2
11	Add the Light Gradient – Accent 2 fill color to the chart area.	2
12	You create another chart showing the Balance sheet items. You change the chart to a clustered column and switch the row and column data to focus on each balance sheet item. Insert a stacked column chart using the ranges A4:D4, A10:D10, A15:D15, and A16:D16 on the Balance sheet. Change the chart type to Clustered Column and switch the rows and columns in the chart.	10
13	You want to move the column chart to be on the Summary worksheet along with the bar chart. Move the column chart to the Summary worksheet. Cut the chart and paste it in cell A1.	5
14	The column chart needs to have a descriptive title to indicate the data comes from the Balance sheet. Change the title to 3-Year Balance Sheet.	2
15	The last chart will be a line chart to show the trends in Memberships. Insert a line chart using the range I3:L15 on the Membership worksheet.	5
16	You want to move the line chart to be on the same Summary sheet as column and bar charts. Move the line chart to the Summary worksheet. Cut the chart and paste it in cell A17.	4
17	Because the lowest value is between 200 and 300, you will change the vertical axis at 200 instead of 0. Adjust the vertical axis so the Minimum Bound is 200 and display a vertical axis title # of Memberships for the line chart.	5
18	Apply Chart Style 4 and change colors to Monochromatic Palette 8 for the line chart.	4
19	Move the legend to the top of the chart and add the chart title 3-Year Membership Trends.	4
20		0
21		0
22		0
23		0
24	You want to add sparklines to the Daily Attendance Trends. You add high points to emphasize which time of day is the most popular for your membership. Select range B16:F16 on the Membership worksheet. Insert Column Sparklines using data from the range B6:F14. Display the high points for the sparklines.	7
25	Insert a footer with Exploring Series on the left, the sheet name code in the center, and the file name code on the right on the Membership, Expenses, and Summary sheets individually. Change to Normal view.	2
26	Save and close Exp19_Excel_Ch03_Cap_Gym.xlsx. Exit Excel. Submit the file as directed.	0

Close

Week 4 Assignment – Using Presentation Aids to Enhance Your Speech

Due by Saturday, 11:59 p.m. (MT) end of Week 4 (120 pts)

Learning Objectives Covered:

• LO 04.01 – Define and discuss six types of presentation aids and their purposes
• LO 04.02 – Define and apply the assertion/evidence format for slide design

Career Relevancy

As we discussed last week, career professionals need to be able to speak confidently and competently to co-workers, management, clients, and patients. This such a common job requirement, the Bureau of Labor Statistics lists public speaking or giving presentations as one of the most often required communication skills.

Background

Presentations are used for a variety of purposes. Most often, they are used to inform, teach, report, advertise, persuade, or inspire audience. Depending to the purpose of a presentation, its content, structure, and design may differ.

Purpose of informative presentations is to inform about events or demonstrate some products, services, or product functions. While teaching presentations demonstrate how to do certain things: operate a device/tool or implement new process. Reporting presentations, on the other hand, convey status report of a project or process.

Other common types of presentation in a business field are those that advertise, persuade, or inspire audience. Presentations focused on advertising target sales of products of services; persuasive presentations engage auditorium in decision making, while inspiring presentations engage into problem solving.

When type and purpose of presentation are selected, presentation slides need to be designed with that purpose in mind. Slide design approach known as assertion-evidence (AE), is often used in the professional field. What is AE approach? Alley (n.d.) provides a clear outline of what AE approach is:

This approach will help you to create better understood presentations, as evidenced by tests of audience comprehension. In addition, the approach will make your presentations more focused and help you to project more confidence.

In the assertion-evidence approach, you build your talk on messages (not topics) to tell a coherent and compelling story about your work. Those messages you then support with visual evidence (not bullet lists). In addition, you engage the audience by fashioning sentences on the spot, but after practice.

Presentations often contain visual elements that help to communicate a message or idea with less words. Those different visual elements are called presentation aids. Presentation aids include but are not limited to images/photographs, charts, tables, graphs, videos, audios, and special visual effects like animation.

Before you proceed with this assignment, please review the following videos that give excellent information about how to use other types of aids during your speech:

Video #1: Using Visual Aid Part 1

• Length: 11:07 min
• Learning Objective: LO 04.01 – Define and discuss six types of presentation aids and their purposes
• Content: Public Speaking Projects discusses how properly to use visual aid in presentations.
• Key Takeaways:
  • Select your visual aid careful as selecting a wrong type may ruin your presentation.
  • Avoid passing things through the audience
  • Know your technology
• URL:

Video #2: Using Visual Aid Part 2

• Length: 9:20 min
• Learning Objective: LO 04.01 – Define and discuss six types of presentation aids and their purposes
• Content: Public Speaking Projects discusses how properly to use visual aid in presentations.
• Key Takeaways:
  • Expect unexpected – be aware of “Murphy’s Law” (i.e. equipment breaks, web sites fails, etc.)
  • Practice with your presentation aids
  • Double check all legal guidelines
• URL:

References

Alle, M. (n.d.) Assertion-Evidence Approach. Retrieved form https://www.assertion-evidence.com/ (Links to an external site.)

Prompt

Part 1: After researching and reviewing the various types of presentation aids, decide which would be best-suited to add to the speech you gave last week. Justify your choice in one paragraph.

Part 2: Reflect on your experiences in this class.

• What did you learn about yourself and your strengths?
• How did you prepare?
• What do you wish you had done differently?
• What advice would you give students who are going to take this course?

Your complete submission should be a minimum of 400 words with one citation.

write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions with your classmates. Be substantive and clear, and use examples to reinforce your ideas.

Neuromarketing is a controversial marketing technique. Research the issue and respond to the following questions in your discussion:

• Do you think neuromarketing is easier in an e-market environment?
• Identify an example you see as neuromarketing.
• How can neuromarketing be used in the financial management of Cyber-Health?
• Take a pro or con position on the controversy surrounding neuromarketing.

SENARIO:

Medical Education Academy (Med Ed) is a prominent, privately owned health care education institution that provides degree programs in nursing, medical technology, and health care administration in the United States. The company has built a positive reputation in the traditional on-campus education market for quality skills at an affordable price. Because of this institutional strategy, Med Ed has adopted the motto, “Quality skills with minimum bills.”

Now, however, to keep Med Ed’s motto and institutional operating model intact, President Will Learner, M.D., is planning to strengthen his academy’s health care education leadership while also reducing rising administrative expenses by acquiring an online health care education provider named Cyber-Health College (CHC). Cyber-Health College is a fully certified online health care education provider with a strong reputation among prospective students for relatively inexpensive, timely, and skill-intensive program completion. President Learner believes that Cyber-Health’s online programs will fit well with Med Ed’s institutional strategy because both educational providers emphasize quality skills and affordable prices.

You have been named to Med Ed’s newly formed digital learning initiative team (D-LIT). President Learner is relying on your e-business expertise to analyze Cyber-Health’s e-business and e-marketing fundamentals as well as to propose digital marketing strategy guidelines that will optimize Cyber-Health’s contribution to Med Ed’s strong reputation in the traditional health care education market.

Cyber-Health College was a pioneer in the online health care education market in the 1990s. Its founder and CEO, Lucy Vision, Ph.D., avoided the pitfalls of other dot-coms by building credibility with educational accreditation boards and developing intelligent agent software applications as a method of guiding student instruction without human faculty. Cyber-Health patented its med-teach agent technology using female voices and an embedded nurturing interface to gain student trust and build strong learning bonds. The educational press regularly commended Cyber-Health for designing a high-tech/high-touch instructional interface. Because of the strong, skill-intensive course learning and user-friendly, agent-driven interactive online instruction, Cyber-Health effectively positioned its medical education programs as “health care learning for the digital future.” However, this praise and online health care education success also drew its fair share of detractors. Faculty unions at medical programs and even other non-agent-driven online health care education programs criticized Cyber-Health for dehumanizing health care knowledge and medical education delivery.

The focus of your contribution to the newly formed D-LIT will be to highlight the potential of Cyber-Health’s e-business approach to complement Med Ed’s traditional health care education marketing strategy. Med Ed’s traditional marketing strategy relies on physical brick-and-mortar facilities, hard copy books and course resources, and human faculty instructors. In this traditional on-campus model, students attend physical classroom facilities for health care education, and traditional advertising media or promotional events are used to raise enrollment. By contrast, Cyber-Health’s online e-business education approach uses digital networks as the primary vehicle for delivering health care learning to students. By accessing the Cyber-Health Web site and med-teach agent, students directly engage in autonomous, self-guided medical education coursework without going to a physical classroom facility and without human instructors. The med-teach agents employ artificial intelligence to progressively learn each student’s health care instructional needs and improve the student’s performance through skill-intensive virtual course project scenarios covering every aspect of traditional medical education. President Learner is keenly interested in your assessment of this futuristic online e-business model for delivering health care educational programs.

The objectives:

Discuss the fundamentals of marketing and how they now apply to e-marketing.

Discuss the use of the marketing process in e-marketing.

Explain interactive marketing and electronic commerce.

Statistical Error: Expectations of success

Definition: The assumption, prediction, and expectation of a behavior, performance, or action that elicits a positive ability or outcome of an individual or group.

1. Provide a Human Resource decision that has to be made as an example to the statistical error expectations of success. Definition is provided above, give an example/scenario.

2. Errors typically occur because the data used to make the decision is flawed in some way. What flawed data could lead to the error for this decision?

3. Think about what data could be used instead (to avoid expectations of success)?

4. What parameter or statistic will you use to represent the dataset?

5. How could this help avoid the error?

Statistical Error: Stereotype threat

Definition: Follows from expectations of success. It is a situation in which people are or feel themselves to be at risk of conforming to stereotypes about their social group.

1. Provide a Human Resource decision that has to be made as an example to the statistical error stereotype threat. Definition is provided above, give an example/scenario.

2. Errors typically occur because the data used to make the decision is flawed in some way. What flawed data could lead to the error for this decision?

3. Think about what data could be used instead (to avoid stereotype threat)?

4. What parameter or statistic will you use to represent the dataset?

5. How could this help avoid the error?

Statistical Error: Ignoring context

Definition: The belief that performance is determined by the individual effort and neglects the tools, location, colleagues, and environment that allows someone to successfully perform.

1. Provide a Human Resource decision that has to be made as an example to the statistical error ignoring context. Definition is provided above, give an example/scenario.

2. Errors typically occur because the data used to make the decision is flawed in some way. What flawed data could lead to the error for this decision?

3. Think about what data could be used instead (to avoid ignoring context)?

4. What parameter or statistic will you use to represent the dataset?

5. How could this help avoid the error?

Statistical Error: Team interdependence

Definition: This captures the relationship between individual performance and team performance. When team interdependence is high, individual performance is strongly impacted by the performance of the members of the team.

1. Provide a Human Resource decision that has to be made as an example to the statistical error team interdependence. Definition is provided above, give an example/scenario.

2. Errors typically occur because the data used to make the decision is flawed in some way. What flawed data could lead to the error for this decision?

3. Think about what data could be used instead (to avoid team interdependence)?

4. What parameter or statistic will you use to represent the dataset?

5. How could this help avoid the error?

Please respond to each student and word count for each response 150 words with 2 scholarly sources and please cite sources.

Original question: In your own words, define what ERM actually is. Then, pick a scholarly work listed in Chapter 2 and briefly describe its philosophy and effects on the practices of ERM. Afterward, complete your Discuss post with a process you would implement into your organization that involved use of the Critical Steps for Value-Added Risk Management on pp. 47-48. Please use scholarly works to support your statements

Student 1 Juanita,

Enterprise Risk Management (ERM) is the process of identifying and strategically managing potential risks that may affect an organization (Fraser & Simkins, 2010). In comparison to traditional risk management, ERM is a comprehensive approach to risk management and focuses on managing all risks (Ogutu, Bennett, & Olawoyin, 2018). Likewise, Berry-Stolzle and Xu (2018, p. 159) add that ERM is a holistic approach to managing risk by “controlling and coordinating any offsetting risks.”

I have chosen James Lam’s, Emergence of the Chief Risk Officer (1997). In this article, Lam identifies three trends (broader dimensions of risk, the changing role of risk management, and regulatory oversight) that have driven organization’s to take a holistic approach when managing risk (Lam & Kawamoto, 1997). Likewise, Lam discusses the complexity of implementing a comprehensive risk management program. As stated by Lam and Kawamoto (1997), the amount of risk multinational organizations face, can threaten an organizations stability. Especially, in today’s global economy where it can be challenging to manage risk.

If I were to implement a process into my organization that used one of the critical steps for value-added risk management, I would first identify and list potential risks in terms of there impact on the enterprise and communicate my findings across business and risk functions. Next, I would break down the risks and establish risk management teams. Then, I would incorporate risk management into my regular strategic process and continually monitor, analysis and refresh risk information. Lastly, I would integrate an ERM strategy into the management system (Fraser & Simkins, 2010, p. 47-48).

Student 2 Connie,

Enterprise risk management (ERM) is defined as the all-inclusive approach to managing risks within an organization by setting objectives and strategies to overcome such risk. ERM involves all the management teams input from lower management to the board of directors and stakeholders. Each employee assumes responsibility for effective control practices of must acknowledge the importance of the risks related to their behavior. The awareness of risk must be made aware to all employees and the role that they play in minimizes risks taken (Braumann, 2018).

The scholarly work listed in Chapter 2 that I chose was Jeremy Bentham’s, the law of supply and demand. In a market economy, the law of supply and demand is a philosophy of the characteristics of prices established. Whenever there is a change in demand that increases due to a change in the price of a good, which results in a movement along the demand curve. Meanwhile, there is an opposite relationship between the quantity demanded and the price, so the variance of price would result in a decrease or increase in the amount demanded (Buechner, 2018). Therefore, in relations to enterprise risk management, the increase and/or decreases in prices could affect the amount demanded and in return affect the number of goods sold.

In reviewing the critical steps for value-added strategic risk management, the process that I would choose to implement within our agency would be using strategic risk assessments in developing strategy, strategic plans and strategic objectives (Fraser & Simkins, 2010). Through establishing interdisciplinary teams, leadership should contemplate how each strategy will motivate the organization to accomplish objectives, distribute funds and develop abilities These teams should be derived from a diverse group of individuals with the various skills and abilities (Lippuner & McDermott, 2017).

8 hours ago