Computer Applications

A computer is an electronic device, operating under the control of instructions (software) stored in its own memory unit, that can accept data (input), manipulate data (process), and produce information (output) from the processing. Generally, the term is used to describe a collection of devices that function together as a system.

1. Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru Gobind Singh Indraprastha University and Approved by Govt of NCT of Delhi & Bar Council of India)
Semester: FIRST Semester
Name of the Subject:
COMPUTER APPLICATIONS
BASICS OF COMPUTERS
UNIT-I

2. 2
What Is A Computer?
Acomputerisanelectronicdevice,operatingunderthecontrolof
instructions(software)storedinitsownmemoryunit,thatcanacceptdata
(input),manipulatedata(process),andproduceinformation(output)fromthe
processing.Generally,thetermisusedtodescribeacollectionofdevicesthat
functiontogetherasasystem.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

3. 3
Devices that comprise a computer system
Printer
(output)
Monitor
(output)
Speaker
(output)
Scanner
(input)
Mouse
(input)
Keyboard
(input)
System unit
(processor, memory…)
Storage devices
(CD-RW, Floppy, Hard
disk, zip,…)
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

4. 4
What Does A Computer Do?
•Computerscanperformfourgeneraloperations,which
comprisetheinformationprocessingcycle.
•Input
•Process
•Output
•Storage
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

5. 5
What Do Computers Do?
•Input, Process, Output, & Store data
Input Process Output
Store Data
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

6. 6
Data and Information
•Allcomputerprocessingrequiresdata,whichisacollectionofraw
facts,figuresandsymbols,suchasnumbers,words,images,videoand
sound,giventothecomputerduringtheinputphase.
•Computersmanipulatedatatocreateinformation.Informationisdata
thatisorganized,meaningful,anduseful.
•DuringtheoutputPhase,theinformationthathasbeencreatedisput
intosomeform,suchasaprintedreport.
•Theinformationcanalsobeputincomputerstorageforfutureuse.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

7. 7
Why Is A Computer So Powerful?
•The ability to perform the information processing cycle with amazing
speed.
•Reliability (low failure rate).
•Accuracy.
•Ability to store huge amounts of data and information.
•Ability to communicate with other computers.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

8. 8
How Does a Computer Know what to do?
•It must be given a detailed list of instructions, called a computer
programor software, that tells it exactly what to do.
•Before processing a specific job, the computer program corresponding
to that job must be stored in memory.
•Once the program is stored in memory the compute can start the
operation by executing the program instructions one after the other.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

9. 9
What Are The Primary Components Of A Computer ?
•Input devices.
•Central Processing Unit
(containing the control unit and
the arithmetic/logic unit).
•Memory.
•Output devices.
•Storage devices.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

10. 10
Uses of Computer
PC at Home
Common uses for the computer within the home
•Computer games
•Working from Home
•Banking from Home
•Connecting to the Web
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

11. 11
Uses of Computer
•Office Applications
•Stock Control
• Stock control is ideal for automation and in many companies it
is now completely computerized. The stock control system keeps
track of the number of items in stock and can automatically order
replacement items when required.
•Accounts / Payroll
• In most large organizations the accounts are maintained by a
computerized system. Due to the repetitive nature of accounts a
computer system is ideally suited to this task and accuracy is
guaranteed.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

12. 12
Uses of Computer
•Automated Production Systems
• Many car factories are almost completely automated and the cars are
assembled by computer-controlled robots. This automation is becoming
increasingly common throughout industry.
•Design Systems
• Many products are designed using CAD (Computer Aided Design)
programs to produce exact specifications and detailed drawings on the
computer before producing models of new products.

13. 13
Uses of Computer
Computers in Daily Life
•Accounts
•Games
•Educational
•On-line banking
•Smart ID cards
•Supermarkets
•Working from home (Tele-working)
•Internet

14. 14
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

15. 15
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

16. Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru Gobind Singh Indraprastha University and Approved by Govt of NCT of Delhi & Bar Council of India)
Semester: FIRST Semester
Name of the Subject:
COMPUTER APPLICATIONS
INTRODUCTION TO COMPUTER
SOFTWARES
UNIT-II

17. 17
•Software is a set of electronic instructions that tells the computer how
to do certain tasks. A set of instructions is often called a program.
•When a computer is using a particular program, it is said to be
running or executing the program.
•The two most common types of programs are system software and
application software.
Bringing the Machine to Life –
What is Software?
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

18. 18
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

19. 19
•System software exists primarily for the computer itself, to help the
computer perform specific functions.
•One major type of system software is the operating system (OS). All
computers require an operating system.
•The OS tells the computer how to interact with the user and its own
devices.
•Common operating systems include Windows, the Macintosh OS,
OS/2, and UNIX .
Bringing the Machine to Life –
System Software
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

