User:Nawarajbhandary/Real teaching lesson plan 13

From ICTED-WIKI
Revision as of 15:01, 16 May 2024 by Nawarajbhandary (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Real Teaching Lesson Plan Number: 13 (Thirteen)
Subject: Computer Science Class: 11
Period: Third Unit: Four (4)
Topic: Application Package Time: 45 min
Teaching Item: Introduction to Spreadsheet (Microsoft Excel 2010) No. of Students: 23

SPECIFIC OBJECTIVES

  • Explain about the spreadsheet along with features,
  • Perform basic work using the on spreadsheet (MS Excel 2010),

TEACHING MATERIALS

  • Daily materials
  • Laptop with installed office package,
  • Presentation Slide,

TEACHING LEARNING ACTIVITIES

  1. Enter the classroom, and encourage students before starting the lesson for their total participation and also concentration on the lesson, and then write today’s topic on the board.
  2. Begin the class by understanding their opinion and knowledge about the topic and explain importance of spreadsheet on working with large volume of mathematical data for calculation and visualization,
  3. Begin the classroom with more student-centered learning methodology with demonstration method using the Spreadsheet (Microsoft Excel 2010) and command student to follow with me,
  4. Present the content to be covered using PowerPoint presentation followed by the real demonstration method to illustrate topic with all student and teach them about Spreadsheet software, and working with Microsoft Excel (Features, Fundamental of MS Excel, creating and entering data in excel, working with formulas, CURD operation in excel, cell formatting, basic mathematical function etc.),
  5. Encouraging students to ask questions or share their thoughts if they encounter any type of problem and confusions during explanation and demonstration of working with Microsoft Excel 2010,
  6. Follow the learning by doing practical based approach to attain the learning through Microsoft office,
  7. clarifying doubts and summarizing topic in brief,

ASSESSMENT

  • Create a blank file and save it in location and enter the numerical data on excel?
  • Perform basic mathematical function like (adding, subtracting, multiply and division with excel)?

HOMEWORK

MS Excel 2010 Assignment work 1
MS Excel 2010 Assignment work 1
  • Prepare basic salary sheet in excel (Assignment Work 1)




MS Excel 2010 Assignment work 2
MS Excel 2010 Assignment work 2
  • Prepare appropriate chart in Ms-excel using the following data (Assignment Work 2)