Mega Bytes, your computer hardware and software company, has approached the local public school system about providing computer instruction at the junior and senior high school level. The local public schools are using computer equipment that is approximately 10 years old. You can assume that all the training will take place in a single room in one building and that the room is available and furnished with suitable computer furniture.
You will be making a presentation before the school Board of Directors and you will cover the following points:
- Why it's important to use current hardware and software
- The cost involved in purchasing equipment for a 20-student capacity computer lab
- A proposed software training program, which includes your hourly rate and the estimated number of hours required per semester to train a single class
- The benefits to the students, faculty, and community-at-large
1. Open a new Word document and save it as School Outline.docx.
2. Create an outline that contains headings and subheadings for at least 10 slides. Hint: Remember to work in Outline view to enter text for the headings and subheadings.
3. Save the document.
4. Open a new Excel workbook and save it as School Figures.xlsx.
5. Name Sheet I Hardware, create a worksheet that contains information about the hardware you believe should be purchased, and the price of each item. For example, you could create a worksheet that appears as shown below:
Quantity
|
Machine
|
Unit Cost
|
Total
|
20
|
Laptops
|
$1,200.00
|
$24,000.00
|
|
Color
|
|
|
3
|
Printers
|
$400.00
|
$1,200.00
|
|
Network
|
|
|
2
|
Hubs
|
$2,000.00
|
$4,000.00
|
|
|
Total
|
$29,200.00
|
6. Name Sheet 2 Software, and create a worksheet that contains information about the software you believe should be purchased and the price of each item. For example, you could list the Microsoft Office 2010 suite.
7. Name Sheet 3 Training and create a worksheet that contains your hourly rate and an estimate of the cost of training a single full-semester class.
8. Save the workbook.
9. Open a new PowerPoint presentation and save it as School Presentation.pptx.
10. Apply the presentation design of your choice, then create a title slide.
11. Import the document School Outline.docx into the presentation.
12. Copy the appropriate cells from each worksheet in School Figures.xlsx into its own slide. Do not create links between Excel and PowerPoint. Size and position the copied cells attractively on each slide.
13. On each slide containing copied cells, double-click the cells, then fill the first row with the shading color of your choice.
14. Optional: Add artwork, transitions, and builds into the slides that you consider appropriate.
15. Review your work and submit School Presentation.pptx to your instructor as required.