One of my colleagues was setting up around 400 student accounts for the new year today. He had an Excel spreadsheet with Firstname and Lastname in seperate cells A and B and needed to add two more columns with the students login name (cell C) and email address (cell D).

At first he thought this would have to be a manual process until I showed him how to join multiple cells in Microsoft Excel using the CONCATENATE function. The login name had to take the format firstname.lastname and the email address had to be in the format firstname.lastname@schoolname.school.nz.
Continue reading

I’m going to be cabling our new house soon with Cat6 for phones and data, speaker cabling (more on this later) and I’d like to run something at the same time to future proof us if we decide to purchase a projector in the future. I’ve got to make the decision between running an HDMI cable, of around 10m, into the ceiling, or instead run some cabling for YCbCr Digital Component video (as opposed to analog YPbPr/RGB). This post goes through my thought process when choosing HDMI vs YCbCr Digital Component video
Continue reading