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