IT 206 Week 1 CheckPoint Formatting Issues

IT 206 Week 1 CheckPoint Formatting Issues

Click Here to Buy the Tutorial

http://www.studentandtutor.com/tutorials-12678-it206-it206-it-206-week-1-checkpoint-formatting-issues

For more course tutorials visit

http://www.studentandtutor.com/user/goaway-tutorial-posted

·       Consolidate all the sections of the Currency Conversion development documentation: menu selection, requirements, design, and testing.

·       Incorporate any changes recommended by the instructor.

·       Post the assignment as an attachment.

IT 206 Week 1 DQ 1 and DQ 2

IT 206 Week 1 DQ 1 and DQ 2

Click Here to Buy the Tutorial

http://www.studentandtutor.com/tutorials-12679-it206-it206-it-206-week-1-dq-1-and-dq-2

For more course tutorials visit

http://www.studentandtutor.com/user/goaway-tutorial-posted

·         Microsoft^® Word provides keyboard combinations that can increase a user’s 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?

IT 206 week 2 Assignment Microsoft Word Exercise

IT 206 week 2 Assignment Microsoft Word Exercise

Click Here to Buy the Tutorial

http://www.studentandtutor.com/tutorials-12684-it206-it206-it-206-week-2-assignment-microsoft-word-exercise

For more course tutorials visit

http://www.studentandtutor.com/user/goaway-tutorial-posted

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.

o   Set the hanging indention for all paragraphs at .25 inch.

o   Create a comment for the introductory paragraph.

o   Change bullet point styles.

o   Create a table of contents using the Table of Contents feature.

Part II

·         Read the following scenarios:

You are working at a support desk for a company providing onsite and telephone support to customers with Microsoft^® Word questions. On this particular day, you are presented with the following three situations:

Situation 1: A student, planning to attend a local college in the fall, has been told to purchase word processing software for an English class. He is currently looking to buy Microsoft^® Word, but he wants to know the major functions of this software.

Situation 2: A woman, who owns her own business, calls the support desk looking to create a Microsoft^® Word template for mail sent to customers. She wants each letter to look similar; she is also tired of cutting and pasting her company logo and contact information into each letter.

Situation 3: An employee working in the human resources department of your company is writing the Employee Handbook. He wants to insert various headers and footers in different sections of the handbook, but needs it all to be contained in a single Microsoft^® Word file. He tells you that he has already set section breaks within the handbook, but all headers and footers he has inserted are the same for all sections. He asks you why this is happening and how he can fix it.

·         Write a 1-page response for each of the three situations. Include the following in each response:

o    Identify a general approach for facilitating the customer over the telephone. What are possible challenges in the given situation? What strategies would help you overcome the challenges?

o    If causes to the problem or question described by the customer are unclear in the situation, explain how you would further diagnose the problem or question.

o    Once the causes are identified, describe a step-by-step troubleshooting process to help the customer complete the task.

If the customer has problems understanding your instructions, briefly explain an alternative solution.

IT 206 Week 2 CheckPoint Knowing Where You Placed Your Document

IT 206 Week 2 CheckPoint Knowing Where You Placed Your Document

Click Here to Buy the Tutorial

http://www.studentandtutor.com/tutorials-12681-it206-it206-it-206-week-2-checkpoint-knowing-where-you-placed-your-document

For more course tutorials visit

http://www.studentandtutor.com/user/goaway-tutorial-posted

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.

IT 206 Week 3 CheckPoint Simplifying Your Excel Usage

IT 206 Week 3 CheckPoint Simplifying Your Excel Usage

Click Here to Buy the Tutorial

http://www.studentandtutor.com/tutorials-12686-it206-it206-it-206-week-3-checkpoint-simplifying-your-excel-usage

For more course tutorials visit

http://www.studentandtutor.com/user/goaway-tutorial-posted

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?

IT 206 week 3 DQ 1 and DQ 2

IT 206 week 3 DQ 1 and DQ 2

Click Here to Buy the Tutorial

http://www.studentandtutor.com/tutorials-12688-it206-it206-it-206-week-3-dq-1-and-dq-2

For more course tutorials visit

http://www.studentandtutor.com/user/goaway-tutorial-posted

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^® Excel’s versatility allows users to analyze both qualitative and quantitative data. How does the versatility of Microsoft^® Excel^® affect application support? Because of its versatility, what assumptions must be made when diagnosing and troubleshooting Microsoft^® Excel^®-based problems?

IT 206 Week 4 Assignment Microsoft Excel Exercise

IT 206 Week 4 Assignment Microsoft Excel Exercise

Click Here to Buy the Tutorial

http://www.studentandtutor.com/tutorials-12693-it206-it206-it-206-week-4-assignment-microsoft-excel-exercise

For more course tutorials visit

http://www.studentandtutor.com/user/goaway-tutorial-posted

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.

o   Using the Tools menu, set the Excel spreadsheet to be protected.

o   Calculate the sum of the entire data set.

o   Calculate the average of the entire data set.

o   Delete any empty cells between the data cells to condense the data.

·       Read the following scenario:

You are working at a support desk for a company providing onsite and telephone support to customers with Microsoft^® Excel^® questions. On this particular day, you are presented with the following three situations:

Situation 1: A business professional wants to use Microsoft^® Excel^® to organize data for the monthly expense report. He has never used Microsoft^® Excel^® and is inquiring about the functions that would support him with this task.

Situation 2: A husband is having difficulties with his Microsoft^® Excel^®spreadsheet. He has been trying to track his monthly grocery spending to find the daily average he spends on food. The spreadsheet is organized by day, and for the days in which no groceries were purchased, he enters zero. He is seeking assistance to calculate the correct monthly average.

Situation 3: A local grocery store owner has created a spreadsheet containing the types of inventory she carries within the store. The spreadsheet contains 235 different kinds of inventory, defined by price, quantity on hand, ordered quantity, and category. She loses her placement every time she scrolls through the data set. She wants to know how to effectively scroll through the data sheet and manage this large data set.

·       Team-up with another student assigned by the facilitator.

·       Discuss how to diagnose and troubleshoot the situations.

·       Write a 1-page response for each of the three situations. Include the following in each response:

o   Identify a general approach for facilitating the customer over the telephone. What are possible challenges in the given situation? What strategies would help you overcome the challenges?

o   If causes to the problem or question described by the customer are unclear in the situation, explain how you would further diagnose the problem or question.

o   Once the causes are identified, describe a step-by-step troubleshooting process to help the customer complete the task.

o   If the customer has problems understanding or following your instructions, briefly explain an alternative solution.

·         Complete your written responses individually.