Grade VIII

August


Grade VIII

Chapter 1: OpenShot Video Editor

Learn the fundamentals of video editing using OpenShot Video Editor. Explore the workspace, import media, arrange clips on a timeline, add transitions, titles, audio and effects, and export a finished video.

🎬 What is Video Editing?

Video editing is the process of selecting, arranging, trimming and improving video and audio clips to create a final video.

Video editing allows us to combine different types of media, such as videos, photographs, music, narration and text.

🎥 What is OpenShot?

OpenShot Video Editor is a video-editing application used to create and edit videos.

It provides tools for working with video clips, images, audio, titles, transitions, animations and visual effects.

🌟 Why Do We Edit Videos?

Raw video recordings may contain unwanted parts, mistakes, pauses or unnecessary scenes.

Editing helps us organise content and communicate a message more clearly and creatively.

🧩 Multimedia

Multimedia means using more than one type of media to present information.

A video project may include:

  • 🎥 Video clips
  • 🖼️ Images
  • 🎵 Music
  • 🎙️ Narration
  • 🔊 Sound effects
  • 🔤 Text and titles

📁 What is a Video Project?

A video project contains information about how media files are arranged and edited.

The project file stores editing information, while the original video, image and audio files remain separate media files.

🖥️ The OpenShot Workspace

The OpenShot window contains different areas that help us organise and edit a video project.

Important parts of the workspace include the Project Files panel, Video Preview, Timeline and editing tools.

📂 Project Files

The Project Files area displays the media files that have been imported into the current project.

These may include video clips, images and audio files.

📥 Importing Media Files

Before editing, media files must usually be imported into the project.

You can import files such as:

  • Video clips
  • Images
  • Music files
  • Recorded narration

⏱️ Understanding the Timeline

The timeline is the main working area where media clips are arranged in time order.

A timeline helps the editor decide:

  • When a clip starts
  • When a clip ends
  • Which clip appears first
  • When audio should play

🛤️ What are Tracks?

A timeline can contain multiple horizontal rows called tracks.

Different tracks can be used to organise different types of media.

For example, one track may contain video while another track contains background music.

🔴 The Playhead

The playhead indicates the current position in the timeline.

When you play the video, the playhead moves across the timeline.

▶️ Video Preview

The Video Preview window allows you to watch your project while editing.

It helps you check the order, timing and appearance of your video.

➕ Adding Clips to the Timeline

After importing a media file, it can be placed on the timeline.

The position of a clip on the timeline determines when it appears or plays in the final video.

↔️ Moving Clips

Clips can be moved along the timeline to change their position.

This helps you arrange scenes in the correct sequence.

✂️ Trimming a Clip

Trimming means removing unwanted parts from the beginning or end of a media clip.

Trimming can make a video shorter and help remove unnecessary pauses or mistakes.

✂️ Splitting a Clip

A long clip can be divided into smaller parts.

Splitting allows an editor to remove or rearrange a section from the middle of a video.

🗑️ Deleting a Clip

A clip that is no longer required can be removed from the timeline.

Removing a clip from the project timeline does not normally mean deleting the original media file from the computer.

🖼️ Adding Images

Images can be added to a video project to create slideshows, introductions, explanations or visual presentations.

The duration of an image on the timeline can be adjusted.

🎵 Adding Audio

Audio can make a video more interesting and informative.

A project may include:

  • Background music
  • Voice narration
  • Sound effects
  • Recorded dialogue

🔊 Adjusting Audio Volume

The volume of an audio clip can be adjusted to make the sound louder or quieter.

Background music should not overpower important narration or dialogue.

🎚️ Fade In and Fade Out

A fade in gradually increases the visibility or volume of a clip.

A fade out gradually decreases the visibility or volume until it disappears or becomes silent.

🔄 Transitions

A transition controls how one clip changes into another clip.

Transitions can make the change between scenes smoother.

Common examples include fades and other visual transition effects.

🔤 Adding Titles

Titles are text elements added to a video.

Titles can be used for:

  • Video names
  • Introductions
  • Headings
  • Captions
  • Credits

✨ Video Effects

Effects can change the appearance or behaviour of video clips.

Effects should be used carefully so that they improve the video instead of distracting the audience.

🎞️ Animation

Animation can be used to create movement in a video project.

For example, an image or text object can be made to move, appear or change position over time.

📚 Working with Multiple Layers

Multiple tracks can be used to create layered video projects.

For example, a video can appear on one track while text or an image is placed on another track.

📤 Exporting a Video

After completing the editing process, the project can be exported or rendered as a video file.

The exported file can then be played using a media player or shared through suitable platforms.

⚙️ What is Rendering?

Rendering is the process of converting the edited project into a finished video file.

During rendering, the video editor combines clips, audio, transitions, titles and effects according to the timeline.

📹 Video Formats

Videos can be saved in different file formats.

The choice of format may affect file size, quality and compatibility.

A commonly used video file extension is .mp4.

🖥️ Video Resolution

Resolution describes the amount of visual detail represented by the dimensions of a video frame.

Higher resolutions generally contain more pixels and can require more storage space and processing power.

🎞️ Frame Rate

A video is made up of a sequence of still images called frames.

Frame rate describes how many frames are displayed each second.

©️ Copyright and Media

Videos, music, photographs and other creative works may be protected by copyright.

Always use media that you created yourself, have permission to use or are legally permitted to use.

⚖️ Responsible Video Editing

Video editing can change the way an event or person is shown.

Editors should avoid creating misleading or harmful content and should respect the privacy and dignity of other people.

🔄 The Video Editing Workflow

A typical video-editing process can be understood as:

Plan → Collect Media → Import → Arrange → Edit → Preview → Improve → Export

  1. Plan: Decide the purpose and message of the video.
  2. Collect Media: Gather videos, images and audio.
  3. Import: Add media files to the project.
  4. Arrange: Place clips on the timeline.
  5. Edit: Trim, split and organise the clips.
  6. Enhance: Add titles, transitions and audio.
  7. Preview: Watch the video and check for mistakes.
  8. Export: Create the final video file.

🖥️ Important Parts of the OpenShot Workspace

Part Purpose
Project Files Displays imported media files.
Video Preview Shows the current video project.
Timeline Used to arrange clips over time.
Tracks Allow different media elements to be organised in layers.
Playhead Shows the current position on the timeline.
Toolbar Provides access to editing tools and commands.

🧩 Types of Media in a Video Project

Media Type Example Possible Use
Video Video clip Main scenes and recordings.
Image Photograph or graphic Slides, illustrations and backgrounds.
Audio Music or narration Sound, explanation and atmosphere.
Text Title or caption Information and explanation.

✂️ Basic Video Editing Operations

Operation Meaning
Import Add media files to the project.
Move Change the position of a clip on the timeline.
Trim Remove unwanted parts from the beginning or end.
Split Divide one clip into separate parts.
Delete Remove a clip from the timeline.
Duplicate Create another copy of a clip in the project.

🎞️ Understanding a Timeline

TIME  ───────────────────────────────────────────────→

TRACK 3        [ TITLE ]
TRACK 2     [ BACKGROUND MUSIC ───────────────────── ]
TRACK 1  [ VIDEO 1 ][ VIDEO 2 ][ VIDEO 3 ]

                ▲
            PLAYHEAD

The timeline helps an editor organise different types of media and control exactly when they appear or play.

📹 Important Video Properties

Property Meaning
Resolution The dimensions and amount of visual detail in a video frame.
Frame Rate The number of video frames displayed per second.
Duration The total length of the video.
File Size The amount of storage space required by the file.
Format The type of video file, such as an MP4 file.

🎯 Activity: Create a 30-Second Video

Create a short video on a topic of your choice.

Possible topics include:

  • 🏫 My School
  • 🌍 Save the Environment
  • 🤖 Robotics in Daily Life
  • 💻 A Day in the Computer Lab
  • 📚 My Favourite Subject

Your video should include:

  1. At least two video clips or images.
  2. A suitable title.
  3. At least one transition.
  4. Background music or narration.
  5. Proper trimming of unwanted parts.
  6. A final exported video.

🚀 Mini Project: School Event Highlights

Create a short highlights video for a school activity or event.

Follow these steps:

  1. Collect suitable photographs and video clips.
  2. Create a new OpenShot project.
  3. Import all required media.
  4. Arrange clips in the correct sequence.
  5. Trim unnecessary sections.
  6. Add a title at the beginning.
  7. Add captions where necessary.
  8. Add suitable background audio.
  9. Add transitions carefully.
  10. Preview the complete video.
  11. Export the final video.

✨ Good Video Editing Practices

  • Plan your video before you begin editing.
  • Keep your media files organised in folders.
  • Save your project regularly.
  • Remove unnecessary footage.
  • Keep transitions simple and meaningful.
  • Make sure titles are easy to read.
  • Balance music and narration properly.
  • Preview the complete project before exporting.
  • Respect copyright and privacy.
  • Use video editing responsibly.

📚 Key Terms

Term Meaning
Video Editing The process of arranging and modifying video and audio content.
OpenShot A video-editing application.
Multimedia The use of multiple forms of media together.
Timeline An area used to arrange media according to time.
Track A horizontal layer on a timeline that can contain media clips.
Playhead An indicator showing the current position on the timeline.
Trim To remove unwanted parts from the beginning or end of a clip.
Split To divide a clip into smaller sections.
Transition An effect controlling the change between clips.
Title Text added to a video project.
Effect A feature that changes the appearance or behaviour of media.
Rendering The process of creating the final video from the edited project.
Resolution The dimensions and visual detail of a video frame.
Frame A single still image in a video sequence.
Frame Rate The number of frames displayed per second.

📝 Chapter Summary

OpenShot Video Editor can be used to create multimedia video projects using video clips, images, audio, titles, transitions and other editing features.

The timeline is an important part of video editing because it helps arrange clips according to time. Tracks allow multiple media elements to be organised in layers.

Editors can trim, split, move and delete clips to improve a video. Audio, titles and transitions can then be added to create a more complete presentation.

Finally, the completed project is rendered or exported as a video file that can be played or shared.

🧠 Quick Check

  1. What is video editing?
  2. What is OpenShot Video Editor?
  3. What is multimedia?
  4. Name four types of media that can be used in a video project.
  5. What is a video project?
  6. What is the purpose of the Project Files panel?
  7. What is a timeline?
  8. What is a track?
  9. What is a playhead?
  10. What is the purpose of the Video Preview window?
  11. What does importing media mean?
  12. What is trimming?
  13. What is splitting?
  14. What is a transition?
  15. Why are titles used in videos?
  16. What is rendering?
  17. What is video resolution?
  18. What is frame rate?
  19. Why should background music be adjusted carefully?
  20. Why is copyright important in video editing?
  21. List the steps involved in creating a video project.
  22. Design a 30-second educational video using OpenShot.

Grade VIII

Chapter 2: Database Management System

Learn how computers organise large amounts of information using databases and Database Management Systems (DBMS). Explore tables, fields, records, keys, queries, forms and reports.

📊 What is Data?

Data is a collection of raw facts and figures that can be stored and processed.

Examples of data include names, roll numbers, marks, phone numbers and dates.

💡 What is Information?

Information is meaningful data that has been organised or processed.

For example, a list of marks is data, while a student's total, percentage and result are useful information created from data.

🗃️ What is a Database?

A database is an organised collection of related data that can be stored, managed and accessed easily.

A school database may store information about students, teachers, classes, attendance, examinations and fees.

❓ Why Do We Need Databases?

Databases help us manage large amounts of information in an organised manner.

They make it easier to store, search, update and retrieve information when required.

💻 What is a DBMS?

DBMS stands for Database Management System.

