IT 206 CART Become Exceptional/it206cart.com

1
IT 206 CART Become Exceptional/it206cart.com

• FOR MORE CLASSES VISIT
• www.it206cart.com

2
IT 206 Entire Course FOR MORE CLASSES
VISIT www.it206cart.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 CLASSES VISIT www.it206cart.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 issues.
4
IT 206 Week 1 DQ 1 and DQ 2 FOR MORE CLASSES
VISIT www.it206cart.com 1. Discussion
Questions Due Day 2 and 4
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?
5
IT 206 Week 2 Assignment Microsoft Word Exercise
FOR MORE CLASSES VISIT www.it206cart.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
provide a user to minimize such misplacements?
Explain your answer.
6
IT 206 Week 2 CheckPoint Knowing Where You Placed
Your Document FOR MORE CLASSES
VISIT www.it206cart.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 provide a user to
minimize such misplacements? Explain your answer.
7
IT 206 Week 3 CheckPoint Simplifying Your Excel
Usage FOR MORE CLASSES VISIT www.it206cart.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 CLASSES
VISIT www.it206cart.com . 1. 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? Because of its versatility,
what assumptions must be made when diagnosing and
troubleshooting Microsoft Excel-based problems?
9
IT 206 Week 4 Assignment Microsoft Excel
Exercise FOR MORE CLASSES VISIT www.it206cart.com
1. Assignment Excel Exercise Due Day
7 Complete the following tasks by
using the Microsoft Excel document provided in
Course Materials o Format appropriate cells
for currency. o Merge title cells. o
Construct a bar graph using the existing data and
provide labels and a legend. o Insert a border
around data. o Freeze the first column of the
data set.
10
IT 206 Week 4 CheckPoint The Risk of Macros FOR
MORE CLASSES VISIT www.it206cart.com 1.
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
CLASSES VISIT www.it206cart.com 1.
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 CLASSES
VISIT www.it206cart.com 1. Discussion
Questions Due Day 2 and 4 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?
13
IT 206 Week 6 Assignment Microsoft Access
Exercise FOR MORE CLASSES VISIT www.it206cart.com
1. Assignment MS Access Exercise Due
Day 7 Complete the following tasks
using Microsoft Access 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
Student ID number First name
14
IT 206 Week 6 CheckPoint Analyzing Data FOR MORE
CLASSES VISIT www.it206cart.com   1.
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 CLASSES VISIT www.it206cart.
com 1. 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 CLASSES
VISIT www.it206cart.com 1. 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 CLASSES VISIT www.it206cart.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. o
Create a master slide with a logo, footer, and
font. o Add notes to each slide.
18
IT 206 Week 8 CheckPoint Pitfalls to a
Presentation FOR MORE CLASSES VISIT www.it206cart
.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 CLASSES
VISIT www.it206cart.com 1. 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 CLASSES VISIT www.it206cart
.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) 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
21
IT 206 CART Become Exceptional/it206cart.com

• FOR MORE CLASSES VISIT
• www.it206cart.com