BASIC COMPUTER APPLICATIONS

Veterinary Inspector Punjab Exam

1. KNOWLEDGE ABOUT COMPUTER ACCESSORIES

1.1 BASIC COMPUTER COMPONENTS

A. INPUT DEVICES (Send information to computer)

1. KEYBOARD

Used for: Typing text, commands

Types: Standard QWERTY (most common), Ergonomic, Laptop keyboard

Connection: Wired (USB), Wireless (Bluetooth)

Function: Main text input device

2. MOUSE

Used for: Navigate, select, click on items

Types: Optical (laser), Wireless, Trackpad, Touchpad

Functions: Left click (select), Right click (menu), Scroll (wheel)

Movement: Controls cursor on screen

3. TOUCHPAD

Location: On laptop keyboard

Use: Replace mouse on laptops

Navigation: Finger movement on surface

Clicks: Tap or press areas

4. SCANNER

Purpose: Convert documents/images to digital

Use: Farm records, documents, photos

 Output: Digital image files

Connection: USB to computer

5. MICROPHONE

Purpose: Record audio

Use: Voice input, recording, dictation

Types: Built-in (laptop), External

Connection: USB or 3.5mm jack

B. OUTPUT DEVICES (Show information from computer)

1. MONITOR/SCREEN

Purpose: Display visual information

Types: LED, LCD (common), CRT (older)

Size: 15”, 17”, 19”, 21”, 24” (inches)

Connection: HDMI, VGA, DisplayPort

Resolution: Affects image clarity

2. PRINTER

Purpose: Print documents on paper

Types:

Inkjet: Good quality, slower

Laser: Fast, professional

Dot matrix: Old technology

Use: Farm records, certificates, reports

3. SPEAKERS

Purpose: Audio output

Types: Built-in, External

Use: Listening to videos, presentations

4. HEADPHONES

Purpose: Personal audio listening

 Use: Videos, audio files, calls

C. STORAGE DEVICES

1. HARD DISK DRIVE (HDD)

Capacity: 500 GB to 2 TB (terabyte)

Speed: Slower than SSD

Type: Mechanical (spinning disk)

Use: Primary storage in computers

2. SOLID STATE DRIVE (SSD)

Capacity: 256 GB to 1 TB+

Speed: Very fast (no moving parts)

Type: Electronic storage

Use: Modern computers (faster performance)

3. EXTERNAL HARD DISK

Capacity: 1-4 TB

Purpose: Backup, portable storage

Connection: USB

Portability: Easy to carry

4. USB FLASH DRIVE (Pen Drive)

Capacity: 8 GB to 128 GB

Portability: Very portable

Use: Transfer files, backup

Connection: USB port

5. SD CARD (Memory Card)

Capacity: 32 GB to 512 GB

Use: Camera storage, phones

Portability: Very small

Connection: Card reader needed

D. PROCESSING & MEMORY DEVICES

1. CPU (Central Processing Unit)

Function: Brain of computer

Speed: Measured in GHz (Gigahertz)

Brands: Intel, AMD

Types: i3, i5, i7 (Intel), Ryzen (AMD)

2. RAM (Random Access Memory)

Function: Temporary memory for running programs

Amount: 4GB, 8GB, 16GB, 32GB

Speed: Affects performance

Type: DDR3, DDR4, DDR5 (newer)

3. MOTHERBOARD

Function: Central board connecting all components

Importance: Holds CPU, RAM, storage

Brands: ASUS, Gigabyte, MSI

E. POWER SUPPLY

1. POWER SUPPLY UNIT (PSU)

Function: Provides electricity to computer

Wattage: 500W, 650W, 750W (watts)

Stability: UPS (Uninterruptible Power Supply) recommended

2. UPS (Uninterruptible Power Supply)

Function: Backup power during outage

Capacity: 500VA to 2000VA

Use: Prevents data loss if power cuts

Important: For farms in areas with frequent power cuts

1.2 PERIPHERAL DEVICES

Definition: External devices connected to computer

Common Peripherals:

Printer

Scanner

External hard drive

USB devices

Monitor (if not integrated)

Keyboard and mouse (if separate)

Speakers

Camera

Connection Methods:

USB (Universal Serial Bus) - Most common

HDMI (for display)

Ethernet (for network)

Bluetooth (wireless)

3.5mm jack (audio)

2. WINDOWS OPERATING SYSTEM BASICS

2.1 WHAT IS AN OPERATING SYSTEM?

Definition: Software that manages computer hardware and applications

Purpose:

Control hardware

Manage files and folders

Run programs

User interface (how you interact)

Common Operating Systems:

Windows (Microsoft) - Most common

 macOS (Apple)

Linux (Free, open-source)

Android (Mobile)

2.2 WINDOWS 10/11 BASICS

Starting Computer:

1. Press power button

2. Wait for Windows to load (1-2 minutes)

3. Login with username/password

4. Desktop appears

Desktop Elements:

A. TASKBAR (Bottom of screen)

Shows running programs

Shows time and system tray

Quick access icons

Start button (far left)

B. START MENU

Click Windows logo (bottom left)

Shows all installed programs

Search function

Settings access

Shutdown options

C. FILE EXPLORER

Manages files and folders

Shows: This PC, Documents, Downloads, Pictures

Folder structure (C:, D: drives)

Search files
D. ICONS

Desktop shortcuts

Double-click to open

Right-click for options

Delete icon by right-click → Delete

2.3 FILE MANAGEMENT

Understanding Folders:

C: Drive (main storage)

Documents folder (important files)

Downloads (files downloaded from internet)

Pictures (image files)

Desktop (shortcuts and files on desktop)

File Operations:

Creating New Folder:

1. Right-click in empty space

2. Select “New” → “Folder”

3. Name the folder

4. Press Enter

Copying Files:

1. Right-click file

2. Select “Copy”

3. Go to destination folder

4. Right-click → “Paste”

Moving Files:

1. Right-click file

2. Select “Cut”
3. Go to destination

4. Right-click → “Paste”

Deleting Files:

1. Right-click file

2. Select “Delete”

3. File goes to Recycle Bin

4. Empty Recycle Bin to permanently delete

Renaming Files:

1. Right-click file

2. Select “Rename”

3. Type new name

4. Press Enter

Searching for Files:

1. Click Search (magnifying glass)

2. Type file name or part of name

3. Results appear instantly

2.4 SYSTEM SETTINGS

Accessing Settings:

Click Start button → Settings

OR right-click taskbar → Settings

Important Settings:

Display Settings:

Screen brightness

Resolution (clarity)

Display scaling

Sound Settings:
 Volume control

Speaker selection

Microphone volume

Network Settings:

Wi-Fi connection

Ethernet connection

Network status

User Accounts:

Create new user account

Change password

Set profile picture

Updates:

Windows updates

Security patches

Feature updates (periodically)

Security:

Windows Defender (antivirus)

Firewall settings

USB device restrictions

3. MS WORD - DOCUMENT CREATION AND FORMATTING

3.1 STARTING MS WORD

Methods:

1. Click Start button → Search “Word” → Open Microsoft Word

2. Click Word icon on desktop (if available)

3. Double-click Word document file

First Screen:
 Blank document option

Template options

Recent documents

3.2 BASIC DOCUMENT CREATION

Main Elements:

Ribbon (Top of screen):

File (Save, Open, Print)

Home (Font, Bold, Italic, Alignment)

Insert (Images, Tables, Shapes)

Layout (Margins, Spacing)

References (Citations, Bibliography)

Toolbar:

Save (Ctrl + S)

Undo (Ctrl + Z)

Redo (Ctrl + Y)

Print (Ctrl + P)

Page Area:

Where you type text

White/blank space for document content

3.3 TEXT FORMATTING

Font Formatting:

Selecting Text:

1. Click at start of text

2. Drag to end of text (OR)

3. Triple-click to select paragraph

4. Ctrl + A to select all

Font Style:

Bold: Ctrl + B (or click Bold button)

Italic: Ctrl + I (or click Italic button)

Underline: Ctrl + U (or click Underline button)

Font Change:

1. Select text

2. Click Font dropdown (Calibri, Arial, Times New Roman, etc.)

3. Choose font

Font Size:

1. Select text

2. Click Size dropdown (8, 10, 12, 14, 16, etc.)

3. Choose size

Font Color:

1. Select text

2. Click Font Color dropdown (A with colored line)

3. Choose color

Alignment:

Left align (Ctrl + L)

Center align (Ctrl + E)

Right align (Ctrl + R)

Justify (Ctrl + J)

3.4 DOCUMENT FORMATTING

Margins:

1. Go to Layout tab

2. Click Margins
3. Choose preset (Normal, Narrow, Wide) OR Custom

Line Spacing:

1. Select text

2. Go to Home tab

3. Click Line Spacing dropdown

4. Choose 1.0, 1.5, 2.0, or custom

Paragraph Spacing:

1. Select paragraph

2. Go to Layout tab

3. Set spacing before and after paragraph

Bullet Points:

1. Place cursor where you want list

2. Click Bullet Point button (Home tab)

3. Type list items

4. Press Enter for new item

5. Press Backspace twice to exit list

