UNIT-I: Introduction to Computers
Introduction to Computers: Introduction, Characteristics of Computers, Block diagram of computer. Types of
computers and features: Mini Computers, Micro Computers, Mainframe Computers, Super Computers. Types of
Programming Languages: Machine Languages, Assembly Languages, High-Level Languages. Data Organization:
Drives, Files, Directories. Types of Memory: Primary and Secondary (RAM, ROM, PROM, EPROM). Secondary
Storage Devices: FD, CD, HD, Pen drive. I/O Devices: Scanners, Plotters, LCD, Plasma Display. Number
Systems: Introduction to Binary, Octal, Hexadecimal systems, Conversion, Simple Addition, Subtraction,
Multiplication.
UNIT-II: Algorithm and Flowcharts
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.
Operating System and Services in O.S.: DOS – History, Files and Directories, Internal and External Commands,
Batch Files. Types of O.S.
UNIT-IV: Windows Operating Environment
Windows Operating Environment: Features of MS – Windows, Control Panel, Taskbar, Desktop, Windows
Application, Icons, Windows Accessories, Notepad, Paintbrush.
UNIT-V: Editors and Word Processors
Editors and Word Processors: Basic Concepts, Examples: MS-Word, Introduction to desktop publishing.
UNIT-VI: Spreadsheets and Database Packages
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
Computers are electronic devices capable of processing and storing data efficiently. They are widely used
in various fields such as education, healthcare, business, and science.
1.1 Characteristics of Computers
- Speed: Processes millions of instructions per second.
- Accuracy: Performs tasks with a high degree of precision.
- Automation: Operates automatically once programmed.
- Versatility: Can handle a wide variety of tasks.
- Storage: Stores vast amounts of data.
2. Block Diagram of a Computer
The block diagram represents the basic components of a computer system:
- Input Unit: Accepts data and instructions.
- Processing Unit: Processes the data (includes CPU).
- Memory Unit: Stores data temporarily or permanently.
- Output Unit: Displays the processed data.
Diagram:
[Input Unit] → [Processing Unit (CPU)] → [Memory Unit] → [Output Unit]
3. Types of Computers
Computers can be classified based on size, performance, and application:
- Mini Computers: Smaller, less powerful than mainframes, used in businesses.
- Micro Computers: Personal computers like desktops and laptops.
- Mainframe Computers: Powerful systems used in large organizations.
- Super Computers: Extremely powerful, used for complex computations.
4. Types of Programming Languages
- Machine Language: Binary code (0s and 1s) understood by computers.
- Assembly Language: Low-level language using mnemonics.
- High-Level Language: User-friendly, closer to natural language (e.g., Python, C++).
Example:
Machine Language: 101010
Assembly Language: ADD AX, BX
High-Level Language: print("Hello, World!")
5. Data Organization
- Drives: Storage devices (e.g., C drive, D drive).
- Files: A collection of related data stored in drives.
- Directories: Folders used to organize files systematically.
6. Types of Memory
6.1 Primary Memory
- RAM: Temporary, volatile memory used for processing.
- ROM: Permanent, non-volatile memory containing system firmware.
- PROM: Programmable Read-Only Memory, can be programmed once.
- EPROM: Erasable Programmable Read-Only Memory, reprogrammable.
6.2 Secondary Storage Devices
- Floppy Disk (FD): Obsolete portable storage.
- Compact Disk (CD): Optical storage, capacity up to 700 MB.
- Hard Disk (HD): Magnetic storage, large capacity.
- Pen Drive: Portable USB storage device.
7. Input/Output Devices
- Scanners: Convert physical documents into digital format.
- Plotters: Print high-quality graphics and designs.
- LCD: Liquid Crystal Display, used in monitors and TVs.
- Plasma Display: High-definition display technology.
8. Number Systems
8.1 Introduction
A number system is a way to represent numbers. Common systems include:
- Binary: Base-2, uses digits 0 and 1.
- Octal: Base-8, uses digits 0-7.
- Hexadecimal: Base-16, uses digits 0-9 and letters A-F.
8.2 Conversions
Binary to Decimal: (1010)₂ = (10)₁₀
Octal to Decimal: (12)₈ = (10)₁₀
Hexadecimal to Decimal: (A)₁₆ = (10)₁₀
8.3 Arithmetic Operations
- Addition: Add corresponding digits.
- Subtraction: Use borrow method if necessary.
- Multiplication: Multiply each digit and sum appropriately.
Example:
Binary Addition: 1010 + 0101 = 1111
Binary Subtraction: 1010 - 0101 = 0101
Binary Multiplication: 1010 × 0101 = 01001010
UNIT-II: Algorithm and Flowcharts
1. Algorithm
1.1 Definition
An algorithm is a step-by-step procedure or formula for solving a problem. It consists
of a finite sequence of well-defined instructions that produce a result or solve a problem.
1.2 Characteristics of Algorithms
- Finiteness: An algorithm must always terminate after a finite number of steps.
- Definiteness: Each step must be clearly and unambiguously defined.
- Input: An algorithm must accept zero or more inputs.
- Output: An algorithm must produce at least one output.
- Effectiveness: The steps must be basic enough to be carried out practically.
1.3 Advantages and Disadvantages
Advantages:
- Provides a clear step-by-step solution to a problem.
- Helps in debugging and verifying the correctness of the solution.
- Serves as a blueprint for program development.
Disadvantages:
- May become complex for large or intricate problems.
- Writing an algorithm requires prior understanding of the problem.
1.4 Examples
Example: Algorithm to find the sum of two numbers
1. Start
2. Input two numbers (a, b)
3. Compute sum = a + b
4. Print sum
5. Stop
2. Flowchart
2.1 Definition
A flowchart is a graphical representation of an algorithm using symbols to depict steps
and arrows to show the flow of control.
2.2 Flowchart Symbols
- Oval: Represents Start/End.
- Rectangle: Represents a process or instruction.
- Diamond: Represents a decision point.
- Parallelogram: Represents input/output operations.
- Arrow: Indicates the flow of control.
Symbol Key:
Oval: Start/End
Rectangle: Process
Diamond: Decision
Parallelogram: Input/Output
Arrow: Control Flow
2.3 Advantages and Disadvantages
Advantages:
- Provides a visual representation, making it easier to understand the logic.
- Helps identify errors in the process or logic.
- Useful for explaining logic to non-technical stakeholders.
Disadvantages:
- Can become complex for large or detailed processes.
- Modifying a flowchart can be time-consuming.
2.4 Examples
Flowchart to Find the Sum of Two Numbers
Flowchart Steps:
1. Start
2. Input two numbers
3. Add the numbers
4. Output the sum
5. End
Graphical Representation:
(Start) → [Input a, b] → [Sum = a + b] → [Output sum] → (End)
Flowchart to Determine Even or Odd
Flowchart Steps:
1. Start
2. Input a number
3. Check if number % 2 == 0
4. If true, print "Even"; otherwise, print "Odd"
5. End
Graphical Representation:
(Start) → [Input number] → (Check number % 2 == 0?)
→ [True: Print "Even"] → (End)
→ [False: Print "Odd"] → (End)
UNIT-III: Operating System and Services in OS
1. Introduction to Operating Systems (OS)
An Operating System (OS) is system software that acts as an interface between hardware
and users. It manages hardware resources and provides services for application programs.
1.1 Functions of an Operating System
- Process Management: Handles the execution of processes.
- Memory Management: Allocates and deallocates memory as needed.
- File System Management: Organizes and controls file storage.
- Device Management: Manages input/output devices.
- Security and Access Control: Protects data and resources.
2. DOS (Disk Operating System)
2.1 History of DOS
DOS was developed in the early 1980s as a command-line operating system for personal computers. The most
popular version was MS-DOS by Microsoft.
2.2 Files and Directories
DOS uses a hierarchical structure to organize files and directories:
- File: A collection of data stored on disk.
- Directory: A folder containing files or subdirectories.
Example:
C:\Documents\File.txt
- "C:" is the drive
- "Documents" is the directory
- "File.txt" is the file
2.3 Internal and External Commands
Commands in DOS are categorized into:
- Internal Commands: Built into the command interpreter (e.g.,
dir
,
copy
, del
).
- External Commands: Stored in separate executable files (e.g.,
format
,
diskcopy
).
Examples:
Internal: dir → Lists files in the directory.
External: format A: → Formats a floppy disk in drive A.
2.4 Batch Files
A batch file is a text file containing a series of DOS commands executed in sequence.
Example:
@echo off
echo Welcome to DOS
dir
pause
3. Types of Operating Systems
Operating Systems can be classified into different types based on their functionality and usage:
- Batch Operating System: Executes jobs in batches without user interaction.
- Time-Sharing Operating System: Allows multiple users to access the system
simultaneously.
- Distributed Operating System: Manages a group of independent computers as a single
system.
- Real-Time Operating System: Ensures real-time processing with strict timing
constraints.
- Network Operating System: Provides services like file sharing, and printer access
over a network.
Examples:
Batch OS: IBM OS/360
Time-Sharing OS: UNIX
Distributed OS: Google File System
Real-Time OS: VxWorks
Network OS: Windows Server
UNIT-IV: Windows Operating Environment
1. Features of MS-Windows
MS-Windows is a graphical user interface (GUI)-based operating system designed for user-friendliness and
multitasking. Key features include:
- Graphical Interface: Easy-to-navigate windows, icons, and menus.
- Multitasking: Run multiple applications simultaneously.
- Plug and Play: Automatically detects and configures new hardware.
- Networking: Simplified network setup and internet connectivity.
- Security: User accounts, firewalls, and regular updates for protection.
2. Control Panel
The Control Panel is a centralized hub for managing system settings and configurations.
Common features include:
- Display Settings: Adjust resolution, themes, and screen savers.
- Hardware and Sound: Configure printers, audio devices, and power settings.
- Programs: Install, uninstall, or modify software applications.
- User Accounts: Manage user profiles, passwords, and parental controls.
Example:
To change the display settings:
1. Open Control Panel → Display → Adjust Resolution.
3. Taskbar
The Taskbar is located at the bottom of the screen and helps manage active applications
and shortcuts:
- Start Menu: Access programs, settings, and files.
- Quick Launch: Shortcut area for frequently used apps.
- System Tray: Displays system notifications and background apps.
- Application Area: Displays open and active programs.
4. Desktop
The Desktop is the primary workspace where users interact with files, folders, and
shortcuts. Key components include:
- Icons: Graphical representations of files, folders, and applications.
- Wallpaper: The background image or color of the desktop.
- Context Menu: Right-click options for managing desktop items.
5. Windows Applications
Windows offers built-in applications to perform various tasks:
- File Explorer: Browse and manage files and folders.
- Web Browser: Access the internet using Edge or other browsers.
- Media Player: Play audio and video files.
- Email Client: Manage emails through Mail or Outlook.
6. Windows Accessories
Windows includes several utility tools known as Accessories for everyday tasks:
6.1 Notepad
A simple text editor for creating and editing plain text files.
Features:
- Lightweight and fast.
- Supports basic text formatting.
- Ideal for scripts and notes.
6.2 Paintbrush
A basic graphic editing program for creating and editing images.
Features:
- Supports drawing, coloring, and basic editing tools.
- Compatible with common image formats (BMP, PNG, JPEG).
Example:
Open Paintbrush → Draw shapes → Save as image.
UNIT-V: Editors and Word Processors
1. Basic Concepts
Editors and Word Processors are software tools used to create, edit,
and format text and documents. They play a crucial role in documentation, publishing, and communication.
- Editors: Focused on basic text creation and modification, often used by
programmers.
- Word Processors: Advanced tools with rich formatting, styling, and layout features
for documents.
2. Examples of Editors
Popular text editors include:
- Notepad: A simple editor for plain text creation.
- Sublime Text: Advanced text editor for coding and scripting.
- Visual Studio Code: A robust editor for programming with extensions and debugging
tools.
Example:
Using Notepad:
1. Open Notepad.
2. Type "Hello, World!"
3. Save the file as "example.txt".
3. Examples of Word Processors
Popular word processors include:
- MS-Word: The most widely used word processor with comprehensive features for
document creation and formatting.
- Google Docs: Cloud-based word processor for collaborative document editing.
- LibreOffice Writer: An open-source word processor with features similar to MS-Word.
Example:
Using MS-Word:
1. Open MS-Word.
2. Create a new document.
3. Add text, format it using font options.
4. Insert images or tables.
5. Save the document as "example.docx".
4. Introduction to Desktop Publishing (DTP)
Desktop Publishing (DTP) refers to the use of software to design and produce
high-quality printed and digital documents. It combines text, graphics, and layouts to create visually
appealing outputs.
4.1 Applications of DTP
- Creating brochures, flyers, and posters.
- Designing books, magazines, and newspapers.
- Developing business cards, invitations, and banners.
4.2 Popular DTP Software
- Adobe InDesign: Industry-standard tool for professional DTP projects.
- CorelDRAW: Popular for vector graphics and layout designs.
- Scribus: Open-source software for beginners and professionals.
Example:
Using Adobe InDesign:
1. Open Adobe InDesign.
2. Create a new project with desired dimensions.
3. Add text, images, and layouts.
4. Save the project as a PDF or print-ready file.
UNIT-VI: Spreadsheets and Database Packages
1. Introduction
Spreadsheets and Database Packages are powerful tools used for data
organization, analysis, and presentation. These tools enhance productivity by automating calculations
and managing large datasets.
2. Spreadsheets
2.1 Purpose and Usage
- Purpose: Spreadsheets are used for data analysis, financial modeling, and
record-keeping.
- Usage: They allow users to enter data in tabular format, perform calculations, and
visualize data with charts.
2.2 Commands in MS-Excel
MS-Excel is a widely used spreadsheet application. Key commands include:
- Formulas:
=SUM(A1:A10)
, =AVERAGE(A1:A10)
.
- Cell Referencing: Absolute (
$A$1
) and Relative (A1
).
- Functions:
IF
, VLOOKUP
, HLOOKUP
,
CONCATENATE
.
Example:
To calculate the total of column A:
1. Select the cell where you want the total.
2. Use the formula =SUM(A1:A10).
3. Database Packages
3.1 Purpose and Usage
- Purpose: Database packages store, retrieve, and manage data systematically.
- Usage: Used for creating, querying, and managing relational databases.
3.2 Creation of Files in MS-Access
MS-Access is a database management system used for creating and managing relational databases.
Steps to Create a Database in MS-Access:
1. Open MS-Access and select "New Database."
2. Define tables and their fields (e.g., Name, Age, Address).
3. Set primary keys for unique identification.
4. Save the database with an appropriate name.
4. Switching Between Applications
Windows allows seamless switching between applications using the following methods:
- Keyboard Shortcut: Use
Alt + Tab
to cycle through open applications.
- Taskbar: Click on the desired application's icon on the taskbar.
Example:
To switch between MS-Excel and MS-Access:
1. Use Alt + Tab to choose the application.
2. Alternatively, click on the respective taskbar icons.
5. MS-PowerPoint
5.1 Purpose and Usage
- Purpose: MS-PowerPoint is used to create visually engaging presentations.
- Usage: It supports text, images, animations, and charts to enhance communication.
5.2 Key Features
- Slides: Create and organize information on slides.
- Animations: Add visual effects to objects and text.
- Transitions: Apply effects between slides for smooth navigation.
Example:
To create a simple presentation:
1. Open MS-PowerPoint and select a theme.
2. Add slides and input text or images.
3. Apply animations and transitions.
4. Save the file as "example.pptx".