• Step 1: Watch an instructional video on the BI software.
• Step 2: Review various BI Software options including Tableau; Excel or other Business Intelligence. Search the CTU Library and the internet to learn about optional software.
• Step 3: If you choose Tableau, download the Tableau BI software. After you select the link, look for the orange icon in the middle portion of your screen to begin the download or use any Business Intelligence software to create at least 2 graphs illustrating at least 2 comparisons between the US and zip code data.

Consider the following scenario, continued from the Unit 1 Individual Project:

Big D Incorporated needs to prepare an assessment regarding the feasibility of making a recommendation for expansion into another market. As the Business Analyst, your assignment is to prepare a short presentation for the Board of Directors that apply concepts learned in Unit 1 and concepts from Unit 2 to make the necessary recommendations and justifications for those recommendations. You will need to compare and contrast the varying markets in order to make the best recommendation possible. Complete the following:

• Click here to download the reports for the United States. The Web site provides free demographical services where one can choose from a variety of criteria and generate reports based on the U.S. Census data. This particular file contains 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the entire United States.
• Click here to download the reports for zip code 60614. This particular file contains 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the U.S. zip code 60614.
• Using all 4 demographic reports (General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary) for the United States and zip code 60614, prepare a 1-page memo explaining how your territory differs from the national profile. Feel free to note anything that you found surprising in this data.
• Use the business intelligence software you choose to depict information from these reports.
• Prepare a presentation of 5–6 slides of your major findings. You may group a category of data from the Total United States and zip code 60614, and create a graph to show how they differ. The presentation should have at least two graphs and a headline that summarizes a key takeaway from the graph. The last page should contain at least 3 questions that you would want answered based on what you’ve seen in this comparison.

Your presentation should include 5–6 slides in PowerPoint, plus title and reference slides with speaker notes (200–250 words per slide).

For assistance with the usage of Tableau for analysis and reporting, review and use the following instructions. This should be helpful if you are having problems with the software usage or with problems with the data.  But, you do not need to use Tableau. For BI software usage such as Excel, resort to using the Help functions and other resources on the internet and in videos to learn how to use Excel to create graphical presentations including table usage.

Instructions to Create Bar Graph in Tableau (optional) or in another BI Software.

1. Open the assignment CTU instructions.
2. Download Business Intelligence Software.
3. Create your Tableau Public Account.
4. Click the download link for the zip code (60614) file (file will open in Excel).
5. Click the download link for the US file (file will open in Excel).
6. The following are some options:
   1. Create separate demographical worksheets. For example: Education Attainment File  – Worksheet (include both Zip Code and U.S. data); Household Income (include Zip Code and U.S. data)
      • See a sample of the file available with column headings and extraneous blanks.

Household IncomeChicago U.S.198019901980 to 199020001990 to 20001980Median Household Income18,43841,2271.23669,3110.68116,902Average household Income24,24567,6071.788114,6150.69520,382Per Capita Income13,56438,5181.8463,7910.6567,321

• See a sample of the file available with column headings and extraneous blanks.

2000 Educational AttainmentU.S.ChicagoCollege: Associates Degree6.3%1.9%College: Bachelor’s Degree15.5%44.2%College: Graduate Degree8.9%34.0%College: Some College, no Degree21.1%8.7%School: 9th to 11th grade, no diploma12.1%3.2%School: Grade K-96.1%2.0%School: High School Graduate28.6%5.6%

