CLASS X

Information Technology Notes

ICT Skills Notes -
1. Introduction to Word Processing
• Word Processing: The process of creating, editing, formatting, and printing text documents
using software.
• Examples: LibreOffice Writer, MS Word, Google Docs.

Features of a Word Processor

• Easy editing (insert, delete, copy, paste text).
• Formatting tools (fonts, colors, styles).
• Spell-check and grammar check.
• Insert tables, pictures, charts, and symbols.
• Page layout and printing options.
• Auto-correct and auto-complete.

Software Packages for Word Processing

• LibreOffice Writer (Free & Open-source).
• MS Word (Commercial, part of MS Office).
• Google Docs (Online, cloud-based).

Introduction to LibreOffice Writer

• Free and open-source software.
• Works on Windows, Linux, and macOS.
• File extension: .odt (Open Document Text).

Opening and Exiting the Word Processor

❌
• Open: Start → Programs → LibreOffice Writer.
• Exit: File → Exit OR click close button.

Word Wrap and Alignment

• Word Wrap: Text automatically moves to the next line when it reaches the right margin.
 • Alignment: Positioning of text in a document.
• Left Align (default)
• Right Align
• Center Align
• Justify

Header and Footer

• Header: Text/graphics appearing at the top of each page.
• Footer: Text/graphics appearing at the bottom of each page.
• Commonly used for page numbers, date, document title.

Saving a Document in Various Formats

• Default format: .odt (LibreOffice Writer).

• Other formats: .docx (MS Word), .pdf, .txt.

• File → Save As → Choose file format.

2. Introduction to Spreadsheet Applications

• Spreadsheet: A software application to organize data in rows and columns.
• Used for calculations, data analysis, and charts.

Various Spreadsheet Applications

• LibreOffice Calc
• MS Excel
• Google Sheets

Opening a Workbook and Entering Data

• Open: Start → LibreOffice Calc.
• Workbook: A file containing one or more worksheets.
• Entering data: Click a cell → Type → Press Enter.

Sorting Data
• Sorting: Arranging data in ascending or descending order.
• Example: Sorting student names alphabetically.
Formulas and Functions
• Formula: A mathematical expression. Always begins with =.

• Example: =A1+B1

• Function: Predefined formula.

• Example: =SUM(A1:A5) → adds values.

• Other functions: AVERAGE, MIN, MAX.

Saving a Spreadsheet in Various Formats

• Default format: .ods (LibreOffice Calc).

• Other formats: .xlsx (Excel), .csv (Comma-separated values), .pdf.

3. Introduction to Presentation Software

• Presentation Software: Used to create slideshows with text, images, and multimedia.
• Helps in effective communication.

Packages for Presentation

• LibreOffice Impress
• MS PowerPoint
• Google Slides

Creating a New Presentation

• Open Impress → Choose Template/Blank Presentation.
• Add slides → Insert text, pictures, charts.

Inserting Clip Art and Images

• Insert → Picture/Clip Art → Select file/image.
• Used to make slides attractive.

Slide Layouts
• Predefined formats for slides.
• Examples: Title Slide, Title + Content, Two Column, Blank Slide.

Saving Presentations
• Default format: .odp (LibreOffice Impress).

• Other formats: .pptx (MS PowerPoint), .pdf.

Printing a Presentation
• File → Print.
• Options: Print full slides, handouts, notes pages, or outline.

ICT Skills – Practise Q&A

A. Very Short Answer Questions
1. Q: What is word processing?
A: Word processing is the process of creating, editing, formatting, and printing text
documents using software such as LibreOffice Writer or MS Word.
2. Q: What is the default file extension of LibreOffice Writer?
A: .odt

3. Q: Define word wrap.

A: Word wrap is the feature that automatically shifts text to the next line when it reaches the
right margin.
4. Q: Name two spreadsheet software applications.
A: MS Excel and LibreOffice Calc.
5. Q: What does a workbook contain?
A: A workbook contains one or more worksheets.
6. Q: Which symbol is always used to begin a formula in a spreadsheet?
A: = (equals sign).

