IT 206 Read, Lead, Succeed/Uophelpdotcom

1
IT 206 Read, Lead, Succeed/Uophelpdotcom

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

2
IT 206 Entire Course

• For more course tutorials visit
• www.uophelp.com
•  
• 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

3
IT 206 Week 1 CheckPoint Formatting Issues

• For more course tutorials visit
• www.uophelp.com
•  
• 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.

4
IT 206 Week 1 DQ 1 and DQ 2

• For more course tutorials visit
• www.uophelp.com
•  
• 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?
•  

5
IT 206 week 2 Assignment Microsoft Word Exercise

• For more course tutorials visit
• www.uophelp.com
•  
• 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.

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

• For more course tutorials visit
• www.uophelp.com
•  
• 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.

7
IT 206 Week 3 CheckPoint Simplifying Your Excel
Usage

• For more course tutorials visit
• www.uophelp.com
•  
• 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?

8
IT 206 week 3 DQ 1 and DQ 2

• For more course tutorials visit
• www.uophelp.com
•  
• 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.

9
IT 206 Week 4 Assignment Microsoft Excel Exercise

• For more course tutorials visit
• www.uophelp.com
•  
• 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 column of the data set.

10
IT 206 Week 4 CheckPoint The Risk of Macros

• For more course tutorials visit
• www.uophelp.com
•  
• 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.

11
IT 206 Week 5 CheckPoint Mail Merging

• For more course tutorials visit
• www.uophelp.com
•  
• 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.

12
IT 206 Week 5 DQ 1 and DQ 2

• For more course tutorials visit
• www.uophelp.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.

13
IT 206 Week 6 Assignment Microsoft Access Exercise

• For more course tutorials visit
• www.uophelp.com
•  
• 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

14
IT 206 Week 6 CheckPointAnalyzing Data

• For more course tutorials visit
• www.uophelp.com
•  
• 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.

15
IT 206 Week 7 CheckPoint Other Uses for PowerPoint

• For more course tutorials visit
• www.uophelp.com
•  
• 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?

16
IT 206 Week 7 DQ 1 and DQ 2

• For more course tutorials visit
• www.uophelp.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 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.

17
IT 206 Week 8 Assignment Microsoft PowerPoint
Exercise

• For more course tutorials visit
• www.uophelp.com
•  
• 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.

18
IT 206 Week 8 CheckPoint Pitfalls to a
Presentation

• For more course tutorials visit
• www.uophelp.com
•  
• 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.

19
IT 206 Week 9 capstone DQ

• For more course tutorials visit
• www.uophelp.com
•  
• 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.

20
IT 206 Week 9 Final Project Common Microsoft
Office Errors

• For more course tutorials visit
• www.uophelp.com
•  
• 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.

21
IT 206 Read, Lead, Succeed/Uophelpdotcom

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