Information Systems homework help
CIS/211 Office Software Support Fundamentals
Copyright ©2017 by University of Phoenix. All rights reserved.
SYLLABUS
Course Description This course will prepare students to support Microsoft® Office applications. The student will learn the product features of Word, Excel®, PowerPoint®, and Outlook®. This course is based on the requirements of the Microsoft® Office Specialist certification.
Course Dates Feb 21, 2017 – Mar 27, 2017
Faculty Information
• Academic Policies • Instructor Policies University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality.
Academic Resources • Course Software
Instructions Click the link for additional course software requirements. Note: We do not recommend trial software versions because they expire. SupportingMaterial Course Software
• College of IS&T Resources Instructions Click the link to review the College of IS&T Resources. SupportingMaterial College of IS&T Resources
• College of IS&T Website Instructions Click the link to access the College of IS&T Website. SupportingMaterial College of IS&T Website
Get Ready for Class • Familiarize yourself with the textbook used in this course.
Instructions Beskeen, D., Cram, C., Duffy, J., Friedrichsen, L., and Reding, E., (2015). Enhanced Microsoft Office 2013: Illustrated Introductory, First Course (Microsoft Office 2013 Enhanced Editions). Boston, MA: Cengage.
Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents (both located on your student website):
Policies
JOHNNY BROOKS (PRIMARY)Name : Email Address : Phone Number : See Policies
Course Materials All electronic materials are available on your student website.
Week1 Feb, 21 – Feb, 27 Microsoft® Word
Tasks
1.1 Identify the functions of Microsoft® Word. 1.2 Perform various tasks using Microsoft® Word. 1.3 Diagnose and troubleshoot common problems encountered in Microsoft® Word.
Objectives/Competencies
Required Learning Activities • Lynda.com® Video Access
Click the link to access the Lynda.com® website. Search by title to find the specific video to view.
Instructions
• Read Me First
Read the course’s Read Me First document.
Read Me First Support Material
Instructions
• Word 2013: Unit A, Enhanced Microsoft Office 2013: Illustrated Introductory
Read Word 2013: Unit A, “Creating Documents with Word 2013,” in Enhanced Microsoft Office 2013: Illustrated Introductory.
Instructions
• Word 2013: Unit B, Enhanced Microsoft Office 2013: Illustrated Introductory
Read Word 2013: Unit B, “Editing Documents,” in Enhanced Microsoft Office 2013: Illustrated Introductory. Instructions
• Word 2013: Unit C, Enhanced Microsoft Office 2013: Illustrated Introductory
Read Word 2013: Unit C, “Formatting Text and Paragraphs,” in Enhanced Microsoft Office 2013: Illustrated Introductory.
Instructions
• Word 2013: Unit D, Enhanced Microsoft Office 2013: Illustrated Introductory
Read Word 2013: Unit D, “Formatting Documents,” in Enhanced Microsoft Office 2013: Illustrated Introductory. Instructions
• Lynda.com®: Word 2013
Watch the following sections in the Lynda.com® video titled “Word 2013 Essential Training with David Rivers”:
• Getting Started with Word • Editing Text • Formatting Text • Using Paragraph Formatting • Formatting Pages Support Material
Instructions
• Getting Started with VitalSource eBooks • Learning Team Collaborative Discussion Instructions
Lynda.com® Video Access
• Lynda.com®: Office 2013 New Features
Watch the section titled, “Word” in the Lynda.com® video, Office 2013 New Features with David Rivers.
Lynda.com® Video Access Support Material
Instructions
• Pluralsight: Word 2013 Fundamentals
Complete the following sections in the Pluralsight® module titled Word 2013 Fundamentals by Heather Ackmann:
• Introduction to Tables • Introduction to Pictures and Video • Introduction to SmartArt and Charts • Introduction to Coauthoring and Collaboration
Instructions
• Supporting Activity: Office 2013 Features
Based on the Lynda.com® video, “Office 2013 New Features”, share three ways you could apply these new features in a workplace setting.
Write a customer dialog for showing a customer how to use the new features you discovered.
Lynda.com®: Office 2013 New Features Support Material
Instructions
• Supporting Activity: Microsoft® Word Exercise
Complete the following tasks by using the Week 1 Individual document:
• Change the document body to left alignment. • Correct any header and footer misspellings. • Set margins at one inch. • Wrap text around graphics. • Insert page numbers within the header. • Replace the existing date by using the auto date function. • Set the hanging indention for all paragraphs at .25 inch. • Create a comment for the introductory paragraph. • Change bullet point styles. • Create a table of contents using the Table of Contents feature. Post your completed document with your reply. Discuss what was either easy or difficult for you while completing this exercise.
Week 1 Individual Document Support Material
Instructions
Assignments See the student website for additional recommended learning activities that may help you learn this week’s concepts.
Title Type Due Points
Week One Participation Instructions: Participate in class discussion.
Individual Feb 27, 2017 11:59 PM 4
Individual: 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.
SupportingMaterial:Pluralsight: Word 2013 Fundamentals
Individual Feb 27, 2017 11:59 PM 12
Week2 Feb, 28 – Mar, 06 Microsoft® Excel®
2.1 Identify the functions of Microsoft® Excel®. 2.2 Perform various tasks using Microsoft® Excel®. 2.3 Diagnose and troubleshoot common problems encountered in Microsoft® Excel®.
Objectives/Competencies
Required Learning Activities • Excel® 2013: Unit A, Enhanced Microsoft Office 2013: Illustrated Introductory
Read Excel® 2013: Unit A, “Getting Started with Excel® 2013,” in Enhanced Microsoft Office 2013: Illustrated Introductory.
Instructions
• Excel® 2013: Unit B, Enhanced Microsoft Office 2013: Illustrated Introductory
Read Excel® 2013: Unit B, “Working with Formulas and Functions,” in Enhanced Microsoft Office 2013: Illustrated Introductory.
Instructions
• Excel® 2013: Unit C, Enhanced Microsoft Office 2013: Illustrated Introductory
Read Excel® 2013: Unit C, “Formatting a Worksheet,” in Enhanced Microsoft Office 2013: Illustrated Introductory. Instructions
• Excel® 2013: Unit D, Enhanced Microsoft Office 2013: Illustrated Introductory
Read Excel® 2013: Unit D, “Working with Charts,” in Enhanced Microsoft Office 2013: Illustrated Introductory. Instructions
• Lynda.com®: Excel® 2013: Working with Charts and Graphs
Watch and complete the exercise files for the Lynda.com® video titled, “Excel 2013: Working with Charts and Graphs with Richard Harrington”. Note: Exercise files can be found within the Lynda.com® website. Click on the button that is labeled “Exercise files” above the video you are viewing, then click the file name in the pop-up box to download the files to your computer.
Lynda.com® Video Access Support Material
Instructions
• Supporting Activity: Analyzing Data
Write a short-answer response to the following:
• What are some qualitative tools used to analyze data in Microsoft® Excel®? • How do these tools assist users with their business decisions? • Provide an example from a past or current work experience when the use of these tools would have helped the outcome of your spreadsheet. • How was the data analyzed differently? Explain your answer.
Instructions
• Supporting Activity: Troubleshooting Startup Issues in Excel®
Write a short-answer response to the following:
• Describe how you might troubleshoot and resolve startup issues in Excel® (Freezing, Not Responding). • What are potential causes of these types of issues? Create a customer support dialog showing what you would say to help the customer troubleshoot and resolve the issue.
Instructions
• Learning Team Collaborative Discussion: Microsoft® Excel® Troubleshooting Exercise
Accumulate and diagnose, as a team, five frequent errors in Microsoft® Excel®. Discuss potential caused for each issue along with potential resolution(s). Note: This discussion will be used for your Week Two Application Support Checklist for Microsoft® Excel® paper due this week.
Instructions
Assignments See the student website for additional recommended learning activities that may help you learn this week’s concepts.
Title Type Due Points
Week Two Participation Instructions: Participate in class discussion.
Individual Mar 06, 2017 11:59 PM 4
Individual: 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.
SupportingMaterial:Lynda.com®: Excel® 2013: Working with Charts and Graphs
Individual Mar 06, 2017 11:59 PM 10
Individual: 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.
Individual Mar 06, 2017 11:59 PM 12
Week3 Mar, 07 – Mar, 13 Microsoft® PowerPoint®
3.1 Identify the functions of Microsoft® PowerPoint®. 3.2 Perform various tasks using Microsoft® PowerPoint®. 3.3 Diagnose and troubleshoot common problems encountered in Microsoft® PowerPoint®.
Objectives/Competencies
Required Learning Activities • PowerPoint® 2013: Unit A, Enhanced Microsoft Office 2013: Illustrated Introductory
Read PowerPoint® 2013: Unit A, “Creating a Presentation in PowerPoint® 2013,” in Enhanced Microsoft Office 2013: Illustrated Introductory.
Instructions
• PowerPoint® 2013: Unit B, Enhanced Microsoft Office 2013: Illustrated Introductory
Read PowerPoint® 2013: Unit B, “Modifying a Presentation,” in Enhanced Microsoft Office 2013: Illustrated Introductory.
Instructions
• PowerPoint® 2013: Unit C, Enhanced Microsoft Office 2013: Illustrated Introductory
Read PowerPoint® 2013: Unit C, “Inserting Objects into a Presentation,” in Enhanced Microsoft Office 2013: Illustrated Introductory.
Instructions
• PowerPoint® 2013: Unit D, Enhanced Microsoft Office 2013: Illustrated Introductory
Read PowerPoint® 2013: Unit D, “Finishing a Presentation,” in Enhanced Microsoft Office 2013: Illustrated Introductory.
Instructions
• Lynda.com®: PowerPoint® 2013 Power Shortcuts
Watch the following sections in the Lynda.com® video titled “PowerPoint 2013 Power Shortcuts with David Rivers”:
• Introduction • Top Ten Tips • Tips for Managing Your Files • Customizing the User Interface • Handy Keyboard and Mouse Shortcuts • Working with Text • Working with Media • Working with Objects and Animations • Sharing Presentations • Conclusion
Lynda.com® Video Access Support Material
Instructions
• Pluralsight: PowerPoint® 2013 Essentials
Complete the following sections in the Pluralsight® module titled PowerPoint® 2013 Essentials by Heather Ackmann:
• Creating a Table • Working with SmartArt • Working with Charts • Creating Slide Transitions
Instructions
• Working with Actions and Hyperlinks • Introduction to Animations • Working with Sound • Working with Video • Sharing Your Presentation
• Supporting Activity: PowerPoint® Animations Exercise
Complete the “Introduction to Animations” section in the Pluralsight® module titled PowerPoint® 2013 Essentials by Heather Ackmann. Create a simple PowerPoint® presentation with animations as described in the Pluralsight® course module. Post the presentation as a reply to this activity for discussion and reflection. Note: The PowerPoint® presentation should have at least one animation and one slide transition.
Instructions
• Supporting Activity: PowerPoint® Troubleshooting
Write a short-answer response to the following:
• List the steps one would take to perform a repair of a PowerPoint® 2013 installation. • What kinds of issues might one experience in which they need to do a repair? Create a customer dialog or script explaining to a customer how they would perform a PowerPoint® 2013 installation.
Instructions
• Learning Team Collaborative Discussion: Microsoft® PowerPoint® Exercise
Discuss, as a team, each of the topics below:
• Topic 1: Discuss the general functions, benefits, business value, and practical uses of Microsoft® PowerPoint®. • Topic 2: Discuss how tables, SmartArt, charts, transitions, and animations can improve a PowerPoint® presentation. • Topic 3: Research and discuss three common issues one might experience when using PowerPoint®, along with potential resolutions for each. Note: This will be used as a basis for your Week Three Individual Microsoft® PowerPoint® Presentation assignment.
Instructions
Assignments See the student website for additional recommended learning activities that may help you learn this week’s concepts.
Title Type Due Points
Week Three Participation Instructions: Participate in class discussion.
Individual Mar 13, 2017 11:59 PM 4
Individual: 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.
SupportingMaterial:Pluralsight: PowerPoint® 2013 Essentials
Individual Mar 13, 2017 11:59 PM 10
Individual: 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.
Individual Mar 13, 2017 11:59 PM 12
Week4 Mar, 14 – Mar, 20 Microsoft® Outlook®
4.1 Identify the functions of Microsoft® Outlook®. 4.2 Perform various tasks within Microsoft® Outlook®. 4.3 Diagnose and troubleshoot common problems encountered using Microsoft® Outlook®.
Objectives/Competencies
Required Learning Activities • Outlook® 2013: Unit A, Enhanced Microsoft Office 2013: Illustrated Introductory
Read Outlook® 2013: Unit A, “Getting Started with Email,” in Enhanced Microsoft Office 2013: Illustrated Introductory. Instructions
• Outlook® 2013: Unit B, Enhanced Microsoft Office 2013: Illustrated Introductory
Read Outlook® 2013: Unit B, “Managing Information Using Outlook®,” in Enhanced Microsoft Office 2013: Illustrated Introductory.
Instructions
• Pluralsight®: Outlook 2013 Fundamentals for Business Professionals
Complete the Pluralsight® module titled “Outlook 2013 Fundamentals for Business Professionals by Patricia Ciszek”. Instructions
• Lynda.com®: Outlook 2013 Power Shortcuts
Watch the following sections in the Lynda.com® video titled “Outlook 2013 Power Shortcuts with Gini Courter”:
• Introduction • Top Ten Power Shortcuts • Organizing Your Inbox • Managing Incoming Messages • Creating Emails and Replying to Them • Creating Special-Use Emails • Staying on Task • Tips for Calendars, Meetings, and Appointments • Working with Contacts • Miscellaneous Tips and Trick • Conclusion
Lynda.com® Video Access Support Material
Instructions
• Supporting Activity: Best Practices
Research tips and best practices for being more efficient in using Microsoft® Outlook®. Write a short-answer response to the following:
• Which of these tips do you think would be applicable to the highest number of users? Why? • Which one of these do you think would be used by the fewest number of users? Why? • Which one would be the most difficult for you to explain? Why?
Instructions
• Supporting Activity: Outlook® Troubleshooting
Write a short-answer response to the following:
• Describe some of the issues that can be caused by not properly managing the size of one’s Outlook® mailbox. • What are some ways to organize messages and clean up or reduce the size of one’s Outlook® mailbox? Create a customer dialog to help diagnose and resolve an Outlook® mailbox that is too full.
Instructions
• Learning Team Collaborative Discussion: Application Support for Microsoft® Outlook®
Assume that you are a support professional and must respond to the following questions from customers via email. Discuss with your team responses to the following four questions:
• 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? Note: This will be used for your Week Four Individual assignment.
Instructions
Assignments See the student website for additional recommended learning activities that may help you learn this week’s concepts.
Title Type Due Points
Week Four Participation Instructions: Participate in class discussion.
Individual Mar 20, 2017 11:59 PM 4
Individual: 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.
Individual Mar 20, 2017 11:59 PM 12
Week5 Mar, 21 – Mar, 27 Cloud Computing and Office365™
5.1 Identify the various features, advantages, and IT trends associated with Cloud Computing and Office365™.
Objectives/Competencies
Required Learning Activities • Cloud Appendix A, Enhanced Microsoft Office 2013: Illustrated Introductory
Read Cloud Appendix A, “Working in the Cloud,” in Enhanced Microsoft Office 2013: Illustrated Introductory. Instructions
• Pluralsight®: Cloud Computing: The Big Picture
Complete the Pluralsight® module titled “Cloud Computing: The Big Picture by David Chappell”. Instructions
• Pluralsight®: Office 365: Introduction to the Outlook Web App
Complete the Pluralsight® module titled “Office 365: Introduction to the Outlook Web App by Patricia Ciszek”. Instructions
• Pluralsight®: Office 365: Introduction to OneDrive for Business
Complete the Pluralsight® module titled “Office 365: Introduction to OneDrive for Business by Alan Wright”. Instructions
• Lynda.com®: Office365™
Watch the following sections of the Lynda.com® video “Learn Office 365™: The Basics with David Rivers”:
• About Office365™ • Working with the Outlook® Web App • Sharing and Collaboration • Connecting with Colleagues
Lynda.com® Video Access Support Material
Instructions
• Supporting Activity: Office365™ Exercise
Based on the Lynda.com® video “Up and Running with Office365™ with David Rivers”, discuss some issues that might arise using cloud software products versus locally installed programs. What are some drawbacks one might face in using Office365™? Write three action plan items or goals you will implement in the next 30 days to apply what you have learned about Office 365™.
Lynda.com®: Office365™ Support Material
Instructions
• Learning Team Collaborative Discussion: Office365™ Presentation
List and discuss key differences between Office 2013 and Office365™ in the following areas:
• Cost • Differences in functionality & usability • Features and updates • Benefits of Cloud Computing
Instructions
• Cloud storage options with Microsoft® OneDrive® Address the following:
• What are some other factors that may influence you to buy one or the other? Think about this from an organizational standpoint. Note: This discussion will be used for your Week Five Individual Assignment due this week.
Assignments See the student website for additional recommended learning activities that may help you learn this week’s concepts.
Title Type Due Points
Week Five Participation Instructions: Participate in class discussion.
Individual Mar 27, 2017 11:59 PM 4
Individual: 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.
Individual Mar 27, 2017 11:59 PM 12
All trademarks are property of their respective owners. University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries. Microsoft®, Windows®, and PowerPoint® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended to imply endorsement, sponsorship, or affiliation.
Trademark
Needs help with similar assignment?
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp Order Paper Now