The City School

Cantt Campus Gujranwala

Daily Lesson Plan
Class 6 Subject ICT Topic
Analyzing Data

Date 15.08.22 Duration 70 min Term 1st

By the end of the lesson the students will be able to;

Learning
Objectives:  Use the CONCATENATE function to combine the value of two cells
 Use LEFT function to select the text from a cell string
 Use Multiple IF condition on cells and use IF&AND function
 Computers ICT lab 2, PPT, multimedia. Introduction to Pakistan.ppt
 MS Excel 2013
Resources:  Chapter – analyzing Data
 Analyzing Data- Exercise Handout
 Exercise.xls – Soft Copy

Starter Checking Prior Knowledge: -

Activity: 2min
 Share the learning objectives.
 A brain storming session about the objective they have learn in previous class
about Microsoft Excel 2013

Learning Exposition: 3min

Activities:
Teacher will ask from the learners to comprehend sequences and programing and write
basic code, showing on board.
Teachers should follow the course B resource video for lesson 6 to conduct this lesson
Practice:

Ask learners to open the “analyzing Data” chapter in their computing e-book.
• Elaborate the content and demonstrate all required skills mentioned in the planning
guide.

Production Task: 40

Explain and demonstrate the following skills as per the instructions of computing e-book min
by performing Part A of “analyzing Data” exercise:
• Insert a column between data cells.
• Use the TODAY function to insert the current date in a cell.
• Use the CONCATENATE function to combine the value of two cells.
• Use the SUM function to calculate values.
• Use the LEFT function to select the text from a cell string.
• Use the SUBSTITUTE function to replace a particular word/value with another
word/value.

Planned by: Sadia Sabeen

 • Use IF condition on cells.
• Use Multiple IF condition on cells.
• Use IF&AND function.
• Apply different borders on cells.
 Distribute the “analyzing Data - Exercise Handout” to all learners and ask them to
attempt the “Part A” of the exercise with the help of computing e-book.

20min

Plenary: 5 min
Ask them what did they learn today?
Assessment
Opportunities: Class discussion and practice task

Home
Learning:

Lesson
Evaluation(s):

Planned by: Sadia Sabeen

 The City School
Cantt Campus Gujranwala
Daily Lesson Plan
Class Nursery Subject ICT Topic Orientation
Date 15.08.22 Duration 70 min Term 1st

Learning By the end of the lesson the students will be able to;
Objectives:
 Interaction with students
Sensory room, video
Resources:

Starter
Checking Prior Knowledge: -
Activity: 5min
Introduction with students

Planned by: Sadia Sabeen

 5

min

Exposition:

After introduction teacher will ask to learners about their favorite cartoon
Learning character and she will bring them to sensory room and play the nursery rhymes.
30min
Activities:
Practice:

 https://www.youtube.com/watch?v=RWH8_tvsMBc
 https://www.youtube.com/watch?v=ztEmqebRTNo

25min

How was the day and how was the ICT lesson?
Plenary: 5 min

Assessment
Opportunities:

Home
Learning:

Lesson
Evaluation(s):

Planned by: Sadia Sabeen

 The City School
Cantt Campus Gujranwala
Daily Lesson Plan
Class 3 Subject ICT Topic Analyzing Data
Date 02.03.22 Duration 70 min Term 2nd

By the end of the lesson the students will be able to;

Learning
Objectives:  Understand the difference between a cell and cell range
 Create a new excel worksheet and sum formula

Resources:
Microsoft Excel 2016, Chapter - Analyzing Data, Toy Sale.xls – Softcopy

Starter
Activity: 2min
Checking Prior Knowledge: -

Spend 15 minutes to revise the skills taught in the previous class.

Learning Exposition: 5min

Activities:
Ask learners to open the “Analyzing Data” chapter in their computing e-book.
Use the “Toy Sale.xls” softcopy or any other excel file for demonstration purpose.

Practice:

Familiarize learners with the standard toolbar of MS Excel. Learners will work in pairs.

 Familiarize with Microsoft Excel Interface.

 Understand the difference between a cell and cell range.
 Create a new excel worksheet
 Manually adjust the column’s width.
 Change and adjust the row height.
 Use of addition
 Save the worksheet.
40min
Production Task:

Planned by: Sadia Sabeen

 After the practice learners will practice the above-mentioned individually.

20min

Plenary: How did we learn today? 3 min

Assessment
Discussion and Toy sale worksheet file
Opportunities:

Home
Learning:

Lesson
Evaluation(s):

The City School

Cantt Campus Gujranwala
Daily Lesson Plan
Class 3 Subject ICT Topic Analyzing Data
Date 09.03.22 Duration 70 min Term 2nd

Learning By the end of the lesson the students will be able to;
Objectives:  Use of addition, subtraction, division and multiplication formula

Resources: Microsoft Excel 2016, Chapter - Analyzing Data, Toy Sale.xls – Softcopy

Starter Checking Prior Knowledge: -

Activity:
Teacher will ask from learners about the tables and how we use tables 2min

