IT 206 Slingshot Academy / snaptutorial.com

1
IT 206 Slingshot Academy / snaptutorial.com
The goal of higher education should be to
champion the airing of all honest viewpoints.
Nothing less is acceptable
For More Courses
Visit Now
www.snaptutorial.com
2
IT 206 Slingshot Academy / snaptutorial.com
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
3
IT 206 Slingshot Academy / snaptutorial.com
IT 206 Week 1 CheckPoint Formatting Issues
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 Slingshot Academy / snaptutorial.com
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?           
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 Slingshot Academy / snaptutorial.com
IT 206 Week 2 Assignment Microsoft Word Exercise
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. 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 Slingshot Academy / snaptutorial.com
IT 206 Week 2 CheckPoint Knowing Where You Placed
Your Document
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 Slingshot Academy / snaptutorial.com
IT 206 Week 3 CheckPoint Simplifying Your Excel
Usage
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? 
8
IT 206 Slingshot Academy / snaptutorial.com
IT 206 Week 3 DQ 1 and DQ 2
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 Slingshot Academy / snaptutorial.com
IT 206 Week 4 Assignment Microsoft Excel Exercise
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. o    Sort the daily spending amounts in
ascending order.
10
IT 206 Slingshot Academy / snaptutorial.com
IT 206 Week 4 CheckPoint The Risk of Macros
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 Slingshot Academy / snaptutorial.com
IT 206 Week 5 CheckPoint Mail Merging
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 Slingshot Academy / snaptutorial.com
IT 206 Week 5 DQ 1 and DQ 2
1.     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.
13
IT 206 Slingshot Academy / snaptutorial.com
IT 206 Week 6 Assignment Microsoft Access
Exercise
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
14
IT 206 Slingshot Academy / snaptutorial.com
IT 206 Week 6 CheckPointAnalyzing Data
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 Slingshot Academy / snaptutorial.com
IT 206 Week 7 CheckPoint Other Uses for
PowerPoint
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 p
resentation. How would these steps differ if the
presentation had a business orientation? What
features should be emphasized and why? 
16
IT 206 Slingshot Academy / snaptutorial.com
IT 206 Week 7 DQ 1 and DQ 2
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 Slingshot Academy / snaptutorial.com
IT 206 Week 8 Assignment Microsoft PowerPoint
Exercise
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. o    Insert a
graphic or picture.
18
IT 206 Slingshot Academy / snaptutorial.com
IT 206 Week 8 CheckPoint Pitfalls to a
Presentation
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 this affect
existing Microsoft PowerPoint users and the
level of support required by the software?
Explain your answer.
19
IT 206 Slingshot Academy / snaptutorial.com
IT 206 Week 9 capstone DQ
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 Slingshot Academy / snaptutorial.com
IT 206 Week 9 Final Project Common Microsoft
Office Errors
1.     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 each application
21
IT 206 Slingshot Academy / snaptutorial.com
The goal of higher education should be to
champion the airing of all honest viewpoints.
Nothing less is acceptable
For More Courses
Visit Now
www.snaptutorial.com