Numbered List:

1. Click Numbering button (Home tab)

2. Type list items

3. Similar to bullets

3.5 SAVING AND PRINTING

Saving Document:

First Save:

1. Press Ctrl + S

2. Choose location (Documents folder recommended)

3. Type filename
4. Choose file type (Word Document .docx)

5. Click Save

Saving Again:

Press Ctrl + S (overwrites previous version)

Save As (Different name/location):

1. File menu → Save As

2. Choose location

3. Type new name

4. Click Save

Printing:

1. Press Ctrl + P

2. Select printer

3. Choose number of copies

4. Set page range (all, specific pages)

5. Click Print

Print Preview:

1. File menu → Print

2. See preview on right side

3. Check before printing

3.6 BASIC EDITING

Copy and Paste:

Select text → Ctrl + C (copy) → Click location → Ctrl + V (paste)

Cut and Paste (Move):

Select text → Ctrl + X (cut) → Click location → Ctrl + V (paste)

Find and Replace:

1. Press Ctrl + H
2. Type word to find

3. Type replacement word

4. Click “Replace All” (all instances) or “Replace” (one at a time)

Spell Check:

Red squiggly line = spelling error

Right-click word for corrections

4. MS EXCEL - SPREADSHEET AND DATA

4.1 STARTING MS EXCEL

Methods:

1. Start button → Search “Excel” → Open

2. Click Excel icon on desktop

3. Double-click Excel file

First Screen:

Blank workbook

Template options

Recent files

4.2 EXCEL BASICS

Main Components:

Spreadsheet Layout:

Columns: A, B, C, D… (vertical, letters)

Rows: 1, 2, 3, 4… (horizontal, numbers)

Cells: Individual boxes (A1, B2, C3 = cell reference)

Cell Selection:

Click cell to select (highlighted with border)

Drag to select multiple cells

 Shift + Click to select range

Tabs at Bottom:

Sheet1, Sheet2, Sheet3

Each sheet has separate data

Right-click to add/delete sheets

4.3 ENTERING DATA

Typing in Cells:

1. Click cell

2. Type data

3. Press Enter (moves to next cell below)

4. OR press Tab (moves to next cell right)

Data Types:

Text: Names, descriptions

Numbers: Quantities, prices

Dates: 01/01/2024

Formulas: Start with = (=A1+B1)

Editing Cell Content:

1. Double-click cell (enter edit mode)

2. OR press F2

3. Edit text

4. Press Enter to confirm

4.4 FORMATTING CELLS

Column Width:

Double-click border between column headers

Auto-fits width to content

Row Height:

Double-click border between row numbers

Auto-fits height to content

Number Format:

1. Right-click cells

2. Select “Format Cells”

3. Choose format (Number, Currency, Percentage, Date, etc.)

Font Formatting:

1. Select cells

2. Use Home tab options

3. Bold, Italic, Underline (similar to Word)

Cell Color:

1. Select cells

2. Click Fill Color dropdown

3. Choose color

Borders:

1. Select cells

2. Click Borders dropdown

3. Choose border style

4.5 BASIC FORMULAS

What are Formulas:

Calculations in cells

Start with = sign

Examples: =A1+B1 (addition), =A1*B1 (multiplication)

Common Formulas:

SUM (Total):
 =SUM(A1:A10) - Adds A1 through A10

=SUM(B2:B5,D2:D5) - Adds non-adjacent ranges

AVERAGE:

=AVERAGE(A1:A10) - Average of cells

COUNT:

=COUNT(A1:A10) - Counts numeric cells

MIN/MAX:

=MIN(A1:A10) - Lowest value

=MAX(A1:A10) - Highest value

IF (Conditional):

=IF(A1>100,“Pass”,“Fail”)

If A1 greater than 100, show “Pass”, otherwise “Fail”

Entering Formulas:

1. Click cell where you want result

2. Type = followed by formula

3. Press Enter

4. Result appears in cell

Copying Formulas:

1. Click cell with formula

2. Copy (Ctrl + C)

3. Select range to paste

4. Paste (Ctrl + V)

5. Formula adjusts for each row (A1 becomes A2, A3, etc.)

4.6 WORKING WITH DATA

Sorting Data:

1. Select data including headers

2. Data tab → Sort

3. Choose column to sort

4. Ascending (A-Z) or Descending (Z-A)

Filtering Data:

1. Select data with headers

2. Data tab → AutoFilter

3. Click dropdown arrows in headers

4. Uncheck items to hide

5. Show only needed data

Creating Charts:

1. Select data to chart

2. Insert tab → Chart

3. Choose chart type (Column, Line, Pie, etc.)

