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

3. Block Diagram of a Computer

                +------------+       +------------+       +------------+
                | Input Unit | --->  | CPU        | --->  | Output Unit|
                +------------+       +------------+       +------------+
                                         |
                                         v
                                   +-------------+
                                   | Memory Unit |
                                   +-------------+
            

4. Types of Computers and Features

5. Types of Programming Languages

    Example:
    Machine: 10110010
    Assembly: MOV A, B
    High-Level: sum = a + b;
            

6. Data Organization

7. Types of Memory

8. Secondary Storage Devices

9. I/O Devices

10. Number Systems

Computers understand binary system (0 and 1), but humans also use octal, decimal, and hexadecimal.

    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:

Advantages:

Disadvantages:

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:

Disadvantages:

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:

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.

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.

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:

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:

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:

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:

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:

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:

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:

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:

Example: Creating a Resume

  1. Open MS Word and select a resume template or blank document.
  2. Write your name in bold, large font.
  3. Add a section for Education, Experience, and Skills.
  4. Insert a table for qualifications.
  5. 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:

Uses of DTP:

Example: Making a School Poster

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:

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:

  1. Open MS Access → Click "Blank Database"
  2. Name your database file and click "Create"
  3. Add tables by clicking "Table Design"
  4. Define fields like ID, Name, Age, Address
  5. 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:

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:

Example: Class Project Presentation

  1. Open PowerPoint → New Presentation
  2. Title Slide: “My Science Project”
  3. Slide 2: Objective with bullet points
  4. Slide 3: Add image and explanation
  5. Apply animations to headings
  6. Press F5 to start slide show