7. Q: What is the default file extension of LibreOffice Impress?

A: .odp

B. Short Answer Questions (2–3 Marks)

1. Q: List any three features of a word processor.
A:
• Spell-check and grammar check.
• Inserting images, tables, and charts.
• Formatting tools such as font styles, colors, and alignment.
2. Q: What is the difference between header and footer?
A:
• Header: Appears at the top of every page in a document.
• Footer: Appears at the bottom of every page in a document.
 3. Q: Write two differences between formula and function in spreadsheets.
A:
• A formula is a user-defined calculation (e.g., =A1+B1), while a function is a
predefined formula (e.g., =SUM(A1:A5)).

• A formula is written by the user, while a function is provided by the software.

4. Q: What is a slide layout? Give one example.
A: A slide layout is a predefined format that decides how text, images, and objects are
arranged on a slide. Example: Title Slide, Title + Content.

C. Long Answer Questions (4–5 Marks)

1. Q: Explain the steps to save a document in LibreOffice Writer in different formats.
A:
• Click on File → Save As.
• Type the file name.
• In the Save as type dropdown, choose the desired format (e.g., .odt, .docx,
.pdf).

• Click Save.
2. Q: Write the steps to sort data in LibreOffice Calc.
A:
• Select the range of data to be sorted.
• Go to Data → Sort.
• Choose ascending or descending order.
• Click OK.
3. Q: What are the uses of presentation software?
A:
• Used for preparing slideshows to present ideas.
• Helps in effective teaching, business meetings, and seminars.
• Allows use of text, images, audio, video, and animations.
4. Q: Write the difference between LibreOffice Writer, Calc, and Impress.
A:
• Writer: Word processing (documents, reports, letters).
• Calc: Spreadsheet application (calculations, charts, data analysis).
• Impress: Presentation software (slideshows, seminars).
📘 Entrepreneurial Skills –
1. Characteristics of a Successful Entrepreneur
• Innovative and creative.
• Self-motivated and confident.
• Willing to take risks.
• Good decision-making ability.
• Persistent and hardworking.
• Good communication and leadership skills.

2. Key Characteristics of a Successful Entrepreneur

1. Initiative – Takes the first step in doing things.
2. Risk-taking – Ready to face uncertainty.
3. Innovative – Brings new ideas/products/services.
4. Goal-oriented – Works with a clear vision.
5. Hardworking & Persistent – Never gives up easily.
6. Leadership – Can guide and motivate a team.
7. Decision-making ability – Makes quick and effective choices.

3. Entrepreneurship and Society

• Generates employment opportunities.
• Contributes to economic development.
• Promotes innovation and technology.
• Improves standard of living.
• Creates wealth for the nation.

4. Qualities and Functions of an Entrepreneur

Qualities:
• Creativity, vision, self-confidence, adaptability, patience.
Functions:
• Identifying business opportunities.
• Arranging resources (money, people, materials).
• Managing and organizing the business.
• Taking decisions and risks.
• Marketing and promoting products.

5. Characteristics of Entrepreneurship
• Innovation and creativity.
• Risk-bearing.
• Resource mobilization.
• Organization and management.
• Goal-oriented activity.
• Dynamic and competitive process.

6. Role and Importance of an Entrepreneur

• Brings new ideas to market.
• Provides jobs to others.
• Contributes to GDP and development.
• Solves customer problems with new products/services.
• Encourages other businesses to grow.

7. Common Myths about Entrepreneurship

❌
❌
• Entrepreneurs are born, not made (Truth: Skills can be learned).

❌
• Entrepreneurs are always rich (Truth: Many struggle in the beginning).

❌
• Entrepreneurs work only for money (Truth: They also work for passion and innovation).
• Entrepreneurship is risky and always fails (Truth: Proper planning reduces risks).

8. Entrepreneurship as a Career Option

• Can start own business/startup.
 • Can become self-employed.
• Offers independence and flexibility.
• Opportunity to follow passion.

9. Advantages of Becoming an Entrepreneur

• Independence and freedom.
• Personal satisfaction.
• Financial rewards (profits).
• Recognition and respect in society.
• Opportunity to innovate.

