0% found this document useful (0 votes)

113 views89 pages

Basic Computer Skills

This document is a vocational course outline on Basic Computer Skills prepared for Dr. Bhimrao Ambedkar University, Agra. It covers fundamental concepts such as the definition of a computer, its components, types, and working mechanisms, along with historical figures and terms related to computing. The document also details various computer types based on size, mechanism, and purpose, as well as essential parts of a computer system.

Uploaded by

neeteshsingh1974

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

113 views89 pages

Basic Computer Skills

Uploaded by

neeteshsingh1974

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

You are on page 1/ 89

Notes: Vocational Course

Semester 1 & 3: Basic Computer Skills

Specially prepared for: Dr. Bhimrao Ambedkar University, Agra

UNIT 1 - INTRODUCTION TO BASIC COMPUTER

SKILLS

Introduction & Definition of Computer

A computer is an electronic device that processes data to perform various tasks, ranging from
simple calculations to complex problem-solving. It is a versatile tool that has become an
integral part of modern life, influencing almost every aspect of society, business, education,
and entertainment.

A computer is a programmable electronic device that accepts raw data as input and
processes it with a set of instructions (a program) to produce the result as output. It renders
output after performing mathematical and logical operations and can save the output for
future use. It can process numerical as well as non-numerical calculations. The term
"computer" is derived from the Latin word "computare" which means to calculate.

• Who developed the computer?

Many people throughout history are credited with developing early prototypes that
led to the modern computer. During World War II, physicist John Mauchly, engineer J.
Presper Eckert, Jr., and their colleagues at the University of Pennsylvania designed the
first programmable general-purpose electronic digital computer, the Electronic
Numerical Integrator and Computer (ENIAC).

• Strongest Computer in the world?

• Fugaku (Japan)
• Summit (United States)
• Sierra (United States)
• Sunway TaihuLight (China)
• Super MUC-NG (Germany)

• Who is known as the father of the computer?

Charles Babbage is often referred to as the "father of the computer" due to his
pioneering work in the field of computing during the 19th century. Babbage was a
mathematician, engineer, and inventor who conceptualized and designed the first
automatic mechanical computer known as the "Analytical Engine."

Terms related to computer

1. Computer: An electronic device that processes data to perform various tasks according
to a set of instructions.

2. Hardware: The physical components of a computer, such as the central processing unit
(CPU), memory, storage devices, and input/output devices.

3. Software: Programs and applications that provide instructions for the computer to
execute tasks.

4. Operating System (OS): Software that manages computer hardware and provides
services for computer programs. Examples include Windows, macOS, and Linux.

5. Central Processing Unit (CPU): The primary component responsible for executing
instructions and performing calculations in a computer.

6. Memory (RAM): Random Access Memory, a type of volatile memory that provides
temporary storage for actively used data and program instructions.

7. Storage: The place where data is stored for the long term, such as hard drives or solid-
state drives.

8. Input Devices: Devices like keyboards, mice, and touchscreens that allow users to input
data into the computer.

9. Output Devices: Devices like monitors, printers, and speakers that display or provide
results of the computer's processing.

10.Motherboard: The main circuit board that connects and facilitates communication
between various components of a computer.

11. Peripheral: Any device connected to the computer, such as printers, scanners, or
external hard drives.

12. Binary: A number system based on two digits, 0 and 1, used by computers to
represent information.

13. Byte: A unit of digital information consisting of 8 bits. It is often used to measure file
sizes and memory capacity.

14. Algorithm: A step-by-step procedure or formula for solving a problem or performing a

task.

16. LAN (Local Area Network): A network that connects computers and devices within a
limited geographical area, such as a home, office, or campus.

17. WAN (Wide Area Network): A network that covers a broader area, often connecting
multiple LANs across different locations.
18. Internet: A global network of interconnected computers that communicate using
standardized protocols.

19. Browser: A software application used to access and navigate the World Wide Web,
such as Chrome, Firefox, or Safari.

20. Firewall: A security system that monitors and controls incoming and outgoing network
traffic to protect against unauthorized access.

Different types of computers

Computers come in various types, each designed to serve specific purposes and cater to
different computing needs. Here are some common types of computers:

Based on size:

Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 3 of 11
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
Supercomputers: The most powerful and high-performance computers
designed to handle complex scientific calculations, simulations, and
data analysis. Supercomputers are used in research institutions,
government labs, and industries with demanding computational
requirements.
Mainframes: Powerful computers capable of processing large volumes
of data and managing multiple tasks simultaneously. Mainframes are
often used in large organizations for critical business applications.
Mini Computers: It lies in the middle range of computing systems,
between the mainframe and microcomputer as it is smaller than the
mainframe and larger than a microcomputer. One of a minicomputer's
specific characteristics is its small size. Minicomputers are lots smaller
and more portable than larger mainframe pc systems.
Micro Computers:
Desktop Computers: These are traditional computers with
separate components, including a tower or case housing the
CPU, memory, and storage, along with peripherals like
monitors and keyboards.
Laptops: Portable computers with integrated components,
including a screen, keyboard, and trackpad or pointing device.
Palmtops: An earlier computer small enough to hold in one
hand and operate with the other. Also called a "hand top,"
palmtops had small keyboards or specialized keypads tailored
to specific industries. General-purpose palmtops were never
widely used, but they were resurrected in the form of
smartphones and tablets.
Based in Mechanism:
Analog Computers: An Analog computer is a computer which uses
continuously changeable entities like mechanical, electrical, hydraulic,
etc. These were first used at the time of the 1950s–1960s. Analog
computers work with physical quantities, and they are designed to
process continuous data in the form of analog signals.
Analog computers use physical quantities, such as voltage,
current, or other continuously variable signals, to represent and
manipulate data.

Example: Speedometer, Seismometer, Voltmeter, Analog Clock

Digital Computers: Digital computers are capable of solving problems
by processing information in discrete form. It operates on data using
only the two digits 0 and 1.
Hybrid Computers: Hybrid computers are computing systems that
combine the features and capabilities of both analog and digital
computers. They leverage the strengths of analog computing for
processing continuous data and digital computing for handling discrete
data.

Other types of computers

• Workstations: Specialized computers designed for high-performance computing tasks,

such as scientific simulations, graphic design, and video editing.

• Servers: Computers designed to manage and distribute resources, services, and data
to other computers on a network. They are crucial for hosting websites, managing
databases, and more.

• Embedded Computers: Computers integrated into other devices and systems. They
are dedicated to specific functions and are found in everyday devices such as washing
machines, cars, and digital cameras.

• Microcontrollers: Small, specialized computers embedded in electronic devices to

control specific functions. They are commonly found in appliances, toys, and
automation systems.

• Gaming Consoles: Specialized computers designed specifically for playing video

games. Examples include consoles like PlayStation, Xbox, and Nintendo Switch.

• Thin Clients: Computers that rely on a server to perform most computing tasks. Thin
clients are often used in business environments where centralization of computing
resources is preferred.

• Wearable Computers: Small, portable computing devices that can be worn or carried,
such as smartwatches and fitness trackers.

• Quantum Computers: Experimental computers that leverage principles of quantum

mechanics to perform certain types of calculations exponentially faster than classical
computers. Quantum computers are still in the early stages of development.

Different parts of a Computer System

A computer system is a complex combination of hardware and software components that
work together to perform various functions. Here are the key parts of a typical computer
system:

1. Central Processing Unit (CPU): Often referred to

as the brain of the computer, the CPU carries out
instructions of a computer program. It performs
arithmetic and logical operations, manages data,
and controls the execution of programs.

2. Memory (RAM): RAM (Random Access Memory): This

is volatile memory used by the CPU to store data and
instructions temporarily. It allows for quick access to
information but loses its contents when the power is turned
off.

3. Storage Devices (Hard Drives, SSDs): This is non-volatile

memory used for long-term data storage. Hard drives and solid-
state drives (SSDs) are common types of storage devices.

4. Motherboard: The motherboard is the main circuit board

that connects and holds together all the essential components of
the computer system. It provides the electrical connections
needed for data transfer between components.

Power Supply Unit (PSU): The PSU converts electrical power from
an outlet into a form that the computer can use. It supplies power
to the motherboard, CPU, and other components.
A switched-mode power supply (SMPS), also called switching-
mode power supply, switch-mode power supply, switched power
supply, or simply switcher, is an electronic power supply that
incorporates a switching regulator to convert electrical power
efficiently.

6. Input Devices: Input devices allow users to

interact with the computer. Common examples
include the keyboard and mouse. Other input
devices include touchscreens, scanners, and
cameras.

7. Output Devices: Output devices display or

provide information to the user. Examples include
monitors, printers, and speakers.

8. Graphics Processing Unit (GPU): The GPU, or

graphics card, is responsible for rendering images and
videos. It is crucial for graphics-intensive applications
such as gaming, video editing, and 3D modeling.

9. Expansion Cards: These are additional cards that can be added to the motherboard to
enhance the computer's capabilities. Examples include graphics cards, sound cards, and
network interface cards.

10. Cooling System: Computers generate heat during operation, especially the CPU and
GPU. Cooling systems, including fans and heat sinks, help dissipate this heat to prevent
overheating.

11. Networking Components:

Network interface cards (NICs) enable the
computer to connect to a network. Routers
and modems facilitate internet
connectivity.

12. Peripheral Devices: These include devices such as printers, scanners, external hard
drives, and other accessories that connect to the computer to provide additional functionality.

13. Operating System (OS): The operating system is system software that manages
hardware resources and provides a user interface.

Common examples include Windows, macOS, Android and Linux.

14. Software Applications: These are programs that users run to perform specific tasks.
Examples include word processors, web browsers, games, and photo editing software.

These components work together to enable the computer to process information, execute
programs, and perform a wide range of tasks based on user input and software instructions.

Working of a Computer
The working of a computer involves a series of steps and processes that allow it to execute
tasks and perform operations.

• 1. Input:
• Users provide input to the computer through various input devices, such as
keyboards, mice, touchscreens, or other peripherals.
• Input can include commands, data, or any form of interaction with the
computer.
• 2. Processing:
• The central processing unit (CPU) is responsible for processing the input. It
fetches instructions and data from memory, performs calculations and logical
operations, and manages the flow of information within the computer.
• The CPU executes instructions based on the program or software being run.
• 3. Memory:
• The computer's memory, including RAM (Random Access Memory), stores
data and instructions that are actively used by the CPU during processing.
• Data in RAM is volatile, meaning it is lost when the computer is powered off.
Non-volatile storage devices (e.g., hard drives or SSDs) retain data for long-
term storage.

• 4. Storage:
• Long-term storage devices, such as hard drives or SSDs, store data persistently
even when the computer is turned off.
• Software and data are loaded into memory from storage when needed for
processing.
• 5. Output:
• Output devices, such as monitors, printers, or speakers, present the results of
the computer's processing to the user.

Unit 2 – Introduction to Windows 10 and Operating System

What is an Operating System?

An operating system (OS) is a software that manages computer hardware and provides common
services for computer programs. It acts as an intermediary between the hardware components of a
computer system and the applications software. Here's an overview of the key components and
functions of an operating system:

Main components of Operating system are as follows:

Hardware Abstraction:

• The operating system abstracts the underlying hardware components of the computer,
including the CPU, memory, storage devices, input/output (I/O) devices, and network
interfaces.
• It provides a standardized interface for applications to interact with hardware resources,
hiding the complexities of hardware management from software developers.

Process Management:

• The OS is responsible for managing processes, which are instances of executing programs. It
allocates CPU time, memory, and other resources to processes, schedules their execution,
and facilitates communication and synchronization between them.
• Process management includes features such as multitasking, multiprocessing, and
multitasking, allowing multiple processes to run concurrently on a computer system.

Memory Management:

• The OS manages system memory (RAM) to ensure efficient allocation and utilization of
memory resources by processes.
• It allocates memory to processes as needed, tracks memory usage, and provides
mechanisms for memory protection, virtual memory, and memory swapping to optimize
system performance and prevent memory conflicts.

File System Management:

• The operating system manages files and directories stored on storage devices such as hard
drives, solid-state drives (SSDs), and optical discs.
• It provides a hierarchical file system structure for organizing and accessing files, as well as file
management operations such as creation, deletion, renaming, and modification of files.
• File system management also includes features such as file permissions, encryption,
compression, and support for different file formats.

Device Management:

• The OS controls input/output (I/O) devices such as keyboards, mice, monitors, printers,
network adapters, and storage devices.

User Interface:

• The operating system provides a user interface (UI) that allows users to interact with the
computer system and execute applications.
• User interfaces may be graphical (GUI) or command-line (CLI), providing methods for users to
perform tasks, navigate the system, and access system resources and applications.

Security and Access Control:

• The OS implements security mechanisms to protect the computer system from unauthorized
access, malware, and other security threats.
• It enforces access control policies, authentication, and encryption to safeguard data and
ensure the integrity, confidentiality, and availability of system resources.

Networking:

• The operating system supports networking capabilities, allowing computers to communicate

with each other over local area networks (LANs) and the internet.
• It provides networking protocols, services, and utilities for network configuration, connection
management, data transfer, and network security.

Introduction to Windows 10

Windows 10 is a widely used operating system developed by Microsoft, released on July 29, 2015, as
the successor to Windows 8. It represents a significant evolution in Microsoft's Windows operating
system family, combining the familiar features of Windows 7 with the modern design elements
introduced in Windows 8.

Here's an overview of Windows 10:

User Interface:

• Windows 10 features a user-friendly interface with a blend of traditional desktop elements

and modern design principles.
• The Start menu returns in Windows 10, combining the traditional menu with Live Tiles
introduced in Windows 8, providing quick access to frequently used apps and information.
• Users can switch between tablet mode and desktop mode, depending on the device and
user preferences.

Cortana:

• Cortana is Microsoft's virtual assistant integrated into Windows 10, offering voice-activated
assistance, reminders, calendar management, and web search capabilities.
• Cortana can perform tasks such as setting reminders, sending emails, searching the web, and
providing weather forecasts, all through voice commands or text input.

Microsoft Edge:

• Microsoft Edge is the default web browser in Windows 10, replacing Internet Explorer.
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 2 of 8
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• It features a modern and streamlined interface, faster performance, improved security
features, and integration with Cortana for personalized web search results and
recommendations.

Windows Store:

• The Windows Store is an app marketplace where users can discover, download, and install a
wide range of apps, games, and entertainment content.
• Windows 10 introduces Universal Windows Platform (UWP) apps, which are designed to run
across multiple devices, including PCs, tablets, smartphones, and Xbox consoles.

Continuum:

• Continuum is a feature in Windows 10 that enables seamless transition between different

device modes, such as tablet mode and desktop mode.
• It automatically adjusts the user interface and app layout based on the device's form factor
and input method, providing a consistent user experience across devices.

Security Features:

• Windows 10 includes various security enhancements to protect users from malware, viruses,
and other security threats.
• Features such as Windows Defender Antivirus, Windows Firewall, Secure Boot, Device Guard,
and Windows Hello (biometric authentication) help safeguard user data and privacy.

Updates and Support:

• Windows 10 follows a "Windows as a Service" (WaaS) model, with regular updates and
feature releases delivered through Windows Update.
• Microsoft provides long-term support (LTSC) and semi-annual channel (SAC) releases, with
extended support options for enterprise customers.

Integration with Other Microsoft Services:

• Windows 10 integrates seamlessly with other Microsoft services and products, including
Office 365, OneDrive cloud storage, Xbox Live gaming, and Skype communication tools.

Features of Windows 10

Windows 10 is a versatile and feature-rich operating system that offers a wide range of capabilities to
users across various devices. Here are some of the key features of Windows 10:

Start Menu:

• Windows 10 reintroduces the Start menu, combining the familiarity of Windows 7's Start
menu with the Live Tiles feature from Windows 8.
• Users can customize the Start menu with their favorite apps, programs, and Live Tiles,
providing quick access to frequently used content and information.

