DepEd ALS Module 3: Digital Applications – Spreadsheets

Welcome to 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 (BEC).

This module was designed to provide you with fun and meaningful opportunities for guided and independent learning at your own pace and time. You will be able to process the contents of the learning resource while being an active learner.

This is a list of all sources used in developing this module.

The following are some reminders in using this module:

1. Use the module with care. Do not put unnecessary mark/s on any part of the module. Use a separate sheet of paper in answering the exercises.

2. Don’t forget to answer the Pre-assessment before moving on to the other activities included in the module.

3. Read the instruction carefully before doing each task.

4. Observe honesty and integrity in doing the tasks and checking your answers.

5. Finish the task at hand before proceeding to the next.

6. Return this module to your ALS Teacher/Instructional Manager/Learning Facilitator once you are through with it.

If you encounter any difficulty in answering the tasks in this module, do not hesitate to consult your ALS Teacher/Instructional Manager/Learning Facilitator. Always bear in mind that you are not alone.

We hope that through this material, you will experience meaningful learning and gain deep understanding of the relevant competencies. You can do it!

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 a spreadsheet program 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:

Lesson 1 – Understanding Spreadsheets

After this lesson, learners should be able to:

  • use the spreadsheet application to generate different documents;
  • create a new spreadsheet based on the different available templates;
  • demonstrate how to save a spreadsheet under another name, as another file type, and to a location on a drive;
  • distinguish the different uses of magnification or zoom tools;
  • determine the use of the different toolbars;
  • demonstrate understanding of using cells in a spreadsheet;
  • apply the process of modifying rows and columns; and customize worksheets.

Lesson 2 – Using Formula and Formatting Cells

After this lesson, learners should be able to:

  • employ good practices in using arithmetic formulas and functions in spreadsheets;
  • create formulas using cell references and arithmetic operators;
  • identify errors in formulas;
  • employ spreadsheet functions; and
  • use relative and absolute cell referencing in formulas;
  • use logical functions.

Lesson 3 – Inserting Charts and Finalizing Spreadsheets

After this lesson, learners should be able to:

  • create different types of charts in a spreadsheet;
  • edit charts in a spreadsheet; and
  • demonstrate the preparation of outputs in a spreadsheet.

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

UNESCO_ALS_LS6_DIGICIT_M03-V1.1.C

Can't Find What You'RE Looking For?

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

Leave a Comment