For first part of the final assignment, you will be creating and submitting the following files: a Word document and Excel spreadsheet and PowerPoint presentation.  Within these files, you will be utilizing a number of the features learned about this term in the course. 

Using the provided Microsoft Word file, you will be using various formatting and insertion techniques to make this document more visually appealing and useful.  Perform the following tasks on this file:

●  Apply an appropriate Title style to the document title

●  Use Heading styles on the various subtitles

●  Download and insert a picture into the document that corresponds with the topic in the document.  Resize the picture as needed to have it fit logically.

●  Change the line spacing in the document to 1.5

●  Convert the bolded text in the Multiple Intelligences section to a numbered list

●  Insert a 2×4 table in the Overview section and enter the following information:

Adult Online Learners by Age Group

25-29

13%

30-39

19%

40-99

19%

●  Merge the two cells in the first row.

●  Use the Find and Replace feature to find all instances of the word pedagogy and replace it with instruction

●  Insert the three links (on the last page) to your Google Docs, Google Calc, and Google Slides work in Part B

●  Be sure your name shows in the File Properties as the Author and name the file LastnameFirstname_WordFinal

Using the provided Microsoft Excel file, you will be utilizing many of the features learned this term to bring it more to life and make it more useful for an end user.  Perform the following tasks for this file:

●  Enter the following values below in cell range F3:H5

○   

90

14.99

1349.10

8

3.79

30.32

100

9.99

999.00

○  Adjust column widths as needed

●  Apply  the SUM function in cells F33 and H33.  Use F3:F32 and H3:H32 as your cells to add, respectively.

●  Merge and center the text in cell A1 across Columns A through E and apply the Heading 3 Style

●  Apply the Heading 4 cell style to the column headings in Row 2

●  Add the word “Total” to cells E33 and G33 (to the left of the SUM function, total amount shown)

●  Apply the Total Cell style to the cell range E33:H33

●  Apply the Currency [0] number format to cell ranges F3:H5

●  Apply the Comma [0] number format to the cell range F7:H32

●  Insert a Clustered Column Chart, to the right of the data set columns, that displays the total sales for any orders placed between 01/2015 and 05/2015. Set a Chart Title that makes sense for the data.

●  In Rows 34, 35 and 36 enter the labels Average, Max, Min respectively. In columns F, G, and H use the corresponding Average, Max, & Min functions accordingly for rows 3 through 32.

●  Rename the worksheet from Sheet 1 to DataSet

●  Insert a 3-D Pie Chart using the cell range H3:H33 and use the Move Chart feature to move it to a new worksheet of its own.  Label the new sheet PieChart.  Add a title that makes sense for the data.

●  Be sure your name shows in the File Properties as the Author and name the file LastnameFirstname_ExcelFinal

Starting with a blank Microsoft PowerPoint presentation, apply the different steps below to change the visual layout and flow of the presentation.  Perform the following tasks for this file:

●  Apply the “Organic” theme to the presentation

●  On slide 1, set the Title to “PowerPoint Basics” and the subtitle to “CS165 Final Project”

●  Insert a second slide be sure the slide layout is set to “Title and Content.”

○  Add the title “Adding Online Pictures” to the second slide

○  Insert an Online picture in the content area of slide 2 by doing a search for “Photography” and choosing a picture that matches the topic. Resize the picture to fit the space accordingly.

○  Add a “Fly In” Animation to the inserted picture with settings “From Bottom-Left and for a duration of “1 Second.”

●  Insert a third slide and set the slide layout to “Two Content.”

○  Add the title “How to use Bullet Points and SmartArt” to the third slide.

○  In the left pane add the following content for 3 bullet points:

■  How Much Content is Too Much?

■  Organizing Your Thoughts

■  Selecting the Right Graphics

○  In the right pane, add a SmartArt Graphic of your choice, in which you will display keywords from each of the bullet points added in the prior step.  Think about what style of SmartArt will best display this.

●  Insert a fourth slide and set the slide layout to “Title and Content.”

