IT 206 Proactive Tutors/snaptutorial.com

1
IT 206 Proactive Tutors/snaptutorial.com
For more course Tutorials
www.snaptutorial.com
2
IT 206 Proactive Tutors/snaptutorial.com
IT 206 Week 1 CheckPoint Formatting Issues
IT 206 Entire Course
  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
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.   
3
IT 206 Proactive Tutors/snaptutorial.com
IT 206 Week 2 Assignment Microsoft Word Exercise
IT 206 Week 1 DQ 1 and DQ 2
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?
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. 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. o    Set the hanging indention for all
paragraphs at .25 inch.
4
IT 206 Proactive Tutors/snaptutorial.com
IT 206 Week 3 CheckPoint Simplifying Your Excel
Usage
IT 206 Week 2 CheckPoint Knowing Where You Placed
Your Document
  .     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.  
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 possible limitations using macros within
Microsoft Excel and how would you convey this
to a user?   
5
IT 206 Proactive Tutors/snaptutorial.com
IT 206 Week 4 Assignment Microsoft Excel Exercise
IT 206 Week 3 DQ 1 and DQ 2
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 affe
ct application support? Because of its
versatility, what assumptions must be made when
diagnosing and troubleshooting Microsoft Excel-b
ased problems?   
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. o    Sort the daily spending amounts in
ascending order
6
IT 206 Proactive Tutors/snaptutorial.com
IT 206 Week 5 CheckPoint Mail Merging
IT 206 Week 4 CheckPoint The Risk of Macros
.     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.   
.     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.  
7
IT 206 Proactive Tutors/snaptutorial.com
IT 206 Week 6 Assignment Microsoft Access Exercise
IT 206 Week 5 DQ 1 and DQ 2
.     Discussion Questions Due Day 2 and
4            Identify common Microsoft Access d
atabase terms. How would you explain them to
various MicrosoftAccess 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.  
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
8
IT 206 Proactive Tutors/snaptutorial.com
IT 206 Week 7 CheckPoint Other Uses for PowerPoint
IT 206 Week 6 CheckPointAnalyzing Data
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.  
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 p
resentation. How would these steps differ if the
presentation had a business orientation? What
features should be emphasized and why?   
9
IT 206 Proactive Tutors/snaptutorial.com
IT 206 Week 8 Assignment Microsoft PowerPoint
Exercise
IT 206 Week 7 DQ 1 and DQ 2
.     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.   
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. o    Insert a
graphic or picture. o    Implement a
background. o   
10
IT 206 Proactive Tutors/snaptutorial.com
IT 206 Week 9 capstone DQ
IT 206 Week 8 CheckPoint Pitfalls to a
Presentation
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.  
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.   
11
IT 206 Proactive Tutors/snaptutorial.com
IT 206 Week 9 Final Project Common Microsoft
Office Errors
Final Project Common MS Office Errors Due
Day 7            Create an application support
checklist for each Microsoft Office application
(Microsoft Word, MicrosoftExcel,
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   o    Summary of the application o   
Five common errors for

12
IT 206 Proactive Tutors/snaptutorial.com
For more course Tutorials
www.snaptutorial.com