20. 20
•Application Software consists of programs that tell a computer how
to produce information
•Application software tells the computer how to accomplish tasks the
user requires, such as creating a document or editing a graphic image.
•Some important kinds of application software are:
Word processing programs Spreadsheet software
Database management Presentation programs
Graphics programs Networking software
Web design tools and browsers Internet applications
Communications programs Utilities
Entertainment and education Multimedia authoring
Bringing the Machine to Life -Applications
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

21. What is an Operating System?
•A program that acts as an intermediary between a user of a computer
and the computer hardware.
•Operating system goals:
–Execute user programs and make solving user problems easier.
–Make the computer system convenient to use.
•Use the computer hardware in an efficient manner.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

22. Computer System Structure
•Computer system can be divided into four components
–Hardware –provides basic computing resources
•CPU, memory, I/O devices
–Application programs –define the ways in which the system
resources are used to solve the computing problems of the
users
•Word processors, compilers, web browsers, database
systems, video games
–Users
•People, machines, other computers
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

23. Four Components of a Computer System
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

24. Operating System Definition
•OS is a resource allocator
–Manages all resources
–Decides between conflicting requests for efficient and fair
resource use
•OS is a control program
–Controls execution of programs to prevent errors and improper
use of the computer
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

25. Operating System Definition (Cont.)
•No universally accepted definition
•“Everything a vendor ships when you order an operating system” is
good approximation
–But varies wildly
•“The one program running at all times on the computer” is the kernel.
Everything else is either a system program (ships with the operating
system) or an application program
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

26. Computer Startup
•bootstrap programis loaded at power-up or reboot
–Typically stored in ROM or EEPROM, generally known as firmware
–Initializatesall aspects of system
–Loads operating system kernel and starts execution
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

27. Computer System Organization
•Computer-system operation
–One or more CPUs, device controllers connect through common bus
providing access to shared memory
–Concurrent execution of CPUs and devices competing for memory
cycles
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

28. Computer-System Operation
•I/O devices and the CPU can execute concurrently.
•Each device controller is in charge of a particular device type.
•Each device controller has a local buffer.
•CPU moves data from/to main memory to/from local buffers
•I/O is from the device to local buffer of controller.
•Device controller informs CPU that it has finished its operation by causing
an interrupt.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

29. Common Functions of Interrupts
•Interrupt transfers control to the interrupt service routine generally, through
the interrupt vector, which contains the addresses of all the service routines.
•Interrupt architecture must save the address of the interrupted instruction.
•Incoming interrupts are disabled while another interrupt is being processed
to prevent a lost interrupt.
•A trap is a software-generated interrupt caused either by an error or a user
request.
•An operating system is interrupt driven.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

30. 30
Computer Software
•Computersoftwareisthekeytoproductiveuseofcomputers.Softwarecanbe
categorizedintotwotypes:
•Operatingsystemsoftware
•Applicationsoftware.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

31. 31
Operating System Software
Operating system software tells the computer how to perform the
functions of loading, storing and executing an application and how to
transfer data.
Today, many computers use an operating system that has a graphical user
interface (GUI) that provides visual clues such as icon symbols to help
the user. Microsoft Windows 98is a widely used graphical operating
system. DOS(Disk Operating System) is an older but still widely used
operating system that is text-based.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

32. 32
Application Software
•ApplicationSoftwareconsistsofprogramsthattellacomputerhowto
produceinformation.Someofthemorecommonlyusedpackagesare:
•
•Wordprocessing
•Electronicspreadsheet
•Database
•Presentationgraphics
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

33. 33
Word Processing
•WordProcessingsoftwareisusedtocreateandprintdocuments.Akey
advantageofwordprocessingsoftwareisthatuserseasilycanmake
changesindocuments.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

34. 34
Electronic Spreadsheets
•Electronicspreadsheetsoftwareallowstheusertoadd,subtract,and
performuser-definedcalculationsonrowsandcolumnsofnumbers.
Thesenumberscanbechangedandthespreadsheetquickly
recalculatesthenewresults.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

35. 35
Database Software
•Allowstheusertoenter,retrieve,andupdatedatainanorganizedand
efficientmanner,withflexibleinquiryandreportingcapabilities.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

36. 36
Presentation Graphics
•Presentationgraphicsoftwareallowstheusertocreate
documentscalledslidestobeusedinmakingthepresentations.
Usingspecialprojectiondevices,theslidesdisplayasthey
appearonthecomputerscreen.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

37. Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru Gobind Singh Indraprastha University and Approved by Govt of NCT of Delhi & Bar Council of India)
Semester: FIRST Semester
Name of the Subject
COMPUTER APPLICATIONS
DESKTOP COMPONENTS
UNIT-III

38. Spreadsheets Basics
•Excel is a “spreadsheet” which holds different kinds of information
•It performs calculations with mathematical and statistical functions
•Constants -entries that do not change
•Formulas -combination of constants and functions
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

39. Using Functions in Excel
•Use spreadsheets in decision making; use Goal Seek and Scenario Manager
to evaluate multiple conditions
•Use financial functions (PMT, etc.)
•Use fill handle and AutoFill capability
•Use pointing to create a formula
•Statistical Functions —MAX, MIN, AVERAGE, COUNT
•Use functions over arithmetic expressions
•Decision making functions (IF and VLOOKUP (vertical lookup))
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

40. SUM(number1, number 2,…)
•Example
=SUM(3, 2) equals 5
•If cells A2:E2 contain 5, 15, 30, 40, and 50:=SUM(A2:C2) equals
50=SUM(B2:E2, 15) equals 150
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

41. AVERAGE(number 1, number 2,…)
•Examples
If A1:A5 is named Scores and contains the numbers 10, 7, 9, 27, and 2,
then:
=AVERAGE(A1:A5) equals 11
=AVERAGE(Scores) equals 11
=SUM(A1:A5)/COUNT(A1:A5) equals 11
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

42. SIN(number)
•IMPORTANT NOTE:
–Angle (number) must be provided in radians If your argument is in
degrees, multiply it by PI()/180 to convert it to radians.
=SIN(PI()) equals 1.22E-16, which is approx. 0
=SIN(PI()/2) equals 1
=SIN(30*PI()/180) equals 0.5, the sine of 30 degrees
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

43. COUNT
•COUNT counts the number of cells that contain numbers & numbers
within the list of arguments.
•Value 1, 2,…, are 1 to 30 arguments that can contain or refer to a variety of
different types of data, but only numbers are counted.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

44. COUNTIF(range,criteria)
Counts the number of cells within a range that meet the given criteria.
Suppose A3:A6 contain "apples", "oranges", "peaches", "apples", respectively:
COUNTIF(A3:A6,"apples")equals 2
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

45. (A4:A130,1)
(A4:A130,2)
(A4:A130,3)
(A4:A130,4)
(A4:A130,5)
=COUNTIF(A4:A130,1)
=D4/D9*100
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

46. Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

47. Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

48. Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

49. Some Useful Functions
•IF
•TIME
functions
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

50. Conditional Functions
•Conditional functions allow the software to perform conditional tests and
evaluate a condition in your worksheet. Depending on whether the
condition is true or false, different values will be returned to the cells.
•=IF is the most important conditional function
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

51. If
=IF(condition, action if true, action if false)
This tests the “condition” to determine if specific results or cell contents are
true or false.
The instructions to be executed can return cell contents that are labels as well
as values.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

52. Logical Operators
•To perform conditional tests, logical operators are required.
= Equal
< Less than
> Greater than
<= Less than or Equal to
>= Greater than or Equal to
ChanderprabhuJain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

53. Logical Functions
And(logical1, logical2)Returns true if each
condition is true
Or(logical1, logical2)Returns true if either
condition is true
Not(logical) Returns true if the
condition is f
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

54. Examples
=IF(AND(B11<>0,G11=1),10,0) means that if the value in B11 is not equal to 0
and the value in G11 is equal to 1, assign the number 10. Otherwise, assign
the number 0.
=IF(OR(E13=“Profit”,F15>G15),”Surplus”,”Deficit”) means that if either E13
contains the word “Profit” or the contents of F15 are greater than or equal to
the contents of G15, assign the label “Surplus”. Otherwise, assign the label
“Deficit”.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

55. VLOOKUP Function
•Searches for a value in the leftmost column of a table, and then returns a
value in the same row from a column you specify in the table. Use
VLOOKUP instead of HLOOKUP when your comparison values are
located in a column to the left of the data you want to find.
Syntax:
=VLOOKUP(lookup_value,table_array,
col_index_num,range_lookup)
–If range_lookupis TRUE, the values in the first column of table_array
must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE,
TRUE; otherwise VLOOKUP may not give the correct value. If
range_lookupis FALSE, table_arraydoes not need to be sorted.

56. Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru Gobind Singh Indraprastha University and Approved by Govt of NCT of Delhi & Bar Council of India)
Semester: FIRST Semester
Name of the Subject
COMPUTER APPLICATIONS
COMPUTER NETWORKS
UNIT-IV