10. Disadvantages of Being an Entrepreneur

• High risk of failure.
• Uncertain income.
• Heavy workload and stress.
• Requires investment and resources.
• Responsibility for employees and business losses.

📘 Entrepreneurial Skills – Q&A

A. Very Short Answer Questions
1. Q: Define entrepreneurship.
A: Entrepreneurship is the process of starting and managing a business by taking risks and
introducing new ideas.
2. Q: Mention any two qualities of a successful entrepreneur.
A: Creativity and self-confidence.
3. Q: State one myth about entrepreneurship.
A: Entrepreneurs are always rich.
4. Q: Write one advantage of becoming an entrepreneur.
A: Independence and freedom.
B. Short Answer Questions (2–3 Marks)
1. Q: List any three functions of an entrepreneur.
A: Identifying opportunities, arranging resources, and managing business.
2. Q: Write two ways entrepreneurship helps society.
A: Creates employment, improves standard of living.
3. Q: Mention two disadvantages of entrepreneurship.
A: Risk of failure and uncertain income.

C. Long Answer Questions (4–5 Marks)

1. Q: Explain the key characteristics of a successful entrepreneur.
A: Initiative, risk-taking, innovation, goal orientation, persistence, leadership, and decision-
making ability.
2. Q: What is the role and importance of entrepreneurs in society?
A: They provide jobs, contribute to GDP, bring innovation, solve customer problems, and
promote national development.
3. Q: Discuss the advantages and disadvantages of becoming an entrepreneur.
A:
• Advantages: Freedom, financial rewards, innovation, recognition.
• Disadvantages: Risk, uncertain income, workload, stress.
Digital Documentation (Advanced) using
LibreOffice

1. Styles in LibreOffice Writer Documents

• A Style is a set of predefined formatting instructions.
• Types of styles:
• Paragraph Styles (applied to whole paragraph)
• Character Styles (applied to selected text)
• Page Styles (page layout, margins, header, footer)
• Frame Styles (frames for images/objects)
• List Styles (numbering, bullets)

Using the Styles and Formatting Window

• Shortcut key: F11
• Used for applying, creating, updating, and managing styles.

2. Paragraph Styles
• Apply formatting to an entire paragraph.
• Includes: alignment, line spacing, borders, shading, indentation.

Applying Paragraph Styles

• Place cursor in paragraph → Select desired style from Styles window.

3. Creating and Updating Styles in LibreOffice Writer

• Styles can be created, modified, and updated.

Creating a New Style from a Selection

• Format text manually → Select text → Styles → New Style from Selection → Name it →
Save.

Loading a Style from a Template or Another Document

• Go to Styles → Load Styles → Select file/template → Import styles.
Creating a New Style Using Drag-and-Drop
• Drag formatted text into the Styles window → Drop → New style created.

4. Modify, Resize, Crop and Delete Images

• Modify: Adjust brightness, contrast, color.
• Resize: Select image → Drag corner handles.
• Crop: Right-click → Crop.
• Delete: Select image → Press Delete.

5. Drawing Shapes and Their Properties

• Shapes: Line, rectangle, ellipse, arrows, callouts, etc.
• Properties: Line color, thickness, fill color, shadow, transparency.

Displaying the Drawing Toolbar

• Go to View → Toolbars → Drawing.

Using the Drawing Toolbar

• Used to insert shapes, text boxes, lines, arrows, and callouts.

Changing Drawing Properties

• Right-click shape → Properties → Change color, border, shadow.

Resizing and Grouping Drawing Objects

• Resize: Drag handles.
• Group: Select multiple → Right-click → Group.

6. Alignment
• Types of alignment for text and objects:
• Left (default)
• Right
• Center
• Justify
7. Anchoring
• Defines how an object (image/shape) is attached to text.
• Options:
• To Page
• To Paragraph
• To Character
• As Character

8. Arrangement
• Controls stacking order of objects.
• Options: Bring to Front, Send to Back, Forward, Backward.

9. Creating and Using Templates

