Computer hardware assignment
From WLCS
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:
Procedures:
- Go to a computer retailer's website (e.g. Dell, HP, Sony, Apple, etc.)
- Find a desktop computer that you would be interested in purchasing
- Look for the computer's "technical specifications"
- Bookmark or save the link
- Open a Google spreadsheet document
- Share the spreadsheet with Mr. Bui
- Name the spreadsheet Computer Hardware Assignment
- Paste the link to the computer that you found in the Google spreadsheet somewhere visible
- Create 4 different headers: Component, Make/Model, Cost, Link
- 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
- Using Newegg, find the components of your pre-built machine
- Make sure that your components "match" up with the motherboard
- 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)
- 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!
- Show the cost of the manufactured machine in the cell below your total
- Use some spreadsheet magic and show the difference between your total and the manufactured computer