BCE Unit01
BCE Unit01
BCE Unit01
UNIT I
Computer: Definition, Classification, Organization i.e. CPU, register, Bus architecture,
Instruction set,Memory & Storage Systems, I/O Devices, and System & Application Software.
Computer Application ine-Business, Bio-Informatics, health Care, Remote Sensing & GIS,
Meteorology and Climatology,Computer Gaming, Multimedia and Animation etc.
Operating System: Definition, Function, Types, Management of File, Process & Memory.
Introdcution to MS word, MS powerpoint, MS Excel
UNIT II
Introduction to Algorithms, Complexities and Flowchart, Introduction to Programming,
Categories ofProgramming Languages, Program Design, Programming Paradigms,
Characteristics or Concepts of OOP,Procedure Oriented Programming VS object oriented
Programming.Introduction to C++: Character Set, Tokens, Precedence and Associativity,
Program Structure, Data Types,Variables, Operators, Expressions, Statements and control
structures, I/O operations, Array, Functions,
UNIT III
Object & Classes, Scope Resolution Operator, Constructors & Destructors, Friend Functions,
Inheritance,Polymorphism, Overloading Functions & Operators, Types of Inheritance, Virtual
functions.Introduction to Data Structures.
UNIT IV
Computer Networking: Introduction, Goals, ISO-OSI Model, Functions of Different Layers.
Internetworking Concepts, Devices, TCP/IP Model. Introduction to Internet, World Wide Web,
Ecommerce
Computer Security Basics: Introduction to viruses, worms, malware, Trojans, Spyware and Anti-
Spyware Software, Different types of attacks like Money Laundering, Information Theft,
CyberPornography, Email spoofing, Denial of Service (DoS), Cyber Stalking, ,Logic bombs,
HackingSpamming, Cyber Defamation , pharming Security measures Firewall, Computer Ethics
& Good Practices,Introduction of Cyber Laws about Internet Fraud, Good Computer Security
Habits,
UNIT V
Data base Management System: Introduction, File oriented approach and Database approach,
DataModels, Architecture of Database System, Data independence, Data dictionary, DBA,
Primary Key, Datadefinition language and Manipulation Languages.
Cloud computing: definition, cloud infrastructure, cloud segments or service delivery models
(IaaS, PaaSand SaaS), cloud deployment models/ types of cloud (public, private, community and
hybrid clouds), Prosand Cons of cloud computing
UNIT –I
Computer
Computer is an advanced electronic device that takes raw data as an input from the user and
processes it under the control of a set of instructions (called program), produces a result
(output), and saves it for future use
Functionalities of a Computer
If we look at it in a very broad sense, any digital computer carries out the following five
functions −
Step 1 − Takes data as input.
Step 2 − Stores the data/instructions in its memory and uses them as required.
Step 3 − Processes the data and converts it into useful information.
Step 4 − Generates the output.
Step 5 − Controls all the above four steps.
Advantages of Computers
Following are certain advantages of computers.
High Speed
Computer is a very fast device.
It is capable of performing calculation of very large amount of data.
The computer has units of speed in microsecond, nanosecond, and even the
picosecond.
It can perform millions of calculations in a few seconds as compared to man who will
spend many months to perform the same task.
Accuracy
In addition to being very fast, computers are very accurate.
The calculations are 100% error free.
Computers perform all jobs with 100% accuracy provided that the input is correct.
Storage Capability
Memory is a very important characteristic of computers.
A computer has much more storage capacity than human beings.
It can store large amount of data.
It can store any type of data such as images, videos, text, audio, etc.
Diligence
Unlike human beings, a computer is free from monotony, tiredness, and lack of
concentration.
It can work continuously without any error and boredom.
It can perform repeated tasks with the same speed and accuracy.
Versatility
A computer is a very versatile machine.
A computer is very flexible in performing the jobs to be done.
This machine can be used to solve the problems related to various fields.
At one instance, it may be solving a complex scientific problem and the very next
moment it may be playing a card game.
Reliability
A computer is a reliable machine.
Modern electronic components have long lives.
Computers are designed to make maintenance easy.
Automation
Computer is an automatic machine.
Automation is the ability to perform a given task automatically. Once the computer
receives a program i.e., the program is stored in the computer memory, then the
program and instruction can control the program execution without human
interaction.
Reduction in Paper Work and Cost
The use of computers for data processing in an organization leads to reduction in paper
work and results in speeding up the process.
As data in electronic files can be retrieved as and when required, the problem of
maintenance of large number of paper files gets reduced.
Though the initial investment for installing a computer is high, it substantially reduces
the cost of each of its transaction.
Disadvantages of Computers
Following are certain disadvantages of computers.
No I.Q.
A computer is a machine that has no intelligence to perform any task.
Each instruction has to be given to the computer.
A computer cannot take any decision on its own.
Dependency
It functions as per the user’s instruction, thus it is fully dependent on humans.
Environment
The operating environment of the computer should be dust free and suitable.
No Feeling
Computers have no feelings or emotions.
It cannot make judgment based on feeling, taste, experience, and knowledge unlike
humans.
Computer – Generations
Generation in computer terminology is a change in technology a computer is/was being used.
Following are the main five generations of computers.
2 Second Generation
The period of second generation: 1959-1965. Transistor based.
3 Third Generation
The period of third generation: 1965-1971. Integrated Circuit based.
4 Fourth Generation
The period of fourth generation: 1971-1980. VLSI microprocessor based.
5 Fifth Generation
The period of fifth generation: 1980-onwards. ULSI microprocessor based.
The period of first generation was from 1946-1959. The computers of first generation used
vacuum tubes as the basic components for memory and circuitry for CPU (Central Processing
Unit). These tubes, like electric bulbs, produced a lot of heat and the installations used to fuse
frequently. Therefore, they were very expensive and only large organizations were able to
afford it.
In this generation, mainly batch processing operating system was used. Punch cards, paper
tape, and magnetic tape was used as input and output devices. The computers in this
generation used machine code as the programming language.
In this generation, assembly language and high-level programming languages like FORTRAN,
COBOL were used. The computers used batch processing and multiprogramming operating
system.
system were used. High-level languages (FORTRAN-II TO IV, COBOL, PASCAL PL/1, BASIC,
ALGOL-68 etc.) were used during this generation.
method of making computers think like human beings. All the high-level languages like C and
C++, Java, .Net etc., are used in this generation.
AI includes −
Robotics
Neural Networks
Game Playing
Development of expert systems to make decisions in real-life situations
Natural language understanding and generation
The main features of fifth generation are −
ULSI technology
Development of true artificial intelligence
Development of Natural language processing
Advancement in Parallel Processing
Advancement in Superconductor technology
More user-friendly interfaces with multimedia features
Availability of very powerful and compact computers at cheaper rates
Some computer types of this generation are −
Desktop
Laptop
NoteBook
UltraBook
ChromeBook
Srajan Institute of Technology,Managemet & Science,Ratlam
Computer – Types
Computers can be broadly classified by their speed and computing power.
S.No. Type Specifications
PC (Personal Computer)
Although personal computers are designed as single-user systems, these systems are normally
linked together to form a network. In terms of power, now-a-days high-end models of the
Macintosh and PC offer the same computing power and graphics capability as low-end
workstations by Sun Microsystems, Hewlett-Packard, and Dell.
Workstation
Mainframe
Mainframe is very large in size and is an expensive computer capable of supporting hundreds
or even thousands of users simultaneously. Mainframe executes many programs concurrently
and supports many simultaneous execution of programs.
Supercomputer
Supercomputers are one of the fastest computers currently available. Supercomputers are
very expensive and are employed for specialized applications that require immense amount of
mathematical calculations (number crunching).
Srajan Institute of Technology,Managemet & Science,Ratlam
For example, weather forecasting, scientific simulations, (animated) graphics, fluid dynamic
calculations, nuclear energy research, electronic design, and analysis of geological data (e.g. in
petrochemical prospecting).
Computer – Components
All types of computers follow the same basic logical structure and perform the following five
basic operations for converting raw input data into information useful to their users.
S.No. Operation Description
The process of entering data and instructions into the computer system.
1 Take Input
Saving data and instructions so that they are available for processing as
2 Store Data and when required.
Output The process of producing useful information or results for the user, such
4 as a printed report or visual display.
Information
Control the Directs the manner and sequence in which all of the above operations are
5 performed.
workflow
Srajan Institute of Technology,Managemet & Science,Ratlam
Input Unit
This unit contains devices with the help of which we enter data into the computer. This unit
creates a link between the user and the computer. The input devices translate the information
into a form understandable by the computer.
CPU (Central Processing Unit)
CPU is considered as the brain of the computer. CPU performs all types of data processing
operations. It stores data, intermediate results, and instructions (program). It controls the
operation of all parts of the computer.
CPU itself has the following three components −
ALU (Arithmetic Logic Unit)
Memory Unit
Control Unit
Output Unit
The output unit consists of devices with the help of which we get the information from the
computer. This unit is a link between the computer and the users. Output devices translate the
computer's output into a form understandable by the users.
Central Processing Unit (CPU) consists of the following features −
CPU is considered as the brain of the computer.
CPU performs all types of data processing operations.
It stores data, intermediate results, and instructions (program).
It controls the operation of all parts of the computer.
Srajan Institute of Technology,Managemet & Science,Ratlam
This unit controls the operations of all parts of the computer but does not carry out any actual
data processing operations.
Functions of this unit are −
It is responsible for controlling the transfer of data and instructions among other units
of a computer.
It manages and coordinates all the units of the computer.
It obtains the instructions from the memory, interprets them, and directs the operation
of the computer.
It communicates with Input/Output devices for transfer of data or results from storage.
It does not process or store data.
ALU (Arithmetic Logic Unit)
This unit consists of two subsections namely,
Arithmetic Section
Logic Section
Arithmetic Section
Function of arithmetic section is to perform arithmetic operations like addition, subtraction,
multiplication, and division. All complex operations are done by making repetitive use of the
above operations.
Logic Section
Function of logic section is to perform logic operations such as comparing, selecting, matching,
and merging of data.
Input Devices
Following are some of the important input devices which are used in a computer −
Keyboard
Mouse
Joy Stick
Light pen
Track Ball
Scanner
Graphic Tablet
Microphone
Magnetic Ink Card Reader(MICR)
Optical Character Reader(OCR)
Bar Code Reader
Optical Mark Reader(OMR)
Keyboard
Keyboard is the most common and very popular input device which helps to input data to the
computer. The layout of the keyboard is like that of traditional typewriter, although there are
some additional keys provided for performing additional functions.
Srajan Institute of Technology,Managemet & Science,Ratlam
Keyboards are of two sizes 84 keys or 101/102 keys, but now keyboards with 104 keys or 108
keys are also available for Windows and Internet.
The keys on the keyboard are as follows −
S.No Keys & Description
Typing Keys
1 These keys include the letter keys (A-Z) and digit keys (09) which generally give the
same layout as that of typewriters.
Numeric Keypad
It is used to enter the numeric data or cursor movement. Generally, it consists of a set
2 of 17 keys that are laid out in the same configuration used by most adding machines
and calculators.
Function Keys
The twelve function keys are present on the keyboard which are arranged in a row at
3
the top of the keyboard. Each function key has a unique meaning and is used for
some specific purpose.
Control keys
These keys provide cursor and screen control. It includes four directional arrow keys.
4
Control keys also include Home, End, Insert, Delete, Page Up, Page Down,
Control(Ctrl), Alternate(Alt), Escape(Esc).
Srajan Institute of Technology,Managemet & Science,Ratlam
Mouse
Mouse is the most popular pointing device. It is a very famous cursor-control device having a
small palm size box with a round ball at its base, which senses the movement of the mouse
and sends corresponding signals to the CPU when the mouse buttons are pressed.
Generally, it has two buttons called the left and the right button and a wheel is present
between the buttons. A mouse can be used to control the position of the cursor on the screen,
but it cannot be used to enter text into the computer.
Advantages
Easy to use
Not very expensive
Moves the cursor faster than the arrow keys of the keyboard.
Joystick
Joystick is also a pointing device, which is used to move the cursor position on a monitor
screen. It is a stick having a spherical ball at its both lower and upper ends. The lower spherical
ball moves in a socket. The joystick can be moved in all four directions.
Srajan Institute of Technology,Managemet & Science,Ratlam
The function of the joystick is similar to that of a mouse. It is mainly used in Computer Aided
Designing (CAD) and playing computer games.
Light Pen
Light pen is a pointing device similar to a pen. It is used to select a displayed menu item or
draw pictures on the monitor screen. It consists of a photocell and an optical system placed in
a small tube.
When the tip of a light pen is moved over the monitor screen and the pen button is pressed,
its photocell sensing element detects the screen location and sends the corresponding signal
to the CPU.
Track Ball
Track ball is an input device that is mostly used in notebook or laptop computer, instead of a
mouse. This is a ball which is half inserted and by moving fingers on the ball, the pointer can
be moved.
Srajan Institute of Technology,Managemet & Science,Ratlam
Since the whole device is not moved, a track ball requires less space than a mouse. A track ball
comes in various shapes like a ball, a button, or a square.
Scanner
Scanner is an input device, which works more like a photocopy machine. It is used when some
information is available on paper and it is to be transferred to the hard disk of the computer
for further manipulation.
Scanner captures images from the source which are then converted into a digital form that can
be stored on the disk. These images can be edited before they are printed.
Digitizer
Digitizer is an input device which converts analog information into digital form. Digitizer can
convert a signal from the television or camera into a series of numbers that could be stored in
Srajan Institute of Technology,Managemet & Science,Ratlam
Digitizer is also known as Tablet or Graphics Tablet as it converts graphics and pictorial data
into binary inputs. A graphic tablet as digitizer is used for fine works of drawing and image
manipulation applications.
Microphone
Microphone is an input device to input sound that is then stored in a digital form.
The microphone is used for various applications such as adding sound to a multimedia
presentation or for mixing music.
This reading process is called Magnetic Ink Character Recognition (MICR). The main advantages
of MICR is that it is fast and less error prone.
OCR scans the text optically, character by character, converts them into a machine readable
code, and stores the text on the system memory.
Bar Code Reader scans a bar code image, converts it into an alphanumeric value, which is then
fed to the computer that the bar code reader is connected to.
It is specially used for checking the answer sheets of examinations having multiple choice
questions.
Output Devices
Monitors
Monitors, commonly called as Visual Display Unit (VDU), are the main output device of a
computer. It forms images from tiny dots, called pixels that are arranged in a rectangular form.
The sharpness of the image depends upon the number of pixels.
Srajan Institute of Technology,Managemet & Science,Ratlam
A finite number of characters can be displayed on a screen at once. The screen can be divided
into a series of character boxes - fixed location on the screen where a standard character can
be placed. Most screens are capable of displaying 80 characters of data horizontally and 25
lines vertically.
There are some disadvantages of CRT −
Large in Size
High power consumption
Flat-Panel Display Monitor
The flat-panel display refers to a class of video devices that have reduced volume, weight and
power requirement in comparison to the CRT. You can hang them on walls or wear them on
your wrists. Current uses of flat-panel displays include calculators, video games, monitors,
laptop computer, and graphics display.
Srajan Institute of Technology,Managemet & Science,Ratlam
Printers
Printer is an output device, which is used to print information on paper.
There are two types of printers −
Impact Printers
Non-Impact Printers
Impact Printers
Impact printers print the characters by striking them on the ribbon, which is then pressed on
the paper.
Characteristics of Impact Printers are the following −
Very low consumable costs
Very noisy
Useful for bulk printing due to low cost
There is physical contact with the paper to produce an image
These printers are of two types −
Character printers
Line printers
Character Printers
Character printers are the printers which print one character at a time.
These are further divided into two types:
Dot Matrix Printer(DMP)
Daisy Wheel
Srajan Institute of Technology,Managemet & Science,Ratlam
Advantages
Inexpensive
Widely Used
Other language characters can be printed
Disadvantages
Slow Speed
Poor Quality
Daisy Wheel
Head is lying on a wheel and pins corresponding to characters are like petals of Daisy (flower)
which is why it is called Daisy Wheel Printer. These printers are generally used for word-
processing in offices that require a few letters to be sent here and there with very nice quality.
Advantages
Srajan Institute of Technology,Managemet & Science,Ratlam
Advantages
Very high speed
Very high quality output
Good graphics quality
Supports many fonts and different character size
Disadvantages
Srajan Institute of Technology,Managemet & Science,Ratlam
Expensive
Cannot be used to produce multiple copies of a document in a single printing
Inkjet Printers
Inkjet printers are non-impact character printers based on a relatively new technology. They
print characters by spraying small drops of ink onto paper. Inkjet printers produce high quality
output with presentable features.
They make less noise because no hammering is done and these have many styles of printing
modes available. Color printing is also possible. Some models of Inkjet printers can produce
multiple copies of printing also.
Advantages
High quality printing
More reliable
Disadvantages
Expensive as the cost per page is high
Slow as compared to laser printer
Computer - Memory
A memory is just like a human brain. It is used to store data and instructions. Computer
memory is the storage space in the computer, where data is to be processed and instructions
required for processing are stored. The memory is divided into large number of small parts
called cells. Each location or cell has a unique address, which varies from zero to memory size
minus one. For example, if the computer has 64k words, then this memory unit has 64 * 1024
= 65536 memory locations. The address of these locations varies from 0 to 65535.
Memory is primarily of three types −
Cache Memory
Primary Memory/Main Memory
Secondary Memory
Srajan Institute of Technology,Managemet & Science,Ratlam
Cache Memory
Cache memory is a very high speed semiconductor memory which can speed up the CPU. It
acts as a buffer between the CPU and the main memory. It is used to hold those parts of data
and program which are most frequently used by the CPU. The parts of data and programs are
transferred from the disk to cache memory by the operating system, from where the CPU can
access them.
Advantages
The advantages of cache memory are as follows −
Cache memory is faster than main memory.
It consumes less access time as compared to main memory.
It stores the program that can be executed within a short period of time.
It stores data for temporary use.
Disadvantages
The disadvantages of cache memory are as follows −
Cache memory has limited capacity.
It is very expensive.
Secondary Memory
This type of memory is also known as external memory or non-volatile. It is slower than the
main memory. These are used for storing data/information permanently. CPU directly does
not access these memories, instead they are accessed via input-output routines. The contents
of secondary memories are first transferred to the main memory, and then the CPU can access
it. For example, disk, CD-ROM, DVD, etc.
It is a non-volatile memory.
Data is permanently stored even if power is switched off.
It is used for storage of data in a computer.
Computer may run without the secondary memory.
Slower than primary memories.
Random Access Memory
RAM (Random Access Memory) is the internal memory of the CPU for storing data, program,
and program result. It is a read/write memory which stores data until the machine is working.
As soon as the machine is switched off, data is erased.
Access time in RAM is independent of the address, that is, each storage location inside the
memory is as easy to reach as other locations and takes the same amount of time. Data in the
RAM can be accessed randomly but it is very expensive.
RAM is volatile, i.e. data stored in it is lost when we switch off the computer or if there is a
power failure. Hence, a backup Uninterruptible Power System (UPS) is often used with
computers. RAM is small, both in terms of its physical size and in the amount of data it can
hold.
RAM is of two types −
Static RAM (SRAM)
Dynamic RAM (DRAM)
Static RAM (SRAM)
The word static indicates that the memory retains its contents as long as power is being
supplied. However, data is lost when the power gets down due to volatile nature. SRAM chips
use a matrix of 6-transistors and no capacitors. Transistors do not require power to prevent
leakage, so SRAM need not be refreshed on a regular basis.
There is extra space in the matrix, hence SRAM uses more chips than DRAM for the same
amount of storage space, making the manufacturing costs higher. SRAM is thus used as cache
memory and has very fast access.
Characteristic of Static RAM
Srajan Institute of Technology,Managemet & Science,Ratlam
Long life
No need to refresh
Faster
Used as cache memory
Large size
Expensive
High power consumption
Let us now discuss the various types of ROMs and their characteristics.
MROM (Masked ROM);
The very first ROMs were hard-wired devices that contained a pre-programmed set of data or
instructions. These kind of ROMs are known as masked ROMs, which are inexpensive.
Advantages of ROM
The advantages of ROM are as follows −
Non-volatile in nature
Cannot be accidentally changed
Cheaper than RAMs
Easy to test
More reliable than RAMs
Static and do not require refreshing
Contents are always known and can be verified
Computer - Software
Software is a set of programs, which is designed to perform a well-defined function. A program
is a sequence of instructions written to solve a particular problem.
There are two types of software −
System Software
Application Software
System Software
The system software is a collection of programs designed to operate, control, and extend the
processing capabilities of the computer itself. System software is generally prepared by the
computer manufacturers. These software products comprise of programs written in low-level
languages, which interact with the hardware at a very basic level. System software serves as
the interface between the hardware and the end users.
Some examples of system software are Operating System, Compilers, Interpreter, Assemblers,
etc.
Application Software
Application software products are designed to satisfy a particular need of a particular
environment. All software applications prepared in the computer lab can come under the
category of Application software.
Application software may consist of a single program, such as Microsoft's notepad for writing
and editing a simple text. It may also consist of a collection of programs, often called a
software package, which work together to accomplish a task, such as a spreadsheet package.
Examples of Application software are the following −
Payroll Software
Student Record Software
Inventory Management Software
Income Tax Software
Railways Reservation Software
Microsoft Office Suite Software
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Computer - Applications
Business
Srajan Institute of Technology,Managemet & Science,Ratlam
A computer has high speed of calculation, diligence, accuracy, reliability, or versatility which
has made it an integrated part in all business organizations.
Computer is used in business organizations for −
Payroll calculations
Budgeting
Sales analysis
Financial forecasting
Managing employee database
Maintenance of stocks, etc.
Banking
Insurance
Insurance companies are keeping all records up-to-date with the help of computers. Insurance
companies, finance houses, and stock broking firms are widely using computers for their
concerns.
Insurance companies are maintaining a database of all clients with information showing −
Procedure to continue with policies
Starting date of the policies
Next due installment of a policy
Maturity date
Interests due
Survival benefits
Bonus
Education
Marketing
In marketing, uses of the computer are following −
Advertising − With computers, advertising professionals create art and graphics, write
and revise copy, and print and disseminate ads with the goal of selling more products.
Home Shopping − Home shopping has been made possible through the use of
computerized catalogues that provide access to product information and permit direct
entry of orders to be filled by the customers.
Healthcare
Computers have become an important part in hospitals, labs, and dispensaries. They are being
used in hospitals to keep the record of patients and medicines. It is also used in scanning and
diagnosing different diseases. ECG, EEG, ultrasounds and CT scans, etc. are also done by
computerized machines.
Following are some major fields of health care in which computers are used.
Diagnostic System − Computers are used to collect data and identify the cause of
illness.
Srajan Institute of Technology,Managemet & Science,Ratlam
Lab-diagnostic System − All tests can be done and the reports are prepared by
computer.
Patient Monitoring System − These are used to check the patient's signs for
abnormality such as in Cardiac Arrest, ECG, etc.
Pharma Information System − Computer is used to check drug labels, expiry dates,
harmful side effects, etc.
Surgery − Nowadays, computers are also used in performing surgery.
Engineering Design
Computers are widely used for Engineering purpose.
One of the major areas is CAD (Computer Aided Design) that provides creation and
modification of images. Some of the fields are −
Structural Engineering − Requires stress and strain analysis for design of ships,
buildings, budgets, airplanes, etc.
Industrial Engineering − Computers deal with design, implementation, and
improvement of integrated systems of people, materials, and equipment.
Architectural Engineering − Computers help in planning towns, designing buildings,
determining a range of buildings on a site using both 2D and 3D drawings.
Military
Srajan Institute of Technology,Managemet & Science,Ratlam
Computers are largely used in defence. Modern tanks, missiles, weapons, etc. Military also
employs computerized control systems. Some military areas where a computer has been used
are −
Missile Control
Military Communication
Military Operation and Planning
Smart Weapons
Communication
Communication is a way to convey a message, an idea, a picture, or speech that is received
and understood clearly and correctly by the person for whom it is meant. Some main areas in
this category are −
E-mail
Chatting
Usenet
FTP
Telnet
Video-conferencing
Srajan Institute of Technology,Managemet & Science,Ratlam
Government
Computers play an important role in government services. Some major fields in this category
are −
Budgets
Sales tax department
Income tax department
Computation of male/female ratio
Computerization of voters lists
Computerization of PAN card
Weather forecasting
Instruction set
An instruction set is a group of commands for a CPU in machine language. The term can refer to
all possible instructions for a CPU or a subset of instructions to enhance its performance in
certain situations.
All CPUs have instruction sets that enable commands to the processor directing the CPU to
switch the relevant transistors. Some instructions are simple read, write and movecommands
that direct data to different hardware.
In CISC (Complex Instruction Set Computer) processors there is also a microcode layer, which
involves programmable instructions stored in fast memory that may be updated.
The RISC (Reduced Instruction Set Computer) architecture, on the other hand, has hard-wired
control; it does not require microcode but has a greater base instruction set.
Srajan Institute of Technology,Managemet & Science,Ratlam
BUS
Inside computers, there are many internal components. In order for these components to
communicate with each other they make use of wires that are known as a ‘bus’ .
A bus is a common pathway through which information flows from one computer component
to another. This pathway is used for communication purpose and it is established between two
or more computer components
A data bus will contain actual data that has either just been read from memory or is about to be
written to a memory location. A data bus is bi-directional, which means that information can
either be written or read using the bus lines.
An address bus contains location information. Address bus is unidirectional and usually the
main processing unit writes location information on it of where data will be read from or
written to.
A control bus will transmit commands or control signals between different components. The
data present on a control bus will determine the period for which a device can access the other
busses and one or more command signals that will determine what kind of operation the device
has to execute.
Operating System
The Operating System is a program with the following features −
An operating system is a program that acts as an interface between the software and
the computer hardware.
It is an integrated set of specialized programs used to manage overall resources and
operations of the computer.
It is a specialized software that controls and monitors the execution of all other
programs that reside in the computer, including application programs and other system
software.
The users of a batch operating system do not interact with the computer directly. Each user
prepares his job on an off-line device like punch cards and submits it to the computer
operator. To speed up processing, jobs with similar needs are batched together and run as a
group. The programmers leave their programs with the operator and the operator then sorts
the programs with similar requirements into batches.
The problems with Batch Systems are as follows −
The processors communicate with one another through various communication lines (such as
high-speed buses or telephone lines). These are referred as loosely coupled systems or
distributed systems. Processors in a distributed system may vary in size and function. These
processors are referred as sites, nodes, computers, and so on.
The advantages of distributed systems are as follows −
With resource sharing facility, a user at one site may be able to use the resources
available at another.
Speedup the exchange of data with one another via electronic mail.
If one site fails in a distributed system, the remaining sites can potentially continue
operating.
Better service to the customers.
Reduction of the load on the host computer.
Reduction of delays in data processing.
MS WORD
It is an application Software that is designed for the entry, editing, and printing of documents
Word processing documents include: E-mail , One page flyers , Reports , Mail Merges , Faxes ,
Memorandums , Letters
Features
Character formatting
Paragraph formatting
Wizards- step by step tutorial
Thesaurus
Grammar Checker
Spell Checker
Srajan Institute of Technology,Managemet & Science,Ratlam
Mail merge
Auto correct
Auto text
etc
Microsoft Excel
It is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features
calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic
for Applications. It has been a very widely applied spreadsheet for these platforms, especially
since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for
spreadsheets.
Microsoft Excel is a spreadsheet program that is used to record and analyse numerical data.
Think of a spreadsheet as a collection of columns and rows that form a table. Alphabetical
letters are usually assigned to columns and numbers are usually assigned to rows. The point
where a column and a row meet is called a cell. The address of a cell is given by the letter
representing the column and the number representing a row. Let's illustrate this using the
following image.
We all deal with numbers in one way or the other. We all have daily expenses which we pay for
from the monthly income that we earn. For one to spend wisely, they will need to know their
income vs. expenditure. Microsoft Excel comes in handy when we want to record, analyze and
store such numeric data.
Srajan Institute of Technology,Managemet & Science,Ratlam
Ribbon is on the top of worksheet, below the title bar or name of the excel file. It contains
seven tabs: Home, Insert, Page Layout, Formulas, Data, Review and View.
Each tab has its own specific groups of related commands. These groups have several additional
commands that can be viewed by clicking the arrow at the right bottom corner of any group.
There are many tabs available in Microsoft Excel: Home, Insert, Page Layout, Formula, Data,
Review and View. Each tab has different features.
The features of the Home tab are:
Clipboard, Font, Alignment, Number, Cells and Editing
Srajan Institute of Technology,Managemet & Science,Ratlam
Worksheet
Rows
Rows run horizontally across the worksheet and ranges from 1 to 1048576. A row is identified
by the number that is on left side of the row, from where the row originates.
Columns
Columns run vertically downward across the worksheet and ranges from A to XFD - 1 to 16384.
A column is identified by a column header that is on the top of the column, from where the
column originates.
Cells
Cells are small boxes in the worksheet where we enter data. A cell is the intersection of a row
and column. It is identified by row number and column header such as A1, A2.
MS- PowerPoint
PowerPoint is the powerful and ubiquitous presentation program from Microsoft. It gives you
the facility to create stunning presentations that incorporate video and PowerPoint animations.
The image editing capabilities that PowerPoint offer get better and better with every new
version.
Microsoft PowerPoint is a software program developed by Microsoft to produce effective
presentations. It is a part of Microsoft Office suite. The program comprises slides and various
tools like word processing, drawing, graphing and outlining. Thus it can display text, table,
chart, graphics and media in the slides.
Srajan Institute of Technology,Managemet & Science,Ratlam
There are three main features of the Microsoft PowerPoint window that you need to focus
upon while learning PowerPoint. These features are Microsoft Office Button, Quick Access
Toolbar and Ribbon.
Microsoft Office Button is located on the upper-left corner of the PowerPoint window.
See the image:
When you click the button it displays a menu with multiple options to perform different tasks.
See the image:
Srajan Institute of Technology,Managemet & Science,Ratlam
It is located beside the Microsoft Office Button. By default it shows three commands; Save,
Undo and Redo.
See the image:
Srajan Institute of Technology,Managemet & Science,Ratlam
When you click the drop-down arrow at the right end of Quick Access Toolbar it offers more
commands. The desired command out of these commands can be added to Quick Access
Toolbar with a left click on it.
See the image:
You can also add the Office Button and Ribbon commands. Just right click the command and
select the "Add to Quick Access Toolbar" option. See the image, the command New Slide is
added to Quick Access Toolbar.
Srajan Institute of Technology,Managemet & Science,Ratlam
Ribbon is located on the top of the PowerPoint window just below the Title bar. It is made up of
seven tabs; Home, Insert, Design, Animations, Slide Show, Review and View. Each tab is divided
into groups of related commands that are displayed on the Ribbon. To view additional
commands of a group click the arrow at the right bottom corner of the group.
Slide: Presentation is created on slides. It lies in the centre of the PowerPoint window.
Placeholder: By default two placeholders appear in the slide when you open the PowerPoint.