Document No.
: FM-BES-046
BASIC EDUCATION SCHOOL
Revision No.: 01
Effectivity Date: July 15, 2024
DYNAMIC LEARNING PLAN
Page 1 of 5
COMPUTER I
S.Y. 2024 - 2025
Prepared by:
ROVELYN G. BORQUILLO
Subject Teacher
Reviewed and Approved by:
MARY ANN P. BUNAGAN
ICT and Robotics Area Head
COMPUTER I
This document is a property of University of Saint Louis Tuguegarao. It must not be reproduced or transmitted in any form, in whole or in part, without expressed written permission.
Document No.: FM-BES-046
BASIC EDUCATION SCHOOL
Revision No.: 01
Effectivity Date: July 15, 2024
DYNAMIC LEARNING PLAN
Page 2 of 5
Grading Third
Week 4, 5, January 16-31, 2025
and 6
CONTENT GUIDE
Content VII. Equations and Formulas in Ecxel
A. Inserting and Deleting Columns and Rows
B. Mathematical Computations Using Microsoft Excel
C. Sorting and Filtering Data
D. Charts in Microsoft Excel
E. Previewing and Printing Worksheets
Learning At the end of the lesson, the students should be able to:
Competencies
conduct mathematical operations in Microsoft Excel,
creates formula and use functions in the worksheet,
know how to preview and print worksheet; and
appreciate the importance of equations and formulas in Excel.
Activities Performance Task – See Attachment 1
Written Work – See Attachment 2
Essential How do workbooks and worksheets in Excel help you organize and
Questions manage multiple sets of data efficiently?
Value “The whole point is to live life and be - to use all the colors in the
Statements crayon box.”
- RuPaul
Learning PowerPoint Presentation
Resources Smart Projector
Genyo
Spin the Wheel app
Reference A. Printed
Maximo, Alexander et. al. (2020). Office Productivity. Techfactors
Inc., pp 55-62.
COMPUTER I
This document is a property of University of Saint Louis Tuguegarao. It must not be reproduced or transmitted in any form, in whole or in part, without expressed written permission.
Document No.: FM-BES-046
BASIC EDUCATION SCHOOL
Revision No.: 01
Effectivity Date: July 15, 2024
DYNAMIC LEARNING PLAN
Page 3 of 5
B. Online
ExcelChamps. (2023, November 30). Introduction to Microsoft Excel
| Basics Knowledge + Components + Examples. Excel Champs.
https://excelchamps.com/excel-basics/
GeeksforGeeks. (2021, June 24). Working with Spreadsheets in MS
Excel. GeeksforGeeks. https://www.geeksforgeeks.org/working-with-
spreadsheets-in-ms-excel/
ATTACHMENT 1:
COMPUTER 1
THIRD GRADING S.Y. 2024-2025
WEEK 5 (PERFORMANCE TASK)
NAME: SECTION:
SUBJECT TEACHER: MRS. ROVELYN G. BORQUILLO SCORE: /30
“COMPUTE ME”
TASK SUMMARY
A. Instructions: Create formulas and use functions in the worksheet below. Consider the
rubrics given.
COMPUTER I
This document is a property of University of Saint Louis Tuguegarao. It must not be reproduced or transmitted in any form, in whole or in part, without expressed written permission.
Document No.: FM-BES-046
BASIC EDUCATION SCHOOL
Revision No.: 01
Effectivity Date: July 15, 2024
DYNAMIC LEARNING PLAN
Page 4 of 5
Function
Example: =MIN(C3:C7)
You want to find out who among the students has the lowest grade in the
computer subject for the first grading period
1. You want to determine Lhoyd's average for the whole grading period.
2. You want to find out who among the students has the highest grade in the
computer subject for the third grading period.
3. You want to know the numerical data on the worksheet given.
4. You want to determine the highest grade given to the students for the whole
grading.
5. You want to determine the number of students who have grades in the
second grading.
B. Instructions: Compute the following in the Excel.
1. =(J3^2)/(H2^2)
2. =(B4^2*D2^3+12)/(12^2-4)
3. =B6^2*C4^2
4. = (7^3-3)/(2+2)
5. =3^3+5^2
Rubrics:
Criteria Excellent Proficient Satisfactory Developing
6 5 4 2-3 Improvement
Formula All formulas are Minor errors in Some formula Multiple Formulas are
Accuracy (6 correctly formulas, but errors, but they formula errors missing or
pts) written and they still do not leading to incorrect,
produce provide mostly significantly incorrect producing no
accurate correct results. impact overall outputs. meaningful
results. results. results.
Use of Uses Uses built-in Uses functions Uses functions Does not use
Functions (6 appropriate functions with minor incorrectly or any functions
pts) built-in correctly but errors but they inefficiently, or misuses
functions (e.g., may not be the still function. affecting them
SUM, most efficient results. completely.
AVERAGE, IF, choice.
VLOOKUP)
correctly and
efficiently.
COMPUTER I
This document is a property of University of Saint Louis Tuguegarao. It must not be reproduced or transmitted in any form, in whole or in part, without expressed written permission.
Document No.: FM-BES-046
BASIC EDUCATION SCHOOL
Revision No.: 01
Effectivity Date: July 15, 2024
DYNAMIC LEARNING PLAN
Page 5 of 5
Cell Uses absolute, Uses cell Uses Uses incorrect Does not use
Referencing (6 relative, and references references, but cell cell references
pts) mixed cell mostly correctly with some referencing, or misuses
references but with minor confusion affecting them entirely.
correctly and errors. between calculations.
appropriately. absolute and
relative
references.
Worksheet Worksheet is Worksheet is Worksheet is Worksheet Worksheet is
Organization & well-organized, mostly somewhat lacks disorganized,
Clarity (6 pts) labeled, and organized, with organized, but organization, with unclear or
easy to clear labeling some labels or making it missing labels,
understand; and minor formatting are difficult to making it hard
formulas and formatting unclear. understand to follow.
functions are issues. formulas and
logically functions.
placed.
Accuracy of All calculations Mostly correct Some errors in Many Most
Output (6 pts) are correct, calculations, calculations, calculation calculations are
and the with minor but the errors that incorrect or
worksheet mistakes that worksheet still impact overall missing
produces the don’t impact functions. results.
expected major results.
results.
COMPUTER I
This document is a property of University of Saint Louis Tuguegarao. It must not be reproduced or transmitted in any form, in whole or in part, without expressed written permission.
