GUMACA NATIONAL HIGH SCHOOL
Brgy. Mabini, Gumaca, Quezon 4307
Contact No. 09778248353 School ID: 301325
“Creating Opportunity, Serving the Community, and Building Productive Society”
________________________________________________________________________________________
G10-TLE LESSON PLAN FOR CLASS OBSERVATION 2
Specialization – Computer System Servicing
January 12, 2024 |10:30 am | CSS - Ibalong
I. OBJECTIVES
A. Learning Competency The learners demonstrate and understanding of concepts and underlying principles in
performing computer operations
B. Learning Outcome The learners shall be able to perform computer operations based on a given tasks
C. Learning Objectives 1. To recognize the different parts/elements of an Excel chart
2. To navigate the Chart Tools menu
3. To create a simple chart
II. CONTENT Creating Graph in Microsoft Excel
III. LEARNING
RESOURCES
A. Reference www.microsoft.com/education/Office
B. Other Learning Laptop, projector, internet, computer laboratory
References/ Materials
IV. PROCEDURES
A. Preliminaries a. Prayer
b. Greetings
c. Checking of attendance
d. House rules/ Health protocol reminders
B. REVIEW OF THE Let us have a review of our lesson.
PAST LESSON
Label Diagram. Students will choose and drag the word that corresponds to the
parts of Microsoft Excel using WordWall (online activity site)
Well done class! You clearly understand our lesson yesterday. Remember
class, Knowing the different parts of the Microsoft Excel is important for us to know
how it works so that we can easily use or navigate within the Microsoft Excel.
C. PRIMING
ACTIVITY/ Let us have a short online activity. (Wooclap Survey).
MOTIVATION
The class will answer the online survey form using wooclap:
1. Religion Affiliation.
2. Mode of Transportation you used going to School
Email Address: depedgumacanhs@gmail.com
Contact No. 09778248353 School ID: 301325
This form is a property of Gumaca National High School and the contents are treated confidential.
Therefore, unauthorized reproduction is strictly prohibited unless otherwise permitted by the School Head.
Page 1 of 5
GUMACA NATIONAL HIGH SCHOOL
Brgy. Mabini, Gumaca, Quezon 4307
Contact No. 09778248353 School ID: 301325
“Creating Opportunity, Serving the Community, and Building Productive Society”
________________________________________________________________________________________
Class, analyze the result of the survey?
How did you find the survey form helpful for data presentation?
What do you think of other application of this survey form? Any example?
Well done class!
D. LESSON PROPER
I. ACTIVITY For our next activity, we will have a “Game Show quiz”.
The class will be divided into three groups. I will be playing a timed game show
quiz. Each question has a corresponding point. Most points at the end of the game
will be the winning group
You will be given 20 seconds to answer the each given questions.
1. Bar Chart
2. Columns
3. Pie Charts
4. Line Graphs
5. Histogram
Class, what did you notice in our activity?
What are those samples presented in the activity?
(A Chart)
What is a Chart?
That’s correct! Recalling what we learned from our Geometry/Math subjects, a
Email Address: depedgumacanhs@gmail.com
Contact No. 09778248353 School ID: 301325
This form is a property of Gumaca National High School and the contents are treated confidential.
Therefore, unauthorized reproduction is strictly prohibited unless otherwise permitted by the School Head.
Page 2 of 5
GUMACA NATIONAL HIGH SCHOOL
Brgy. Mabini, Gumaca, Quezon 4307
Contact No. 09778248353 School ID: 301325
“Creating Opportunity, Serving the Community, and Building Productive Society”
________________________________________________________________________________________
chart is a visual representation of data represented by symbols; such as the sample
charts we will see on the screen.”
In Microsoft Excel, we can make charts to display series of numeric data in a
graphical format to make it easier to understand large quantities of data and the
relationship between different series of data.
II. ANALYSIS Now let us look on the picture, what type of graphs is shown in the picture ?
What can you say about the picture? What is all about?
(Projects a sample bar chart on the screen. Pinpoint and define each part/element.)
Discussion of Lesson – INSERTING GRAPHS IN EXCEL
Next, how do we start making a chart in Microsoft Excel? First we need numeric
data.
Class, last meeting we discuss about the different parts of Microsoft excel. Now, we
will insert numeric data to create our sample chart.
Email Address: depedgumacanhs@gmail.com
Contact No. 09778248353 School ID: 301325
This form is a property of Gumaca National High School and the contents are treated confidential.
Therefore, unauthorized reproduction is strictly prohibited unless otherwise permitted by the School Head.
Page 3 of 5
GUMACA NATIONAL HIGH SCHOOL
Brgy. Mabini, Gumaca, Quezon 4307
Contact No. 09778248353 School ID: 301325
“Creating Opportunity, Serving the Community, and Building Productive Society”
________________________________________________________________________________________
(Pull up and project saved data on the screen)
(Demonstrate how to pull up and navigate the Chart Tools Menu)
(Demonstrate how to make a chart)
(Demonstrate how to modify a chart; change its type, figures, colors and schemes)
(Demonstrate how to make other types of chart)
III. ABSTRACTION Group Activity. Chart making Contest
Students will be grouped into three. Each group will pick a task. The pick task
contains the instructions on how to insert graph. Target output is to produce one (1)
colourful chart based on what they pick. They will be given 10 minutes to do the
activity and (3) minutes to present it to the class.
Step 1 – Select the data for which you want to create a chart.
Step 2 – Go to the Insert tab.
Step 3 – on the Chart ribbon, Click on the recommended Charts.
Step 4 – Select one of the graph types of you want to use (click all charts if you
didn’t find your preferred design)
Step 5 – Select the 2D column chart and click OK.
(the student have the option to edit the title of the graphs)
IV. APPLICATION Each group will present their output in front of the class.
The grades will based on the output, They will also give grades on the performance
of their classmates. These are the rubrics for grading their performance.
RUBRICS 10 8 6
Creativity
Clarity
Participation/cooperation
TOTAL
After the performance, the teacher will ask a representative from the other group to
give their feedback. (vice versa)
The teacher will also give her feedback to motivate learner.
E. EVALUATION Quiz
Read the items carefully. Identify the correct order on how to insert graphs on
excel
_____1. Select the data for which you want to create a chart.
_____2. Select the 2D column chart and click OK.
_____3. Go to the Insert tab.
_____4. Select one of the graph types of you want to use (click all charts if you
didn’t find your preferred design)
_____5. On the Chart ribbon, Click on the recommended Charts.
F. ASSIGNMENT Since it’s Friday, Take a rest and enjoy your weekend.
Prepared and demonstrated by:
DAIRYL P. VIRREY
Email Address: depedgumacanhs@gmail.com
Contact No. 09778248353 School ID: 301325
This form is a property of Gumaca National High School and the contents are treated confidential.
Therefore, unauthorized reproduction is strictly prohibited unless otherwise permitted by the School Head.
Page 4 of 5
GUMACA NATIONAL HIGH SCHOOL
Brgy. Mabini, Gumaca, Quezon 4307
Contact No. 09778248353 School ID: 301325
“Creating Opportunity, Serving the Community, and Building Productive Society”
________________________________________________________________________________________
Teacher I
Observed by:
MARIA FE P. GRUTA
HEAD TEACHER III, TLE
Email Address: depedgumacanhs@gmail.com
Contact No. 09778248353 School ID: 301325
This form is a property of Gumaca National High School and the contents are treated confidential.
Therefore, unauthorized reproduction is strictly prohibited unless otherwise permitted by the School Head.
Page 5 of 5
