A

PRACTICAL FILE
ON
IT SKILLS
PAPER CODE: BMB 151
Submitted for partial fulfillment of requirement for the award of
degree
Of
MBA
(SESSION:2025-2027)

SUBMITTED TO SUBMITTED BY:

Ms. MONIKA BHATIA KOMAL GARG

ASST. PROFESSOR MBA-1st SEM
MBA-1ST SEM ROLL NO: 25MB046

HIERANK BUSINESS SCHOOL

A-42 INDUSTRIAL AREA, SECTOR-62, NOIDA
(Affiiated to CCS University, Meerut)
 Acknowledgement

A successful project is a result of teamwork and coordination that

includes not only the group of developers who put forth the ideas logic
and efforts but also those who guides them so at the completion of the
project. I feel obliged to extend my gratitude towards all those made
valuable contributions

In addition I wish to convey a deep sense of gratitude towards Dr.

Monica Bhatia at anytime I needed

In the end just a significantly I would request I like to express my

sincere thanks to doctor Monica Bhatia and all others who have provided
me accent excellent knowledge and support throughout my post
graduation I am very much thankful to my parents brother and friends
for their continuous support
DECLARATION
 Certificate

Date: ……………….

TO WHOM SO EVER IT MAY CONCERN

This is to certify that Mr/Ms………………………… is a bonafide student of

MBA 1st Year of this institute for the session (2025-27) and he/she has
prepared IT skills lab I Report titled
“………………………………………………………………………………
……………………………….”, for partial fulfillment of Master of Business
Administration (MBA) affiliated to Dr. A P J Abdul Kalam Technical
University, LUCKNOW.

I wish him/her all the best for his/her future endeavour’s.

1)​ Computer Overivew

[Link] of computer

2)​ Computer Components

a.​ Hardware

b.​ Software

3)​ Input devices in Computer

4)​ Output devices in Computer

5)​ Software: Types of software with examples

6)​ Computer Memory

a.​ RAM

b.​ ROM

7)​ Computer Network and Types of Network with examples

8)​ Internet and it’s application areas

a.​ Basic services over Internet

9)​ Windows operating System: Introduction and characteristics.

10)​ Word Processing Concepts

11)​ Spreadsheet

12)Interface of the Presentation Package

❖​ Computer Overview

A computer is an advanced electronic device that accepts data as input,

processes it according to the provided instructions, and produces meaningful
information as output. Modern computers are extremely fast, accurate, and
capable of performing billions of operations per second. They are used in
areas like education, medicine, business, science, communication,
entertainment, banking, research, and more.

A. Functionalities of Computer
A computer performs seven major functions:
[Link] Function

❖​ The computer first accepts data and instructions from the user or
another device.
❖​ Input devices convert human-readable data into machine-readable
form.

❖​ Examples of Input Devices

Keyboard
Mouse
Scanner
Microphone
Touchscreen

2. Processing Function
 ❖​ After receiving input, the computer’s CPU (Central Processing Unit)
processes the data.
❖​ It performs calculations, comparisons, and decisions based on
instructions.

Key Components

​ ALU (Arithmetic Logic Unit): Performs mathematical an

3. Output Function

❖​ Once processing is complete, the computer displays or sends out the

result.

❖​ Examples of Output Devices

Monitor
Printer
Speaker
Projector

4.​ Storage Function

❖​ Computers can store data permanently or temporarily.

❖​ Types of Storage

Primary Storage (RAM) – temporary, used while tasks are running

Secondary Storage – permanent (Hard disk, SSD, Pen drive).

[Link] Function
 ❖​ The computer has a control unit that manages and coordinates all
operations.
❖​ It ensures that input, processing, and output happen in the correct
sequence.

❖​ Examples

Telling input devices when to accept data

Instructing ALU to perform a task
Sending results to output devices

[Link] Movement / Data Transfer Function

❖​ Computers transfer data internally between memory, CPU, and storage

as well as externally between devices.

❖​ Examples

Transferring files from phone to PC

Sending data to the internet
Data transfer between RAM and CPU

[Link]-Making Function

❖​ Computers make logical decisions based on conditions and

instructions.

❖​ Example

If a condition is true → perform action A

If false → perform action B
 ❖​ Used in:

Banking systems
Traffic control
Games
Software automation

❖​ Computer Components

Computer system is made up of several components that work together to

perform tasks. These components are divided into hardware and software.

A .Hardware
Hardware refers to all the physical components of a computer system. These
parts can be touched, seen, and replaced.
Hardware is divided into several categories:

[Link] Devices

❖​ These devices allow users to enter data, commands, and information

into the computer.

a .Keyboard

❖​ Most common input device.

 ❖​ Contains keys for alphabets, numbers, functions, and special
characters.

❖​ Types: QWERTY, Wireless, Virtual keyboard.

b) Mouse

❖​ A pointing device used to control the cursor.

❖​ Operations: Click, right-click, double-click, drag-and-drop.

❖​ Types: Optical, Wireless, Gaming mouse.

c) Scanner

❖​ Converts physical documents into digital format.

❖​ Types: Flatbed, Handheld, Barcode scanners.

d) Microphone

❖​ Uses sound input for recording audio, voice commands, and online
communication.

e) Webcam

❖​ Captures images or video input.

f) Touchscreen
 ❖​ Acts as both an input and output device.

❖​ Used in smartphones, ATMs, tablets, etc.

