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

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

Implementation of P5,000 Net Take Home Pay for DepEd Personnel FY 2019

Share this post

DepEd issued the guidelines for the Implementation of the Php 5,000.00 Net Take Home Pay for all personnel for FY 2019. This issuance is relative to RA 11260 entitled An Act Appropriating Funds for the Operation of the Government of the Republic of the Philippines from January 1 to December 31, 2019 and for Other Purposes.

The Administrative Code of 1987 expressly prohibits deductions from the salaries of government employees for services rendered, unless expressly authorized by law[1]. As an exception, General Appropriations Acts (GAAs) for previous years provided for authorized deductions from the salaries and benefits accruing to government employees, with required order of preference for deductions and limitations that deductions should not reduce the employee’s monthly net take home pay (NTHP) to an amount lower than the threshold stated therein.

Correspondingly, the Department issued guidelines for the implementation of these provisions in the respective GAAs enacted in previous years. The GAA of FY 2019 (RA 11260), incorporating the President’s Veto thereon, provides for the foregoing for the current fiscal year. However, there are notable differences from equivalent provisions in the FY 2018 GAA. 

In order to implement and comply with the applicable provisions in the FY 2019 GAA and the President’s Veto Message on the subject, ensure that teachers receive the mandated minimum monthly NTHP of Php 5,000, and instill discipline in contracting financial obligations from authorized entities, these guidelines are being issued.

To facilitate adjustments in the system and ensure smooth transition, the modifications in the payroll deduction schedule will be made effective in the August 2019 payroll. This is due to administrative and logistical preparations needed, such as extensive and proper communication with all stakeholders and implementers, as well as technical modifications to be made in the payroll program.

Download the DepEd Order here.

Share this post

Teaching Reading Resources |FREE Download|

Share this post

The Schools Division of Davao City conducted a Reading Workshop and Skills Training last July 2018. The activity was held at Imelda Elementary School, Tugbok District. The following Teaching Reading Resources are now available for download.

We would like to share with everyone the presentations used during this activity. You can download it for free by visiting our newly created website. This website will be tackling only for Reading Resources. However, you need to register and log-in to access the files.

You can access this website by registering at You can also comment and participate in many of our discussions, threads, and posts there.

Topics include (Teaching Reading Resources):

  1. Background Information on What is Reading?
  2. Domains of Literacy: Beginning Reading
  3. Phonemic Awareness
  4. Developing Word Recognition
  5. Vocabulary Development and many more.


Remember that the Powerpoint Presentations, Word Documents and other files are only viewable once you register. Browsing the website will not show these links to guest users.

Share this post

How many teaching loads are required for Master Teachers in DepED?

Share this post

Teaching loads in DepEd is one of the hottest topics. And Master Teachers are mostly the ones who are questioned about it. Consequently, we will determine how many teaching loads are required for them.

We needed to plow our way out of many DepEd Orders to answer this question. To begin with, we opened DepEd Order #39 s. 1990.

Legal Basis #1

Item #7, Part 4:

All Master Teachers I and II (shall) be given full teaching loads, except those with special projects or researches, in which case a minimum of 4 teaching loads be given.

DepEd Order 39 s. 1990 also known as Deployment and Assignment of Public School Teachers.

In fact, this is a very clear answer to our question. Master Teachers must have full teaching loads. However, there have been issues that Master Teachers are given less than that due to:

  1. Observation of (other) classes.
  2. School-Based Management tasks.
  3. School Head delegation of administrative functions.
  4. Coaching and Mentoring and alike.

As such, in order to determine if these reasons above are valid, let us check another DepEd Order for more information. So, we checked on DECS Order no. 82 s. 1997.

Legal Basis #2

Item 1, Part A:

Shifting from the Master Teacher’s track to the Principal’s Track… at any point in progression levels provided qualification standards are met and after passing the examination.

Item 1, Part B:

The Master Teacher…who desires to shift is ranked with all other qualified candidates for the equivalent position.

Item 1, Part F:

An assessment, certification and training program shall be conducted by the National Educators Academy of the Philippines

DECS Order No. 82 s. 1997: Revised Guidelines on Shifting from Master Teacher Position to Administrative Position and Vice-Versa.

