DepEd ALS Teacher’s Guide Module 3: Digital Applications – Spreadsheets

Welcome to the Session Guides of this Module entitled Why Do I Need to Believe in Science? under Learning Strand 2 Scientific and Critical Thinking Skills of the ALS K to 12 Basic Education Curriculum (BEC).

This module was collaboratively designed, developed, and reviewed by select DepEd field officials and teachers from formal school and ALS, and private institutions to assist,in helping the ALS learners meet the standards set by the ALS K to 12 Basic Education Curriculum (BEC) while overcoming their personal, social, and economic
constraints in attending ALS learning interventions.

This learning resource hopes to engage the learners in guided and independent learning activities at their own pace and time. Furthermore, this also aims to help learners acquire the needed 21st century skills while taking into consideration their needs and circumstances.

As an ALS Teacher/Instructional Manager/Learning Facilitator, you are expected to orient the learners on how to use this module. You also need to keep track of the learners’ progress while allowing them to managentheir learning. Moreover, you are expected to encourage and assist the learners as they do the tasks included in the module.

We deal with numbers every day. For example, we budget our money for our food, fare, clothing, and other expenses.

Calculating numbers is a skill we can easily do and apply in our daily lives, but what if you need to calculate larger numbers and bigger sums such as in banks, department stores, supermarkets, grades, or payrolls? This is where spreadsheet programs take part, as it helps in computing and organizing data.

This module will walk you through how to use spreadsheets to help you get familiar with it. The following are the three lessons in this module:

Session Guide No.1

  • Lesson 1 − Understanding Spreadsheets

Learning Objectives:

1. Use the spreadsheet application to generate different documents.

2. Create a new spreadsheet based on the different available templates.

3. Demonstrate how to save a spreadsheet under another name, as another file type, and to a location in a drive.

4. Distinguish the different uses of zoom tools.

5. Determine the use of the different toolbars.

6. Demonstrate understanding of using cells in a spreadsheet.

7. Apply the process of modifying rows and columns.

8. Customize worksheets.

Session Guide No.2

  • Lesson 2 − Using Formulas and Formatting Cells

Learning Objectives:

1. Employ good practices in using arithmetic formulas and functions in spreadsheets.

2. Create formulas using cell references and arithmetic operators.

3. Identify errors in a formula.

4. Use relative and absolute cell referencing in formulas.

5. Employ spreadsheet functions.

6. Use logical functions.

Session Guide No.3

  • Lesson 3 − Inserting Charts and Finalizing Spreadsheets

Learning Objectives:

1. Create different types of charts in a spreadsheet.

2. Edit charts in a spreadsheet.

3. Demonstrate the preparation of outputs in a spreadsheet.

ALS Accreditation and Equivalency Program: Junior High School Learning Strand 6 Digital Citizenship


Can't Find What You'RE Looking For?

We are here to help - please use the search box below.

Leave a Comment