[Link] Devices

❖​ These devices display or deliver the results of computer processing.

[Link]

❖​ Primary output device.

❖​ Types:

CRT (Old)
LCD / LED (Common)
OLED (Advanced)
Displays videos, text, images.

b. Printer

❖​ Produces hard copies of documents.

❖​ Types:

Inkjet (Home use)

Laser (Office use)
Dot-matrix (Bill printing)

C. Speakers & Headphones

❖​ Output sound such as music, calls, and alerts.

 d. Projector

❖​ Displays computer screen on a larger surface like walls or screens.

[Link] Processing Unit (CPU) – The Brain of Computer

❖​ The CPU processes all input and produces output.

​ It has three main parts:

❖​ ALU (Arithmetic and Logic Unit)

Performs arithmetic operations (add, subtract, multiply, divide).

Performs logic operations (compare, true/false decisions).

❖​ Control Unit (CU)

Controls the flow of data and instructions.

Manages communication between hardware components.

❖​ Registers

Extremely fast memory inside CPU.

Stores temporary data and instructions

4. Memory (Primary Storage)

a) RAM (Random Access Memory)
Temporary memory, data is lost when power is off.
Stores currently running applications.

Types:
 DRAM
SRAM

b) ROM (Read Only Memory)

Permanent memory.
Stores essential instructions required for booting the computer.

Types:
Masked ROM (MROM)
PROM (Programmable ROM)

b. Software
Software is a collection of instructions, data, or programs that tell hardware
how to operate. It is intangible.

Types of Software:
System Software – System software is the foundational software that
manages the hardware of a computer and provides a platform for application
software to run.
It acts as a bridge between the user, hardware, and application programs.

❖​ Example: Windows, macOS, Linux, Android, BIOS, Device Drivers,

etc.

Application Software :-
Application software refers to programs that help users perform specific tasks
or solve particular problems.
These tasks can be related to education, business, entertainment, personal use,
or communication.
 ❖​ Examples: MS Office, Google Chrome, WhatsApp, Tally, Photoshop,
VLC Media Player.

Utility Software – Utility software is a type of system software designed to maintain,

optimize, and protect a computer system.​
It helps the operating system run smoothly and improves the overall performance of the
device.
Examples: Antivirus, Disk Clean up, Backup tools, File Compression (ZIP, WinRAR)

❖​ Input Devices in Computer

Input devices in a computer are hardware components used to enter data,

instructions, and commands into the system. They allow users to interact with
the computer by providing information that the computer processes.

Examples & Explanation :-

❖​ Keyboard: A keyboard is a primary input device used to enter data,

instructions, and commands into a computer. It consists of a set of keys
that allow users to type letters, numbers, symbols, and perform various
functions.

❖​ Mouse: A mouse is an important pointing device used to control the

cursor on a computer screen. It allows users to select items, open files,
drag objects, and interact with different software applications. The
mouse usually has two main buttons—left and right—and a scroll
wheel for moving up and down on a page.

❖​ Scanner: A scanner is an input device used to convert physical

documents, photos, or printed images into digital format. It captures
the details of a paper document and stores it as an image or text file on
 the computer. Scanners use light sensors to read the content and create
a high-quality digital copy that can be edited, stored, or shared easily.

❖​ Barcode Reader: A barcode reader is an input device used to scan and

read information stored in barcodes. It uses a light beam to capture the
pattern of black and white bars printed on products, labels, or tags.
Once scanned, the reader converts these patterns into digital data and
sends it to the computer or billing system.

❖​ Microphone: A microphone is an input device used to capture sound

and convert it into electrical or digital signals that a computer can
process. It allows users to record their voice, give voice commands,
participate in video calls, and create audio content like music, podcasts,
or presentations.

❖​ Webcam: A webcam is an input device used to capture live video and

images for computers. It allows users to participate in video calls,
online classes, meetings, and live streaming by transmitting real-time
visuals over the internet. Most webcams come with a built-in
microphone and can be attached externally or integrated into laptops.
They help in face-to-face communication, recording videos, and
enhancing online interactions with clear visuals.

❖​ Touchscreen: A touchscreen is an input device that allows users to

interact directly with a computer or mobile device by touching the
screen with a finger or stylus. It replaces the need for a keyboard or
mouse by enabling users to tap, swipe, drag, and zoom on the display.
Touchscreens are commonly used in smartphones, tablets, ATMs,
kiosks, and modern laptops. They make navigation faster, more
intuitive, and user-friendly, allowing even beginners to operate devices
easily.
❖​ Output Devices in Computer

An output device in a computer is a hardware component that receives data

from the computer and presents it to the user in a readable or usable form. It
converts digital information into forms such as text, images, sound, or video.
Common output devices include monitors, which display visual information;
printers and plotters, which produce hard copies; speakers and headphones,
which output sound; and projectors, which display large-screen visuals for
audiences.
Output devices return processed data in readable or usable forms.

❖​ Examples:

❖​ Monitor: A monitor is an important output device that displays text,

images, videos, and other information generated by the computer. It
allows users to visually interact with software, applications, and
multimedia content. They are essential for tasks like browsing, gaming,
designing, and watching videos. A monitor functions as the main
visual interface between the user and the computer, making it easier to
understand and control all activities performed on the system.

❖​ Printer: A printer is an output device that produces a hard copy of

