Consolidate Report Files into One without Copy-Pasting

Share this post

In order to consolidate report files into one without copy-pasting is very easy. In fact, I’ve been using this trick ever since I was tasked to summarize the reports of 600+ schools in our city.

Imagine handling more than 600 files and coming up with a single report to explain the data. This task would normally take weeks or even months to accomplish.

But if all the files are available and are ready for consolidating, this would only take me a day to finish. This includes finalizing a chart dashboard report that is both flashy and corporate looking.

I’ve uploaded a YouTube video tutorial to explain this trick in the simplest manner. You can find the video below and see how fast I can consolidate 40 files into one.

The VBA Codes I use for this trick is available below. Since our website restricts copy-pasting due Intellectual Property Rights (IPR), a download link is provided for all of you by clicking here.

Sub GetSheets()
 'Code Print
 'ref Integrated School Forms 2019
 Path = ""
 FileName = Dir(Path & "*.xlsx")
 Do While FileName <> ""
 Workbooks.Open FileName:=Path & FileName, ReadOnly:=True
 For Each Sheet In ActiveWorkbook.Sheets
 Sheet.Copy After:=ThisWorkbook.Sheets(1)
 Next Sheet
 FileName = Dir()
 End Sub

If you have any other questions or comments regarding this Consolidate Report Files trick, then please write your comments below.

Share this post

Buwan ng Wika Theme 2019

Share this post

Buwan ng Wika (Language Month) is celebrated in the Philippines every month of August. This year’s Theme is Wikang Katutubo: Tungo sa Isang Bansang Filipino.

With DepEd Memorandum 094 s. 2019, the department reiterates the following key objectives for Buwan ng Wika celebration:

  1. ganap na maipatupad ang Pampanguluhang Proklamasyon Blg. 1041 s. 1997;
  2. mahikayat ang iba’t ibang ahensiyang pampahalaan at pampribado na makiisa sa mga programang tulad nito na nagpapataas ng kamalayang pangwika at sibiko; at
  3. maganyak ang mga mamayang FIlipino na pahalagahan ang wikang pambansa sa pamamagitan ng aktibong pakikilahok sa mga gawain kaugnay ng Buwan ng Wikang Pambansa.

Banner for tarpaulin printing can be used as below:

To download the DepEd Memorandum, click here.

Share this post

2019 Nutrition Month Celebration: DM 082 s. 2019

Share this post

DepEd released DM 082 s. 2019 also known as the 2019 Nutrition Month Celebration. Dated 08 July 2019, this year’s theme is Kumain ng wasto at maging aktibo… push natin ‘to!

Furthermore, the 2019 Nutrition Month Celebration aims to promote:

  1. consumption of healthy food and drinks,
  2. eating and choosing healthy choices regularly,
  3. making healthy eating habit and lifestyle, and
  4. being active and exercising daily.

Consequently, to support this developmental endeavour of the National Nutritional Council, DepEd enjoins all schools to participate in this celebration. However, schools must observe the Engaged Time-on-Task Policy of the department be observed.

On the other hand, if you wish to download the Memorandum and the tarpaulin design:

Download Memo Here
Download Image Here

Share this post

FREE Automated Phil-IRI Form 1A and 1B

Share this post

This free Automated Phil-IRI Form 1A and 1B is our response to the tedious tasks underscored with this program. DepEd Order 14 s.2018 may have revised the Phil-IRI process but it did not take into consideration its tediousness.

What is the Phil-IRI Form 1A and 1B

The Free Automated Phil-IRI Form 1A and 1B are the forms needed to accomplish after conducting the Group Screening Test. Furthermore, the Phil-IRI GST is important in order to determine a whole class’ reading level, and identify particular students who may need more assistance in performing reading tasks.

In other words, it can tell teachers whether students are reading at, above, or below their grade levels.

In addition to that, the Phil-IRI Group Screening Test (GST) is a silently-administered test in both Filipino and English. Each tool is composed of a 20-item comprehension test based on a set of leveled passages for each grade level. The GST covers Grades 3 to 6 in Filipino and Grades 4 to 6 in English. The passages were written and selected based on concept load, level of vocabulary used, sentence complexity, nature of themes and cohesion.

1) Phil-IRI Form 1A: Talaan ng Pangkatang Pagtatasa ng Klase (PPK) sa Phil-IRI

The Phil-IRI Form 1A is for the GST in Filipino. The objectives of completing and submitting this form include the following to:

  1. identify the types of questions(literal, inferential or critical) that each child can answer;
  2. classify the students that are recommended for administration of the Phil-IRI tests,
  3. capture the reading performance of the class, thus design appropriate classroom instruction. This form includes the class list, the itemized scores of the students according to the types of questions answered, and their total score.

2) Phil-IRI Form 1B: Summary of the Phil-IRI Group Screening Test Class ReadingRecord (CRR)

