DepEd Class Attendance Sheet Template Excel: Free Guide

How-to basics · Updated November 22, 2026

Yes, the Department of Education (DepEd) in the Philippines does not prescribe a single mandatory Excel template for class attendance, but the most widely used and accepted format is the DepEd Form 1 (School Form 1 / SF1), which is officially issued as an Excel workbook. This article explains the standard SF1 structure, how to download or recreate it, how to fill it out correctly, and common pitfalls to avoid.

Background: Why DepEd Attendance Uses a Standard Form

DepEd centralizes student records through the Learner Information System (LIS) and the Basic Education Information System (BEIS). To keep data uniform across all public schools, DepEd issues official school forms in Excel format. The class attendance sheet is part of School Form 1 (SF1) – School Register, which lists every learner in a class and tracks their daily attendance for the entire school year. While private schools may use their own layouts, public schools are required to use the DepEd-provided SF1 template to ensure that submitted data matches the LIS database.

How the Official DepEd Attendance Sheet Works

The official SF1 Excel template is a single workbook with multiple sheets, one per month (June to March). Each sheet contains a grid where rows represent learners and columns represent the days of the month. The key features are:

  • Learner information columns: LRN (Learner Reference Number), name, sex, birthdate, and other demographic fields.
  • Daily attendance columns: One column per school day, where teachers mark a code: P (Present), A (Absent), L (Late), or E (Excused).
  • Monthly summary columns: Total days present, absent, late, and excused for each learner, plus a signature line for the adviser and school head.

For example, if a learner is present on June 3, you type P in the cell under the June 3 column. At the end of the month, you count the number of P entries for that learner and enter the total in the “Total Present” column. The template includes formulas to auto-sum these counts, but many teachers prefer to manually count to avoid errors.

How to Get the Official DepEd Excel Template

The most reliable source is the DepEd website or your school’s designated LIS coordinator. Here are the common ways:

  1. Visit the official DepEd website (deped.gov.ph) and search for “School Form 1” or “SF1” in the downloads section.
  2. Check the LIS portal (lis.deped.gov.ph) – after logging in, you can download the latest SF1 template from the “Downloads” or “Forms” tab.
  3. Ask your school’s registrar or ICT coordinator for a copy. They usually have the up-to-date version aligned with the current school year.

If you cannot find the official file, you can recreate it in Excel using the standard column headers. However, always cross-check with your school head to ensure you are using the correct version, because DepEd occasionally updates the form layout (e.g., adding columns for new data fields).

How to Fill the Attendance Sheet Correctly

Follow these steps to avoid common mistakes:

  1. Enter learner data first: Copy the learner names and LRNs from the LIS or your class register. Do not type them manually if you can avoid it – this prevents spelling errors.
  2. Mark attendance daily: Use the codes exactly as defined in the template’s legend (usually found at the top of each sheet). Do not use your own abbreviations.
  3. Use the summary formulas: If the template has a “Total Present” column, it likely uses a formula like =COUNTIF(C3:AG3,"P") (assuming the month has 31 columns). Check that the formula range matches the actual days in that month.
  4. Freeze the header rows: To keep the learner names visible while scrolling, select row 3 (if that’s where the first learner is) and go to View > Freeze Panes > Freeze Panes.
  5. Print properly: Use File > Print, then set the orientation to Landscape and fit to one page wide to avoid cutting off columns.

Common Problems and How to Solve Them

Teachers often encounter these issues with the DepEd attendance template:

  • Formulas not calculating: If you type P and the total doesn’t update, check that the cell is formatted as text (not number) and that the formula range is correct. Also, ensure that “Enable iterative calculation” is off – it’s not needed here.
  • Columns misaligned: When you copy data from another sheet, use Paste Special > Values to avoid overwriting formulas.
  • Print cuts off columns: Adjust the print area by selecting the range you need and then Page Layout > Print Area > Set Print Area.
  • Learner count exceeds template rows: The official template usually has 40 or 50 rows. If you have more learners, insert new rows above the summary row, but be careful to copy the formulas down. Right-click the row number and choose Insert, then use the fill handle to copy formulas.

Comparing DepEd Template vs. Custom Excel Sheets

Many teachers create their own attendance sheets for daily use, then transfer totals to SF1 at the end of the month. Here’s a quick comparison:

  • Official SF1: Standardized, required for submission, includes LRN and demographic data. It is long and not ideal for quick daily marking.
  • Custom daily sheet: Can be simplified to just names and dates, with a column for remarks. It saves time but requires a second step to copy totals into SF1.

If you create a custom sheet, use the same codes (P/A/L/E) to avoid confusion. You can even use Excel’s Data Validation to create a dropdown list for each cell: select the range, go to Data > Data Validation, choose “List” and enter P,A,L,E as the source.

Costs and Safety of Using DepEd Templates

The official DepEd templates are free – they are distributed through government channels. Be cautious of third-party websites that charge for “premium” versions; they are not official and may contain errors. When downloading any file, always scan it with antivirus software. Also, never share the file with sensitive learner information (names, LRNs) over unsecured channels. DepEd requires that student data be handled with confidentiality, so store the file in a secure folder and avoid sending it via public email without encryption.

Frequently Asked Questions

Where can I download the DepEd attendance sheet template in Excel?

You can download it from the official DepEd website (deped.gov.ph) under the “Downloads” section, or from the LIS portal after logging in. Alternatively, ask your school’s LIS coordinator for the latest version.

What do the codes P, A, L, and E mean in the DepEd attendance sheet?

P stands for Present, A for Absent, L for Late, and E for Excused (e.g., due to illness or family emergency). These codes are standard across all DepEd school forms.

How do I add more rows for learners in the SF1 template?

Right-click on a row number below the last learner and choose “Insert.” Then copy the formulas from the row above. If the template has a summary row at the bottom, make sure to insert rows above it so the summary formulas include the new rows.

Can I use Google Sheets instead of Excel for the DepEd attendance sheet?

Yes, you can upload the Excel template to Google Sheets and edit it there. However, some formulas may not work identically, and you must download it back as an .xlsx file before submitting. Check that all formulas recalculate correctly in Google Sheets.

What should I do if the attendance sheet has errors in the formulas?

First, check if the formula ranges match the actual columns for the month. If not, edit the formula manually. For example, if your month has 20 school days and the columns are C to V, the formula should be =COUNTIF(C3:V3,"P"). If you are unsure, ask a colleague or your ICT coordinator for help.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.