documents, images, or any information displayed on a computer
screen. It converts digital data into printed form on paper. Printers are
commonly used in homes, schools, offices, and businesses for printing
reports, photos, assignments, invoices, and more. There are different
 types of printers, such as inkjet, laser, and dot matrix, each suited for
specific needs.

❖​ Speakers: Speakers are output devices that produce sound from a

computer or electronic device. They convert digital audio signals into
audible sound waves, allowing users to hear music, videos,
notifications, and other audio content clearly. Speakers are commonly
used in computers, TVs, smartphones, and multimedia systems. They
enhance the user experience by providing better sound quality for
entertainment, gaming, online classes, and video calls.

❖​ Projector: A projector is an output device that displays images, videos,

or presentations onto a large screen or wall. It takes visual data from a
computer, laptop, or other device and projects it using light, making it
useful for classrooms, meetings, seminars, and home theatres.
Projectors help a large audience view the same content clearly at the
same time.

❖​ Plotter: A plotter is an output device used to produce large-sized,

high-quality drawings, graphics, and designs. Unlike a printer, a plotter
draws images using pens, markers, or special ink, which makes it ideal
for technical drawings that require precision. Plotters are commonly
used by engineers, architects, designers, and mapmakers to create
blueprints, architectural plans etc. They can print on large sheets of
paper, vinyl, or plastic with accurate lines and detailed curves.
❖​ Software: Types of Software with Examples

Software programs help computers perform multiple activities.

Types:

System software is the software that controls and manages the hardware and
basic operations of a computer. It acts as a link between the user and the
machine, helping other software run smoothly. It includes the operating
system, device drivers, utility programs, and language translators. Without
system software, a computer cannot function or run applications.

Application Software: Application software refers to programs designed to

help users perform specific tasks on a computer. These tasks can include
creating documents, making presentations, doing calculations, editing photos,
browsing the internet, or managing data. Examples include MS Word, MS
Excel, PowerPoint, web browsers, media players, and games. Application
software runs on top of system software and allows users to complete their
work easily and efficiently.
 ❖​ Examples: MS Word, Excel, PowerPoint, Google Chrome

Utility Software: Utility software is a type of system software designed to help manage,
maintain, and control computer resources. These software tools perform housekeeping
tasks to ensure that the computer works efficiently and securely.
Utility software does not run the computer, but it supports the operating system by
improving performance, protecting data, and managing files.

❖​ Examples: Antivirus, Backup Tools, WinZip

Programming Software:
Programming Software refers to the set of tools that computer programmers
use to create, edit, test, and maintain computer programs. These tools help
developers write code efficiently and convert it into a form that computers
can understand.

❖​ Examples: Python, Java, C++, Visual Studio

❖​ Computer Memory

Computer memory refers to the parts of a computer system that store data,
instructions, and information. It helps the computer perform tasks, run
programs, and keep information available for processing.

Computer memory is mainly divided into Primary Memory and Secondary

Memory.
[Link] Memory (Main Memory)

❖​ Primary memory is the memory that the computer uses directly while performing
tasks. It is fast but limited in size.

❖​ Primary memory is the memory that the computer uses directly while
performing tasks. It is fast but limited in size.
[Link] (Random Access Memory):- RAM (Random Access Memory)
is a type of computer memory that stores data and instructions that the CPU
needs right now.
It is temporary memory — the data disappears when the computer is turned
off.

Key Features of RAM

 ❖​ Volatile Memory

Data is stored only while the computer is ON.

When the power goes off, data is erased.

❖​ Fast Access

RAM is much faster than hard drives or SSDs.

This speed helps your computer run apps smoothly.

❖​ Temporary Storage

Used to store:
Open applications
Running program
Currently used files

❖​ Direct Access

CPU can access any part of RAM directly, without reading in order.

Types of RAM
1.​ SRAM (Static RAM)
Faster and more expensive
Used in cache memory
 [Link] (Dynamic RAM)
Slower and cheaper
Used as main memory in computers

1.​ ROM (Read Only Memory)

ROM is a type of permanent memory in a computer.
It stores essential instructions that are needed for the computer to start
and work properly.
The data in ROM cannot be changed easily and remains safe even when
the power is turned off.

Features of ROM
[Link]-volatile Memory
Data remains safe even when power is turned off.

[Link] Storage
Stores essential programs permanently (like BIOS).

[Link] Be Modified Easily

Data is written once and difficult to change.

[Link] and Stable

Does not lose data and provides stable performance.

[Link] for Booting

Stores instructions that the computer uses during start-up.

Types of ROM
 [Link] (Programmable ROM)
Can be programmed only once.
After programming, the data cannot be changed.

[Link] (Erasable Programmable ROM)

Can be erased using ultraviolet (UV) light.
Rewritable after erasing.

[Link] (Electrically Erasable Programmable ROM)

Can be erased electrically, no light needed.
Data can be updated easily.

[Link] ROM
Faster version of EEPROM.
Used in pen drives, memory cards, BIOS, etc.

❖​ Computer Network and Types of Network with Examples

A computer network is a group of interconnected computers that share

resources and data.

Types of Networks:
LAN (Local Area Network):
Local Area Network (LAN) is a type of computer network that connects
computers and other devices within a small geographical area. It is commonly
used in places like homes, schools, offices, computer labs, libraries, and small
organizations.
A LAN allows multiple devices to share information, resources, and services
such as printers, files, internet connections,

