Class 10 Information Technology: Complete Revision Notes

These short notes cover all five units of the Class 10 IT syllabus, designed for quick revision before exams.

Unit 1: Digital Documentation (Advanced)

Mail Merge

Mail Merge allows you to create personalized bulk documents. It consists of three components:

  • Main document — the template with placeholder fields
  • Data source — the database of recipients
  • Merged document — the final personalized output

Track Changes

Records all edits made in a document, making it essential for collaborative work and review processes.

Unit 2: Electronic Spreadsheet (Advanced)

Key Functions

  • SUM() — adds values in a range
  • AVERAGE() — calculates the mean
  • COUNT() — counts numeric entries
  • MAX() / MIN() — finds highest/lowest values

Cell Referencing

  • Relative (A1): Changes when copied
  • Absolute ($A$1): Remains fixed when copied
  • Mixed (A$1, $A1): Partially fixed

Charts & Data Management

Types include Bar charts, Pie charts, and Line charts. Sorting arranges data in order, while Filtering displays only selected data.

Unit 3: Database Management System (DBMS)

Database Basics

  • Database: An organized collection of data
  • Table components: Fields (columns) and Records (rows)
  • Primary Key: Unique identifier for each record
  • Foreign Key: Links two tables together

SQL Basics

  • SELECT — retrieve data from a table
  • INSERT — add new data
  • UPDATE — modify existing data
  • DELETE — remove data

Unit 4: Web Applications & Security

Internet Basics

The internet is a network of networks using TCP/IP protocol. Web browsers (like Chrome) are used to access websites.

Cyber Safety

  • Use strong, unique passwords
  • Avoid sharing personal information online
  • Use antivirus software

Cybercrime Types

Hacking, phishing, and identity theft are common threats. Protection measures include firewalls, antivirus software, and encryption.

Unit 5: Employability Skills

  • Communication Skills: Verbal and non-verbal communication, active listening
  • Self-Management: Self-awareness, goal setting, time management
  • ICT Skills: Basic computer operations and internet usage
  • Entrepreneurial Skills: Risk-taking, creativity, innovation
  • Green Skills: Environmental protection and sustainable development

Exam Tips

  • Practice SQL commands and spreadsheet functions
  • Learn definitions and key terminology
  • Focus on cyber safety concepts — frequently asked

FAQ Questions & Answers for Class 10 Information Technology (IT)

Unit 1: Digital Documentation (Advanced)

Q1. What is a word processor?

A word processor is software used to create, edit, format, and print documents (e.g., LibreOffice Writer, MS Word).

Q2. What is the use of Styles in a document?

Styles help apply consistent formatting (font, size, color) across the document quickly.

Q3. What is a template?

A template is a pre-designed document format used to create new documents quickly.

Q4. What is mail merge?

Mail merge is used to create multiple documents (letters, emails) for different recipients using a single template and data source.

Q5. What is a table of contents (TOC)?

TOC is a list of headings in a document with page numbers for easy navigation.

Unit 2: Electronic Spreadsheet (Advanced)

Q6. What is a spreadsheet?

A spreadsheet is a tool used to organize, calculate, and analyze data in tabular form.

Q7. What is a cell and cell address?

A cell is the intersection of a row and column; its address is its location (e.g., A1, B2).

Q8. What is a formula in a spreadsheet?

A formula is an equation used to perform calculations (e.g., =A1+B1).

Q9. What is a function?

A function is a predefined formula (e.g., SUM(), AVERAGE(), COUNT()).

Q10. What is conditional formatting?

It automatically formats cells based on specific conditions.

Unit 3: Database Management System (DBMS)

Q11. What is a database?

A database is an organized collection of data.

Q12. What is DBMS?

DBMS (Database Management System) is software used to create and manage databases.

Q13. What is a table in DBMS?

A table stores data in rows and columns.

Q14. What is a primary key?

A primary key uniquely identifies each record in a table.

Q15. What is a query?

A query is used to retrieve specific data from a database.

Unit 4: Web Applications and Security

Q16. What is the Internet?

The Internet is a global network connecting computers worldwide.

Q17. What is a web browser?

A web browser is software used to access websites (e.g., Chrome, Firefox).

Q18. What is a URL?

URL (Uniform Resource Locator) is the address of a webpage.

Q19. What is cyber safety?

Cyber safety refers to safe and responsible use of the internet.

Q20. What is phishing?

Phishing is a cyber attack to steal personal information through fake emails or websites.

Unit 5: Employability Skills

Communication Skills

Q21. What is communication?

Communication is the exchange of information between people.

Q22. What are verbal and non-verbal communication?

Verbal uses words; non-verbal uses gestures, expressions, and body language.

Self-Management Skills

Q23. What is self-management?

It is the ability to control one's behavior, time, and emotions.

ICT Skills

Q24. What is ICT?

ICT stands for Information and Communication Technology.

Entrepreneurial Skills

Q25. Who is an entrepreneur?

An entrepreneur is a person who starts and manages a business.

Green Skills

Q26. What are green skills?

Skills that help protect the environment and promote sustainability.

Important Revision Questions

Q27. What is the difference between data and information?

Data is raw facts; information is processed data.

Q28. What is software?

Software is a set of programs used to operate a computer.

Q29. What is hardware?

Hardware refers to physical parts of a computer.

Q30. What is an operating system?

An OS manages computer hardware and software resources.

Keywords: Class 10 IT notes, information technology, DBMS MySQL, spreadsheet functions, mail merge, cyber safety, SQL basics, employability skills, IT board exam