It is software used to create, store, organise, manage and retrieve data from databases.

🖥️ Examples of DBMS

Common database management systems include:

  • MySQL
  • Microsoft Access
  • Oracle Database
  • PostgreSQL
  • SQLite

📋 What is a Table?

A table is used to store related data in rows and columns.

For example, a Student table may store information about all students in a class.

📝 What is a Record?

A record is a complete collection of information about one item or person in a table.

In a Student table, one row containing information about one student is called a record.

📌 What is a Field?

A field stores one specific type of information about a record.

Examples of fields in a Student table include Name, Roll Number, Class and Date of Birth.

↔️ Rows and Columns

In a database table:

  • A row represents a record.
  • A column represents a field.

🔢 Data Types

A data type specifies the type of data that a field can store.

Choosing the correct data type helps store and process data properly.

🔤 Text Data

Text fields are used to store letters, words and other characters.

Examples include Name, Address and City.

🔢 Number Data

Number fields are used to store numerical values that may be used in calculations.

Examples include Marks, Fees and Quantity.

📅 Date and Time

Date and time fields are used to store dates and time values.

Examples include Date of Birth, Admission Date and Event Date.

☑️ Yes/No Data

A Yes/No field stores one of two possible values.

Examples include:

  • Paid / Not Paid
  • Present / Absent
  • Yes / No
  • True / False

🔑 Primary Key

A primary key is a field, or a combination of fields, that uniquely identifies each record in a table.

For example, a Student ID can uniquely identify each student.

🆔 Unique Identification

Two students may have the same name, but each student can have a different Student ID.

Unique identifiers help avoid confusion when working with records.

🔗 Database Relationships

Different tables in a database can be connected through related fields.

For example, a Student table and an Attendance table may both use Student ID to connect information.

🔄 One-to-Many Relationship

A one-to-many relationship occurs when one record in one table can be related to several records in another table.

For example, one student can have many attendance records.

🔍 What is a Query?

A query is used to ask the database for specific information.

For example, we may want to find all students who scored more than 80 marks.

🔎 Searching Data

Searching helps us locate specific records from a large collection of data.

For example, a school administrator may search for a student using the student's admission number.

↕️ Sorting Data

Sorting means arranging data in a particular order.

Data can often be sorted in ascending or descending order.

🎯 Filtering Data

Filtering displays only those records that match specific conditions.

For example, a filter can display only students from Grade VIII.

📄 What is a Form?

A form provides a user-friendly way to enter, view or modify data.

Forms can make data entry easier than directly working with a large table.

📑 What is a Report?

A report presents database information in an organised format.

Reports are often used to view, share or print selected information.

⚙️ Basic Database Operations

Common operations performed on data include:

  • Create
  • Read
  • Update
  • Delete

These operations are commonly remembered as CRUD.

✅ Data Validation

Data validation helps ensure that entered data follows expected rules.

For example, a Marks field should contain a valid numerical value.

📦 Data Redundancy

Data redundancy means unnecessary repetition of the same data.

A well-designed database attempts to organise data efficiently and reduce unnecessary duplication.

🔐 Database Security

Databases can contain important and private information.

Security measures can help control who is allowed to view, add, change or delete data.

💾 Database Backup

A backup is a copy of important data that can help recover information if the original data is lost or damaged.

📊 Data vs Information

Data Information
Raw facts and figures. Processed and meaningful data.
May not be useful by itself. Helps in understanding and decision-making.
Example: 75, 80, 90 Example: Average marks = 81.67

🗃️ Understanding a Database Table

Student_ID Name Class Marks
101 Aarav VIII 87
102 Diya VIII 92
103 Kabir VIII 78

In the table above:

  • Student_ID, Name, Class and Marks are fields.
  • Each horizontal row is a record.
  • Each vertical column represents a field.
  • Student_ID can be used as the primary key.

🧩 Important Database Components

Component Purpose
Table Stores related data in rows and columns.
Field Stores one type of information.
Record Stores complete information about one item.
Primary Key Uniquely identifies each record.
Query Retrieves specific information from the database.
Form Provides an interface for entering or viewing data.
Report Presents selected information in an organised format.

🔢 Common Data Types

Data Type Example Possible Use
Text Anant Name, Address
Number 85 Marks, Quantity
Date/Time 15-08-2026 Date of Birth, Admission Date
Yes/No Yes Paid, Present, Active

🔑 Why Do We Need a Primary Key?

Consider the following records:

Student_ID Name
101 Rahul
102 Rahul

Both students have the same name, but their Student_ID values are different. Therefore, the Student_ID can uniquely identify each record.

🔍 Example of a Database Query

Suppose a Student table contains the following information:

Name Class Marks
Aarav VIII 87
Diya VIII 92
Kabir VIII 78

A query can ask:

Show all students who scored more than 80 marks.

The database would return Aarav and Diya.

🔄 How a DBMS Works

A simple database workflow can be represented as:

User → DBMS → Database → Result

  1. The user enters, searches or requests information.
  2. The DBMS processes the request.
  3. The DBMS accesses the required data.
  4. The requested information is displayed to the user.

⚙️ CRUD Operations

Operation Meaning Example
Create Add new data. Add a new student record.
Read View or retrieve data. Display a student's details.
Update Modify existing data. Change a student's address.
Delete Remove data. Delete an incorrect record.

✨ Advantages of a DBMS

  • Organises large amounts of data.
  • Makes searching faster and easier.
  • Allows data to be updated efficiently.
  • Supports sorting and filtering.
  • Can reduce unnecessary data duplication.
  • Provides security and access controls.
  • Supports data backup and recovery.
  • Helps generate useful reports.

🎯 Activity: Design a Student Database

Imagine that you have to create a database for your school.

Design a Student table with suitable fields.

Field Name Data Type Purpose
Student_ID Number/Text Unique student identification.
Name Text Stores the student's name.
Class Text Stores the class or grade.
Date_of_Birth Date/Time Stores the date of birth.
Marks Number Stores examination marks.

🚀 Mini Project: School Library Database

Design a simple database for a school library.

Your database may include the following tables:

  • 📚 Books
  • 👨‍🎓 Students
  • 📖 Book_Issues

Think about the following questions:

  1. What information should be stored about each book?
  2. What field can uniquely identify a book?
  3. What information should be stored about students?
  4. How can issued books be connected to students?
  5. What queries might a librarian need?

🔐 Good Database Practices

  • Choose meaningful names for tables and fields.
  • Select suitable data types.
  • Use a primary key where appropriate.
  • Enter data carefully and accurately.
  • Avoid unnecessary duplication of data.
  • Use validation rules when needed.
  • Protect confidential information.
  • Take regular backups of important databases.
  • Provide access only to authorised users.

📚 Key Terms

Term Meaning
Data Raw facts and figures.
Information Meaningful data that has been processed or organised.
Database An organised collection of related data.
DBMS Software used to create and manage databases.
Table A structure that stores related data in rows and columns.
Record A complete set of information about one item in a table.
Field A column that stores one type of information.
Primary Key A field or combination of fields that uniquely identifies a record.
Data Type Specifies the type of data that a field can store.
Query A request for specific information from a database.
Form An interface used for entering or viewing data.
Report An organised presentation of database information.
Sort Arrange data in a particular order.
Filter Display records that match specific conditions.
Validation Checking whether entered data follows required rules.
Backup A copy of data kept for recovery purposes.

📝 Chapter Summary

A database is an organised collection of related data, while a Database Management System (DBMS) is software used to create and manage databases.

Data in a database is commonly organised into tables. A table contains fields (columns) and records (rows). A primary key helps uniquely identify each record.

DBMS software allows users to perform operations such as creating, reading, updating and deleting data. Users can also search, sort and filter information.

Queries retrieve specific information, forms make data entry easier and reports present information in an organised format.

Good database management also involves validation, security, efficient organisation and regular backups.

🧠 Quick Check

  1. What is data?
  2. What is information?
  3. What is a database?
  4. Why do we need a database?
  5. What does DBMS stand for?
  6. Name any two DBMS applications.
  7. What is a table?
  8. What is a record?
  9. What is a field?
  10. What is the difference between a row and a column?
  11. What is a data type?
  12. Name four common data types.
  13. What is a primary key?
  14. Why must a primary key be unique?
  15. What is a database relationship?
  16. What is a one-to-many relationship?
  17. What is a query?
  18. What is sorting?
  19. What is filtering?
  20. What is a form?
  21. What is a report?
  22. What does CRUD stand for?
  23. What is data validation?
  24. What is data redundancy?
  25. Why is database security important?
  26. What is a database backup?
  27. Design a Student table with five suitable fields.
  28. Suggest a suitable primary key for a school database and explain why.
  29. Write three queries that could be useful in a school database.

Grade VIII

Chapter 3: Structured Query Language

Learn how Structured Query Language (SQL) is used to communicate with a database. Explore basic SQL commands for creating tables, inserting, viewing, searching, updating and deleting data.

💻 What is SQL?

SQL stands for Structured Query Language.

SQL is a language used to communicate with and manage relational databases.

🎯 Why Do We Use SQL?

SQL helps users work with data stored in a database.

Using SQL, we can create tables, add records, view information, search for specific data, modify records and delete data.

🗃️ SQL and Databases

A database stores organised data, while SQL provides commands for working with that data.

A user sends an SQL command to the database system, and the database processes the command and returns a result.

🔍 What is a Query?

A query is a request for information or an instruction given to a database.

SQL queries can be used to retrieve or manipulate data.

⌨️ SQL Commands

SQL commands are instructions written to perform specific operations on a database.

Examples include:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • CREATE

🔤 SQL Keywords

Words with special meanings in SQL are called keywords.

Examples include SELECT, FROM, WHERE, INSERT and UPDATE.

📋 Working with Tables

Data in a relational database is commonly stored in tables.

Each table contains rows called records and columns called fields.

🔚 The Semicolon (;)

A semicolon is commonly used to indicate the end of an SQL statement.

For example:

SELECT * FROM Students;

📖 SELECT Command

The SELECT command is used to retrieve data from a table.

SELECT * FROM Students;

The symbol * means all columns.

🎯 Selecting Specific Columns

We can select only the columns that we need.

SELECT Name, Marks
FROM Students;

This command displays only the Name and Marks columns.

📂 FROM Clause

The FROM clause specifies the table from which data should be retrieved.

SELECT * FROM Students;

Here, Students is the name of the table.

🔎 WHERE Clause

The WHERE clause is used to select records that satisfy a particular condition.

SELECT * FROM Students
WHERE Class = 'VIII';

⚖️ Comparison Operators

Conditions in SQL can use comparison operators.

  • = Equal to
  • > Greater than
  • < Less than
  • >= Greater than or equal to
  • <= Less than or equal to
  • <> Not equal to

➕ AND Operator

The AND operator combines two or more conditions.

SELECT * FROM Students
WHERE Class = 'VIII'
AND Marks > 80;

Both conditions must be true.

🔀 OR Operator

The OR operator is used when at least one of the conditions should be true.

SELECT * FROM Students
WHERE Name = 'Aarav'
OR Name = 'Diya';

↕️ ORDER BY

The ORDER BY clause is used to arrange query results in a particular order.

SELECT * FROM Students
ORDER BY Name;

⬆️ ASC - Ascending Order

ASC is used to arrange data in ascending order.

SELECT * FROM Students
ORDER BY Marks ASC;

⬇️ DESC - Descending Order

DESC is used to arrange data in descending order.

SELECT * FROM Students
ORDER BY Marks DESC;

➕ INSERT Command

The INSERT INTO command is used to add a new record to a table.

INSERT INTO Students
(Student_ID, Name, Class, Marks)
VALUES (104, 'Riya', 'VIII', 88);