⭐ Local Area Network (LAN): Detailed Features

A LAN (Local Area Nework) connects computers within a small
geographical area such as a home, office, school, or building.
Features
[Link] Data Transfer Speed:-

❖​ Speed ranges from 100 Mbps to 10 Gbps.

❖​ Ideal for fast sharing of files, applications, and printers.

[Link] Installation & Maintenance Cost

❖​ Uses inexpensive cables (Ethernet) and network hardware.

❖​ Requires less complex infrastructure.

[Link] Security

❖​ Controlled by a single organization.

❖​ Easy to implement firewalls, access control, and user restrictions.

1.​ Allows Resource Sharing

❖​ Users can share files, printers, scanners, internet, and software.

❖​ Increases efficiency and reduces cost.

2.​ Less Error & High Reliability

❖​ Fewer external disturbances.

❖​ Stable connection due to short distance wiring.

3.​ Uses Wired and Wireless Technology

❖​ Wired LAN → Ethernet cables
 ❖​ Wireless LAN → Wi-Fi

4.​ Easy Setup and Troubleshooting

❖​ Less complex and easier to configure.

❖​ Troubleshooting issues is faster.

❖​ Example: School computer labs.

MAN (Metropolitan Area Network):

A Metropolitan Area Network (MAN) is a type of computer network that
covers a larger geographic area than a LAN but smaller than a WAN. It
typically spans a city, town, or a large campus. MAN connects multiple
LANs within the same metropolitan region to share resources and
communicate efficiently.

MAN networks are widely used by government agencies, educational

institutions, cable TV providers, and telecom

Features of MAN (Metropolitan Area Network )

[Link] a Large Geographical Area:-

❖​ MAN typically spans 10–50 kilometers.

❖​ It connects multiple LANs within a city, metropolitan area, or several

nearby towns.

[Link] Data Transmission Speed

❖​ Faster than WAN but slightly slower than LAN.

❖​ Usually uses fiber optic cables for high-speed communication.

[Link] Multiple Users

❖​ Designed to connect hundreds or thousands of users.

❖​ Commonly used by government offices, universities, cable TV networks,

etc.

[Link] Multiple LANs

❖​ MAN links different LANs of schools, hospitals, offices, and

organizations within a city.
❖​ Helps share data smoothly across locations.

[Link] and Reliable Communication

❖​ Designed for continuous and stable connectivity.

❖​ Less prone to breakdowns because it uses advanced wired technologies.

[Link] High-Quality Transmission Media

❖​ Mostly uses fiber optics, microwave links, or leased telephone lines.

❖​ These support high bandwidth and long-distance communication.

[Link] Cost

❖​ Cost is higher than LAN but lower than WAN.

❖​ Often maintained by telecom companies or government bodies.

❖​ Example: Cable TV network.

WAN (Wide Area Network):

 Wide Area Network (WAN) is a computer network that covers a very large
geographical area, such as a country, continent, or even the entire world.
WANs are used to connect multiple LANs and MANs so that users in distant
locations can communicate and share information.

The biggest example of a WAN is the Internet, which connects millions of

networks worldwide

Features of WAN
Very Large Coverage Area

❖​ WAN can cover multiple cities, states, countries, or continents.

Interconnects Many Networks

❖​ It links LANs and MANs that are miles apart.

Uses Public Communication Channels

❖​ WAN often uses telephone lines, satellites, fiber optics, or microwave

links.

Lower Speed Compared to LAN/MAN

❖​ Because of the long distance, speed may be lower or more expensive.

High Cost

❖​ Installation and maintenance are costly as WAN requires advanced

equipment.

Used by Organizations with Multiple Branches

❖​ Banks, multinational companies, government agencies, etc.

Internet and Its Application Areas

The Internet is a worldwide network of interconnected computers that

communicate using standardized protocols. It allows billions of devices across
the world to share information, communicate, and access services. It is
considered the backbone of today’s digital world.

The internet works through a system of servers, routers, and communication

cables that enable data to travel from one point to another in milliseconds. It
supports several services such as email, websites, social media, cloud storage,
multimedia streaming, and more.

Major Application Areas of the Internet

[Link]:-
Communication refers to the exchange of data, instructions, and information
between two or more computers or devices using communication channels like
cables, Wi-Fi, Bluetooth, or the internet.

In simple words, it means computers talking to each other to share information.

Examples:-

❖​ Email (Electronic mail): E-mail is an electronic method of

communication used to send messages and files from one computer or
device to another over the internet.
 Instant Messaging: Instant Messaging is an internet-based service that
allows users to exchange text messages, images, videos, and files
instantly in real time.

Video Conferencing: Video conferencing is a method of

communication that enables two or more people to conduct
face-to-face meetings using video and audio transmission over the
internet.

Social Networking:
Social networking is the use of internet-based platforms to create,
maintain, and grow relationships with people by sharing content,
messages, and interactions.

VoIP Calls:
VoIP (Voice over Internet Protocol) is a technology that allows users
to make voice and video calls using the internet instead of a traditional
telephone network.
Importance: Saves time, reduces communication cost, supports
real-time exchange.

[Link] & E-Learning

E-Learning is a method of education that uses electronic technologies and
the internet to deliver lessons, courses, and training to learners anywhere and
anytime.
Examples

❖​ Online courses (Coursera ) :-An online course is a structured learning

