air force school hasimara lesson plan cbse | informatics ... · pdf fileair force school...

AIR FORCE SCHOOL HASIMARA

Lesson Plan

Board: CBSE | Class: XII | Subject: Informatics Practices

Chapter Name: Computer Networking

Prerequisite

Knowledge

The student should know about the peripherals device. They should also

know that this device works with electronic signals.

Short

Description of

Lesson

This lesson deals with network, terminology of networks, domain name

resolution. The student will learn about network topologies, types of

network. This lesson also tells about transmission media, network

devices and network security

Objectives

The students will be able to

- Understand network

- Identify needs for networking

- Familiarize with nodes, server, MAC address, IP address, Domain

name

- Understand Network topologies, network

- Know the transmission media, network devices

- Acquire knowledge on network security

Aids

White Board, marker , duster, text book, ppt slide, projector

Supplementary

Activities

Reading the important terms, writing glossary in the note copy. They are

asked to read out the important points from ‘Let us Revise”

Procedure

Explaining the term network and its uses in day to day life. Network goals

like resource sharing, reliability, cost factor, communication medium is

explained through examples

1- Once the network is done the print out of the document will be

taken from any system.

2- We can communicate with each other through using speaker and

head phones.

Important terms of network like workstation, server, MAC address, IP

address, domain name is explained by making ppt file.

In practical class IP address is shown by giving command IPconfig at c:\>

prompt.

Network topologies like point-to-point, star, bus ring , tree, graph , mesh,

fully connected is introduced by making figures on the white board along

with its advantage and disadvantage.

With the help of book the transmission media – co-axial, optical fiber etc is

shown. Terms like modem, hub, switch, repeater, gateway, bridge, router

are explained by giving notes. Topic on network security is discussed with

the students as it is the major issue of concern.

After finishing the chapter, the related questions are asked to the.

Expected

Outcome

After completing this lesson, the student will understand the main features

of network and its uses. They will also be able to recognize what types of

topologies are required for connecting network as per its advantage and

disadvantage.

Student

Deliverables

Learn the answers given in the text book.

Write down the selected sample based question answers in the note copy

For example:

1 – What are the different types of networks?

2 – How is Coaxial cable is different from optical fibre?

Assessment Solving text book questions answers


Lesson Plan


Chapter Name: Open source concept

Prerequisite

Knowledge

The student should know about the hardware and software. They should

also know that these two works together.

Short

Description of

Lesson

This lesson tells us about the Open Source Concepts and how they are

different from software, which is not open source.

Objectives

At the conclusion of this lesson, the students will be able –

- To develop ability to use the Open Source Technology

- To understand terminologies and definitions Open Source based

software.

- To recognize the advantage of open standards

- To identify Indian language computing

Aids

Projector and computer system with open source operating system, Book

Supplementary

Activities

Reading the important terms, writing glossary in the note copy. They are

asked to read out the important points from ‘Let us Revise”

Procedure

The lesson is explained by showing the slide made up of all open source

software and free software with illustration. The important key term like

FLOSS, OSS ,ODF are demonstrated with the help of examples given in

the book. Students are asked to write down the notes in a copy.

For example - The terms Free and Open represents a different emphasis on

importance of freedom (free software) or technical progress (open source

software) Explaining Indian Language Computing which refers to ability

to interact in diverse Indian languages on electronic form. It is

demonstrated that Indian Computing Language first needs to address the

issue of encoding Indian Language Character in memory.

Expected

Outcome

- Knows about the different types of open and free software

- Learns basic types on Indian-Language-Text Typing

- Recognize the proprietary and open standard

- Advantages of OSS over proprietary software.

Student

Deliverables

Discussion on the related topic. Writing answers of the given exercise in a

note copy. For example –

a) What is open based software?

b) Expand the term OSI, FLOSS, PHP, LAMP

Assessments To write the answers of Type A and Type B of text book in a note copy


Lesson Plan


Chapter Name: GUI Programming Revision Tour – I

Prerequisite

Knowledge

The students should be aware of the term Application Software and

Programming Software

Short

Description of

Lesson

Introducing the GUI tools and its properties . Learning the basic

components of the Java GUI NetBeans.

Objectives

The students will be able to have a feel of the Java GUI NetBeans and will

be able to use the basic jLabel, jTextFields, jButton controls .

Aids White Board, marker , duster, diagram, text book, computer, ppt slide,

projector, Java NetBeans software

Supplementary

Activities

Developing GUI (Graphical User Interface) using jLabel, jTextFields,

jButton controls .

Procedure

The session starts with a brief recap of Java NetBeans as a programming