✏️ UPDATE Command

The UPDATE command is used to modify existing data in a table.

UPDATE Students
SET Marks = 90
WHERE Student_ID = 104;

🗑️ DELETE Command

The DELETE command is used to remove records from a table.

DELETE FROM Students
WHERE Student_ID = 104;

🗃️ CREATE DATABASE

The CREATE DATABASE command is used to create a new database.

CREATE DATABASE SchoolDB;

📋 CREATE TABLE

The CREATE TABLE command is used to create a new table.

CREATE TABLE Students (
    Student_ID INT,
    Name VARCHAR(50),
    Class VARCHAR(10),
    Marks INT
);

🔢 SQL Data Types

Data types specify the kind of values that a column can store.

  • INT – Whole numbers
  • VARCHAR – Text of variable length
  • DATE – Dates
  • BOOLEAN – True or False values

🔑 PRIMARY KEY

A primary key uniquely identifies every record in a table.

CREATE TABLE Students (
    Student_ID INT PRIMARY KEY,
    Name VARCHAR(50),
    Class VARCHAR(10),
    Marks INT
);

🚫 What is NULL?

NULL represents a missing, unknown or unavailable value.

NULL is different from zero and is also different from an empty text value.

✨ DISTINCT Keyword

The DISTINCT keyword is used to display only unique values.

SELECT DISTINCT Class
FROM Students;

🔤 LIKE Operator

The LIKE operator can be used to search for a particular pattern in text.

SELECT * FROM Students
WHERE Name LIKE 'A%';

This can find names beginning with the letter A.

🔢 COUNT() Function

The COUNT() function can be used to count records.

SELECT COUNT(*)
FROM Students;

➕ SUM() Function

The SUM() function calculates the total of numerical values.

SELECT SUM(Marks)
FROM Students;

📊 AVG() Function

The AVG() function calculates the average of numerical values.

SELECT AVG(Marks)
FROM Students;

🔝 MAX() Function

The MAX() function returns the largest value.

SELECT MAX(Marks)
FROM Students;

🔻 MIN() Function

The MIN() function returns the smallest value.

SELECT MIN(Marks)
FROM Students;

🏗️ Data Definition Language

SQL commands used to define or create database structures are often grouped as DDL.

Examples include CREATE and ALTER.

✏️ Data Manipulation Language

SQL commands used to add, modify or delete data are often grouped as DML.

Examples include INSERT, UPDATE and DELETE.

🔍 Data Query Language

Commands used to retrieve information from a database are often grouped as DQL.

The most commonly used DQL command is SELECT.

⚠️ Write Conditions Carefully

Commands such as UPDATE and DELETE can affect many records.

A WHERE condition helps specify exactly which records should be changed or removed.

📋 Sample Student Table

Student_ID Name Class Marks
101 Aarav VIII 87
102 Diya VIII 92
103 Kabir VIII 78

🧩 Categories of SQL Commands

Category Purpose Examples
DDL Defines database structures. CREATE, ALTER
DML Manipulates data. INSERT, UPDATE, DELETE
DQL Retrieves data. SELECT

⌨️ Basic SQL Commands

Command Purpose
SELECT Retrieves data from a table.
INSERT INTO Adds a new record.
UPDATE Modifies existing records.
DELETE Removes records.
CREATE DATABASE Creates a new database.
CREATE TABLE Creates a new table.

🔄 How SQL Works

USER
  │
  ▼
SQL QUERY
  │
  ▼
DBMS
  │
  ▼
DATABASE
  │
  ▼
RESULT

The user writes an SQL command. The DBMS processes the command, works with the database and returns the required result.

⚙️ CRUD Operations in SQL

Operation SQL Command Purpose
Create INSERT Add new data.
Read SELECT View or retrieve data.
Update UPDATE Modify existing data.
Delete DELETE Remove data.

🧠 Common SQL Clauses

Clause Purpose
SELECT Specifies the data to retrieve.
FROM Specifies the table.
WHERE Specifies a condition.
ORDER BY Sorts the result.

🎯 Practical SQL Examples

1. Display all student records:

SELECT * FROM Students;

2. Display only student names and marks:

SELECT Name, Marks
FROM Students;

3. Find students scoring more than 80 marks:

SELECT * FROM Students
WHERE Marks > 80;

4. Arrange students according to marks:

SELECT * FROM Students
ORDER BY Marks DESC;

5. Add a new student:

INSERT INTO Students
(Student_ID, Name, Class, Marks)
VALUES (104, 'Riya', 'VIII', 88);

6. Change a student's marks:

UPDATE Students
SET Marks = 90
WHERE Student_ID = 104;

7. Delete a student record:

DELETE FROM Students
WHERE Student_ID = 104;

📊 Common SQL Functions

Function Purpose
COUNT() Counts records or values.
SUM() Calculates the total.
AVG() Calculates the average.
MAX() Finds the largest value.
MIN() Finds the smallest value.

🧪 Activity: Query a Student Database

Consider a table named Students containing the fields Student_ID, Name, Class and Marks.

Write SQL commands to:

  1. Display all records.
  2. Display only Name and Marks.
  3. Display students scoring more than 75 marks.
  4. Display students of Class VIII.
  5. Arrange students by name.
  6. Arrange students by marks in descending order.
  7. Add a new student record.
  8. Update the marks of a student.
  9. Delete a selected student record.
  10. Count the total number of students.

🚀 Mini Project: School Database Queries

Imagine that your school has a database containing student records.

Create suitable SQL queries for the following requirements:

  1. Display all students in Grade VIII.
  2. Find students scoring more than 90 marks.
  3. Display students in alphabetical order.
  4. Find the highest marks.
  5. Find the average marks.
  6. Add a new student.
  7. Correct the marks of a student.
  8. Remove an incorrect record.

✨ Good SQL Practices

  • Use meaningful names for databases and tables.
  • Write SQL keywords clearly and consistently.
  • Use suitable data types.
  • Use a primary key to identify records uniquely.
  • Use WHERE carefully with UPDATE and DELETE.
  • Check your query before executing it.
  • Back up important data regularly.
  • Protect confidential database information.
  • Do not share database credentials carelessly.

📚 Key Terms

Term Meaning
SQL A language used to communicate with relational databases.
Query A request or instruction given to a database.
Keyword A word with a special meaning in SQL.
SELECT Retrieves data from a table.
INSERT Adds new data to a table.
UPDATE Modifies existing data.
DELETE Removes data from a table.
WHERE Specifies a condition for selecting records.
ORDER BY Arranges query results in a particular order.
Primary Key Uniquely identifies each record in a table.
NULL Represents missing or unknown data.
DDL Commands used to define database structures.
DML Commands used to manipulate database data.
DQL Commands used to retrieve data.
Aggregate Function A function that performs a calculation on a group of values.

📝 Chapter Summary

Structured Query Language, or SQL, is used to communicate with and manage relational databases. SQL commands allow users to create database structures and work with stored data.

The SELECT command retrieves data, while WHERE helps select records that satisfy a condition. ORDER BY can arrange results in ascending or descending order.

INSERT adds new records, UPDATE modifies existing records and DELETE removes records. CREATE commands can be used to create databases and tables.

SQL also provides functions such as COUNT(), SUM(), AVG(), MAX() and MIN() for performing calculations on data.

By using SQL carefully and logically, we can manage large amounts of data efficiently.

🧠 Quick Check

  1. What does SQL stand for?
  2. What is SQL used for?
  3. What is a query?
  4. What is an SQL keyword?
  5. What does the SELECT command do?
  6. What does the symbol * mean in a SELECT statement?
  7. What is the purpose of the FROM clause?
  8. What is the purpose of the WHERE clause?
  9. Name four comparison operators used in SQL.
  10. What is the difference between AND and OR?
  11. What is ORDER BY used for?
  12. What is the difference between ASC and DESC?
  13. What is INSERT INTO used for?
  14. What is UPDATE used for?
  15. What is DELETE used for?
  16. What does CREATE DATABASE do?
  17. What does CREATE TABLE do?
  18. What is a data type?
  19. What is a primary key?
  20. What does NULL represent?
  21. What is DISTINCT used for?
  22. What is LIKE used for?
  23. What does COUNT() do?
  24. What does AVG() calculate?
  25. What do MAX() and MIN() return?
  26. What is DDL?
  27. What is DML?
  28. What is DQL?
  29. Why should UPDATE and DELETE commands be used carefully?
  30. Write an SQL query to display all records from a Students table.
  31. Write an SQL query to display students scoring more than 80 marks.
  32. Write an SQL query to add a new student.
  33. Write an SQL query to update a student's marks.

Grade VIII

Chapter 4: Fear of Missing Out

Understand the Fear of Missing Out (FOMO), how social media can influence our thoughts and behaviour, and how to develop healthy digital habits for a balanced and meaningful life.

😟 What is FOMO?

FOMO stands for Fear of Missing Out.

It is the feeling that other people may be experiencing something exciting, interesting or important while we are missing it.

📱 An Everyday Example

Imagine that you are studying, but your friends are posting photos and messages about an event.

You may repeatedly check your phone because you do not want to feel left out. This can be an example of FOMO.

🌐 FOMO and Social Media

Social media allows us to see updates from many people at any time.

Constant updates can sometimes create the feeling that we must always stay connected so that we do not miss anything.

🔔 The Role of Notifications

Notifications can quickly draw our attention away from other activities.

When we feel that every notification might contain something important, we may develop the habit of checking our devices repeatedly.

⚖️ Comparing Ourselves with Others

People often share selected moments of their lives online.

Comparing our everyday life with carefully selected online posts can sometimes create unrealistic expectations.

🎬 The Online Highlight Reel

Online posts may show celebrations, achievements, holidays and happy moments.

They do not always show the complete picture of a person's everyday life.

🔄 Constantly Checking Devices

FOMO may encourage a person to check messages, social media or other online platforms repeatedly.

This can interrupt activities such as studying, reading, playing, talking with family or resting.

🎯 FOMO and Distraction

When attention constantly shifts between tasks and online updates, it can become difficult to concentrate.

Focus improves when we give proper attention to one task at a time.

⏰ Time and Screen Use

Time spent repeatedly checking devices can slowly add up.

Being aware of our screen habits can help us use technology more intentionally.

🌙 FOMO and Sleep

Staying online late because we do not want to miss messages or updates can affect a healthy routine.

Creating a regular bedtime routine and reducing unnecessary device use before sleep can support better rest.

🌳 The Importance of the Present Moment

When we are constantly worried about what is happening online, we may pay less attention to what is happening around us.

Spending time with family, friends, hobbies and studies can be more meaningful when we are fully present.

😊 From FOMO to JOMO

JOMO stands for Joy of Missing Out.

It means feeling comfortable with not participating in every online activity and choosing how to spend our time consciously.

🎯 Making Conscious Choices

We do not need to respond immediately to every message or view every update.

Learning to decide what deserves our attention is an important digital life skill.

⚖️ Digital Balance

Digital balance means using technology in a way that supports our learning, communication, creativity and well-being.

Technology should be a useful tool rather than something that controls all of our attention.

🌱 Healthy Digital Habits

Healthy habits can help us stay in control of our technology use.

  • Check devices at suitable times.
  • Turn off unnecessary notifications.
  • Focus on one task at a time.
  • Take regular screen breaks.
  • Spend time on offline activities.

🔕 Managing Notifications

Not every application needs permission to interrupt us.

We can choose which notifications are useful and reduce unnecessary interruptions.

📌 Setting Priorities

Priorities help us decide what should receive our attention first.

For example, completing homework may be more important than immediately checking a new social media update.

🚴 Enjoying Offline Activities