program delivered through digital platforms that includes lessons,
videos, quizzes, assignments, and certificates, all accessible through
the internet.

❖​ Virtual classrooms (Google Classroom):-virtual classroom is a digital

space where teachers conduct live online classes using video
conferencing tools, allowing students to learn, ask questions, and
participate from any location.
 ❖​ Digital libraries and e-books:-digital library is an electronic database
that stores digital versions of books, research papers, magazines, and
other learning materials for easy online access.

e-book is a digitally formatted book that can be read electronically on

devices such as smartphones, tablets, laptops, or e-readers.

❖​ Educational videos (YouTube):-Educational videos on YouTube are

video lessons created by teachers, professionals, institutions, and
experts to help learners understand different subjects easily. These
videos cover almost every topic—from science, maths, and coding to
languages, history, arts, and exam preparation

❖​ Research papers and academic website:- Research papers are formal

academic documents written by researchers, scientists, or scholars.
They present new findings, experiments, theories, or analysis on a
specific topic. In education and e-learning, research papers help
students and teachers stay updated with the latest knowledge.

Importance: Makes education accessible to all, supports distance

learning, and improves student performance.

[Link] Banking & Finance

Online banking and finance refer to the use of internet and digital platforms
to manage money, make payments, transfer funds, and access financial services.
It allows customers to perform almost all banking activities without visiting a
physical bank.
Examples:-

❖​ Net banking :- Net banking is an electronic system that enables customers

to access banking services such as checking account balances,
transferring funds, paying bills, and managing accounts online through a
computer or mobile device.
❖​ UPI transactions :-UPI (Unified Payments Interface) is a real-time
payment system developed by NPCI (National Payments Corporation of
India) that allows users to instantly send or receive money using a mobile
phone. It works 24/7 and does not require bank account details—only a
UPI ID or QR code.

❖​ Online fund transfer (NEFT, RTGS, IMPS):-Online Fund Transfer refers

to sending money electronically from one bank account to another using
the internet. It allows users to transfer funds quickly and safely without
visiting the bank.

❖​ Mobile banking apps :- Mobile Banking Apps are smartphone

applications provided by banks that allow customers to access and
manage their bank accounts anytime, anywhere. Using these apps, users
can check balances, transfer money, pay bills, and perform many banking
services directly from their mobile phones.

❖​ Online trading (stocks & crypto):- Online Trading Apps are mobile
applications that allow users to buy and sell financial instruments like
stocks, mutual funds, bonds, commodities, and currencies directly from
their smartphones. These apps connect users to the stock market in real
time, making trading easy, fast, and accessible from anywhere.

Importance: Safe and fast transactions, 24×7 availability, cashless economy.

[Link] & Multimedia

❖​ Entertainment and Multimedia refers to the use of digital technology

to create, store, deliver, and enjoy different forms of entertainment
such as music, videos, games, animations, movies, and interactive
content. It uses a combination of text, audio, video, graphics, and
animation to provide engaging and interactive user experiences.
 ❖​ Video streaming: Video Streaming is a technology that allows users to
watch videos online in real-time without downloading the entire file.
The video plays almost instantly because it is sent in small data
packets over the internet.

Platforms like YouTube, Netflix, Amazon Prime Video, Hotstar, and

Instagram use video streaming to deliver movies, shows, and live videos

❖​ Music streaming: Music Streaming is a technology that allows users to

listen to music online without downloading the audio files. The songs
play instantly over the internet, similar to radio, but with the option to
choose any track, playlist, or album.

❖​ Popular music-streaming platforms include Spotify, Gaana, JioSaavn,

Apple Music, YouTube Music, and Wynk.

❖​ Online gaming: Online Gaming refers to playing video games over the
internet using computers, smartphones, gaming consoles, or tablets.
Players can compete or cooperate with others in real time from
anywhere in the world.
❖​ Popular online games include BGMI, Free Fire, Fortnite, PUBG, Call
of Duty, Valorant, Minecraft, and more.

❖​ Social media entertainment: Social Media Entertainment refers to the

enjoyment and engagement people get from using social media
platforms like Instagram, YouTube, Facebook, TikTok, Snapchat, and
Twitter. These platforms allow users to watch, create, share, and
interact with videos, memes, photos, reels, live streams, and other
entertaining content.

Importance: Easily accessible entertainment anytime, anywhere.

[Link] Sharing & Web Browsing
Information Sharing refers to the process of exchanging data, messages, files,
images, and knowledge with others through digital platforms. It allows
people to communicate quickly and efficiently across the world.
Web Browsing is the activity of exploring or viewing information on the
internet using a web browser like Google Chrome, Firefox, Safari, or Edge.
Users search for information through search engines such as Google, Bing, or
Yahoo
Examples:-

❖​ Search engines:Search Engine is an online tool that helps users find

information on the internet. When you type a query (keywords), the
search engine scans billions of web pages and shows the most relevant
results.

❖​ Online news portals: Online News Portals are websites and apps that
provide news and information through the internet. They publish the
latest updates on politics, sports, entertainment, business, technology,
weather, and world events in real time. Examples include Times of
India, BBC News, NDTV, India Today, The Hindu, Aaj Tak, and
Google News.

Blogs and articles:-

❖​ Blog is an online platform or webpage where individuals or groups