4. Click Insert

5. Chart appears in spreadsheet

Saving Excel File:

1. Ctrl + S

2. Choose location

3. Type filename

4. Choose file type (.xlsx for Excel)

5. Click Save

5. MS POWERPOINT - PRESENTATIONS

5.1 STARTING POWERPOINT

Methods:

1. Start button → Search “PowerPoint” → Open

2. Click PowerPoint icon

3. Double-click PowerPoint file

New Presentation:

Blank presentation

Templates available

Recent presentations

5.2 PRESENTATION BASICS

Main Screen:

Slide area (large, center)

Slide panel (left side)

Notes area (bottom)

Toolbar (top)

Slides:

Each slide is one screen/page

Multiple slides in presentation

Slides shown one at a time during presentation

5.3 CREATING SLIDES

Adding New Slide:

1. Home tab → New Slide

2. Choose layout:

Title Slide (Title + Subtitle)

Title and Content (Title + bullet points)

Two Content (Title + two columns)

Blank

Editing Slide Content:

1. Click text box

2. Type text

3. Click outside to deselect

Slide Layouts:

Title slide: First slide (presentation title)

Content slides: Information slides (with bullets, images)

Blank slide: Custom content

5.4 FORMATTING SLIDES

Text Formatting:

1. Select text

2. Home tab → Font formatting (Bold, Italic, Size, Color)

3. Similar to Word

Background:

1. Design tab → Themes (color schemes)

2. Choose theme

3. All slides get same design

Adding Images:

1. Insert tab → Pictures

2. Choose image file

3. Drag corners to resize

4. Position on slide

Adding Shapes:

1. Insert tab → Shapes

2. Choose shape

3. Click and drag to draw

4. Right-click to format (color, border)

5.5 SLIDE TRANSITIONS AND ANIMATIONS
Transitions (How slides change):

1. Transitions tab

2. Choose transition (Fade, Push, Wipe, etc.)

3. Set duration (0.5 sec, 1 sec, 2 sec)

4. Apply to all slides OR just this slide

Animations (How objects appear):

1. Select object (text or image)

2. Animations tab

3. Choose animation (Fade, Bounce, Spin, etc.)

4. Set order and timing

5.6 PRESENTING AND SAVING

Starting Presentation:

Press F5 (full screen from beginning)

OR Shift + F5 (from current slide)

Click mouse or press right arrow to advance

Ending Presentation:

Press Esc key

Saving Presentation:

1. Ctrl + S

2. Choose location

3. Type filename

4. Choose file type (.pptx for PowerPoint)

5. Click Save

Printing Slides:

1. File → Print
2. Choose layout (Slides, Handouts, Outline)

3. Set number of copies

4. Click Print

6. INTERNET AND EMAIL BASICS

6.1 INTERNET FUNDAMENTALS

What is Internet:

Global network of computers

Connects devices worldwide

Access information, email, videos

Internet Connection:

Broadband (Fast, fiber optic, DSL)

Mobile data (3G, 4G, 5G)

Speed: Measured in Mbps (Megabits per second)

Web Browser:

Software to access websites

Common: Google Chrome, Microsoft Edge, Firefox, Safari

Address bar: Type website URL ([Link])

Website Basics:

URL: [Link]

https: Secure connection (lock icon shows)

Domain: [Link] (website address)

6.2 EMAIL BASICS

What is Email:

Electronic mail

Send messages to people

 Attachments: Send files with email

Email Providers (Free):

Gmail (Google)

Outlook (Microsoft)

Yahoo Mail

All provide web-based email access

Email Address Format:

username@[Link]

Example: farmer@[Link]

Unique identifier for each person

Creating Email Account (Gmail example):

1. Go to [Link]

2. Click “Create Account”

3. Enter:

First name

Last name

Choose username

Create strong password

Recovery email (optional)

Recovery phone (optional)

4. Click “Create Account”

5. Verify phone number or email

Sending Email:

1. Click “Compose”

2. Enter recipient email (To field)

3. Enter subject (what email is about)

4. Type message in body

5. Click “Send”

Email Components:

To: Recipient email address

Cc: Copy (recipient gets copy, but not main recipient)

Bcc: Blind copy (hidden from other recipients)

Subject: Topic of email

Body: Message content

Attachments: Files attached

Receiving Email:

Emails appear in Inbox

Unread emails: Bold or notification

Click email to read full content

Attachments:

Download: Click attachment, save to computer

Send: Click “Attach” button, select file, send email

Email Organization:

Inbox: Received emails

Sent: Emails you sent

Drafts: Unsent emails (save before sending)

