Difference between revisions of "Computer hardware assignment"
From WLCS
| Line 13: | Line 13: | ||
# Look for the computer's "technical specifications" | # Look for the computer's "technical specifications" | ||
# Bookmark or save the link | # Bookmark or save the link | ||
| − | # Open a Google | + | # Open a Google spreadsheet document |
| + | # 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 | ||
| Line 32: | Line 33: | ||
#* Make sure that your components "match" up with the motherboard | #* Make sure that your components "match" up with the motherboard | ||
# For each part, copy and paste the following into your document: | # For each part, copy and paste the following into your document: | ||
| − | #* The full name of the part (including make and model) | + | #* The full name of the part (including make and model) into the '''Make/Model''' column |
| − | #* The cost | + | #* The cost of the part in the '''Cost''' column |
| − | # After you have "purchased" all the parts, at the bottom of the spreadsheet, | + | # 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 | ||
Revision as of 00:12, 23 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
- Create 3 different headers: Component, Make/Model, Cost
- 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
- 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