regularly post content such as opinions, experiences, tutorials, stories,
reviews, or informational posts. Blogs are usually written in a personal
and conversational style.
❖​ An Article is a written piece of content that provides detailed, factual,
and well-researched information on a particular topic. Articles are
more formal and structured compared to blogs.

Examples: Travel blogs, Food blogs, Fashion blogs, Tech blogs, Study blogs.
Government information portals

Importance: Helps in decision making, awareness, learning, and research.

5.​ Online Booking & Reservations

❖​ Online Booking and Reservations refer to using websites or mobile apps

to book services such as travel tickets, hotels, movie seats, doctor
appointments, events, and more. It allows users to check availability,
compare options, make payments, and confirm bookings instantly
through the internet.

Examples of Online Bookings

❖​ Travel – Flight, train, bus tickets (IRCTC, MakeMyTrip)

❖​ Hotels – OYO, [Link], Airbnb

❖​ Movies – BookMyShow, Paytm

❖​ Events – Concerts, shows, sports matches

❖​ Appointments – Doctor, salon, vaccination slot

The internet enables booking services from home.

Uses of Online Booking & Reservations

❖​ Booking travel tickets and rooms

 ❖​ Reserving movie seats and event tickets

❖​ Scheduling appointments

❖​ Pre-booking services (meals, cabs, tours)

Avoiding long lines and last-minute issue

9) Windows Operating System: Introduction and Characteristics

❖​ Windows Operating System, developed by Microsoft, is one of the

most widely-used operating systems for personal computers. It
provides a graphical user interface (GUI) that makes it easy for users to
interact with the computer using windows, icons, menus, and buttons.
Windows manages computer hardware, runs applications, controls
files, and provides a user-friendly environment for performing
everyday tasks.

Characteristics
1.​ Graphical User Interface (GUI):A Graphical User Interface (GUI) is a
type of user interface that allows users to interact with a computer using
visual elements like icons, buttons, windows, menus, and images instead
of typing commands. It makes computers easier to use because users can
simply click, drag, and drop to perform tasks. GUI is used in Windows,
Android, iOS, and most modern software applications. Uses icons, menus,
buttons, and drag-and-drop features.

2.​ Multitasking: Multitasking is the ability of an operating system to run

multiple programs or tasks at the same time. It allows users to switch
between different applications quickly without closing them. For example,
you can listen to music, browse the internet, and download a file all at
once on your computer or smartphone.
3.​ Plug and Play: Plug and Play (PnP) is a feature of modern operating
systems that allows the computer to automatically detect and configure
hardware devices as soon as they are connected. Users do not need to
manually install drivers or adjust settings. The system identifies the
device, installs required drivers, and makes it ready to use instantly.

4. File Management System: File Management System is a part of the

operating system that helps users create, store, organize, rename, move, copy,
and delete files and folders on a computer. It provides tools like File Explorer
(Windows) or Finder (Mac) to manage data easily. It also keeps track of
where files are stored, their type, size, date created, and permissions.

5. Security and Protection: Security and Protection in an operating system

refers to the methods used to protect data, files, hardware, and software from
unauthorized access, misuse, and damage. It ensures that only trusted users
and programs can access system resources. The goal is to keep information
safe, private, and secure from threats like viruses, hackers, or accidental
misuse.
6. Networking Capabilities:Networking Capabilities of an operating system
refer to its ability to connect, communicate, and share resources with other
computers and devices over a network. These capabilities allow users to share
files, printers, internet connections, and applications easily. Modern OS like
Windows, Linux, and macOS provide strong networking features for both
home and business use.
7. Wide Software Compatibility: Wide Software Compatibility means that an
operating system can support and run a large variety of software applications
without any issues. Systems like Windows are known for this because they
can run software for education, business, gaming, graphics, programming,
and more. This makes the OS flexible and useful for different types of users.

8. Control Panel & Settings: Control Panel and Settings are tools in an
operating system (especially Windows) that allow users to view, manage, and
customize system settings. They help control how the computer behaves, how
hardware works, and how software is configured. These tools make it easy to
adjust system preferences without using commands.
9. Regular Updates: Regular Updates are periodic improvements released by
the operating system to keep the computer secure, stable, and up-to-date.
These updates fix system bugs, improve performance, add new features, and
protect the device from new viruses or security threats. Windows, Android,
iOS, and other operating systems provide automatic updates to ensure smooth
functioning.

10) Word Processing Concepts

Word Processing refers to the use of computer software to create, edit,
format, store, and print text documents. Word processors make writing easier
and more efficient than manual typing. Popular word processing software
includes MS Word, Google Docs, WPS Office, and LibreOffice Writer.
1.​ Creating Documents :
❖​ Word processors allow users to:

❖​ Use readymade templates (letters, resumes, certificates, reports)

❖​ Open existing documents for editing

❖​ Creating documents is the first step in preparing digital content.

2.​ Editing Features

Editing means making changes to the text. Word processors allow:

❖​ Insert text anywhere

❖​ Delete text quickly

❖​ Copy and paste content

❖​ Cut and move paragraphs

❖​ Undo/redo actions

❖​ These features make editing extremely flexible compared to typewriters.

[Link] Features
Formatting makes a document visually clear and attractive. It includes:
Character Formatting

❖​ Font type, size, color

❖​ Bold, italic, underline

❖​ Highlighting text

❖​ Changing case

Paragraph Formatting

❖​ Alignment (left, right, center, justify)