tool and its GUI capabilities. The data types, operators of Java and

programming constructs – selection, iteration and jump statement is

explained through examples. Having delivered the concept of using these

tools, students will use them to create better workshops. Explaining the

Text Interaction in Java GUIs – i) getText( )method

ii) parse…… method( )

iii) setText( ) method

iv) JOptionPane.showMessageDialog( ) method

The introduction of these tool will help students understand the need of

designing and interactive form using NetBeans.

Expected

Outcome

The students will innovate / identify areas where they have seen the use of

these tools. They will be able to understand how the result are calculated

and displayed for the user.

Student

Deliverables

Creating a GUI

To enter name of the person and to display Welcome with the entered

name.

Enter the marks in 3 subjects and to display their total using simple

calculation.

Assessments Interacting on the method used for jList and jCombo Box.


Lesson Plan


Chapter Name: GUI Programming Revision Tour – II

Prerequisite

Knowledge

The students should know the fundamental programming concept and the

tools to create GUI in netbean Java.

Short

Description of

Lesson

In this chapter we shall be revising the JAVA GUI programming concepts

using Swing API through NetBeans IDE. Java GUI applications are created

through RAD tools with Classes, Object and methods etc.

Objectives

The students will be able

- To use jText Area , jPassword, jList, jLabel, jCombo boxes along

with its properties.

- To understand the methods used with above controls.

- To create interactive GUI.

Aids Computer System with NetBeans, Projector, Board, Book

Supplementary

Activities

To illustrate the answer graphically.

Make precise and concise notes, point wise.

Procedure

This lesson includes the other important controls where programming is

done through swing API only. After explaining the properties of mentioned

controls, the GUI is designed and the coding is shown on the white board

with the help of projector.

Expected

Outcome

They should be able to use check boxes, radio button, combo boxes while

creating GUI.

Student

Deliverables

Creating JFrame as shown in the

figure as per desire salary.

Assessments Solving the practical problems given in the text book.


Lesson Plan


Chapter Name: GUI Programming Revision Tour – III

Prerequisite

Knowledge

The students should be aware of the controls, child controls

Short

Description of

Lesson

In this chapter concept related with Class, Objects, Constructors and

methods are discussed. In Java method or function is a sequence of some

declaration and executable statements. In Java, which is strictly Object-

oriented, any action can take place through methods and methods

have to be exist as a part of the class.

Objectives

The students will be able to understand

- classes and objects

- methods, scope

- constructors, The this object

- OO terminology

Aids Computer System with NetBeans, Projector, Board, Book

Supplementary

Activities

Students will be asked to create a method and output the result.

Example 1 To adds any two numbers

2 To find out the day no.

Procedure

Demonstrating all the above terms by showing the ppt on the white board

and to make the students understand that any action in Java can take place

through method and the methods have to exist as a part of class.

For example –

int mult(int x, int y) Formal parameter

{

Return x *y;

}

int length = 10;

int width =5;

int area = mult(length, width) Actual parameter

method call

Expected

Outcome

After compilation of this chapter, they should be able to create their own

method and class.

Student

Deliverables

Write a method which takes 3 numbers and displays its sum.

Assessments Writing important terms and text book question answers in a copy.


Lesson Plan


Chapter Name: More about classes and libraries

Prerequisite

Knowledge

The students should know the uses class and methods

Short

Description of

Lesson

The student should have the knowledge of Java coding with container

controls.

Objectives


- Familiarize classes and Java libraries

- Understand how to work with string

- Use predefined Math library

- Create and utilize the packages.

Aids Book, Computer system with Java NetBean,

Supplementary

Activities

Students will be asked to create a method and output the result.

Example 1 To adds any two numbers

2 To find out the day no.

Procedure

In this lesson more about classes and libraries are explained through GUI.

Availability of classes like java.lang, java.util, java.io etc is explained with

real life situation. Related questions are asked before proceeding to the next

term. Illustrating the usage of string method like length(), CharAt(),

CompareTo(), equals() etc in the IT lab by creating simple GUI.

Expected

Outcome

They should be able to create more productive program using Java class

libraries.

Student

Deliverables

The students are asked to use the entire method prototype to make

themselves more comfortable in creating GUI.

Assessments Students are asked to solve the problem given in the book.


Lesson Plan


Chapter Name: Concept of Inheritance

Prerequisite

Knowledge

The students should be aware of the controls, child controls

Short

Description of

Lesson

This chapter deals with inheritance, the capability of one class to derive

properties from another class. It tells about the ways, inheritance is

implemented in Java.