Offline activities can provide enjoyment without requiring a constant internet connection.

Reading, sports, art, music, nature, robotics and conversations are examples of meaningful offline activities.

🎓 Focus Time

During study or homework time, keeping distracting applications away can help improve concentration.

A focused period of work is often more productive than working while constantly checking notifications.

👥 Online Peer Pressure

Sometimes people may feel pressure to participate in online trends simply because others are doing so.

A responsible digital citizen thinks before participating and makes independent choices.

⏸️ Pause Before Checking

Before opening an application, pause and ask:

"Why am I opening this app right now?"

This simple question can help us use technology more intentionally.

🌈 It Is Okay to Miss Something

It is impossible to watch every video, attend every event or follow every online conversation.

Missing some updates is a normal part of life.

💪 Digital Self-Control

Digital self-control means making thoughtful decisions about when, why and how we use technology.

It helps us become active users of technology instead of simply reacting to every notification.

🛠️ Technology is a Tool

Technology can help us learn, communicate, create and solve problems.

We should aim to use digital tools purposefully and responsibly.

🔄 Understanding the FOMO Cycle

SEE AN UPDATE
      ↓
WORRY ABOUT MISSING OUT
      ↓
CHECK DEVICE
      ↓
SEE MORE UPDATES
      ↓
WANT TO CHECK AGAIN
      ↓
REPEAT

Recognising this pattern can help us pause and make a conscious choice about whether checking the device is necessary.

⚖️ FOMO vs JOMO

FOMO JOMO
Fear of Missing Out Joy of Missing Out
Worry about missing an update. Comfort with choosing not to participate.
May encourage repeated checking. Encourages intentional use of time.
Attention is pulled toward everything. Attention is given to priorities.
"What am I missing?" "What do I want to focus on?"

🔍 Possible Signs of FOMO

  • Frequently checking messages without a clear reason.
  • Feeling distracted by notifications.
  • Finding it difficult to put the phone away.
  • Feeling pressure to follow every online trend.
  • Worrying about conversations happening without you.
  • Comparing your life constantly with online posts.
  • Interrupting important work to check updates.
  • Staying online simply because others are online.

These signs do not define a person. They can simply help us reflect on whether our digital habits need better balance.

🌱 Healthy Responses to FOMO

Situation Helpful Response
A notification appears while studying. Finish the study task before checking it.
Friends are discussing an online trend. Decide independently whether it is useful or appropriate.
You keep checking social media. Take a break and do an offline activity.
You compare yourself with online posts. Remember that posts may not show the complete picture.
You feel you must reply immediately. Respond at an appropriate and convenient time.

⚖️ A Simple Digital Balance Formula

PURPOSEFUL USE
      +
FOCUSED WORK
      +
REST
      +
OFFLINE ACTIVITIES
      +
REAL-LIFE CONNECTIONS
      =
HEALTHY DIGITAL BALANCE

📅 Daily Habits for Better Digital Balance

  1. Start important tasks before checking unnecessary updates.
  2. Keep notifications limited to useful applications.
  3. Set aside focused study time.
  4. Avoid switching constantly between tasks and social media.
  5. Spend time with family and friends without always checking devices.
  6. Enjoy hobbies that do not require a screen.
  7. Take regular breaks from digital devices.
  8. Follow a healthy bedtime routine.
  9. Choose what to watch and read intentionally.
  10. Remember that it is okay not to know every update.

🤔 Ask Yourself Before Opening an App

  1. Why am I opening this app?
  2. Do I need to check it right now?
  3. Will this interrupt something important?
  4. How much time do I plan to spend here?
  5. What will I do after I close the app?

🎯 Activity: My Attention Diary

For one day, observe the moments when you feel like checking a device.

Time What Was I Doing? Why Did I Want to Check? Was It Necessary?
__________ __________ __________ Yes / No
__________ __________ __________ Yes / No
__________ __________ __________ Yes / No

Discuss how becoming aware of our habits can help us make better decisions.

🗣️ Group Discussion

Discuss the following questions with your classmates:

  1. Why do people feel that they might miss something online?
  2. Can notifications become distracting?
  3. Is it possible to be connected without being online all the time?
  4. How can we enjoy social media responsibly?
  5. What offline activity would you choose instead of unnecessary screen time?

🚀 Mini Challenge: One Hour of Focus

Choose one useful activity such as studying, reading, drawing, building a robot or completing a project.

  1. Keep unnecessary notifications away.
  2. Focus on the chosen activity.
  3. Avoid switching between applications.
  4. Take a break after completing the activity.
  5. Reflect on whether you actually missed anything important.

✨ Good Digital Practices

  • Use technology with a clear purpose.
  • Do not allow every notification to control your attention.
  • Give priority to important responsibilities.
  • Take breaks from continuous screen use.
  • Avoid unnecessary comparison with online content.
  • Think independently before following online trends.
  • Enjoy meaningful offline activities.
  • Respect your own time and the time of others.
  • Use technology to learn, create and communicate positively.
  • Remember that missing an update is not the same as missing life.

📚 Key Terms

Term Meaning
FOMO Fear of Missing Out.
JOMO Joy of Missing Out.
Notification An alert from a device or application.
Digital Balance Using technology in a healthy and purposeful way.
Distraction Something that takes attention away from a task.
Focus Giving attention to a particular task or activity.
Priority Something that should receive important attention.
Self-Control The ability to manage one's actions and choices.
Online Highlight Reel Selected moments of life shared online.
Peer Pressure Pressure to act in a certain way because others are doing it.
Intentional Use Using technology with a clear reason or purpose.

📝 Chapter Summary

Fear of Missing Out, or FOMO, is the feeling that we may be missing something interesting or important that others are experiencing. Social media and constant notifications can sometimes encourage repeated checking of digital devices.

FOMO can distract us from important activities and make it difficult to focus on the present moment. Online posts may also show only selected moments, so comparing our complete life with someone else's online content may not give us a balanced picture.

Healthy digital habits include managing notifications, setting priorities, focusing on important tasks, enjoying offline activities and taking regular breaks from screens.

JOMO, or Joy of Missing Out, reminds us that it is perfectly okay not to participate in every online activity. We can choose where to place our attention and use technology purposefully.

🧠 Quick Check

  1. What does FOMO stand for?
  2. What is meant by Fear of Missing Out?
  3. How can social media contribute to FOMO?
  4. How can notifications affect our attention?
  5. Why can comparing ourselves with online posts be misleading?
  6. What is an online highlight reel?
  7. How can constant device checking affect concentration?
  8. How can excessive online activity affect a daily routine?
  9. Why is it important to be present in the moment?
  10. What does JOMO stand for?
  11. What is digital balance?
  12. Name three healthy digital habits.
  13. How can unnecessary notifications be managed?
  14. Why is setting priorities important?
  15. Name three enjoyable offline activities.
  16. What is online peer pressure?
  17. Why should we think before following an online trend?
  18. Why is it okay to miss some online updates?
  19. What is digital self-control?
  20. How can technology be used purposefully?
  21. What question can you ask yourself before opening an app?
  22. How can FOMO affect study time?
  23. What is the difference between FOMO and JOMO?
  24. How can you improve your own digital balance?
  25. Design a one-hour focus plan with minimal digital distractions.
  26. Write five rules for healthy technology use.

Grade VIII

Chapter 5: Lists & Tables in HTML

Learn how HTML lists and tables help us organise and present information clearly on a web page. Explore ordered lists, unordered lists, description lists and tables.

🌐 Why Organise Web Content?

A web page can contain a large amount of information. HTML provides elements such as lists and tables to organise information in a clear and readable manner.

📋 What is an HTML List?

An HTML list is used to display a collection of related items.

HTML mainly provides three types of lists:

  • Ordered List
  • Unordered List
  • Description List

🔢 Ordered List

An ordered list displays items in a particular sequence or order.

It is created using the <ol> tag.

📌 List Item

Each item in an ordered or unordered list is created using the <li> tag.

<li>First Item</li>

📝 Ordered List Example

<ol>
    <li>Wake up</li>
    <li>Get ready</li>
    <li>Go to school</li>
</ol>

The browser displays the items with numbers.

🔵 Unordered List

An unordered list displays items without a specific sequence.

It is created using the <ul> tag.

📝 Unordered List Example

<ul>
    <li>Keyboard</li>
    <li>Mouse</li>
    <li>Monitor</li>
</ul>

The browser normally displays the items with bullet points.

⚖️ Ordered vs Unordered Lists

Use an ordered list when the sequence of items is important.

Use an unordered list when the order of items does not matter.

📖 Description List

A description list is used to display terms along with their descriptions.

It uses the following tags:

  • <dl> – Description List
  • <dt> – Description Term
  • <dd> – Description Details

📚 Description List Example

<dl>
    <dt>HTML</dt>
    <dd>Language used to create web pages.</dd>

    <dt>CSS</dt>
    <dd>Language used to style web pages.</dd>
</dl>

🪆 Nested Lists

A list can contain another list. This is called a nested list.

Nested lists are useful for displaying categories and subcategories.

📂 Nested List Example

<ul>
    <li>Programming Languages
        <ul>
            <li>Python</li>
            <li>Java</li>
            <li>C++</li>
        </ul>
    </li>
</ul>

📊 What is an HTML Table?

An HTML table is used to display information in rows and columns.

Tables are useful for presenting structured information such as timetables, marks, price lists and schedules.

🗂️ The <table> Tag

The <table> tag is used to create an HTML table.

Other table elements are placed inside the <table> element.

↔️ Table Row

The <tr> tag is used to create a table row.

A table can contain one or more rows.

🔤 Table Heading

The <th> tag is used to create a table heading cell.

Table headings normally describe the information stored in each column.

📦 Table Data

The <td> tag is used to create a normal table data cell.

Data cells contain the actual information in a table.

📝 Basic Table Example

<table>
    <tr>
        <th>Name</th>
        <th>Marks</th>
    </tr>

    <tr>
        <td>Aarav</td>
        <td>90</td>
    </tr>
</table>

🏷️ Table Caption

The <caption> tag is used to provide a title or description for a table.

<caption>Student Marks</caption>

🧩 Table Sections

Larger tables can be organised into sections.

  • <thead> – Table header
  • <tbody> – Main table content
  • <tfoot> – Table footer

⬆️ <thead>

The <thead> element contains the heading section of a table.

📄 <tbody>

The <tbody> element contains the main data of a table.

⬇️ <tfoot>

The <tfoot> element contains summary or footer information for a table.

↔️ colspan Attribute

The colspan attribute allows one cell to span across multiple columns.

<td colspan="2">
    Total Marks
</td>

↕️ rowspan Attribute

The rowspan attribute allows one cell to span across multiple rows.

<td rowspan="2">
    Grade VIII
</td>

🎨 Styling Tables with CSS

HTML creates the structure of a table, while CSS can be used to improve its appearance.

table {
    border: 1px solid black;
}

🔲 Adding Cell Borders

th, td {
    border: 1px solid black;
}

This can add borders to table heading and data cells.

🧱 border-collapse

The border-collapse property can combine adjacent borders into a single border.

table {
    border-collapse: collapse;
}

📏 Cell Padding

The CSS padding property adds space inside table cells.

th, td {
    padding: 10px;
}

🎨 Styling Lists

CSS can also be used to change the appearance of lists.

ul {
    list-style-type: square;
}

🔠 Ordered List Styles

Ordered lists can use different numbering styles.

  • 1, 2, 3
  • A, B, C
  • a, b, c
  • I, II, III
  • i, ii, iii

🎯 list-style-type

The CSS list-style-type property controls the appearance of list markers.

ol {
    list-style-type: upper-roman;
}

