Difference between revisions of "Computer hardware assignment"
From WLCS
| Line 16: | Line 16: | ||
# Share the spreadsheet with Mr. Bui | # Share the spreadsheet with Mr. Bui | ||
# Name the spreadsheet '''Computer Hardware Assignment''' | # Name the spreadsheet '''Computer Hardware Assignment''' | ||
| − | # Paste the link to the computer that you found in the Google spreadsheet | + | # Paste the link to the computer that you found in the Google spreadsheet somewhere visible |
| − | # Create | + | # Create 4 different headers: '''Component''', '''Make/Model''', '''Cost''', '''Link''' |
# Paste the following into the '''Component''' column of your spreadsheet: | # Paste the following into the '''Component''' column of your spreadsheet: | ||
#* Motherboard | #* Motherboard | ||
| Line 35: | Line 35: | ||
#* The full name of the part (including make and model) into the '''Make/Model''' column | #* 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 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 | # 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! | #* 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 | # 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 | # Use some spreadsheet magic and show the difference between your total and the manufactured computer | ||
Revision as of 09:15, 29 January 2013
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