57. Networking
•Computer networkA collection of computing devices that are connected in
various ways in order to communicate and share resources
Usually, the connections between computers in a network are made using
physical wires or cables
However, some connections are wireless, using radio waves or infrared signals
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

58. 15-58
Networking
•The generic term nodeor hostrefers to any device on a network
•Data transfer rate The speed with which data is moved from one place
on a network to another
•Data transfer rate is a key issue in computer networks
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

59. 15-59
Networking
•Computer networks have opened up an entire frontier in the world of
computing called the client/server model
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

60. 15-60
Networking
•File serverA computer that stores and manages files for multiple users on
a network.
•Web serverA computer dedicated to responding to requests (from the
browser client) for web pages
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

61. 15-61
Types of Networks
•Local-area network (LAN)A network that connects a relatively small
number of machines in a relatively close geographical area
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

62. 15-62
Types of Networks
•Various configurations, called topologies, have been used to administer
LANs
–StarRingtopologyA configuration that connects all nodes in a closed
loop on which messages travel in one direction
–topologyA configuration that centers around one node to which all
others are connected and through which all messages are sent
–Bus topologyAll nodes are connected to a single communication line
that carries messages in both directions
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

63. Types of Networks
Various network topologies
15-10
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

64. 15-64
Types of Networks
•Wide-area network (WAN)A network that connects two or more local-
area networks over a potentially large geographic distance
–Often one particular node on a LAN is set up to serve as a gateway to
handle all communication going between that LAN and other networks
• Communication between networks is called internetworking
–The Internet,as we know it today, is essentially the ultimate wide-
area network, spanning the entire globe
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

65. 15-65
Types of Networks
Metropolitan-area network (MAN)The communication
infrastructures that have been developed in and around large cities
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

66. 15-66
Internet Connections
•Internet backboneA set of high-speed networks that carry Internet traffic
These networks are provided by companies such as AT&T, GTE, and IBM
•Internet service provider (ISP)A company that provides other
companies or individuals with access to the Internet
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

67. 15-67
Internet Connections
•There are various technologies available that you can use to connect a
home computer to the Internet
–A phone modemconverts computer data into an analog audio signal
for transfer over a telephone line, and then a modem at the destination
converts it back again into data
–A digital subscriber line (DSL)uses regular copper phone lines to
transfer digital data to and from the phone company’s central office
–A cable modem usesthe same line that your cable TV signals come in
on to transfer the data back and forth
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

68. 15-68
Internet Connections
•Broadband A connection in which transfer speeds are faster than 128 bits
per second
–DSL connections and cable modems are broadband connections
–The speed for downloads(getting data from the Internet to your home
computer) may not be the same as uploads(sending data from your
home computer to the Internet)
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

69. Packet Switching
•To improve the efficiency of transferring information over a shared
communication line, messages are divided into fixed-sized, numbered
packets
•Network devices called routers are used to direct packets between networks
Figure 15.4
Messages
sent by
packet
switching
15-18
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

70. 15-70
Open Systems
•Proprietary systemA system that uses technologies kept private by a
particular commercial vendor
–One system couldn’t communicate with another, leading to the need
for
•InteroperabilityThe ability of software and hardware on multiple
machines and from multiple commercial vendors to communicate
–Leading to
•Open systemsSystemsbased on a common model of network architecture
and a suite of protocols used in its implementation
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

71. 15-71
Open Systems
•The International Organization
for Standardization (ISO)
established the Open Systems
Interconnection (OSI)
Reference Model
•Each layer deals with a
particular aspect of network
communication
The layers of the OSI Reference Model

72. 15-72
Network Protocols
•Network protocols are layered such that each one relies on the protocols
that underlie it
•Sometimes referred to as a protocol stack
Layering of key network protocols

73. 15-73
TCP/IP
•TCP stands for Transmission Control Protocol
TCP software breaks messages into packets, hands them off to the IP
software for delivery, and then orders and reassembles the packets at
their destination.
•IP stands for Internet Protocol
IP software deals with the routing of packets through the maze of
interconnected networks to their final destination
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)

74. 15-74
TCP/IP (cont.)
•UDP stands for User Datagram Protocol
–It is an alternative to TCP
–The main difference is that TCP is highly reliable, at the cost of
decreased performance, while UDP is less reliable, but generally faster.
Chanderprabhu Jain College of Higher Studies & School of Law
Plot No. OCF, Sector A-8, Narela, New Delhi –110040
(Affiliated to Guru GobindSingh IndraprasthaUniversity and Approved by Govtof NCT of Delhi & Bar Council of India)