Complete Guide to DepEd School Forms 1-10 in Excel Format
DepEd School Forms 1-10 Excel Download: A Guide for Teachers
If you are a teacher in the Philippines, you probably know that you need to prepare and submit various school forms throughout the school year. These forms are required by the Department of Education (DepEd) to monitor and evaluate the progress and performance of learners, teachers, and schools. In this article, we will explain what are DepEd school forms, why they are important, how to use them in different learning modalities, and where to download them in excel format.
What are DepEd school forms and why are they important?
Definition and purpose of DepEd school forms
DepEd school forms are official documents that contain relevant data and information about learners, teachers, and schools. They are used for various purposes such as enrollment, attendance, promotion, health, personnel, and report card. They are also used as basis for planning, budgeting, policy-making, research, and evaluation by the DepEd and other stakeholders.
deped school forms 1-10 excel download
List and description of DepEd school forms 1-10
There are many types of DepEd school forms, but the most common ones are numbered from 1 to 10. Here is a table that summarizes the codes, titles, descriptions, preparers, modes of preparation, and schedules of these forms.
Code and title
To be prepared by
Mode of preparation
SF 1 School Register
Master list of class enrollment
LIS (Learner Information System)
Beginning of school year (BoSY) and as needed
SF 2 Learners Daily Class Attendance
Recording of attendance, absence, or tardiness (template with name of learners)
Partially through LIS and manual
SF 3 Books Issued and Returned
List of books (by title) issue to/returned by learners
Partially through LIS and manual
BoSY and End of school year (EoSY)
SF 4 Summary Enrollment and Movement of Learners
Enrollment count, transferred in/out and dropout by grade level (Summary of SF 2)
SF 5 Report on Promotion
List of promoted/retained by class
SF 6 Summary Report on Promotion
Number of promoted/retained by grade level (Summary of SF 5)
SF 7 Inventory of School Personnel
List of school personnel with basic profile and teaching load/assignment
Manual (originally designed in Human Resource Information System)
BoSY and as needed
SF 8 Learner Basic Health Profile Per learner assessment of health status, nutritional status, and immunization recordClass adviserManualBoSY and as needed
SF 9 Learners Progress Report Card
Report card showing learners academic performance, attendance, and behavior
SF 10 Learners Permanent Academic Record
Cumulative record of learners academic performance from Kindergarten to Grade 12
EoSY and as needed
How to use DepEd school forms in different learning modalities?
Guidelines for preparing and submitting DepEd school forms
The DepEd has issued various guidelines and policies on how to prepare and submit school forms in different learning modalities. These include the following:
DepEd Order No. 11, s. 2018 Guidelines on the Preparation and Checking of School Forms (Revised)
DepEd Order No. 31, s. 2020 Interim Guidelines for Assessment and Grading in Light of the Basic Education Learning Continuity Plan (BELCP)
DepEd Order No. 12, s. 2021 Amendment to DepEd Order No. 30, s. 2020 (Adoption of the Basic Education Learning Continuity Plan for School Year 2020-2021 in Light of the COVID-19 Public Health Emergency)
DepEd Memorandum No. 42, s. 2021 Guidelines on the Encoding of Data in the Learner Information System (LIS) for School Year (SY) 2020-2021
DepEd Memorandum No. 43, s. 2021 Guidelines on the Encoding of Data in the Enhanced Basic Education Information System (EBEIS) for School Year (SY) 2020-2021
DepEd Memorandum No. 44, s. 2021 Guidelines on the Encoding of Data in the Human Resource Information System (HRIS) for School Year (SY) 2020-2021
Teachers are advised to read and follow these guidelines carefully to ensure accuracy, completeness, consistency, and timeliness of data and information in the school forms.
Tips and tools for accomplishing DepEd school forms
To make the task of accomplishing DepEd school forms easier and faster, teachers can use some tips and tools such as:
Using a computer or laptop with a reliable internet connection and updated software applications.
Creating a backup copy of the school forms in a flash drive or cloud storage.
Using formulas, functions, filters, charts, and other features in excel to automate calculations, sorting, formatting, and visualization of data.
Using online platforms such as Google Forms, Google Sheets, Google Classroom, Microsoft Forms, Microsoft Excel Online, Microsoft Teams, etc. to collect, organize, share, and collaborate on data with learners, parents, and colleagues.
Using online resources such as DepEd Commons, DepEd Learning Portal, DepEd Tambayan PH, etc. to access downloadable templates, samples, tutorials, and updates on school forms.
Seeking assistance from the school ICT coordinator or division LIS/EBEIS/HRIS focal person in case of technical issues or concerns.
Reviewing and verifying the data and information before submitting or printing the school forms.
Where to download DepEd school forms 1-10 in excel format?
Sources and links for downloading DepEd school forms
The official source for downloading DepEd school forms is the DepEd website (www.deped.gov.ph). Under the Resources tab, there is a section called School Forms where teachers can find downloadable files of various school forms in different formats such as PDF, Word, or Excel.
However, some teachers may prefer to use alternative sources that offer customized or modified versions of DepEd school forms that suit their needs or preferences. Some of these sources are:
: This is a website that provides free teaching materials, news updates, and other resources for teachers. It has a page dedicated to DepEd school forms where teachers can download editable templates in excel format.
: This is an online community of teachers, learners, parents, and other stakeholders who share their insights, experiences, and resources on various topics related to education. It has a section called School Forms where teachers can download and request for school forms in excel format.
: This is a website that offers free and quality teaching and learning materials, news updates, and other services for teachers and learners. It has a category called School Forms where teachers can download ready-to-print school forms in excel format.
Advantages and disadvantages of using excel format
Using excel format for DepEd school forms has some advantages and disadvantages that teachers should consider. Some of the advantages are:
It allows teachers to edit, customize, or modify the school forms according to their needs or preferences.
It enables teachers to use formulas, functions, filters, charts, and other features to automate calculations, sorting, formatting, and visualization of data.
It facilitates teachers to use online platforms to collect, organize, share, and collaborate on data with learners, parents, and colleagues.
It helps teachers to save time, effort, and resources in preparing and submitting school forms.
Some of the disadvantages are:
deped school forms 1-10 pdf download
deped school forms 1-10 editable format download
deped school forms 1-10 free download 2023
deped school forms 1-10 templates download
deped school forms 1-10 compilation download
deped school forms 1-10 latest version download
deped school forms 1-10 online download
deped school forms 1-10 for sy 2022-2023 download
deped school forms 1-10 with formulas download
deped school forms 1-10 automated download
deped school forms 1-10 manual download
deped school forms 1-10 official download
deped school forms 1-10 updated download
deped school forms 1-10 lis download
deped school forms 1-10 guidelines download
deped school forms 1-10 sample download
deped school forms 1-10 ready to print download
deped school forms 1-10 new adjusted download
deped school forms 1-10 for kindergarten download
deped school forms 1-10 for senior high school download
It requires teachers to have a computer or laptop with a reliable internet connection and updated software applications.
It poses a risk of data loss or corruption due to technical issues or human errors.
It may cause confusion or inconsistency in data and information due to different versions or formats of school forms.
It may not comply with the official guidelines and policies of the DepEd on the preparation and submission of school forms.