Plan to build your perfect PC. (Remember, you are to select each part of the computer. No kits are allowed. No prebuilt computing devices are allowed. This project is
designed to help you apply what you are learning each week using current hardware and software options.)
Create an Excel spreadsheet that includes the major components, specifications, parts, vendors, pricing, and total cost as outlined below.
1. What purpose did you select for the computer you will be building?
2. What price range did you select for the computer you will be building? Were you able to stay within budget? Why or why not?
3. List all major components in your spreadsheet template. Include at least the motherboard, processor power, memory, drives, and monitor size. Add to this list as
4. Determine all necessary parts to buy. (Include at least the case, expansion cards, NIC, and keyboard. Add to this list as needed.)
What parts did you decide to buy? ARE THESE INCLUDED IN YOUR SPREADSHEET?
5. Include OS and software.
What OS and software did you decide to include? ARE THESE INCLUDED IN YOUR SPREADSHEET?
6. Update an Excel spreadsheet with all specifications and parts.
HAVE YOU UPDATED YOUR SPREADSHEET?
7. Price parts from two locations. You may use bricks and mortar stores in your area, such as TigerDirect and online sellers, such as newegg.com or
http://www.tigerdirect.com/. So you can do all of your comparison shopping online, if you desire.
WHAT TWO LOCATIONS DID YOU CHOOSE TO PRICE PARTS? (YOU WILL BE ADDING IN THE PRICES FROM THESE TWO LOCATIONS AS SEPARATE COLUMNS IN YOUR SPREADSHEET. (See item #8
8. Update your spreadsheet with the seller’s name, prices, and totals.
ADD IN THE PRICES FROM THESE TWO LOCATIONS AS SEPARATE COLUMNS IN YOUR SPREADSHEET. MAKE SURE YOU ADD THE VENDOR, PRICE AND TOTAL FOR ALL ITEMS YOU SELECT AS WELL AS
THE COMPUTER AS A WHOLE.
9. Write a 2–5 paragraph report on your learning and experiences in completing this project. (10 points)
MAKE SURE TO INCLUDE AN INTRODUCTION, 2-3 PARAGRAPHS ABOUT THE PROJECT, AND A CONCLUSION