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

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

Create-Edit Without Using Photoshop

Share this post

The popularity of Adobe Creative Cloud especially Photoshop is worldwide. Many digital editors use Adobe applications in many of their tasks. But what if you don’t have Adobe Photoshop installed? Here, we’re gonna teach you how to Create or Edit without using Adobe Photoshop!

The video shows – from start to finish – how to create and edit without using Photoshop. With the online photo editing tool, you can have all the interface photoshop have without installing it on your computer.

The only downside of course is that you can’t access it without an internet connection. But other than that, it’s all worth it!

You can download the file we used in this tutorial below.

Sample Certificate Design (.psd file)

If you want to install the latest Adobe CC 2019 on your desktop and you wish to install it for free, then please subscribe to our mailing list found on the right side panel of our website, or just scroll down if you’re using your mobile phones.

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

How to Backup Your Computer Easily

Share this post

Almost every work we need to accomplish involve computers. And most of the time, we encounter errors and worse, we end up reformatting our system. This is very tragic especially when you don’t have back-ups at all. And speaking of backups, this is what we’re gonna be showing you right now, the simplest way to backup your computer and hopefully save you the trouble of reformatting your laptop or computer which obviously erases everything, including your precious programs. 

Remember that we’re gonna be doing a System Image Backup which is actually a full copy of our hard drive. So, if it ever comes to a point where our hard drive goes berserk and crappy, we can just replace it and restore everything from this backup. The best part of it is, you don’t need to reformat your windows and all your applications are still there.

To begin with, click on your windows icon here on the lower left and type “Control Panel”, windows will give you a suggested icon so you can just click on it. On the control panel window, click Back up and Restore (Windows 7) which is under the System and Security item.

In this window, on the left side panel is a Create a System Image selection, click on it and wait for a window to open.

After it loads, you will be asked as to where you will be saving your backup, for this tutorial, we’ll save it on our hard disk. If your hard disk is partitioned, you will have more options here, but I didn’t partition my drive that’s why I only have one. After choosing where you’d save it, click Next. Following that will be information regarding your backup task  which is telling you basically that the backup will be saved on Drive D, and everything on your Drive C will be backed up. Now, Click Start Backup. You unit will now start the process of system backup and this will probably take some time depending on your computer.

You will then be prompted choose if you wish to create a system repair disc, in other words, it means we will have a copy of this backup on a CD. We generally recommend you to do this, and by doing so, you only need to click YES and then insert your rewritable CD on your optical drive and click create disc.

That’s it, you’ve successfully backed up our system and in case of emergency, you can just use this System Image Restore for your laptop. And you won’t be needing to go through that tedious reformatting process which basically kills everything you worked for your unit.

Share this post

FREE Downloadable Music with Visual Effects for Awarding Events

Share this post

The Philippines are always into a custom of recognition and ceremonies for awarding. In fact, the Department of Education encourages rewards in the earliest stages of school attendance. Thus, we provide you with FREE Downloadable Music with Visual Effects During Awarding!

On the other hand, teachers are the ones who manage these events. And more often than not, sound system including “dj-spinning”, is one of those ancillary task teachers’ are responsible with. As such, we would like to help our teachers in the field in the littlest means we can in these tasks.

What’s in-store for you?

The difficulty to handle events are high. Teachers turn out to be multi-taskers when it comes these circumstances. In spite of that, most of the teachers are also in-charge of the sound-system. And it would be convenience on their part to be provided freely.

Thus, we included 12 different audio-visual tracks below. However, since not everyone have Adobe Premiere, we rendered these files to MP4. Furthermore, we also opted to render these files into MP3 (audio only) so that it can be played on-the-go. 

Kindly look into the twelve (12) renditions of these tracks. You can choose from two (2) tracks here. And as bonus, these are rendered in multiple colors. This way, may choose which of these tracks suits your school’s colors.


Track 1 was used in the Emmy Awards, and Track 2 was popularized by David Foster

Audio-Visual Effects Illustration for Awarding Music

Emmy Awards Track

  1. Blue Audio-Visual Spectrum
  2. Colorful Audio-Visual Spectrum
  3. Green Audio-Visual Spectrum
  4. Red Audio-Visual Spectrum
  5. White Audio-Visual Spectrum
  6. Yellow Audio-Visual Spectrum

David Foster Track

  1. Blue Audio-Visual Spectrum
  2. Colorful Audio-Visual Spectrum
  3. Green Audio-Visual Spectrum
  4. Red Audio-Visual Spectrum
  5. White Audio-Visual Spectrum
  6. Yellow Audio-Visual Spectrum

Stand alone MP3 Audio tracks of the files above which are remastered.

  1. Emmy Awards MP3: Track 1 – Audio File Only (MP3)
  2. David Foster MP3:Track 2 – Audio File Only (MP3)

Share this post

How to Install MS Office 2019 even on an OLD Laptop for FREE!!!

Share this post

Have you ever come across a time where you really want to upgrade your Microsoft Office but you can’t due to budget constraints? Or you’re using the latest MS Office on your unit but has been disabled since you weren’t able to purchase a product key? Then here’s a good news for you! As shown in the video, we’ve decided to install MS Office 2019 on a 2011 HP Probook 6569B Model which we also decided to reformat to run on a Windows 10 Operating System. Before you begin to watch the video below, might as well read our objectives on doing this:

  1. We wanted to test if an old laptop can smoothly run Windows 10 OS.
  2. We also wanted to know if an MS Office 2019 can actually be installed on this old laptop.
  3. And most of all, we wanted to help out everyone else who really don’t have access on MS Office 2019 and are forced to stay outdated with their old applications.

Having said that, click the video below to see for yourself the installation process of MS Office 2019 on an old laptop.

Where to DOWNLOAD???

The following files used in this video are:

MS Office 2019 Retail (Installation/Setup File) which can be downloaded here:

MS OFFICE 2019 Installer

alternate link if above is unavailable

MS Office 2019 Activator File which can be downloaded here:

MS OFFICE 2019 Product Key Activator

alternate link if above is unavaible


We do not claim any rights to the MS Office 2019 Retail – Installation/Setup file since this was directly downloaded from the Microsoft Website. The activator used was a command prompt exe file which was supposed to be manually encoded within the CMD of each system, the alteration was only done to manipulate it into a Run Command Exe for easier use.

Share this post