LATEST NEWS

6/recent/ticker-posts

School Form 1: How to Unmerge Data into Multiple Cells in Excel

What you’re seeing now is basically an LIS Generated School Form 1. I say “basically” because I kinda’ changed some major details in it because of the Data Privacy Act and we’re not allowed to publicized personal information of anyone including our learners. 

 

So, for teachers both public and private schools, you should all be familiar with this School Form along with all the policies that govern it. As for our – soon to be – teachers, if you’re watching this right now, I suggest you take some notes, what you will be seeing right now ain’t taught in schools anywhere in the country.

 

Now, every teacher who handles the School Forms knows how important this SF1 is. It’s basically your complete class list which has all the information of your students who are officially enrolled in your class. All information is tabulated into this table right here.

 

The major concern of our teachers with this form is the fact that it’s generated in a way wherein all the necessary information of our students are placed in table format that has multiple cells merged in each data. 

 

For example, in the learners’ names, the Full Name of your students are found in a merged cell that combined the Last Name, First Name, Extension Name and Middle Name of your learners. And since this cell is a merged cell, we can’t just dissect the names individually.

 

You might see a lot of tutorials in the internet on how to do this, but to save you all the trouble, let me tell you why those won’t work.

 

First, Filipinos have a very complex way of naming their kids. In fact, most Filipino names are very complicated due to our mixed cultural history courtesy of our preoccupation from the Spanish, Japanese and American colonizers. So, a huge thanks to these nations for making our lives a lot more difficult than it already is. Filipinos have this way of making their kids’ names very “unique”. Such that they have multiple first names, like, “Juan Carlos Miguel” and then there’s their middle “Santos”, and the family name, “Cruz”, now to top it all off, they add an extension name, a "Jr" perhaps. That basically makes up to, “Juan Carlos Miguel Santos Cruz Jr.”. Now, that’s one very long name for you!

 

Secondly, if such name is found in your LIS, any formula or tutorial you will find in the internet for breaking these names will not be dynamic. Simply because most tutorials will based on a standard idea of regular names. A first name, middle name, and last name.

 

And for that very reason, many of our teachers can’t fully source out the data found in the LIS School Form 1 into their different School Forms. For example, the School Form 10 right here. You can see in the learner’s profile in the upper part, each learner data is separated into different sections. Which means, teachers need to dissect the names found in the School Form 1 before they can use it here in our School Form 10 which is the most important document for our learners’ throughout Grade 1 to Grade 12. 

 

So, how do we dissect all of these data into individual cells so that our tasks would become way easier and we can become more efficient and productive with our time? 

  

In your LIS School Form 1, I want you to copy all the data here by pressing CTRL A in your keyboard and pressing CTRL C. 

 

Once that is copied, you need to open our iSF School Form 1 Data Divider file which you can download below:


 

 


When you open the file, a security notification will be prompted for you. If you’re using Windows instead of Mac, the security notifications is found below the ribbon tab of your Excel Workbook, just above the Column Sections. After enabling all these security features, you will be greeted by our Welcome Page which also happens to be a navigation sheet where you can easily access our Facebook page, YouTube channel and website with just a click of your mouse. Below it would be information about using our Free Templates and a reminder about unlawful distribution, selling and profiteering of our projects. You can also use the icons below in case you’d like to send us your donations for our efforts in making these free templates for all of you.

 

Now, click the OPEN TO BLANK FILE button right here and you’d be transferred to our School Form 1 – Copy spreadsheet.

 

Paste everything here by pressing CTRL V on your keyboards.

 

Don’t worry if the data is a bit messy with all the rows and columns overlapping with one another. We only need the data here, so just let it be. Now, click the GO TO SF 1 Data Segregator button.

 

In this worksheet, you can see there are three buttons you can use. The Generate School Form 1 Data button which will automatically dissect your learners’ data into their respective cells. Following that will be the reset button, in case you wish to paste a new School Form 1 from the LIS in our blank sheet previously. And of course, our Template Information button which is the property ownership of this file. 

 

So, click the button right there to distribute all the data from our SF 1 to its individual cells. 

 

And just like that, you have harvested all of your School Form 1 data into different cells! And since the data are taken from the School Form 1 using our VBA codes, the data is not formula based. Which means, you can just copy all these cells either individually or as a group and use it to whatever purpose you have in mind. 

 

Now, you can easily use these information for School Form 10 or School Form 9, or whatever document you wish to process which requires you to have their data accessible and neatly organized in a table form.

 

So, that’s it! This is how you can easily unmerge and fetch all the data from the School Form 1 into different cells without compromising your SF 1 data. 

 

If you found this video useful, please don’t forget to subscribe in our channel and always click the notification bell to get notified with our latest videos. Like and share our videos to others so that they would learn from us too. 

 

Post a Comment

0 Comments