In other words, it’s definitely clear, a Master Teacher can’t just take away his/her teaching loads. There must be clear-cut steps to take. Further, the Department Orders specifically says they should be given full teaching loads.


  1. DECS Order No. 82 s. 1997: Revised Guidelines on Shifting from Master Teacher Position to Administrative Position and Vice-Versa.
  2. DECS Order No. 50 s. 1994: Guidelines for Teaching Assignments in the Intermediate Grades.
Share this post

Search for Outstanding Barkada Kontra Droga Program Implementers (SY) 2018-2019

Share this post

The Search for Outstanding Barkada Kontra Droga Implementers in Secondary Schools for School Year 2018-2019 is on. This activity is under the Office of the President, through the Dangerous Drugs Board (DDB) which aims to:

  1. Strengthen the National Drug Education Program through BKS Movement established in the schools;
  2. Develop skills and understanding among all school personnel and students in initiating active responses for a drug-free school;
  3. increase community awareness and participation
  4. support and sustain the services in the Barkada-adopted concepts, and
  5. identify best practices of the different BKD Chapters.

All secondary schools with an organized and functional BKD Chapters are encouraged to join the search.

Implementing Rules

The Search for the Outstanding BKD Chapter is open to all secondary schools with organized and functional BKD Chapter nationwide.

Period of Coverage

The Search will cover BKD activities conducted from SY 2018-2019. There will be three (3) levels of searches to be conducted as follows:

  • Division Level – The search will be conducted in June 2019 by the Division Evaluating Team. The winner at the respective Division Level shall be submitted to the Regional Evaluating Team. (Deadline July 31, 2019)
  • Regional Level – The search for the regional level will be done in August 2019 in which the best entry in each region shall be submitted to the National Evaluation Team. (Deadline September 13, 2019)
  • National Level – Two levels of evaluation shall be conducted:
  1. Paper Evaluation – September 16-19, 2019
  2. Field Evaluation – September to December 2019


