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

Components of Motherboard

Adapter: It’s a circuit board that is attached with port and by this processor will control and communicate others devices.

Port: It will help us to attach the devices. Different types of port are: Serial, parallel, USB etc.

PCI Slot: It will allow to attach extra device with PC such as: TV card,NIC(LAN Card) etc.

Power Supply: Pc needs four types of DC voltages +5, -5, +12, -12. Power supply unit will convert AC to required Dc voltage.

Display Adapter: It works with mo monitor. Ex: VGA, SVGA ,CGA etc.

Code

Code
• Code reduces the volume of data, so data manipulation becomes easier and less error involved with data.
• Types of code:
• (1)BCD Code: It is used to represent numbers in computer system. It is 4 bit code. It is a weighted code and 8-4-2-1 weight is given to every number. Example: The BCD of 13 is: 00010011
25 = 00100101
• (2)Alphanumeric Code: It is a 8 bit code.It is used to represent alphabets, digits, symbols, special symbols tic etc. 4 bit of this code is zone bits and 4 bit is 8-4-2-1 ,Ex: ASCll,EBCDIC
Z Z Z Z 8 4 2 1
• (3)Uni code: It is a 16 bit code. It is used to represent special languages like Bengali, Hindi, Chinese, Arabic etc.

Number system

Number system
• Decimal Number: 0,1,2,3,4,5,6,7,8,9
• Base of decimal Number :10
• Binary Number: 0,1
• Base of Binary Number: 2
• Octal Number: 0,1,2,3,4,5,6,7
• Base of Octal Number: 8
• Hexadecimal Number: 0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F
• Base of Hexadecimal Number : 16
Conversation Of Numbers: Binary to Decimal
(101)2
101= 1x(2)0 =1 , 0x(2)1=0,1x(2)2=1x4 = 5 (101)2 = (5)10

Types of Computer

Types of Computer

• Based on signal: Two types :

• 1.Analog Computer: It follows analog signal .Ex. Speedometer 2.Digital Computer: It follows digital signal .Ex. Personal computer
• Based on capacity:
• 1.Super computer :It’s largest computer in size and capacity. It may have more than thousand processors. It is used in weather forecasting, complicated calculations and research ez.
• 2.Mainframe Computer : less are in size and capacity than the super computer. It is used in organizations where many users need to work with same data. It is found in railway, air ticket reservation and in large organization like bank ez.
• 3. Minicompurter: it’s smaller in size and capacity than supercomputer and mainframe computer. It’s used in organizations for the serving the input and output needs of 100 users at a time. Usually minicomputer can be found in many organizations as a server computer.
• 4.Workstation:Special computer used for scientist and engineers is called workstation

• 5.Micro computer : Micro computer is used according to size and capacity it’s the smallest .Ex. Personal computer.

Other types of computer

• Laptop computer: Special computer which has the same capacity as microcomputer

• PDA: Personal Digital Assistant. It’s used for taking notes, tracking data, agenda ez.It’s also called palmtop.
• Tablet PC: It’s created by Microsoft .It’s a special computer which has same functionality as microcomputer.

Computers definition

Computer: Computer is an electronic device that takes data as input. Processes the data and finally it produces the output based on input.

Input----Processing ---- Output.

Components of computer System---

1.Hardware

2.Software

3.Humanware.

4.Operational procedures .

1.Hardware : All the physical component of computer system which we can touch is called as Hardware. Ex: Cpu, Monitor etc.

2.Software: Collection of program is called software.Ex.Operating syste,,ms office etc.

3.Humanware;Human involvement with computer system is called humanware.3 types of human ware .

1.Analyst.

2.programmer

3.Operator.

1.Analyst: The person who has vast knowledge and who analyses a system makes a design to convent manual system to computerize system is analyst.

2.programmer: The person who has less knowledge than analyst and who writes program for assistant is called programmer.

3.Operator: The person who has least knowledge and who only operates a system is called operator.

4.Operational procedures : The rules that will define how to use computer system. How to make change in hardware and software etc.