♿ Accessible Tables

Clear table headings make information easier to understand.

Use <th> for headings and <caption> when a table needs a clear title.

✅ Use Tables for Data

Tables should be used for information that naturally belongs in rows and columns.

Examples include marks, timetables, attendance and schedules.

⚠️ Do Not Use Tables for Page Layout

Modern web pages use HTML structure and CSS for page layouts.

Tables should mainly be used to present tabular data.

📋 Types of HTML Lists

List Type Main Tag Purpose
Ordered List <ol> Displays items in a sequence.
Unordered List <ul> Displays items with bullet points.
Description List <dl> Displays terms and descriptions.

🧩 Important List Tags

Tag Purpose
<ol> Creates an ordered list.
<ul> Creates an unordered list.
<li> Creates a list item.
<dl> Creates a description list.
<dt> Creates a description term.
<dd> Creates description details.

📊 Important HTML Table Tags

Tag Purpose
<table> Creates a table.
<tr> Creates a table row.
<th> Creates a table heading cell.
<td> Creates a table data cell.
<caption> Provides a title for a table.
<thead> Contains the table heading section.
<tbody> Contains the main table content.
<tfoot> Contains the table footer.

📝 Complete Example: HTML Lists

<!DOCTYPE html>
<html>

<head>
    <title>My Favourite Subjects</title>
</head>

<body>

    <h2>Favourite Subjects</h2>

    <ol>
        <li>Computer Science</li>
        <li>Mathematics</li>
        <li>Science</li>
    </ol>

    <h2>Computer Topics</h2>

    <ul>
        <li>HTML</li>
        <li>CSS</li>
        <li>Python</li>
    </ul>

</body>

</html>

📊 Complete Example: Student Marks Table

<!DOCTYPE html>
<html>

<head>
    <title>Student Marks</title>
</head>

<body>

    <h2>Student Marks</h2>

    <table>

        <caption>Grade VIII Results</caption>

        <tr>
            <th>Name</th>
            <th>Subject</th>
            <th>Marks</th>
        </tr>

        <tr>
            <td>Aarav</td>
            <td>Computer</td>
            <td>90</td>
        </tr>

        <tr>
            <td>Diya</td>
            <td>Computer</td>
            <td>95</td>
        </tr>

    </table>

</body>

</html>

🎨 Example: A Styled Table

<style>

table {
    border-collapse: collapse;
}

th, td {
    border: 1px solid black;
    padding: 10px;
}

</style>

The CSS above adds borders and spacing to the table.

↔️ Example: Using colspan

<table>

    <tr>
        <th colspan="2">
            Student Information
        </th>
    </tr>

    <tr>
        <td>Name</td>
        <td>Aarav</td>
    </tr>

</table>

The heading cell spans across two columns.

↕️ Example: Using rowspan

<table>

    <tr>
        <th>Class</th>
        <th>Student</th>
    </tr>

    <tr>
        <td rowspan="2">VIII</td>
        <td>Aarav</td>
    </tr>

    <tr>
        <td>Diya</td>
    </tr>

</table>

The Class VIII cell spans across two rows.

⚖️ Lists vs Tables

Lists Tables
Display a collection of items. Display structured data.
Can be ordered or unordered. Organise information into rows and columns.
Useful for steps and categories. Useful for marks and timetables.
Use tags such as ol, ul and li. Use tags such as table, tr, th and td.

🧱 Understanding Table Structure

<table>

    <tr>
        <th>Heading 1</th>
        <th>Heading 2</th>
    </tr>

    <tr>
        <td>Data 1</td>
        <td>Data 2</td>
    </tr>

</table>

The basic structure of an HTML table is:

Table → Rows → Cells

🧪 Activity 1: Create a Favourite Things List

Create a web page containing:

  1. An ordered list of your daily activities.
  2. An unordered list of your favourite hobbies.
  3. A nested list showing a subject and its topics.
  4. A description list containing three computer terms.

🎯 Activity 2: Create a School Timetable

Create an HTML table to display a school timetable.

Your table should include:

  • Days of the week
  • Subject names
  • Table headings
  • At least five rows
  • Appropriate use of <th> and <td>

🚀 Activity 3: Build a Class Result Table

Create a table containing information about five students.

Include the following fields:

  • Roll Number
  • Name
  • Subject
  • Marks

Add a caption and use CSS to apply borders and padding.

💻 Mini Project: My Class Web Page

Create a simple web page about your class using both lists and tables.

Your page should contain:

  1. A heading containing the class name.
  2. An unordered list of class subjects.
  3. An ordered list of classroom rules.
  4. A table containing a sample timetable.
  5. A caption for the table.
  6. Table headings and data cells.
  7. Simple CSS for borders and spacing.

✨ Good HTML Practices

  • Use lists for collections of related items.
  • Use ordered lists when sequence matters.
  • Use unordered lists when order does not matter.
  • Use tables only for tabular information.
  • Use <th> for table headings.
  • Use <caption> to describe a table.
  • Indent HTML code to improve readability.
  • Close HTML tags correctly.
  • Use meaningful content and clear headings.
  • Use CSS to control presentation and appearance.

📚 Key Terms

Term Meaning
List A collection of related items.
Ordered List A list in which the sequence of items is important.
Unordered List A list in which the order of items is not important.
Description List A list containing terms and their descriptions.
Nested List A list placed inside another list.
Table A structure used to organise data into rows and columns.
Row A horizontal collection of table cells.
Cell An individual space in a table.
Table Heading A cell that describes a column or row of data.
Table Data The actual information stored in a table cell.
Caption A title or description for a table.
colspan Allows a cell to span across multiple columns.
rowspan Allows a cell to span across multiple rows.

📝 Chapter Summary

HTML lists are used to display collections of related items. Ordered lists use the <ol> tag, unordered lists use the <ul> tag and list items use the <li> tag.

Description lists use <dl>, <dt> and <dd> to display terms and their descriptions. Lists can also be nested.

HTML tables are used to organise information into rows and columns. The <table> tag creates a table, <tr> creates rows, <th> creates heading cells and <td> creates data cells.

Tables can be improved using captions, table sections, colspan, rowspan and CSS styling. Tables should be used for data rather than for designing the overall layout of a web page.

🧠 Quick Check

  1. What is an HTML list?
  2. Name the three main types of HTML lists.
  3. Which tag is used to create an ordered list?
  4. Which tag is used to create an unordered list?
  5. Which tag is used to create a list item?
  6. When should you use an ordered list?
  7. When should you use an unordered list?
  8. What is a description list?
  9. What are the uses of the <dl>, <dt> and <dd> tags?
  10. What is a nested list?
  11. What is an HTML table?
  12. Which tag creates a table?
  13. Which tag creates a table row?
  14. Which tag creates a table heading?
  15. Which tag creates a table data cell?
  16. What is a table caption?
  17. What is the purpose of <thead>?
  18. What is the purpose of <tbody>?
  19. What is the purpose of <tfoot>?
  20. What does the colspan attribute do?
  21. What does the rowspan attribute do?
  22. How can CSS be used to style a table?
  23. What is the use of border-collapse?
  24. Why should tables not normally be used for page layout?
  25. Write HTML code for an ordered list containing three items.
  26. Write HTML code for an unordered list containing three items.
  27. Write HTML code to create a simple table with two columns.
  28. Create a timetable using an HTML table.
  29. Create a web page using an ordered list, unordered list and table.


Grade VIII

Chapter 7: Advanced Python

Take your Python programming skills to the next level by learning about functions, modules, strings, lists, dictionaries, file handling, exception handling, and other powerful programming concepts.

🐍 Moving Beyond Basic Python

Advanced Python programming helps us write larger, smarter and more organised programs.

Instead of writing all instructions in one place, we can divide programs into reusable parts and work with different types of data.

⚙️ Functions

A function is a named block of code designed to perform a particular task.

Functions help us avoid repeating the same code again and again.

def greet():
    print("Hello, World!")

greet()

📝 Creating a Function

In Python, the def keyword is used to define a function.

def function_name():
    statement

The indented statements form the body of the function.

📥 Function Parameters

A parameter is a value that a function receives to perform its task.

def greet(name):
    print("Hello", name)

greet("Anant")

➕ Multiple Parameters

A function can receive more than one parameter.

def add(a, b):
    print(a + b)

add(10, 20)

↩️ Returning a Value

The return statement sends a result back from a function.

def add(a, b):
    return a + b

answer = add(10, 20)

print(answer)

📍 Local Variables

A variable created inside a function is usually called a local variable.

def show():
    message = "Hello"
    print(message)

show()

🌍 Global Variables

A variable created outside a function can generally be accessed from different parts of the program.

school = "My School"

def show():
    print(school)

show()

📦 Modules

A module is a Python file containing useful functions, variables or other code that can be imported into another program.

📥 Importing a Module

The import keyword is used to include a module in a Python program.

import math

print(math.sqrt(25))

🎲 The random Module

The random module can be used to generate random values.

import random

number = random.randint(1, 10)

print(number)

🔤 Working with Strings

A string is a sequence of characters.

name = "Python"

print(name)

Python provides many useful methods for working with strings.

🔧 Common String Methods

text = "python programming"

print(text.upper())
print(text.lower())
print(text.title())
print(text.replace("python", "Python"))

📏 Finding String Length

The len() function returns the number of characters in a string.

name = "Python"

print(len(name))

📋 Lists

A list is used to store multiple values in a single variable.

fruits = ["Apple", "Banana", "Mango"]

print(fruits)

🔢 Accessing List Items

List items are accessed using their index number.

fruits = ["Apple", "Banana", "Mango"]

print(fruits[0])
print(fruits[1])

Python indexing begins with 0.

➕ Adding Items to a List

The append() method adds an item to the end of a list.

fruits = ["Apple", "Banana"]

fruits.append("Mango")

print(fruits)

➖ Removing List Items

The remove() method removes a specified item.

fruits = ["Apple", "Banana", "Mango"]

fruits.remove("Banana")

print(fruits)

📏 List Length

The len() function can also be used to count the number of items in a list.

numbers = [10, 20, 30, 40]

print(len(numbers))

🔄 Looping Through a List

A for loop can process every item in a list.

fruits = ["Apple", "Banana", "Mango"]

for fruit in fruits:
    print(fruit)

📖 Dictionaries

A dictionary stores data as key-value pairs.

student = {
    "name": "Ravi",
    "class": 8,
    "marks": 90
}

🔑 Accessing Dictionary Values

Dictionary values can be accessed using their keys.

student = {
    "name": "Ravi",
    "marks": 90
}

print(student["name"])
print(student["marks"])

➕ Adding Dictionary Data

New key-value pairs can be added to a dictionary.

student = {
    "name": "Ravi"
}

student["class"] = 8

print(student)

✏️ Updating Dictionary Data

Assign a new value to an existing key to update its value.

student = {
    "name": "Ravi",
    "marks": 80
}

student["marks"] = 95

print(student)

🗂️ Organising Data

Lists and dictionaries can be combined to organise more complex information.

students = [
    {"name": "Ravi", "marks": 90},
    {"name": "Riya", "marks": 95}
]

print(students[0]["name"])

🔒 Tuples

A tuple is a collection of values that is generally not modified after creation.

colours = ("Red", "Green", "Blue")

print(colours)

🎯 Sets

A set is a collection that stores unique values.

numbers = {1, 2, 3, 3, 4}

print(numbers)

Duplicate values are not stored as separate items in a set.

📁 File Handling

File handling allows a program to save information permanently in a file and read it later.

📂 Opening a File

The open() function is used to open a file.

file = open("notes.txt", "r")

content = file.read()

print(content)

file.close()

✍️ Writing to a File

