Thursday, February 26, 2009

Special gift for mid sem break: Assignment 3



Software Skills : Spreadsheet Formulas, Web Browser and E-Mail
Business Skills : Technology Pricing

You have been asked to obtain pricing information on hardware and software for ComSyz Sdn. Bhd, Jalan Hang Tuah, 75300 Melaka. Survey from the computer shop or search from magazine or newspaper; get pricing for:

20 PC desktop systems
2 notebook/laptops
(Note: manufactured by IBM, Dell, Compaq, Acer or any computer brand. For the purpose of this assignment, ignore the fact that desktop systems usually come with preloaded software packages.)
2 monochrome LaserJet desktop printers
1 color inkjet printer,
1 digital scanner

Each PC desktop system must satisfy the following minimum specifications:

Processor speed : 2.5 GHz
Hard drive : 160 GB
RAM : 1 GB
CD-ROM speed : 48 speed
Monitor (diagonal measurement) : 17 inches

Each laptop must satisfy the following minimum specifications:

Processor speed : 1.8 GHz
Hard drive : 120 GB
RAM : 2 GB
DVD-ROM : DVD-Super multi double layer (support DVD+R Double Layer / DVD+/-RW / DVD-RAM
Laptop screen : 14 inches, wide LCD
Wireless technology : 802.11 b/g wireless LAN

For each monochrome desktop printer must satisfy the following minimum specifications:

Print speed : 12 pages per minute
Print resolution : 600 x 600
Network ready? : Yes

After pricing all the computer hardware, obtain pricing on:
22 copies of Microsoft Windows Vista
22 copies of Microsoft Office 2007

(Note: The application software suite packages come in various versions, so be sure that each package contains programs for word processing, spreadsheet analysis, database management and graphics preparation)

Prepare a spreadsheet showing your research results for the all computer hardware and software. Use your spreadsheet software to determine the PC desktop system, laptop, printer, scanner and software combination that will offer both the best performance and pricing. Then prepare a quotation for that all computer hardware and software.

Assume that your company will take the standard warranty and service contract offered by each product’s manufacturer.

Send the softcopy (spreadsheet) and hardcopy (quotation). For the softcopy, send via e-mail to For the hardcopy, also prepare one page of your report with a few sentences describing one thing that you have learned from your research. Also attach the evidence (brochures, pamphlets or catalog that you get the price).

Due date: Monday, March 16, 2009 (3.30 pm)


  1. salam..
    sir nyer blog kn x leh right click..
    so mcm ner nk amik soklan assignment 3 tue??
    susah r lau nk refer...nk kena buka blog aje..

    sir, misal kata price yg dia bg x sama mcm dlm pamplet yg dia bg tu cam ne ea?
    nk ikot yg dlm pamplet ke?

  3. to fmunyaraZ
    copy paste apa yang sir nak kat blog ni dalam microsoft word then save file je la.