• Cortana, Microsoft's digital assistant, is integrated into Windows 10, providing voice-
activated assistance, reminders, calendar management, and web search capabilities.
• Cortana can perform tasks such as setting reminders, sending emails, searching the web, and
providing weather forecasts, all through voice commands or text input.

Microsoft Edge Browser:

• Windows 10 introduces Microsoft Edge as the default web browser, offering a modern and
streamlined browsing experience.
• Edge features faster performance, improved security features, and integration with Cortana
for personalized web search results and recommendations.

Windows Hello:

• Windows Hello is a biometric authentication feature in Windows 10 that allows users to log
in to their devices using facial recognition, fingerprint scanning, or iris scanning.
• It provides a more secure and convenient alternative to traditional password-based
authentication methods.

Virtual Desktops:

• Windows 10 includes a Virtual Desktops feature that allows users to create multiple desktops
for organizing and managing open windows and applications.
• Users can switch between different virtual desktops to group related tasks, projects, or
activities, improving productivity and organization.

Task View:

• Task View is a feature in Windows 10 that allows users to view all open windows and
applications on their desktop in a single view.
• It provides a quick and convenient way to switch between different tasks, windows, and
virtual desktops, improving multitasking efficiency.

Action Center:

• The Action Center in Windows 10 consolidates notifications and system alerts from apps and
services into a single location.
• Users can access the Action Center from the taskbar to view and respond to notifications,
adjust settings, and perform quick actions such as toggling Wi-Fi or Bluetooth.

Continuum:

• Continuum is a feature in Windows 10 that enables seamless transition between different

Windows Ink:

• Windows 10 includes Windows Ink, a suite of digital pen and touch input features designed
to enhance creativity and productivity.
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 4 of 8
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• Windows Ink allows users to take notes, sketch, annotate documents, and create digital art
using a compatible stylus or touch input device.

Security Enhancements:

• Windows 10 includes various security enhancements to protect users from malware, viruses,
and other security threats.
• Features such as Windows Defender Antivirus, Windows Firewall, Secure Boot, Device Guard,
and BitLocker encryption help safeguard user data and privacy.

Applications of Windows 10

Windows 10 supports a wide range of applications for various purposes, catering to the needs of
individuals, businesses, and organizations. Some important applications of Windows 10 are as
Follows:

Microsoft Office Suite:

• Microsoft Office Suite, including applications such as Word, Excel, PowerPoint, and Outlook,
is widely used for word processing, spreadsheet management, presentation creation, and
email communication.
• These productivity applications are essential for individuals, students, professionals, and
businesses for creating and managing documents, spreadsheets, presentations, and emails.

Web Browsers:

• Web browsers such as Microsoft Edge, Google Chrome, Mozilla Firefox, and Opera are
essential applications for accessing and browsing the internet.
• Web browsers allow users to view websites, search for information, access online services,
and interact with web-based applications.

Email Clients:

• Email clients such as Microsoft Outlook, Mozilla Thunderbird, and Mail for Windows 10 are
used for managing email accounts, sending and receiving emails, and organizing email
messages.
• Email clients offer features such as email filtering, sorting, categorization, and integration
with calendars and contacts.

Media Players:

• Media players such as Windows Media Player, VLC Media Player, and iTunes are used for
playing audio and video files on Windows 10.
• Media players support various audio and video formats, offer playback controls, equalizer
settings, and playlist management features.

Image Editing Software:

Video Editing Software:

• Video editing software such as Adobe Premiere Pro, Windows Movie Maker, and DaVinci
Resolve are used for editing and producing professional-quality videos.
• Video editing software offers features such as timeline editing, transitions, special effects,
audio editing, and video rendering.

Antivirus and Security Software:

• Antivirus and security software such as Windows Defender, McAfee, and Norton Antivirus
are essential for protecting Windows 10 systems from malware, viruses, spyware, and other
security threats.
• Antivirus software offers real-time protection, malware scanning, firewall protection, and
web browsing security features.

Cloud Storage and Backup Services:

• Cloud storage and backup services such as OneDrive, Google Drive, and Dropbox are used for
storing, syncing, and backing up files and data in the cloud.
• Cloud storage services offer file synchronization, file sharing, collaboration, and remote
access features across devices.

Communication and Collaboration Tools:

• Communication and collaboration tools such as Microsoft Teams, Skype, Slack, and Zoom are
used for messaging, video conferencing, and collaboration in teams and organizations.
• These tools offer features such as instant messaging, voice and video calls, screen sharing,
file sharing, and project management.

Development Tools and IDEs:

• Development tools and integrated development environments (IDEs) such as Visual Studio,
Eclipse, and JetBrains IntelliJ IDEA are used by developers for coding, debugging, and testing
software applications.
• Development tools support various programming languages and frameworks, offering
features such as code editing, syntax highlighting, debugging, and version control integration.

Use of File Explorer in windows 10

In Windows 10, Windows Explorer has been replaced by File Explorer, which serves as the primary
file management tool for navigating and managing files and folders on your computer. File Explorer
provides a graphical user interface (GUI) for interacting with the file system, allowing users to

Navigating the File System:

• File Explorer allows users to navigate the file system hierarchy, including drives, folders, and
files, using a hierarchical tree structure in the navigation pane.
• Users can quickly switch between different folders and drives by clicking on their respective
icons or using keyboard shortcuts.

Managing Files and Folders:

• File Explorer provides various file management operations, including creating, copying,
moving, renaming, and deleting files and folders.
• Users can perform bulk operations such as selecting multiple files or folders and applying
actions like copying, moving, or deleting them simultaneously.

Viewing File Properties:

• Users can view detailed information about files and folders, including file size, type, date
modified, and attributes, in the Details pane of File Explorer.
• File properties also provide metadata such as author, title, tags, and ratings, depending on
the file type and associated metadata.

Searching for Files and Folders:

• File Explorer includes a powerful search feature that allows users to search for files and
folders based on various criteria, including file name, content, file type, and date modified.
• Users can perform quick searches using the search box in the top-right corner of File Explorer
or use advanced search filters to refine search results.

Organizing Files and Folders:

• File Explorer allows users to organize files and folders by arranging them in different views
such as Details, List, Tiles, and Content.
• Users can sort files and folders alphabetically, by size, by date modified, or by other criteria
to find and organize files more efficiently.

Accessing Network Resources:

• File Explorer provides access to network resources such as shared folders, network drives,
and network locations, allowing users to browse and manage files stored on remote servers
or network-attached storage (NAS) devices.

Customizing File Explorer:

• Users can customize File Explorer settings and preferences to suit their workflow and
preferences, including options for changing the default view, customizing folder options, and
adjusting layout settings.
• File Explorer also supports customization through the use of Quick Access shortcuts, pinned
folders, and customizable toolbars and ribbons.
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 7 of 8
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
Integration with Other Applications:

• File Explorer integrates with other applications and services on Windows 10, allowing users
to open files with associated applications, preview files using the built-in preview pane, and
share files via email or cloud storage services.

Unit 3 – Introduction to Internet

What is a Network?
A network is a collection of computers, servers, mainframes, network devices, or other
devices interconnected to allow for communication and sharing of resources. Essentially, it's
a system of interconnected nodes that can exchange data and information with each other.
Networks can be classified based on their size, scope, and purpose. Here are some common
types of networks:
1. Local Area Network (LAN): A LAN typically covers a small geographic area, such as a
single building or campus. It allows devices within this area to communicate with
each other and share resources like files, printers, and internet connections.
2. Wide Area Network (WAN): A WAN spans a large geographic area, often connecting
multiple LANs or other networks across cities, countries, or even continents. The
internet itself is the largest WAN, connecting networks worldwide.
3. Wireless Networks: These networks use wireless connections, such as Wi-Fi or
cellular networks, to enable communication between devices without the need for
physical cables. Wireless networks can be LANs or WANs, depending on their size and
scope.
4. Home Networks: These are LANs set up within a household, typically to share
internet access among multiple devices and allow for file sharing and media
streaming between devices like computers, smartphones, and smart TVs.

Important terms related to Internet:

Ethernet: Ethernet is a widely used technology for local area networking (LAN). It defines
wiring and signaling standards for the physical layer and data link layer of the OSI model,
enabling devices to communicate within a LAN.
MAC Address: MAC (Media Access Control) address is a unique identifier assigned to a
network interface controller (NIC) for communications at the data link layer of a network
segment. It is usually represented as a series of hexadecimal digits separated by colons or
hyphens.
Packet: A packet is a unit of data transmitted over a packet-switched network. It consists of a
header containing control information and payload data. Packets are routed between nodes
in the network based on the destination address contained in the packet header.
Latency: Latency is the time delay between the initiation of a network request and the
receipt of the corresponding response. It is typically measured in milliseconds (ms) and
includes factors such as transmission delay, propagation delay, and processing delay.
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 1 of 13
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
DNS (Domain Name System): DNS is a decentralized naming system for translating domain
names (e.g., www.example.com) into IP addresses and vice versa. It enables users to access
resources on the internet using human-readable domain names instead of numeric IP
addresses.
Gateway: A gateway is a networking device that serves as an entry and exit point between
two different networks. It translates data between different protocols, formats, or
communication technologies, allowing devices on one network to communicate with devices
on another network.
LAN (Local Area Network): A LAN is a network that connects devices within a limited
geographical area, such as a home, office, or school campus. LANs typically use high-speed
connections to facilitate communication and resource sharing among devices.
VPN (Virtual Private Network): A VPN is a secure network connection established over a
public network, such as the internet. It creates a private encrypted tunnel between the
user's device and a VPN server, ensuring confidentiality and privacy of data transmitted over
the network.
Router: A router is a networking device that forwards data packets between computer
networks. Routers use routing tables and algorithms to determine the optimal path for
transmitting packets from the source to the destination across interconnected networks.
Firewall: A firewall is a network security device that monitors and controls incoming and
outgoing network traffic based on predetermined security rules. It acts as a barrier between
a trusted internal network and untrusted external networks, such as the internet, to prevent
unauthorized access and protect against malicious threats.

Different ways of connection to Internet

DSL (Digital Subscriber Line):

• DSL uses existing telephone lines to provide high-speed internet access.

• It offers faster speeds than traditional dial-up connections.
• DSL connections are typically asymmetrical, meaning the download speed is faster
than the upload speed.
• Distance from the provider's central office can affect the quality and speed of the DSL
connection.
Cable Internet:

• Cable internet utilizes the same coaxial cables that are used to deliver cable
television services.
• It provides higher speeds compared to DSL and is often more widely available in
urban and suburban areas.

• Cable internet connections are typically asymmetrical, with faster download speeds
than upload speeds.
• Bandwidth may be shared with neighboring users, leading to slower speeds during
peak usage times.
Fiber Optic Internet:

• Fiber optic internet delivers data using light signals transmitted through optical fibers
made of glass or plastic.
• It offers extremely high-speed internet access, often with symmetrical upload and
download speeds.
• Fiber optic connections are less susceptible to interference and signal degradation
compared to DSL and cable connections.
• Fiber optic infrastructure is still being expanded, so availability may be limited in
some areas.
Satellite Internet:

• Satellite internet utilizes satellites in geostationary orbit to provide internet access to

users.
• It is available in remote or rural areas where traditional wired internet connections
are not feasible.
• Satellite internet can suffer from latency due to the long distance signals must travel
between Earth and the satellite.
• Data caps and slower speeds during peak usage times are common limitations of
satellite internet.
Fixed Wireless Internet:

• Fixed wireless internet uses radio signals to provide internet access to a fixed
location, typically via antennas installed on buildings or towers.
• It is often used in rural areas where laying cables or installing other infrastructure is
impractical.
• Speeds and reliability of fixed wireless internet can vary depending on factors such as
signal strength and interference.
Mobile Broadband:

• Mobile broadband provides internet access using cellular networks, typically through
smartphones, tablets, or dedicated mobile hotspot devices.
• It offers flexibility and mobility, allowing users to access the internet from almost
anywhere with cellular coverage.
• Speeds and coverage can vary depending on the strength of the cellular signal and
network congestion.
• Data caps and throttling may apply, particularly for users on limited data plans.

Evolution of Internet

ARPANET (1960s-1970s):

• The precursor to the modern internet, ARPANET was created by the United States
Department of Defense's Advanced Research Projects Agency (ARPA).
• ARPANET was established in the late 1960s and became operational in 1969,
connecting computers at research institutions and universities.
• It utilized packet switching technology to transmit data between interconnected
nodes, laying the foundation for the internet's decentralized architecture.
• ARPANET's primary purpose was to facilitate communication and resource sharing
among researchers and scientists.
TCP/IP Protocol Suite (1970s-1980s):

• The development of the Transmission Control Protocol (TCP) and Internet Protocol
(IP) by Vinton Cerf and Robert Kahn in the 1970s was a crucial milestone in internet
evolution.
• TCP/IP standardized communication protocols for data transmission over networks,
enabling diverse computer systems to interconnect and communicate seamlessly.
• TCP/IP became the foundational protocol suite for the internet, facilitating the
creation of a global network of networks.
Commercialization and World Wide Web (1990s):

• The 1990s saw the commercialization and widespread adoption of the internet,
driven by advancements such as the creation of the World Wide Web (WWW) by Tim
Berners-Lee.
• The WWW introduced a user-friendly interface for accessing and navigating internet
resources using hypertext documents (web pages) linked via hyperlinks.
• Web browsers like Mosaic and Netscape Navigator made the internet more
accessible to the general public, leading to a surge in internet usage and the
emergence of online businesses and services.
Broadband and High-Speed Internet (2000s):

• The 2000s witnessed the proliferation of broadband internet connections, offering

significantly higher speeds than traditional dial-up connections.
• Technologies such as Digital Subscriber Line (DSL), cable internet, and fiber optics
enabled faster and more reliable internet access for consumers and businesses.
• Broadband internet facilitated the growth of multimedia content, including
streaming video, online gaming, and social media platforms, transforming the way
people consume and interact with digital content.
Mobile Internet and Wireless Connectivity (2010s):

• The advent of smartphones and mobile devices revolutionized internet usage, driving
the popularity of mobile internet access.
• High-speed cellular networks such as 3G, 4G LTE, and eventually 5G provided
widespread wireless connectivity, allowing users to access the internet on the go.
• Mobile apps and responsive web design optimized for smaller screens became
increasingly prevalent, shaping user experiences on mobile devices.
Internet of Things (IoT) and Future Trends:

• The internet continues to evolve with emerging technologies such as the Internet of
Things (IoT), connecting a vast array of devices and objects to the internet.
• IoT devices, ranging from smart home appliances to industrial sensors, generate and
exchange data, driving innovation in areas like automation, healthcare, and
transportation.
• Future trends in internet evolution may include advancements in artificial
intelligence, virtual reality, augmented reality, and blockchain technology, shaping
the internet's trajectory in the years to come.

Web Browsers

A web browser is a software application used to access and navigate the World Wide Web. It
interprets HTML code, displays multimedia content, and allows users to interact with
websites. Popular browsers include Chrome, Firefox, Safari, and Edge. They often feature
extensions, bookmarks, and settings for customization. Security and privacy are key
considerations, with features like incognito mode and built-in privacy tools. Browsers play a
crucial role in the online experience, influencing speed, compatibility, and user interface
design.

Features of Web Browser

User Interface (UI): The visual elements that users interact with, including the address bar,
navigation buttons, bookmarks bar, and settings menu.
Browser Engine: It manages the communication between the UI and the rendering engine,
interpreting HTML and CSS to display web content properly.
Rendering Engine: Interprets HTML and CSS, rendering the content of a webpage on the
screen. Different browsers may use different rendering engines (e.g., Blink in Chrome, Gecko
in Firefox).
JavaScript Engine: Executes and processes JavaScript code on web pages, enabling dynamic
and interactive content.
Networking: Handles network requests, sending and receiving data between the browser
and web servers. It includes protocols like HTTP and HTTPS.