This form has the same content and objectives as the Phil-IRI Form 1A. Phil-IRI Form 1B is for the GST in English.

Video tutorial on how to use Automated Phil-IRI 1A and 1B

Download Automated Phil-IRI Form 1A and 1B Here

Share this post

Automated Diploma Generator: Template for SY 2018-2019

Share this post

The release of DepEd Order 02, s.2019 prompted the End of the School Year Rites for SY 2018-2019. Along with this DepEd Order are templates for the Diploma and Certificates for completer(s) in the K to 12 Curriculum. As such, we provide you with our very own Automated Diploma Generator for SY 2018-2020.

Instructions on how to use this Automated Diploma Generator is available on our YouTube Video below. Also, we would like to request everyone to keep on supporting our YouTube Channel by subscribing to it. Further, the notification bell icon will keep you updated with our uploads.

How to Use the Automated Diploma Generator?

The Automated Diploma Generator relies from your SF-5 file from the LIS. Thus, you must update your LIS Classes first before using this free template.

Remember to install the Fonts that are found in the downloaded file. These fonts will used in the Diploma/Certificate template in general.

Download Links are the following:

Kindergarten Automated Diploma Generator

Elementary Sample Certificate 2019

However, we would like to inform everyone that we have yet to receive any news for the SF5-SHS LIS. This means that there’s a high chance the SHS will be encoding their SF5 manually.

Rest assured that as soon as we receive confirmation, we’ll update this article immediately.

What type of paper dimensions and quality is desired for diplomas and certificates?

Diplomas are usually printed on parchment paper with sizes and dimension that differ depending on the school. On the other hand, certificates for kindergarten, grade 6 and grade 10 are usually printed on special paper. Either way, both paper qualities are okay.

Please check the information below for desktop applications that would benefit your tasks in school. The following information provided should greatly help you along the way.

Please visit this link if you wish to download the background music used in this tutorial.

And if you don’t have a MS Office 2019 installed in your laptop, you can check on this link to download for free.

Share this post

Sample Detailed Action Plan Template

Share this post

Teachers, School Heads, and even Supervisors every now and then are required to make an Action Plan. But not single one template is standardized – as far as the elements go.

In short, every office, every school, every district has their own way of how to make an action plan. But the best action plan model should have all the elements in it.

What are these elements?

Among the most reoccurring elements we saw in many action plans all over the internet either have one or two of these in our list. In fact, some action plans have more than these! Which we really found odd and redundant.

Thus, we synthesized all of it and created a single template that can address the need of the author, along with the objectives.

·      Areas of Concern

Every action plan must have a concrete identification as to what are the possible problems or issues each procedure will have. By being able to identify these concerns, the ability to prevent them are higher. If the issue could not be prevented, a definite measure can be used to resolve it.

·      Activity

A specific detail as to what will be done. However, it could be presented in a general title which will later be broken down and defined through the next element.

·      Objectives

It answers the question “What will the activity achieve?”. Objectives must be S.M.A.R.T. at the very least. Specifically aligned with every cognitive, psychomotor and affective domain.

·      Inclusive Dates and Venue

The specific time and place as to where the activity should take place. The inclusive dates must also

·      Person/Organizations Responsible

This item includes all individuals or group of individuals who are involved with the activity. The list could be identified in general terms but they must be specified from which group or category they belong to.

·      Resources Needed

This may refer to material and immaterial objects. It also includes individuals or person who may be referred to as resource persons involved in the activity. All other materials that may or may not be used in the conduct of the activity can be listed here as well.

·      Community Partnership

Refers to the different community and/or stakeholders who will be working with the activity. Which also includes the end-users or the beneficiaries of the activity. The item also refers to the specific involvement of a particular group on a specific activity – which depends on the objective. 

·      Success Indicators

A quantitative data which will be the basis of objective achievement. This item must reflect that the objectives which were set are attained. It should also be presented in a measurable manner, i.e. number or percentage.

We would like to share to all of you, a Sample Action Plan Template which we have filled-in already as a guide for you on how to make your own Action Plan in the future. Each item has been sampled from start to finish. 

This Sample Action Plan is considered as pre-stage activity. This means that the activity must not deviate with the action plan. The activity may have unforeseen changes due to uncontrollable circumstances e.g. the dates and venues changed. But, the general objectives of the Action Plan must remain the same. Unless, a new action plan is to be drafted.

How To Download?

As we always do here in our website, the files are available for downloading via two (2) links. The first link is only for DepEd Email Users. If you wish to download via the first link, you must log-in to your DepEd Email account. The second link is a universal server, an alternate link. This is for those who couldn’t access the DepEd G-Drive. Both links are working fine. 

Download Link using DepEd Email Account

Alternate Link for No DepEd Email Account

Check out our other Free Downloads:

Visit our Download Page by clicking here

Share this post

Early Registration Forms Complete Download List

Share this post

