IT 206 Tutorials / IT 206dotcom

1. IT 206 Tutorials / it206dotcom

2. IT 206 Entire Course IT 206 Tutorials 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 Write a 200- to 300-word response that answers the following: Based on the article by Nott (2008), what are some business uses for inserting a canvas within a Microsoft® Word document? From these uses, propose a strategy that may help users overcome formatting issues. IT 206 Week 1 CheckPoint Formatting Issues

3. IT 206 Week 1 DQ 1 and DQ 2 IT 206 Tutorials • 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? o Change the document body to left alignment. o Correct any header and footer misspellings. o Set margins at 1 inch. o Wrap text around graphics. IT 206 week 2 Assignment Microsoft Word Exercise

4. IT 206 Week 2 CheckPoint Knowing Where You Placed Your Document IT 206 Tutorials • 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 such misplacements? Explain your answer. • 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 require the use of a macro. What are possible limitations using macros within Microsoft® Excel® and how would you convey this to a user? IT 206 Week 3 CheckPoint Simplifying Your Excel Usage

5. IT 206 Tutorials • 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 originally analyzed? Explain your answer. o Insert a border around data. o Freeze the first column of the data set. o Sort the daily spending amounts in ascending order. o Using the Tools menu, set the Excel spreadsheet to be protected. IT 206 Week 4 Assignment Microsoft Excel Exercise • IT 206 week 3 DQ 1 and DQ 2

6. IT 206 Tutorials • 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 • 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®. IT 206 Week 5 CheckPoint Mail Merging • IT 206 Week 4 CheckPoint The Risk of Macros

7. IT 206 Tutorials • 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. You are working at a support desk for a company providing onsite and telephone support to customers with Microsoft® Access® questions. On this particular day, you are presented with the following three situations: IT 206 Week 6 Assignment Microsoft Access Exercise • IT 206 Week 5 DQ 1 and DQ 2

8. IT 206 Tutorials • 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® Access®? How could these steps help you diagnose and troubleshoot Microsoft® Access® errors? Which of the five steps presents the greatest possibility for user error and why? Explain your answer. • 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®. IT 206 Week 7 CheckPoint Other Uses for PowerPoint • IT 206 Week 6 CheckPointAnalyzing Data

9. IT 206 Tutorials • Microsoft® PowerPoint® provides features that assist developing various presentation styles. What are two features that must be used cautiously when creating a business presentation? What effect do these features have on an audience? Explain your answer. You are working at a support desk for a company providing onsite and telephone support to customers with Microsoft® PowerPoint® questions. On this particular day, you are presented with the following three situations: IT 206 Week 8 Assignment Microsoft PowerPoint Exercise • IT 206 Week 7 DQ 1 and DQ 2

10. IT 206 Tutorials • 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. • 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. IT 206 Week 9 capstone DQ • IT 206 Week 8 CheckPoint Pitfalls to a Presentation

11. IT 206 Tutorials • 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. • IT 206 Week 9 Final Project Common Microsoft Office Errors

12. IT 206 Tutorials