it 206 cart Invent Youself/it206cartdotcom

1
it 206 cart Invent Youself/it206cartdotcom

• 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 IT
206 Week 5 DQ 1 and DQ 2
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.co
m   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?
9
IT 206 Week 4 Assignment Microsoft Excel
Exercise FOR MORE CLASSES VISIT www.it206cart.co
m   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.
Microsoft 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.co
m   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 Last name Gender
Phone number Address Major
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.co
m   . 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 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 Invent Youself/it206cartdotcom

• FOR MORE CLASSES VISIT
• www.it206cart.com