As the Early Registration for SY 2019-2020 comes near, teachers will be conducting different programs for our community. As such, with the release of DepEd Order 3 s. 2018, also known as Basic Education Enrollment Policy, early registration forms are of use.

The list of these forms is provided below along with their download links for easy access. 


ALL DepEd Employees are required to log-in on the DepEd Email Accounts if they wish to download the file from the DepEd Server we have provided below. If you do not have a DepEd Email Account or you could not access your DepEd Email accounts, then please use the alternate links (universal link). We will not be confirming the request to access of these files if you are not using your DepEd email (e.g.[email protected]).

The list of these early registration files (also known as Annexes of DO 3 s. 2018) are as follows:

  1. Early Registration Mapping Tool
  2. Basic Education Enrollment Form
  3. Affidavit of Undertaking
  4. Temporary Progress Report for Kindergarten
  5. Temporary Progress Report for Elementary and Junior High School
  6. Temporary Progress Report for Senior High School
Share this post

Reveal WiFi Passwords for Windows

Share this post

We’ve been receiving a lot of requests on how to hack WiFi passwords. And it may sound unethical, in a country like ours, internet comes as a luxury. And for the promos our ISPs advertise, it will only get you frustrated. So, we understand why people ask us on methods on WiFi hacking.

However, we don’t patronize such activity. Since WiFi passwords targeted for hacking are mostly that from the next door neighbour. Well, we would have a different mind-set if it was from a big abusive company, but not until such request should come.

Nonetheless, for many employees and corporate men (and women), remembering WiFi passwords is such a drag. We know people actually making lists of PASSWORDS which they use to access different routers and modems. That would be very exhausting to do actually. So what if, there was an application that would immediately show us the passwords of the different routers and modems we once connected?

Then here you go, a company called The Magic Jelly Bean created an application that does it! You install the program like any other, and it will immediately run to your cached connections to show you all of the WiFi connections in your history. Now, you only to browse through the list it generate, and gets it all for you!

To download, you can click the following links below:



Share this post

Automated ECCD Checklist Version 2.3: FREE DOWNLOAD

Share this post

The Automated ECCD Checklist Version 2.3 is the latest on the automation of the early childhood care and development checklist. Furthermore, this update already integrates the Summary Reports for the Baseline (Pretest) and Summative (Posttest) Assessments.

Note: that the Automated ECCD Checklist Version 2.3 works best with Microsoft Excel 2013 and above. If you only have an MS Office 2010 and below, we suggest you to upgrade your system. Consequently, a set of instructions are available in this article to install MS Office 2019.

The video tutorial below shows how to use the Automated ECCD Checklist Version 2.1 to Version 2.3:

Download Links:

Please choose the link that fits your status. For instance, if you do not have a DepEd Email account, then use the Universal Link. On the other hand, teachers who are waiting for confirmation of their DepEd email can use the universal link as well.



Do you wish to implement this template on your division/region level?

Kindly send your requests via email to this address:

iSF Developer,
[email protected]

Kindly format your letter appropriately. At the same time, you can indicate in your letter a request to demo the file to your locale. For example, if you are near our current station, we can accommodate your requests during weekends.

On the other hand, locales outside Mindanao should consider transportation means. Especially when the conduct of workshop is scheduled during weekdays. Strict adherence to existing policies shall be implemented.

Updates and latest information regarding the file will be posted below:

As of 26 February 2019:

Teachers recommended to use School Head instead of Principal for universality.

As of 24 February 2019:
We already reduced the file size and integrated the corrections necessary for the summative results. Thank you for immediately informing us!

Share this post

FREE Automated ECCD Checklist

Share this post

Update as of 17 August 2018:

Revision on the interpretation table suited for learners below 5 years of age as per DO 47 s. 2016 and DO 20 s.2018; cut-off age of enrollment set at August 31 of every school year.

Update as of 25 July 2018:

Corrected the “District” label in the ECCD that isn’t fetching from the class profile directory as well as the missing count in the Self-Help Domain.

Update as of 15 July 2018:

Added new downloadable Automated ECCD Checklist 2.0 which has a Class Summary Report of all ECCD Checklists. This ECCD Checklist Form 2 has a Baseline and Summative Report already which are all ready to print via Long Bond Paper (Folio 8.5×13″)

For the longest time, kindergarten teachers did not have any automated forms. Since the release of the automated e-class record last 2015, no automated file was ever released for our kindergarten curriculum. It may have taken us a while to produce one, but rest assured, this one is more than you could ask!

Watch the video below to learn more how to use this checklist.

The file can be downloaded below:


There has been a request to update the file above since Kindergarten Teachers are required to create a Summary Report on the Class ECCD Checklist known as ECCD Form 2. So we opted to incorporate the summary with the ECCD Checklist as the Automated ECCD Checklist Version 2.0 which you can download below:


This file is to be distributed for free through our website and must not be published on any other sources without the consent of the Integrated School Forms team.

Share this post