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:
- Use the spreadsheet application to generate different documents.
- Create a new spreadsheet based on the different available templates.
- Save a spreadsheet under another name, as another file type, and to a location in a drive.
- Distinguish the different uses of zoom tools.
- Determine the use of the different toolbars.
- Show understanding of using cells in a spreadsheet.
- Apply the process of modifying rows and columns.
- 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:
- Follow good practices when using arithmetic formulas and functions in spreadsheets.
- Create formulas using cell references and arithmetic operators.
- Identify errors in a formula.
- Use relative and absolute cell referencing in formulas.
- Use spreadsheet functions.
- 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:
- Create different types of charts in a spreadsheet.
- Edit charts in a spreadsheet.
- 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
| Detail | Information |
|---|---|
| Program | ALS Accreditation and Equivalency Program: Junior High School |
| Learning strand | Learning Strand 6: Digital Citizenship |
| Module | Module 3: Digital Applications – Spreadsheets |
| Publishers | UNESCO Office, Jakarta, and the Department of Education |
| Year | 2020 |
| Author | Heiden Chan |
| License | Open 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
| Name | Role |
|---|---|
| Jenelyn Marasigan Baylon | Master Teacher I, ALS Task Force (On-detail) |
| Kristine Lee S. Lumanog | Education Program Specialist II, ALS Task Force (On-detail) |
| Judy R. Mendoza | Project Development Officer III, Bureau of Learning Resources |
| Reyangie V. Sandoval | Education Program Specialist II, Bureau of Learning Resources |
| Josephine C. Intino | Senior Education Program Specialist, Bureau of Curriculum Development |
| Eric U. Labre | Senior Education Program Specialist, Bureau of Learning Resources |
| Roderick P. Corpuz | Supervising Education Program Specialist, ALS Task Force |
| Daisy Asuncion O. Santos | Chief Education Program Specialist, Bureau of Learning Resources |
| Marilette R. Almayda | Director III/Head, ALS Task Force |
| Ariz Delson Acay D. Cawilan | Officer-In-Charge, Office of the Director IV, Bureau of Learning Resources |
| G. H. S. Ambat | Assistant Secretary for Alternative Learning System Program and Task Force |
| Tonisito M. C. Umali | Undersecretary for Legislative Liaison Office, External Partnership Service and Project Management Service |
| Leonor Magtolis Briones | Secretary |
| Name | Role |
|---|---|
| Heiden Chan | Author |
| Adelina Calub | Content Expert |
| Bernadette Sison | Admin and Finance Staff |
| Mildred Parbo | Project Lead |
| Ma. Teresita Medado | President |
Content and Language Evaluators and Instructional Design Reviewer
| Name | Role |
|---|---|
| Edward C. Jimenez | Schools Division Office of Meycauayan City, Department of Education |
| Melvin Lazaro | Regional Office III – Central Luzon, Department of Education |
| Ma. Jessamine Anne R. Verzosa | Freelance Language Editor |
| Name | Role |
|---|---|
| Ade Sandra | Admin and Finance Assistant |
| Rusyda Djamhur | Project Assistant |
| Marmon Abutas Pagunsan | National Project Consultant |
| Remegio Alquitran | National Project Officer |
| Maria Karisma Bea Agarao | National Programme Coordinator |
| Mee Young Choi | Head of Education Unit |
| Shahbaz Khan | Director 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