CBSE- Computer Science(083) 2023-2024 Lesson Plan

Computer Science (083) 2023-2024 Lesson Plan

 Unit I: Computational Thinking and Programming – 2

Lesson Plan:

Objective: By the end of this unit, students will be able to revise Python topics covered in Class XI, understand functions and their types, work with exceptions, manipulate text files, perform operations on binary files, work with CSV files, and understand basic data structures like stacks.

Duration: 5 lessons (45 minutes for one Lesson)

Lesson 1: Python Revision and Introduction to Functions

• Revision of Python topics covered in Class XI (variables, data types, operators, control structures, loops, etc.)
• Introduction to functions: types of functions (built-in functions, functions defined in a module, user-defined functions)
• Creating user-defined functions
• Arguments and parameters
• Default parameters and positional parameters
• Function returning value(s)
• Flow of execution
• Scope of a variable (global scope, local scope)

Lesson 2: Exception Handling

• Introduction to exceptions and error handling
• Handling exceptions using try-except-finally blocks
• Common types of exceptions and their handling
• Raising exceptions

Lesson 3: Working with Text Files

• Introduction to files
• Types of files: Text file, Binary file, CSV file
• Relative and absolute paths
• Opening a text file
• Text file open modes (r, r+, w, w+, a, a+)
• Closing a text file
• Opening a file using the 'with' clause
• Writing/appending data to a text file using write() and writelines()
• Reading from a text file using read(), readline(), and readlines()
• Seek and tell methods
• Manipulation of data in a text file

Lesson 4: Working with Binary Files

• Basic operations on a binary file
• Opening a binary file using file open modes (rb, rb+, wb, wb+, ab, ab+)
• Closing a binary file
• Importing the pickle module for serialization
• Using dump() and load() methods for reading and writing binary files
• Read, write/create, search, append, and update operations in a binary file

Lesson 5: Working with CSV Files and Introduction to Stacks

• Working with CSV files

  • Importing the csv module
  • Opening and closing a CSV file
  • Writing into a CSV file using writer(), writerow(), and writerows()
  • Reading from a CSV file using reader()

• Introduction to stacks

• Operations on stacks: push and pop

• Implementation of a stack using a list

Assessment:

• Class exercises and practice problems after each lesson
• Unit-level assessment covering topics from all lessons
• Programming assignments to apply the concepts learned

Note: The above lesson plan provides a broad outline. The actual content and pacing may vary based on the students' prior knowledge, learning pace, and the available class time.

Unit II: Computer Networks

Objective:

By the end of this unit, students will understand the evolution of computer networks, data communication terminologies, transmission media, network devices, network topologies, network protocols, and web services.

Duration: 5 lessons (approximately 45 minutes per lesson)

Lesson 1: Evolution of Networking

Objective: Introduce the concept of computer networks and explore the evolution of networking from ARPANET to the internet.

1. Introduction (5 minutes)

• Welcome students and provide an overview of the unit.
• Explain the importance of computer networks in today's digital world.

2. What is a Computer Network? (10 minutes)

• Define a computer network and its purpose.
• Discuss the benefits of computer networks in sharing resources and information.

3. Evolution of Networking (20 minutes)

• Briefly explain the ARPANET, NSFNET, and their significance in the development of the internet.
• Discuss the key milestones and advancements leading to the modern internet.

4. Activity: Timeline Creation (10 minutes)

• Divide students into groups.
• Instruct each group to create a timeline highlighting the major events in the evolution of computer networks.
• Encourage creativity and the inclusion of relevant illustrations or diagrams.

5. Group Presentations and Discussion (10 minutes)

• Each group presents their timelines to the class.
• Facilitate a class discussion to reinforce the key concepts and address any questions.

Lesson 2: Data Communication Terminologies and Switching Techniques

Objective: Introduce data communication terminologies, components, and switching techniques.

1. Concept of Communication and Components (10 minutes)

• Define communication and its relevance in data transmission.
• Explain the components of data communication: sender, receiver, message, communication media, and protocols.

2. Measuring Capacity of Communication Media (15 minutes)

• Discuss bandwidth and data transfer rate as measures of communication media capacity.
• Provide examples and comparisons of different communication media based on their capacity.

3. IP Address and Switching Techniques (15 minutes)

• Explain the concept of an IP address and its role in identifying devices on a network.
• Introduce circuit switching and packet switching techniques, highlighting their differences and applications.

4. Activity: Case Study Analysis (15 minutes)

• Provide a case study scenario involving data transmission.
• Ask students to analyze the scenario and identify the most suitable switching technique.
• Discuss their answers as a class, considering the advantages and disadvantages of each technique.

5. Recap and Discussion (5 minutes)

• Summarize the key points covered in the lesson.
• Address any remaining questions or concerns from students.

Lesson 3: Transmission Media

Objective: Explore different wired and wireless communication media used in computer networks.

1. Wired Communication Media (15 minutes)

• Introduce twisted pair cable, coaxial cable, and fiber-optic cable as examples of wired communication media.
• Discuss their characteristics, advantages, and applications.

2. Wireless Media (15 minutes)

• Explain radio waves, microwaves, and infrared waves as examples of wireless communication media.
• Discuss their characteristics, advantages, and applications.

3. Activity: Media Comparison Chart (15 minutes)

• Divide students into pairs or small groups.
• Instruct them to create a comparison chart highlighting the characteristics and applications of different communication media.
• Encourage them to research and gather additional information if necessary.

4. Group Presentations and Discussion (10 minutes)

