Sunday, October 16, 2016

Income - Generating Projects for Schools

The income - generating projects can be dependent on your school's resources like empty lands, or livestock or farms that can be used for maximized profits.

The projects I mention herein are the income - generating projects I believe can be possible for STI College - General Santos.


You can adopt these ideas that may appropriate for your school.

Proposed programs / projects for Income Augmentation:

  • Further improve the linkage or off – school services of STI College – Gen Santos  to private and government agencies who need additional workforce or resources in their events.

>> Presently, only the HRM students are contracted for on – call services in a sister – company hotel of STI – Gensan. This can be further improved with similar programs encompassing other students of other programs like IT, or Business studies and further promoted to other companies as well.

Moreover, the exposure shall be beneficial to students in terms of their holistic  learning.

  • Provide  catering, managerial – training, IT services, and facilities for hire.

>> Presently, the school offers only free use of IT laboratories or computers for promotional purposes. However, this can be further complemented if the school can also offer services or trainings that can be financially remunerated.

>> Teachers who have the technical expertise can be contracted to deliver trainings to other institutions which may need technical assistance.

>> Students and teachers may produce business plans for feasibility studies among companies which need company research. IT students with their teachers may create computer programs, networking of computer systems, or troubleshooting services to sister companies and / or external companies that STI – Gensan has linkages with.

All these will further showcase the technical specialization of STI Gensan, and the school’s  workforce will have the affirmation and / or value – added enhancement of their skills from industry or field exposure.

  • Expand the Internship program across all courses.

>> The present Internship program is provided to HRM and Business Administration students. The income can be further increased if the internship is offered to all programs. Bigger  internship fees can be collected, but apart from this, the school can be further promoted locally and internationally with expanded global exposure.

  • Create a market for the student projects. Remarkable students projects can be sold to companies who can have better use of these end – results. This is taking a proactive initiative to encouraging students and teachers to innovate and to materialize their technical skills.
  •  Other Income  - generating  projects:

a.       Invite more food – providers and service contractors like photocopier / bookbinding. Rental fees from these sellers can be viable fund – generating means.
b.      Sell school supplies. Selling of supplies like paper, pen, among other basic school needs can be viable sale as well.
c.       Create training / learning modules for sale. While STI – Gensan strictly follows the policies of STI Educational Network, teachers can create independent learning modules that can be sold to students and other  institutions.

Thursday, September 22, 2016

Music: Boosting Your Brain

When I was younger, I normally locked myself in the bedroom or woke up around 4AM to study for exam or answer my school assignments. I needed the silence to focus, however, this can be a problem too because the peaceful environment could tempt me to sleep between books (which happened very frequently). So, as I would not be tempted, I would sit in the most uncomfortable way, so, I couldnt sleep and this would work so effectively, that I graduated top of my batch.

But, as I grew older, my inclination for music had been improved (I could hardly sing though) but I need the music to keep me pumping, to keep my brain humming.


This worked well as I finished my college course (graduating top of the batch), 2 masteral degrees and now pursuing my PhD. I love listening to happy music from sergio vallin and online / radio stations   or classical ones if it's still too early in the morning.

Experts believe  that by listening to music, you:
  • improve your mood, thereby, producing productivity
  • boost your brain with the brain chemicals ( dopamine and oxytoxin) being released; dopamine as  responsible for the positive / good states that we normally experience from pleasurable things like sex, eating or exercising and oxytoxin as responsible for being trustworthy or generous with others.
  • learn through music from language, math, or spatial intelligence. Even kids with Learning Disability can learn through music as their medium. 
So, if you need to prepare for exams or something, you need to calm your brain, so, to dis-engage you from stress that deviates you from remembering things, scientists believe that music can induce a state of meditation and relaxes the brain, thus, it can function better.

Experts, however, showed in the recent study that specific music like Mozart's L'allegro can boost brain activity over Beethoven's Fur Elise. The former was played among young adults and elderly and it showed increase in brain activity related to memory, cognition and problem solving.

It's good to know that we can have access now to music that are brain - boosters. So, grab those CDs  or play some tunes in your smartphones and be the genius that you can be! 

Wednesday, September 21, 2016

Consolidating Several Worksheets from Different Workbooks using Macro

I have been using MS Excel before whenever I had to make grades for my classes but never did I think that I shall be using MS Excel to create programs or what they call VBA as I have been using only Java or C# with MySQL or Oracle for database programming.

So, working now as an Excel Trainer cum Reports Analyst, I have to create small macro programs that will aid the office in report generation. So, let me share, a simple Macro Program to that shall consolidate / combine different worksheets from several workbooks into one summary file.

I hope these will help you in your macro learning.

different worksheets of different workbooks

