Lesson Plan

Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Getting Started with Python : Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Python Pluses, some minuses. Working in Python programming MLL:
– working in default python Distribution, working in Anaconda Knows uses of Q. Who developed Python Quiz
Distribution, writing and compiling Python program with various Programming Language?
command line in linux. Understanding First Program/ Script programming syntax Q. Is Python an object Oriented Questionnaire
Identifies type of Programming?
Demonstration
programming
paradigm HOT: Method
Applies the concept Q. What is the difference between
practically interactive mode and script mode in Weekly test
Python?
Monthly test
Q. Write a program in Python to print
your name.

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Python Fundamentals : Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Python character set, Tokens- keywords, programming MLL:
identifiers, literals, operators, punctuators. Barbones of a Knows uses of Q. What is the difference between a Quiz
Python program, Variable and Assignments- creating a various keyword and an identifier?
variable, multiple assignments, variable definition, dynamic programming syntax Q. How many strings are supported in Questionnaire
typing. Simple Input and Output – reading numbers, output Identifies type of Python?
through print() statement. Demonstration
programming
paradigm HOT: Method
Applies the concept Q. What is the difference between an
practically expression and a statement in Python? Weekly test
Q. Write a program to calculate profit
Monthly test
percentage from the sales of goods
that you made.

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Data Handling : Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Data Types – Numbers, Strings, Lists and tuples , programming MLL:
Dictionary. Mutable and Immutable Types- variable Internals. Knows uses of Q. What are data types? What are Quiz
Operators – Arithmetic operators, Relational operators, identity various Python’s built in core data types?
operators,logical operators, bitwise operators, operator programming syntax Q. What do you understand by the Questionnaire
precedence. Expressions – evaluating expressions, type casting. Identifies type of term immutable?
Working with some standard library modules – working with Demonstration
programming
math module of python, using random module, using the paradigm HOT: Method
statistics module. Applies the concept Q. Why is Boolean considered a
practically subtype of integers. Weekly test
Q. Write a program to obtain principal
Monthly test
amount, rate of interest and time from
the user and compute simple interest.

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Conditional and Iterative Statements: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Types of Statements in Python. Statement flow programming MLL:
control. Program logic development tools – flowcharts. If Knows uses of Q. What is statement? What is the Quiz
statements , if else statement, if- elif statement, nested If various significance of an empty statement?
statement. Repetition of Tasks – a necessity. The range() programming syntax Q. Write a program to print numbers Questionnaire
function. Iteration/Looping Statements - for loop, while loop, Identifies type of from 1 to 100.
loop else statement, jump statements- break and continue. Loop Demonstration
programming
else Statement. Nested Loops. paradigm HOT: Method
Applies the concept Q. Write a program to print factorial of
practically a given number. Weekly test
Q. Write a program to print Fibonacci
Monthly test
series.

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
String Manipulation: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Traversing a string, String operators- basic programming MLL:
operations, membership operators, comparison operators, string Knows uses of Q. What is a string slice? How is it Quiz
slices, string functions and methods various useful?
programming syntax Questionnaire
Identifies type of HOT:
Demonstration
programming Q. Write a program that reads a string
paradigm and checks whether it is a palindrome Method
Applies the concept string or not.
practically Q. Write a program that reads a string Weekly test
and then prints a string that capitalizes
Monthly test
every other letter in the string e.g.
passion becomes pAsSiOn.

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Debugging Programs: Understands the Use of e-content : e-book, powerpoint Individual Task Debugging
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. refers to the
Application: python Group Task process of
Introduction, Debugging, Errors and Exceptions, debugging programming MLL: locating the
techniques, Using Debugger Tool – working with Integrated Knows uses of Q. What do you mean by Syntax errors Quiz place of error,
debugger tool of Spyder IDE, working with Python Debugger- various and semantics errors? cause of error
pdb. programming syntax Questionnaire and correcting
Identifies type of HOT: the code
Demonstration
programming Q. Why are logical errors harder to accordingly.
paradigm locate? Method
Applies the concept Q. What is an Exception?
practically Weekly test

