The President of the Company has asked you to replace the computers in every department. The researched information must be presented in this format:
A memo to the president stating the need to replace the computers.
An Excel spreadsheet comparing three different computers that you have researched. Create a spreadsheet listing the three computers, computer specifications, and cost. Show the cost benefit of each computer. Which one would be the better deal? You must use a formula or function in this worksheet.
Create a chart comparing the costs and features. You can decide on the most appropriate chart to display your data.
Prepare a PowerPoint presentation that will be presented to the president and the board for approval to purchase the computers. In the presentation, make your recommendation as to which computer you feel would work best for the company.
There are 4 deliverables for this project:
Word processed Memorandum.
Excel Spreadsheet using formulas or functions and an Excel Chart comparing the costs and features of the selected computers.
PowerPoint Presentation with at least 6 slides. The presentation should consist of a title slide, agenda, your charts and graphs, and a concluding slide.
Important Information:
You can embed your chart in a worksheet or create it in a separate chart sheet. With object embedding, the chart may be sized and it enables you to create a compound document with data from several applications. Whereas with linking, your chart is in a separate file. You may want to review object linking and embedding in Chapter 3 of your textbook.
To copy a chart to a PowerPoint Presentation:
Select the embedded chart or the chart sheet with a single chart. A chart sheet is easier to copy to a PowerPoint Presentation.
Copy the chart and paste in the desired place in PowerPoint.
Hint: Paste Options
Click Paste Options next to the chart.
To paste the chart with a link to source data, click Chart.
To paste the chart and to include access to the entire workbook, click Excel Chart.
To paste the charts as a static picture, click Paste as Picture.
To paste the chart in the original format, click Keep Source Formatting.
To paste the chart and format using the theme that is applied to the presentation, click use Destination Theme.
OK. Looks like you have an assignment to do, but I don't understand what your question is about the assignment.
You are getting ready for your 1st day of work and realize that you have several options of how to get to bank of Wall Street. you could drive your car and look for street parking , or park in the parking garage. you mighteven take a taxi or subway. youj must get to work , wo tine is scarce and being on a limited budget ,money is scarce. explain the trade-offs between any 3 options. what would you gain and what would you have to give up?
wow i have this exact same assignment do on monday, weird. my qst about the assignment is simple. how should i start my memorandum? i have never written one
To complete this project, follow these steps:
1. Write a memorandum to the president:
- Begin with a formal salutation.
- State the purpose of the memorandum (to discuss the need for replacing the computers in every department of the company).
- Provide a brief overview of the current state of the computers (their age, performance issues, etc.).
- Explain the potential benefits of replacing the computers (improved productivity, reduced downtime, etc.).
- Conclude by requesting approval for the purchase of new computers.
- End with a professional closing and your signature.
2. Create an Excel spreadsheet comparing three different computers:
- Start by creating a new Excel workbook.
- Create a table with columns for computer specifications (e.g., processor, RAM, storage capacity, etc.) and cost.
- Research three different computers and fill in the specifications and cost for each.
- Use a formula or function to calculate the cost benefit of each computer (e.g., cost divided by performance rating).
- Identify the computer with the highest cost benefit as the better deal.
3. Create a chart comparing costs and features:
- Select the data in your Excel spreadsheet, including the computer names, specifications, and cost.
- Click on the "Insert" tab in the Excel toolbar.
- Choose the appropriate chart type to display your data (e.g., bar chart or column chart).
- Customize the chart by adding axis labels, titles, and any other necessary details.
- Embed the chart into the same worksheet or create a separate chart sheet, as per your preference.
4. Prepare a PowerPoint presentation:
- Create a new PowerPoint presentation.
- Start with a title slide that includes the project name and your name.
- Add an agenda slide to outline the contents of your presentation.
- Insert the chart from your Excel spreadsheet into one of the slides (use the copy and paste method mentioned above).
- Include additional slides to present the specifications and cost of each computer.
- Provide a comparison of the cost benefits and explain why you recommend a specific computer.
- Conclude with a slide summarizing your recommendation and requesting approval for the purchase.
- Use consistent formatting and professional slide layouts throughout the presentation.
Remember to proofread and review all your deliverables before submitting them to the president and the board for approval.