Objectives

Objective – They will be able

- To understand need for inheritance

- To utilize different forms of inheritance

- To familiarize with derive/sub and super/base classes

- To know functions overloading inheritance and constructor

- To gain knowledge on abstract class and interfaces.

Aids Computer system with Netbean Java, Projector, Board

Supplementary

Activities

Reading the chapter and learning the solved answers given in the text book.

Procedure

With the help of book, different forma of inheritance is shown – single,

multiple, hierarchical, multi level, hybrid. The syntax of derived / sub and

super/base classes is explained on the white board

Class <sub class name>extends <super class name>{

: member of subclass

}

Expected

Outcome

After compilation of this lesson, the students should be able to use private,

public and protected members as classes.

Student

Deliverables

Write syntax to define class Methods. What type inheritance does Java

have?

Assessments Students are asked to solve the problem given in the book.


Lesson Plan


Chapter Name: Database Connectivity

Prerequisite

Knowledge

They should know how to create GUI using Java Controls like JTextField,

JLabel, JRadioButton, JCombo etc.

Short

Description of

Lesson

In this chapter we shall know how to connect the front end NetBeans

application with back-end databases through JDBC,ODBC for making GUI

applications.

Objectives

The conclusion of the lesson is to

i) Know classes used for Database Connectivity

ii) Prerequisites for Connecting to mysql from Java

iii) Connecting to mysql from Java

Aids Computer system with Java and Mysql software, Projector & board

Supplementary

Activities

Reading the chapter. Following the steps for connectinvity . (ie)

i) Import the package

ii) Register the JDBC driver

iii) Open the connection.

iv) Execute the query.

v) Process the resultset.

vi) Clean up the environment.

Procedure

Explaining the real-life application where datas are stored and

manipulated. In order to connect to database from within an application, we

need a framework that helps to send and execute SQL statements from

within the appliation code.

Expected

Outcome

They should be able to connect front-end and back-end program .

Student

Deliverables

What is database connectivity?

What tasks does JDBC perform?

Assessments Creating GUI application given in the book during practical period .


Lesson Plan


Chapter Name: Web Application

Prerequisite

Knowledge

They should know the uses and advantage of computers in every day life.

Short

Description of

Lesson

World Wide Web is an example of an information protocol/service that can

be used to send and receive information over the internet. It supports:

• Multimedia Information

• Hyper Text Information

• Graphical User Interface

The World Wide Web is an example of an information protocol / service

that works using a Client/Server software design. A service that uses

Client/Server design requires two pieces of software

to work: Client software (e.g. Web Browser) to request information, and

Server software(Web server)to answer requests and provide their

information. Most Web applications are designed this way.

Objectives

They should be able to understand

i) Application of Web Browser and Web Server .

ii) Communication with Web server.

Aids Computer with MS-Office, Internet Connection, Projector

Supplementary

Activities

Reading the chapter and learning answers of solved problems given in the

book.

Procedure

Beginning with a review of uses of computer, followed by a new lesson,

then by showing practical use of net, and finally ending with a mastery

demonstration.

Expected

Outcome

After studying this lesson students will be able to explore net and collect

information on related topic.

Student

Deliverables

What is Client Server Computing?

In what ways id the WWW different from other servers on the Internet?

Assessments Exploring net and downloading sample question paper from CBSE site.


Lesson Plan


Chapter Name: HTML I- Basic HTML Elements

Prerequisite

Knowledge

The students should know the syntax of different languages used for

writing source code.

Short

Description of

Lesson

The World Wide Web (or simply the Web or WWW) is a system of sharing

interlinked hypertext documents over the internet. These documents are

stored on web-servers on the internet and contain text, images, videos and

other multimedia. These documents also contain hyperlinks to navigate

among them. HTML (Hyper Text Markup Language) is the basic language

which is used to create Hypertext documents. In this lesson we are going to

learn how to create hyper text documents using HTML.

Objectives

The student should be able to

i) Understand HTML and its capabilities

ii) Know writing HTML documents

iii) Recognize container and empty elements.

iv) Acquire knowledge on logical and

Aids Computer System with Ms-Office Software, Projector, Board

Supplementary

Activities

Reading the book and witing all empty and conaitner tag in a copy. Using

the attibute of tags while writing source code.

Procedure

Exlaining the chapter by showing the source code for writing HTML page

by using projector. For ex. <body bycolor=green text=blue>. This attribute

of body tag will give the background page color as green and text color as

blue.

Expected

Outcome

After studying this lesson students will be able to:

i) Define the term hypertext and state the purpose of HTML.