Search engine
• A search engine is a web-based tool or service that allows users to search for
information on the internet by entering keywords or phrases related to their query.
• Search engines use algorithms to crawl and index web pages across the internet,
organizing and cataloging them based on relevance to specific keywords and topics.
• When a user enters a search query, the search engine retrieves relevant results from
its index and presents them to the user in the form of a search results page.
• Search engines may also offer additional features such as image search, video search,
news search, and specialized search tools for specific types of content.
• Examples of search engines include Google, Bing, Yahoo, DuckDuckGo, and Baidu.

Components of a Search Engine

Crawling Software

• Responsible for systematically browsing the web and collecting information

from web pages. It identifies new and updated pages.
Index

• Stores and organizes the information collected during the crawling process.
This allows for quick retrieval of relevant results when users perform a search.
Ranking Algorithm

• Determines the order in which search results are presented to users based on
factors like relevance, authority, and other criteria
Search Query Processor

• Analyses and interprets user queries to understand the intent and deliver
relevant search results.
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 6 of 13
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
Caching System

• Stores copies of frequently accessed web pages or search results to improve

response times and reduce server load.

Meta Search Engine

A meta search engine is a search tool that aggregates results from multiple search
engines and presents them in a unified list. It doesn't have its own database but instead
fetches results from other search engines. Examples include Dogpile and MetaCrawler.

IP Address & MAC Address

IP address and MAC address are both identifiers used in computer networks, but they serve
different purposes and operate at different layers of the network stack. Here's a breakdown
of the differences between the two:
IP Address (Internet Protocol Address):

• An IP address is a numerical label assigned to each device connected to a

computer network that uses the Internet Protocol for communication.
• It serves two main purposes: host or network interface identification and
location addressing.
• IP addresses are typically assigned dynamically (via DHCP) or statically
(manually configured) and can be changed or reassigned as needed.
• IP addresses are used at the network layer (Layer 3) of the OSI model for
routing and addressing packets within a network and across networks.
• IP addresses can be either IPv4 (32 bits) or IPv6 (128 bits), with IPv6 being
increasingly adopted to accommodate the growing number of devices
connected to the internet.
MAC Address (Media Access Control Address):

• A MAC address is a unique identifier assigned to a network interface controller (NIC)

for communications at the data link layer (Layer 2) of a network segment.
• It is usually hardcoded into the hardware of the network adapter by the
manufacturer and serves as a permanent and globally unique identifier for the
device.
• MAC addresses are used for identifying devices within the same local network and
are primarily used for communication on the local network segment.
• Unlike IP addresses, MAC addresses do not change and remain constant throughout
the lifetime of the network adapter.

• MAC addresses are typically represented as a series of hexadecimal digits separated

by colons or hyphens (e.g., 00:1A:2B:3C:4D:5E).
Key Differences:

• Purpose: IP addresses are used for network layer addressing and routing, while MAC
addresses are used for data link layer communication within a local network
segment.
• Assignments: IP addresses can be dynamically assigned (via DHCP) or statically
configured, while MAC addresses are typically hardcoded into the hardware by the
manufacturer and remain unchanged.
• Scope: IP addresses are used for routing packets across networks, while MAC
addresses are used for communication within the same local network segment.
• Layer: IP addresses operate at the network layer (Layer 3) of the OSI model, whereas
MAC addresses operate at the data link layer (Layer 2).

Protocols

Communication Protocols: These protocols dictate how data is exchanged between devices.
o TCP (Transmission Control Protocol):
▪ Transmission Control Protocol (TCP) is a connection-oriented protocol
used in conjunction with IP to establish reliable and error-checked
communication between devices.
▪ TCP breaks data into packets, ensures they are delivered in order, and
retransmits any lost packets to ensure data integrity and reliability.
▪ TCP is widely used for applications that require guaranteed delivery of
data, such as web browsing, email, and file transfer.

o UDP (User Datagram Protocol):

▪ Transmission Control Protocol (TCP) is a connection-oriented protocol
used in conjunction with IP to establish reliable and error-checked
communication between devices.
▪ TCP breaks data into packets, ensures they are delivered in order, and
retransmits any lost packets to ensure data integrity and reliability.
▪ TCP is widely used for applications that require guaranteed delivery of
data, such as web browsing, email, and file transfer.

Internet Protocols: These protocols govern communication over the Internet.

o IP (Internet Protocol):

o HTTPS (Hypertext Transfer Protocol Secure): An extension of HTTP with

added security features for encrypted communication.
Network Protocols: These protocols operate at the network layer and manage how devices
communicate within a network
o DNS (Domain Name System):
▪ Transmission Control Protocol (TCP) is a connection-oriented protocol
used in conjunction with IP to establish reliable and error-checked
communication between devices.
▪ TCP breaks data into packets, ensures they are delivered in order, and
retransmits any lost packets to ensure data integrity and reliability.
▪ TCP is widely used for applications that require guaranteed delivery of
data, such as web browsing, email, and file transfer.

o DHCP (Dynamic Host Configuration Protocol): Assigns IP addresses

dynamically to devices in a network.
Email Protocols: These protocols handle the transmission and retrieval of email messages.
o SMTP (Simple Mail Transfer Protocol):
▪ Transmission Control Protocol (TCP) is a connection-oriented protocol
used in conjunction with IP to establish reliable and error-checked
communication between devices.
▪ TCP breaks data into packets, ensures they are delivered in order, and
retransmits any lost packets to ensure data integrity and reliability.
▪ TCP is widely used for applications that require guaranteed delivery of
data, such as web browsing, email, and file transfer.

Netiquettes

Netiquette, short for "network etiquette," refers to the set of social conventions, guidelines,
and rules governing respectful and appropriate behavior when communicating and
interacting with others online. Netiquette is essential for fostering positive and productive
online communication and maintaining a respectful online community.

Be Respectful and Courteous:

• Treat others with the same respect and courtesy that you would in face-to-face
interactions.
• Avoid offensive language, insults, and personal attacks. Be mindful of cultural
differences and sensitivities.
Use Proper Language and Tone:

• Use clear and concise language when communicating online.

• Avoid using excessive capitalization, which can be interpreted as shouting, and
refrain from using offensive or inappropriate language.

• Be aware of the tone of your messages and use emoticons or emojis to convey
emotions or intentions if necessary.
Think Before You Post:

• Before posting or sharing content online, consider the potential impact on others and
the broader community.
• Verify the accuracy of information before sharing it, especially if it could be
misleading or harmful.
• Remember that once something is posted online, it can be difficult to remove or
retract, so think carefully about the content you share.
Respect Privacy and Confidentiality:

• Respect the privacy of others and avoid sharing personal or sensitive information
without permission.
• Be cautious when sharing private information online, including passwords, financial
details, and personal photos or videos.
• Be mindful of privacy settings on social media platforms and adjust them to control
who can access your personal information.
Be Thoughtful in Communication:

• Use appropriate formatting and structure in your messages, such as paragraphs and
bullet points, to improve readability.
• Avoid spamming or flooding online forums, chat rooms, or email inboxes with
irrelevant or repetitive messages.
• Wait your turn to speak in group discussions or online meetings, and avoid
interrupting others.
Follow Community Guidelines and Rules:

• Familiarize yourself with the rules and guidelines of online platforms, forums, and
communities you participate in.
• Respect moderators and administrators who enforce community guidelines and
rules.
• Report inappropriate behavior or content to moderators or administrators when
necessary.
Be Patient and Understanding:

• Be patient and understanding when interacting with others online, especially if they
are new to the platform or technology.
• Offer help and support to others when needed, and be willing to listen and learn
from different perspectives.
Practice Good Digital Citizenship:

• Be a responsible and ethical digital citizen by promoting positive online behavior and
combating cyberbullying, harassment, and misinformation.
• Use technology and the internet in ways that contribute to the well-being of yourself
and others, and respect intellectual property rights when sharing content online.

Google Products

Google offers a diverse range of products and services across various categories, including
search, communication, productivity, entertainment, and technology. Here are some
important Google products:
Google Search:

• Google Search is the company's flagship product and the world's most popular
search engine. It allows users to search for information, websites, images, videos,
news, and more using keywords and phrases.
Gmail:

• Gmail is a free email service provided by Google, offering features such as a

customizable inbox, spam filtering, built-in chat, and integration with other Google
services like Google Drive and Google Calendar.
Google Maps:

• Google Maps is a web mapping service that provides detailed maps, satellite imagery,
street view, real-time traffic conditions, and turn-by-turn navigation for users around
the world.
Google Drive:

• Google Drive is a cloud storage and file-sharing service that allows users to store,
synchronize, and share files, documents, photos, and videos across devices. It also
includes Google Docs, Sheets, and Slides for collaborative document editing.
Google Photos:

• Google Photos is a cloud-based photo and video storage service that automatically
backs up and organizes users' photos and videos. It offers features like unlimited
storage, automatic tagging, facial recognition, and smart search.
Google Chrome:

• Google Chrome is a web browser developed by Google, known for its speed,
simplicity, and security features. It is the most popular web browser globally,
available on desktop and mobile platforms.
YouTube:

• YouTube is a video-sharing platform owned by Google, where users can upload, view,
and share videos. It offers a wide range of content, including music videos, tutorials,
vlogs, and live streams.
Google Workspace (formerly G Suite):

• Google Workspace is a suite of productivity tools for businesses and organizations,

including Gmail, Google Drive, Google Docs, Google Sheets, Google Slides, Google
Meet, Google Calendar, and more.
Google Meet:

• Google Meet is a video conferencing and collaboration platform that enables users to
host and join virtual meetings, webinars, and video calls. It offers features like screen
sharing, real-time captions, and integration with Google Calendar.
Android:

• Android is a mobile operating system developed by Google, used by billions of

smartphones and tablets worldwide. It offers a customizable user interface, access to
the Google Play Store for apps and games, and integration with Google services.
Google Assistant:

• Google Assistant is a virtual assistant powered by artificial intelligence that provides

voice-activated assistance and information retrieval. It is available on smartphones,
smart speakers, smart displays, and other devices.
Google Ads:

• Google Ads is an online advertising platform that allows businesses to create and
manage advertisements that appear in Google search results, websites, YouTube
videos, and other online platforms.

Microsoft Word
Interface of MS Word

Title Bar:

Displays the name of the document or "Document1" if unnamed.

Contains the standard minimize, maximize/restore, and close buttons.

Ribbon:

The Ribbon is a dynamic toolbar located at the top of the window, organized into tabs (e.g.,
Home, Insert, Page Layout, etc.).

Each tab contains groups of related commands and tools for various tasks.

Quick Access Toolbar:

Located above or below the Ribbon, it provides quick access to frequently used commands
and tools.

Users can customize the Quick Access Toolbar to include their preferred commands.

Backstage View:

Accessible by clicking the File tab.

Provides options for opening, saving, printing, and managing documents.

Includes document properties, options for exporting, and settings for the overall application.

