CBSE Class 10 Board Exam Information Technology (Skill Subject 402) Syllabus

Name the main categories/types of styles in a word processor like LibreOffice Writer.

Paragraph styles, Character styles, Page styles, List (numbering) styles, and Frame styles.

What is one major advantage of using styles instead of manual formatting?

Styles ensure consistent formatting throughout the document and allow you to change the look of all similarly styled text at once by editing the style.

How can you apply a style quickly in Writer using the Styles window?

Select the text/place the cursor, open the Styles window (F11) or the styles drop-down, and double-click the desired style to apply it.

In a word processor, what is the difference between 'inline' and 'floating' image anchoring?

An inline image is anchored as a character and moves with the text; a floating image is anchored to a paragraph/page/character and text wraps around it while it can be positioned freely.

What is 'text wrapping' for an image in a document?

Text wrapping controls how the document text flows around an inserted image, e.g., None, Page wrap (around), Optimal, Wrap through, or Before/After.

How do you insert an image from a file in LibreOffice Writer?

Use Insert > Image, browse to and select the image file, then click Open/Insert.

What is a template in a word processor?

A template is a pre-designed document with fixed layout, styles and formatting that serves as a starting pattern for creating new documents (e.g., letters, resumes, reports).

What is the main benefit of using templates?

Templates save time and ensure a consistent, standardized layout and formatting across many similar documents.

How do you create a document from a template in LibreOffice?

Use File > New > Templates (or File > Templates > Manage), select the desired template, and open it to create a new document based on it.

What is a Table of Contents (TOC) in a document?

A Table of Contents is an automatically generated, ordered list of the document's headings with their page numbers, used for easy navigation.

What must be applied to text before an automatic Table of Contents can be generated?

Heading styles (e.g., Heading 1, Heading 2) must be applied to the section titles so the TOC can pick them up.

What is Mail Merge?

Mail Merge is a feature that combines a main document (with fixed text) and a data source (list of recipients) to produce many personalized copies, such as letters, labels or emails.

Name the two main components required for a Mail Merge.

1) The main/form document with fixed content and merge fields, and 2) the data source (database/spreadsheet) containing the variable recipient data.

In a spreadsheet, what does 'consolidating data' mean?

Consolidating data means combining and summarizing data from multiple ranges or sheets into a single summary using a function such as Sum, Average, Count, Max or Min.

What spreadsheet tool lets you quickly summarize and analyze large data sets by grouping/rearranging fields?

A Pivot Table (called Pivot Table / DataPilot in LibreOffice Calc).

What is a 'scenario' in a spreadsheet?

A scenario is a saved set of input (changing) cell values used in what-if analysis to compare different possible outcomes without re-entering data.

What is Goal Seek used for in a spreadsheet?

Goal Seek finds the required input value in one cell that will make a formula cell produce a specified target/result (backward what-if analysis).

Give the syntax and purpose of the IF function.

=IF(condition, value_if_true, value_if_false). It returns one value if the logical condition is TRUE and another if it is FALSE.

What do the AND and OR logical functions do?

AND returns TRUE only if all conditions are TRUE; OR returns TRUE if at least one condition is TRUE.

What does the COUNTIF function do? Give its syntax.

COUNTIF counts the number of cells in a range that meet a given condition. Syntax: =COUNTIF(range, criteria).

What do the statistical functions AVERAGE, MAX and MIN return?

AVERAGE returns the mean of a range, MAX returns the largest value, and MIN returns the smallest value in a range.

What is the difference between SUM and SUMIF?

SUM adds all values in a range; SUMIF adds only the values that satisfy a specified condition: =SUMIF(range, criteria, sum_range).

What does 'linking data' between spreadsheets/cells mean?

Linking data uses references so a cell automatically reflects (and updates with) data stored in another cell, sheet or file - changes in the source update the link.

What is the benefit of sharing a spreadsheet?

Sharing a spreadsheet allows multiple users to view and edit the same workbook simultaneously, supporting collaboration.

What is a macro in a spreadsheet/office application?

A macro is a recorded or programmed sequence of commands/actions that can be saved and replayed to automate repetitive tasks.

Define a database.

A database is an organized collection of related data stored so that it can be easily accessed, managed, retrieved and updated.

What does DBMS stand for and what is it? Give an example.

DBMS = Database Management System: software used to create, store, manage, retrieve and manipulate data in a database. Examples: LibreOffice Base, MySQL, MS Access, Oracle.

In a database table, what is a field and what is a record?

A field is a single column that stores one type of attribute (e.g., Name); a record is a complete row containing all field values for one entity (e.g., one student).

What is a primary key in a database table?

A primary key is a field (or set of fields) that uniquely identifies each record in a table; it cannot be duplicate or null.

Name four common data types used when creating database fields.

Text/Varchar, Number/Integer, Date/Time, Boolean (Yes/No), and Currency/Decimal.

In a DBMS, what is the difference between a Query, a Form and a Report?

A Query retrieves/filters specific data from tables; a Form provides a user-friendly interface to enter and view data; a Report presents and formats data for printing/output.

What are accessibility options on a computer and who are they for?

Accessibility options are built-in settings that make a computer easier to use for people with disabilities, e.g., screen magnifier, on-screen keyboard, narrator, high contrast, and sticky keys.

What is assistive technology? Give two examples.

Assistive technology is hardware/software that helps people with disabilities perform tasks. Examples: screen readers, screen magnifiers, on-screen keyboards, Braille displays, and speech-recognition software.

What is a computer network?

A computer network is a group of two or more computers/devices connected together to share data, resources (printers, files) and communication.

State the difference between LAN and WAN.

A LAN (Local Area Network) connects devices over a small area such as a building; a WAN (Wide Area Network) connects devices over large geographical areas, e.g., the Internet.

What is instant messaging (IM)? Give one example.

Instant messaging is real-time text-based communication between two or more people over a network/internet. Examples: WhatsApp, Google Talk, Skype, Telegram.

What is a blog?

A blog is a regularly updated website or web page, usually run by an individual or small group, where entries (posts) are written in an informal or conversational style, shown newest first.

What is an online transaction?

An online transaction is the buying/selling of goods or services or transfer of money carried out over the internet using electronic payment methods.

Name two common modes of online payment.

Credit/debit cards, net banking, UPI, digital wallets (e-wallets), and cash on delivery (COD).

What is internet security?

Internet security is the practice of protecting computers, networks, data and users from online threats such as viruses, hackers, malware and theft of information.

List three safe browsing / online safety practices.

Use strong unique passwords, do not share personal/financial information with unknown sites, look for HTTPS/padlock on secure sites, avoid clicking suspicious links, and keep antivirus updated.

What is malware? Name two types.

Malware is malicious software designed to harm or gain unauthorized access to a computer. Types: virus, worm, Trojan horse, spyware, and ransomware.

What does 'https' indicate when browsing a website?

HTTPS (Hyper Text Transfer Protocol Secure) indicates the connection to the website is encrypted and secure, protecting data exchanged between the user and the site.