• Template: A pre-designed document used as a base for future documents.

Using Templates in LibreOffice Writer

• File → New → Templates → Select template.

Creating Your Own Template

• Format a document → File → Templates → Save As Template → Save as .ott.

10. Creating a Table of Contents (TOC)

• Automatically generated from heading styles.
• Steps: Insert → Table of Contents and Index → Table of Contents.

Hierarchy of Headings
• Heading 1 → Main topic
• Heading 2 → Sub-topic
• Heading 3 → Sub-sub-topic

Customizing the Table of Contents

• Right-click TOC → Edit Index/Table → Change formatting, levels, tab leaders.
Customizing Paragraph Styles for Headings
• Modify heading styles (fonts, colors, numbering) in Styles window.

Applying Character Styles

• Used to highlight specific text (e.g., Emphasis, Strong Emphasis, Code).

Maintaining a Table of Contents

• Always apply proper heading styles (do not manually format headings).

Updating a Table of Contents

📘
• Right-click TOC → Update Index/Table.

Q&A – Digital Documentation (Advanced)

A. Very Short Answer Questions (1 Mark)

1. Q: Shortcut key to open Styles window?
A: F11.
2. Q: File extension of a template in LibreOffice?
A: .ott

3. Q: Name any two drawing shapes.

A: Rectangle, Ellipse.
4. Q: What is anchoring?
A: Anchoring defines how an object is attached to text or page.
5. Q: Which feature is used to automatically generate a TOC?
A: Heading styles.

B. Short Answer Questions (2–3 Marks)

1. Q: Differentiate between Paragraph Styles and Character Styles.
A:
• Paragraph styles apply to entire paragraphs (alignment, spacing).
• Character styles apply only to selected text (bold, italic, color).
2. Q: Write two steps to resize and crop an image.
A:
• Resize: Select image → Drag corner handles.
• Crop: Right-click image → Crop.
 3. Q: What is the importance of hierarchy of headings?
A: Ensures structured documents and helps in creating/updating TOC.

C. Long Answer Questions (4–5 Marks)

1. Q: Explain the process of creating and using a template in LibreOffice Writer.
A:
• Format a document with required styles/layout.
• File → Templates → Save As Template → Save as .ott.

• To use: File → New → Templates → Select saved template.

2. Q: Describe different anchoring options in LibreOffice Writer.
A:
• To Page: Object stays fixed on page.
• To Paragraph: Object moves with the paragraph.
• To Character: Object linked to specific character.
• As Character: Object behaves like a character in text.
3. Q: Write steps to create and customize a Table of Contents.
A:
• Apply heading styles (Heading 1, Heading 2, etc.).
• Insert → Table of Contents and Index → Table of Contents.
• Right-click TOC → Edit Index/Table → Customize levels, formatting.
• Update TOC regularly using right-click → Update Index/Table.
Electronic Spreadsheet (Advanced) using
LibreOffice Calc

1. Data using Scenarios and Goal Seek

Using Consolidating Data
• Data Consolidation combines data from multiple sheets into one.
• Steps: Data → Consolidate → Select ranges → Function (SUM, AVERAGE, etc.) → OK.

Creating Subtotals
• Subtotals summarize grouped data.
• Steps: Data → Subtotals → Select column → Choose function → OK.

Using "What-if" Scenarios

• Allows testing different values to see how results change.
• Example: Changing interest rates in a loan calculation.

Changing Scenarios
• Use Tools → Scenarios → Select scenario → Apply different set of values.

2. Multiple Operations in Columns or Rows

Calculating with One Formula and One Variable
• Data → Multiple Operations → Select formula cell → Input range for variable → OK.

Calculating with Several Formulas Simultaneously

• Select multiple result cells → Use Multiple Operations → Apply formulas with different
values.

3. Using Goal Seek and Solver

Using Goal Seek
• Finds required input to achieve a desired output.
• Example: To get target profit, find required sales.
• Tools → Goal Seek → Set target cell, input cell, and value → OK.
Using the Solver
• More advanced than Goal Seek.
• Solves equations with multiple conditions/constraints.
• Tools → Solver → Set target, constraints → Solve.

