Helping Troubled Students

Troubled and delinquent students are not exclusive to government or private schools. In fact, these kinds of students are only natural among different types of school from college to elementary schools. Thus, the school administrators can only help identify these students and institute the needed interventions.

Normally, schools do have their Guidance Office or Student Services  to provide seminars or consultations among troubled students including those who have drug addiction.

But, schools oftentimes partner with third party institutions including addiction treatment centers to help fully their affected students and recover totally.

We wish not to see students ending in riots or in hospital beds or worse in cemeteries. Thus, let us help one another help these students because they too can hope for a good change.

Professor on Trail Running Video

Trail running has been my passion and every week, this running has become a habit. And, from the most recent trail run, 18 runners including one mid - school young lady and college professor hit the road.

And, what can be so grand was to witness the proud Mt. Matutum on early morning with welcoming locals. Watch this video from iShots. Then, perhaps, you too can have fun with us.

MySQL's Inner Join

Inner Join can be used to link two tables or more provided that they have the same matching primary key and foreign key.

The samples below link two tables, customers and sales on their customer id.

the records from Customer table

the records from Sales table

the resulting table after inner join,

 summing the total for customer record 3 using the Sum function and Group By

The syntax for INNER JOIN: 

SELECT * FROM table1 INNER JOIN table2 ON table1.PrimaryKey = table2.ForeignKey

Alternative Formats:

SELECT * FROM table1 JOIN table2 ON table1.PrimaryKey = table2.ForeignKey

SELECT *  FROM table1,table2 WHERE  table1.PrimaryKey=table2.ForeignKey

The resulting table above is shown after this command was run on MySQL:

SELECT firstname,lastname,sum(salesamount) as salesPerCustomer from customers inner join sales on customers.customerID=sales.customerID group by lastname

or

SELECT c.firstname,c.lastname,sum(s.salesamount) as salesPerCustomer from customers as c,sales as s where c.customerID=s.customerID group by lastname

Schools on 5S of Good Housekeeping

Late last year, our school had initiated a seminar on 5S of  good housekeeping that is based on Japanese 5 principles: seiri, seiton, seiso, seiketsu, and shitsuke.  In English, they can be sort, set in order, clean standardize and sustain.

It aims to eliminate wastage and promote  order and efficiency among the  personnel and in the workplace. The principles assert that if one's workplace is cluttered, an employee becomes less productive. Thus, good housekeeping can be an efficient and effective foundation to quality management and productivity.

These 5S principles can also be applied not just in schools, offices but also at home. So, sort and segregate according to their needs and clean the area at all times, document needed stuffs and do all these practices consistently. Throw unwanted stuffs,  use  paperless office software  and above all, sort your things and place them in their proper places (e.g. drawers, cabinets).

With an organized and clean table, we can practically maximize our time on more important things.