Inspiration from “The ON House” Milano #thisismyclassroom

I was lucky enough to find out about this house through a parent of the school and visited it today. The ON House has been created by Simontech to demonstrate the various home and office automation products that they sell and how they can be integrated together via an overarching web app.

As you might remember from previous blog posts I am gathering inspiration, student wish lists and researching classroom design in order to develop a classroom with a clear Computer Science identity and purpose. In short I want a classroom that can be customised to suit particular learning and teaching tasks but also become integrated into the lessons I teach.

I plan to take some of my students there so they can also gain an insight into what is possible with current technology. What I particularly liked about The ON House was that the technology was not obvious or overwhelming however the integration of the technology made the house more accessible and customisable.

During the visit I thought about how some of the technology could be integrated into a Computer Science classroom. For example the ambient lighting presets could be used to indicate and suit different learning activities. Programmable colour changing LEDs in the ceiling or floor could also be accessed directly by students in their programming lessons. I think there would have to be a way of allowing access to these lights during lesson so that my classroom did not become a disco when a student got home!

The ability to change the machines that were displayed on the short throw projector via an app would also be very useful in class. At my previous school a custom SMART panel was used to switch sources which meant that any changes required software updates from the company. It also meant that if the panel broke – it cost a lot to fix it and rendered the AV unit useless. Multi-platform applications that perform the same function as a custom panel would, I think, allow changes in the future to be made much more easily. Also replacing an android tablet or iPad mini would be much cheaper than a custom SMART panel.

Simontech also explained that access levels can be set within their system and I think that this could be fantastic for lesson preparation. If you have the lighting, AV, etc. set appropriately for a particular task or topic you can quickly save this as a preset at the end of a lesson and recall that preset the next time the class comes in leaving you free to start the lesson without fiddling with the technology.

There were other interesting components built into The ON House including electric privacy glass. On returning to school I trawled YouTube for a while and found a great short video showing this in action.

In the video you can see that when the glass is set to white you can project on the surface and, if you think it’s useful, add a touch screen too. This could allow you to open out a classroom with few windows so that more natural light was let in and also function as a display space.

Another aspect they discussed was security. In their kitchen demo they showed that their app could prevent doors into other rooms as well as individual cupboards and drawers from opening depending on the preset.

I have linked a few videos and articles about the ON house below so you can find out more about it. If you are in the Milan area and would like to visit it you can send an email to theonhouse@simontech.it or phone +39 02 40043548.

Using Excel, Macros and @Evernote for Course Planning

I use Evernote a lot. I store interesting tweets, grab sections of web pages for later, have a form of GTD in there (The Secret Weapon) to keep me focussed. I took part in the 30-day paperless challenge in September and had a lot of fun seeing what was possible. I’ve even started to get my colleagues interested in using Evernote. And last month I was very happy to discover my work opened up access to the web version of Evernote.

I’ve been thinking about this for a while now: There has been a distinct disconnect in my workflow. Found an interesting link? Send it to Evernote. Got a unit to develop? Plan it up in Evernote and assign a task in my GTD stack. Plan my weekly lessons? A paper desktop planner with scribbled notes on which resources I need to have ready?! It’s really daft but, up until recently, it was the most accessible way to work. I’ve even found myself taking pictures of my planner pages and sending them to Evernote so I can check I’m ready for the coming week!

Two weeks ago I attempted to set up an electronic planner in Evernote from my workplace. The web version didn’t really like being pasted into from a Word document and screwed up all the formatting and numbering so I figured I needed a few hours investigation time and a desktop version of Evernote to make progress. This weekend I made time.

Firstly I wanted to be able to create a template with the correct number of rows for each particular class for each term, so I created a simple macro that took values (class name, start date, end date, number of periods per week) and used them to populate a new Excel worksheet. Here’s the VBA if you want to use it yourself:

Sub btnCreateTermPlanner()
Dim AddSheetQuestion As Variant
Dim StartDate As String
Dim EndDate As String
Dim noPeriods As Integer
Dim noPPW As Integer

StartDate = Worksheets(“Start”).Cells(1, 2)
EndDate = Worksheets(“Start”).Cells(2, 2)
noPeriods = Worksheets(“Start”).Cells(5, 2)
noPPW = Worksheets(“Start”).Cells(4, 2)

AddSheetQuestion = Application.InputBox(“Please enter the name of the sheet you want to add,” & vbCrLf & _
“or click the Cancel button to cancel the addition:”, _
“What sheet do you want to add?”)
‘ create new workbook
Worksheets.Add
ActiveSheet.Name = AddSheetQuestion
ActiveSheet.Move After:=Worksheets(Worksheets.Count)
‘ add header text
Worksheets(AddSheetQuestion).Range(“B2:F2”).Merge
Cells(2, 2) = AddSheetQuestion
Worksheets(AddSheetQuestion).Range(“B3:F3″).Merge
Cells(3, 2) = StartDate & ” – ” & EndDate & “, ” & noPPW & ” periods per week.”
Cells(5, 2) = “#”
Cells(5, 3) = “wb.”
Cells(5, 4) = “Topic”
Cells(5, 5) = “Learning Objectives”
Cells(5, 6) = “Resources”
‘ number rows
Call NumberPlanner(noPeriods)

‘ date rows
Call DatePlanner(noPeriods, StartDate, noPPW)

Worksheets(AddSheetQuestion).Columns(4).ColumnWidth = 30
Worksheets(AddSheetQuestion).Columns(5).ColumnWidth = 30
Worksheets(AddSheetQuestion).Columns(6).ColumnWidth = 30
End Sub

Sub NumberPlanner(ByVal noPeriods As Integer)
Dim count1 As Integer
For count1 = 1 To noPeriods
Cells(count1 + 5, 2) = count1
Next count1
End Sub
Sub DatePlanner(ByVal noPeriods As Integer, ByVal StartDate As Date, ByVal noPPW As Integer)
‘ One date at the start of every week
Dim date1 As Integer
Dim wb As Boolean
Dim daycounter As Integer
Dim weekcounter As Integer
wb = True
daycounter = noPPW
weekcounter = -1
For date1 = 0 To noPeriods – 1
If daycounter = noPPW Then
wb = True
daycounter = 0
weekcounter = weekcounter + 1
End If
If wb Then
Cells(date1 + 6, 3) = StartDate + (weekcounter * 7)
wb = False
End If
daycounter = daycounter + 1

Next date1
Cells.Columns.AutoFit

End Sub

It’s not refined and I have to admit I can’t remember how to make the macro populate a Word document directly yet but the code above generates something a little (ok, exactly) like this:

A little manual formatting after copying and pasting into Word resulted in this:

Finally, copying and pasting into the desktop version of Evernote was a breeze. It even took in the document header and footer (I’d recommend removing the footer as an Evernote note does not have a page break!).

The time consuming part will be linking Evernote notes into the resources column for each lesson, but I’m happy the structure is there. The aim is that, once completed, these plans will not only be synchronised between home and work (reducing the need for those photographs of paper planners!) but that revising them will be much more efficient as I can immediately add in a new resource or interesting news article link when I find it (because they always appear three months before or after you actually need them). If my colleagues need to look at them for any reason I can send it quickly via email.

The ultimate goal? No paper planner at all for my lessons. These folk have already managed it and, if the web version can handle editing the newly created notes, it won’t take long until I manage it too.