Ask Computer Engineering Expert

Assignment

Using Microsoft Excel or other spreadsheet tools is essential to tracking, storing, reading, and learning from data. It is used by businesses every day to spot trends, issues, growth patterns, and risks. As you saw in the Strayer Story last week and the Strayer Talk this week, Deidre Jefferies uses Excel to create spreadsheets she sends to potential and current clients, to track inventory and pricing, and to set goals and see potential areas for improvement within the business.

In this Challenge, you will use Microsoft Excel to outline the steps you would take to implement your plan to solve your problem, and to outline the costs that will be involved in your plan. Additionally, you'll use basic functions to analyze your plan. You will format your worksheets to make them easy to work with as well.

Follow the steps below to create your Implementation Plan and Costs Chart for your plan to solve your identified problem. [If you don't remember how to operate these functions in Microsoft Excel, refer back to TestOut, the course material, your instructor, or Google it!] Completed sample versions of the Implementation Plan (Sheet 1) and Costs Chart (Sheet 2) are included here below the rubric for your reference.

Instructions:

1. Create and title your workbook. Save at firstname_lastname_Challeng3_CIS105.xlsx

1. Create a new workbook using Microsoft Excel.

2. Create two sheets inside the workbook and title them "Implementation Plan" and "Costs Chart". You can name the sheets by right clicking the tab at the bottom of the sheet and choosing "Rename."

3. It's also a good idea to put this title at the top of your spreadsheets in Cell A1, then use "merge and center" on the home ribbon when you are finishing your formatting. This will center your title at the top of your work and make the printed version (if you choose to print out your workbook) look more professional.

2. Create your Implementation Plan and Timeline on Sheet #1.

Regardless of what problem you are trying to solve, a plan is only as good as the effort taken to think through its steps.

1. Create labels as shown on the sample in the first three columns of this worksheet; one titled "STEPS," one titled "TARGET COMPLETION DATES," and the last titled "TIME ESTIMATES."

STEPS

i) List each major step you would need to complete under the "STEPS" column. Bold the font of each step. Customize these to fit your actual ideas (don't just label them "Step 1", "Step 2", etc. like in the sample) and be descriptive of what each step is. For example, "Painting", "Baking", "Writing", etc. Add additional rows as needed.

ii) List at least two actions you need to take for each major step. Again, be descriptive (don't just label them "Action 1", "Action 2", etc. like in the sample)

TARGET COMPLETION DATES

i) List the target deadline for each major step and action under the "TARGET COMPLETION DATES" column. Note that completion dates for the major step should be equal to the last date of the action within that step that will take the longest. Use DD/MM/YYYY format for your target deadlines (ex: 01/31/2017)

TIME ESTIMATES

i) List a time estimate (in hours) for each major step under the "TIME ESTIMATES" column.

ii) Calculate the total time estimate for your entire implementation plan at the bottom of this column as shown in the example.

2. Add formatting such as color, borders, centering, bolding, etc. to make your sheet more visually appealing and easier to read.

3. Create a Costs chart on Sheet #2.

Even if the problem you chose was personal, there are likely going to be some costs associated with solving it.

1. First, create headers for two columns; one titled "ITEM" and one titled "COSTS."