• Each group presents their comparison chart to the class.
• Facilitate a discussion to compare and contrast the different media, emphasizing their strengths and limitations.

5. Recap and Reflection (5 minutes)

• Summarize the key concepts covered in the lesson.
• Ask students to reflect on the advantages and disadvantages of wired and wireless communication media.

Lesson 4: Network Devices and Topologies

Objective: Familiarize students with various network devices and network topologies.

1. Network Devices (15 minutes)

• Introduce network devices such as modems, Ethernet cards, RJ45 connectors, repeaters, hubs, switches, routers, gateways, and WiFi cards.
• Explain the purpose and functionality of each device.

2. Network Topologies (20 minutes)

• Define network topologies and their significance in network design.
• Discuss different topologies: bus, star, and tree.
• Explain the advantages and disadvantages of each topology.

3. Activity: Topology Design (15 minutes)

• Divide students into groups.
• Assign each group a scenario and ask them to design a network topology that suits the given requirements.
• Encourage students to consider the advantages and limitations of each topology.

4. Group Presentations and Discussion (10 minutes)

• Each group presents their network topology design and explains their reasoning.
• Facilitate a class discussion to compare the different designs and evaluate their effectiveness.

5. Recap and Reflection (5 minutes)

• Summarize the key points covered in the lesson.
• Ask students to reflect on the factors to consider when selecting a network topology.

Lesson 5: Network Protocols and Introduction to Web Services

Objective: Introduce network protocols and web services, including HTTP, FTP, SMTP, TCP/IP, POP3, HTTPS, TELNET, and VoIP.

1. Network Protocols (15 minutes)

• Define network protocols and their role in facilitating communication between devices.
• Introduce common protocols such as HTTP, FTP, SMTP, TCP/IP, POP3, HTTPS, TELNET, and VoIP.
• Explain their functions and applications.

2. Introduction to Web Services (20 minutes)

• Discuss the World Wide Web (WWW) and its significance in internet-based services.
• Introduce Hyper Text Markup Language (HTML), Extensible Markup Language (XML), domain names, URLs, websites, web browsers, web servers, and web hosting.

3. Activity: Protocol Matching (15 minutes)

• Provide a list of network protocols and a set of scenarios.
• Ask students to match the appropriate protocol to each scenario, explaining their reasoning.
• Discuss the answers as a class, considering the strengths and limitations of each protocol.

4. Group Discussion: Web Services Exploration (10 minutes)

• Divide students into small groups.
• Assign each group a specific web service (e.g., email, file transfer, video conferencing) to explore further.
• Instruct them to research and discuss the underlying protocols and technologies used in their assigned web service.

5. Recap and Conclusion (5 minutes)

• Summarize the key concepts covered in the unit.
• Encourage students to explore and utilize web services responsibly.

Note: Assessments, quizzes, and additional activities can be incorporated throughout the unit to gauge student understanding and reinforce key concepts

Unit III: Database Management

Lesson Title: Introduction to Database Concepts and SQL

Lesson Objectives:

1. Understand the fundamental concepts of databases and their importance.
2. Familiarize students with the relational data model and its components.
3. Introduce students to the Structured Query Language (SQL) and its syntax.
4. Enable students to perform basic SQL operations for database management.
5. Learn how to connect Python with an SQL database and execute queries.

Materials Needed:

• Computer with database management system software installed (e.g., MySQL, PostgreSQL)
• Python programming environment (e.g., Anaconda, Jupyter Notebook)

Lesson Outline:

1. Introduction to Database Concepts (30 minutes) a. Discuss the importance of databases in managing and organizing data. b. Explain key terms and concepts: data, database, DBMS, data models. c. Highlight the advantages of using a relational data model.

2. Relational Data Model (60 minutes) a. Define the basic components: relation (table), attribute (column), tuple (row). b. Explain domain (attribute data type), degree (number of attributes), cardinality (number of tuples). c. Discuss keys: candidate key, primary key, alternate key, foreign key. d. Provide examples and exercises to reinforce understanding.

3. Structured Query Language (SQL) (90 minutes) a. Introduction to SQL syntax and commands. b. Data Definition Language (DDL): create database, use database, show databases, drop database, show tables, create table, describe table, alter table (add and remove attribute, primary key), drop table. c. Data Manipulation Language (DML): insert, delete, select, update, operators (mathematical, relational, logical), aliasing, distinct clause, where clause, in, between, order by, null, is null, is not null, like. d. Aggregate functions: max, min, avg, sum, count, group by, having clause. e. Joins: Cartesian product, equi-join, natural join.

4. Interface of Python with an SQL Database (60 minutes) a. Discuss the importance of integrating Python and SQL. b. Explain the process of connecting Python with an SQL database. c. Demonstrate how to perform insert, update, and delete queries using Python's cursor. d. Show how to retrieve and display data using connect(), cursor(), execute(), commit(), fetchone(), fetchall(), rowcount. e. Provide examples and exercises for hands-on practice.

5. Creating Database Connectivity Applications (60 minutes) a. Explain the process of creating database connectivity applications. b. Guide students in creating Python scripts that interact with an SQL database. c. Discuss the use of %s format specifier or format() to perform queries. d. Allow students to work on a project or exercise to apply their knowledge.

6. Recap and Conclusion (10 minutes) a. Review key concepts covered in the lesson. b. Answer any remaining questions or concerns. c. Summarize the importance of database management and SQL in modern applications.

Note: The duration of each section is approximate and can be adjusted based on the pace and needs of the students.