❖​ Line spacing

❖​ Paragraph spacing

❖​ Indentation

❖​ Bullets and numbering

Page Formatting

❖​ Page size (A4, Letter)

❖​ Margins

❖​ Page orientation (portrait/landscape)

❖​ Headers and footers

Page numbering

❖​ Formatting improves readability and enhances presentation.

3.​ Spell Check and Grammar Check

Word processors automatically check:
Spelling errors (red underline)
Grammar mistakes (blue underline)
They provide suggestions to improve the quality and correctness of the
document. This ensures error-free writing.
4.​ Search and Replace
Users can:
Search for specific words or phrases
Replace them with new words throughout the document
This tool saves time, especially in large documents.

5.​ Tables and Columns

Word processors allow inserting:
Tables to arrange data in rows and columns
Columns for newspaper-style layout
Table formatting tools (shading, borders, merging cells)
Tables make data organized and easy to understand
 6.​ Inserting Objects
Users can insert:
Images
Shapes
Charts
SmartArt
Hyperlinks
Symbols and equations
This enriches the document and makes it more informative.

7.​ Page Layout and DesiThis feature allows:

Adding borders
Applying themes
Creating sections
Cover pages
Watermarks (Confidential,
Page layout controls the overall appearance of the document.

8.​ Styles and Templates

Styles
A set of predefined formatting options used for:
Titles
Headings
Sub-headings
This ensures uniform formatting throughout the document.
Templates
Ready-made document formats that save time.
Examples: Resume, Report, Letter templates.
9.​ Mail Merge (Very Important)
Mail Merge combines:
A main document (letter or certificate)
A data source (names, addresses, phone numbers)
It helps create multiple personalized copies (like sending letters to 100 people
at once).

10.​Collaboration Tools
In cloud-based word processors (Google Docs):
Multiple users can edit the same document
Comments and suggestions can be added
Changes are updated in real-time
This improves teamwork and document management.

11.​Saving and Storing Documents

❖​ Documents can be saved in multiple formats:

.docx (Word)

.pdf

.txt

.rtf

Cloud storage (Google Drive, OneDrive)

Users can easily update and retrieve documents anytime.

12.​Printing
 ❖​ Word processors provide:

Print preview
Page selection (print specific pages)

Orientation and layout options

Double-sided printing

This helps produce professional hard copies

Benefits of Word Processing

❖​ Faster than manual typing

❖​ Easy corrections and editing

❖​ Professional formatting

❖​ Reduces errors

❖​ Supports images, tables, charts

❖​ Saves time and effort

 ❖​ Digital storage and sharing

11)Spreadsheet
Spreadsheet is a software application used to store, organize, calculate, and
analyze data in a tabular form. It consists of rows and columns that form cells
where users can enter numbers, text, and formulas. Spreadsheets are widely
used in business, finance, education, data analysis, budgeting, and accounting.

Components of Spreadsheet
1. Row & Column Structure: row and column structure is a way of arranging
data in a table or spreadsheet so that information is organized, easy to read,
and easy to compare. It is used in MS Word tables, MS Excel, Google Sheets,
databases, and many applications that display data in tabular form.
2. Cell Addressing: Cell Addressing refers to the method of identifying each
cell in a spreadsheet (like MS Excel or Google Sheets) using a combination
of column letter and row number.
For example: A1, B5, C10

Every cell has a unique address which helps the spreadsheet locate data and
apply formulas accurately.
[Link] Types: Data Types refer to the kinds of values that can be stored and
processed by a computer or a software application (like spreadsheets, databases,
or programming languages).
They define what type of data is being used and what operations can be
performed on it.
 4.​ Formulas: formula is an expression used in spreadsheets (like MS Excel,
Google Sheets, LibreOffice Calc) to perform calculations, process data,
and automate tasks.
A formula always begins with an equal sign (=) so the computer knows it has
to calculate something.

5.​ Functions: Function is a predefined, built-in formula in a spreadsheet

application such as MS Excel, Google Sheets, or LibreOffice Calc,
designed to perform specific calculations quickly and accurately.

Functions make work easier because they are ready-made formulas that do
not require you to write complex mathematical expressions manually.
6.​ AutoFill: Auto Fill is a feature in spreadsheet software like MS Excel,
Google Sheets, and LibreOffice Calc that allows users to automatically
copy data, continue patterns, and fill sequences into adjacent cells without
typing them manually.
It saves time and reduces errors, especially when working with repetitive or
patterned damanu8.

[Link] Analysis: Data Analysis is the process of collecting, cleaning,

organizing, and examining data to find useful information, draw conclusions,
and support decision-making.
It helps convert raw data into meaningful insights.

[Link] and Graphs: Charts and Graphs are visual representations of data.
They convert numerical or textual information into graphical formats so that
data becomes easier to understand, compare, and analyse.

9..Pivot Tables: Pivot Table is a powerful data analysis tool in spreadsheet

software (MS Excel, Google Sheets, LibreOffice Calc) used to summarize,
analyse, explore, and present large amounts of data in a simple and organized
way.

10. What-if Analysis: What-If Analysis in spreadsheets (like MS Excel or

Google Sheets) is a powerful tool used to predict outcomes and make
 decisions by changing input values and seeing how those changes affect the
final results.
It helps in planning, forecasting, budgeting, and comparing different
scenarios.

