G D GOENKA PUBLIC SCHOOL, SWARN NAGRI, GREATER NOIDA
LESSON PLAN
        WEEK                                            25.07.25
      SUBJECT                                      Computer science
  CLASS & SECTION                                       XII A/C/D
      CHAPTER                                     Data File Handling (
  TEACHING PERIOD                                        2 and 6
    PRE CONTENT                           Demonastration, Program Excecution
   TOPIC/CONTENT                            Comma Sperated Values(CSV File)
LEARNING OUTCOMES          1.   Understand the concept and structure of CSV files.
                           2.   Perform reading from and writing to CSV files using Python.
                           3.   Differentiate between reader, writer, DictReader, and
                                DictWriter from the csv module.
                           4.   Apply file handling techniques to process tabular data.
SKILLS INCORPORATED  Use of csv module in Python
                         File operations: open, read, write, append
                         Parsing data from files and displaying output
                         Error handling and debugging
                                          ACTIVITY :
 TEACHER CENTRIC :       Briefly revise file handling basics (open(), read(), write())
                         Introduce the concept of CSV (Comma-Separated Values) files
                         Demonstrate reading CSV files using csv.reader and csv.DictReader
                         Provide a sample file (students.csv) and explain its structure
 STUDENT CENTRIC :             Open and explore the sample CSV file
                               Write a Python program to:
                                    o Read the file using csv.reader
                                    o Print each row
                               Modify the program to use csv.DictReader and access values
                                by column name
                                       TEACHING AIDS
      GENERAL
                                Textbook, Marker ,duster, whiteboard, IDLE Software
      SPECIFIC
                        Recent currency exchange data (INR vs USD, Euro, Yen, etc.)
                        Graphs showing movement of exchange rates over time
         REF.
   WEBSITE/BOOKS :                      Sultan Chand Book, Python4csip
    METHODOLOGY         Lecture-Cum-Discussion: Introduce concepts and encourage
                       questioning.
                        Case-Based Approach: Program file ( create csv file)
    INTEGRATION OF                               Smart Board
      TECHNOLOGY
   INTERDISCIPLINARY   --------------------------------------------
       APPROACH
 INNOVATIVE PRACTICE   ------------------------------------------
     POST CONTENT
  REMEDIAL MEASURES    Doubts to be taken at the end of the lecture
      HOMEWORK         Questions given at the back of lesson( Program)
Teacher’s Signature:                                                Principal’s Signature