ALS Learning Strand 6 Digital Citizenship Session Guides for Module 3: Digital Applications – Spreadsheets

ALS JHS Learning Strand 6 session guides for Module 3 on spreadsheets: three lessons on spreadsheet basics, formulas and functions, and charts.

These are the session guides for Module 3, Digital Applications – Spreadsheets, under Learning Strand 6 (Digital Citizenship) of the Alternative Learning System Accreditation and Equivalency (ALS A&E) Program for Junior High School. They are written for ALS teachers, Instructional Managers, and Learning Facilitators who guide learners through the module. Across three sessions, learners move from opening their first spreadsheet to using formulas, functions, and charts.

The guides were published in 2020 by UNESCO and the Department of Education as part of the project “Better Life for Out-of-School Girls to Fight Against Poverty and Injustice in the Philippines,” with funding from the Korea International Cooperation Agency (KOICA).

On this page 6 sections

Why learn spreadsheets

We deal with numbers every day. For example, we budget our money for food, fare, clothing, and other expenses. Small sums are easy to work out by hand. Larger numbers and bigger totals are harder, like the ones handled in banks, department stores, supermarkets, grade records, and payrolls. Spreadsheet programs help us compute and organize data like this. The module walks learners through using a spreadsheet so they become comfortable with it.

Lessons in this module

The module has three lessons, each with its own session guide.

Session Guide 1: Understanding Spreadsheets

Learners get to know the spreadsheet application and its basic tools. By the end of the session, learners should be able to:

  1. Use the spreadsheet application to generate different documents.
  2. Create a new spreadsheet based on the different available templates.
  3. 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. Show understanding of using cells in a spreadsheet.
  7. Apply the process of modifying rows and columns.
  8. Customize worksheets.

Session Guide 2: Using Formulas and Formatting Cells

Learners use the spreadsheet to compute. By the end of the session, learners should be able to:

  1. Follow good practices when 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. Use spreadsheet functions.
  6. Use logical functions.

Session Guide 3: Inserting Charts and Finalizing Spreadsheets

Learners present data visually and prepare finished work. By the end of the session, learners should be able to:

  1. Create different types of charts in a spreadsheet.
  2. Edit charts in a spreadsheet.
  3. Show how to prepare outputs in a spreadsheet.

How to use these session guides

The module is designed so that ALS learners can work through guided and independent activities at their own pace and time. It also aims to build 21st century skills while taking learners’ needs and circumstances into account.

  • For ALS teachers and facilitators: Orient learners on how to use the module before they begin. Track each learner’s progress while letting them manage their own learning. Encourage and assist learners as they do the tasks in the module.
  • For learners: Work through the three lessons in order. Each one builds on the skills from the session before it.
  • For parents and guardians: Give your learner time to practice, especially if a computer is available at home or in the community.

About this resource

DetailInformation
ProgramALS Accreditation and Equivalency Program: Junior High School
Learning strandLearning Strand 6: Digital Citizenship
ModuleModule 3: Digital Applications – Spreadsheets
PublishersUNESCO Office, Jakarta, and the Department of Education
Year2020
AuthorHeiden Chan
LicenseOpen access (CC BY-SA 3.0 IGO); government property, not for sale

For inquiries, the guides list the DepEd Bureau of Learning Resources (BLR) at blr.qad@deped.gov.ph and blr.lrpd@deped.gov.ph.

Frequently asked questions

Who are these session guides for?

They are for ALS teachers, Instructional Managers, and Learning Facilitators in the ALS Accreditation and Equivalency Program for Junior High School. Facilitators use them to guide learners through Module 3 of Learning Strand 6, Digital Citizenship.

What lessons are in Module 3: Digital Applications – Spreadsheets?

There are three lessons. They are Understanding Spreadsheets, Using Formulas and Formatting Cells, and Inserting Charts and Finalizing Spreadsheets.

What is the teacher’s role when using this module?

The teacher orients learners on how to use the module and keeps track of their progress. The teacher also lets learners manage their own learning and encourages and assists them as they do the tasks.

Who published these session guides?

They were published in 2020 by UNESCO Office, Jakarta, and the Department of Education. The project was funded by the Korea International Cooperation Agency (KOICA).

Full text of the document

The text below is a transcription of the PDF above, as printed.

Learning Strand 6 Digital Citizenship – Session Guides for Module 3: Digital Applications – Spreadsheets

[illustration: cover art of a computer monitor showing a Wi-Fi symbol, surrounded by a folder, cloud, shield with checkmark, magnifying glass, document, email envelope, phone, and lightbulbs, with a globe in the background]

SECONDARY JHS LEARNING STRAND 6 DIGITAL CITIZENSHIP

SESSION GUIDES FOR MODULE 3: DIGITAL APPLICATIONS – SPREADSHEETS

ALS Accreditation and Equivalency Program: Junior High School

GOVERNMENT PROPERTY NOT FOR SALE

LEARNING STRAND 6 SESSION GUIDES

Alternative Learning System – Accreditation and Equivalency (ALS-A&E)

JUNIOR HIGH SCHOOL: DIGITAL CITIZENSHIP SESSION GUIDES FOR MODULE 3 (DIGITAL APPLICATIONS – SPREADSHEETS)

