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
• PCPartPicker

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 document
6. Share the document with Mr. Bui
7. Name the document Computer Hardware Assignment
8. Copy & paste the link to the computer that you found
9. Copy & paste a picture of the computer that you found
10. Copy & paste the specifications
11. Copy & paste the price

1. Create 4 different headers: Component, Make/Model, Cost, Link
2. 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
3. Using Newegg, find the components of your pre-built machine
   • Make sure that your components "match" up with the motherboard
4. 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
   • The link to the part's page in the Link column (in case you need to find it again)
5. 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!
6. Show the cost of the manufactured machine in the cell below your total
7. Use some spreadsheet magic and show the difference between your total and the manufactured computer