Monthly test

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
List Manipulation : Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Creating and accessing lists – creating lists, programming MLL:
accessing lists. List operations- join lists, repeating or Knows uses of Q. How are lists different from strings Quiz
replicating lists, slicing lists, working with lists, list functions various when both are sequences?
and methods. programming syntax Q. What are nested lists? Questionnaire
Identifies type of
Demonstration
programming HOT:
paradigm Q. Write a program to find the largest Method
Applies the concept number of a list of numbers.
practically Q. Write a program to find the second Weekly test
largest number of a list of numbers.
Monthly test

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Tuples : Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Creating and accessing tuples – creating tuples, programming MLL:
accessing tuples. Tuples operations- joining tuples, slicing Knows uses of Q. How are tuples different from lists Quiz
tuples, Tuples functions and methods. various when both are sequences?
programming syntax Q. How can you say that a tuple is an Questionnaire
Identifies type of ordered list of objects?
Demonstration
programming
paradigm HOT: Method
Applies the concept Q. Can tuples be nested?
practically Q. Write a Python function Weekly test
secondLargest(T) which takes as input
Monthly test
tuple T and returns the second largest
element in the tuple.
.

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Dictionaries: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge, Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Dictionary- Key : Value Pairs – creating a programming MLL:
dictionary, accessing elements of a dictionary, characteristics Knows uses of Q. How are dictionaries different from Quiz
of a dictionary. Working with Dictionaries – multiple ways of various lists?
creating dictionaries, adding elements to dictionary, updating programming syntax Q. Why can’t Lists can be used as keys? Questionnaire
existing elements in a dictionary, checking for existence of a Identifies type of
key, pretty printing a dictionary, counting frequency of Demonstration
programming HOT:
elements in a list using dictionary. Dictionary Functions and paradigm Q. Write a program to create a Method
methods. Applies the concept dictionary containing names of
practically competition winner students as keys Weekly test
and number of their wins as values.
Monthly test

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Understanding Sorting: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge, Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, sorting, bubble sort, insertion sort programming MLL:
Knows uses of Q. Given an array: 89, 20, 31, 56, 20. Quiz
various Sort this array in ascending order using
programming syntax i) Bubble sort ii) Insertion Sort Questionnaire
Identifies type of
Demonstration
programming HOT:
paradigm Q. Write a program to sort a list using Method
Applies the concept Bubble Sort.
practically Q. Write a program to sort a sequence Weekly test
using insertion sort.
Monthly test

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
States and Transitions: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge, Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, magical Island- the Island of Victory, programming MLL:
States, Transitions and Diagrams Knows uses of Q. What is State? Quiz
various Q. What do you understand by
programming syntax transition? Questionnaire
Identifies type of
Demonstration
programming HOT:
paradigm Q. Draw state-transition diagram for Method
Applies the concept game of chess.
practically Q. Draw state-transition diagram for Weekly test
asking a room reservation in a hotel.
Monthly test

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Basic Computer Overview: Understands the Use of e-content : e-book, powerpoint Individual Task Basic
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. knowledge of
Application: python Group Task Computers is
Introduction, Basic Computer organization- Input Unit,Output programming MLL: required in
unit, CPU, Memory, Storage Unit, System bus, Mobile System Knows uses of Q. State the basic units of a computer. Quiz most of the
Organisation , Types of Software – System software, various Name the subunits that make up the work/ job
Application software, software libraries. programming syntax CPU, and give the functions of each of Questionnaire nowdays .
Identifies type of the units.
Demonstration
programming Q. What is the function of memory?
paradigm What are its measuring units? Method
Applies the concept
practically HOT: Weekly test
Q. What is the difference between
Monthly test
RAM and ROM?
Q. What is the difference between an
interpreter and compiler.

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Data Representation: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Digital Number System- decimal number system, programming MLL:
binary number system. Number Conversions – Decimal to Knows uses of Q. Convert following decimal numbers Quiz
binary conversion, binary to decimal conversion, decimal to various to binary:
octal , octal to decimal, octal to binary, binary to octal, decimal programming syntax i) 13 Questionnaire
to hex, hex to decimal, binary to hex, hex to binary , Identifies type of ii) 106
Representing unsigned integers in binary, binary addition, Demonstration
programming iii) 84
Character/String representation- ASCII Code, ISCII paradigm Method
Code,Unicode. Applies the concept HOT:
practically Q. Convert Binary numbers to decimal: Weekly test
i) 10010
Monthly test
ii) 101010
iii) 1010100.011

Date: Name and Signature of the Teacher: Principal:

 Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Boolean Logic: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Development of Boolean logic, binary valued quantities, programming MLL:
logical operations – logical functions, logical operators, Knows uses of Q. Prove that X.(X+Y)=X by truth table. Quiz
evaluation of Boolean expressions using truth table, basic logic various
gates- Inverter(NOT gate) , OR Gate, AND Gate, basic programming syntax HOT: Questionnaire
postulates of Boolean logic, principal of duality, basic theorems Identifies type of Q. Draw logic circuit diagram for the
of Boolean algebra- properties of 0,1, Indempotence law, Demonstration
programming following:
Involution, Complementary law, Commutative law, paradigm Y = ab+ b’ c + c’ a’ Method
Associative law, Distributive law, Absorption law, some other Applies the concept Q. State DeMorgan’s Law of Boolean
rules of Boolean logic algebra, DeMorgan’s Theorems, practically Algebra and verify them using truth Weekly test
Simplifying a Boolean Expression, More about logic Gates – table.
NOR Gate, NAND Gate, XOR Gate, XNOR Gate, NAND to Monthly test
NAND and NOR to NOR design.

Date: Name and Signature of the Teacher: Principal:

Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Insight Into Program Execution: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Basic flow of compilation, Understanding programming MLL:
Translation Process- compilation process, Interpretation Knows uses of Q. What are the front end and back end Quiz
process, Role of Operating System in Running a Program, various phases of a compiler?
Introduction to Parallel Computing, Cloud Computing. programming syntax Q. What is the difference between Questionnaire
Identifies type of linker and loader parts of a compiler?
Demonstration
programming
paradigm HOT: Method
Applies the concept Q. What is cloud computing?
practically Q. What are the advantages of parallel Weekly test
computing?
Monthly test

Date: Name and Signature of the Teacher: Principal:

Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Relational Databases: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Purpose of DBMS, Relational Database Model, programming MLL:
The Relational Model Terminology – Views, Structure of Knows uses of Q. What is database system? What is its Quiz
Relational Databases, brief history of MySQL, MySQL various need?
Database System, Starting MySQL, MySQL and SQL- programming syntax Q. What is SQL? Questionnaire
Processing capabilities of SQL, Data Definition Language, Identifies type of
Classification of SQL Statements. Demonstration
programming HOT:
paradigm Q. Differentiate between DDL and DML Method
Applies the concept commands.
practically Weekly test

Monthly test

Date: Name and Signature of the Teacher: Principal:

Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Simple Queries in SQL: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Some MySQL SQL Elements – Literals, Data programming MLL:
Types, Null values, comments. SQL Command syntax, making Knows uses of Q. Differentiate between CHAR and Quiz
simple queries- accessing database, the SELECT command , various VARCHAR datatypes.
selecting all columns, reordering columns in query results, programming syntax Q. Write query to display all records Questionnaire
eliminating redundant data, selecting from all rows, viewing Identifies type of from table empl.
structure of table, how to perform simple calculation, scalar Demonstration
programming
expression, using column alias, handling nulls, putting text paradigm HOT: Method
Applies the concept Q. Write a query to display employee
practically number, name, sal and annual salary Weekly test
whose commission is not NULL from
Monthly test
table empl.
Q. Write a query to display the name of
employee who is having ‘L’ as any
alphabet of the name.

Date: Name and Signature of the Teacher: Principal:

Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Table Creation and Data Manipulation Commands: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Databases in MySQL- creating databases, programming MLL:
opening databases ,removing databases. Creating Tables- Data Knows uses of Q. Write a query to remove the entire Quiz
Integrity through constraints. Changing data with DML various contents of empl table.
commands- Inserting data into tables, modifying data with programming syntax Q. Write a query to make the changes Questionnaire
update command, deleting data with delete command. More Identifies type of permanent.
DDL commands - ALTER TABLE command, The DROP Demonstration
programming
TABLE Command. paradigm HOT: Method
Applies the concept Q. Write a query to add a Primary Key
practically constraint to the table Employee2 Weekly test
using EmpID column.
Monthly test
Q. Add a Foreign Key reference on the
Employee2 table that will ensure that
employee records with non-existent
departments are to be prohibited.

Date: Name and Signature of the Teacher: Principal:

Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Table Joins and Indexes in SQL: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python MLL: Group Task software.
Introduction, Joins- Using table aliases, additional search programming Q. Define: i) Cross Join ii) Left Join
conditions in joins, joining more than two tables, Equi joins, Knows uses of Q. A table FLIGHT has 4 rows and 2 Quiz
Non-Equi Joins, Natural Joins, Indexes in Database- creating various columns and another table AIR HOSTESS
Indexes in MySQL. programming syntax has 3 rows and 4 columns. How many Questionnaire
Identifies type of rows and columns will be there if we
Demonstration
programming obtain the Cartesian product of these
paradigm two tables? Method
Applies the concept
practically HOT: Weekly test
Q. In a Database Multiplexes, there are
Monthly test
two tables with the following data. Write
MySQL queries for
i) to iii) which are based on TicketDetail
and AgentDetails:
i) To display Tcode, Name and Aname of
all the records where the number of
tickets sold is more than 5.
ii)To display total number of tickets
booked by agent “Mr. Ayush”
iii)To display Acode, Aname and
corresponding Tcode where Aname ends
with “k”.

