Computer Fundamental & Office Automation
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

2. Block Diagram of a Computer

The block diagram represents the basic components of a computer system:

Diagram:
[Input Unit] → [Processing Unit (CPU)] → [Memory Unit] → [Output Unit]
        

3. Types of Computers

Computers can be classified based on size, performance, and application:

4. Types of Programming Languages

Example:
Machine Language: 101010
Assembly Language: ADD AX, BX
High-Level Language: print("Hello, World!")
        

5. Data Organization

6. Types of Memory

6.1 Primary Memory

6.2 Secondary Storage Devices

7. Input/Output Devices

8. Number Systems

8.1 Introduction

A number system is a way to represent numbers. Common systems include:

8.2 Conversions

Binary to Decimal: (1010)₂ = (10)₁₀
Octal to Decimal: (12)₈ = (10)₁₀
Hexadecimal to Decimal: (A)₁₆ = (10)₁₀
        

8.3 Arithmetic Operations

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

1.3 Advantages and Disadvantages

Advantages:

Disadvantages:

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

Symbol Key:
Oval: Start/End
Rectangle: Process
Diamond: Decision
Parallelogram: Input/Output
Arrow: Control Flow
        

2.3 Advantages and Disadvantages

Advantages:

Disadvantages:

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

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:

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:

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:

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:

2. Control Panel

The Control Panel is a centralized hub for managing system settings and configurations. Common features include:

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:

4. Desktop

The Desktop is the primary workspace where users interact with files, folders, and shortcuts. Key components include:

5. Windows Applications

Windows offers built-in applications to perform various tasks:

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.

2. Examples of Editors

Popular text editors include:

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:

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

4.2 Popular DTP Software

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

2.2 Commands in MS-Excel

MS-Excel is a widely used spreadsheet application. Key commands include:

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

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:

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

5.2 Key Features

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".