The "w" mode can be used to write data to a file.

file = open("notes.txt", "w")

file.write("Welcome to Python!")

file.close()

➕ Appending to a File

The "a" mode adds new data to the end of an existing file.

file = open("notes.txt", "a")

file.write("\nAdvanced Python")

file.close()

🛡️ Using the with Statement

The with statement is a convenient way to work with files because the file is automatically closed afterwards.

with open("notes.txt", "r") as file:
    content = file.read()
    print(content)

⚠️ Exceptions

An exception is an error that occurs while a program is running.

Python provides tools to handle certain errors without abruptly stopping the program.

🛠️ try and except

try:
    number = int(input("Enter a number: "))
    print(number)

except ValueError:
    print("Please enter a valid number.")

🔄 Type Conversion

Type conversion changes a value from one data type to another.

age = "14"

age = int(age)

print(age + 1)

🔢 Common Type Conversion Functions

  • int() – converts to an integer.
  • float() – converts to a decimal number.
  • str() – converts to a string.
  • list() – converts to a list where applicable.

🔍 Variable Scope

Scope refers to the part of a program where a variable can be accessed.

Understanding scope helps programmers organise variables and functions correctly.

📚 Documentation with Docstrings

A docstring can describe the purpose of a function or module.

def add(a, b):
    """Returns the sum of two numbers."""
    return a + b

⚙️ Functions at a Glance

Concept Meaning Example
Function A reusable block of code. def greet():
Parameter A value accepted by a function. def greet(name):
Argument A value passed to a function. greet("Ravi")
Return Sends a result back from a function. return a + b
Local Variable A variable created inside a function. message = "Hello"
Global Variable A variable created outside a function. school = "ABC"

🗂️ Python Collections

Collection Example Main Feature
List ["A", "B", "C"] Ordered collection that can be modified.
Tuple ("A", "B", "C") Ordered collection that is generally not modified.
Set {"A", "B", "C"} Stores unique values.
Dictionary {"name": "Ravi"} Stores data as key-value pairs.

📁 Common File Modes

Mode Purpose
"r" Opens a file for reading.
"w" Opens a file for writing.
"a" Opens a file for adding data at the end.

🔤 Useful String Methods

Method Purpose
upper() Converts text to uppercase.
lower() Converts text to lowercase.
title() Converts words to title case.
replace() Replaces specified text.
len() Returns the number of characters or items.

🧮 Complete Example: Student Result Function

def calculate_total(mark1, mark2, mark3):
    total = mark1 + mark2 + mark3
    return total


def calculate_average(total):
    return total / 3


total_marks = calculate_total(85, 90, 95)

average_marks = calculate_average(total_marks)

print("Total Marks:", total_marks)
print("Average Marks:", average_marks)

📋 Complete Example: Student List

students = [
    "Aman",
    "Riya",
    "Ravi",
    "Priya"
]


print("Students:")

for student in students:
    print(student)


print("Total Students:", len(students))

📖 Complete Example: Student Record

student = {
    "name": "Riya",
    "class": 8,
    "section": "A",
    "marks": 92
}


print("Student Name:", student["name"])
print("Class:", student["class"])
print("Marks:", student["marks"])

📁 Complete Example: Saving Notes

with open("python_notes.txt", "w") as file:
    file.write("Python is powerful.\n")
    file.write("Functions make code reusable.\n")
    file.write("Lists store multiple values.\n")


print("Notes saved successfully.")

⚠️ Complete Example: Safe Division

try:
    number1 = int(input("Enter first number: "))
    number2 = int(input("Enter second number: "))

    answer = number1 / number2

    print("Answer:", answer)

except ValueError:
    print("Please enter valid numbers.")

except ZeroDivisionError:
    print("A number cannot be divided by zero.")

🧪 Activity 1: Build a Calculator Using Functions

Create separate functions for:

  • Addition
  • Subtraction
  • Multiplication
  • Division

Ask the user for two numbers and perform the selected operation.

📋 Activity 2: Class Attendance List

Create a Python list containing the names of students.

Your program should:

  1. Display all student names.
  2. Add a new student.
  3. Remove a student.
  4. Display the total number of students.

📖 Activity 3: Student Information System

Create a dictionary containing:

  • Name
  • Class
  • Section
  • Roll Number
  • Marks

Display the student's complete information neatly.

📁 Activity 4: My Digital Diary

Create a program that asks the user to enter a short diary entry.

Save the entry in a text file using Python.

Then read the file and display the saved entry.

🎲 Activity 5: Guess the Number Game

Use the random module to generate a random number.

Ask the user to guess the number and display whether the guess is:

  • Too High
  • Too Low
  • Correct

🚀 Mini Project: Student Marks Manager

Create a Python program that manages student marks.

Your project should include:

  1. A function to add marks.
  2. A function to calculate total marks.
  3. A function to calculate average marks.
  4. A list or dictionary to store information.
  5. Input from the user.
  6. Exception handling for invalid input.
  7. Saving the result to a text file.
  8. Reading and displaying saved information.

✨ Good Python Programming Practices

  • Use meaningful names for variables and functions.
  • Divide large programs into smaller functions.
  • Use comments where they improve understanding.
  • Use indentation correctly.
  • Avoid repeating the same code unnecessarily.
  • Choose the appropriate data structure for your data.
  • Use with when working with files.
  • Handle expected errors using try and except.
  • Test programs using different inputs.
  • Keep your code simple, readable and organised.

📚 Key Terms

Term Meaning
Function A reusable block of code that performs a task.
Parameter A variable listed in a function definition.
Argument A value supplied when a function is called.
Return Value A result sent back from a function.
Module A Python file containing reusable code.
String A sequence of characters.
List An ordered collection of items.
Tuple An ordered collection that is generally not modified.
Set A collection that stores unique values.
Dictionary A collection that stores data as key-value pairs.
Module A reusable collection of Python code.
File Handling The process of reading from and writing to files.
Exception An error that occurs while a program is running.
Type Conversion Changing a value from one data type to another.
Scope The region of a program where a variable can be accessed.
Docstring A string used to document a function, class or module.

📝 Chapter Summary

Advanced Python programming helps us create larger and more organised programs.

Functions allow code to be reused. Parameters and arguments allow functions to work with different values, while the return statement sends results back to the program.

Modules provide reusable Python code. Collections such as lists, tuples, sets and dictionaries help us organise multiple values.

File handling allows Python programs to save and retrieve information. Exception handling helps programs deal with expected errors more safely.

By combining functions, collections, modules, files and exception handling, we can create more powerful and useful Python applications.

🧠 Quick Check

  1. What is a function?
  2. Which keyword is used to define a function in Python?
  3. What is a parameter?
  4. What is an argument?
  5. What is the purpose of the return statement?
  6. What is the difference between a local and global variable?
  7. What is a Python module?
  8. How do you import a module?
  9. What is the purpose of the random module?
  10. What is a string?
  11. What does the len() function do?
  12. What is a list?
  13. From which number does Python list indexing begin?
  14. Which method adds an item to the end of a list?
  15. Which method removes a specified item from a list?
  16. What is a dictionary?
  17. What is a key-value pair?
  18. What is a tuple?
  19. What is a set?
  20. What happens when duplicate values are added to a set?
  21. What is file handling?
  22. What does "r" mode mean?
  23. What does "w" mode mean?
  24. What does "a" mode mean?
  25. Why is the with statement useful when working with files?
  26. What is an exception?
  27. What is the purpose of try and except?
  28. What is type conversion?
  29. Write a function to calculate the square of a number.
  30. Create a list containing five subjects and display each subject.
  31. Create a dictionary to store student information.
  32. Write data to a text file and then read it.
  33. Create a program that handles invalid number input.
  34. Build a simple calculator using functions.

Grade VIII

Chapter 8: Natural Language Processing

Explore how computers understand, process and generate human language. Learn about Natural Language Processing (NLP), text and speech data, chatbots, virtual assistants, language translation and the responsible use of AI.

🗣️ What is Natural Language?

Natural language is the language that humans use to communicate with one another.

Examples include English, Hindi, French, Gujarati, Tamil and many other human languages.

Natural languages are different from programming languages such as Python, HTML and Java.

🤖 What is Natural Language Processing?

Natural Language Processing (NLP) is a branch of Artificial Intelligence that helps computers work with human language.

NLP enables computers to process language in the form of text and speech.

💡 Why Do Computers Need NLP?

Computers are very good at processing numbers and following instructions, but human language can be complicated.

NLP helps computers perform language-related tasks such as:

  • Reading text
  • Recognising speech
  • Answering questions
  • Translating languages
  • Generating text

⌨️ Text and Speech

NLP systems can work with two important forms of language data:

  • Text: Written words and sentences.
  • Speech: Spoken words and sounds.

For example, a chatbot may process text, while a voice assistant may process spoken language.

⚙️ How Does NLP Work?

An NLP system generally follows a process similar to this:

  1. Receive language input.
  2. Process the words or speech.
  3. Identify patterns or meaning.
  4. Generate an appropriate output.

📥 Language Input

The first step is receiving input from the user.

The input may be:

  • A typed sentence
  • A question
  • A voice command
  • A document
  • A message

✂️ Breaking Text into Tokens

Computers often break a sentence into smaller parts called tokens.

Sentence:
"I love robotics"

Possible tokens:
"I"
"love"
"robotics"

This process is commonly called tokenisation.

🔍 Understanding Meaning

Understanding language is difficult because the same word can have different meanings depending on its context.

For example, the word bank may refer to a financial institution or the side of a river.

🧩 The Importance of Context

Context means the surrounding words and situation that help us understand the intended meaning.

NLP systems use context to make better predictions about what a user means.

💬 Chatbots

A chatbot is a computer program designed to communicate with users through text or speech.

Chatbots may be used for:

  • Answering questions
  • Customer support
  • Learning assistance
  • Booking services
  • Providing information

🎙️ Virtual Assistants

A virtual assistant can receive voice commands and respond using speech or text.

A typical process may be:

  1. Listen to the user's voice.
  2. Convert speech into text.
  3. Process the request.
  4. Generate a response.
  5. Convert the response into speech.

🎤 Speech Recognition

Speech recognition is the process of converting spoken language into text that a computer can process.

Example:

Spoken Input:
"What is the weather?"

          ↓

Text:
"What is the weather?"

🔊 Text-to-Speech

Text-to-Speech (TTS) technology converts written text into spoken audio.

It can help make digital information more accessible to users.

🌐 Language Translation

NLP can help translate text from one language into another.

English:
"Good Morning"

        ↓

Hindi:
"सुप्रभात"

Translation systems must consider both words and their context.

😊 Sentiment Analysis

Sentiment analysis is used to identify the general feeling or opinion expressed in text.

A simple system may classify text as:

  • Positive 😊
  • Negative 😟
  • Neutral 😐

📝 Example: Sentiment

Sentence: "This robotics activity was amazing!"

Possible sentiment: Positive 😊

Sentence: "The application is not working."

Possible sentiment: Negative 😟

✏️ Spell Checking

NLP techniques can help identify possible spelling mistakes.

Input:
"Robtics"

Possible suggestion:
"Robotics"

⚡ Autocomplete and Predictions

NLP systems can predict possible words while a user is typing.

Input:
"I am going to the..."

Possible predictions:
school
market
park

The prediction depends on patterns learned from language data.

❓ Question Answering Systems

Some NLP systems are designed to receive questions and generate useful answers.

User:
"What is a robot?"

System:
"A robot is a machine that can perform tasks."

📄 Text Summarisation

Text summarisation reduces a large piece of information into a shorter form containing the main ideas.

This can help users quickly understand long documents.

✍️ Text Generation