Planned by: Sadia Sabeen

 5min

Exposition:

Use the “Toy Sale.xls” softcopy and perform the Analyzing Data exercise for
demonstration purpose.
Practice:

Students will work in pairs and complete the following functions

 Open an existing worksheet.
 Manually adjust the column’s width.
Learning
 Change and adjust the row height.
Activities:
 Use of addition, subtraction, division and multiplication formula.
 Print previews the worksheet.
 Save the worksheet. 40min
 Print the worksheet.

Production Task:

Learners will repeat the task individually, teacher will divide the class into two halves one
halve will work and the other halve will revise the concept from the book.

20min

Plenary: Feedback will be taken through www (what went well) 3 min

Assessment
Class Discussion and assigned task
Opportunities:

Home
Learning:

Lesson
Evaluation(s):

Planned by: Sadia Sabeen

 The City School
Cantt Campus Gujranwala
Daily Lesson Plan
Class 5 Subject ICT Topic Building a website
04.03.22,
Date Duration 70min+70min Term 2nd
11.3.22

By the end of the lesson the students will be able to;

Learning
 Understand the purpose of the website and webpage
Objectives:  Create Mobirise account.

Resources:
Mobirise , Building a Website – Soft Copies folder, building a Website- Exercise Handout

Starter
Activity: 2min
Checking Prior Knowledge: -

Teacher will randomly ask from learners the uses and the interface of website

Learning Exposition: 5min

Activities:
Explain and demonstrate the following skills by performing the “part A” of “Building a
website” exercise:
Practice:

After the demonstration, ask all learners to perform the “Part A” of exercise on lab
computers with the help of their e-book.
Students will work in pairs to design a website;

• Creation of Mobirise account.

• Opening and exploring Mobirise interface.
• Selection of website theme.
• Inserting a new webpage.
• Designing a webpage.
• Modify the main menu navigation.
• Use formatting and editing tool. 40min
• Insert photos and galleries.
• Add, subtract and rename web pages.
Production Task:

Students will repeat this task individually and repeat all the steps and create a
website.

Planned by: Sadia Sabeen

 20min

Plenary: What is the purpose of the website and webpage? 3 min

Assessment
Students will be assessed during the practical
Opportunities:

Home
Learning:

Lesson
Evaluation(s):

The City School

Cantt Campus Gujranwala
Daily Lesson Plan
Class KG Subject ICT Topic Code.org. Loops
Date 07.03.22 Duration 70 min Term 2nd

Learning By the end of the lesson the students will be able to;
Objectives:
 Develop puzzle solving and algorithmic thinking

Resources:
ICT, Internet Access, teachers official email account, Course A resource.pdf

Starter
Activity: 2min
Checking Prior Knowledge: -

Teacher will ask to the learners about drag and drop.

Learning Exposition: 5min

Activities:
Teachers should follow the course A resource PDF for lesson 7 to conduct this lesson.

Practice:

Project a puzzle from lesson 7. This lesson serves as an introduction to loops. Loops allow
for students to simplify their code by grouping commands that need to be repeated.
Students will develop critical thinking skills by noticing repetition in movements of their

Planned by: Sadia Sabeen

 classmates and determining how many times to repeat commands. By seeing

"Happy Maps" again, students will get the chance to relate old concepts such as
sequencing to the new concept of repeat loops. 40min

Production Task:

Learners will complete the puzzle individually.

Lesson 7. Code.org Course A

20min

Plenary: What did you learn today? 3 min

Assessment
Class Discussion and assigned task
Opportunities:

Home
Learning:

Lesson
Evaluation(s):

The City School

Cantt Campus Gujranwala
Daily Lesson Plan
Class KG Subject ICT Topic Code.org. Sequencing
Date 28.02.22 Duration 70 min Term 2nd

Learning By the end of the lesson the students will be able to;
Objectives:
 Develop algorithmic thinking and sequencing.

Planned by: Sadia Sabeen

 Resources:
ICT, Internet Access, teachers official email account, Course A resource.pdf

Starter
Activity: 2min
Checking Prior Knowledge: -

Teacher will ask to the learners about sequence by following the map.

Exposition: 5min

Teacher will line up all the students and tell them to move towards their seats in a
sequence and teacher will guide them by mapping the locations.

Teacher will tell the students that today we are going to learn about the sequence
and maps.

Practice:

Teacher should draw and explain the compass on the board to explain east, west, north
and south. Then teacher will login students Code.org account and guide them how to
make a sequence.
Learning Students will work in pairs to complete the sequential worksheet online.
Activities: Lesson 6. Code.org Course A
Production Task:
40min
 The teacher will plan an individual assessment activity for the learners.

 The teacher will divide the class into two halves and instruct them for the
assessment.
 One half will use computers to complete the given task whereas the other group
will use paper and pencil to complete the task. They will swap the activity after the
given time.
 The teacher will monitor them while working on computers and assess them using
the Skills Assessment Sheet
 You are to assess the students on unit 10, 11 and 12 in lesson 6.