1. Create a file with data organized without extraneous rows and columns but including headings.
2. The idea is to clean up the file before usage. Separating files and worksheets may be the best way to make this happen
3. Note in the real situation, when using BI software, you will want to ensure your data are clean and you have similar data in your files.
4. Save the file(s) on your computer.
5. Open Tableau. Then do a File > Open > Open your saved file.
6. At the bottom of the screen on the left, click on the little box next to Sheet 1 (looks like a bar graph with a plus in the top left corner).
7. Under Measures (on left), you should see Chicago and U.S. Click on U.S. and pull it into rows at the top of the screen. Then click on Chicago and pull it over into rows.
8. Under Dimensions on the left, you should see Household Income. Click on Household Income and pull it into column.
9. Now in the second column from the left, you should see measures.
10. In the top right corner, you should see a “show me” box illustrating ways you can view the data based on the values you have chosen. To do side-by-side comparisons, put your cursor over the rightmost picture on the third line with the side-by-side blue and orange bars. Click on it. Your graph should appear on the page. You can play around with how you want to portray your data.
11. To save in Tableau Public, click File > Save to Tableau Public as… > give the file a descriptive name. You will be asked to log into Tableau Public using your e-mail and password.
12. When your graph is saved in public, at the bottom right, there is a download button. Decide how you will save the file. (You can create an image and name the .png file. It will be saved in tableau public.)
13. After the file is saved, open the .png file, and edit or copy the graph.
14. Open your PowerPoint file, then paste (special) it on the slide. You can adjust the size.
15. Repeat the same in Tableau opening of any other prepped and cleaned file.

Note: Measure values are your number fields; measure names are the descriptors.

Please submit your assignment.

For more information on creating PowerPoint Presentations, please visit the Microsoft Office Applications Lab.

Additional Resources

American Marketing Association. (n.d.). Summary reports. Retrieved from http:/www.marketingpower.com/content753.php

Igines. (2012, December 9). How to make a line graph in Excel (Scientific data) [Video file]. Retrieved from https://www.youtube.com/watch?v=Xn7Sd5Uu42A

Microsoft. (2018). Create a chart from start to finish. Retrieved from https://support.office.com/en-us/article/Create-a-chart-from-start-to-finish-0baf399e-dd61-4e18-8a73-b3fd5d5680c2

References

Pak, A. (2013, August 12). Tableau Public – Overview and Applications [Video file]. Retrieved from http://youtu.be/PnkMiHocqRw

Tableau. (2018). Tableau public. Retrieved from http://www.tableausoftware.com/public/

For assistance with your assignment, please use your text, Web resources, and all course materials

For each of the two assignment, you will be responsible for watching a film, writing a 3 page  in which you respond to prompts (see below), and then providing a list of  “My Criteria for Quality in Film.”

THE PROCESS:

1.  Make any and all arrangements necessary to view the films and write about them: Some of the films may be available for streaming via Netflix or another online content provider; others may be available for checkout from your local public library, while others may need to be rented. You are better off watching these films on the largest possible screen, and at the highest possible resolution.

2.  Make Time to Complete the Assignment: Each assignment requires you to watch a film IN ADDITION to the ones you will be watching for the week’s discussion, so be sure to leave yourself enough time to: watch the film, think, write a first draft, edit and revise.

3.  Turn your assignments in by their respective due dates to the correct assignment folder in LEO.

THE CONTENT:

These assignments are reaction assignments, not plot summaries or research assignments. Write what you have to say about the film, not what others have said, but know how the film was made  The assignments will be graded based on:

a) Evidence that you are reading and viewing the course content, comparisons to other relevant films you have seen (in class and as a movie watcher); use of the film vocabulary introduced in class and college-level writing skills (spelling, punctuation, and grammar).

b) Clear presentation of your opinions and reasonable explanations and justifications to support those opinions: In a 100-level course, you would perhaps be asked to write about what you watched on the screen. In a 200-level course, you are being asked to say what you think about what you watched. In this 300-level course, you should explain why you think the way you do about the film, and then justify your opinions with explanations (using references found in the weekly content in the LEO classroom).

Be sure to correctly spell the names listed in the credits of directors, actors, screenwriters, and other people  (to avoid “points” being taken off of the final grade for that assignment).

These assignments are about your observations, insights and evaluations not only what you can learn by reading up on the film or the filmmaker. Do not just repeat what you find online. Think carefully before you write, be creative and apply what you have been learning in this course.

 Film One (F1)

Part 1: View a feature film made between 1940 – 1970 you have not seen before (or will see later in this class) by a great director. Many directors were active both before and after 1970 so make sure you see a pre-1970 FEATURE fiction film.