Modern AI systems can generate text such as:

  • Answers
  • Stories
  • Summaries
  • Instructions
  • Computer programs

Generated information should still be checked for accuracy.

📚 Language Data

NLP systems learn from examples of language data.

Such data may include:

  • Books
  • Articles
  • Conversations
  • Web pages
  • Educational content

🧠 Training an NLP System

AI systems can be trained using examples that help them identify patterns in language.

The quality and diversity of training data can affect how well an NLP system performs.

🐍 NLP with Python

Python can be used to create programs that analyse and process text.

Even simple Python programs can perform basic text processing.

🔤 Example: Processing Text with Python

sentence = "I love learning robotics"

words = sentence.split()

print(words)

The split() method separates a sentence into words.

🔢 Counting Words

sentence = "Robotics is fun to learn"

words = sentence.split()

print("Number of words:", len(words))

This program combines basic text processing with lists and the len() function.

🔠 Standardising Text

Text may be converted into a common format before processing.

text = "Robotics and AI"

print(text.lower())
print(text.upper())

🔎 Searching for Keywords

sentence = "I am learning robotics"

if "robotics" in sentence:
    print("Keyword found")
else:
    print("Keyword not found")

This is a simple example of searching for a word in text.

💬 Building a Simple Rule-Based Chatbot

A basic chatbot can respond using predefined rules.

message = input("You: ")

if "hello" in message.lower():
    print("Bot: Hello!")

elif "robot" in message.lower():
    print("Bot: Robots are interesting machines!")

else:
    print("Bot: I do not understand yet.")

📏 Rule-Based NLP Systems

A rule-based system follows instructions created by programmers.

For example:

IF user says "hello"
THEN reply "Hello!"

Rule-based systems are useful for simple and predictable tasks.

🧠 AI-Based Language Systems

More advanced language systems use machine learning and Artificial Intelligence to identify complex patterns in data.

These systems can handle a wider variety of language inputs, although they can still make mistakes.

⚠️ Limitations of NLP

Human language can be difficult for computers because it may contain:

  • Different meanings
  • Spelling mistakes
  • Slang
  • Different accents
  • Incomplete sentences
  • Sarcasm and humour

⚖️ Bias in Language AI

AI systems can sometimes produce unfair or inaccurate results because of limitations or biases in the data and systems used to build them.

AI-generated results should therefore be reviewed carefully.

🔐 Privacy and Language Data

Messages, documents and voice recordings may contain personal information.

We should be careful about sharing private or sensitive information with digital systems.

🛡️ Responsible Use of NLP

When using AI language tools, students should:

  • Check important information.
  • Protect personal information.
  • Use respectful language.
  • Do not blindly copy generated work.
  • Understand the topic before submitting work.
  • Use AI as a learning assistant.

⚙️ A Simple NLP Process

Step What Happens?
1. Input The system receives text or speech.
2. Processing The language is broken into smaller parts and analysed.
3. Understanding The system identifies patterns and possible meaning.
4. Response The system generates text, speech or another output.

⌨️ Text Processing vs 🎤 Speech Processing

Feature Text Speech
Input Written words Spoken words
Example A typed message A voice command
Processing Text analysis Speech recognition
Output Text or action Speech, text or action

🌍 Applications of Natural Language Processing

Application How NLP Is Used
Chatbots Understanding messages and generating replies.
Virtual Assistants Processing voice commands and responding.
Translation Converting text between languages.
Spell Checking Identifying possible spelling errors.
Autocomplete Predicting possible words while typing.
Sentiment Analysis Identifying opinions or general feelings in text.
Text Summarisation Creating shorter versions of long text.
Question Answering Responding to questions using processed information.
Text-to-Speech Converting written text into spoken audio.

🧩 Rule-Based vs AI-Based Language Systems

Feature Rule-Based System AI-Based System
Working Method Uses predefined rules. Uses learned patterns and AI models.
Flexibility Usually handles limited situations. Can handle a wider variety of inputs.
Example Keyword-based chatbot. Advanced conversational AI system.
Limitation May fail outside programmed rules. May generate inaccurate or unexpected responses.

🐍 Complete Example: Simple Text Analyser

text = input("Enter a sentence: ")

words = text.split()

print("Original Text:", text)
print("Lowercase Text:", text.lower())
print("Uppercase Text:", text.upper())
print("Number of Characters:", len(text))
print("Number of Words:", len(words))

This program performs several basic text-processing operations.

🔎 Complete Example: Keyword Search

sentence = input("Enter a sentence: ")
keyword = input("Enter a word to search: ")

if keyword.lower() in sentence.lower():
    print("The keyword was found.")
else:
    print("The keyword was not found.")

😊 Complete Example: Simple Sentiment Detector

message = input("Enter your feedback: ")

positive_words = ["good", "great", "excellent", "amazing"]
negative_words = ["bad", "poor", "terrible", "worst"]

message = message.lower()

if any(word in message for word in positive_words):
    print("Possible Sentiment: Positive 😊")

elif any(word in message for word in negative_words):
    print("Possible Sentiment: Negative 😟")

else:
    print("Possible Sentiment: Neutral 😐")

This is a simple classroom demonstration. Real-world sentiment analysis is usually much more complex.

🧪 Activity 1: Token Detective

Take five sentences and manually divide each sentence into tokens.

Then use Python's split() method to compare your answer with the program's output.

💬 Activity 2: Build a Classroom Chatbot

Create a simple rule-based chatbot that can respond to questions about your school or classroom.

The chatbot may respond to messages such as:

  • Hello
  • What is your name?
  • What is robotics?
  • What is AI?
  • Goodbye

📊 Activity 3: Feedback Analyser

Collect a few sample feedback statements and classify them as:

  • Positive
  • Negative
  • Neutral

Discuss why a real computer system may find this task difficult.

🌐 Activity 4: Language Translator Investigation

Write a sentence in one language and translate it into another.

Compare the original and translated sentences and identify:

  • Words that changed
  • Word order differences
  • Meaning that may have changed
  • Words that were difficult to translate

🎤 Activity 5: Speech-to-Text Experiment

Use an available speech-to-text system under teacher supervision.

Speak the same sentence in different ways and observe whether the output changes.

Discuss the effects of:

  • Accent
  • Background noise
  • Speed of speaking
  • Pronunciation

🚀 Mini Project: Smart School Help Bot

Create a simple chatbot that answers common questions about a school.

Your chatbot may answer questions about:

  • School timing
  • Computer laboratory
  • Robotics laboratory
  • Subjects
  • Teachers
  • Homework

Your project should include:

  1. User input.
  2. Text conversion using lower().
  3. Conditional statements.
  4. Multiple possible responses.
  5. A polite greeting and exit message.

🛡️ Responsible Use of Language AI

  • Check important facts before using them.
  • Do not share private information unnecessarily.
  • Do not use AI to bully or harass others.
  • Do not blindly copy AI-generated content.
  • Understand and verify your work.
  • Respect copyright and academic honesty.
  • Remember that AI systems can make mistakes.
  • Use AI tools to learn, create and solve problems responsibly.

📚 Key Terms

Term Meaning
Natural Language A language naturally used by humans for communication.
NLP A field of AI concerned with processing and working with human language.
Token A smaller unit of language processed by a computer.
Tokenisation The process of dividing text into smaller units such as words.
Context Information surrounding language that helps determine meaning.
Chatbot A program designed to communicate with users.
Speech Recognition The process of converting spoken language into text.
Text-to-Speech The process of converting written text into spoken audio.
Sentiment Analysis Identifying the general opinion or feeling expressed in text.
Translation Converting language from one language into another.
Autocomplete Predicting possible words or text while a user is typing.
Rule-Based System A system that works according to predefined rules.
Language Model An AI system designed to work with patterns in language.
Bias A systematic unfair tendency that can affect an AI system's results.

📝 Chapter Summary

Natural Language Processing, or NLP, is an area of Artificial Intelligence that enables computers to work with human language.

NLP systems can process both text and speech. They are used in applications such as chatbots, virtual assistants, translation, spell checking, autocomplete, sentiment analysis and text summarisation.

Human language is complex because meaning can depend on context, grammar, spelling, accents and many other factors.

Python can be used to perform basic text-processing tasks such as splitting text into words, counting words and searching for keywords.

NLP and language AI are powerful technologies, but their outputs may not always be accurate. Responsible users should verify important information and protect their privacy.

🧠 Quick Check

  1. What is natural language?
  2. What does NLP stand for?
  3. What is the purpose of Natural Language Processing?
  4. Name two forms of language data that NLP systems can process.
  5. What is tokenisation?
  6. What is a token?
  7. Why is context important in language?
  8. What is a chatbot?
  9. What is speech recognition?
  10. What is Text-to-Speech?
  11. What is language translation?
  12. What is sentiment analysis?
  13. What are positive, negative and neutral sentiments?
  14. What is autocomplete?
  15. What is text summarisation?
  16. What is text generation?
  17. What is the difference between a rule-based and an AI-based system?
  18. Why can human language be difficult for computers?
  19. What is bias in AI?
  20. Why should AI-generated information be checked?
  21. Why is privacy important when using language AI?
  22. What does the split() method do in Python?
  23. How can Python count the words in a sentence?
  24. How can a Python program search for a keyword?
  25. Write a simple rule-based chatbot program.
  26. Write a program to count the number of words in a sentence.
  27. Create a simple sentiment analyser using positive and negative keywords.
  28. Give three real-life applications of NLP.
  29. What precautions should students take while using AI language tools?

Grade VIII

Chapter 9: Next Generation of Robots

Explore the future of robotics and discover how Artificial Intelligence, sensors, computer vision, automation and intelligent machines are creating the next generation of robots.

🤖 What Are Next-Generation Robots?

Next-generation robots are advanced robots designed to perform tasks more intelligently, independently and safely than traditional robots.

These robots combine technologies such as:

  • Artificial Intelligence
  • Machine Learning
  • Sensors
  • Computer Vision
  • Natural Language Processing
  • Advanced Actuators
  • Cloud and Edge Computing

⏳ From Traditional to Intelligent Robots

Traditional robots usually follow a fixed set of programmed instructions.

Intelligent robots can collect information from their surroundings, process that information and select an appropriate action.

Traditional Robot

Input → Program → Action


Intelligent Robot

Sense → Analyse → Decide → Act → Learn

🧠 Artificial Intelligence in Robots

Artificial Intelligence enables robots to perform tasks that require some level of perception, reasoning, prediction or decision-making.

AI can help a robot:

  • Recognise objects
  • Understand speech
  • Identify patterns
  • Make predictions
  • Select actions
  • Adapt to changing situations

👁️ Computer Vision

Computer Vision enables a computer or robot to obtain useful information from images and video.

A robot equipped with a camera may use computer vision to:

  • Recognise objects
  • Detect faces
  • Follow a path
  • Read signs
  • Identify obstacles

📡 Advanced Sensors

Sensors allow robots to collect information about their environment.

Next-generation robots may use multiple sensors at the same time.

  • Camera sensors 📷
  • Ultrasonic sensors 📏
  • Infrared sensors 🔴
  • Temperature sensors 🌡️
  • Motion sensors 🚶
  • Touch sensors ✋
  • GPS sensors 🛰️

🧩 Sensor Fusion

Sensor fusion means combining information from multiple sensors to obtain a better understanding of the environment.

Camera
   +
Ultrasonic Sensor
   +
GPS
   ↓
Better Understanding
   ↓
Robot Decision

🤝 Human-Robot Collaboration

The future of robotics includes robots that work alongside humans instead of simply replacing them.

Collaborative robots may assist humans with tasks that are:

  • Repetitive
  • Dangerous
  • Heavy
  • Precise
  • Time-consuming