○  Add the title “Creating tables in PowerPoint”

○  In the Content section, add a 2×4 table, and populate it with the same content used in the Word table created earlier

○  Format the top row with a “Circle” Bevel effect and the bottom two rows with a “Cool Slant” Bevel effect.

●  Apply the “Wipe” Transition effect to all slides

●  Be sure your name shows in the File Properties as the Author and name the file LastnameFirstname_PowerPointFinal

***NOTE: Part B of this project continues on the next page***

Part B

Once you have completed building your project in Microsoft Office, you will now use G Suite to demonstrate your ability to work with collaborative features.

Task 1: Altering Your Word Document

●  Open Google Docs and upload your Microsoft Word document from Part A. 

●  Select the picture you inserted and right-click to insert a link to a website that might be relevant to the topic of adult learners.

●  Select two areas in your document where you made changes to the formatting or content during Part A, highlight those areas, and leave a comment about what you changed. 

●  Use the Word Count tool to find the number of words in the document, and type the total word count at the bottom of the document. 

●  Format your word count total with: 

○  Font size: 24

○  Font color: purple

○  Font: Cambria

○  Bold and underline

●  Rename your file LastnameFirstname_DocumentFinalGoogle

●  Share your document by selecting “Anyone with a grantham.edu address can EDIT, and  copy and paste the link into the bottom of your Word document in the provided box next to “Link #1”

Task 2: Importing Data and Formatting Your Excel Spreadsheet

●  Open Google Sheets and upload your Excel spreadsheet from Part A

●  Insert a new row underneath the column headers in row 2

●  In A3, use the NOW function to display the current date in month, day, year format (e.g. 07-04-2016).

●  Use conditional formatting to turn any total sales above $1,000 (column G) green. 

●  Use conditional formatting to turn any orders placed with Vance (column C) purple. 

●  Format the totals column with a solid green column border.

●  Set all 2015 sales data in columns A through G as protected, and set your spreadsheet to provide a warning if someone tries to edit the data.

●  Share your document by selecting “anyone with a grantham.edu address can EDIT”, and copy and paste the link into the bottom of your Word document in the provided box next to “Link #2”

●  Rename your Sheet to LastNameFirstName_SpreadsheetFinalGoogle

Task #3

●  Upload your PowerPoint from Part A into Google Slides

●  On Slide 2, add a text box at the bottom with “Click Here to Jump to Slide 4”

●  Highlight the text you just typed and create a slide-to-slide link to Slide 4

●  Create a new slide (slide 5)

●  On slide 5, import a YouTube video that gives tips on creating good presentations or speaking skills

●  Leave a comment on the title page listing what changes you made to the presentation after uploading it to Slides.

●  Share your document by selecting “anyone with a grantham.edu address can EDIT”, and copy and paste the link into the bottom of your Word document in the provided box next to “Link #3” 

●  Rename your presentation LastNameFirstName_PresentationFinalGoogle

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

For Extra Credit on the Unit 3 Writing Assignment, you may complete any of the following exercises from the textbook, Business Communication, 6th Edition. Each of the exercises will be worth 1-2% of extra credit on the writing assignment, for a maximum of 10% of Extra Credit on the Writing Assignment. Below, I have listed the exercises from each chapter that you may complete for extra credit. Please write the exercises as a Word Document and submit them with formatting and filenames according to the Syllabus.

Module 8

Question 8.10, #1, #7, #8, parts a-d on all

You may complete parts a-d on any/all of the three questions from 8.10 for 2% credit ea. (up to 6% total e.c.).

Module 12

12.8

12.13

12.17

12.19

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Case Study: Tesla Motors (in 2013): Will Sparks Fly in the Automobile Industry? Frank T. Rothaermel; Erin Zimmer CASE STUDY ATTACHED

Instructions:

Case Study Papers (Due Weeks Two – Seven)

We will cover six cases over six weeks. Each of these weeks you will turn in a six page paper, DUE SUNDAY, as follows: page 1-cover page, page 6-reference page; in other words you have to pages 2, 3, 4, and 5 to answer the following questions:

1.    Briefly, what is the case about?  No more than one paragraph!!!2.    Who are the primary decision makers?3.    Who are other affected stakeholders?4.    What is the primary set of problems/opportunities faced by the company in this case?5.    What is the real source of these problems/opportunities?6.    What do the financials tell you about the firm?7.    Who are it’s major competitors?  8.    Perform a brief SWOT analysis?9.    Does the company have a clear mission and vision statement?10.  What are the companies core values?  Do they represent the firm’s non-negotiable reason for being? 11.  How has the firm either achieved a competitive advantage from strategic Positioning or failed to achieve a competitive advantage?  More importantly, what would your recommend it do to maintain/create a sustainable competitive advantage?12.  Evaluate the company’s current leadership – effective or ineffective – why or why not?13.  Perform a five forces analysis?  Where does the firm stand in regards to:

• Threat of entry
• Threat of substitutes
• Bargaining power of suppliers
• Bargaining power of buyers
• Intra-Industry Rivalry

14.  What are the top priorities you would set for the firm?

You will not be able to answer all of these questions every week. Part of your grade will be based on choosing the right questions to answer for that case study. Moreover, over the course of the class you should not answer the same set of questions for each case.  (Note: Always answer questions 2, 5, and 14). 

Instructions:

Case Study Papers (Due Weeks Two – Seven)

We will cover six cases over six weeks. Each of these weeks you will turn in a six page paper, DUE SUNDAY, as follows: page 1-cover page, page 6-reference page; in other words you have to pages 2, 3, 4, and 5 to answer the following questions:

1.    Briefly, what is the case about?  No more than one paragraph!!!2.    Who are the primary decision makers?3.    Who are other affected stakeholders?4.    What is the primary set of problems/opportunities faced by the company in this case?5.    What is the real source of these problems/opportunities?6.    What do the financials tell you about the firm?7.    Who are it’s major competitors?  8.    Perform a brief SWOT analysis?9.    Does the company have a clear mission and vision statement?10.  What are the companies core values?  Do they represent the firm’s non-negotiable reason for being? 11.  How has the firm either achieved a competitive advantage from strategic Positioning or failed to achieve a competitive advantage?  More importantly, what would your recommend it do to maintain/create a sustainable competitive advantage?12.  Evaluate the company’s current leadership – effective or ineffective – why or why not?13.  Perform a five forces analysis?  Where does the firm stand in regards to:

• Threat of entry
• Threat of substitutes
• Bargaining power of suppliers
• Bargaining power of buyers
• Intra-Industry Rivalry

14.  What are the top priorities you would set for the firm?

You will not be able to answer all of these questions every week. Part of your grade will be based on choosing the right questions to answer for that case study. Moreover, over the course of the class you should not answer the same set of questions for each case.  (Note: Always answer questions 2, 5, and 14). 

Instructions:

Case Study Papers (Due Weeks Two – Seven)

We will cover six cases over six weeks. Each of these weeks you will turn in a six page paper, DUE FRIDAY, as follows: page 1-cover page, page 6-reference page; in other words you have to pages 2, 3, 4, and 5 to answer the following questions:

1.    Briefly, what is the case about?  No more than one paragraph!!!2.    Who are the primary decision makers?3.    Who are other affected stakeholders?4.    What is the primary set of problems/opportunities faced by the company in this case?5.    What is the real source of these problems/opportunities?6.    What do the financials tell you about the firm?7.    Who are it’s major competitors?  8.    Perform a brief SWOT analysis?9.    Does the company have a clear mission and vision statement?10.  What are the companies core values?  Do they represent the firm’s non-negotiable reason for being? 11.  How has the firm either achieved a competitive advantage from strategic Positioning or failed to achieve a competitive advantage?  More importantly, what would your recommend it do to maintain/create a sustainable competitive advantage?12.  Evaluate the company’s current leadership – effective or ineffective – why or why not?13.  Perform a five forces analysis?  Where does the firm stand in regards to:

• Threat of entry
• Threat of substitutes
• Bargaining power of suppliers
• Bargaining power of buyers
• Intra-Industry Rivalry

14.  What are the top priorities you would set for the firm?

You will not be able to answer all of these questions every week. Part of your grade will be based on choosing the right questions to answer for that case study. Moreover, over the course of the class you should not answer the same set of questions for each case.  (Note: Always answer questions 2, 5, and 14). 

CASE STUDY: WILL SPARKS FLY IN THE AUTOMOBILE 1. What is the case about?The case study is about Tesla Motors, which deals in electric vehicles in the US. It isattempting to make strides in the…

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Strengths factors that leverages the organizational performance

Weaknesses factors that will affect the health care organization (cost, quality, etc).

Opportunities factor that improve initiatives for the organization.

Threats factors that could negatively affect organizational performance.

A SWOT analysis is a strategic planning exercise used to evaluate an organization’s strengths, weaknesses, opportunities, and threats. The SWOT analysis should match the organization’s resources and capabilities to the competitive environment in which it operates. The analysis should help guide the organization’s formulation and selection of strategy. The SWOT analysis framework is often represented in a 2 x2 matrix. (See template below).

Using the health care company selected in week 2, help with no more than 8 slides with bullets and note pages that includes the following:

1. The first slide should include your completed SWOT diagram.
2. Identify a minimum of five (5) factors that affect the firm’s environment. You must include the internal and external environments (for example: resources, market, competitors, geographical, global) in each factor. Rate the top three (3) concerns, based on your professional experience. 
3. Assess and provide recommendations that will:Enhance the Strengths
4. Minimize the Weakness
5. Maximize the Opportunity, and
6. Overcome the Threat
7. Assume you are meeting with your internal or external stakeholders. Stakeholders Recommendation in which you:Provide a summary of your SWOT analysis to the stakeholder selected.
8. Provide three (3) recommendations.
9. Include two or more references to support your rationale.

Extra Credit (15 points): You may earn up to fifteen (15) points of extra credit for submitting a slide presentation that includes either a voice or video recording in which you present your SWOT Analysis. (This is in addition to submitting original deliverable requirements)

The specific course learning outcomes associated with this assignment are:

• Apply the health financial planning process and it’s components in financial management activities
• Analyze the principles of financial planning, management, and budgeting in the health care organization.
• Explain cost-setting methods and demonstrate how cost setting affects the revenue cycle.
• Use technology and information resources to research issues in health financial management.
• Write clearly and concisely about health financial management using proper writing mechanics.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

• Do you think the genre of the Western is slowly dwindling? Are the Western’s conventions showing up in other genres? Be sure to support your answer with specifics. 100 words

I would wager to say that what sold movies those old John Wayne movies were American values and manly characters.  With that in mind, and closing in on almost a century later, has anything changed since Wayne’s time?  Aren’t the box office hits still selling audiences on American values and manly characters? When considering your response, consider any of the box office hits of 2014 and 2015, how do they sell audiences on American values and manly characters? 100 words

 Class

Isn’t comedy relative?  Let’s be honest here, the humor of The Three Stooges variety… not really funny.  It is funny if you like your comedy being physical and simplistic and “innocent”.  

A movie like Legally Blonde is humorous because it is the story of the simpleton beating the “better” people at their own game.  Comedy does not have to be of the Stooges variety all the time or of the Andy Griffith variety, either.  Yes, there are plenty of examples of that sort of humor from Dumb and Dumber to Father of the Bride.  But, then there is also dark humor like Heathers or stoner humor like any of the Cheech and Chong movies or there’s obnoxious sophomoric humor like this is the End.  And then there is Queen Latifah in Taxi and Last Holiday… hilarious! Not all people will find all sorts of comedy humorous.  Luckily, there all types of comedies to pick from.    So, comedy… relative?  Ideas?  Thoughts? 100 words

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"