UNIT-I: Introduction to Computers
Introduction, Characteristics of Computers, Block diagram of computer. Types of computers and features, Mini
Computers, Micro Computers, Mainframe Computers, Super Computers.
UNIT-II: Algorithm and Flowcharts
Algorithm: Definition, Characteristics, Advantages and disadvantages, Examples. Flowchart: Definition,
Define symbols of flowchart, Advantages and disadvantages, Examples.
UNIT-III: Operating System and Services in O.S.
DOS History, Files and Directories, Internal and External Commands, Batch Files, Types of Operative System.
UNIT-IV: Windows Operating Environment
Features of MS – Windows, Control Panel, Taskbar, Desktop, Windows Application, Icons, Windows Accessories,
Notepad, Paintbrush.
UNIT-V: Editors and Word Processors
Basic Concepts, Examples: MS-Word, Introduction to desktop publishing.
UNIT-VI: Spreadsheets and Database Packages
Purpose, usage, command, MS-Excel, Creation of files in MS-Access, Switching between applications,
MS-PowerPoint.
UNIT-I: Introduction to Computers
1. Introduction
A computer is an electronic device that accepts input, processes it, and delivers the output. It can
store and retrieve data efficiently.
2. Characteristics of Computers
- Speed: Processes data quickly.
- Accuracy: Performs operations without errors.
- Automation: Can work automatically without manual intervention.
- Storage: Can store large amounts of data.
- Versatility: Can perform a wide range of tasks.
3. Block Diagram of a Computer
+------------+ +------------+ +------------+
| Input Unit | ---> | CPU | ---> | Output Unit|
+------------+ +------------+ +------------+
|
v
+-------------+
| Memory Unit |
+-------------+
4. Types of Computers and Features
- Micro Computers: Used at home or for personal tasks.
- Mini Computers: Mid-sized computers for small organizations.
- Mainframe Computers: Used in large organizations for bulk data processing.
- Super Computers: Highly powerful computers used for scientific simulations and
research.
5. Types of Programming Languages
- Machine Language: Binary language directly executed by CPU.
- Assembly Language: Uses mnemonics and requires assembler.
- High-Level Language: Like Python, C++, Java – user-friendly and portable.
Example:
Machine: 10110010
Assembly: MOV A, B
High-Level: sum = a + b;
6. Data Organization
- Bit: Smallest unit (0 or 1)
- Byte: Group of 8 bits
- Field: Group of characters
- Record: Collection of related fields
- File: Collection of records
- Directory: Folder that contains files
7. Types of Memory
- Primary Memory: RAM (temporary), ROM (permanent)
- Secondary Memory: HDD, SSD, CD/DVD, USB drives
- ROM Types: PROM (Programmable), EPROM (Erasable)
8. Secondary Storage Devices
- FD: Floppy Disk – obsolete now
- CD: Compact Disc – optical storage
- HD: Hard Disk – magnetic storage
- Pen Drive: USB flash storage
9. I/O Devices
- Scanners: Convert paper documents into digital form
- Plotters: Print vector graphics
- LCD: Liquid Crystal Display screens
- Plasma Display: Use plasma gas to show images (older tech)
10. Number Systems
Computers understand binary system (0 and 1), but humans also use octal, decimal, and hexadecimal.
- Binary (Base-2): Uses 0, 1
- Octal (Base-8): Uses 0-7
- Decimal (Base-10): Uses 0-9
- Hexadecimal (Base-16): Uses 0-9 and A-F
Examples:
Binary of 5 = 101
Octal of 9 = 11
Decimal of 101 = 5
Hexadecimal of 15 = F
Binary Operations:
Addition: 101 + 001 = 110
Subtraction: 101 - 001 = 100
Multiplication: 101 x 10 = 1010
UNIT-II: Algorithm and Flowcharts
1. Algorithm
Definition: An algorithm is a set of well-defined, logical steps designed to perform a
task or solve a problem. It forms the foundation of programming and computational logic.
Key Characteristics of an Algorithm:
- Finiteness: An algorithm must always terminate after a finite number of steps.
- Definiteness: Each step must be clear and unambiguous.
- Input: Zero or more inputs are supplied externally.
- Output: At least one output is produced.
- Effectiveness: Each step must be simple enough to be performed.
Advantages:
- Helps understand the logic before coding.
- Easy to write and debug.
- Language-independent representation.
Disadvantages:
- No standardized format.
- Can become complex for large problems.
Example 1: Largest of Two Numbers
Algorithm: Find the largest of two numbers A and B
Step 1: Start
Step 2: Read A and B
Step 3: If A > B then
Print "A is greater"
Else
Print "B is greater"
Step 4: Stop
Example 2: Factorial of a Number
Algorithm: Calculate the factorial of a number N
Step 1: Start
Step 2: Read N
Step 3: Set fact = 1
Step 4: Repeat from i = 1 to N
fact = fact * i
Step 5: Print fact
Step 6: Stop
2. Flowchart
Definition: A flowchart is a visual representation of the sequence of steps and
decisions needed to perform a process using standardized symbols.
Standard Flowchart Symbols:
[Oval] - Start or End
[Parallelogram] - Input or Output
[Rectangle] - Process or Calculation
[Diamond] - Decision (Yes/No)
[Arrow] - Flow of control
Advantages:
- Easy to visualize and communicate logic.
- Highlights logical flow and decision-making paths.
- Helps detect errors before coding.
Disadvantages:
- Can become complex for detailed logic.
- Difficult to modify once completed.
Example Flowchart: Find the Largest of Two Numbers
+---------+
| Start |
+----+----+
|
v
+---------------------+
| Input A and B |
+---------------------+
|
v
+-----------------------------+
| Is A greater than B? |
+----------+------------------+
|
Yes / \ No
/ \
v v
+----------------+ +----------------+
| Print "A > B" | | Print "B > A" |
+----------------+ +----------------+
\ /
v v
+--------+
| Stop |
+--------+
Example Flowchart: Factorial of a Number
+--------+
| Start |
+---+----+
|
v
+----------------+
| Read N |
+----------------+
|
v
+----------------+
| Set F = 1, i=1 |
+----------------+
|
v
+-------------------------+
| Is i <= N? |
+----------+--------------+
|
Yes / \ No
/ \
v v
+---------------------+ +--------------+
| F = F * i, i = i +1 | | Print F |
+---------------------+ +--------------+
\ |
\_______________/
|
v
+-------+
| Stop |
+-------+
UNIT-III: Operating System and Services in OS
1. Introduction to Operating System
An Operating System (OS) is system software that acts as an intermediary between
computer hardware and software. It manages hardware resources and provides essential services for
computer programs. Without an OS, users wouldn't be able to interact with the computer or run
applications efficiently.
Key Functions of an OS:
- Process Management: The OS manages processes running on the computer, allocating
resources to processes and scheduling their execution. For example, the OS determines which process
gets the CPU at any given time.
- Memory Management: It allocates and deallocates memory to processes as needed. The
OS ensures that each program has enough memory to run, and prevents processes from interfering with
each other.
- File and Disk Management: It handles the organization, storage, retrieval, and
management of files on the disk. It keeps track of files, directories, and permissions, ensuring
secure and efficient access to stored data.
- Device Management: The OS controls hardware devices like printers, scanners, and
disk drives. It provides device drivers that allow software applications to interact with hardware
devices.
- User Interface and Security: The OS provides an interface (like GUI or
command-line) for the user to interact with the computer. It also handles user authentication and
enforces security policies to protect data and system integrity.
2. DOS (Disk Operating System)
History of DOS:
MS-DOS (Microsoft Disk Operating System) was the first widely used operating system for
IBM PCs in the 1980s. It is a single-user, single-tasking operating system. Later, Windows began to
dominate, but MS-DOS was foundational in the development of personal computing.
Files and Directories in DOS:
In DOS, files are stored in directories. A directory can contain both files and other directories
(subdirectories), which are used to organize the system’s data. A file has a name and an extension
(e.g., report.txt
), which indicates its type.
Example Directory Structure:
C:\
├── Documents\
│ └── report.txt
├── Programs\
│ └── setup.exe
└── System\
└── autoexec.bat
Internal Commands in DOS:
Internal commands are built into the command interpreter (COMMAND.COM) and do not require separate
program files. They execute quickly and are typically used for basic system functions.
DIR
- Displays a list of files and subdirectories in the current directory.
CLS
- Clears the screen.
DEL
- Deletes a specified file (e.g., DEL report.txt
).
COPY
- Copies files from one location to another (e.g.,
COPY report.txt D:\Backup
).
External Commands in DOS:
External commands are separate program files that reside on disk. They are invoked from the command line
and are usually used for more advanced operations.
FORMAT
- Used to format a disk (e.g., FORMAT A:
).
DISKCOPY
- Copies all files from one disk to another.
XCOPY
- Copies entire directories and their contents (e.g.,
XCOPY /E C:\Data D:\Backup
).
Batch Files:
Batch files are text files containing a series of commands. These files are executed in sequence when the
batch file is run. Batch files allow for automation of tasks.
Example Batch File:
@echo off
cls
echo Starting the backup process...
xcopy C:\Documents D:\Backup\ /E
echo Backup complete.
pause
In this batch file, the commands clear the screen, display a message, copy files from one directory to
another, and then pause the process until the user presses any key.
3. Types of Operating Systems
1. Single-user, Single-tasking OS
These are simple operating systems that allow one user to perform one task at a time. MS-DOS is an
example of this type of OS.
Example:
MS-DOS: Only one program can be executed at a time.
2. Single-user, Multitasking OS
These operating systems allow a single user to run multiple programs simultaneously. Modern OSes like
Windows and macOS fall into this category.
Example:
Windows: Allows running web browsers, text editors, and games simultaneously.
3. Multi-user OS
These operating systems allow multiple users to access and use the system resources at the same time.
Examples include UNIX and Linux.
Example:
Linux: Multiple users can log in remotely and run programs at the same time.
4. Real-time OS
Real-time OSes are used in systems where time constraints are critical. They are found in embedded
systems like medical devices, industrial robots, and aerospace controls.
Example:
VxWorks: Used in embedded systems that require real-time processing.
5. Distributed OS
These OSes manage a group of separate computers and make them appear as a single system to the user.
Examples include Google's distributed OS and cloud computing services.
Example:
Hadoop: A framework for distributed data processing across many computers.
UNIT-IV: Windows Operating Environment
1. Features of MS Windows
Microsoft Windows is one of the most widely used operating systems for personal
computers. It provides a graphical user interface (GUI) that allows users to interact with the computer
using visual elements like icons, buttons, and windows, rather than text-based commands.
Key Features of MS Windows:
- Graphical User Interface (GUI): Windows allows users to interact with the system
using graphical elements (icons, buttons, windows). The GUI is intuitive, making it easy to navigate
and perform tasks.
Example: You can open a web browser by double-clicking the browser icon on the
desktop or taskbar.
- Multitasking: MS Windows allows you to run multiple applications at once, and you
can switch between them without closing any.
Example: You can have a web browser open for research while also editing a Word
document, and switch between them easily.
- File Management: Windows uses File Explorer to help manage files and folders on the
system. You can organize files in directories, move them, delete them, or copy them to other
locations.
Example: To save a new document, you would use File Explorer to choose the
folder where it should be saved.
- Security Features: Windows comes with built-in security features like
Windows Defender, which helps protect the computer from viruses and malware.
Example: If you download a suspicious file, Windows Defender will notify you
and may block the download to keep your system safe.
2. Control Panel
The Control Panel in Windows is where users can access and adjust the system settings
and configuration. This includes everything from hardware setup to security and network settings.
Key Components of the Control Panel:
- System and Security: Adjust settings related to system performance and security.
Example: You can view system information, configure backup settings, or change
firewall settings.
- Network and Internet: Manage network connections and internet settings.
Example: If you want to set up Wi-Fi, you can do it through this section.
- Hardware and Sound: Manage hardware devices, such as printers or speakers.
Example: You can change the default printer or adjust the sound settings here.
- User Accounts: Manage user accounts, change passwords, and control account access.
Example: You can create a new user account or change an existing user’s
password.
3. Taskbar
The Taskbar is located at the bottom of the screen and is an essential part of the
Windows interface. It shows running applications, gives you access to pinned programs, and displays
notifications.
Taskbar Components:
- Start Menu: Located at the left side of the Taskbar, the Start Menu provides quick
access to programs, settings, and files.
Example: Clicking the Start button shows the list of installed apps, documents,
and system settings.
- Quick Launch: This section allows you to pin frequently used programs for faster
access.
Example: Pin applications like Chrome, Word, or File Explorer for easy access.
- System Tray: Located on the right side of the Taskbar, it shows notifications like
the time, volume control, and system alerts.
Example: You can check the battery level or click the network icon to manage
Wi-Fi connections.
- Open Windows: The taskbar displays icons for any applications that are open. You
can click on these to bring the corresponding window to the foreground.
Example: If you're working on multiple documents, each open document will have
its icon on the Taskbar for easy switching.
4. Desktop
The Desktop is the primary workspace in Windows. It serves as a canvas for organizing
shortcuts, files, and running programs. You can customize the desktop to fit your needs and preferences.
Key Desktop Components:
- Icons: Small graphical representations of files, programs, or folders. You can
double-click these icons to open or execute the corresponding item.
Example: Double-click the "This PC" icon to open the file explorer and access
your computer’s files.
- Wallpaper: The background image of the desktop. Users can choose an image from the
default options or upload their own.
Example: You might change the wallpaper to a picture of your favorite landscape
for a personalized touch.
- Shortcuts: These are icons that provide quick access to files, applications, or
websites without opening the corresponding location in the file system.
Example: You might create a shortcut for a frequently used document so you
don’t have to navigate through folders each time.
5. Windows Applications
Windows comes pre-installed with a wide range of applications that help you perform
various tasks, from writing documents to editing photos.
Common Windows Applications:
- Notepad: A simple text editor for creating and editing plain text files. It’s often
used for taking quick notes.
Example: Write a to-do list or take a note during a meeting.
- Paint: A basic graphics editing program. It allows you to create and edit images
using simple drawing tools.
Example: You can create basic drawings or resize images using Paint.
- Calculator: A basic arithmetic tool for performing simple calculations.
Example: Use the calculator to perform basic math or convert units like inches
to centimeters.
- Windows Media Player: A multimedia player that lets you play music and videos.
Example: Open your favorite music files using Windows Media Player to listen to
them.
6. Windows Accessories
Windows Accessories are a set of tools provided by Windows that are lightweight but very
useful for various tasks. These accessories make daily tasks easier and faster.
Examples of Windows Accessories:
- Snipping Tool: A tool for capturing screenshots of parts of the screen.
Example: Capture an image of a specific section of a webpage and save it as a
file.
- WordPad: A basic word processing tool that is more advanced than Notepad but
simpler than Microsoft Word.
Example: You can use WordPad to create documents that include basic formatting
like bold, italics, and bullet points.
- Calculator: A simple application to perform arithmetic operations like addition,
subtraction, and multiplication.
Example: Use the Calculator app to quickly find the total cost of items during
shopping.
Additional Diagrams (Text Representation)
1. Taskbar Layout Example:
----------------------------------------------------------
| Start Menu | Quick Launch | Open Windows | System Tray |
----------------------------------------------------------
2. Desktop Icon Layout:
+--------------------------------------+
| [My Documents] [This PC] [Recycle Bin] |
+--------------------------------------+
| [Notepad] [Paint] [Calculator] |
+--------------------------------------+
UNIT-V: Editors and Word Processors
1. Basic Concepts
Editor: An editor is a software used to write, modify, or view plain text. It is mainly
used for writing code, notes, or configuration files. Editors do not support rich formatting like bold
text or inserting images.
Example: Notepad is a basic editor used for writing text or code like HTML, Python, etc.
Word Processor: A word processor is an application that allows users to create and
format documents using various fonts, colors, alignments, and graphics. It is mostly used to write
letters, reports, resumes, etc.
Example: MS Word is a popular word processor used for creating formatted documents like
reports or essays.
Comparison Table:
Feature |
Text Editor |
Word Processor |
Purpose |
Write plain text or code |
Create formatted documents |
Formatting |
No formatting (plain text only) |
Rich formatting (bold, fonts, color) |
Image Support |
No |
Yes |
Spell Check |
No |
Yes |
Diagram: Simple Difference
+--------------------+ +-----------------------------+
| Notepad | | Microsoft Word |
|--------------------| |-----------------------------|
| Plain text only | | Text, Images, Fonts, Colors |
| No formatting | | Formatting Tools Available |
+--------------------+ +-----------------------------+
Example of Using an Editor:
Notepad code:
print("Hello Nivesh!")
Example of Using Word Processor:
- Write "My Resume" using bold heading.
- Add bullet points for Skills.
- Insert a profile picture and contact table.
2. MS Word
Microsoft Word is a powerful word processing application from Microsoft that helps users
to create professional-looking documents.
Main Features of MS Word:
- Text formatting (font, size, color)
- Insert pictures, charts, and tables
- Spell and grammar check
- Page setup: margins, orientation
- Header, footer, watermark, and page numbers
Example: Creating a Resume
- Open MS Word and select a resume template or blank document.
- Write your name in bold, large font.
- Add a section for Education, Experience, and Skills.
- Insert a table for qualifications.
- Save the document as .docx or export to PDF.
Diagram: MS Word Interface
+---------------------------------------------------------+
| File | Home | Insert | Design | Layout | Review | View |
+---------------------------------------------------------+
| Font Options | Paragraph | Styles | Editing Tools |
+---------------------------------------------------------+
| Typing Area (Document) |
+---------------------------------------------------------+
| Status Bar | Page No. | Word Count | Zoom Slider |
+---------------------------------------------------------+
3. Introduction to Desktop Publishing (DTP)
Desktop Publishing (DTP) is the process of using software to create documents for print
or digital publishing. It involves layout, design, and typography to make documents visually appealing.
Common DTP Software:
- Adobe InDesign – for professional publishing
- Microsoft Publisher – for small projects
- CorelDRAW – for graphic-rich designs
- Scribus – free DTP software
Uses of DTP:
- Designing magazines and books
- Creating posters and flyers
- Brochures and newsletters
Example: Making a School Poster
- Open Microsoft Publisher
- Choose a poster template or start blank
- Add a bold heading: “Annual Sports Day”
- Insert images of students and games
- Use colorful fonts and background design
Diagram: Poster Design Elements
+-------------------------------+
| ANNUAL SPORTS DAY |
|-------------------------------|
| Date: 12th March 2025 |
| Time: 9:00 AM – 4:00 PM |
| Venue: School Playground |
| |
| [Images of Students Playing] |
+-------------------------------+
UNIT-VI: Spreadsheets and Database Packages
1. Purpose and Usage
Spreadsheets and Database Packages are tools used to organize,
analyze, and store data efficiently.
Spreadsheets: Help in managing numeric data, performing calculations, and visualizing
data using charts.
Usage: Budgeting, accounting, data entry, analysis.
Examples: MS Excel, Google Sheets.
Database Packages: Used for storing large amounts of structured data and retrieving it
efficiently.
Usage: Managing student records, inventory systems, customer details.
Examples: MS Access, MySQL.
2. Spreadsheet Commands and MS Excel
MS Excel is a spreadsheet program that allows users to perform calculations, create
charts, and store tabular data.
Common Commands in MS Excel:
- =SUM(A1:A5): Adds values from cells A1 to A5.
- =AVERAGE(B1:B10): Calculates the average of values in B1 to B10.
- =IF(A1>10, "Yes", "No"): Conditional formula to check if A1 is greater than 10.
- Merge Cells: Combine multiple cells into one large cell.
- Sort & Filter: Organize and search data easily.
Example Table: Monthly Expenses
+-----------+-------------+
| Category | Amount (₹) |
+-----------+-------------+
| Rent | 10,000 |
| Grocery | 5,000 |
| Transport | 2,000 |
| Utilities | 1,500 |
+-----------+-------------+
| Total | =SUM(B2:B5) |
+-----------+-------------+
3. MS Access - Creation of Files
MS Access is a database management system (DBMS) that helps create, manage, and query
databases.
Steps to Create a Database File in MS Access:
- Open MS Access → Click "Blank Database"
- Name your database file and click "Create"
- Add tables by clicking "Table Design"
- Define fields like ID, Name, Age, Address
- Save the table and set a Primary Key
Example Table Structure:
+----------+-----------+-------+------------+
| Field | Data Type | Size | Description|
+----------+-----------+-------+------------+
| ID | Number | Auto | Unique key |
| Name | Text | 50 | Full Name |
| Age | Number | 2 | Student Age|
| Address | Text | 100 | Home Addr. |
+----------+-----------+-------+------------+
4. Switching Between Applications
Windows allows switching between running applications using simple shortcuts and controls.
Methods:
- Alt + Tab: Cycle through open applications quickly.
- Taskbar: Click on the app icons in the taskbar to switch.
- Task View (Win + Tab): Shows thumbnails of all open apps and desktops.
Example:
You are writing a report in MS Word and need data from Excel. Press Alt + Tab to switch
from Word to Excel and back.
5. MS PowerPoint
MS PowerPoint is used to create slide-based presentations for meetings, education, and
more.
Key Features:
- Add and format slides with text, images, and charts
- Use transitions and animations for visual appeal
- Insert multimedia (audio, video)
- Apply templates for quick design
- Presenter view and slide show mode
Example: Class Project Presentation
- Open PowerPoint → New Presentation
- Title Slide: “My Science Project”
- Slide 2: Objective with bullet points
- Slide 3: Add image and explanation
- Apply animations to headings
- Press F5 to start slide show