🏥 Robots in Healthcare

Advanced robots can assist healthcare professionals in various activities.

Possible applications include:

  • Assisting with medical procedures
  • Delivering supplies
  • Supporting rehabilitation
  • Helping with patient monitoring
  • Assisting people with limited mobility

🚗 Autonomous Vehicles

An autonomous vehicle is designed to use sensors and software to understand its surroundings and assist with or perform driving tasks.

Such systems may use:

  • Cameras
  • Radar
  • Distance sensors
  • GPS
  • Computer Vision
  • AI algorithms

🚁 Drones and Flying Robots

Drones are flying robotic systems that can be controlled remotely or programmed to perform specific tasks.

Future drones may be used for:

  • Aerial photography
  • Mapping
  • Agriculture
  • Search and rescue
  • Infrastructure inspection
  • Emergency response

🌾 Agricultural Robots

Robots can help improve efficiency in agriculture.

Agricultural robots may help with:

  • Monitoring crops
  • Analysing soil
  • Detecting plant problems
  • Watering crops
  • Harvesting

🌊 Underwater Robots

Underwater robots can explore environments that may be difficult or dangerous for humans to reach.

They can be used for:

  • Ocean exploration
  • Marine research
  • Pipeline inspection
  • Underwater photography
  • Search operations

🚀 Space Robots

Robots are useful for exploring environments where human travel is difficult or risky.

Space robots may be used to:

  • Explore planets
  • Collect scientific information
  • Inspect equipment
  • Perform remote operations

🦿 Humanoid Robots

A humanoid robot is designed with some physical features or movements inspired by the human body.

Such robots may include:

  • Head and torso
  • Arms and hands
  • Legs
  • Cameras or vision systems
  • Speech interaction systems

🦾 Robotic Prosthetics and Exoskeletons

Robotics can be used to create devices that assist or support human movement.

Examples include:

  • Robotic prosthetic limbs
  • Powered exoskeletons
  • Rehabilitation devices
  • Assistive robotic systems

💬 Robots That Understand Language

Natural Language Processing can allow robots to interact with people using text or speech.

Human:
"Please bring the book."

        ↓

Speech Recognition

        ↓

Language Processing

        ↓

Robot Decision

        ↓

Robot Action

🧠 Machine Learning

Machine Learning is a branch of AI in which systems identify patterns from examples or data.

In robotics, machine learning may help with:

  • Object recognition
  • Pattern detection
  • Prediction
  • Navigation
  • Improving performance

🔄 Adaptive Robots

An adaptive robot can modify its behaviour based on changes in its environment or the information it receives.

For example, an obstacle-detecting robot may change its path when it detects an object in front of it.

🗺️ Autonomous Navigation

Autonomous navigation allows a robot to move through an environment using information from sensors and software.

A navigation system may need to:

  1. Understand its surroundings.
  2. Identify obstacles.
  3. Determine its position.
  4. Select a path.
  5. Move safely.

🧭 Mapping and Localisation

Intelligent robots may create or use a map of their surroundings.

Localisation means determining where the robot is located within an environment.

☁️ Cloud Robotics

Cloud robotics involves using remote computing resources to support robotic systems.

A robot may use network-connected systems for:

  • Data storage
  • Information sharing
  • Advanced computation
  • Remote monitoring

⚡ Edge Computing in Robotics

Edge computing means processing information closer to where it is generated.

For robots, this can help reduce the time needed to send data to a distant system and receive a response.

🌐 Internet of Things and Robots

Robots can communicate with other connected devices through networks.

This allows different systems to share information and coordinate actions.

Sensor → Robot → Network → Smart System

🏙️ Robots in Smart Cities

Advanced robotic systems may support the development of intelligent urban environments.

Possible applications include:

  • Traffic monitoring
  • Waste management
  • Infrastructure inspection
  • Emergency assistance
  • Environmental monitoring

🌱 Sustainable Robotics

Future robots should also be designed with sustainability in mind.

Important considerations include:

  • Energy efficiency
  • Durable components
  • Repairable designs
  • Reduced electronic waste
  • Responsible use of resources

🔋 Future Power Sources

Advanced robots require reliable sources of energy.

Research and development continue in areas such as:

  • Improved batteries
  • Energy-efficient motors
  • Renewable energy
  • Wireless charging

⚖️ Ethics in Robotics

As robots become more capable, it becomes increasingly important to consider how they should be designed and used responsibly.

Important questions include:

  • Is the robot safe?
  • Who is responsible for its actions?
  • Does it protect privacy?
  • Is the system fair?
  • Can humans understand and supervise it?

🔐 Cybersecurity and Robots

Connected robots may require protection from unauthorised access and harmful interference.

Important security measures include:

  • Strong authentication
  • Secure software updates
  • Protected communication
  • Access control
  • Regular security testing

👨‍⚖️ Human Control and Safety

Powerful robotic systems should be designed with appropriate safety mechanisms and human supervision.

Robots should operate within clearly defined limits and respond safely when unexpected situations occur.

💼 Robots and Future Careers

The growth of robotics is creating opportunities in many fields.

  • Robotics Engineering
  • Artificial Intelligence
  • Machine Learning
  • Computer Vision
  • Embedded Systems
  • IoT Engineering
  • Automation
  • Cybersecurity
  • Data Science

📈 Evolution of Robots

Generation Main Capability Example
Early Robots Perform fixed repetitive tasks. Industrial robotic arm
Sensor-Based Robots React to information from sensors. Line-following robot
Programmable Robots Perform tasks according to software instructions. Arduino-based robot
Intelligent Robots Use AI to analyse information and make decisions. Smart service robot
Next-Generation Robots Combine AI, sensors, learning and connectivity. Advanced autonomous robotic systems

🧠 Components of an Intelligent Robot

Component Purpose
Sensors Collect information from the environment.
Processor Processes data and executes instructions.
AI System Helps identify patterns and support decisions.
Actuators Produce physical movement or action.
Communication System Allows the robot to exchange information with other systems.
Power System Provides electrical energy.
Safety System Helps ensure safe and controlled operation.

🌍 Applications of Next-Generation Robots

Field Possible Robotic Application
Healthcare Assistance, rehabilitation and medical support.
Agriculture Crop monitoring and precision farming.
Education Interactive learning and laboratory activities.
Space Exploration and remote operations.
Ocean Research Underwater exploration and inspection.
Transportation Advanced driver assistance and autonomous systems.
Industry Automation and human-robot collaboration.
Disaster Response Search, inspection and remote assistance.

⚙️ Traditional Robots vs Next-Generation Robots

Feature Traditional Robot Next-Generation Robot
Programming Usually follows fixed instructions. May use AI and adaptive software.
Sensing May use limited sensors. Can combine multiple advanced sensors.
Decision-Making Mostly predefined. Can use data and AI-based decision systems.
Interaction Limited interaction with humans. May use speech, vision and natural language.
Connectivity Often operates independently. May connect with networks and other devices.
Adaptability Limited. Potentially more adaptive.

🧪 Activity 1: Design a Robot of the Future

Imagine that you are a robotics engineer designing a robot for the year 2040.

Your robot design should include:

  1. A name for the robot.
  2. The problem it will solve.
  3. At least three sensors.
  4. At least two actuators.
  5. An AI capability.
  6. A method of communication.
  7. A safety feature.
  8. A source of power.

🗺️ Activity 2: Build a Robot Decision Flow

Create a flowchart for an autonomous obstacle-avoiding robot.

START
  ↓
Read Distance Sensor
  ↓
Is an Obstacle Detected?
  ↓
YES ──→ Stop
  ↓
Turn
  ↓
Move Forward

NO ──→ Move Forward
  ↓
Repeat

Discuss how the robot could be improved using a camera or AI.

👁️ Activity 3: Sensor Fusion Challenge

Design a smart robot that uses information from at least three different sensors.

For each sensor, explain:

  • What information it collects.
  • Why the robot needs it.
  • How the information affects the robot's actions.

🚀 Mini Project: Smart Autonomous Delivery Robot

Design a concept for a robot that can deliver an object safely from one location to another.

Your design should include:

  • Robot body and wheels.
  • Obstacle detection.
  • Navigation system.
  • Object storage area.
  • Status indicator.
  • Emergency stop feature.

Draw the system architecture showing:

Sensors
   ↓
Microcontroller / Computer
   ↓
Decision System
   ↓
Motor Controller
   ↓
Motors
   ↓
Robot Movement

🎓 Skills for the Future of Robotics

  • Programming
  • Electronics
  • Mechanical Design
  • Problem Solving
  • Artificial Intelligence
  • Data Analysis
  • Computer Vision
  • Cybersecurity
  • Teamwork
  • Creative Thinking
  • Ethical Decision-Making

🛡️ Responsible Robotics

  • Design robots with safety as a priority.
  • Protect users' privacy and personal data.
  • Secure connected robotic systems.
  • Test systems carefully before deployment.
  • Consider the impact of robots on society.
  • Keep appropriate human supervision over important systems.
  • Design technology to assist and benefit people.
  • Consider sustainability and electronic waste.

📚 Key Terms

Term Meaning
Autonomous Robot A robot designed to perform tasks with a degree of independent operation.
Artificial Intelligence Technology that enables systems to perform tasks involving pattern recognition, prediction or decision-making.
Computer Vision Technology that processes and analyses information from images or video.
Machine Learning A method in which systems identify patterns from data or examples.
Sensor Fusion Combining information from multiple sensors.
Humanoid Robot A robot with features or movements inspired by the human body.
Collaborative Robot A robot designed to work in cooperation with humans.
Autonomous Navigation The ability of a robotic system to navigate using information about its environment.
Localisation Determining the position of a robot within an environment.
Cloud Robotics The use of network-connected computing resources to support robots.
Edge Computing Processing data closer to where the data is generated.
IoT A network of connected devices capable of collecting and exchanging information.
Actuator A component that produces physical movement or action.
Robotic Ethics Principles concerned with the responsible design and use of robots.

📝 Chapter Summary

The next generation of robots will combine robotics with Artificial Intelligence, Machine Learning, Computer Vision, Natural Language Processing, advanced sensors and connected computing systems.

Future robots may be more capable of sensing their environment, analysing information, communicating with humans and adapting their behaviour to changing situations.

Robotics will continue to play an important role in healthcare, agriculture, transportation, industry, education, disaster response, space exploration and many other fields.

As robots become more powerful and connected, safety, cybersecurity, privacy, ethics and responsible human supervision will become even more important.

🧠 Quick Check

  1. What are next-generation robots?
  2. How are intelligent robots different from traditional robots?
  3. What role does Artificial Intelligence play in robotics?
  4. What is Computer Vision?
  5. Name four sensors that may be used by an advanced robot.
  6. What is sensor fusion?
  7. What is a collaborative robot?
  8. How can robots assist in healthcare?
  9. What technologies may be used by autonomous vehicles?
  10. Give three applications of drones.
  11. How can robots assist in agriculture?
  12. What are underwater robots used for?
  13. Why are robots useful in space exploration?
  14. What is a humanoid robot?
  15. What is a robotic prosthetic?
  16. How can robots understand spoken commands?
  17. What is Machine Learning?
  18. What is an adaptive robot?
  19. What is autonomous navigation?
  20. What is localisation?
  21. What is cloud robotics?
  22. What is edge computing?
  23. How can IoT and robotics work together?
  24. What is sustainable robotics?
  25. Why is cybersecurity important in robotics?
  26. What are some ethical concerns related to robots?
  27. Why is human supervision important?
  28. Name five careers related to robotics.
  29. Design a robot for a real-world problem.
  30. Explain how AI, sensors and actuators can work together in an intelligent robot.