4. Link Spreadsheet Data

Setting up Multiple Sheets
• Each workbook can contain multiple sheets.
• Insert → Sheet → Name sheet.

Inserting New Sheets

• Right-click sheet tab → Insert Sheet.

Creating Reference with the Mouse

• Type = → Go to another sheet → Click cell → Press Enter.

Creating Reference with the Keyboard

• Type: =Sheet2.A1

Reference to Other Documents

• ='[Link]

Relative and Absolute Hyperlinks

• Relative: Link changes if file location changes.
• Absolute: Fixed link to exact location.

Creating Hyperlinks
• Insert → Hyperlink → Enter URL/file location.

Linking to External Data

• Sheet → Link to External Data → Enter URL or file → Select range.

Using the External Data Dialog

• Allows connecting Calc to external files or websites.

Linking to Registered Data Sources

• Tools → Options → LibreOffice Base → Register database → Use in Calc.
5. Share and Review a Spreadsheet
Setting up a Spreadsheet for Sharing
• Tools → Share Document → Enable sharing.

Opening a Shared Spreadsheet

• Shared file can be opened by multiple users simultaneously.

Saving a Shared Spreadsheet

• Changes saved and merged automatically.

Recording Changes
• Edit → Track Changes → Record.

Editing Change Comments

• Right-click → Edit Comment.

Adding Other Comments

• Insert → Comment.

Editing Comments
• Right-click comment → Edit.

Formatting Comments
• Change font, color, and background of comments.

Reviewing Changes – View, Accept or Reject

• Edit → Track Changes → Manage → View changes.
• Accept/Reject selected changes.

6. Merging and Comparing

Merging Documents
• Combine data from different spreadsheets.
• Tools → Merge Documents → Select file.

Comparing Documents
• Tools → Compare Documents → Shows differences between files.
7. Use Macros in Spreadsheet
Using the Macro Recorder
• Tools → Macros → Record Macro.
• Perform steps → Stop recording → Save macro.

Creating a Simple Macro

• Write macro in LibreOffice Basic.
• Example: Formatting cells, inserting values.

Using a Macro as a Function

• Macros can be used like formulas in cells.

Passing Arguments to a Macro

• Macros can accept parameters (like cell ranges, values).

Accessing Cells Directly

• Example in Basic:
[Link](0).getCellByPosition(0,0).String="Hello"

Sorting Columns Using Macro

• Macros can automate sorting tasks instead of manual sorting.

📘 Q&A – Electronic Spreadsheet (Advanced)

A. Very Short Answer Questions (1 Mark)

1. Q: What is data consolidation in Calc?
A: Combining data from multiple sheets into one.
2. Q: Which tool is used to achieve a desired output by changing input?
A: Goal Seek.
3. Q: Shortcut to insert a new sheet?
A: Right-click sheet tab → Insert Sheet.
4. Q: What is the difference between relative and absolute hyperlink?
A: Relative changes with file location, absolute is fixed.
5. Q: What is the purpose of a macro?
A: To automate repetitive tasks.
B. Short Answer Questions (2–3 Marks)
1. Q: Differentiate between Goal Seek and Solver.
A:
• Goal Seek: Works with one input and one output.
• Solver: Works with multiple inputs and constraints.
2. Q: Write two steps to record a macro in LibreOffice Calc.
A: Tools → Macros → Record Macro → Perform actions → Stop recording → Save.
3. Q: How can we review changes in a shared spreadsheet?
A: Edit → Track Changes → Manage → View → Accept/Reject changes.
4. Q: Define “What-if Analysis” with one example.
A: What-if analysis allows users to test different input values to see how they affect results.
Example: Checking how changing interest rates affects loan repayment.
5. Q: Write two advantages of using Solver over Goal Seek.
A:
• Solver can handle multiple variables, Goal Seek only one.
• Solver can apply constraints to values, Goal Seek cannot.
6. Q: How is linking to external data useful in spreadsheets?
A: It allows importing live or updated data from external files/websites so that calculations
always use the latest information.
7. Q: Differentiate between comments and change tracking in Calc.
A:
• Comments: Notes added to cells for clarification.
• Change tracking: Records who made changes and what was changed.
8. Q: Explain relative vs. absolute hyperlink with examples.
A:
• Relative hyperlink: Changes if the file location changes (e.g.,
../docs/[Link]).

