IT 206 UOP Course Tutorial / uophelp

1. it 206 uopCourse Tutorial For more course tutorials visit www.uophelp.com

2. it 206 uopCourse Tutorial IT 206 Entire Course IT 206 Week 1 CheckPoint Formatting Issues Consolidate all the sections of the Currency Conversion development documentation: menu selection, requirements, design, and testing. Incorporate any changes recommended by the instructor. Post the assignment as an attachment. • IT 206 Week 1 CheckPoint Formatting Issues • IT 206 Week 1 DQ 1 and DQ 2 • IT 206 Week 2 CheckPoint Knowing Where You Placed Your Document • IT 206 Week 2 Assignment Microsoft Word Exercise • IT 206 Week 3 CheckPoint Simplifying Your Excel Usage • IT 206 Week 3 DQ 1 and DQ 2

3. it 206 uopCourse Tutorial IT 206 Week 1 DQ 1 and DQ 2 IT 206 week 2 Assignment Microsoft Word Exercise Assignment: MS Word Exercise – Due Day 7 Part I Complete the following tasks by using the Microsoft® Word document provided within Course Materials: Change the document body to left alignment. • Microsoft® Word provides keyboard combinations that can increase a user’s efficiency. How can these shortcuts simplify the support process for Microsoft® Word? For those customers that solely use alternative methods of completing these tasks, how would you introduce these key combinations?

4. it 206 uopCourse Tutorial IT 206 Week 2 CheckPoint Knowing Where You Placed IT 206 Week 3 CheckPoint Simplifying Your Excel Usage CheckPoint: Simplifying Your Excel® Usage – Due Day 5 Write a 200- to 300-word response that answers the following: Based on the article by Lenning (2005), how is a macro utilized within Microsoft® Excel®? Name various business functions that • CheckPoint: Knowing Where You Placed Your Document – Due Day 5 • Write a 200- to 300-word response that answers the following: Customers often save their Word documents to unknown folders within their computers. What are some ways to search for recent .doc files using Microsoft® Word? What recommendations would you provide a user to minimize

5. it 206 uopCourse Tutorial IT 206 week 3 DQ 1 and DQ 2 IT 206 Week 4 Assignment Microsoft Excel Exercise Assignment: Excel® Exercise – Due Day 7 Complete the following tasks by using the Microsoft® Excel® document provided in Course Materials • Discussion Questions – Due Day 2 and 4 • What are some qualitative tools used to analyze data within 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 to analyze data in your spreadsheet. How was the data

6. it 206 uopCourse Tutorial IT 206 Week 4 CheckPoint The Risk of Macros IT 206 Week 5 CheckPoint Mail Merging CheckPoint: Mail Merging – Due Day 5 Write a 200- to 300-word response that explains the following: The article from Product News Network (2007) introduces 4TOPS, a mail merger that can be embedded within Microsoft® Access®. What are some key • CheckPoint: The Risk of Macros – Due Day 5 • Write a 200- to 300-word response that answers the following question: Based on the article by Lenning (2005), what is a primary security risk that users should acknowledge when using macros? Why is it important

7. it 206 uopCourse Tutorial IT 206 Week 5 DQ 1 and DQ 2 IT 206 Week 6 Assignment Microsoft Access Exercise Assignment: MS Access® Exercise – Due Day 7 Complete the following tasks using Microsoft® Access®: Create a database consisting of two tables. Name both tables. Create fields for each table. The first table must contain the following fields: • Identify common Microsoft® Access® database terms. How would you explain them to various Microsoft® Access® users with little database knowledge? How would the description of these terms vary depending on the experience level of the customer? How would you determine this experience level? Explain your answer.

8. it 206 uopCourse Tutorial IT 206 Week 6 CheckPointAnalyzing Data IT 206 Week 7 CheckPoint Other Uses for PowerPoint CheckPoint: Other Uses for PowerPoint® - Due Day 5 Write a 200- to 300-word response that answers the following questions: In his article from Computer Act!ve, Stevenson (2008) introduces an alternative use for Microsoft® PowerPoint®. List and explain the five steps to creating a basic Microsoft® PowerPoint® presentation. How would these steps differ if the presentation had a business orientation? What features should be emphasized and why? • CheckPoint: Analyzing Data – Due Day 5 • Write a 200- to 300-word response that answers the following questions: Based on the article by Samuels and Wood (2007), what are the five basic steps required for analyzing data using Microsoft®

9. it 206 uopCourse Tutorial IT 206 Week 7 DQ 1 and DQ 2 IT 206 Week 8 Assignment Microsoft PowerPoint Exercise Assignment: MS PowerPoint Exercise – Due Day 7 Complete the following tasks using Microsoft® PowerPoint®: Create a Microsoft® PowerPoint® presentation with at least six slides. Make the topic of the presentation on how a support desk can communicate effectively with customers. • Discussion Questions – Due Day 2 and 4 • Microsoft® PowerPoint® is evolving graphically. How might this change the complexity of a presentation? Do you think Microsoft®’s plug-ins enhance the effectiveness of its product? Why or why not?

10. it 206 uopCourse Tutorial IT 206 Week 8 CheckPoint Pitfalls to a Presentation IT 206 Week 9 capstone DQ Capstone Discussion Question – Due Day 3 Create a draft of an application support checklist for Outlook®. You should first identify and diagnose five frequent errors in Outlook®. Each error must then offer possible diagnosing strategies and troubleshooting tactics. Provide an alternative support approach for each error for customers who might be at a lower skill level. • CheckPoint: Pitfalls to a Presentation – Due Day 5 • Write a 200- to 300-word response that explains the following: Based on the article by Fontana (2008), what is the motivation for the pptPlex prototype Microsoft® is trying to implement in Microsoft® PowerPoint®? How might this affect existing Microsoft® PowerPoint® users and the level of support required by the software? Explain your answer.

11. it 206 uopCourse Tutorial IT 206 Week 9 Final Project Common Microsoft Office • Final Project: Common MS Office Errors – Due Day 7 • Create an application support checklist for each Microsoft® Office application (Microsoft® Word, Microsoft® Excel®, Microsoft® Access®, Microsoft® PowerPoint®, and Microsoft® Outlook®) using the information accumulated from your individual assignments from Weeks One through Nine. For each application, identify common user errors as well as provide a step-by-step strategy to diagnose and troubleshoot

12. it 206 uopCourse Tutorial For more course tutorials visit www.uophelp.com