Document Area:
Prepared By: Chanakya Institute of IT & Management
(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 1 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
The main area where users can create, edit, and view the content of their document.

Displays the blinking cursor to indicate the insertion point.

Scroll Bars:

Allow users to navigate through the document vertically or horizontally.

Include a vertical scroll bar on the right side and a horizontal scroll bar at the bottom.

Status Bar:

Located at the bottom of the window, it displays information about the document, such as
page number, word count, language, and view options.

Provides zoom controls for adjusting the document's magnification.

View Options:

Found in the lower-right corner, these buttons allow users to switch between different
document views, such as Print Layout, Read Mode, and Web Layout.

Zoom Slider:

Located on the status bar, it allows users to adjust the zoom level for a better view of the
document.

Insertion Point:

The blinking vertical line that indicates where the next character will be inserted.

Cursor:

The movable, visible indicator that shows the current position in the document.

Dialog Boxes:

Pop-up windows that appear when users access certain features or settings.

Users can customize various document properties through dialog boxes.

Formatting Toolbar:

Displays formatting options for the selected text, such as font style, size, bold, italic,
underline, and more.

Appears below the Ribbon.

Spell Check and Grammar Check:

Features that help users identify and correct spelling and grammar errors in the document.

Suggestions are provided, and users can choose to accept or ignore them.

Basic Text Operations

Prepared By: Chanakya Institute of IT & Management

(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 2 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
1. Entering Text:

• Click where you want to start typing in the document.

• Type the desired text using the keyboard.

2. Selecting Text:

• To select a single word: Double-click on the word.

• To select a portion of text: Click and drag the cursor over the desired text.

• To select the entire document: Press "Ctrl + A" on the keyboard.

3. Copying and Pasting:

• To copy selected text: Right-click, choose "Copy," or press "Ctrl + C."

• To paste copied text: Right-click where you want to paste and choose "Paste," or
press "Ctrl + V."

4. Cutting and Pasting:

• To cut selected text: Right-click, choose "Cut," or press "Ctrl + X."

• To paste the cut text: Right-click where you want to paste and choose "Paste," or
press "Ctrl + V."

5. Undo and Redo:

• To undo the last action: Press "Ctrl + Z."

• To redo an undone action: Press "Ctrl + Y."

6. Formatting Text:

• Change font style, size, and colour: Use the formatting options in the Ribbon under
the "Home" tab.

• Bold text: Press "Ctrl + B" or use the bold button in the Ribbon.

• Italicize text: Press "Ctrl + I" or use the italic button in the Ribbon.

• Underline text: Press "Ctrl + U" or use the underline button in the Ribbon.

7. Alignment:

• Align text left, centre, right, or justify: Use the alignment options in the Ribbon under
the "Home" tab.

8. Bullet Points and Numbering:

• Create bulleted or numbered lists: Use the respective buttons in the Ribbon under
the "Home" tab.

9. Line Spacing:

• Adjust line spacing: Use the line spacing options in the Ribbon under the "Home"
tab.

Prepared By: Chanakya Institute of IT & Management

(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 3 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
10. Find and Replace:

• To find specific text: Press "Ctrl + F" to open the Find dialog box.

• To find and replace text: Press "Ctrl + H" to open the Find and Replace dialog box.

11. Inserting Special Characters:

• Insert symbols or special characters: Use the "Symbol" button in the Ribbon under
the "Insert" tab.

12. Indentation:

• Indent paragraphs: Use the indentation options in the Ribbon under the "Home" tab.

Navigation Pane

The Navigation Pane in Microsoft Word is a helpful feature that provides a way to navigate through a
document, find specific content, and manage the document's structure. The Navigation Pane is
particularly useful for working with longer documents, such as reports, theses, or manuscripts.

1. Accessing the Navigation Pane:

• To open the Navigation Pane, go to the "View" tab in the Ribbon.

• Check the "Navigation Pane" option in the "Show" group.

2. Search and Navigation:

• The Navigation Pane allows you to search for specific words or phrases within the
document.

• Enter the desired search term in the search box at the top of the Navigation Pane.

• Word will highlight and display a list of all instances of the searched term in the
document.

3. Headings and Structure:

• If your document contains headings (formatted using styles such as Heading 1,

Heading 2, etc.), these headings will be listed in the Navigation Pane.

• This provides a quick overview of the document's structure and allows you to
navigate directly to specific sections.

4. Thumbnail View:

• In addition to the headings, you may see thumbnail images representing pages of
the document in the Navigation Pane.

• This visual representation helps you quickly identify and navigate to specific pages.

5. Drag-and-Drop Reorganization:

• You can rearrange the document's structure by dragging and dropping headings in
the Navigation Pane.

Prepared By: Chanakya Institute of IT & Management

(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 4 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• This action will reorganize the corresponding content in the document.

Find & Replace Feature of MS Word

The Find and Replace feature in Microsoft Word is a powerful tool that allows users to search for
specific text or formatting elements in a document and replace them with new text or formatting.
This feature is particularly useful when working with long documents or when you need to make
consistent changes throughout a document.

Finding Text:

1. Navigate to the Find Dialog:

• Press "Ctrl + F" on your keyboard or go to the "Home" tab in the Ribbon, click on the
"Editing" group, and then select "Find."

2. Enter the Search Term:

• In the Find dialog box, enter the word or phrase you want to find in the "Find what"
field.

3. Navigate Through Matches:

• Use the "Find Next" button to locate the first occurrence of the search term.

• Continue clicking "Find Next" to move through subsequent occurrences.

4. Close the Find Dialog:

• Once you've finished finding instances, close the Find dialog box.

Replacing Text:

1. Navigate to the Replace Dialog:

• Press "Ctrl + H" on your keyboard or go to the "Home" tab in the Ribbon, click on the
"Editing" group, and then select "Replace."

2. Enter the Search and Replace Terms:

• In the Replace dialog box, enter the word or phrase you want to find in the "Find
what" field.

• Enter the replacement text in the "Replace with" field.

3. Replace or Replace All:

• Use the "Find Next" button to locate the first occurrence of the search term.

• To replace a single occurrence, click "Replace." To replace all occurrences at once,

click "Replace All."

4. Close the Replace Dialog:

• Once you've finished replacing or made the necessary changes, close the Replace
dialog box.

Prepared By: Chanakya Institute of IT & Management

(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 5 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
Advanced Options:

• Match Case:

• Check the "Match case" option if you want the search to be case-sensitive.

• Whole Words:

• Check the "Whole words" option if you only want to find whole words that match
the search term.

• Use Wildcards:

• Check the "Use wildcards" option for more advanced search patterns using wildcard
characters.

• Format and Special:

• Use the "Format" button in the Replace dialog to search for specific formatting and
replace it accordingly.

Grammer and Spelling check feature in MS Word

The grammar and spelling check feature in Microsoft Word is a crucial tool that helps users identify
and correct errors in their written documents. These features are designed to improve the overall
quality and correctness of the text.

Spelling Check:

1. Automatic Spelling Check:

• As you type, Microsoft Word automatically checks for spelling errors. Underlined red
squiggly lines appear below misspelled words.

2. Manual Spelling Check:

• To manually check the entire document for spelling errors, go to the "Review" tab in
the Ribbon and click on "Spelling & Grammar" or press "F7."

3. Spell Check Suggestions:

• If Word detects a potential spelling error, it provides suggestions for corrections.

• Users can choose from the suggested corrections or ignore the suggestion if the
word is spelled correctly.

4. Add to Dictionary:

• If a word is not recognized but is correct in the context, users can add it to the
custom dictionary to prevent future flagging.

Grammar Check:

1. Automatic Grammar Check:

• Like the spelling check, Word also checks for grammar errors as you type. Underlined
green squiggly lines appear below potential grammatical issues.
Prepared By: Chanakya Institute of IT & Management
(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 6 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
2. Manual Grammar Check:

• To manually check the entire document for grammar errors, go to the "Review" tab
in the Ribbon and click on "Spelling & Grammar" or press "F7."

3. Grammar Check Suggestions:

• When a potential grammar error is identified, Word provides suggestions for

correction or flags the sentence for review.

• Users can choose from suggested corrections or choose to ignore the grammar
suggestion.

Views in MS Word
1. Print Layout View:

• Default View: The default view in Word.

• WYSIWYG (What You See Is What You Get): Represents the document as it would
appear when printed, including margins, headers, footers, and page breaks.

2. Read Mode:

• Optimized for Reading: Provides a clean and distraction-free layout for reading
documents.

• Navigation: Supports continuous scrolling and immersive reading experience.

Prepared By: Chanakya Institute of IT & Management

(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 7 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra

3. Web Layout View:

• Optimized for Online Viewing: Mimics how a document would appear on the web.

• Hyperlinks Active: Allows users to click on hyperlinks as if viewing a webpage.

4. Outline View:

• Structured Document Overview: Displays an outline of the document's structure.

• Headings and Subheadings: Shows headings, allowing users to navigate and

reorganize content easily.

Prepared By: Chanakya Institute of IT & Management

(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 8 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra

5. Draft View:

• Simplified Layout: Focuses on the content without displaying headers, footers, and
other elements.

• Fast Editing: Enables quick text entry and editing without worrying about the
document's final appearance.

Formatting Text and Paragraphs

Formatting Text:
Prepared By: Chanakya Institute of IT & Management
(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 9 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
1. Font Style, Size, and Colour:

• Select the text you want to format.

• In the "Home" tab of the Ribbon, use the font dropdown menu to choose a font
style.

• Use the font size dropdown to set the desired size.

• To change the font colour, use the "Font Colour" button in the Ribbon.

2. Bold, Italic, Underline:

• Select the text.

• Use the "Bold," "Italic," and "Underline" buttons in the Ribbon or use keyboard
shortcuts (Ctrl + B for bold, Ctrl + I for italic, Ctrl + U for underline).

3. Strikethrough and Subscript/Superscript:

• Use the "Strikethrough" button in the Ribbon for strikethrough.

• For subscript or superscript, use the respective buttons or the keyboard shortcuts
(Ctrl + = for subscript, Ctrl + Shift + + for superscript).

4. Text Case:

• Change text case using the "Change Case" button in the Ribbon. Options include
Sentence case, lowercase, UPPERCASE, Capitalize Each Word, and tOGGLE cASE.

5. Clear Formatting:

• To remove formatting and return to the default style, use the "Clear Formatting"
button in the Ribbon.

Formatting Paragraphs:

1. Alignment:

• Select the paragraphs.

• Use the alignment buttons in the Ribbon to align text left, center, right, or justify.

2. Line Spacing:

• Use the "Line and Paragraph Spacing" button in the Ribbon to set single, 1.5, double
spacing, or customize spacing options.

3. Paragraph Indentation:

• Adjust indentation using the "Increase Indent" and "Decrease Indent" buttons in the
Ribbon.

• Use the ruler to set specific indentation values.

4. Bullets and Numbering:

• Use the "Bullets" and "Numbering" buttons in the Ribbon to create bulleted or
numbered lists.
Prepared By: Chanakya Institute of IT & Management
(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 10 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• Customize list formatting using the dropdown menu.

5. Borders and Shading:

• Highlight the text or paragraph.

• Use the "Borders" and "Shading" options in the Ribbon to add borders or
background colour.

6. Spacing Before and After Paragraphs:

• Use the "Line and Paragraph Spacing" options in the Ribbon to set spacing before or
after paragraphs.

7. Tabs:

• Set custom tab stops using the ruler.

• Access advanced tab settings by clicking on the "Tabs" button in the Ribbon.

8. Drop Cap:

• Apply a drop cap to the first letter of a paragraph using the "Drop Cap" feature in the
Ribbon.

Styles:

1. Quick Styles:

• Apply predefined styles from the "Styles" group in the Ribbon for consistent
formatting.

2. Create and Modify Styles:

• Access the "Styles" pane to create, modify, or apply custom styles for text and
paragraphs.

Page Setup in MS Word

Page setup in Microsoft Word refers to configuring various settings related to the layout, size,
margins, and orientation of your document.

Setting Page Size and Orientation:

1. Open your document in Microsoft Word.

2. Go to the "Layout" or "Page Layout" tab in the Ribbon.

3. Click on the "Size" button:

• Choose a standard page size (Letter, Legal, A4, etc.).

• Alternatively, select "More Paper Sizes" to set custom dimensions.

4. Click on the "Orientation" button:

Prepared By: Chanakya Institute of IT & Management

(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 11 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• Choose between "Portrait" (vertical) and "Landscape" (horizontal) orientations.

Adjusting Margins:

1. In the "Layout" or "Page Layout" tab, click on "Margins."

• Choose from predefined margin settings or select "Custom Margins" for more
options.

2. In the "Page Setup" dialog box:

• Adjust top, bottom, left, and right margins as needed.

• You can also set the gutter, header, and footer distances.

Specifying Paper Source and Layout:

1. In the "Layout" or "Page Layout" tab, click on "Page Setup" or "Page Setup Dialog Box."

2. In the "Page Setup" dialog box:

• Choose the paper source, such as the printer tray.

• Set the paper source for the first page differently if needed.

Adding Page Numbers:

1. In the "Insert" tab, click on "Page Number."

• Choose the desired location for page numbers (Top of Page, Bottom of Page, Page
Margins, etc.).

2. Select a page number format.

Setting Page Background:

1. In the "Design" tab, click on "Page Colour" to change the background colour of the entire
page.

• Choose from the available colour options or customize.

Using Sections for Different Page Setup:

1. If your document requires different page setups (e.g., different margins or orientations),
you can use sections.

• Place the cursor where you want to start a new section.

2. Go to the "Layout" or "Page Layout" tab and click on "Breaks."

• Choose "Next Page" under "Section Breaks."

3. Now, you can apply different page setup options to each section independently.

• Repeat the process to create additional sections with unique settings.

Checking Page Setup Details:

1. To review and modify page setup details, click on the small arrow in the "Page Setup"
group in the "Layout" or "Page Layout" tab.
Prepared By: Chanakya Institute of IT & Management
(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 12 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• This opens a menu with options like "Margins," "Orientation," "Size," etc.

2. Select "Page Setup" to open the "Page Setup" dialog box, where you can make advanced
adjustments.

Print Preview:

1. Before finalizing, it's a good idea to check the print preview to see how your document will
look when printed.

• Go to the "File" tab, select "Print," and review the print preview on the right.

Mail Merge

Mail Merge in Microsoft Word is a powerful feature that allows you to create a set of documents,
such as letters, envelopes, labels, or emails, and customize each document with individualized
information from a data source. This is particularly useful when you need to send personalized
content to a large number of recipients.

Basic Mail Merge Process:

Step 1: Prepare Your Main Document

1. Open Microsoft Word and create a new document.

2. Go to the "Mailings" tab in the Ribbon.

Step 2: Select Document Type

1. Click on "Start Mail Merge" in the Mailings tab.

2. Choose the type of document you want to create (e.g., Letters, Email Messages, Envelopes,
Labels).

Step 3: Select Recipients

1. Click on "Select Recipients" in the Mailings tab.

2. Choose "Use an Existing List" to import data from an Excel spreadsheet, Access database, or
other data sources.

Step 4: Insert Merge Fields

1. Click on "Insert Merge Field" in the Mailings tab.

2. Insert placeholders for personalized information such as <<First Name>>, <<Last Name>>,
etc.

3. These merge fields will be replaced with actual data during the merge.

Step 5: Preview the Document

1. Click on "Preview Results" in the Mailings tab.

2. You can navigate through records to see how the final document will appear for each
recipient.

Prepared By: Chanakya Institute of IT & Management

(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 13 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
Step 6: Complete the Merge

1. Click on "Finish & Merge" in the Mailings tab.

2. Choose "Edit Individual Documents."

3. Select "All" if you want to merge all records or specify a range.

4. Click "OK" to complete the merge.

Prepared By: Chanakya Institute of IT & Management

(An Official Service Provider of Vocational and Co-Curricular Course)
https://www.nepvc.org.in
Page 14 of 14
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra

Microsoft Excel
Introduction and Importance of MS Excel

Introduction to Microsoft Excel:

Microsoft Excel is a powerful spreadsheet application developed by Microsoft as part of the

Microsoft Office suite. Launched in 1985, Excel has become one of the most widely used tools for
data analysis, calculation, and visualization. It allows users to organize, analyse, and present data in a
structured and efficient manner. Excel is equipped with a variety of features, functions, and tools that
make it suitable for a broad range of tasks, from simple calculations to complex financial modelling.

Importance of Microsoft Excel:

1. Data Organization and Management:

• Excel provides a structured grid where users can organize and manage data
efficiently. The grid layout allows for easy entry and manipulation of data in rows and
columns.

2. Calculations and Formulas:

• Excel is known for its robust calculation capabilities. Users can perform various
mathematical operations using built-in functions, formulas, and arithmetic
operations, making it a versatile tool for numerical analysis.

3. Data Analysis and Visualization:

• Excel offers a wide range of tools for data analysis, including pivot tables, charts, and
graphs. These features help users visualize trends, patterns, and insights in their
data, making complex datasets more understandable.

4. Financial Modelling:

• Excel is extensively used for financial modelling and analysis. Professionals in finance,
accounting, and business utilize Excel for tasks such as budgeting, forecasting, and
creating financial statements.

5. Project Management:

• Excel is employed for project management tasks, including creating Gantt charts,
tracking project timelines, managing budgets, and analysing resource allocation.

6. Data Entry and Validation:

• Excel provides data validation features, allowing users to define rules for data entry.
This ensures accuracy and consistency in data input.

Important Features of MS Excel

Microsoft Excel is a versatile spreadsheet software with a wide range of features that make it a
powerful tool for data management, analysis, and visualization. Here are some of the main features
of Microsoft Excel:

1. Grid Interface:

• Excel is based on a grid system where data is organized into rows and columns. Each
intersection of a row and a column is called a cell, and each cell can contain data, formulas,
or functions.

2. Formulas and Functions:

• Excel allows users to perform various calculations using formulas and functions. Functions
range from basic arithmetic operations (e.g., SUM, AVERAGE) to more complex statistical,
financial, and logical functions.

3. Data Visualization:

• Excel offers a variety of chart types to visualize data, including bar charts, pie charts, line
charts, and more. Users can create visually appealing charts and graphs to represent trends
and patterns in their data.

4. PivotTables and Pivot Charts:

• PivotTables enable users to summarize and analyse large datasets by dynamically

reorganizing and summarizing information. Pivot Charts provide visual representations of
PivotTable data.

5. Data Sorting and Filtering:

• Excel allows users to sort data alphabetically or numerically and apply filters to display
specific subsets of data. This feature is particularly useful for data analysis and exploration.

6. Data Validation:

• Data validation features in Excel enable users to set rules for data entry, ensuring data
accuracy and consistency. Users can define criteria for valid input, such as date ranges or
numerical limits.

7. Conditional Formatting:

• Users can apply conditional formatting to cells based on specified criteria. This helps
highlight important information, such as identifying high or low values in a dataset.

8. What-If Analysis:

• Excel supports scenario analysis and goal seeking, allowing users to explore different
scenarios by changing input values and observing the impact on calculated results.

9. Data Consolidation:

• Excel facilitates the consolidation of data from multiple sources or worksheets into a single
sheet, making it easier to analyse and manage large datasets.
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 2 of 25
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra

Data Formats that can be Entered in Excel

1. Text:

• General text can be entered directly into cells. Excel treats the data as text, and you can
include letters, numbers, and special characters.

2. Numbers:

• Numeric values, including integers and decimals, can be entered for quantitative data. Excel
recognizes numbers for mathematical calculations.

3. Dates:

• Dates can be entered in various formats, such as "MM/DD/YYYY" or "DD-MM-YYYY." Excel

recognizes date formats and allows users to perform date-related calculations.

4. Time:

• Time values can be entered in formats like "HH:MM AM/PM." Excel can handle time-related
calculations and formatting.

5. Currency:

• Currency values can be formatted using the appropriate currency symbols and decimal
places. Excel recognizes currency formatting for financial calculations.

6. Percentage:

• Percentage values can be entered as decimals or with the "%" symbol. Excel recognizes
percentages for calculations and can format them accordingly.

7. Scientific Notation:

• Large or small numbers can be entered in scientific notation, such as "1.23E+05" for 123,000.

8. Boolean (True/False):

• Boolean values, representing true or false, can be entered directly. These are often used in
logical calculations.

9. Text with Special Formats:

• Text can be formatted with special characters, such as phone numbers, ZIP codes, or social
security numbers. Excel allows users to customize formats for specific data types.

Cells in MS – Excel

In Microsoft Excel, a cell is the fundamental unit of the spreadsheet where you can input, store, and
manipulate data. Each cell is identified by a unique address, called a cell reference, which is a

Cell:

• Definition: A cell is the intersection point of a column and a row on an Excel worksheet.

• Properties:

• A cell can contain various types of data, including text, numbers, dates, formulas,
and functions.

• Cells are organized in a grid, forming columns labeled with letters (A, B, C, ...) and
rows labeled with numbers (1, 2, 3, ...).

• The default size of a cell is one square, but you can merge cells to create larger areas
for text or data.

Cell Address:

• Definition: A cell address is a unique identifier for a cell, representing its location on the
spreadsheet grid.

• Structure:

• The cell address consists of the column letter followed by the row number. For
example, the cell at the intersection of column B and row 3 has the address B3.

• In Excel, columns are labeled alphabetically (A, B, C, ...) and rows are numbered (1, 2,
3, ...).

• Examples:

• A1: Refers to the cell in the first column and the first row.

• D10: Refers to the cell in the fourth column and the tenth row.

• G5: Refers to the cell in the seventh column and the fifth row.

Cell Reference
A cell reference in Microsoft Excel is a unique identifier that specifies the location of a cell within a
worksheet. It is a combination of the column letter and row number that indicates the intersection
point of a column and a row. This reference helps you identify and work with specific cells when
entering data, creating formulas, or performing other operations in Excel.

The basic structure of a cell reference is as follows:

• Column Letter: Represents the column in which the cell is located. Columns are labelled
alphabetically from A to Z, then AA to ZZ, and so on.
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 4 of 25
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• Row Number: Represents the row in which the cell is located. Rows are numbered
numerically from 1 to the maximum number of rows in a worksheet.

Cell referencing
Absolute Cell Referencing:

1. Definition:

• In absolute cell referencing, the cell reference does not change when you copy the
formula to another location. The reference remains fixed, pointing to the same cell.

2. Notation:

• Absolute references are denoted by placing a "$" symbol before the column letter
and row number. For example, $A$1.

3. Example:

• If you have a formula like =$A$1+B2, and you copy it to another cell, the reference to
$A$1 will not change, but the reference to B2 will adjust based on the new location.

4. Use Case:

• Absolute cell referencing is useful when you want a part of the formula to
consistently refer to the same cell, irrespective of where you copy the formula.

Relative Cell Referencing:

1. Definition:

• In relative cell referencing, the cell reference adjusts when you copy the formula to
another location. It is relative to the position of the formula.

2. Notation:

• Relative references are indicated without the "$" symbol. For example, A1.

3. Example:

• If you have a formula like =A1+B2, and you copy it to another cell, both references
A1 and B2 will adjust based on the new location. If you copy the formula from cell C3
to cell D4, it becomes =B2+C3.

4. Use Case:

• Relative cell referencing is useful when you want the formula to adjust dynamically
based on its new position, particularly when you are performing calculations relative
to nearby cells.

Mixed Cell Referencing:

1. Definition:

• Mixed cell referencing is a combination of absolute and relative references in the

same formula. You can fix either the column or the row while leaving the other part
relative.

• A mixed reference can be $A1 (absolute column, relative row) or A$1 (relative
column, absolute row).

3. Example:

• If you have a formula like =$A1+B2, and you copy it to another cell, the reference to
$A1 will not change, but the reference to B2 will adjust based on the new location.

4. Use Case:

• Mixed cell referencing is useful when you want part of the formula to stay fixed while
allowing the other part to adjust.

Formulas in MS Excel
In Microsoft Excel, a formula is an expression that performs a calculation, returns a value, or
performs a specific operation on data within a worksheet. Formulas are used to perform
mathematical, logical, statistical, or text operations and can reference cells, ranges, or constants.
Formulas are a fundamental aspect of Excel and play a key role in automating calculations and data
analysis.

Components of an Excel Formula:

1. Equal Sign (=):

• A formula in Excel always begins with an equal sign, which signals to Excel that what
follows is a calculation.

2. Operators:

• Mathematical operators (+ for addition, - for subtraction, * for multiplication, / for

division, etc.) are used to perform specific operations.

3. Cell References:

• Cells or ranges are referred to in a formula by their cell references. For example, A1
refers to the cell in column A and row 1.

4. Functions:

• Functions are predefined formulas that perform specific calculations or operations.

Functions in Excel are denoted by their name followed by parentheses. Examples
include SUM(), AVERAGE(), and CONCATENATE().

5. Constants:

• Numeric values or text entered directly into the formula are referred to as constants.
For instance, entering 5 directly into a formula is a constant.

Microsoft Excel includes a wide range of functions to perform various calculations and operations on
data. Here are some of the main functions commonly used in Excel:

1. SUM Function:

• Syntax: =SUM(number1, [number2], ...)

• Adds up all the numbers in a range.

2. AVERAGE Function:

• Syntax: =AVERAGE(number1, [number2], ...)

• Calculates the average of a range of numbers.

3. COUNT Function:

• Syntax: =COUNT(value1, [value2], ...)

• Counts the number of cells that contain numbers.

4. IF Function:

• Syntax: =IF(logical_test, value_if_true, value_if_false)

• Performs a logical test and returns one value if true and another if false.

5. VLOOKUP Function:

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Searches for a value in the first column of a table and returns a value in the same row from
another column.

6. HLOOKUP Function:

• Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

• Searches for a value in the first row of a table and returns a value in the same column from
another row.

7. INDEX and MATCH Functions (Combined):

• Syntax: =INDEX(return_range, MATCH(lookup_value, lookup_range, 0))

• Looks up a value in a column or row and returns a value in the same position from a different
range.

8. CONCATENATE or CONCAT Function:

• Syntax: =CONCATENATE(text1, [text2], ...)

• Combines multiple text strings into one.

9. TEXT Function:

• Syntax: =TEXT(value, format_text)

10. IFERROR Function:

• Syntax: =IFERROR(value, value_if_error)

• Returns a custom result when a formula generates an error, and a default result otherwise.

11. COUNTIF Function:

• Syntax: =COUNTIF(range, criteria)

• Counts the number of cells in a range that meet a specified condition.

12. SUMIF Function:

• Syntax: =SUMIF(range, criteria, [sum_range])

• Adds up the numbers in a range that meet a specified condition.

13. AVERAGEIF Function:

• Syntax: =AVERAGEIF(range, criteria, [average_range])

• Calculates the average of numbers in a range that meet a specified condition.

14. DATE Function:

• Syntax: =DATE(year, month, day)

• Creates a date using the provided year, month, and day.

15. NOW Function:

• Syntax: =NOW()

• Returns the current date and time.

16. LEN Function:

• Syntax: =LEN(text)

• Returns the number of characters in a text string.

Conditional Formatting

Conditional Formatting in Excel is a powerful feature that allows users to apply formatting to cells
based on specified conditions. It helps highlight, organize, and analyze data more effectively by
visually emphasizing certain aspects of the spreadsheet. Conditional Formatting is available in the
"Home" tab on the Excel ribbon.

Steps to Apply Conditional Formatting:

1. Select the Range:

• Highlight the range of cells to which you want to apply conditional formatting.

2. Go to the "Home" Tab:

3. Click on "Conditional Formatting":

• In the "Styles" group, click on "Conditional Formatting." This opens a menu with
various options.

4. Choose a Formatting Rule:

• Select a formatting rule based on your requirements. Common rules include:

• Highlight Cells Rules: Apply formatting based on cell values (e.g., greater
than, less than, between).

• Top/Bottom Rules: Format cells that are in the top or bottom percentage or
number of the selected range.

• Data Bars, Color Scales, and Icon Sets: Apply visual indicators like color
gradients or icons based on cell values.

• New Rule: Create a custom rule using formulas.

5. Set Formatting Options:

• Configure the formatting options for the selected rule. This may include selecting
colors, fonts, or icon styles.

6. Preview and Apply:

• Preview how the formatting will look, and click "OK" to apply the conditional
formatting.

Data Validation

In Microsoft Excel, data validation is a feature that enables users to control and restrict the type of
data that can be entered into a cell or a range of cells. This helps maintain data accuracy, consistency,
and integrity in a spreadsheet. Here's a step-by-step guide on how to use data validation in Excel:

Applying Data Validation:

1. Select the Cell or Range:

• Highlight the cell or range of cells where you want to apply data validation.

2. Go to the "Data" Tab:

• Navigate to the "Data" tab on the Excel ribbon.

3. Click on "Data Validation":

• In the "Data Tools" group, click on "Data Validation." This opens the Data Validation
dialog box.

4. Choose a Validation Criteria:

• Whole number, Decimal, List, Date, Time, Text Length, Custom, etc.

• Based on the selected criteria, additional options may appear for you to set specific
rules.

5. Configure Validation Settings:

• Set specific criteria or values based on the chosen validation type. For example:

• If you choose "Whole number," you can specify a range of whole numbers.

• If you choose "List," you can provide a list of valid values.

6. Input Message (Optional):

• On the "Input Message" tab, you can provide an optional input message that will
appear when the user selects the cell. This message can provide guidance on what
kind of data is expected.

7. Error Alert (Optional):

• On the "Error Alert" tab, you can set up an error message that appears when users
enter invalid data. This helps guide users and ensure data accuracy.

8. Click "OK" to Apply:

• After configuring the data validation settings, click "OK" to apply the data validation
to the selected cell or range.

SORTING AND FILTERING

Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 10 of 25
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• Before performing data, analysis or generating reports, it's often necessary to
sort the data based on specific criteria. This ensures that the analysis is
accurate and provides meaningful insights.
4. Facilitating Comparison:
• Sorting enables easy comparison of values. For instance, sorting a column of
numbers in ascending or descending order allows quick identification of the
highest or lowest values.
5. Data Validation:
• Sorting helps in detecting and correcting errors in datasets. Inconsistencies or
outliers may become more apparent when data is sorted, allowing for quick
validation and correction.
Importance of Filtering Data:
1. Focus on Relevant Information:
• Filtering allows you to focus on specific subsets of data by temporarily hiding
irrelevant information. This is particularly useful when dealing with large
datasets with multiple categories.
2. Quick Data Exploration:
• Filters provide a quick way to explore data by selectively displaying only the
information that meets certain criteria. This is especially helpful when
searching for specific items or values.
3. Data Analysis:
• Filters assist in isolating and analysing specific portions of the dataset. You can
filter data based on conditions, making it easier to perform targeted analysis
and draw conclusions.
4. Identifying Exceptions and Outliers:
• Filters help in identifying exceptions or outliers within a dataset by allowing
you to isolate data that meets certain criteria. This is valuable for quality
control and anomaly detection.
5. Enhancing Data Presentation:
• Filtered data can be presented in a more organized and concise manner,
facilitating better communication of information in reports or presentations.

CHARTS AND GRAPHS

In Microsoft Excel, a chart is composed of various elements that work together to visually
represent and convey data. Here are the main components of a chart in Excel:
1. Chart Area:
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 11 of 25
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• The entire chart, including all elements, is enclosed within the chart area. It is
the outer boundary of the chart.
2. Plot Area:
• The plot area is the region inside the chart area where the actual chart is
displayed. It contains the bars, lines, points, or other graphical
representations of the data.
3. Axes:
• Excel charts typically have two axes: the horizontal (X-axis) and the vertical (Y-
axis). These axes help define the scale and values represented in the chart.
4. Data Series:
• A data series is a collection of related data points that are represented
together on the chart. For example, a bar chart may have multiple data series,
each corresponding to a different category.
5. Data Points:
• Data points are individual values within a data series. Each data point is
represented by a marker (such as a bar or point) on the chart.
6. Legend:
• The legend helps identify and differentiate between various data series on the
chart. It usually includes labels for each series, making it easier for viewers to
interpret the chart.
7. Title:
• The title provides a brief description of the chart's content. It is placed above
or within the chart area and helps users understand the purpose or context of
the chart.
8. Axis Titles:
• Both the X-axis and Y-axis can have titles that describe the data they
represent. These titles help clarify the meaning of the chart.
9. Gridlines:
• Gridlines are horizontal and vertical lines that help users read values from the
chart. They extend from the tick marks on the axes to the plot area.
10. Tick Marks:
• Tick marks are small marks along the axes that indicate specific data points or
intervals. They help users gauge the scale and values on the chart.
11. Data Labels:
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 12 of 25
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• Data labels display the actual values of individual data points on the chart.
They can be positioned directly on the data points or adjacent to them.
12. Chart Styles and Colours:
• Excel provides various styles and color schemes to enhance the visual appeal
of the chart. Users can choose from preset styles or customize colors and
formatting.
13. Chart Tools:
• The Chart Tools tab appears on the ribbon when a chart is selected. It
contains various options and commands for formatting, editing, and
customizing the chart.

1. Column Chart:
Usage:
• Suitable for comparing values across different categories or displaying data changes
over a discrete set of items.
• Can be used for single or clustered columns to represent data variations.
Advantages:
• Easy to understand and widely used.
• Ideal for showcasing data with clear distinctions.
Disadvantages:
• May become cluttered with too much data.
• Not suitable for displaying continuous data.
How to Use:
1. Select the data you want to represent.
2. Go to the "Insert" tab, click on "Column Chart," and choose the desired subtype.
2. Line Chart:
Usage:
• Shows trends over a continuous period.

Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 13 of 25
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• Useful for displaying data points connected by straight lines.
Advantages:
• Excellent for illustrating trends and patterns.
• Easily highlights overall data direction.
Disadvantages:
• Not suitable for displaying discrete data.
• May not emphasize individual data points well.
How to Use:
1. Select your data.
2. Go to the "Insert" tab, click on "Line Chart," and select the appropriate subtype.
3. Pie Chart:
Usage:
• Represents parts of a whole.
• Effective for displaying the contribution of each data point to the total.
Advantages:
• Easily conveys the proportion of each category.
• Visually appealing and straightforward.
Disadvantages:
• Not ideal for large datasets.
• Comparing values within segments can be challenging.
How to Use:
1. Highlight the data.
2. Go to the "Insert" tab, click on "Pie Chart," and choose the desired subtype.
4. Bar Chart:
Usage:
• Similar to column charts, but the bars are horizontal.
• Useful for comparing data across different categories.
Advantages:
• Provides a clear comparison of values.
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 14 of 25
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• Well-suited for long category names.
Disadvantages:
• May look cluttered with too many bars.
• Not effective for displaying time-based data.
How to Use:
1. Select the data.
2. Go to the "Insert" tab, click on "Bar Chart," and choose the subtype you prefer.
5. Scatter Plot:
Usage:
• Displays individual data points on a two-dimensional graph.
• Suitable for showing the relationship between two variables.
Advantages:
• Reveals correlations and trends effectively.
• Can represent a large dataset with individual data points.
Disadvantages:
• May not be suitable for categorical data.
• Requires a large dataset for meaningful insights.
How to Use:
1. Select the data.
2. Go to the "Insert" tab, click on "Scatter Plot," and choose the subtype that fits your
data.

Protecting a worksheet

Security in Excel refers to the measures and features that help protect your Excel files, data, and the
overall integrity of your spreadsheets. Here are some key aspects of security in Excel:

1. Workbook Protection:

• Password Protection: You can password-protect your entire Excel workbook to prevent
unauthorized access. This can be done when saving the workbook, and users need to enter
the correct password to open it.

• Read-Only Mode: You can set a workbook to be read-only, restricting users from making
changes to the original file.

2. Worksheet Protection:
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 15 of 25
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
• Protecting Cells and Ranges: You can protect specific cells, ranges, or entire sheets. This
allows you to control which parts of the worksheet can be edited.

• Password Protection: Like workbook protection, individual sheets or ranges can be

password-protected.

3. File Encryption:

• Encrypt with a Password: Excel allows you to encrypt your workbook with a password using
advanced encryption standards, adding an extra layer of security.

4. Digital Signatures:

• Digital Certificates: Excel supports digital signatures, allowing users to sign workbooks with a
digital certificate. This verifies the authenticity of the workbook and ensures it hasn't been
tampered with.

5. Trusted Documents:

• Trusted Locations: You can specify trusted locations on your computer or network where
Excel will allow macros to run without displaying security warnings. This is useful for
preventing malicious code execution.

6. Protected View:

• Opening Files in Protected View: Excel automatically opens files from potentially unsafe
locations in a protected view, restricting some functionalities. Users can choose to enable
editing if they trust the source.

7. Data Validation:

• Data Validation Rules: Use data validation to control the type and values of data entered
into cells. This helps prevent errors and ensures data accuracy.

Pivot Table
A PivotTable in Excel is a powerful data analysis and summarization tool that allows you to organize
and analyse large sets of data in a structured way. It helps you quickly extract meaningful insights
and trends from your data. Here's a detailed explanation of PivotTables in Excel:

1. Understanding PivotTables:

• Data Source: A PivotTable requires a source range or table in Excel. This could be a range of
cells or a formatted Excel table.

• Fields: Data in the source range is categorized into fields. Fields can include columns, rows,
values, and filters.

2. Creating a PivotTable:

• Select the data you want to analyse.

• Go to the "Insert" tab in the Excel ribbon.

• Click on "PivotTable."
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 16 of 25
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
3. PivotTable Fields:

• Values: This is where you place the numeric data you want to analyse, such as sales,
quantities, or other measurable values.

• Rows and Columns: These fields determine how the data is organized in rows and columns.
For example, you might place the "Product" field in columns and the "Region" field in rows.

• Filters: This allows you to filter data based on specific criteria.

4. Arranging Data:

• Drag and drop fields into the Rows, Columns, Values, and Filters areas in the PivotTable Field
List to arrange the data the way you want.

• You can move fields around to see the data from different perspectives.

5. Summarizing Data:

• Values in the Values area can be summarized using various functions like Sum, Average,
Count, Min, Max, etc. This is useful for numerical data.

6. Grouping Data:

• You can group data by date, number ranges, or custom categories to simplify analysis.

7. Sorting and Filtering:

• You can sort data within the PivotTable and apply filters to focus on specific subsets of data.

8. Calculated Fields:

• You can create calculated fields within the PivotTable to perform calculations on the existing
data.

9. Refreshing Data:

• If your source data changes, you can refresh the PivotTable to reflect the latest information.

10. Formatting:

• You can format the PivotTable to make it more visually appealing and easier to read.

11. Slicers:

• Slicers are visual filters that make it easy to filter data in a PivotTable and see the impact
immediately.

Pivot Charts
A PivotChart in Excel is a graphical representation of data created using a PivotTable. While
PivotTables are excellent for analysing and summarizing data in a tabular format, Pivot Charts
provide a visual representation of that data. Pivot Charts allow users to quickly interpret trends,
patterns, and comparisons within the data. Here's an explanation of Pivot Charts in Excel:

Creating a PivotChart:

1. Create a PivotTable:

2. Select Data for the Chart:

• Choose the data fields you want to include in the PivotChart. These can be dragged
and dropped into the Values, Rows, Columns, and Filters areas in the PivotTable.

3. Insert PivotChart:

• After creating the PivotTable, go to the "Insert" tab in the Excel ribbon.

4. Select Chart Type:

• Click on "PivotChart" and choose the type of chart you want to create. Excel offers
various types, including bar charts, column charts, line charts, pie charts, etc.

5. Specify Chart Location:

• Decide whether you want the PivotChart to be placed in the existing worksheet or
on a new worksheet.

6. Configure the Chart:

• Excel opens a new chart area where you can further customize the appearance of
your PivotChart.

Benefits of Pivot Charts:

1. Visual Analysis:

• Pivot Charts provide a visual representation of data, making it easier to identify

trends, outliers, and patterns.

2. Dynamic Updates:

• When the underlying PivotTable is updated, the associated PivotChart is

automatically updated, ensuring consistency between the data and its visual
representation.

3. Interactivity:

• Pivot Charts are interactive, allowing users to explore and analyse data by interacting
with chart elements.

4. Easy Comparison:

• Comparing data across different categories or time periods is simplified through

Pivot Charts.

5. Enhanced Presentation:

• Pivot Charts are useful for presenting data in a more engaging and understandable
format, especially in reports and presentations.

SORTING AND FILTERING

Sorting and filtering are crucial features in Microsoft Excel that play a significant role in
organizing and analysing data. Here's an explanation of the importance of sorting and filtering
data in Excel:
Importance of Sorting Data:
6. Organizing Data:
• Sorting allows you to arrange data in a specific order, such as alphabetically,
numerically, or by date. This organization enhances the visual structure of the
data, making it easier to read and understand.
7. Identifying Trends and Patterns:
• Sorting data helps in identifying trends and patterns within the dataset. For
example, sorting sales data by date can reveal trends over time, making it
easier to analyse and interpret.
8. Preparing Data for Analysis:
• Before performing data, analysis or generating reports, it's often necessary to
sort the data based on specific criteria. This ensures that the analysis is
accurate and provides meaningful insights.
9. Facilitating Comparison:
• Sorting enables easy comparison of values. For instance, sorting a column of
numbers in ascending or descending order allows quick identification of the
highest or lowest values.
10. Data Validation:
• Sorting helps in detecting and correcting errors in datasets. Inconsistencies or
outliers may become more apparent when data is sorted, allowing for quick
validation and correction.
Importance of Filtering Data:
6. Focus on Relevant Information:
• Filtering allows you to focus on specific subsets of data by temporarily hiding
irrelevant information. This is particularly useful when dealing with large
datasets with multiple categories.
7. Quick Data Exploration:
• Filters provide a quick way to explore data by selectively displaying only the
information that meets certain criteria. This is especially helpful when
searching for specific items or values.

CHARTS AND GRAPHS

In Microsoft Excel, a chart is composed of various elements that work together to visually
represent and convey data. Here are the main components of a chart in Excel:
14. Chart Area:
• The entire chart, including all elements, is enclosed within the chart area. It is
the outer boundary of the chart.
15. Plot Area:
• The plot area is the region inside the chart area where the actual chart is
displayed. It contains the bars, lines, points, or other graphical
representations of the data.
16. Axes:
• Excel charts typically have two axes: the horizontal (X-axis) and the vertical (Y-
axis). These axes help define the scale and values represented in the chart.
17. Data Series:
• A data series is a collection of related data points that are represented
together on the chart. For example, a bar chart may have multiple data series,
each corresponding to a different category.
18. Data Points:
• Data points are individual values within a data series. Each data point is
represented by a marker (such as a bar or point) on the chart.
19. Legend:

1. Column Chart:
Usage:

Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 22 of 25
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
Advantages:
• Easily conveys the proportion of each category.
• Visually appealing and straightforward.
Disadvantages:
• Not ideal for large datasets.
• Comparing values within segments can be challenging.
How to Use:
3. Highlight the data.
4. Go to the "Insert" tab, click on "Pie Chart," and choose the desired subtype.
4. Bar Chart:
Usage:
• Similar to column charts, but the bars are horizontal.
• Useful for comparing data across different categories.
Advantages:
• Provides a clear comparison of values.
• Well-suited for long category names.
Disadvantages:
• May look cluttered with too many bars.
• Not effective for displaying time-based data.
How to Use:
3. Select the data.
4. Go to the "Insert" tab, click on "Bar Chart," and choose the subtype you prefer.
5. Scatter Plot:
Usage:
• Displays individual data points on a two-dimensional graph.
• Suitable for showing the relationship between two variables.
Advantages:
• Reveals correlations and trends effectively.
• Can represent a large dataset with individual data points.
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 23 of 25
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
Disadvantages:
• May not be suitable for categorical data.
• Requires a large dataset for meaningful insights.
How to Use:
3. Select the data.
4. Go to the "Insert" tab, click on "Scatter Plot," and choose the subtype that fits your
data.

Protecting a worksheet

Security in Excel refers to the measures and features that help protect your Excel files, data, and the
overall integrity of your spreadsheets. Here are some key aspects of security in Excel:

1. Workbook Protection:

• Read-Only Mode: You can set a workbook to be read-only, restricting users from making
changes to the original file.

2. Worksheet Protection:

• Protecting Cells and Ranges: You can protect specific cells, ranges, or entire sheets. This
allows you to control which parts of the worksheet can be edited.

• Password Protection: Like workbook protection, individual sheets or ranges can be

password-protected.

3. File Encryption:

• Encrypt with a Password: Excel allows you to encrypt your workbook with a password using
advanced encryption standards, adding an extra layer of security.

4. Digital Signatures:

5. Trusted Documents:

6. Protected View:

7. Data Validation:

• Data Validation Rules: Use data validation to control the type and values of data entered
into cells. This helps prevent errors and ensures data accuracy.

MS-Power point

Procedure to create, save, and close a presentation

Creating, saving, and closing a presentation typically involves using presentation software, such as
Microsoft PowerPoint or Google Slides. Here's a general guide using Microsoft PowerPoint as an
example:

1. Creating a Presentation:

a. Open Microsoft PowerPoint: - On Windows: You can find PowerPoint in the Microsoft Office suite,
usually under the Start menu. - On Mac: Look for PowerPoint in the Applications folder or use
Spotlight Search.

b. Choose a template or start with a blank presentation: - PowerPoint often provides various
templates to choose from. You can also start with a blank presentation.

c. Add slides: - Click on "New Slide" to add slides to your presentation. - Customize each slide by
adding text, images, charts, and other elements.

2. Saving a Presentation:

a. Save the presentation for the first time: - Click on "File" in the top left corner. - Select "Save As" or
"Save a Copy." - Choose the location where you want to save the file. - Enter a name for your
presentation. - Select the desired format (usually .pptx for PowerPoint).

b. Saving subsequent changes: - After the initial save, use "Ctrl + S" (Windows) or "Command + S"
(Mac) to quickly save your changes. - Alternatively, click on "File" and select "Save."

3. Closing a Presentation:

a. Save any changes: - Before closing, make sure to save any changes you've made since the last save.

b. Close the presentation: - Click on the "X" button in the top right corner of the PowerPoint window.
- Alternatively, go to "File" and select "Close" or "Exit."

Method to open and view a presentation

1. Opening a Presentation:

a. Launch PowerPoint: - On Windows: Look for PowerPoint in the Microsoft Office suite, usually
under the Start menu. - On Mac: Find PowerPoint in the Applications folder or use Spotlight Search.

b. Open an Existing Presentation: - Click on "File" in the top left corner. - Select "Open" from the
menu. - Navigate to the location where your presentation is saved. - Select the presentation file
(usually with a .pptx extension) and click "Open."

2. Viewing a Presentation:

b. Slide Show View: - To view the presentation in Slide Show mode, click the "Slide Show" tab at the
top and select "From Beginning." - Alternatively, you can press "F5" on your keyboard to start the
presentation from the beginning.

c. Slide Sorter View: - Click on the "View" tab and select "Slide Sorter" to see a thumbnail view of all
slides. - This view allows you to rearrange slides easily.

d. Reading View: - Click on the "View" tab and select "Reading View" to see a full-screen view of your
slides.

Importance of Views in PowerPoint

Microsoft PowerPoint offers different views to allow users to work on presentations in various ways.
Each view serves a specific purpose and provides a unique perspective on the presentation. Here's a
breakdown of the importance of different views in PowerPoint:

1. Normal View:

• Importance: This is the default view and the most commonly used. In Normal view,
you can see individual slides on the left and the current slide in the main workspace.
It's ideal for creating and editing slides, adding text, images, and other elements.

• Use Cases: Creating and editing slides, adding content, formatting, and fine-tuning
details.

2. Slide Sorter View:

• Importance: Slide Sorter provides a bird's-eye view of all the slides in your
presentation. It allows you to easily reorder slides, duplicate them, or delete them.

• Use Cases: Rearranging slides, organizing content flow, and managing the overall
structure of the presentation.

3. Slide Show View:

• Importance: Slide Show view is crucial for presenting your slides to an audience. It
displays the slides in full-screen mode with animations and transitions, allowing you
to experience the presentation as your audience would.

• Use Cases: Rehearsing and delivering presentations, testing animations and

transitions.

4. Notes Page View:

• Importance: Notes Page view allows you to view and edit speaker notes associated
with each slide. This is valuable for presenters who want to have additional
information, reminders, or cues while presenting.

• Use Cases: Adding and editing speaker notes, providing additional context for each
slide.

5. Reading View:

• Use Cases: Reviewing content, proofreading, getting a comprehensive overview of

the presentation.

6. Outline View:

• Importance: Outline View displays the text content of each slide in a structured
outline format. It's helpful for quickly navigating and editing the text content of your
slides.

• Use Cases: Editing text content efficiently, reorganizing and structuring the outline of
the presentation.

Methods to format slide layout and content

Formatting slide layout and content in PowerPoint is essential to create visually appealing and
effective presentations. Here are methods to format both the layout and content of slides:

Formatting Slide Layout:

1. Choose a Slide Layout:

• Click on the "Home" tab.

• In the Slides group, click on the "Layout" dropdown.

• Choose a layout that suits your content (Title Slide, Title and Content, Two Content,
etc.).

2. Customize Slide Layout:

• Click on the "View" tab.

• Select "Slide Master."

• Make changes to the master slide, which will apply to all slides using that layout.

3. Change Slide Size:

• Click on the "Design" tab.

• In the Customize group, click on "Slide Size."

• Choose a standard size or set a custom size.

4. Modify Background:

• Click on the "Design" tab.

• In the Background group, choose "Format Background" to change color, add a

picture, or apply gradients.

• Click on the "Insert" tab.

• In the Text group, click on "Header & Footer" to add date, time, slide number, or
custom text.

Formatting Slide Content:

1. Text Formatting:

• Highlight the text you want to format.

• Use options in the "Home" tab (Font, Font Size, Bold, Italics, Underline) to format
text.

2. Aligning and Distributing Elements:

• Select the elements you want to align or distribute.

• Click on the "Format" tab.

• In the Arrange group, use options like Align and Distribute for precise arrangement.

3. Inserting and Formatting Shapes:

• Click on the "Insert" tab.

• In the Illustrations group, click on "Shapes" to add a shape.

• Click and drag to draw the shape, then use the "Format" tab to modify its
appearance.

4. Adding and Formatting Images:

• Click on the "Insert" tab.

• In the Images group, click on "Pictures" to insert an image.

• Click on the image, then use the "Format" tab to adjust size, position, and apply
effects.

5. Applying Transitions:

• Click on the "Transitions" tab.

• Choose a transition effect to apply between slides.

6. Adding Animations:

• Click on the "Animations" tab.

• Select an element, then choose an animation effect.

7. Applying Slide Design Themes:

• Click on the "Design" tab.

• Choose a predefined theme to apply to your slides.

• Click on the "View" tab.

• Select "Slide Master" to make global changes to fonts, colours, and placeholders.

Methods to insert pictures, tables, charts, and screenshots

In Microsoft PowerPoint, you can easily insert pictures, tables, charts, and screenshots into your
slides to enhance your presentations. Here are the methods to insert each of these elements:

Inserting Pictures:

• Click on the slide where you want to insert the picture.

• Go to the "Insert" tab on the PowerPoint ribbon.
• Click on the "Pictures" button in the Illustrations group.
• Browse and select the picture file you want to insert, then click "Insert."

Inserting Tables:

• Click on the slide where you want to insert the table.

• Go to the "Insert" tab on the PowerPoint ribbon.
• Click on the "Table" button in the Tables group.
• Select the number of rows and columns for your table from the grid that appears.
• Once you've selected the dimensions, the table will be inserted into your slide.

Inserting Charts:

• Click on the slide where you want to insert the chart.

• Go to the "Insert" tab on the PowerPoint ribbon.
• Click on the "Chart" button in the Illustrations group.
• Choose the type of chart you want to insert from the options available (e.g., Column, Bar,
Pie, Line, etc.).
• Click "OK" to insert the chart, and an Excel spreadsheet will open where you can enter your
data. Alternatively, you can paste your data into the Excel sheet.
• Close the Excel sheet when you're done, and the chart will appear on your slide.

Inserting Screenshots:

• Click on the slide where you want to insert the screenshot.

• Go to the "Insert" tab on the PowerPoint ribbon.
• Click on the "Screenshot" button in the Images group.
• Choose one of the available windows or select "Screen Clipping" to capture a specific portion
of your screen.
• If you choose "Screen Clipping," PowerPoint will minimize, and you can click and drag to
select the area of the screen you want to capture.
• Release the mouse button, and the selected portion will be inserted as a screenshot on your
slide.
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 5 of 9
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra

Procedure of applying animations to slides

Applying animations to slides in Microsoft PowerPoint can enhance the visual appeal of your
presentations and make key points stand out. Here's a step-by-step procedure for applying
animations to slides:

Open PowerPoint and Select a Slide:

• Launch Microsoft PowerPoint and open the presentation where you want to apply
animations.
• Select the slide to which you want to add animations by clicking on it in the slide pane on the
left side of the screen.

Access the Animation Pane:

• Go to the "Animations" tab on the PowerPoint ribbon at the top of the screen.
• In the Animations tab, you'll find various options for adding animations to your slides.
• Click on the "Animation Pane" button in the Advanced Animation group. This will open the
Animation Pane on the right side of the screen, showing a list of animations applied to the
current slide.

Choose an Animation Effect:

• With the slide selected, navigate to the Animations tab on the PowerPoint ribbon.
• In the Animation group, you'll find a variety of animation effects to choose from, such as
Entrance, Emphasis, Exit, and Motion Path animations.
• Click on the "Add Animation" dropdown menu to see the available animation effects.
• Select the animation effect you want to apply to the slide. You can hover over each effect to
see a preview of how it will look on the slide.

Adjust Animation Settings:

• After applying an animation effect, you can customize its settings to control the timing,
duration, and other properties.
• Click on the "Effect Options" button in the Animation group to access additional settings for
the selected animation effect.
• In the Effect Options menu, you can adjust parameters such as direction, speed, delay, and
sound associated with the animation effect.

Preview and Fine-Tune Animations:

• To preview the animations applied to the slide, click on the "Preview" button in the
Animations tab.
• PowerPoint will play a preview of the slide with the applied animations, allowing you to see
how they look and make any necessary adjustments.
• You can also reorder animations in the Animation Pane by clicking and dragging them up or
down in the list.

Apply Animations to Other Objects:

Save and Play the Presentation:

• Once you've finished applying animations to your slides, save the presentation by clicking on
the "Save" button in the Quick Access Toolbar.
• To play the presentation and see the animations in action, click on the "Slide Show" button
in the bottom-right corner of the PowerPoint window.

Procedure of applying transitions to slides

Applying transitions to slides in Microsoft PowerPoint can add visual interest and enhance the flow
between slides during a presentation. Transitions control how slides appear and disappear during the
slideshow. Here's a step-by-step procedure for applying transitions to slides:

Open PowerPoint and Select a Slide:

• Launch Microsoft PowerPoint and open the presentation where you want to apply
transitions.
• Select the slide to which you want to add a transition by clicking on it in the slide pane on
the left side of the screen.

Access the Transitions Tab:

• Go to the "Transitions" tab on the PowerPoint ribbon at the top of the screen.
• In the Transitions tab, you'll find various options for adding transitions to your slides.

Choose a Transition Effect:

• With the slide selected, navigate to the Transitions tab on the PowerPoint ribbon.
• In the Transition to This Slide group, you'll see a variety of transition effects to choose from.
• Click on the dropdown menu next to the "Effect Options" button to see the available
transition effects.

Apply the Transition:

• Select the transition effect you want to apply to the slide by clicking on it.
• PowerPoint will apply the selected transition effect to the slide, and you'll see a preview of
how it looks in the slide pane.

Adjust Transition Settings:

• After applying a transition effect, you can customize its settings to control the timing and
duration.
• Click on the "Effect Options" button in the Transition to This Slide group to access additional
settings for the selected transition effect.

Apply Transitions to Other Slides:

• Repeat the process to apply transitions to other slides in the presentation.

• Select the slide where you want to add a transition, choose a transition effect from the
Transitions tab, and adjust its settings as needed.

Preview the Transitions:

• To preview the transitions applied to the slides, click on the "Preview" button in the
Transitions tab.
• PowerPoint will play a preview of the slideshow with the applied transitions, allowing you to
see how they look and make any necessary adjustments.

Save and Play the Presentation:

• Once you've finished applying transitions to your slides, save the presentation by clicking on
the "Save" button in the Quick Access Toolbar.
• To play the presentation and see the transitions in action, click on the "Slide Show" button in
the bottom-right corner of the PowerPoint window.

Customizing themes and animations

Customizing animations and transitions in Microsoft PowerPoint allows you to tailor the visual effects
to match the tone and style of your presentation. Here are methods to customize animations and
transitions:

Customizing Animations:

Adjusting Animation Timing:

• Select the animated object on the slide.

• Go to the "Animations" tab on the PowerPoint ribbon.
• In the Animation group, click on the "Animation Pane" button to open the Animation Pane.
• In the Animation Pane, select the animation effect you want to customize.
• Right-click on the selected animation effect and choose "Effect Options."
• In the Effect Options dialog box, adjust settings such as duration, delay, start options, and
direction to customize the timing of the animation.

Fine-Tuning Animation Properties:

• With the animated object selected, click on the "Animation Pane" button to open the
Animation Pane.
• In the Animation Pane, select the animation effect you want to customize.
• Right-click on the selected animation effect and choose "Effect Options."

Adding Animation Effects to Text:

• Select the text box or text within a shape that you want to animate.
• Go to the "Animations" tab on the PowerPoint ribbon.
• In the Animation group, click on the "Add Animation" dropdown menu.
• Choose an animation effect from the list, such as Entrance, Emphasis, or Exit effects.
• Adjust the animation settings in the Animation Pane to customize the timing and properties
of the text animation.

Customizing Transitions:

Choosing Transition Effects:

• Go to the "Transitions" tab on the PowerPoint ribbon.

• In the Transition to This Slide group, click on the dropdown menu next to the "Effect
Options" button.
• Choose a transition effect from the available options, such as Fade, Push, Wipe, or Morph.

Adjusting Transition Duration:

• With the slide selected, navigate to the Transitions tab on the PowerPoint ribbon.
• In the Transition to This Slide group, click on the "Duration" dropdown menu.
• Choose a duration for the transition effect, or select "Automatically After" to specify a time
interval for the transition to occur automatically.

Adding Sound to Transitions:

• With the slide selected, navigate to the Transitions tab on the PowerPoint ribbon.
• In the Timing group, check the box next to "Sound" to enable sound for the transition.
• Click on the dropdown menu next to "Sound" to choose a sound effect from the available
options.

Applying Transition Effects to Multiple Slides:

• Select the slides to which you want to apply the same transition effect.
• Go to the "Transitions" tab on the PowerPoint ribbon.
• In the Timing group, choose a transition effect from the Transition to This Slide dropdown
menu.
• The selected transition effect will be applied to all the selected slides.

Previewing Customizations:

• To preview the customized animations and transitions, click on the "Preview" button in the
Animations or Transitions tab.
• PowerPoint will play a preview of the slideshow with the applied customizations, allowing
you to see how they look and make any necessary adjustments.

Unit XIV - Understanding MS-Out look

Introduction to MS Outlook

Outlook is a widely used personal information manager and email client developed by
Microsoft. It is part of the Microsoft Office suite of productivity software and is available for
various platforms, including Windows, macOS, iOS, and Android. Outlook provides a range of
features that help users manage their emails, calendars, contacts, and tasks efficiently.
Below are detailed explanations of its key components and functionalities:

Email Management:
Multiple Account Support: Outlook allows users to configure and manage multiple email
accounts within the same interface. This includes support for Microsoft 365, Outlook.com,
Exchange, Gmail, Yahoo! Mail, and other POP/IMAP email accounts.
Email Organization: Users can organize their emails using folders, labels, and categories.
Outlook supports features like conversation view, which groups related emails together,
making it easier to follow email threads.
Search and Filters: Powerful search capabilities enable users to quickly find specific emails or
attachments. Filters and rules can be set up to automatically categorize or move emails
based on certain criteria.
Focused Inbox: Outlook's Focused Inbox feature intelligently separates important emails
from less critical ones, helping users focus on essential communications.

Calendar Management:
Appointment Scheduling: Outlook's calendar feature allows users to schedule appointments,
meetings, and events. It supports features like recurring events, reminders, and different
views (day, week, month).
Integration: The calendar seamlessly integrates with email, making it easy to schedule
meetings directly from an email. It also supports integration with third-party calendar
services.
Sharing: Users can share their calendars with colleagues or friends, allowing them to view
availability and schedule events.

Task Management:
To-Do Lists: Outlook includes a task management feature where users can create to-do lists,
set due dates, and mark tasks as complete.
Integration with Calendar: Tasks can be integrated with the calendar, allowing users to see
their schedule and tasks in one place.
Security and Productivity Features:
Focused on Security: Outlook includes features like encryption, anti-phishing measures, and
built-in protection against malicious attachments to enhance email security.
Integration with Microsoft 365: For users with Microsoft 365 subscriptions, Outlook
integrates with other Microsoft Office applications, enhancing collaboration and
productivity.
Customization: Users can customize the Outlook interface, including themes, layout, and
quick access toolbar, to suit their preferences.

Mobile Accessibility:
Mobile Apps: Outlook has dedicated mobile apps for iOS and Android devices, providing a
consistent experience across different platforms.
Syncing: Changes made on one device, such as reading an email or scheduling an event, are
synced across all devices connected to the same account.

Interface of MS Outlook

Ribbon: The Ribbon is a key feature in the Outlook interface. It contains tabs, each with
specific groups of related commands. The tabs include Home, Send/Receive, Folder, View,
and others, depending on the context.

Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 2 of 9
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra
Navigation Pane: The Navigation Pane is located on the left side of the Outlook window. It
includes shortcuts to different modules such as Mail, Calendar, Contacts, and Tasks. Users
can switch between these modules to access different features.
Folder Pane: This pane is typically on the left side of the window and displays a hierarchical
view of mail folders. It allows users to navigate and organize their email folders.
Reading Pane: The Reading Pane is located to the right of the message list and displays the
content of the selected email. Users can choose to have the Reading Pane at the bottom or
right side, or they can turn it off if they prefer.
To-Do Bar: The To-Do Bar is a small panel on the right side of the window that provides a
quick view of upcoming appointments, tasks, and flagged emails. It helps users stay
organized and focused on important activities.
Search Bar: The Search Bar is prominently displayed at the top of the Outlook window. Users
can quickly search for emails, contacts, and other items by entering keywords or specific
criteria.
Quick Access Toolbar: This is a customizable toolbar located above the Ribbon. Users can
add frequently used commands to the Quick Access Toolbar for easy access.
Mail Toolbar: When in the Mail module, a toolbar at the top provides quick access to
common email-related actions such as composing a new email, replying, forwarding, and
deleting.
Calendar View: In the Calendar module, users can view their schedule by day, week, or
month. The Calendar View allows for scheduling and managing appointments and events.
Contact Cards: In the Contacts module, contact cards display detailed information about
individual contacts. These cards can include email addresses, phone numbers, and other
relevant details.
Task List: In the Tasks module, users can view and manage their to-do list. Tasks can be
organized, prioritized, and marked as complete.
Status Bar: The Status Bar is located at the bottom of the Outlook window and provides
information about the current status, such as the number of items in the current folder and
the status of email synchronization.

Email Servers

Email servers play a crucial role in facilitating the exchange of electronic messages between
users within an organization or across the internet. Microsoft Outlook, as an email client,
relies on email servers to send, receive, and manage emails efficiently. Here's an explanation
of email servers focusing on MS Outlook:

• Email servers store, manage, and deliver emails between users. They use various
protocols like SMTP (Simple Mail Transfer Protocol), IMAP (Internet Message Access
Protocol), and POP3 (Post Office Protocol) to handle email communications.
Types of Email Servers:

• Outbound Servers (SMTP): These servers handle outgoing emails. When you
compose and send an email in Outlook, it is sent to the outbound server, which then
delivers it to the recipient's email server.
• Inbound Servers (IMAP/POP3): These servers handle incoming emails. They receive
emails sent to your email address, store them temporarily, and then Outlook
retrieves them from the server to display in your inbox.
• Exchange Servers: In a corporate environment, Microsoft Exchange Server is
commonly used. It provides additional functionalities like calendar sharing, contacts
management, and collaboration features, integrated seamlessly with Outlook.
Configuration in Outlook:

• To set up Outlook to work with an email server, you need to configure the account
settings.
• You provide information such as the email address, username, password, incoming
server (IMAP/POP3), outgoing server (SMTP), and ports for communication.
• Outlook uses this information to connect to the email server, authenticate the user,
and synchronize emails, contacts, calendars, and other data.
Security and Authentication:

• Email servers implement security measures to protect against unauthorized access

and ensure the confidentiality and integrity of email communications.
• Authentication mechanisms like SSL/TLS encryption, SPF (Sender Policy Framework),
DKIM (DomainKeys Identified Mail), and DMARC (Domain-based Message
Authentication, Reporting, and Conformance) are commonly used to secure email
transactions.
Functionality in Outlook:

• Outlook acts as an interface between users and email servers, providing features for
composing, reading, organizing, and managing emails.
• It synchronizes emails, contacts, calendars, tasks, and notes between the email
server and the user's local device, ensuring consistency across multiple devices.
Administration and Maintenance:

• Email servers require regular administration and maintenance to ensure optimal

performance, reliability, and security.
• Tasks such as user account management, mailbox management, spam filtering, virus
scanning, backup, and disaster recovery are essential for maintaining the integrity
and availability of email services.

Process for creating and managing contacts and contact groups

Creating and managing contacts and contact groups (distribution lists) in Microsoft Outlook
allows users to efficiently organize and communicate with their contacts. Here's a step-by-
step process for creating and managing contacts and contact groups in MS Outlook:
Creating Contacts:
Open Outlook and Navigate to Contacts:

• Launch Microsoft Outlook and go to the "Contacts" section by clicking on the

"People" icon in the navigation bar at the bottom-left corner of the Outlook window.
Add a New Contact:

• In the Contacts view, click on the "New Contact" button in the toolbar at the top of
the window.
• A new contact form will appear, allowing you to enter details about the contact.
Enter Contact Information:

• Fill in the relevant information for the contact, including their name, email address,
phone number, company, job title, address, and any other details you want to
include.
• You can also add a photo for the contact by clicking on the camera icon and selecting
a picture from your computer or device.
Save the Contact:

• Once you've entered all the necessary information, click on the "Save & Close"
button in the toolbar to save the contact.
• The contact will be added to your Outlook contacts list and will be available for
future use.
Managing Contacts:
View and Edit Contacts:

• To view and edit existing contacts, navigate to the Contacts section in Outlook and
click on the contact you want to modify.
• You can edit the contact's information directly in the contact card that appears, and
changes will be saved automatically.
Organize Contacts into Folders:

• You can organize your contacts into folders or categories to make them easier to
manage.
• Right-click on the Contacts folder in the navigation pane and select "New Folder" to
create a new folder.
• Drag and drop contacts into the desired folder to organize them accordingly.
Search and Filter Contacts:

• Use the search bar at the top of the Contacts view to search for specific contacts by
name, email address, or other criteria.
• You can also apply filters to narrow down the list of contacts based on specific
attributes such as company, location, or job title.
Creating Contact Groups (Distribution Lists):
Open Outlook and Navigate to Contacts:

• Go to the "Contacts" section in Outlook by clicking on the "People" icon in the

navigation bar.
Create a New Contact Group:

• In the Contacts view, click on the "New Contact Group" button in the toolbar at the
top of the window.
• A new contact group form will appear, allowing you to enter details about the group.
Add Contacts to the Group:

• Click on the "Add Members" button in the toolbar of the contact group form.
• Select the contacts you want to add to the group from your contacts list and click
"Members" to add them to the group.
• You can also add contacts from your address book or create new contacts directly
from the group form.
Save the Contact Group:

• Once you've added all the desired contacts to the group, click on the "Save & Close"
button in the toolbar to save the contact group.
• The contact group will be added to your contacts list and can be used to send emails
to multiple recipients simultaneously.
Managing Contact Groups:

• To view and edit existing contact groups, navigate to the Contacts section in Outlook
and click on the contact group you want to modify.
• You can add or remove contacts from the group, change the group's name or
description, and make other modifications as needed.
Send Emails to Contact Groups:

• To send an email to a contact group, compose a new email message in Outlook.

• In the "To" field of the email, type the name of the contact group, and Outlook will
automatically suggest the group from your contacts list.
• Select the group from the suggestions, and all the contacts in the group will be added
to the recipient list of the email.

Unit XV: MS Office on mobile

Microsoft Office on mobile devices brings the power and functionality of the popular
productivity suite to smartphones and tablets, enabling users to work on their documents,
spreadsheets, presentations, and notes while on the go. Here's an explanation of the use
and importance of MS Office on mobile:
Use of MS Office on Mobile:
Document Creation and Editing:

• With MS Office apps on mobile devices like Word, Excel, and PowerPoint, users can
create, edit, and format documents, spreadsheets, and presentations directly from
their smartphones or tablets.
• This enables users to work on their projects, reports, and presentations even when
they're away from their desktop computers.
Collaboration and Sharing:

• MS Office mobile apps support real-time collaboration features, allowing multiple

users to work on the same document simultaneously.
• Users can share documents with colleagues or collaborators via email, cloud storage
services like OneDrive or SharePoint, or direct sharing options within the apps.
Access to Cloud Storage:

• MS Office mobile apps seamlessly integrate with Microsoft's cloud storage service,
OneDrive, as well as other cloud storage providers like Google Drive and Dropbox.
• This enables users to access their documents stored in the cloud, edit them on their
mobile devices, and synchronize changes across all their devices.
Mobile-Friendly Interface:

• MS Office mobile apps are optimized for touchscreens and smaller screens, providing
a user-friendly interface that makes it easy to navigate, edit, and format documents
on mobile devices.
• Features like ribbon menus, context-sensitive toolbars, and touch gestures are
tailored for mobile usage, ensuring a smooth and intuitive experience.
Productivity On the Go:

• MS Office on mobile devices empowers users to be productive even when they're

away from their desks or office computers.
• Whether it's responding to emails, reviewing documents, updating spreadsheets, or
giving presentations, users can stay productive and efficient while on the move.
Importance of MS Office on Mobile:
Flexibility and Mobility:

• MS Office on mobile devices offers users the flexibility to work from anywhere,
whether they're traveling, attending meetings, or working remotely.
• Users can access, edit, and share documents on their smartphones or tablets,
eliminating the need to carry laptops or desktop computers.
Enhanced Collaboration:

• By enabling real-time collaboration and seamless sharing of documents, MS Office on

mobile devices fosters teamwork and collaboration among users, regardless of their
location or device.
• Collaborators can review, comment, and contribute to documents in real-time,
improving productivity and efficiency.
Integration with Desktop Office:

• MS Office on mobile devices seamlessly integrates with the desktop version of

Microsoft Office, allowing users to start a task on one device and continue it on
another.
• Documents created or edited on mobile devices are automatically synchronized with
the user's desktop computer via cloud storage, ensuring continuity and consistency
across devices.
Accessibility for All Users:
Prepared By: Chanakya Institute of IT & Management (An Official Service Provider of Vocational and
Co-Curricular Course)
https://www.nepvc.org.in
YouTube Channel: https://www.youtube.com/@Nepvc2020
Page 8 of 9
Notes: Vocational Course
Semester 1 & 3: Basic Computer Skills
Specially prepared for: Dr. Bhimrao Ambedkar University, Agra

• MS Office on mobile devices caters to a wide range of users, including professionals,

students, educators, and individuals, providing them with access to essential
productivity tools wherever they are.
• The availability of MS Office on mobile devices ensures that users can stay
connected, productive, and organized, regardless of their device or operating system.

ADCA
No ratings yet
ADCA
58 pages
Untitled Document
No ratings yet
Untitled Document
24 pages
9505 Outline
No ratings yet
9505 Outline
48 pages
Computer Fundamentals Application PRELIM Module
100% (1)
Computer Fundamentals Application PRELIM Module
24 pages
11 IP Study Material
No ratings yet
11 IP Study Material
120 pages
Lecture 1-Basic Concepts
No ratings yet
Lecture 1-Basic Concepts
32 pages
Introduction To Computers
No ratings yet
Introduction To Computers
4 pages
Computer Basics and Components Guide
No ratings yet
Computer Basics and Components Guide
5 pages
Chapter 1 CS XI
No ratings yet
Chapter 1 CS XI
29 pages
ICT Notes-1
No ratings yet
ICT Notes-1
42 pages
25cse0102 L1
No ratings yet
25cse0102 L1
18 pages
Chapter-1 Short Notes
No ratings yet
Chapter-1 Short Notes
11 pages
Computer Fundamentals
No ratings yet
Computer Fundamentals
98 pages
HI M2 Introduction To Computer Concepts
No ratings yet
HI M2 Introduction To Computer Concepts
12 pages
PC Basics for Beginners
No ratings yet
PC Basics for Beginners
121 pages
Computer
No ratings yet
Computer
35 pages
Computer Fundamentals Overview
No ratings yet
Computer Fundamentals Overview
6 pages
What Are Computers ?: Calculates
No ratings yet
What Are Computers ?: Calculates
6 pages
Epfo Computer
No ratings yet
Epfo Computer
51 pages
Computer Lecture
No ratings yet
Computer Lecture
37 pages
Computer Basic Notes English
No ratings yet
Computer Basic Notes English
7 pages
Computer Fundamentals for Beginners
No ratings yet
Computer Fundamentals for Beginners
32 pages
Unit 1
No ratings yet
Unit 1
102 pages
New Introduction To Computer
No ratings yet
New Introduction To Computer
111 pages
Computer Book
No ratings yet
Computer Book
164 pages
Lecture 1
No ratings yet
Lecture 1
5 pages
Unit1 Computer
No ratings yet
Unit1 Computer
22 pages
Computer Studies Form One Notes..
No ratings yet
Computer Studies Form One Notes..
18 pages
Basic of Compute
No ratings yet
Basic of Compute
15 pages
Basic Com
No ratings yet
Basic Com
134 pages
Lab Chapter 1
No ratings yet
Lab Chapter 1
85 pages
Presentation 1
No ratings yet
Presentation 1
63 pages
Desorrrrr
No ratings yet
Desorrrrr
27 pages
Computer 1: (Introduction To Computer Concepts and Software)
No ratings yet
Computer 1: (Introduction To Computer Concepts and Software)
32 pages
Module 1 - Computer Fundamentals
100% (1)
Module 1 - Computer Fundamentals
54 pages
Fundamentals of Information Technology
No ratings yet
Fundamentals of Information Technology
85 pages
Online Note Pdfview - PHP
No ratings yet
Online Note Pdfview - PHP
7 pages
Fca Notes
No ratings yet
Fca Notes
12 pages
Ict Comp Funda Excel N
No ratings yet
Ict Comp Funda Excel N
15 pages
Lecture 2
No ratings yet
Lecture 2
40 pages
Lecture 1
No ratings yet
Lecture 1
59 pages
PDC 11 Lecture 1
No ratings yet
PDC 11 Lecture 1
54 pages
Basic Computer Introduction 1
No ratings yet
Basic Computer Introduction 1
47 pages
Notes On Computer Sed, ST 2024
No ratings yet
Notes On Computer Sed, ST 2024
28 pages
Intro Week2
No ratings yet
Intro Week2
45 pages
Introduction To Computers: Objectives
No ratings yet
Introduction To Computers: Objectives
10 pages
Computer Security Fundamentals Guide
No ratings yet
Computer Security Fundamentals Guide
46 pages
Introduction to Computer Systems
No ratings yet
Introduction to Computer Systems
156 pages
DRM1201 Chapter1
No ratings yet
DRM1201 Chapter1
32 pages
COS 101 Course Lecture Note - Ext Dept.
No ratings yet
COS 101 Course Lecture Note - Ext Dept.
14 pages
Fit Unit-1
No ratings yet
Fit Unit-1
18 pages
Introduction to Computer Systems
No ratings yet
Introduction to Computer Systems
51 pages
Knowledge of Computer For FAA by Behjat Riyaz
No ratings yet
Knowledge of Computer For FAA by Behjat Riyaz
303 pages
Fundamentals of Computing
No ratings yet
Fundamentals of Computing
8 pages
What Is Computer: Computer Is An, Designed To Solve and Problems With - The Word Computer Derived From A Latin Word
No ratings yet
What Is Computer: Computer Is An, Designed To Solve and Problems With - The Word Computer Derived From A Latin Word
63 pages
Computer Concepts and Hardware
100% (1)
Computer Concepts and Hardware
68 pages
Computing Basics for Beginners
No ratings yet
Computing Basics for Beginners
65 pages
Unit 1 Computer System 1
No ratings yet
Unit 1 Computer System 1
61 pages
1 Lec1 Basic Concepts
No ratings yet
1 Lec1 Basic Concepts
32 pages
Food Security
No ratings yet
Food Security
6 pages
Holiday Homework XI ENGLISH 2025
No ratings yet
Holiday Homework XI ENGLISH 2025
2 pages
Imarticus Learning - Campus Ambassador JD
No ratings yet
Imarticus Learning - Campus Ambassador JD
3 pages
Land Reforms
No ratings yet
Land Reforms
4 pages
Events at A Glance Sahaitya Utsav 2025
No ratings yet
Events at A Glance Sahaitya Utsav 2025
1 page
Notes English Physical-Education-Yoga-Semester-IV
50% (2)
Notes English Physical-Education-Yoga-Semester-IV
71 pages
History 4th Sem Sanjay Notes For Agra and Other State Universities of UP
No ratings yet
History 4th Sem Sanjay Notes For Agra and Other State Universities of UP
34 pages
B.SC 4th Sem Chemistry MCQ Question Paper
No ratings yet
B.SC 4th Sem Chemistry MCQ Question Paper
21 pages
BD106 (D) HINDI TEACHING For BEd. Useful For R UP State Universities .
No ratings yet
BD106 (D) HINDI TEACHING For BEd. Useful For R UP State Universities .
31 pages
2nd Sem Physical Education Minor Omr
No ratings yet
2nd Sem Physical Education Minor Omr
12 pages
BD106 (C) Science - 3 (Mathematics Teaching)
No ratings yet
BD106 (C) Science - 3 (Mathematics Teaching)
31 pages
BD106 (F) (Social Science - 2) (Economics & Geography)
No ratings yet
BD106 (F) (Social Science - 2) (Economics & Geography)
30 pages
Bd106e (Social Science Teaching 1) History & Civics
No ratings yet
Bd106e (Social Science Teaching 1) History & Civics
38 pages
BD106 (D) Sanskrit Teaching
No ratings yet
BD106 (D) Sanskrit Teaching
31 pages
BD106 (H) (Home Science)
No ratings yet
BD106 (H) (Home Science)
18 pages
BD106 (D) (English Teaching)
No ratings yet
BD106 (D) (English Teaching)
36 pages
Radio Astronomy Receivers - Tiuri - 1964
No ratings yet
Radio Astronomy Receivers - Tiuri - 1964
9 pages
Macro Photography Essentials Guide
No ratings yet
Macro Photography Essentials Guide
35 pages
Gec Time Trials @kisj 9-7-2024
No ratings yet
Gec Time Trials @kisj 9-7-2024
6 pages
Cant Help Falling in Love A Cappella
No ratings yet
Cant Help Falling in Love A Cappella
3 pages
Seminar Report Light Emitting Polymer
No ratings yet
Seminar Report Light Emitting Polymer
39 pages
Rab Penyewaan Alat Kamera Dan Lighting: Camera Equipment
No ratings yet
Rab Penyewaan Alat Kamera Dan Lighting: Camera Equipment
2 pages
The Katalyst (May 2015)
No ratings yet
The Katalyst (May 2015)
34 pages
MWOS Best Odds for Upcoming Matches
No ratings yet
MWOS Best Odds for Upcoming Matches
14 pages
AeriaGames Profile March2011
No ratings yet
AeriaGames Profile March2011
10 pages
Veg Seekh Kebab Recipe & Ingredients
No ratings yet
Veg Seekh Kebab Recipe & Ingredients
30 pages
Clasament Semimaraton
No ratings yet
Clasament Semimaraton
12 pages
Rudra It Solutions Stock PDF
No ratings yet
Rudra It Solutions Stock PDF
4 pages
Fathers in English Literature
No ratings yet
Fathers in English Literature
3 pages
Dhgate Links & Site Seller Info
No ratings yet
Dhgate Links & Site Seller Info
13 pages
Digital Video Processing Fundamentals
No ratings yet
Digital Video Processing Fundamentals
261 pages
Hagrid Compressed
94% (18)
Hagrid Compressed
37 pages
Data Instagram List
No ratings yet
Data Instagram List
18 pages
Manwha, Manhua, Manga List. (Finished or Unfinished)
No ratings yet
Manwha, Manhua, Manga List. (Finished or Unfinished)
11 pages
Service Bulletin Copier: Subject
No ratings yet
Service Bulletin Copier: Subject
9 pages
Aval Inglês - Biografia Machado de Assis
100% (1)
Aval Inglês - Biografia Machado de Assis
1 page
Fillable 3.5 Character Sheet
No ratings yet
Fillable 3.5 Character Sheet
3 pages
Sony Marketing Mix and Swot Analysis
100% (5)
Sony Marketing Mix and Swot Analysis
15 pages
Story of My Life A Cappella Score
No ratings yet
Story of My Life A Cappella Score
3 pages
Axis Max Life: Customer Excellence
No ratings yet
Axis Max Life: Customer Excellence
3 pages
Thanks For Purchasing! If You Have Any Problems or Questions Please Let Me Know. If You Have Time To Leave A Review It Would Be Greatly Appreciated
No ratings yet
Thanks For Purchasing! If You Have Any Problems or Questions Please Let Me Know. If You Have Time To Leave A Review It Would Be Greatly Appreciated
6 pages
IPC HDBW1230R ZS S5 - Datasheet - 20210705
No ratings yet
IPC HDBW1230R ZS S5 - Datasheet - 20210705
3 pages
Homework Rap Song
100% (1)
Homework Rap Song
6 pages
MIS Slides Class 8
No ratings yet
MIS Slides Class 8
47 pages
Antonio Lauro - Fantasia For Guitar and Harpsichord
No ratings yet
Antonio Lauro - Fantasia For Guitar and Harpsichord
22 pages
Free Slouch Hat Crochet Patterns
No ratings yet
Free Slouch Hat Crochet Patterns
7 pages