Suggestion: American directors such as  Frank Capra, George Cukor, John Ford, George Stevens, Preston Sturges, Billy Wilder, or William Wyler. Foreign directors such as Ingmar Bergman (Swedish), Luis Buñuel (Spanish), Claude Chabrol (French), Federico Fellini (Italian), Akira Kurosawa (Japanese), Lina Wertmuller (German) or the British team known as “The Archers” made up of Michael Powell and Emeric Pressburger. For other possibilities, try:  http://www.filmsite.org/directors.html  Comment on the specific film you saw in terms of its genre and the quality of the film itself.  Pay attention to the camerawork (cinematography) the editing (montage) and the sound (including music). What did you like and what did you dislike? Why do you like the things you like, and why do you dislike the things you dislike? Finally, is the film successful in creating a work of fiction using the craft of filmmaking and considering when it was made? (Note: This is not the same question as whether or not you liked it. It is entirely possible to like a film that you are aware is not very good.)

Part 2: Draw some general conclusions about the work of the director and one of the main actors or actresses. For example let us say you watched the 1962 film Lawrence of Arabia. Did you like David Lean as a filmmaker? Explain your answer. Did you like Peter O’Toole  in the role of Larwrence? Why, or why not?

End with your overall impression of the film, including how you see it as an example of the its genre and time period.  

PARTS ONE AND TWO SHOULD BE PRESENTED A assignment!

Part 3: On a separate page, insert the heading “My Criteria for Quality in Film.” Under that heading, propose four general statements indicative of your personal taste in movies. These statements should be numbered (1) through (4), and they should be written as complete sentences or a short paragraph. For example, if you commented in your assignment that you liked the acting because it was realistic and you liked the script because it had a happy ending, you could propose these two statements as criteria for quality: “(1) Excellent movies feature realistic acting. (2) A movie is more likely to be good if it ends happily.” Think about and then explain what words such as good, excellent, and effective actually mean. Be sure to save your “My Criteria” page to your hard drive—you will be resubmitting an expanded version of it with for the second assignment later in this course.

 Scenario

You are the Vice President of Human Resources at a local hospital. There has been a lot of turmoil in recent years due to leadership changes and downsizing accompanied by layoffs. The downsizing and layoffs were the result of an increase in uncompensated care due to a lack of health insurance. The layoffs have caused a decrease in morale and many department leads have also noticed a decrease in employee performance. The Board of Directors, the hospital’s CEO, and the entire executive team are in agreement that there is a need for major changes within the institution. You have been tasked with presenting a plan of action at the next board meeting.

Instructions

Deliverable 1

• Write an executive summary that describes the impact of leadership on employee performance and satisfaction, as well as communication challenges that leaders face, and challenges associated with trying to increase employee motivation, teamwork, and collaboration.
• Examine the literature relating to motivation, teamwork, collaboration, and conflict management.
• a. Discuss the role of leadership/management strategies that will help others respond to workplace challenges.
• b. Discuss the critical leadership skills needed to implement change.
• c. Recommend human resources strategies and practices that hospital department leaders could use to achieve optimal performance from employees.

Deliverable 2

• Create a voiceover PowerPoint presentation that summarizes the major challenges that leaders have in keeping employees motivated.
• a. Based on prior readings, identify one theoretical framework that you will use to guide your presentation.
• b. Include a minimum of three challenges that leaders have in keeping employees motivated.
• c. Include a minimum of one recommendation for each challenge identified in section 3b.

The Role of the RN/APRN in Policy Making

According to Milstead & Short, 2019, nurses are uniquely qualified to participate in the policy making process, particularly in relation to health care related policies, based on their education and experience.  The American Nurses Association (ANA) echoes these statements as well and even references the nurse duty to advocate for patient care which can certainly be done via the support of patient centric legislation (American Nurses Association, 2015).  When considering the challenges in the current healthcare environment, especially those related to COIVD-19, mental health and the deficient number of healthcare services available to most Americans, it makes sense to ask those on the frontlines of patient care to provide their voices to support the changes needed to improve the system and care for the most vulnerable in society. 

