Grade 8 - Ang Katamaran ngm ga Pilipino ni Dr. JoseRizal
Lesson PlanFull description
free
EXAMPLE LESSON PLANFull description
Full description
planFull description
revit
Full description
I. Objectives
At the end of the lesson, the students should be able to:
-
Identify the different kinds of functions in MS Excel; Be familiar with the steps in usin the different MS Excel functions; and Appreciate the importance of learnin the steps in usin the different MS Excel functions!
II. Subject Matter
A! "opic: Microsoft #ffice Excel $%%& B! Sub ' "opic: "opic: Microsoft Excel (unctions )! *eference: +emma e-elopment .roup! #ffice /roducti-ity! $%%0! +emma Inc! ! Materials: Multimedia M ultimedia /ro1ector, 2aptop )omputer, /ower/oint /resentation, )artolina, 3hiteboard and 3hiteboard 3hiteboard Marker III. Learning Activities
A! /reparatory Acti-ities Acti-ities a! #penin /rayer b! .reetins c! )heckin of Attendance B! *e-iew of the /ast 2esson a! efine formula! b! 3hat are the arithmetic arithmetic operators used in formulas4 formulas4 c! 3hat are the common formula error messaes that may appear in MS Excel4 )! Moti-ation Abstract 3ord Boxes "he students will be di-ided into & roups with 5% members each! A -isual aid containin 6 boxes with hidden word related to the present topic will be shown to them! "he roups will be i-en & minutes to fiure out the hidden words! "he roup who will et all the hidden words or answer the most number of correct items wins the ame! ! 2esson /roper 5! iscuss and explain the commonly used MS Excel functions! MS Excel (unctions
(unction S8M
(ormat 7 Syntax 9S8M)A:)A
A
9A
MA=
9MA=)A:)A
MI>
9MI>)A:)A
)#8>"
9)#8>")A:)A
8se )alculates the total of the -alues or rane of cells! )alculates the arithmetic mean of a rane of cells or -alues! .i-es the hihest -alue in a rane of cells or -alues! .i-es the lowest -alue in a rane of cells or -alues! )ounts the number of cells in a rane of cells!
Example 9S8MA5:A$
9A
9MA=A5:A$
9MI>A5:A$
9)#8>"A5:A$
$! iscuss and demonstrate the stpes in usin the different Excel functions! Steps in usin the MS Excel (unctions 5! )lick on the cell you want to perform the formula! $! #n the Standard "oolbar, click the AutoS8M arrow and a drop ' down list will appear! &! )lick on S8M, A or )#8>" and choose with the mouse pointer the rane of cells you want to calculate! ?! )lick the Enter key to finish the formula! IV. Application
"he teacher will assin a pair of students for e-ery computer unit to work on with a hands ' on acti-ity! "he students will be i-en 5% minutes to finish their acti-ities! 5! )rete a new file and enter the followin data! $! )ompute for the sum and a-erae of the i-en -alues for each computer part! &! .i-e the maximum and minimum -alues of the i-en alues for each computer part! ?! )ount the number of -alues you entered for each computer part! 6! Sa-e your file as A)"I
Item >o!
escriptio n
Monitor
+a n $5 % 55 5 $$ D 5
(e b &$ % $& ? 55 % $& 5
5
Mouse
$
Ceyboard
&
/rinter
? 6
Scanner
0D
0
Ma r $? 6 &D D
"ota l
A-e!Sales7Mont h
Mi n
Ma x
)oun t
D6 &5 5 5% 5
V. Evaluation
IE>"I(I)A"I#>: 3rite the correct answer on the space pro-ided!
=MAX(CA:CA) Standard Toolbar Sum ∑ Functions Max A!ra"! Count Min
=COUNT(CA:CA)
5! "he function that calculates the total of the -alues or rane of cells! $! "he function that i-es the lowest -alue in a rane of cells or -alues! &! "he function that calculates the arithmetic mean of a rane of cells or -alues! ?! Built ' in formulas you can use to make your worksheet construction easier! 6! "he function that counts the number of cells in a rane of cells! ! .i-es the hihest -alue in a rane of cells or -alues! ! "he AutoS8M (unction is located in the! 0! "he symbol of AutoSum is ! D! "he format 7 syntax of the )#8>" (unction is ! 5%! "he format 7 syntax of the MA= (unction is ! Answer Cey: 5! Sum
6!)ount
D! 9)#8>")A:)A
$! Min
! Max
5%! 9MA=)A:)A
&! A-erae
! Standard "oolbar
?! (unctions
0! F
VI. Generalization
(unctions are built ' in formulas you can use to make your worksheet construction easier! "he most commonly used MS Excel functions are the followin: S8M ' calculates the total of the -alues or rane of cells! A" Gcounts the number of cells in a rane of cells! In addition, functions are found at the AutoS8M that is located at the Standard "oolbar of the Excel workbook! VII. Assignment / Agreement
A! (ollow ' 8p Assinment 5! )reate a new file and enter the followin data! $! )ompute for the a-erae of the i-en -alues for each student! &! .i-e the maximum and minimum -alues of the i-en rades for each student! ?! )ount the number of rades you entered for each student! 6! Sa-e your file in a ) as )2ASS *E)#*surname! ! )lose your file!
> o!
>ame
5
+uan, Anelina
$ & ? 6
/uno, Brad dela )ruH, "om *osario, Marian )orteH, Anne
)2ASS *E)#* A-era .radin /eriod e 5 $n &r ?t st d d h 0 0 0 D 0 6 ? 0 0 0 ? 00 D D 0 5 0D % D 0 0 0 & 06 0 0 0 D 0% 5 $
Mi n
Ma x
)ou nt
B! Ad-ance Assinment 5! 3hat is I( (unction4 $! 3hat are the steps in usin the I( (unction4 &! .i-e examples 7 instances that you can use the I( (unction!