ALS Accreditation and Equivalency Program: Junior High School Learning Strand 6: Digital Citizenship Session Guides for Module 3 (Digital Applications – Spreadsheets)

Published in 2020 by the United Nations Educational, Scientific and Cultural Organization UNESCO Office, Jakarta Jalan Galuh II No. 5, Kebayoran Baru, Jakarta, Indonesia

and

Department of Education DepEd Complex, Meralco Avenue, Pasig City, Philippines

Copyright © UNESCO and DepEd 2020

This publication is available in Open Access under the Attribution-Share Alike 3.0 IGO (CC-BY-SA 3.0 IGO) license (http://creativecommons.org/licenses/by-sa/3.0/igo/). By using the content of this publication, the users accept to be bound by the terms of use of the UNESCO Open Access Repository (http://www.unesco.org/open-access/terms-use-ccbysa-en).

The designations employed and the presentation of material throughout this publication do not imply the expression of any opinion whatsoever on the part of UNESCO concerning the legal status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries.

The selection and presentation of the material contained in this publication, as well as the opinions expressed herein are the sole responsibility of the authors and not necessarily those of UNESCO, nor do they commit the organization in any way.

This educational resource material was developed and printed through the project “Better Life for Out-of-School Girls to Fight Against Poverty and Injustice in the Philippines” with financial support from Korea International Cooperation Agency (KOICA).

Printed by APC Printers Corporation Printed in Makati City, Philippines

ISBN 888-888-8888-88-8

Development Team

NameRole
Jenelyn Marasigan BaylonMaster Teacher I, ALS Task Force (On-detail)
Kristine Lee S. LumanogEducation Program Specialist II, ALS Task Force (On-detail)
Judy R. MendozaProject Development Officer III, Bureau of Learning Resources
Reyangie V. SandovalEducation Program Specialist II, Bureau of Learning Resources
Josephine C. IntinoSenior Education Program Specialist, Bureau of Curriculum Development
Eric U. LabreSenior Education Program Specialist, Bureau of Learning Resources
Roderick P. CorpuzSupervising Education Program Specialist, ALS Task Force
Daisy Asuncion O. SantosChief Education Program Specialist, Bureau of Learning Resources
Marilette R. AlmaydaDirector III/Head, ALS Task Force
Ariz Delson Acay D. CawilanOfficer-In-Charge, Office of the Director IV, Bureau of Learning Resources
G. H. S. AmbatAssistant Secretary for Alternative Learning System Program and Task Force
Tonisito M. C. UmaliUndersecretary for Legislative Liaison Office, External Partnership Service and Project Management Service
Leonor Magtolis BrionesSecretary
NameRole
Heiden ChanAuthor
Adelina CalubContent Expert
Bernadette SisonAdmin and Finance Staff
Mildred ParboProject Lead
Ma. Teresita MedadoPresident

Content and Language Evaluators and Instructional Design Reviewer

NameRole
Edward C. JimenezSchools Division Office of Meycauayan City, Department of Education
Melvin LazaroRegional Office III – Central Luzon, Department of Education
Ma. Jessamine Anne R. VerzosaFreelance Language Editor
NameRole
Ade SandraAdmin and Finance Assistant
Rusyda DjamhurProject Assistant
Marmon Abutas PagunsanNational Project Consultant
Remegio AlquitranNational Project Officer
Maria Karisma Bea AgaraoNational Programme Coordinator
Mee Young ChoiHead of Education Unit
Shahbaz KhanDirector and Representative

User’s Guide

For the ALS Teacher/Instructional Managers/Learning Facilitator:

Welcome to the session guide of this module entitled Digital Applications – Spreadsheets under Learning Strand 6 Digital Citizenship of the ALS K to 12 Basic Education Curriculum (BEC).

The module and the session guides were 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 manage their learning. Moreover, you are expected to encourage and assist the learners as they do the tasks included in the module.

I can’t transcribe pages 9 to 16 because they aren’t in this request. The only pages attached are labeled 1 to 8, and page 8 is blank. Page 8 contains only the blank marker, with no text.

If you send the page images for pages 9 to 16, I’ll transcribe them in the same style and number the markers 9 to 16.

The development and printing of this teaching resource was made possible with the cooperation of Asia Pacific College. This is a component of the project “Better Life for Out-of-School Girls to Fight Against Poverty and Injustice in the Philippines” implemented by UNESCO Office, Jakarta in partnership with the Department of Education. This initiative received a generous financial support from Korea International Cooperation Agency (KOICA).

For inquiries, please contact:

Department of Education, Bureau of Learning Resources (DepEd BLR)

Office Address : Ground Floor, Bonifacio Building, DepEd Complex, Meralco Avenue, Pasig City, Philippines 1600 Telefax : +63-2-8631-1072; +63-2-8634-1054; +63-2-8631-4985 Email Address : blr.qad@deped.gov.ph; blr.lrpd@deped.gov.ph

Leave a Reply

Your email address will not be published. Required fields are marked *

For students and teachers

Looking for a school?

Look up the enrollment, teachers, classrooms and facilities of more than 60,000 schools across the Philippines, from DepEd’s public data. Free to use.

Philippine Schools Directory by TeacherPH · every region, province, division and district