IT 206 EXPERT TUTOR UOPHELP

1
IT 206 EXPERT TUTOR

• For more course tutorials visit
• www.uophelp.com

2
IT 206 EXPERT TUTOR

• IT 206 Entire Course

• IT 206 Week 1 CheckPoint Formatting Issues

• 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
• IT 206 Week 4 CheckPoint The Risk of Macros
• IT 206 Week 4 Assignment Microsoft Excel Exercise
• IT 206 Week 5 CheckPoint Mail Merging
• IT 206 Week 5 DQ 1 and DQ 2
• IT 206 Week 6 CheckPointAnalyzing Data
• IT 206 Week 6 Assignment Microsoft Access
  Exercise
• IT 206 Week 7 CheckPoint Other Uses for
  PowerPoint
• IT 206 Week 7 DQ 1 and DQ 2
• IT 206 Week 8 CheckPoint Pitfalls to a
  Presentation
• IT 206 Week 8 Assignment Microsoft PowerPoint
  Exercise
• IT 206 Week 9 capstone DQ
• IT 206 Week 9 Final Project Common Microsoft
  Office Errors
•  

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

3
IT 206 EXPERT TUTOR

• IT 206 Week 1 DQ 1 and DQ 2

• IT 206 week 2 Assignment Microsoft Word Exercise

•  
•  
• Microsoft Word provides keyboard combinations
  that can increase a users 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?
•  
• Microsoft Word provides the ability to set
  defaults allowing users to customize their style
  within their document. Explain how you would
  educate a customer on setting his or her own
  document style. What strategies would you advise
  to help the customer avoid common style problems?

•  
• 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.
• Correct any header and footer misspellings.
• Set margins at 1 inch.
• Wrap text around graphics.
• Insert page numbers within the header.
• Replace the existing date with 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.
•  
• Part II

4
IT 206 EXPERT TUTOR

• IT 206 Week 2 CheckPoint Knowing Where You Placed
  Your Document

• IT 206 Week 3 CheckPoint Simplifying Your Excel
  Usage

•  
•  
• 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 such misplacements? Explain your answer.

•  
• 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
  require the use of a macro. What are possible
  limitations using macros within Microsoft Excel
  and how would you convey this to a user?

5
IT 206 EXPERT TUTOR

• IT 206 week 3 DQ 1 and DQ 2

• IT 206 Week 4 Assignment Microsoft Excel Exercise

•  
• 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 originally analyzed? Explain your
  answer.
•  
• Microsoft Excels versatility allows users to
  analyze both qualitative and quantitative data.
  How does the versatility of Microsoft Excel
  affect application support

•  
• Assignment Excel Exercise Due Day 7
•  
• Complete the following tasks by using the
  Microsoft Excel document provided in Course
  Materials
•  
• Format appropriate cells for currency.
• Merge title cells.
• Construct a bar graph using the existing data and
  provide labels and a legend.
• Insert a border around data.
• Freeze the first colu

6
IT 206 EXPERT TUTOR

• IT 206 Week 4 CheckPoint The Risk of Macros

• IT 206 Week 5 CheckPoint Mail Merging

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

•  
• 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 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 application that has
  been changed from its original state? How does
  this affect the level of support required to
  facilitate Microsoft Access users? Explain your
  answer.

7
IT 206 EXPERT TUTOR

• IT 206 Week 5 DQ 1 and DQ 2

• IT 206 Week 6 Assignment Microsoft Access Exercise

•  
• 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.
•  
• Micosoft Access is often more efficient than
  Microsoft Excel when constructing databases.
  Explain why a customer using Microsoft Excel
  may want to use Microsoft Access as an
  alternative. How would you explain usage of data
  between both applications to users?
•  

•  
• 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
•  
• Student ID number
• First name
• Last name
• Gender
• Phone number

8
IT 206 EXPERT TUTOR

• IT 206 Week 6 CheckPointAnalyzing Data

• IT 206 Week 7 CheckPoint Other Uses for PowerPoint

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

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

9
IT 206 EXPERT TUTOR

• IT 206 Week 7 DQ 1 and DQ 2

• IT 206 Week 8 Assignment Microsoft PowerPoint
  Exercise

•  
• Discussion Questions Due Day 2 and 4
•  
• Microsoft PowerPoint is evolving graphically.
  How might this change the complexity of a
  presentation? Do you think Microsofts plug-ins
  enhance the effectiveness of its product? Why or
  why not?
•  
• 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.
•  

•  
• 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.
• Create a master slide with a logo, footer, and
  font.
• Add notes to each slide.
• Insert a graphic or picture.
• Implement a back

10
IT 206 EXPERT TUTOR

• IT 206 Week 8 CheckPoint Pitfalls to a
  Presentation

• IT 206 Week 9 capstone DQ

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

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

11
IT 206 EXPERT TUTOR

• IT 206 Week 9 Final Project Common Microsoft
  Office Errors

•  
• 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 such problems for users at
  beginning and intermediate skill levels. Each
  application support checklist must include the
  following
•  
• Summary of the application
• Five common errors for each application
• Strategies used to diagnose the errors for an
  array of different audiences
• Proposed support tactics to resolve the errors
  for different audiences
•  
• Create and submit a 10- to 15-slide Microsoft
  PowerPoint presentation to summarize your
  findings. The slideshow should resemble an actual
  presentation that co

12
IT 206 EXPERT TUTOR/UOPHELP
For more course tutorials visit www.uophelp.com