Scribd
Upload
25 views3 pages

Class 11 SQL SELECT Command Lesson Plan 35mins Updated

This lesson plan for Class XI Informatics Practices focuses on the SQL SELECT command, teaching students to retrieve and manipulate data from tables. By the end of the lesson, students will understand the syntax of SELECT, use WHERE and ORDER BY clauses, and apply DISTINCT to remove duplicates. The session includes a mix of lectures, demonstrations, and hands-on practice, with assessments to evaluate students' understanding of SQL queries.

Uploaded by

Inderpreet Kaur Gujral
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
25 views3 pages

Class 11 SQL SELECT Command Lesson Plan 35mins Updated

This lesson plan for Class XI Informatics Practices focuses on the SQL SELECT command, teaching students to retrieve and manipulate data from tables. By the end of the lesson, students will understand the syntax of SELECT, use WHERE and ORDER BY clauses, and apply DISTINCT to remove duplicates. The session includes a mix of lectures, demonstrations, and hands-on practice, with assessments to evaluate students' understanding of SQL queries.

Uploaded by

Inderpreet Kaur Gujral
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

LESSON PLAN

CLASS : XI SUBJECT : INFORMATICS PRACTICES

TEACHER : ____________________________

BOOK : NCERT CLASS XI INFORMATICS PRACTICES

NAME OF THE CHAPTER : SQL – SELECT Command

Time : 1 PERIOD × 35 mins

Weightage : 4 Marks

1. INTRODUCTION
The SELECT command in SQL is used to retrieve data from one or more tables. It allows
users to specify which columns of data to view, filter results using WHERE, and sort records
using ORDER BY. This class will focus on writing and understanding basic SELECT queries.

2. LEARNING OBJECTIVES
By the end of the lesson, students will be able to:

❖ Understand the syntax of the SELECT command.

❖ Retrieve all or specific columns from a table.

❖ Use WHERE clause to apply conditions to queries.

❖ Sort query results using ORDER BY.

❖ Remove duplicate records using DISTINCT.

3. LEARNING OUTCOMES
Knowledge - The students will learn:

• Basic syntax of SELECT queries.

• Use of WHERE, ORDER BY, and DISTINCT clauses.

• Execution of simple SQL queries to retrieve and organize data.

Skills - (21st Century Skills):


• Critical Thinking: Designing and analyzing SQL queries for accuracy.

• Collaboration: Working in groups to practice query writing.

• Information Literacy: Interpreting query outputs effectively.

4. TEACHING PREPARATIONS REQUIRED BEFORE THE CLASS


• NCERT Textbook

• SQL software (MySQL / SQLite / SQL Fiddle)

• Sample database: STUDENT (RollNo, Name, Marks)

• Whiteboard or PowerPoint slides for illustration

5. TEACHING METHODOLOGIES
❖ Brief lecture on SELECT syntax and purpose.

❖ Demonstration of real queries on SQL interface.

❖ Interactive session for query practice.

6. SPECIFIC METHODOLOGY INCLUDING THE DOL PARAMETERS


• Flipped Classroom: Students reviewed basic SQL concepts before class.

• Experiential Learning: Practice SELECT queries in real-time.

• Peer Learning: Students discuss query results in pairs.

• Critical Thinking: Predict outcomes of SQL queries before execution.

7. PREVIOUS KNOWLEDGE
Students already know about databases, tables, and basic data entry using SQL INSERT
command.

8. FLOW OF THE SESSION


• Introduction and recall of SQL basics – 5 mins

• Explanation of SELECT syntax and examples – 10 mins

• Practical demonstration and hands-on query writing – 15 mins

• Summary and Q&A – 5 mins


9. RECAPITULATION
❖ SELECT command is used to retrieve data from a database.

❖ WHERE applies conditions to filter data.

❖ ORDER BY sorts the results in ascending or descending order.

❖ DISTINCT removes duplicates in the output.

10. HOME TASK FOR THE CHAPTER


• Write SQL query to display all records from the STUDENT table.

• Display students who scored more than 80 marks.

• Show students' names in alphabetical order.

• Display distinct subjects from a given table.

11. ASSESSMENT STRATEGIES


• Oral questioning to check understanding of SELECT syntax.

• Worksheet containing basic SELECT and WHERE queries.

• Practical evaluation: Execution of SQL queries by students.

You might also like