CIS 211 ENTIRE COURSE

CIS 211 ENTIRE COURSE | University Of Phoenix 

CIS 211   ENTIRE COURSE
 
 
WEEK  1

CIS 211 Week 1 Individual Assignment Microsoft® Word Exercise

Instructions: 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. 

WEEK  2

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

Instructions: 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 Assignment Microsoft® Excel® Troubleshooting Exercise

instructions: Develop an Excel® application support checklist based on the learning team discussion points. This activity should be completed in Microsoft® Excel® and 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.
  

WEEK  3

CIS 211 Week 3 Individual Assignment Microsoft® PowerPoint® Exercise

Instructions: 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 Microsoft® PowerPoint®, 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 Microsoft® PowerPoint®.
• 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 Assignment Microsoft® PowerPoint® Presentation

Instructions: 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.

WEEK  4

CIS 211 Week 4 Individual Assignment Production Costs 

Instructions: Purpose of Assignment The materials covered this week distinguish between the different costing methods and provides needed tools for decision making. This case study focuses on determining equivalent units in a production business setting. Assignment Steps Resources: Generally Accepted Accounting Principles (GAAP), U.S. Securities and Exchange Committee (SEC) Tutorial help on Excel® and Word functions can be found on the Microsoft® Office website. There are also additional tutorials via the web offering support for Office products. Scenario: Davis Skaros has recently been promoted to production manager. He has just started to receive various managerial reports, including the production cost report you prepared. It showed his department had 2,000 equivalent units in ending inventory. His department has had a history of not keeping enough inventory on hand to meet demand. He has come to you, very angry, and wants to know why you credited him with only 2,000 units when he knows he had at least twice that many on hand. Prepare a maximum 700-word informal memo and explain to Mr. Skaros why his production cost report showed only 2,000 equivalent units in ending inventory. Using a professional tone, explain to him clearly why your report is accurate. Format the assignment consistent with APA guidelines. Click the Assignment Files tab to submit your assignment

CIS 211 Week 4 Individual Assignment Application Support for Microsoft® Outlook®

Instructions: 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.

WEEK  5

CIS 211 Week 5 Individual Assignment Office365™ Presentation

Instructions: 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.