1. Functionality of the BKD Program on Drug Abuse Prevention in Secondary Schools10%
a. Activities / Timetable10%
2. Coverage and Scope of Implementation15%
a. School-wide implementation10%
b. Community involvement and partnership5%
3. Nature of Extent of Drug Abuse Prevention Activities / Projects Initiated / Implemented / Organized (indicate number and support with documents)30%
(Use of Mass-Media-Print, TV/broadcast, films, slide presentation, exhibits, etc.)
(Integration of drug abuse prevention concepts and BKD components in classroom instruction, organizing seminar-workshops on drug abuse prevention, launching of BKS, seminars, capacity building, etc.)
(Provision of guidance and counseling services, peer counseling, referral services, assistance to student surrenderers if any, etc.)
(Sports / Athletics, Cultural, Income-Generating, Arts and Crafts, Religious Civic, and other Recreational Activities.
4. Extent of Involvement of the Following in Terms of Providing Leadership and Support in Program Implementation20%
a. Students5%
b. Teachers5%
c. School Administrators2%
d. Parent-Teacher Association (PTA)2%
e. Socio-Civic / Religious Organizations2%
f. Government Officials / Agencies2%
g. Non-Government Officials / Agencies2%
5. Attainment of Objectives20%
6. Monitoring and Evaluation Scheme5%

Awards and Prizes

There will be five (5) National Winners, to wit:

  • 1st Prize – Php 50,000.00 + Plaque
  • 2nd Prize – Php 40,000.00 + Plaque
  • 3rd Prize – Php 30,000.00 + Plaque
  • 2 Consolation Prizes – Php 10,000.00 (each) + Plaque

All Regions will submit one (1) Official Entry. It should be submitted directly to the Bureau of Learner Support Services-SHD DepEd Central office. Deadline for submission will be on September 13, 2019.

For more information and to download the Memoranda, please click here.

Share this post

Softcopy of MOVs are Accepted (R.A. 8792) for Individual Performance Commitment and Review Form (IPCRF)

Share this post

With the end of the School Year Review in season, the Individual Performance Commitment and Review Form (IPCRF) is in-demand. This form needs Means of Verifications (MOVs) upon submission. But all will be a lot easier and more efficient if these are submitted in softcopy(ies) [R.A. 8792].

According to Republic Act 8792 also known as Electronic Commerce Act of 2000:

This Act shall apply to any kind of data message and electronic document used in the context of commercial and non-commercial activities to include domestic and international dealings, transactions, arrangements, agreements contracts and exchanges and storage of information.

Section 4: Sphere of Application, R.A. 8972

This includes all electronic copies (softcopies) of MOVs on the Individual Performance Commitment and Review Form.

We were able to understand this notion when our developer made a Facebook Post on softcopies for MOVs. Mr. Dexter Pante made a comment on this thread. For specific portions, the post is seen as below:

The post was pertaining to a Memo from Region 4A which supplemented the use of e-copies on MOVs. Many regions and School Division Offices aren’t practicing this and are strictly imposing hard copies only. To which Mr. Dexter Pante whom he met last October at a workshop with the Central Office mentioned:

Mr. D. Pante again reiterated that there’s no need for a DepEd Memo or DepEd Order to supplement this since a Republic Act is stronger. Logically, this reason is valid and acceptable. And as such, we strongly advise all other offices and DepEd Personnel to accept and practice softcopies for MOVs. This is for efficiency and savings on your Schools’ MOOE on the use of paper.

Share this post

Brigada Eskwela Implementing Guidelines for SY 2019-2020

Share this post

The Department of Education released DepEd Memorandum 036 s.2019 which is the 2019 Brigada Eskwela Implementing Guidelines for SY 2019-2020. The theme for this School Year’s Event will be Matatag na Bayan para sa Maunlad na Paaralan.

The activity will be from May 20 to May 25, 2019. But the host region will hold the National Kick-off Program on May 26, 2019. The host region is yet to be announced as of writing.

All regional directors and schools division superintendents shall mobilize their partnerships with school-based focal persons. This is to ensure the effective implementation of Brigada Eskwela in all public schools with the involvement of their communities.

School heads shall take the lead in planning and activities. Other groups from both public and private entities may coordinate with any of the following:

  • External Partnerships Service (EPS) of the DepEd Central office,
  • Education Support Services Division (ESSD) in the ROs,
  • School Mobilization (SocMob) and Networking Section under the School Governance and Operations Divisions in the SDOs, and/or
  • School Heads of the beneficiary schools.

All DepEd Employees are encouraged to join the Brigada Eskwela activities. As such, interested employees are given two days to do volunteer work on official time, provided that such work is approved by their heads of offices.

Further, nonteaching personnel shall earn a Compensatory Time Off (CTO) for the complete eight hours participation in the maintenance efforts on the last day of Brigada Eskwela week, which is a Saturday.

Participating teaching personnel on this activity will be given Vacation Service Credits. One-day service credit for the accumulated eight hours of participation in the maintenance effort.

Schedule of Activities:


For more information and to download the Memorandum, click here.

Share this post

How Difficult is the Form-137 / SF10 Transfer of Documents?

Share this post

The Form-137 / SF10 has been the most viral topic of teachers today since many consider it as very difficult for transfer. Even with the release of DepEd Order 54 s. 2016, transfer of permanent records has been a huge issue in the field.

As per the directive of the policy, the permanent records of learners must be delivered and transacted between schools. That is, if a certain student should transfer from one school to another, it is the responsibility of the former school to send the learners’ credentials to the new school.

However, as per observation, the biggest issue has come to light already. Many schools do not send the learners’ credentials to the new school. The following reasons we will mention has been the most common.

  1. Lost In Delivery. Originating schools claim that previously, they were sending the forms via courier. Yet, the receiving schools were unable to receive the said forms.
  2. Cost of Delivery. Even with the provision of the policy, schools still claim that it mostly turns out to be from the pockets of the advisers.
  3. Incorrect Forms Delivered. The forms delivered may be correct in terms of the learner’s profile, however, the contents did not follow the directive of the policy. Examples would be placing “No Entry” on the succeeding boxes or sending the photocopy instead of the original.
  4. Need for Request Form. There are still schools that neglect the system notification of the Learners Information System. As such, they will still wait for the receiving school to send them the permanent record request form.
  5. Unpaid Balances. This is quite common with a private school to public school transfer. But the most unfortunate is when a public school will not send the permanent record because the learner still has unpaid balances either in the PTA, BSP/GSP, and (worst) books unreturned.

In fact, these reasons mentioned are just a few. And many teachers will provide different reasons depending on their experiences.

How about you? What are the reasons you’ve encountered why the Form-137 / SF10 turns out to be difficult to transfer? What experiences did you have during the transfer of documents? Tell us about the Form-137 / SF10 Transfer: How difficult is it? Share your experiences and/or encounters below on our comment section.

Share this post