IT 206 TUTORIALS Real Success / it206tutorials.com

1
IT 206 TUTORIALS Real Success / it206tutorials.com
2
IT 206 TUTORIALS Real Success
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 Success
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
4
IT 206 TUTORIALS Real Success
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 Success
IT 206 Week 2 Assignment Microsoft Word Exercise
FOR MORE CLASSES VISIT www.it206tutorials.com  
1. Assignment MS Word Exercise Due Day 7
Part I Complete the following tasks by
using the Microsoft Word document provided
within Course Materials o Change the
document body to left alignment. o Correct any
header and footer misspellings.
6
IT 206 TUTORIALS Real Success
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?
7
IT 206 TUTORIALS Real Success
IT 206 Week 3 CheckPoint Simplifying Your Excel
Usage FOR MORE CLASSES VISIT www.it206tutorials.
com   1. 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
8
IT 206 TUTORIALS Real Success
IT 206 Week 3 DQ 1 and DQ 2 FOR MORE CLASSES
VISIT www.it206tutorials.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.
9
IT 206 TUTORIALS Real Success
IT 206 Week 4 Assignment Microsoft Excel
Exercise FOR MORE CLASSES VISIT www.it206tutori
als.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.
10
IT 206 TUTORIALS Real Success
IT 206 Week 4 CheckPoint The Risk of Macros
FOR MORE CLASSES VISIT www.it206tutorials.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
11
IT 206 TUTORIALS Real Success
IT 206 Week 5 CheckPoint Mail Merging FOR
MORE CLASSES VISIT www.it206tutorials.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
12
IT 206 TUTORIALS Real Success
IT 206 Week 5 DQ 1 and DQ 2 FOR MORE CLASSES
VISIT www.it206tutorials.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.
13
IT 206 TUTORIALS Real Success
IT 206 Week 6 Assignment Microsoft Access
Exercise FOR MORE CLASSES VISIT www.it206tutoria
ls.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.
14
IT 206 TUTORIALS Real Success
IT 206 Week 6 CheckPoint Analyzing Data FOR
MORE CLASSES VISIT www.it206tutorials.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
15
IT 206 TUTORIALS Real Success
IT 206 Week 7 CheckPoint Other Uses for
PowerPoint FOR MORE CLASSES VISIT www.it206tuto
rials.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
16
IT 206 TUTORIALS Real Success
IT 206 Week 7 DQ 1 and DQ 2 FOR MORE CLASSES
VISIT www.it206tutorials.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?
17
IT 206 TUTORIALS Real Success
IT 206 Week 8 Assignment Microsoft PowerPoint
Exercise FOR MORE CLASSES VISIT www.it206tutori
als.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.
18
IT 206 TUTORIALS Real Success
IT 206 Week 8 CheckPoint Pitfalls to a
Presentation FOR MORE CLASSES
VISIT www.it206tutorials.com   1. 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
19
IT 206 TUTORIALS Real Success
IT 206 Week 9 capstone DQ FOR MORE CLASSES
VISIT www.it206tutorials.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.
20
IT 206 TUTORIALS Real Success
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) using the information
21
IT 206 TUTORIALS Real Success