IT 206 TUTORIALS Absolute Tutors/ it206tutorials.com

1
IT 206 TUTORIALS Real Education /
it206tutorials.com
2
IT 206 TUTORIALS Real Education
IT 206 Entire Course FOR MORE CLASSES
VISIT www.it206tutorials.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
3
IT 206 TUTORIALS Real Education
IT 206 Week 1 CheckPoint Formatting Issues FOR
MORE CLASSES VISIT www.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
4
IT 206 TUTORIALS Real Education
IT 206 Week 1 DQ 1 and DQ 2 FOR MORE CLASSES
VISIT www.it206tutorials.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?
5
IT 206 TUTORIALS Real Education
IT 206 Week 2 Assignment Microsoft Word Exercise
FOR MORE CLASSES VISIT www.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.
6
IT 206 TUTORIALS Real Education
IT 206 Week 2 CheckPoint Knowing Where You
Placed Your Document FOR MORE CLASSES
VISIT www.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
7
IT 206 TUTORIALS Real Education
IT 206 Week 3 CheckPoint Simplifying Your Excel
Usage FOR MORE CLASSES VISIT www.it206tutorials.co
m 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 TUTORIALS Real Education
IT 206 Week 3 DQ 1 and DQ 2 FOR MORE CLASSES
VISIT www.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.
9
IT 206 TUTORIALS Real Education
IT 206 Week 4 Assignment Microsoft Excel
Exercise FOR MORE CLASSES VISIT www.it206tutorial
s.com   1. Assignment Excel Exercise Due
Day 7 Complete the following tasks by
using the Microsoft Excel document provided in
Course Materials
10
IT 206 TUTORIALS Real Education
IT 206 Week 4 CheckPoint The Risk of Macros FOR
MORE CLASSES VISIT www.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 Microsofts service packs, what types
of support strategies should be utilized to
ensure risks are minimized? Explain your answer.
11
IT 206 TUTORIALS Real Education
IT 206 Week 5 CheckPoint Mail Merging FOR MORE
CLASSES VISIT www.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
12
IT 206 TUTORIALS Real Education
IT 206 Week 5 DQ 1 and DQ 2 FOR MORE CLASSES
VISIT www.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.
13
IT 206 TUTORIALS Real Education
IT 206 Week 6 Assignment Microsoft Access
Exercise FOR MORE CLASSES VISIT www.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
14
IT 206 TUTORIALS Real Education
IT 206 Week 6 CheckPoint Analyzing Data FOR
MORE CLASSES VISIT www.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.
15
IT 206 TUTORIALS Real Education
IT 206 Week 7 CheckPoint Other Uses for
PowerPoint FOR MORE CLASSES VISIT www.it206tutori
als.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?
16
IT 206 TUTORIALS Real Education
IT 206 Week 7 DQ 1 and DQ 2 FOR MORE CLASSES
VISIT www.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 Microsofts plug-ins
enhance the effectiveness of its product? Why or
why not?
17
IT 206 TUTORIALS Real Education
IT 206 Week 8 Assignment Microsoft PowerPoint
Exercise FOR MORE CLASSES VISIT www.it206tutorial
s.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.
18
IT 206 TUTORIALS Real Education
IT 206 Week 8 CheckPoint Pitfalls to a
Presentation FOR MORE CLASSES VISIT www.it206tuto
rials.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.
19
IT 206 TUTORIALS Real Education
IT 206 Week 8 CheckPoint Pitfalls to a
Presentation FOR MORE CLASSES VISIT www.it206tuto
rials.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.
20
IT 206 TUTORIALS Real Education
IT 206 Week 9 Final Project Common Microsoft
Office Errors FOR MORE CLASSES
VISIT www.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)
21
IT 206 TUTORIALS Real Education