ii) Identify the main parts of an HTML document.

iii) Identify and state the purpose of different HTML elements.

iv )Differentiate between HTML elements, tags, and attributes.

v) Create web pages using different basic and formatting tags.

Student

Deliverables

Following the steps for writing HTML page and browsing it through

Internet explorer.

Assessments 1. What is wring in the following coding?

a) <font name=”arial”>

b) <body margin top=6- left = 75>

2. List and define different types of paragraph alignments?


Lesson Plan


Chapter Name: HTML II – Lists, Tables, Forms

Prerequisite

Knowledge

The students should be aware of writing HTML page in a notepad and

browsing it through browser.

Short

Description of

Lesson

This chapter describes how to make more accessible page by using text

styles, formatting tools, link tools, and tabular data.

Objectives

The conclusion of this lesson is to

i) Help them to use lists, tables and forms tag properly.

ii) Make them understand that these features help the readers to quickly

understand, scan and extract the information.


Supplementary

Activities

Using the all the mentioned tags for creating we page. Practicing and

browsing the attributes of table, forms tag.

Procedure

Writing the attribute and uses of <table>, <form>, <ol>, <ul> tag by the

help of projector on the board.

Expected

Outcome


i) Create web pages using <ol>, <ul>, <table> along with its attribute.

ii) Understand how to use forms in HTML

Student

Deliverables

Creating Web page by using following coding:

<ul>

<li> apples

<li> bananas

<li> grape

</ul>

Assessments

Writing answers of the questions in the class work copy

i) Differentiate between <ul> and <ol> tags.

ii) Write HTML tags are used for table and adding rows in a HTML

document?


Lesson Plan


Chapter Name: XML – eXtensible Markup Language

Prerequisite

Knowledge

Knowledge on HTML page, attribute of container and empty tag.

Short

Description of

Lesson

XML (eXtensible Markup Language) is also a markup language like

HTML. But XML is different from HTML in the sense that HTML

describes how to display and format the data, text and images in the

browser whereas XML is used to describe the data. XML has nothing

to do with presentation of data in the browser. The XML standard was

created by W3C to provide an easy to use and standardized way to store

self-describing data (Self-describing data is data that describes both its

content and its structure).

Objectives


i) Differentiate between HTML and XML.

ii) Know DTD (Document definition type) is a set of rules that defines

what tags appear in an XML document.

iii) Recognize CSS (Cascading Style Sheet) are a collection of forming

rules that control the appearance of content in a webpage.


Supplementary

Activities

Reading the chapter. Following the lab exercise given in the book.

Learnnng the full forms of XML, EDI, CSS, DTD

Procedure

Explanation on how data sharing technology is important and works on

these technologies. Introduction on meta language, XML vs.

SGML,features of XML, XML structure, the prolog, CSS eyc

Expected

Outcome

After completion of the chapter they should be able

i) To understand the difference between HTML and XML.

ii) Create own tag.

iii) To view the XML document in browser.

Student

Deliverables

Try to create an XML document as per the following data given in the

book. Checking the well-formedness XML document.

Assessments

i) What is declared empty tag?

ii) Can you interchange attribute and element? How Why? When?


Lesson Plan


Chapter Name: MYSQL Revision Tour

Prerequisite

Knowledge

Knowledge on Ms-Excel, MS-Access to create databases.

Short

Description of

Lesson

A database system is basically a computer based record keeping system.

There are different data models are available. The most popular data model

is Relational Data Model (RDBMS). In RDBMS data is arranged in the

form of table. MYSQL is software to manipulate database. It is free, open

source RDBMS. In order to access data within MYSQL database, all

programs and users must use, Structured Query Language (SQL).SQL is

the set of commands that is recognized by nearly all RDBMs. SQL

commands can be classified into three categories. These are DDL (Data

Definition Language), DML (Data Manipulations Language) and TCL

(Transmission Control Language). Apart from MYSQL is commands, it

has various functions that performs some operation and returns a single

value. In this chapter we will learn various commands and functions in

MYSQL and its implementation.

Objectives

After studying this lesson the students will be able to:

Define the terms:

(i) Data Models

(ii) SQL Elements

Create tables with SQL constraints

View a table structure

Insert, modify and delete data from tables

Add a constraint to a table, remove a constraint from a table, modify a

column of a table using ALTER TABLE command.

Delete a table using DROP TABLE.

Aids Computer system with MySql software.

Supplementary

Activities

Creating table with constarints as shown F_name char (50), L_name

char(50), DOB date

Procedure

Explaining the various advantage of database system like inconsistency,

