GRADES 1 to 12

        DAILY LESSON LOG

School:

Grade Level:

VI

Teacher:

Learning Area:

TLE-ICT

Teaching Dates and Time:

WEEK 6

Quarter:

4TH QUARTER

MONDAY

TUESDAY

WEDNESDAY

THURSDAY

FRIDAY

1. OBJECTIVES

Objectives must be met over the week and connected to the curriculum standards. To meet the objectives necessary procedures must be followed and if needed, additional lessons, exercises, and remedial activities may be done for developing content knowledge and competencies. These are assessed using Formative Assessment strategies. Valuing objectives support the learning of content and competencies and enable children to find significance and joy in learning the lessons. Weekly objectives shall be derived from the curriculum guides.

1. Content Standard

Demonstrates knowledge and skills in using online survey tools.

Demonstrates knowledge and skills in performing advanced calculations on numerical data using an electronic spreadsheet tool.

2. Performance Standard

Conducts a survey using online tools.

Processes and summarizes numerical data using advanced functions and formulas in an electronic spreadsheet tool.

3. Learning Competency/Objectives

       Write the LC code for each.

• Process an online survey data.
• View and manage responses on an online survey data

TLEIE6-0f-11

• Identify selected Math functions in Excel.
• Use selected math functions in Excel.

TLEIE6-0f-11

• Identify selected text and logical functions in Microsoft Excel.
• Use selected text and logical functions in Microsoft Excel.

TLEIE6-0f-11

• Identify selected statistical functions in Microsoft Excel.
• Use selected statistical functions in Microsoft Excel.

TLEIE6-0f-11

• Create a spreadsheet
• Design Spreadsheet.
• Apply basic formulas on spreadsheet.

TLEIE6-0f-11

2. CONTENT

Content is what the lesson is all about. It pertains to the subject matter that the teacher aims to teach in the CG, the content can be tackled in a week or two.

PROCESSING AN ONLINE SURVEY DATA

SELECTED MATH FUNCTIONS IN EXCEL

SELECTED TEXT AND LOGICAL FUNCTIONS IN MICROSOFT EXCEL

SELECTED STATISTICAL FUNCTIONS IN MICROSOFT EXCEL

FREE GUIDED ACTIVITY

3. LEARNING RESOURCES

1. References

1. Teacher’s Guide pages

2. Learner’s Materials pages

3. Textbook pages

ICT and Entrepreneurship

pp. 60-63

ICT and Entrepreneurship

pp. 66-73

ICT and Entrepreneurship

pp. 74-79

ICT and Entrepreneurship

pp. 81-88

ICT and Entrepreneurship

pp. 66-88

4. Additional Materials from Learning Resource (LR)portal

2. Other Learning Resource

4. PROCEDURES

These steps should be done across the week. Spread out the activities appropriately so that students will learn well. Always be guided by demonstration of learning by the students which you can infer from formative assessment activities. Sustain learning systematically by providing students with multiple ways to learn new things, practice their learning, question their learning processes, and draw conclusions about what they learned in relation to their life experiences and previous knowledge. Indicate the time allotment for each step.

1. Reviewing previous lesson or presenting the new lesson

Review on how to create and disseminate an online survey form.

Review on the previous lesson about “Selected Math Functions in Excel”.

Review on the previous lesson about “Selected Text and Logical Functions in Microsoft Excel”.

Review on the previous lesson about

• “Selected Math Functions in Excel”
• “Selected Text and Logical Functions in Microsoft Excel”.
• “Selected Statistical Functions in Microsoft Excel”

2. Establishing a purpose for the lesson

This is a free guided activity and let the learners work and finish their spreadsheets on their previous lesson on spreasheets.

3. Presenting examples/Instances of the new lesson

Present “Let’s” Study on page 60 of TX.

Present “Let’s Study” on page 66 of TX.

Present “Let’s Study” on page 74 of TX.

Present “Let’s Study” on page 81 of TX.

4. Discussing new concepts and practicing new skills # 1

Discuss “Processing Online Survey Data” on pp. 60-63 of TX.

Discuss “Selected Math Functions in Excel” on pp. 66-71.

Discuss “Selected Text and Logical Functions in Microsoft Excel” on pp. 74-79.

Discuss “Selected Statistical Functions in Microsoft Excel” on pp. 81-88.

5. Discussing new concepts and practicing new skills # 2

Group Activity: Let the learners View and Manage the responses of the Online Survey Form that they have made from the previous lesson.

Group Activity: Let the learners do “Activity 4.1 I’m a Store Manager!” on page 72 of TX.

Group Activity:

Let the learners do “Activity 4.2 I’m a Teacher!” on page 79 of TX.

Group Activity:

Let the learners do “Activity 4.3 I’m a Statistician!” on page 87-88 of TX.

Original File Submitted and Formatted by DepEd Club Member - visit depedclub.com for more

6. Developing mastery

(leads to Formative Assessment 3)

Group Activity: Let the learners work on the spreadsheets they made on the previous lesson. Let them manage and design their spreadsheets with the correct formula in excel.

7. Finding practical application of concepts and skills in daily living

8. Making generalizations and abstractions about the lesson

Let the groups tell what they have learned in this week’s lesson and let them have a reflection on about their learnings

9. Evaluating learning

20 item quiz on Microsoft Excel.

10. Additional activities for application or remediation

5. REMARKS

6. REFLECTION

Reflect on your teaching and assess yourself as a teacher. Think about your students’ progress this week. What works? What else needs to be done to help the students learn? Identify what help your instructional supervisors can provide for you so when you meet them, you can ask them relevant questions.

1. No. of learners who earned 80% in the evaluation

2. No. of learners who require additional activities for remediation who scored below 80%

3. Did the remedial lessons work? No. of learners who have caught up with the lesson

4. No. of learners who continue to require remediation

5. Which of my teaching strategies worked well? Why did these work?

6. What difficulties did I encounter which my principal or supervisor can help me solve?

7. What innovation or localized materials did I use/discover which I wish to share with other teachers?