Registered Nurses can participate in policy making as it relates to their particular workplaces by becoming involved in nursing committees, clinical practice councils and the local chapter of their State nursing association (Ellenbecker et al., 2017). Nurse leaders can also draw on their experience to support and educate others outside of the healthcare environment (Clarke et al., 2013). A good example of this is nurses who speak to local city governments about the issues they see in their particular area expertise.  In fact, many nursing schools have recognized the importance of having nurses involved in policy making which is the reason why almost all national programs have a health policy component within their program.  A challenge that could arise, is the nurse’s inability to participate due to long work hours or personal commitments outside of work.  A way to address this challenge could be accomplished by having nurses team up and take turns attending meetings.  Also nurses who attend a meeting can gather information from their colleagues and by sharing their collective findings, all nurses will have an opportunity to voice their opinions.

Advanced Practice Registered Nurses (APRN) can influence policy by using their expert assessment and communication skills to advocate for certain populations, serve as a clinical leader at their place of employment and actively participate in their state’s professional nursing organizations specific to their own nursing specialty.  Other ways that APRNs can get involved in health policy is via the analysis of existing health policies, interpretation of research and active participation in regulatory processes. APRNs can also advocate for ethical policies, develop and evaluate policies and use their expertise to educate others (Ellenbecker et al., 2017).

Challenges that can arise for APRNs is the inability to convince others of the importance of participation in policy making activities.  People need to understand the connection between professional responsibility, nursing practice standards, high quality patient care and the healthcare policies that promote all three. Effective nurse leaders are those that can find ways to appeal to public citizens and legislators in order to gain support for policies that address healthcare disparities while also supporting and promoting changes to improve existing policies.

To become a better advocate of healthcare policy, nurses should focus on educating other nurses and the public about important healthcare issues.  One way this can be accomplished is by publishing journal articles and literature reviews for both local and national audiences. Another great way to advocate is by getting involved with professional nurse associations. This writer joined a regional Nurse Practitioner group and regularly received updates on pending legislation that needs to be supported. Nurse advocacy does not have to be complicated. Simple acts such as letter writing campaigns or simply signing a petition in support of an important issue can be very meaningful actions to influence policy making decisions.

Conduct an environmental scan and write an assessment in which you focus on both the internal and external factors that could affect your success within your chosen industry. 

Introduction

After an organization has completed a SWOT analysis, it will carefully monitor both the internal and external environments to detect signs of opportunities and threats that could affect current and future plans. This environmental scanning can help an organization identify trends that are most likely to affect the industry, thereby allowing the development of a strategy for change. The right information, at the right time, can determine the future of an organization.

Note: Developing a strategic plan requires specific steps that need to be executed in a sequence. The assessments in this course are presented in order and should be completed in sequence.

Conduct a personal strengths, weaknesses, opportunities, and threats (SWOT) analysis. In your analysis, consider the following:

Strengths

• What advantages do you have that others do not (skills, education, experience, certifications)?
• What achievements are you most proud of?
• What do you do better than anyone else?
• What do you think others would see as your strengths?
• Do you have special connections that others may not have?
• What personal resources do you have available?

Be sure to consider how others see you—not just how you see yourself.

Weaknesses

• Are there tasks you avoid doing because you do not feel confident doing them?
• Do you have any negative work habits (often late, disorganized, easily stressed)?
• Do you feel confident about your skills, experience, and education?
• Do you have any personality traits that might hold you back? For example, do you have a fear of public speaking, yet work where you are expected to conduct regular meetings?

Again, consider how others see you.

Opportunities

• Do you have a network of influential contacts that can help or offer advice?
• Is there a need in your company or industry that no one else has been able to fill?
• Are there trends in your company that you can use to your advantage?
• Can you offer solutions to problems within your company?

Threats

• What kind of obstacles are you facing at work?
• Are there co-workers/colleagues competing with you for positions or projects?
• Has the nature of your job changed?
• Does technology pose a threat to your position?
• Do any of your weaknesses pose a threat?
• What threats to your overall plan are there?

Once you have completed your SWOT analysis, identify strategies that you can use to capitalize on your strengths and open up opportunities, and address ways you can minimize areas of weakness and eliminate threats. Consider asking a trusted peer or friend to review your SWOT analysis and provide you with honest feedback. Analyze the feedback you receive and include that analysis in your assessment. Were there aspects of the feedback that surprised you?