redundancy, integerity etc. Showing them table creation by writing

command on the board.

Expected

Outcome

At the conclusion of the lesson, the students will be able to create table

with SQL constraints, Alter tables, view structure of table, add, delete alter

tables.

Student

Deliverables

Using commands in MySql like – Create table <table name>, Show tables,

Select * from <table name> and Using functions like curdate(), SysDate(),

Mod(), round(), Substr() etc. in MySql.

Assessments Differentiate between DDL and DML commands?

Differentiate between Char and Varchar datatype?


Lesson Plan


Chapter Name: Database Transaction

Prerequisite

Knowledge

Knowledge on DBMS and RDBMS.

Short

Description of

Lesson

Reliability is a quality, which we seek for in everything that we get. The

same is applicable to software and to database. A reliable database system

is that which retains our database in a consistent state despite occurrence of

many failures. Database Transaction is the field which requires utmost

consistency. This chapter describes fundamentals of database transactions

and its reliable implementation. A database can be called consistent when it

follows ACID properties. A transactions can be called reliable when it

either COMMITed i.e. successfully all its steps are carried out and changes

are permanently reflected in the database or be ROLLBACKed i.e. in case

of failures, if transaction cannot be successfully completed then any data

changes made by he transaction are brought back to the state that earlier

was prior to the execution of this transaction

Objectives


i) Know Concept of database

ii) Understand Transaction

iii) Use Transaction Control Commands

Aids Computer system with MySql Software , Projector

Supplementary

Activities

Reading the chapter and learning glossary given in the book.

Procedure

Explaining that a database transaction is a logical unit of work. A user

views a transction as a logical sequence of read and write operations.

Expected

Outcome

After studying this lesson the students will be able to:

Define a Transaction

Describe reason why all the tasks in a transaction should be executed fully

or not at all.

Perform basic transactions.

Commit a transaction.

Add Save Points to a transaction.

Roll back a Transaction

Roll back a Transaction to a Savepoint.

Student

Deliverables

Perform the following tasks:

Start MySQL session .

Create a table named Student with columns RollNumber, Name and Marks.

Start a transaction and insert two rows to the Student table.

Verify the inserts by SELECT statement.

Commit the changes.

Start another transaction.

Delete a row that was recently inserted.

Verify that the row has been deleted.

Rollback the changes.

Verify that the delete has been cancelled.

Assessments Writing subjective questions answers in a copy.

i) What do you mean by ACID properties of database transaction?

ii) Why do we use ROLLBACK statement> Explain briefly with the help

of an example?


Lesson Plan


Chapter Name: More on SQL – Grouping Records and Table Joins

Prerequisite

Knowledge

They should know the select commands of SQL query.

Short

Description of

Lesson

This chapter deals with aggregate (group) Functions, type of SQL

functions, Grouping result – Group by joins.

Objectives To grouping records and table joining.

Aids Text Book, Computer with My SQL, Projector

Procedure

Explaining the Group By clause of SQL select statement to join two tables.

In practical class the Group by clause and

equi – join will be shown.

Expected

Outcome

At the end of the lesson, the students will understand how to extract desired

information from database

Student

Deliverables

Reading the chapter and practicing cross join, left join, natural join and

equi-join with the help of clauses.

Assessments Solving text book questions answers, queries etc


Lesson Plan


Chapter Name: IT Application

Prerequisite

Knowledge

The students should know the computers are used in all the area and its

benefits are endless for human mankind.

Short

Description of

Lesson

Three major groups of IT applications covered in this chapter are: e-

governance, e-business, and e-learning. Society is impacted as due to ICT

people change their way of conducting the transactions and thus save their

time, money, and energy

Objectives


- Understand that that an IT application has two major parts: Front-end and

back-end

- Identify various components of the front-end of an application.

- Design and develop simple IT applications.

- List the impacts of ICT

Aids Book, Projector, Computer system

Supplementary

Activities

Writing answer or notes in points.

Revising all the topics

Procedure

Explaining the importance of IT applications which is essential

requirement of every individual and organization to simplify their day-to-

day work, efficiently manage and execute projects.

Expected

Outcome

Understanding the impact of ICT on society and e-Learning applications

which uses technology to effectively deliver and monitor learning and

teaching processes.

Student

Deliverables

Discussion on the topic of IT application as e-Gaming, e-Business,

e-Governance, e-Learning etc.

Assessments Writing subjective questions answers in a copy.

i) What do you understand by e-Business ? Give Examples.

ii) How IT applications are created ?

air force school hasimara lesson plan cbse | informatics ... · pdf fileair force school...

Documents