Date: Name and Signature of the Teacher: Principal:

Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Basics of NoSQL Database - MONGODB: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, NoSQL Databases, Types of NoSQL Databases, programming MLL:
Advantages and Disadvantages of NoSQL Databases. Knows uses of Q. What were the needs and Quiz
Downloading and Installing MongoDB, Working with various requirements that led to the
MongoDB – MongoDB Terminology, starting MongoDB programming syntax development of NoSQL databases? Questionnaire
service, MongoDB Basic Commands, CRUID Operations in Identifies type of Q. What are the main categories of
MongoDB – create operation, read operation, some basic Demonstration
programming NoSQL databases?
operations, Update operation, delete operation. paradigm Method
Applies the concept HOT:
practically Q. Create a database namely petshop Weekly test
in MongoDB having a collection pets in
Monthly test
it. Add following documents in it:
name:”Bruno”, species:”Gerbil”
name:”Teekha”,species:”Piranha”
name:”Tezi”, species:”Cat”

Date: Name and Signature of the Teacher: Principal:

Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Cyber Safety: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Cyber Safety, Safely browsing the web, Identity programming MLL:
protection while using Internet- many ways website tracks you, Knows uses of Q. should you use a nick name when Quiz
private browsing and anonymous browsing. Confidentiality of various you log on to the Internet.
Information – Practices to ensure confidentiality of programming syntax Q. When you shop you always check Questionnaire
Information. Cybercrime – reporting cybercrime. Common Identifies type of the security of the website before you
social networking sites. Appropriate usage of social networks. Demonstration
programming enter personal and credit card
paradigm information. Comment. Method
Applies the concept
practically HOT: Weekly test
Q. Describe the following cyber crime:
Monthly test
a) Cyber Bullying
b) Cyber Stalking
Q. What do you understand by Identity
Theft.

Date: Name and Signature of the Teacher: Principal:

Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
Online Access and Computer Security: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Group Task software.
Introduction, Threats to Computer Security- computer viruses, programming MLL:
spyware, adware, spamming, PC Intrusion, Eavesdropping, Knows uses of Q. Describe why authentication is Quiz
Phishing and Pharming, Cookies. Solutions to Computer various important for file protection.
Security Threats- Solutions to Viruses, Adware and Spyware, programming syntax Q. What is antivirus software? Questionnaire
Solutions to Spam, Eavesdropping, solutions to PC Intrusion, Identifies type of
Solutions to phishing and phishing attacks. Firewall – an Demonstration
programming HOT:
important solution for computer security. paradigm Q. What is the need for secure Method
Applies the concept passwords?
practically Q. What measures should you take to Weekly test
keep data secure?
Monthly test

Date: Name and Signature of the Teacher: Principal:

Lesson Plan
Class/Section………… Subject……………… Chapter………………. No. of periods……………

Date of Commencement …………………. Expected date of completion ………….. Actual date of Completion ……………...

Teaching learning activities planned for

Co-relation
Gist of Lesson Targeted learning achieving the TLO using suitable Assessment
with other
Focused skills/Competencies outcomes (TLO) resources and classroom management Strategies
subjects
strategies Planned
REVISION: Understands the Use of e-content : e-book, powerpoint Individual Task Python is used
Focused Skills -Understanding, Knowledge,Identification, basic concepts of presentation, images and videos. to create
Application: python Practice of: Group Task software.
programming Sample Paper Questions. MYSQL is used
Easy scoring Chapters: Quiz
Knows uses of Previous year questions paper of other at backend.
Online Access and Computer Security various regions of KVS.
Cyber Safety programming syntax Seminars by the students on a Questionnaire
Table Creation and Data Manipulation Commands Identifies type of particular topic.
Demonstration
Simple Queries in SQL programming
paradigm Revision with chapter wise test. Method
Relational Databases
Applies the concept
practically Weekly test

Monthly test

Date: Name and Signature of the Teacher: Principal: