ICF 9 Q2 Week 4 Day 1

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 4

Republic of the Philippines

Department of Education
REGION II – CAGAYAN VALLEY
SCHOOLS DIVISION OF ISABELA
GAMU AGRI-FISHERY SCHOOL
LINGLINGAY, GAMU, ISABELA

Semi-Detailed Lesson Plan in GRADE 9 Internet Computing Fundamentals


2nd Quarter, 4th week,
(DAY 1)

A. Content Standards The Learner independently demonstrates common competencies of


Excel Operate a Spreadsheet Application
B. Performance Standards The learner efficiently performs on how to operate Spreadsheet
Application
I.Objectives At the end of the lesson, the learners should be able to:
a. Understand basic computational operations in Excel.
b. Learn to manipulate and analyze data relevant to
Internet Computing.
Apply formulas and functions to perform calculations and
create visualization.
Title Perform Computational Operation
MELC’s The learner will Perform Computational Operation
References https://www.scribd.com
kevinstratvert.com
Teaching Materials and Laptop with Microsoft Excel installed
Devices Projector or TV for demonstration
Integration This lesson plan integrates direct instruction, guided practice, and
collaborative learning, ensuring students grasp both the theoretical
and practical aspects of computational operations in Internet
Computing Fundamentals.
II. Procedure
C. Daily Routine A. Prayer
 The teacher asks a learner to lead the prayer.
B. Greetings

C. Checking of attendance
 The teacher checks the attendance with the help of
the attendance officer.
D. Giving of Classroom Rules/Preparing the Classroom for
Learning
 She reiterates the classroom rules.

D. Review ACIVITY 1. MATCH ME!


Match the Keyboard shortcuts to its function.

__1. Ctrl+Home a. To the beginning of the worksheet

__2. Ctrl+End b. One cell to the right

__3. Tab c. To the previous sheet in the


workbook

__4. Shift+Tab d. One cell in the direction of the arrow

__5. Ctrl+Page Up e. One cell to the left

__6. Any arrow key f. To the last or first non-empty cell in


the
direction of the arrow
__7. Ctrl+arrow key g. One screen to the left

__8. Alt+Page Down h. One screen to the right

__9. Home i. To the beginning of the active cell’s


row

__10. Alt+Page Up j. To the bottommost, rightmost cell in


the Worksheet that contains data.

E. Motivation NUMBER RELAY!


The students will relay the numbers using different actions.
F. Presentation The teacher will ask the students” from the game or activity that you
did, what do you think is our topic for today?’’
G. Discussion The teacher will discuss the following through PowerPoint
presentation and Microsoft Excel.

1. Input: Date or information that is fed into a system for


processing.
2. Output: The result produced by a computer after processing
input.
3. Process: The act of manipulating or transforming data to
generate output.
4. Store: Saving data for later use, often in databases or files.
5. Retrieve: Accessing or fetching stored data when needed.
6. Execute: Carrying out a sequence of instructions or
commands.
7. Compute: Performing mathematical calculation.
8. Transfer: Moving data from one location to another, often over
a network.
9. Update: Modifying existing data or software to improve or
correct it.
10.Monitor: observing system performance or data changes in
real time.

The teacher will show an example of computation applying the terms


above.

H. Application The teacher will pick a name in a box that contains the name of each
student and will try to do the computation in front.
III. Evaluation Question:

1. What is the formula in computing the final or general average


of each student?

IV. Assignment The teacher will ask to write a short reflection (1-2 paragraphs)
about what they learned regarding computational operations and
their application in programming.

Prepared By: Checked By:

KIMBERLY C. PARAYAOAN JUAN F. AGGABAO JR.


LSB Teacher Head Teacher III

Noted by:
LAILANIE A. NICOLAS

Secondary School Principal I

You might also like