Computer hardware assignment

Objective:

• You will learn the different parts of a personal computer
• You will learn to find computer parts online
• You will compare and contrast pricing of building your own PC vs. buying one prebuilt

Resources:

• Media:Hardware.ppt
• Newegg

Procedures:

1. Go to a computer retailer's website (e.g. Dell, HP, Sony, Apple, etc.)
2. Find a desktop computer that you would be interested in purchasing
3. Look for the computer's "technical specifications"
4. Bookmark or save the link
5. Open a Google spreadsheet document
6. Share the spreadsheet with Mr. Bui
7. Name the spreadsheet Computer Hardware Assignment
8. Paste the link to the computer that you found in the Google spreadsheet
9. Create 3 different headers: Component, Make/Model, Cost
10. Paste the following into the Component column of your spreadsheet:
    • Motherboard
    • CPU
    • RAM (memory)
    • Hard drive
    • Video/graphics card
    • CD/DVD burner
    • Case
    • Power supply
    • Monitor
    • Keyboard
    • Mouse
11. Using Newegg, find the components of your pre-built machine
    • Make sure that your components "match" up with the motherboard
12. For each part, copy and paste the following into your document:
    • The full name of the part (including make and model) into the Make/Model column
    • The cost of the part in the Cost column
13. After you have "purchased" all the parts, at the bottom of the spreadsheet, total the cost of your machine
    • You should use the spreadsheet function =sum() <- watch Mr. Bui's demo!
14. Show the cost of the manufactured machine in the cell below your total
15. Use some spreadsheet magic and show the difference between your total and the manufactured computer