Trash/Deleted: Deleted emails

Archive: Keep but remove from inbox

6.3 INTERNET SAFETY

Password Security:

Use strong password (mix of letters, numbers, symbols)

At least 8 characters

Don’t share password

 Change regularly

Phishing Awareness:

Don’t click links in suspicious emails

Don’t enter personal info on unknown websites

Check sender email address (legitimate?)

Malware Prevention:

Install antivirus software

Don’t download from untrusted sources

Keep Windows updated

Privacy:

Don’t share personal information online

Check privacy settings on websites

Be careful what you post

7. FARM DATA RECORDING AND STORAGE

7.1 IMPORTANCE OF DIGITAL RECORD KEEPING

Why Digital Records:

Better organization

Easy search and retrieval

Backup (safety from loss)

Analysis and trends

Sharing with veterinarian

Government compliance

7.2 DATA TO RECORD (FOR LIVESTOCK FARM)

Animal Information:

Animal ID (ear tag number)

 Name (optional)

Breed

Date of birth

Sex

Parents (dam/sire)

Date acquired

Cost

Health Records:

Vaccination dates and names

Deworming dates and products

Illness/disease dates and treatment

Medication given (name, dose, duration)

Veterinarian visits

Laboratory test results

Reproductive Records (Cattle):

Heat detection dates

Breeding date

Estimated due date

Pregnancy confirmation

Birth date

Offspring details

Breeding success rate

Production Records:

Milk production (daily liters) - for dairy animals

Weight gain (for meat animals)

Feed given (type and amount)

Water consumption
 Egg production (for poultry)

Financial Records:

Feed cost

Veterinary cost

Breeding cost

Labor cost

Income from milk/meat/eggs

Profit/loss

7.3 CREATING SPREADSHEET FOR FARM DATA

Step 1: Create Column Headers

Example - Cattle Health Record:

Animal Animal
Date Breed Vaccine/Medicine Dose Route Veterinarian Cost
ID Name

Step 2: Enter Data

1. Click first cell under Date

2. Type date (01/15/2024)

3. Press Tab (move to next column)

4. Enter all information

5. Press Enter (go to next row)

Step 3: Format Spreadsheet

1. Make headers bold

2. Add borders

3. Adjust column width

4. Color headers

Step 4: Add Formulas (if needed)

Example: Total cost = SUM of all costs

 Average milk per day = AVERAGE of daily milk

Step 5: Regular Updates

Add data daily/weekly

Keep updated (not months later)

Save regularly (backup important)

7.4 FILE BACKUP AND STORAGE

Why Backup:

Prevents data loss (computer crash, corruption)

Insurance against accidental deletion

Multiple copies = safer

Backup Methods:

Method 1: External Hard Drive

Copy files to external drive

Frequency: Weekly or monthly

Storage: Keep in safe place

Cost: One-time (500-2000 rupees)

Method 2: Cloud Storage (Free)

Google Drive (free 15 GB)

OneDrive (free 5 GB)

Dropbox (free 2 GB)

Files accessible from anywhere

Automatic sync (if enabled)

Method 3: USB Flash Drive

Small, portable

Limited capacity (8-128 GB)

Good for small files

 Easy to lose

Best Practice:

Keep 2-3 copies

Different locations (home + external drive + cloud)

Update backups regularly

7.5 SHARING DATA WITH VETERINARIAN

Preparation:

1. Export data from Excel

2. Save as PDF (if needed for printing)

3. Clear and organized format

Methods to Share:

Email: Attach file

WhatsApp: Send document

Cloud share: Share link

Print: Physical copy

Format for Sharing:

Clear headers

Date range clear

All relevant data

Professional appearance

KEY POINTS FOR EXAM

✓ Keyboard and mouse: Input devices (send info to computer) ✓ Monitor and printer: Output
devices (show/print info from computer) ✓ Hard drive and SSD: Storage devices ✓ RAM:
Temporary memory (affects speed) ✓ Windows: Operating system (manages hardware) ✓ File
Explorer: Manages files and folders (C: drive) ✓ Word: Document creation (save as .docx) ✓
Excel: Spreadsheets with data and formulas ✓ PowerPoint: Presentations with slides ✓ Gmail:
Email service (username@[Link]) ✓ Strong password: Mix letters, numbers, symbols ✓
Backup: Keep copies (cloud, external drive) ✓ Farm data: Record health, production, financial ✓
Spreadsheet: Organize data in rows and columns ✓ Formulas: =SUM, =AVERAGE, =COUNT, =IF

ESTIMATED EXAM QUESTIONS: 5-8 MCQs TOTAL TOPICS COVERED: 7 main sections