Presentation

Computer Presentation

Data

=IF(B2>=40,"Pass","Fail")

=IF(AND(B2>=40,B2<=100),"Pass","Fail")


=IF(AND(B2>=95,B2<=100),"A+",IF(AND(B2>=85,B2<=95),"A",IF(AND(B2>=80,B2<=85),"A-",IF(AND(B2>=70,B2<=80),"B+",IF(AND(B2>=60,B2<=70),"B",IF(AND(B2>=50,B2<=60),"B-",IF(AND(B2>=40,B2<=50),"C","F")))))))



(1) Calculate total price
(2) If total price is between 100-500 then discount is 5%
If total price is between 501-1000 then discount is 8%
If total price is between 1001-5000 then discount is 10%
If total price is more than 5000 then discount is 12%
(3) Calculate Net price

=IF(AND(D2>=100,D2<=500),D2*5%,IF(AND(D2>=501,D2<=1000),D2*8%,IF(AND(D2>=1001,D2<=5000),D2*10%,D2*12%)))


WITHOUT =

=IF(AND(B2>=95,B2<=100),"A+",IF(AND(B2>=85,B2<95),"A",IF(AND(B2>=80,B2<85),"A-",IF(AND(B2>=70,B2<80),"B+",IF(AND(B2>=60,B2<70),"B",IF(AND(B2>=50,B2<60),"B-",IF(AND(B2>=40,B2<50),"C","F")))))))

Computer Networks

Computer Networks

If group of computers are connected via cable or wireless to share the resource then it is called computer network.

Technological requirement for Network: NIC(Network Interface Card),Cable,Modem,RJ45,It is also called LAN card, HUB/switch, Router

Networking Operating system: Windows Xp, Windows Server 2008.

Types of Network

Basically there are 3 types of Network.

LAN MAN WAN

Local area Network Metropolitan area Wide area network

Network

It can cover a short it can cover a city it can cover whole world

Distance like a building.

Fastest Faster than WAN it is the slowest

Ex: ULAB Network Ex: ATM Booth Ex: Internet

Of Dhaka city.

Assignment1

Max. Marks – 10

Submission Date
The assignment due date is on 21/04/2011 within 5.30 pm.

Submission Requirements
- Cover Page
- Question paper
- Table of Contents
- Hand written Assignment Answers (Each answer in separate sheet)

Late Submission Penalty
- 1 day late : deduction of 20%
- 2 days late : deduction of 40%
- 3 days late : deduction of 50%
- >3 days late : zero marks awarded


Scenario

ULAB requires some computer systems to be purchased. The main purposes of the computer systems are to allow the graphic designers to use the following software:

(1) Corel Draw
(2) Photoshop
(3) Flash
(4) Dream weaver
(5) Maya 3D Animation
(6) Microsoft Office etc.

The computer systems have to be high-end system with sufficient processing power to cater for the above-mentioned activities. A high-end printer is also need to be acquired for printing the required documents.

You, as an IT Manager of ULAB, had been approached to provide all the necessary specifications for the above-mentioned computer system. A suitable operating system also has to be identified and the chosen operating system should be able to run the above mentioned applications that the company intends to use in its’ daily operational activities.




Tasks

1. Identify the components for the computer system which include the specifications for the following: CPU, secondary storage devices, relevant peripherals and other necessary components of the computer system.

2. Based on the above, specify a complete computer system to suit the given task of ULAB.

3. Perform an evaluation of the performance of the selected system. This includes the CPU clock speed, and other relevant performance factors.

4. Conduct a comparison between functions of different types of operating systems to find a suitable operating system for the proposed computer system to run the graphics applications.

5. Specify the requirements to have the network connectivity with computer systems.



Advice on source of information

• Lecturing notes
• Introduction to Computers Latest edition, Peter Norton, McGraw Hill.
• Computer Fundamentals Latest edition, Dr. Lutfar Rahman and Dr. Alamgir Hossain
• Internet
• Leaflet/Information from different Computer Shop