ICT Skills Class 12 Notes | CBSE Employability Skills

Latest and concise ICT Notes for Class 12 of CBSE Employability Skills. Easy exam-ready notes with keypoints to help you scoer high marks.

Session 1: Introduction to Spreadsheet

What is spreadsheet?

• A spreadsheet is an electronic document that stores data in rows and columns (cells).
• Each cell is identified by a cell address (like A1, B2).
• Uses: Budgeting, marks calculation, charts, data analysis.

Types of spreadsheets

• Microsoft Excel,
• LibreOffice Calc
• Google Sheets

Components of Spreadsheet

Session 2: Performing Basic Operations in Spreadsheet

Opening and Saving a Spreadsheet

• Open a new spreadsheet: File → New → Spreadsheet
• Open existing file: File → Open → Select file → OK
• Save file: File → Save / Save As → Give name → OK

Types of Data

• Data can be text, numbers, dates, or formulas.

Editing Data

1. Method-1: Click on the cell and type again to replace data.
2. Method-2: Double-click the cell or use Formula Bar to edit text.
3. Method-3: Press Delete to remove content from the cell.

Selecting Multiple Cells

• Single cell: Click once.
• Range of cells: Click and drag.
• Entire row: Click row number.
• Entire column: Click column letter.
• Entire sheet: Click the box at top-left corner.

Printing spreadsheet

• File → Print OR Press Ctrl + P
• Select printer name → select range of pages → select number of copies → OK

Session 3: Working with Data and Formatting Text

Ways to perform calculations:

• Add Values Directly: Type =73+89+78 → Enter → Result shown.
• Use Cell Addresses: Type =B2+C2+D2 → auto-updates if data changes.
• Select Cells with Mouse: Type = → Click cell → + → Click next cell → Enter.
• Use Function (For exp SUM()): Type =SUM(B2:D2) → Press Enter → Calculates total.

Copying and Moving Formula

• After writing one formula, it can be used for other rows easily.
• Copy (Ctrl+C) or Cut (Ctrl+X) the cell with formula.
• Paste (Ctrl+V) into the next cell.
• Cell references change automatically (called relative referencing).

Formatting Cells & Text

• Change Font Style/Size: Select text → Choose font & size from toolbar.
• Align Text: Use toolbar icons to Left, Center, or Right align.

Highlight Text

Importance of Formatting

• Makes spreadsheet neat, readable, and professional.
• Highlights important data clearly.
• Improves the presentation of spreadsheet reports.

Session 4: Advanced Features in Spreadsheet

Sorting Data

• Sorting means arranging data in a specific order (alphabetical or numerical).
• Steps:
  1. Select data range → Click Data → Sort → Choose the column (e.g., Total Marks) and order (Ascending or Descending) → Click OK

Filtering Data

• Filtering displays only specific records from a large dataset.
• Steps:
  1. Click on AutoFilter icon → Drop-down arrows appear in column headers.
  2. Choose column (e.g., Class) → Uncheck unwanted items (e.g., XII-B) → Click OK

Protecting Spreadsheet with Password

• Method 1: Protect Spreadsheet Option
  1. Click Tools → Protect Spreadsheet → Enter and confirm password.
• Method 2: Save As with Password
  1. Click File → Save As → Save with password → Enter password in both boxes → OK.

Session 5: Presentation Software

• Presentation software is widely used to create digital presentations with slides.
• Helps in explaining concepts effectively using visuals.

Advantages

1. More interesting with images, videos, animation, and music.
2. Easy to edit and update.
3. Can be projected to a large audience.
4. Can be printed and distributed to viewers.

Popular Presentation Software

• LibreOffice Impress, Microsoft PowerPoint, OpenOffice Impress, Google Slides, Apple Keynote

Starting LibreOffice Impress

• Type LibreOffice Impress in search bar → Select it from search result → Cancel “Select Template” → Blank presentation opens.

Adding Text

• By default, first slide has two text boxes: Title (Top box), Content (Lower box)
• You can click and type in the boxes to add text.

---

Session 6: Opening, Closing, Saving & Printing

• Saving a Presentation: Click File → Save As →Choose a folder (e.g., Desktop) → Enter a File name (default is “Untitled#”) →  Click Save.
• Opening a Presentation: File → Open → Browse file → Open
• Closing a Presentation: File → Close (Choose Save / Don’t Save / Cancel if prompted)
• Printing a Presentation: File → Print or Ctrl + P →  Select Printer, Number of Copies, All/Selected Slides → OK

Session 7: Working with Slides & Text

• Add a New Slide: Slide → New Slide or Ctrl + M
• Delete a Slide: Slide → Delete Slide or press Del
• Insert Textbox: Insert → Textbox, then type text.

Text Formatting

• Font style: Change from Font Style drop-down.
• Font size: Choose suitable size (e.g., 8, 12, 14, 22). Change from Properties tab.
• Highlighting: Bold, Italic, Underline, Strikethrough from Properties tab.
• Text Alignment: Left, Right, Center, Justify using Paragraph options.
• Text Color/Highlight Color: Choose from Font Color drop-down.

Session 8: Advanced Features

• Inserting Shapes: Insert → Shape → Choose (Arrow, Circle, etc.)
• Inserting Images: Insert → Image →  Select and Open desired image.
• Changing Layout: Layouts tab → Select required layout

Important Shortcut