11. Formatting Options: Formatting options in a word processor or

spreadsheet help to change the appearance of text, numbers, and documents.
They make content easier to read, attractive, and well-organized.

[Link] Validation: Data Validation is a feature in spreadsheets (like Excel or

Google Sheets) that controls what type of data can be entered into a cell.
It helps prevent mistakes by allowing only correct, meaningful, and specific
data .

13.​Import/Export: Import refers to the process of bringing external data or

files into a software application, system, or spreadsheet so that the data
can be viewed, edited, or processed further. It allows users to load
information from different file formats such as CSV, TXT, XML, images,
databases, or other software programs.
Export refers to the process of sending or saving data from a software
application into another file format or system so it can be shared, transferred, or
used elsewhere. When exporting, data is typically converted into formats like
PDF, CSV, TXT, JPG, DOCX, or database files so that other programs can read
and use it.

14. Use Cases: Spreadsheets are powerful tools used for organizing,
calculating, analyzing, and presenting data. They are widely used in
education, business, finance, research, and daily life.

Benefits of spreadsheet
❖​ Easy Data Organization

❖​ Automatic Calculations

❖​ Time-Saving

❖​ Better Data Analysis

❖​ Easy Visualization

❖​ Large Data Handling

❖​ Improves Accuracy

❖​ Customization and Flexibility

❖​ Easy Sharing and Collaboration

❖​ Helps in Decision-Making

❖​ Cost-Effective Tool
 ❖​ Supports Data Security

12)​ Interface of the Presentation Software

The interface of a presentation software refers to all the on-screen

elements that help the user create, edit, and display slides. It is designed to
make slide creation easy and visually appealing. The main components
include:

[Link] Bar (Top of the Window)

❖​ The Title Bar is located at the very top of the software window.

❖​ It displays the name of the presentation file and the application

name (e.g., PowerPoint).

❖​ Contains the window control buttons: Minimize, Maximize, and

Close.
 ❖​ Often includes a Quick Access Toolbar, which provides shortcuts to
commonly used commands like Save, Undo, and Redo.

2.​ Ribbon / Menu Bar

❖​ The Ribbon is a collection of multiple tabs such as Home, Insert, Design,

Transitions, Animations, Slide Show, Review, and View.

❖​ Each tab contains groups of tools, for example:

❖​ Home Tab: Font, Paragraph, ClipboardSlides, Drawing

❖​ Insert Tab: Tables, Pictures, Shapes, Charts, Text Box.

❖​ Design Tab: Themes, Variants, Background Styles

❖​ Transitions & Animations Tabs: Movement effects for slides and objects

❖​ It provides quick access to all tools required to design and format slides.

3.​ Slide Pane / Slides Panel (Left Side)

❖​ Displays all slides in thumbnail (miniature) view.

❖​ Helps in navigating between slides quickly.

❖​ Allows users to add, delete, rearrange, duplicate, or organize slides easily

❖​ Useful for managing the overall structure of the presentation.

4.​ Slide Workspace / Slide Editing Area (Center)

❖​ The main working area where the selected slide is displayed in full
size.

❖​ Users can type text, insert images, charts, tables, shapes, videos, and
other objects.

❖​ Allows formatting of text, adjusting layout, and applying design

elements.

❖​ This is the area where the actual slide content is created and edited.

5.​ Notes Pane

❖​ Positioned below the slide editing area.

❖​ Allows users to type speaker notes or additional information that

supports the presentation.

❖​ Notes do not appear during the slideshow but help the presenter
remember key points.
6.​ Status Bar (Bottom of the Window)

❖​ Shows the slide number and the total number of slides.

❖​ Displays the applied theme or layout.

❖​ Contains a zoom slider to increase or decrease the slide view.

❖​ Includes view mode buttons like:

❖​ Normal View

❖​ Slide Sorter View

❖​ Reading View

❖​ Provides quick information about the current working mode.

7.​ Slide Sorter View

❖​ Displays all slides in a grid of small thumbnails.

❖​ Useful for organizing the order of slides.

❖​ Perfect for checking the flow and sequence of the entire presentation.

❖​ Allows quick rearrangement with drag-and-drop.

8.​ Outline View

❖​ Shows only the text content of slides in an outline/tree structure.

❖​ Helps in editing text quickly without focusing on formatting.

❖​ Useful for planning the presentation and maintaining logical flow.

9.​ Task Pane (Right Side of the Screen)

❖​ Appears depending on the task you are performing.

❖​ Examples:

Choosing themes and templates.

Formatting shapes, pictures, or text.

Applying animations or transitions.

Provides additional options and advanced formatting tools.

10.​Quick Access Toolbar

❖​ A small customizable toolbar usually placed above the Ribbon.

 ❖​ Contains frequently used options like:

Save

Undo

Redo

Print

Start Slide Show

❖​ Helps users work faster without switching tabs repeatedly.

11.​View Buttons

❖​ Located at the bottom-right corner or on the View Tab.

❖​ Includes:

Normal View: For editing slides.

Slide Sorter: For rearranging slides.

Reading View: For previewing how the slide looks.

Slide Show: For running the presentation.

 ❖​ Useful for switching between different working modes quickly.

12.​Zoom Controls

❖​ Found on the Status Bar.

❖​ Allows the user to zoom in to view details or zoom out to see the entire
slide.

❖​ Helps in editing content more accurately.

Bibliography