it 206 tutorials real education / it206tutorials.com

21
IT 206 TUTORIALS Real Education / it206tutorials.com

Upload: veeru37

Post on 13-Apr-2017

205 views

Category:

Education


1 download

TRANSCRIPT

Page 1: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education / it206tutorials.com

Page 2: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Entire Course FOR MORE CLASSES VISITwww.it206tutorials.com

  IT 206 Week 1 CheckPoint Formatting IssuesIT 206 Week 1 DQ 1 and DQ 2IT 206 Week 2 CheckPoint Knowing Where You Placed Your DocumentIT 206 week 2 Assignment Microsoft Word Exercise

Page 3: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 1 CheckPoint Formatting Issues FOR MORE CLASSES VISITwww.it206tutorials.com

  1. CheckPoint: Formatting Issues – Due Day 5 · 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

Page 4: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 1 DQ 1 and DQ 2FOR MORE CLASSES VISITwww.it206tutorials.com

  1. Discussion Questions – Due Day 2 and 4 · 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?

Page 5: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 2 Assignment Microsoft Word Exercise

FOR MORE CLASSES VISITwww.it206tutorials.com

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.o Insert page numbers within the header.o Replace the existing date with the auto date function.

Page 6: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 2 CheckPoint Knowing Where You Placed Your DocumentFOR MORE CLASSES VISITwww.it206tutorials.com

  1. 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

Page 7: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 3 CheckPoint Simplifying Your Excel Usage

FOR MORE CLASSES VISITwww.it206tutorials.com

· 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?

Page 8: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 3 DQ 1 and DQ 2 FOR MORE CLASSES VISITwww.it206tutorials.com

· 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.

Page 9: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 4 Assignment Microsoft Excel Exercise

FOR MORE CLASSES VISITwww.it206tutorials.com

 1. Assignment: Excel® Exercise – Due Day 7 · Complete the following tasks by using the Microsoft® Excel® document provided in Course Materials:

Page 10: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 4 CheckPoint The Risk of Macros

FOR MORE CLASSES VISITwww.it206tutorials.com

· 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 to educate users of these risks once their dilemma is resolved? Aside from installing Microsoft®’s service packs, what types of support strategies should be utilized to ensure risks are minimized? Explain your answer.

Page 11: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 5 CheckPoint Mail Merging FOR MORE CLASSES VISITwww.it206tutorials.com

· 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 attributes of this product and how may it help the operations of an organization? How do third-party plug-ins change the process of diagnosing and troubleshooting errors within an application? What steps would you take in diagnosing an

Page 12: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 5 DQ 1 and DQ 2 FOR MORE CLASSES VISITwww.it206tutorials.com

 · 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.

Page 13: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 6 Assignment Microsoft Access Exercise

FOR MORE CLASSES VISITwww.it206tutorials.com

 o Create a database consisting of two tables.o Name both tables.o Create fields for each table. The first table must contain the following fields:

Page 14: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 6 CheckPoint Analyzing Data FOR MORE CLASSES VISITwww.it206tutorials.com

· 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.

Page 15: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 7 CheckPoint Other Uses for PowerPoint

FOR MORE CLASSES VISITwww.it206tutorials.com

· 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?

Page 16: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 7 DQ 1 and DQ 2 FOR MORE CLASSES VISITwww.it206tutorials.com

 . 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?

Page 17: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 8 Assignment Microsoft PowerPoint Exercise

FOR MORE CLASSES VISITwww.it206tutorials.com

 1. Assignment: MS PowerPoint Exercise – Due Day 7· Complete the following tasks using Microsoft® PowerPoint®:o Create a Microsoft® PowerPoint® presentation with at least six slides.o Make the topic of the presentation on how a support desk can communicate effectively with customers.

Page 18: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 8 CheckPoint Pitfalls to a Presentation

FOR MORE CLASSES VISITwww.it206tutorials.com

· 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.

Page 19: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 8 CheckPoint Pitfalls to a Presentation

FOR MORE CLASSES VISITwww.it206tutorials.com

· 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.

Page 20: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education

IT 206 Week 9 Final Project Common Microsoft Office Errors

FOR MORE CLASSES VISITwww.it206tutorials.com

  1. 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®)

Page 21: IT 206 TUTORIALS Real Education / it206tutorials.com

IT 206 TUTORIALS Real Education