CIS/211

OFFICE SOFTWARE SUPPORT FUNDAMENTALS

The Latest Version A+ Study Guide

**********************************************

CIS 211 Entire Course Link

https://hwsell.com/category/cis-211/

**********************************************

CIS 211 Week 1 Individual: Microsoft Word Exercise

Create a 2-page business proposal document in Microsoft Word addressing the following situation and requirements, making sure all points in the requirements section are covered.

Scenario: You have recently started employment at a small, but growing organization that lacks common software programs used for business. The organization currently does not have a word processing program and only uses freeware or other downloadable programs in writing business correspondence. Your new employer has asked you to gather information and write a business proposal encouraging executives to purchase and use Microsoft Word.

At minimum, add and address the following topics in your proposal:

• Include an introduction to your proposal.
• Include a table that addresses the advantages, disadvantages, and costs of using Microsoft Word.
• Insert an appropriate picture or video into the proposal illustrating the usefulness of Microsoft Word in the workplace. (Research online for this if needed)
• Include SmartArt or Charts to make the proposal more visually appealing than a standard paper.
• Include at least one paragraph describing the benefits and uses of Coauthoring and Collaboration that the organization might utilize with Microsoft Word.
• Include a conclusion as a final selling point to your audience.

Structure your response as a proposal rather than a research paper.

Follow APA formatting guidelines for any citations and references as needed.

Submit your Microsoft Word document to the Assignment Files tab.

CIS 211 Week 2 Individual: Microsoft Excel Lynda.com Exercise

Create the following charts based on the datasets in the exercise files in the Lynda.com video for this week. Required charts are listed below followed by the file name in the folder titled “2 An Overview of Chart and Graph Types” in the Exercise Files download section of the Lynda.com video.

• Column Chart – (2_1 Column.xlsx)
• Area Chart – (2-Area.xlsx)
• Pie Chart – (2-Pie.xlsx)
• Stock Chart – (2-Stocks.xlsx)
• Doughnut Chart – (Doughnut.xlsx)
• Radar Chart – (Radar.xlsx)

Combine the charts into one Excel file. You may separate the charts by tab/worksheet within the file.

Submit the completed Excel assignment to the Assignment Files tab.

CIS 211 Week 2 Individual: Microsoft Excel Troubleshooting Exercise

Develop an Excel application support checklist based on the learning team discussion points. This activity should be completed in Microsoft Exceland submitted as an Excel spreadsheet.

Fill in your spreadsheet with content for each of the five issues, symptoms, and resolutions.

Format your assignment as an Excel spreadsheet as follows:

• Use three columns (A,B,C).
• Format each column width to 50.
• Format all cells in these columns as text.
• Set all cells to Wrap Text.
• In the first row, merge and center all cells to create your title.

  • Bold text, Light Gray fill color for cell, and set text size to 16.

• In the second row, title your columns as follows in Bold text:

  • Issue (Column A)
  • Symptoms (Column B)
  • Resolution (Column C)

Submit your Excel spreadsheet to the Assignment Files tab.

CIS 211 Week 3 Individual: Microsoft PowerPoint Exercise

Create a 9- to 12-slide Microsoft PowerPoint presentation addressing the following situation and requirements based on Topics 1 and 2 in the learning team discussion, making sure all points in the requirements section are covered.

Scenario: You have convinced your new employer to adopt Microsoft Word and as a result, the company has purchased the Microsoft Office suite, which includes Microsoft PowerPoint. The organization would like to understand some of the benefits and functionalities of MicrosoftPowerPoint, as well as how it can be used to increase productivity.

At minimum, address the following core content in your presentation:

• Provide an overview of the general functions and features within MicrosoftPowerPoint.
• Provide specific examples of how Microsoft PowerPoint can be used to enhance productivity in the organization.
• Provide guidance on how one might use the online sharing and PowerPoint Web App.

Include the following formatting requirements in your presentation:

• At least one Table
• At least one Chart
• At least one Animation
• Slide Transitions for all slides in the presentation

Include speaker notes or a voice recording for all slides. Simply submitting slides is not sufficient.

Choose one of the following to add to your presentation:

• Record your voice over the presentation, and submit the file just as if you were giving the presentation
• Include detailed speaker notes for each slide with a transcript of what you would say

Submit your presentation to the Assignment Files tab when complete.

CIS 211 Week 3 Individual: Microsoft PowerPoint Presentation

Create a 6- to 9-slide Microsoft PowerPoint presentation (approximately 2 to 3 slides for each of the three issues and resolutions) that addresses Topic 3 as discussed in the learning team.

Include speaker notes or a voice recording for all slides. Simply submitting slides is not sufficient.

Choose one of the following to add to your presentation:

• Record your voice over the presentation, and submit the file just as if you were giving the presentation
• Include detailed speaker notes for each slide with a transcript of what you would say

Submit your presentation to the Assignment Files tab when complete.

CIS 211 Week 4 Individual: Application Support for Microsoft Outlook

Based on your learning team discussions, use Microsoft Outlook to draft responses to all four questions.

Include a response of at least 150 words for each question in a new message within Outlook.

• Question 1: I am thinking about purchasing and using Microsoft Outlook for my small business. Can you provide some insight and information as to how this can help me be more productive?
• Question 2: I have been trying to figure out how to organize my messages more efficiently. I just keep them in the inbox for now, but there are way too many and I can’t find older messages when I need to. Can you provide advice or tips on how to more appropriately organize my inbox?
• Question 3: When I start Outlook every day it takes so long to load. It goes through “Enabling Add-Ins” for at least 20 different programs. I can’t figure out how to get rid of some of these Add-Ins. Can you let me know? Also, can you think of anything else that might help speed up my Outlook?
• Question 4: At least twice per day, Outlook crashes at random times and I have to close/re-open it. Do you know what might be causing this or what I should check?

Place an appropriate subject in the e-mails.

Save each response as a separate e-mail in Outlook Message Format.

Submit the four e-mails to the Assignment Files tab.

CIS 211 Week 5 Individual: Office365™ Presentation

Based on your learning team discussion this week, create a presentation that is 5 to 10 slides (with speaker notes) based on the following scenario.

You work for an organization with about 300 employees. You are in charge of tool selection and procurement for office software. You research options and come to a decision that you will recommend Office365™ rather than standard copies of Office 2013 for your organization. You must convince the organization’s leaders that this is the best option.

Cover all of the following topics:

• Cost
• Differences in functionality & usability
• Features and updates
• Benefits of Cloud Computing
• Cloud storage options with Microsoft® OneDrive®

Submit your presentation to the Assignment Files tab.