20min

Plenary: Feedback will be taken through www (what went well) 3 min

Assessment
Code.org worksheet and practical
Opportunities:

Home
Learning:

Lesson
Evaluation(s):

Planned by: Sadia Sabeen

 The City School
Cantt Campus Gujranwala
Daily Lesson Plan
Class 4 Subject ICT Topic Modular Designing
03.03.22
Date Duration 70min+70min Term 2nd
10.03.22

By the end of the lesson the students will be able to;

Learning
Objectives:  Use available templates to create designs and plans
 Search different shapes and objects and Connect shapes and objects with

Resources:
Edraw Max 9.0, Chapter – Modular Designing, Modular Designing– Exercise Handout

Starter
Activity: 2min
Checking Prior Knowledge: -

Teacher will randomly ask from learners the uses and the interface of website

Learning Exposition: 5min

Activities:
Ask learners to open the “Modular Designing” chapter in their computing e-book.
 Elaborate the content and demonstrate all required skills mentioned in the
planning guide.
 Edraw Max is a diagramming and vector graphics application.
 It offers different templates with pre-defined objects and shapes, which can be
used to design house layouts, office layouts, network diagram and electrical work.
Practice:

After the demonstrate the following skills as per the instructions of teacher, students
performing Part A of “Modular Designing” exercise:

 Familiarize with Edraw Max’s user interface.

 Use available templates to create designs and plans.
 Search for different shapes and objects.
 Connect shapes and objects with connector lines. 40min
 Change the color of connector lines and arcs.
 Resize and rotate objects.
 Apply color on inserted objects/shapes.
 Inserting text on the design.
 Save the design file.

Planned by: Sadia Sabeen

 Production Task:

Students will repeat this task individually and repeat all the steps and create
design and complete the exercise “Modular Designing” individually. 20min

Plenary: What did we learn today? 3 min

Assessment
Students will be assessed during the practical
Opportunities:

Home
Learning:

Lesson
Evaluation(s):

The City School

Cantt Campus Gujranwala
Daily Lesson Plan
Class 1 Subject ICT Topic Code.org. loops
Date 07.03.22 Duration 70 min Term 2nd

Learning By the end of the lesson the students will be able to;
Objectives:
 Develop puzzle solving and algorithmic thinking

Resources:
ICT, Internet Access, teachers official email account, Course A resource.pdf

Starter
Activity: 2min
Checking Prior Knowledge: -

Teacher will ask to the learners about drag and drop.

Learning Exposition: 5min

Activities:
Teachers should follow the course A resource PDF for lesson 7 to conduct this lesson.

Practice:

Project a puzzle from lesson 7. This lesson serves as an introduction to loops. Loops allow
for students to simplify their code by grouping commands that need to be repeated.
Students will develop critical thinking skills by noticing repetition in movements of their
classmates and determining how many times to repeat commands. By seeing

Planned by: Sadia Sabeen

 "Happy Maps" again, students will get the chance to relate old concepts such as
sequencing to the new concept of repeat loops.
40min

Production Task:

Learners will complete the puzzle individually.

Lesson 7. Code.org Course A

20min

Plenary: What did you learn today? 3 min

Assessment
Class Discussion and assigned task
Opportunities:

Home
Learning:

Lesson
Evaluation(s):

The City School

Cantt Campus Gujranwala
Daily Lesson Plan
Class 1 Subject ICT Topic Code.org. Sequencing
Date 28.02.22 Duration 70 min Term 2nd

Learning By the end of the lesson the students will be able to;
Objectives:
 Develop algorithmic thinking and sequencing.

Planned by: Sadia Sabeen

 Resources:
ICT, Internet Access, teachers official email account, Course A resource.pdf

Starter
Activity: 2min
Checking Prior Knowledge: -

Teacher will ask to the learners about sequence by following the map.

Exposition: 5min

Teacher will line up all the students and tell them to move towards their seats in a
sequence and teacher will guide them by mapping the locations.

Teacher will tell the students that today we are going to learn about the sequence
and maps.

Practice:

Teacher should draw and explain the compass on the board to explain east, west, north
and south. Then teacher will login students Code.org account and guide them how to
make a sequence.
Learning Students will work in pairs to complete the sequential worksheet online.
Activities: Lesson 6. Code.org Course A
Production Task:
40min
 The teacher will plan an individual assessment activity for the learners.

 The teacher will divide the class into two halves and instruct them for the
assessment.
 One half will use computers to complete the given task whereas the other group
will use paper and pencil to complete the task. They will swap the activity after the
given time.
 The teacher will monitor them while working on computers and assess them using
the Skills Assessment Sheet
 You are to assess the students on unit 10, 11 and 12 in lesson 6.
20min

Plenary: Feedback will be taken through www (what went well) 3 min

Assessment
Code.org worksheet and practical
Opportunities:

Home
Learning:

Lesson
Evaluation(s):

Planned by: Sadia Sabeen

Planned by: Sadia Sabeen