• Absolute hyperlink: Fixed path (e.g., C:/Users/Admin/docs/[Link]).

9. Q: Write steps to consolidate sales data from multiple regions into one sheet.
A:
• Open target sheet.
• Go to Data → Consolidate.
• Select ranges from different sheets.
• Choose function (SUM/AVERAGE).
• Press OK.
 10.Q: How can you insert a reference from another document in Calc?
A:
• Type = in a cell.

• Navigate to other file → Select cell → Press Enter.

OR
• Use formula: ='[Link]

11.Q: What are macros? Give two uses in real-life spreadsheet work.
A: Macros are recorded/created instructions to automate tasks.
• Example 1: Automatically formatting tables.
• Example 2: Generating monthly reports.
12.Q: Write the steps to record a macro in LibreOffice Calc.
A:
• Tools → Macros → Record Macro.
• Perform desired actions.
• Stop recording.
• Save macro with name.
13.Q: Explain how to merge two spreadsheet documents.
A:
• Open base spreadsheet.
• Tools → Merge Documents.
• Select second spreadsheet.

C. Long Answer Questions (4–5 Marks)

1. Q: Explain the process of linking data between multiple sheets in LibreOffice Calc.
A:
• Insert new sheet.
• In target sheet, type = → Switch to source sheet → Select cell → Press Enter.

• Alternatively, use formula =Sheet2.A1.

2. Q: Describe steps to create and use "What-if" scenarios.

A:
• Go to Tools → Scenarios.
• Select changing cells and define values.
• Save with scenario name.
 • Switch between scenarios to see effects.
3. Q: What are macros? Explain their advantages with examples.
A:
• A macro is a recorded/created program that automates tasks.
• Advantages: Saves time, reduces errors, automates repetitive jobs.
• Example: A macro that formats all headings in bold automatically.
4. Q: Describe the process of creating, applying, and modifying a scenario in Calc with an
example.
A:
• Tools → Scenarios → Select range → Enter values → Save with name.
• Apply scenario by selecting it from the list.
• Modify by editing values or adding notes.
• Example: Sales forecast with different discount rates.
5. Q: Explain step-by-step how to use Goal Seek to calculate required marks to reach a target
percentage in exams.
A:
• Enter formula for percentage.
• Tools → Goal Seek.
• Select target cell (percentage).
• Enter target value (e.g., 75%).
• Select variable cell (marks to be changed).
• Click OK → Required marks displayed.
6. Q: Describe the steps for sharing a spreadsheet and tracking changes made by other users.
A:
• Tools → Share Document → Enable sharing.
• Multiple users can open and edit file.
• Edit → Track Changes → Record.
• Changes are highlighted.
• Edit → Track Changes → Manage → Accept/Reject.
7. Q: Discuss how macros can improve productivity in spreadsheet work with at least two
detailed examples.
A:
• Automates repetitive tasks → saves time.
• Reduces errors by using consistent commands.
 • Example 1: Macro to format all headings bold and center aligned.
• Example 2: Macro to generate charts automatically after data entry.
8. Q: Explain the difference between linking spreadsheet data within sheets, between
documents, and linking to external data sources. Give one example each.
A:
• Within sheets: =Sheet2.A1 → Refers to another sheet in same workbook.

• Between documents: ='[Link] → Refers

to another file.
• External data sources: Tools → Link to External Data → Connect to
database/website for live data.
9. Q: Compare and contrast the use of Solver and Multiple Operations in spreadsheet problem-
solving.
A:
• Solver: Optimizes values with multiple constraints, used for complex problems (e.g.,
maximize profit).
• Multiple Operations: Tests different input values with formulas, useful for
sensitivity analysis.
• Solver gives one optimized solution, Multiple Operations gives a table of outcomes.