These files were saved in one folder, and the idea is to combine different data from different worksheet and combine them all in one separate workbook say in a different folder.

the summary file (some rows were hidden for visual purpose)

So, in my Summary File, I write these:

Sub createSummarySheet()
Dim SummarySht As Worksheet
Dim FolderPath As String
Dim BlankRow As Long
Dim FileName As String
Dim WorkBk As Workbook
Dim SourceRange As Range
Dim DestRange As Range
Dim lastrow As Long

Set SummarySht = ActiveWorkbook.Worksheets(1)
FolderPath = "C:\Tickets\"  'this is the folder where you will save your different workbooks for consolidation

BlankRow = 2
FileName = Dir(FolderPath & "*.xl*")
SummarySht.Range("A2:D" & SummarySht.Rows.Count).ClearContents

Do While FileName <> ""
    Set WorkBk = Workbooks.Open(FolderPath & FileName)
    'call combine function
    SummarySht.Range("A" & BlankRow).Value = FileName
    lastrow = WorkBk.Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
    Set SourceRange = WorkBk.Worksheets(1).Range(Cells(2, 1), Cells(lastrow, 3))
    Set DestRange = SummarySht.Range("B" & BlankRow)
    Set DestRange = DestRange.Resize(SourceRange.Rows.Count, SourceRange.Columns.Count)
    DestRange.Value = SourceRange.Value
    BlankRow = BlankRow + DestRange.Rows.Count
    WorkBk.Close saveChanges:=False
    FileName = Dir()


SummarySht.Range("A1:D" & SummarySht.UsedRange.Rows.Count).Borders.LineStyle = xlContinuous
End Sub
In  another module to combine the different worksheets before being captured into summary file, I write these:

Sub Combine()
    Dim J As Integer

    On Error Resume Next
    Worksheets.Add ' add a sheet in first place
    Sheets(1).Name = "Sheet1"

    ' copy headings
    Selection.Copy Destination:=Sheets(1).Range("A1")

    ' work through sheets
    For J = 2 To Sheets.Count ' from sheet 2 to last sheet
        Sheets(J).Activate ' make the sheet active
        Selection.CurrentRegion.Select ' select all cells in this sheets

        ' select all lines except title
        Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select

        ' copy cells selected in the new sheet on last line
        Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp)(2)
End Sub

Culture and Education, the Philippine Perspective

I posted this as part of my answer for Socio - Cultural Foundation  online discussion on how culture and school can interplay its effect on one another.

I cant help but cite the Philippine scenario of how culture is affecting everyone on / off school.

While culture and education have a two - way effect with one another, if qualifying  indicators include employment of graduates, drop-out rates, or Human Development Index, I may say we are getting better and the source of change can be attributed to the efforts of our schools systems. However, we still fall short if we need to see the real facts and to further compare these against other countries.

In the case of drop-out rates, from the records of EduData of August 2015(source: GMA News Online), it suggests that:

  • Survival rates have been improving steadily over the past three year, with about 60% of the initial class graduating high school in 2015, compared to about 50% in 2013.
  • The survival rate improvement can be attributable to the Grade 2 dropout rate. More and more students are choosing to proceed after their first year in school compared to past years.

  • Once a student has reached grade 3, there is a small chance that he will be unable to graduate elementary school. However, making the leap from elementary to high school is still difficult.

  • Females have a higher propensity for staying in school than males, but fewer are given the opportunity to attend high school after graduating elementary.

  • The gaps in dropout rates between genders have remained generally unchanged over time.

  • the drop-out hotspots include war - plagued provinces like Zamboanga, typhoon - prone provinces in Eastern Visayas and a small hotspot in Central Luzon.

While we are improving, we still need to do more as our quality of education is still undervalued. One indicator of this the rank of our universities and colleges as compared to other Asian academic institutions. Several years ago, we were of equal with Thailand and Malaysia, but from the 2015 QS University Rankings for Asia, we only had 1 public school (UP) being included in the top schools compared to 11 public institutions from Thailand, and 14 from Malaysia (source:

And because  of social meritocracy, employment is normally prejudiced if you dont come from any renowned institutions like DeLa Salle or UST. So, what can we say then for graduates coming from the provinces? Their future I may say is huddled with more prejudice and skills/knowledge to prove.

Further, if value system is one of the criterion of a positive culture, then what can we say about the claim of former BIR Chief Kim Henares that 90% of our professionals are tax evaders and these include doctors, lawyers, architects and entertainers (source:  This is one reflection that value integration and internalization is not prioritized as compared to subjects like science or mathematics.

So, teachers and school heads are challenged to do more. The end - results are still not sufficient if we need to catch up with counterparts (Thailand, Malaysia at least).