Word Excel
Special Project Dell vs. Gateway Computer Comparison Project
Get Info: Locate
computers from 2 of the following sources: (1)
Dell (2) Gateway
Get the following information about each computer: (what is in
parenthesis is suggestions only)
1. Name of Computer
(Select 1000Cse)
2. Computer Maker (Gateway,
Dell)
3. Source of Information
(www.gateway.com, www.dell.com)
4. Style of Computer
(Desktop, Tower)
5. Motherboard (Pentium 4,
core duo)
6. Processor Speed (1.8 GHz)
7. Amount of Memory (2 GB)
8. Size of Hard Drive (80 GB)
9. Does it have a Video card,
if so size (128 MB)
10. Monitor Size (15 inch)
11. Operating System (Windows
XP, Vista)
12. CD/DVD Type (CD-ROM,
CD-RW, DVD)
13. List Programs included
(Word, Quicken etc.)
14. List available upgrades
15. List warranty info
16. Additional benefits
(rebates, free internet)
17. Cost of computer ($1195)
18. Cost of Taxes (calculate
using a formula)
19. Cost of Express Shipping
($115, do NOT put free)
20. Total Cost of the
computer (calculate using a formula)
Creating A Spreadsheet: You may use
the following as a guide or create your own.
|
|
A |
B |
C |
D |
|
1 |
Excel
Computer Project by Your
NAME |
|||
|
2 |
# |
Category |
Computer #1 |
Computer #2 |
|
3 |
1 |
Name |
|
|
|
4 |
2 |
Maker |
|
|
|
5 |
3 |
Source of Information |
|
|
|
6 |
4 |
Style |
|
|
|
7 |
5 |
Motherboard |
|
|
|
8 |
6 |
Processor Speed (MHz) |
|
|
|
9 |
7 |
Memory (MB) |
|
|
|
10 |
8 |
Hard Drive (GB) |
|
|
|
11 |
9 |
Video Card (MB) |
|
|
|
12 |
10 |
Monitor Size (inches) |
|
|
|
13 |
11 |
Operating System |
|
|
|
14 |
12 |
CD Type |
|
|
|
15 |
13 |
Programs Available |
|
|
|
16 |
14 |
Upgrades Available |
|
|
|
17 |
15 |
Warranty info |
|
|
|
18 |
16 |
Additional Benefits |
|
|
|
19 |
17 |
Cost of Computer |
|
|
|
20 |
18 |
Taxes |
(Calculate using formula) |
(Calculate using formula) |
|
21 |
19 |
Shipping & Handling |
|
|
|
22 |
20 |
TOTAL cost |
(Calculate using formula) |
(Calculate using formula) |
Create 2 Graphs:
ό
Bar Graph of
Processor Speeds (Dell vs. Gateway)
ό
Pie Graph showing
Total Cost for Gateway
**Note: only numbers should be in this cell, cannot graph
with letters in the cell**
What you think (this is what goes in your 2 page typed paper):
1. Which computer do you think is the better value for the
money? WHY?
2. Which computer would you buy?
WHY?
What To TURN IN!!!! All Graphs & Spreadsheets must be centered
horizontally & vertically
Title Page:
ό
Title Page
(centered left/right, full justification top/bottom)....................................... 20 points
§
include
your name, class name, class time, date
2 Page
Report with Table:
ό
2 pages (double
spaced, 1 margins l/r)................................................................. 100
points
§
First page: 2 ½
top margin, page number at bottom center as a footnote
§
Second page: 1
top margin, page number at bottom center as footnote, and top left name as
header
§
The Table should
be on a sheet of its own with appropriate information.
Excel
Spreadsheet:
ό
Bar Graph (on
its own sheet of paper)................................................................... 40
points
ό
Pie Graph (on
its own sheet of paper)................................................................... 40
points
ό
Your excel
spreadsheet, with the information you gathered (on its own sheet of paper).... 100 points
o
Total Pages to be turned in...........
..6 pages for a total of
300 points