2. List each of the major items or factors you would need for your solution (i.e. your own and others' time, equipment, transportation, products, etc.) under the "ITEM" column. You'll need approximately 5-15 items total. If you have fewer than 5 items, break these down into smaller sub-items. If you have more than 15 items, consolidate similar items. Be descriptive here and adjust the width of your columns as needed.

3. Include a realistic cost estimate for each of the items involved in your plan under the "COSTS" column.

4. Add a third column labeled "Comment" and comment on each of the costs, explaining how you came up with that cost. These notes to yourself are very helpful when you look back on an older spreadsheet, and also help explain to others why things are on the sheet.

5. Add up the total costs using the Sum function. Remember to start all function cells with an equal sign (=).

6. Next, add an "Average" label and calculate the average cost of the item costs you've identified for your plan. This way, you can easily see if each cost is larger or smaller than the average.

7. Add a "Lowest" label next, and calculate the smallest of your costs. This might come in handy to show you which item you can easily knock out first. Use the MIN function here.

8. Add a "Highest" label after this, to show which item is the largest cost. You'd be surprised how useful this label can be when you have a lot of data to sift through. Use the MAX function here.

9. Test your data by putting in some random numbers. Make sure your MIN and MAX functions are working correctly by changing one of the values to a small number and one to a large number. Add up all of the figures on a calculator or use all "1's" and count them to make sure the sum and average functions are working correctly. After you test your formulas, enter the real data.

10. Create a pie chart graphic that shows a breakdown of the percentages of each cost area by using the layout functions. The pie chart is used to represent percentages of the whole. It allows you to see at a glance how much of your total cost is represented by each individual cost. Insert the pie chart as an object in the sheet. Click on one of the pie labels once and select the Enlarge button shown here to make the pie chart large enough to read (size 12-14 font recommended). Right-click on the label and select "Format Data Labels". When you see the panel options, set them as "percentage". Uncheck the "Value" option, and ensure that the "Percentage" option is checked. If you have a lot of labels, be sure to check the "Show Leader Lines" option, see Format Data Labels options.

11. Merge and Center the title at the top of your spreadsheet just as you did in Sheet #1.

4. Format and save your workbook.

1. Change the font for all dollar amounts to a new font that you feel is clean and easy to read in spreadsheet format.

2. Add professional-looking color to some of the font in the sheet (For example, the titles or headers). Remember, the goal is to make your workbook easier to read. So you wouldn't want to use light yellow fonts, for example, because they would be hard to see against a white background.

3. Be sure to spell check your workbook to check for any typos or errors.

4. Re-save your file. Again, the correct file naming convention is: firstname_lastname_Challenge3_CIS105.xlsx

The specific course learning outcomes associated with this challenge are:

1. Use basic application software.
2. Create a digital solution for an identified business problem.
3. Use technology in a professional and ethical manner within real world contexts.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M92425493
  • Price:- $60

Priced at Now at $60, Verified Solution

Have any Question?


Related Questions in Computer Engineering

Does bmw have a guided missile corporate culture and

Does BMW have a guided missile corporate culture, and incubator corporate culture, a family corporate culture, or an Eiffel tower corporate culture?

Rebecca borrows 10000 at 18 compounded annually she pays

Rebecca borrows $10,000 at 18% compounded annually. She pays off the loan over a 5-year period with annual payments, starting at year 1. Each successive payment is $700 greater than the previous payment. (a) How much was ...

Jeff decides to start saving some money from this upcoming

Jeff decides to start saving some money from this upcoming month onwards. He decides to save only $500 at first, but each month he will increase the amount invested by $100. He will do it for 60 months (including the fir ...

Suppose you make 30 annual investments in a fund that pays

Suppose you make 30 annual investments in a fund that pays 6% compounded annually. If your first deposit is $7,500 and each successive deposit is 6% greater than the preceding deposit, how much will be in the fund immedi ...

Question -under what circumstances is it ethical if ever to

Question :- Under what circumstances is it ethical, if ever, to use consumer information in marketing research? Explain why you consider it ethical or unethical.

What are the differences between four types of economics

What are the differences between four types of economics evaluations and their differences with other two (budget impact analysis (BIA) and cost of illness (COI) studies)?

What type of economic system does norway have explain some

What type of economic system does Norway have? Explain some of the benefits of this system to the country and some of the drawbacks,

Among the who imf and wto which of these governmental

Among the WHO, IMF, and WTO, which of these governmental institutions do you feel has most profoundly shaped healthcare outcomes in low-income countries and why? Please support your reasons with examples and research/doc ...

A real estate developer will build two different types of

A real estate developer will build two different types of apartments in a residential area: one- bedroom apartments and two-bedroom apartments. In addition, the developer will build either a swimming pool or a tennis cou ...

Question what some of the reasons that evolutionary models

Question : What some of the reasons that evolutionary models are considered by many to be the best approach to software development. The response must be typed, single spaced, must be in times new roman font (size 12) an ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As