Lesson Plan 1
Subject: Computer Science Date:
Class: 8 Venue: Classroom Period/Day:1
Unit/Chapter: Introduction to MS Access 2016
Topic: Database Management Concepts Class Duration: 60 min
Learning Objectives • Define the term Database.
• Explain the requirement for a database.
• Discuss the four types of databases.
• Define the terms— Relational Database, Records, and Fields.
Learning Outcomes Learners will be able to Understand:
Terms – data, database.
Elements of Database.
Need of Database Management System (DBMS).
Functions of a DBMS.
Explain the meaning of DBMS.
Discuss the functions of a DBMS.
Explain the meaning of a primary key.
Materials/Resources 1. White board
(including ICT resources) 2. Textbook
3. Notebooks
4. Videos link given in ebook.
Pedagogical Strategy:
Planned Activity (Teacher) Student Activity
Teacher starts the topic by asking to Learners get the idea of the
E - Energize learners
acknowledge names like MySQL, Oracle topic.
DBMS.
Introduce this lesson with Learners understand the
N - Navigate content discussion database concepts. concept and make note of
important points
Extended by explaining various
capabilities that database
possesses.
G- Generate Meaning Teacher asks the question: Learners answer these
questions
Differentiate between Data and
Information.
Explain the 2 requirements of
Primary Key.
A - Apply to real life Teachers ask Learners: Learners answer the question.
How will you save the data of a class in
which you have to organize name, Roll
number, marks of all students in a class?
To check the learner 's understanding, Learners participated in Quiz.
G - Gauge the learning the teacher divided the class into
groups and conducted a quiz.
Teacher asked learners to search more about RDMS softwares.
E - Extend
Support Strategy:
Inclusion Strategies Teacher will give more time to those who need more support.
Challenge Strategy:
Extra worksheet given to confident learners.
Learners are asked to solve the back chapter exercise.
Remedial Teaching Plan
Prepared By: Checked and verified by:
Lesson Plan 2
Subject: Computer Science Date:
Class: 8 Venue: Classroom Period/Day:2
Unit/Chapter: Introduction to MS Access 2016
Topic: Introducing MS Access 2016 Class Duration: 60 min
Learning Objectives
Identify the elements of Access 2016.
Demonstrate how to start Access.
Demonstrate how to create a database from template and from
scratch, and also to save the database.
Learning Outcomes Learners will be able to:
Open a Database application.
Create a new database from scratch.
Use built-in databases as well.
Save the database files with an appropriate extension.
Materials/Resources White board
(including ICT resources) Textbook
Notebooks
Videos link given in ebook.
Pedagogical Strategy:
Planned Activity (Teacher) Student Activity
Teacher starts the topic by asking a few Learners answers the
E - Energize learners
questions from previous topic. questions.
Teacher starts the lesson by setting a Learners understand the
N - Navigate content projector to show: concept and make note of
important points
How to open an Access
application.
Choose from built – in databases.
OR go for blank database.
G- Generate Meaning Teacher dictates the steps of the topic Learners note down the steps.
for the learners to jot it down.
A - Apply to real life Teachers ask Learners: Learners answer the question.
Do you have MS Access in your
Systems?
To check the learner 's understanding, Learners participated in Quiz.
G - Gauge the learning the teacher divides the class into groups
and conducted a quiz.
E - Extend Teacher asks learners to explore the other options of a database window.
Support Strategy:
Inclusion Strategies Teacher will give more time to those who need more support.
Challenge Strategy:
Extra worksheet given to confident learners.
Remedial Teaching Plan
Prepared By: Checked and verified by:
Lesson Plan 3
Subject: Computer Science Date:
Class: 8 Venue: Classroom Period/Day:3
Unit/Chapter: Introduction to MS Access 2016
Topic: Introducing MS Access 2016 Class Duration: 60 min
Learning Objectives
Spell out the rules for naming a field correctly.
Describe the data types available in Access 2016.
Discuss and demonstrate how to assign a data type.
Demonstrate the 2 types of views- Datasheet view and Design
View.
Learning Outcomes Learners will be able to:
Understand the need of choosing a particular data type.
Know about Rules for naming a field.
Differentiate between Datasheet and Design view of application.
Materials/Resources White board
(including ICT resources) Textbook
Notebooks
Videos link given in ebook.
Pedagogical Strategy:
Planned Activity (Teacher) Student Activity
Teacher starts the topic by asking a few Learners answers the
E - Energize learners
questions from previous topic. questions.
Teacher starts the lesson by showing Learners understand the
N - Navigate content few pics about the topic. concept and make note of
important points
And explaining each and every point.
G- Generate Meaning Teacher showed the steps on the laptop. Learners note down the steps.
A - Apply to real life Teachers ask Learners: Learners answer the question.
Which datatype should be used
for a field named “Fees”?
To check the learner 's understanding, Learners answer the question.
G - Gauge the learning the teacher asks:
“Out of the fields – PlayerID,
PlayerName, GameWon”, Which is
highly suitable for Primary Key?
E - Extend Teacher asks learners to explore the other options of a database window.
Support Strategy:
Inclusion Strategies Teacher will give more time to those who need more support.
Challenge Strategy:
Extra worksheet given to confident learners.
Remedial Teaching Plan Learners are asked to solve the back chapter exercise.
Reflection
Lesson Plan 4
Subject: Computer Science Date:
Class: 8 Venue: Classroom Period/Day:4
Unit/Chapter: Introduction to MS Access 2016
Topic: Modifying Table Design Class Duration: 60 min
Learning Objectives
To demonstrate how to:
Add/delete a field.
Move a field.
Hide/unhide fields.
Freeze/unfreeze fields.
Change a field’s format.
Learning Outcomes Learners will be able to:
Make modifications on the field such as adding data, delete,
hide/unhide, freeze/unfreeze, change data type.
Materials/Resources White board
(including ICT resources) Textbook
Notebooks
Projector
laptop
Pedagogical Strategy:
Planned Activity (Teacher) Student Activity
Teacher starts the topic by asking a few Learners answers the
E - Energize learners
questions from previous topic. questions.
Teacher starts the lesson by setting the Learners get the concepts.
N - Navigate content projector and showing all the features
of modifying designs of a table.
G- Generate Meaning Teacher explains the steps in written. Learners note down the steps.
A - Apply to real life Teachers ask Learners: Learners answer the question.
“What steps I should follow if I want
some fields to be shown when I scroll
down my page.”
To check the learner 's understanding, Learners try the exercise.
G - Gauge the learning the teacher asks:
E - Extend Teacher asks learners to watch:
[Link]
Support Strategy:
Inclusion Strategies Teacher will give more time to those who need more support.
Challenge Strategy:
Extra worksheet given to confident learners.
Remedial Teaching Plan Learners are asked to solve the back chapter exercise.
Reflection
Lesson Plan 5
Subject: Computer Science Date:
Class: 8 Venue: Classroom Period/Day:5
Unit/Chapter: Introduction to MS Access 2016
Topic: Totaling, Sorting, Filtering, and Searching Data Class Duration: 60 min
Learning Objectives
Demonstrate how to open an already existing database.
Demonstrate how to sum, sort, filter, and search data in Datasheet
view.
How to Use advanced filtering tools in Datasheet view.
Learning Outcomes Learners will be able to:
Open an existing database.
Perform operations such as - sum, average, count, max, min
Filter the values
Sort the data
Advance filtering – Using selection.
Materials/Resources White board
(including ICT resources) Textbook
Notebooks
Projector
Laptop
Pedagogical Strategy:
Planned Activity (Teacher) Student Activity
Teacher starts the topic by asking a few Learners answers the
E - Energize learners
questions from previous topic. questions.
Teacher starts the lesson by setting the Learners get the concepts.
N - Navigate content projector and showing all the steps for
performing calculations, filtering and
sorting of data.
Sum:
Sorting and Filtering :
Data Sorted in ascending Order:
G- Generate Meaning Teacher explains the steps in written. Learners note down the steps.
A - Apply to real life Teachers ask Learners: Learners answer the question.
“Is it possible to see only those student’s
names and marks who scored more
than 80?”
To check the learner 's understanding, Learners answer the question.
G - Gauge the learning the teacher asks:
“Is there any way to check the filtered criteria
that has been applied on the column?”
E - Extend Teacher asks learners to watch:
Support Strategy:
Inclusion Strategies Teacher will give more time to those who need more support.
Challenge Strategy:
Extra worksheet given to confident learners.
Remedial Teaching Plan Learners are asked to solve the back chapter exercise.
Reflection