Using @EdPuzzle for the first time #flipclass #flipchat

EdPuzzle is not a new site to me, however I’ve never had the time to sit down and investigate it properly. I got the opportunity today as the rain made an overdue visit to Milan.

My Year 10 Computer Science students are revisiting the Python language and I gauged their knowledge during class last week. As they all selected similar problems to solve I decided to share my solutions via video and take advantage of the embedded questioning offered by EdPuzzle.

I had intended to link to the finished EdPuzzle from a Google Form and then mark student submissions using Flubaroo however I was happy to see that EdPuzzle linked to Google Classroom and recorded student results and progress for me.

I’ve attached a quick video walkthrough of one of the tasks below, in case you want to see how it works. I think that next time I’ll make one video so that students do not have two tasks to complete but would appreciate any other feedback or suggestions!

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.

TeachMeet Aberdeen October 2011

On Wednesday evening I once again found myself at MacRobert Building, University of Aberdeen six months on from the last one organised primarily by Stuart Brown. The wikispace advertising the TeachMeet can be found here and, in addition to this, Stuart made use of social media to extend the reach of the promotional material. This approach, along with the assistance of Jim and Linda at the University in selecting the optimum date for engaging PGDE and BEd students, resulted in over 60 attending the evening. At times the online stream had viewers into double figures but we were beset with technical issues, most disruptive was the lack of constant wifi and this seriously hampered our online impact as well as preventing the planned link up with TeachMeet Strathclyde. However the evening could be considered a success and as we were able to record most of the presentations on the laptop I hope we can – in time – share the talks with a wider audience.

To whet your appetite, here is a YouTube playlist of the May 2011 TeachMeet Aberdeen presentations.

When I find the time to edit and upload the individual presentations to YouTube I’ll update this post but I’ve included my notes on each presentation and relevant links to the web sites mentioned.

Stuart Brown – “Why de ye bother with aww that?’ – Justifying the use of ICT in the classroom

Stuart Brown: "the way we communicate is changing"

I felt this was an excellent start to the night. Stuart highlighted the fact that 19C teaching methods and environments are not suited to 21C learning. That most pupils have access to instantaneous information using devices which are often more technologically advanced than the computers and resources available in school puts today’s teachers at a disadvantage. I agreed (through gritted teeth as I recognised the phrase “don’t throw out the baby with the bathwater” from many unfocussed, confused presentations on implementation of Curriculum for Excellence) with Stuart on the need for all teachers to adapt, not rebuild to ensure that we are serving our learners sufficiently. I recommend you watch Stuart’s last TeachMeet talk (May 2011) which is a stepping stone to this presentation.

I loved the phrase Stuart used in the presentation “to stratify education” – but felt it needed explanation. Internet searches show this to be standarisation of education or use of standard tests and tracking methods.

Ian Simpson – “Becoming Orson: Podcasting the War of The Worlds”

I did this so I won’t comment for long on the actual presentation. On reflection this talk was a little early, my lunchtime podcasting group had only been working on this for about 5 weeks (30-40mins per week) and despite their excellent progress there was little evidence to share with the teachers present. However it was a good starting point for a future presentation (maybe TeachMeet Aberdeen October 2012?) on how these learners have self-organised themselves into an amateur radio drama production group. After working with them the day after the presentation and seeing how they continued to innovate and collaborate with the newly-arrived high quality microphones I have high hopes of achieving our ambitious target to have recorded and shared the full radio play by next October. Follow the progress via this blog or my twitter stream @familysimpson.

In addition Dave Adams, DO Curriculum and Quality Improvement Service for South Lanarkshire, got in touch in September and kindly sent his ideas based around the 1938 Orson Welles War of The Worlds radio play for CBS. I’ve emailed Dave to see if these lesson ideas are publicly available and will update the links section if this is the case.

Nikki Stobbie – Random Name Generator

Nikki Stobbie describes how she uses classtools.net with her classes

A presentation from a press-ganged student! Nikki showed us http://www.classtools.net and, in particular, the random name generator. Great resource to use in class and a great 2 minute presentation!

Mark Hay – ‎”Look what I did…” E-Portfolio’s using glow wiki

I didn’t see this presentation as I had to run to the shop for supplies but will update once I’ve extracted the presentation from the video clips currently sitting on my laptop.

Martin Coutts – “Maths is just a game”  – Using GBL to raise attainment

Martin showed how he used Mangahigh with an Access 3 / Foundation class to improve their motivation and attainment. Pupils were taught maths through combination of games and Prodigi technique. Competitive aspect through bronze, silver and gold and school leaderboard. Martin especially recommends sigma prime.

Kathryn Roper – “GeoBus – A mobile Earth Science Resource”

GeoBus: based at St Andrews University but a national funded resource for secondary schools (or P7 at a push). Kathryn seems very passionate about Earth Science and claims to be able to develop activities to suit your curricular area.

GeoBus launches January 2012 but those interested can get in touch with Kathryn now via kathryn.roper@mac.com

Gretchen Perk exemplified how she uses the Frayer model to enhance literacy

Gretchen Perk – “Frayer Model in Literacy”

Meldrum Academy English teacher Gretchen spoke about the Frayer Model which is a “vocab aquisition graphic builder”. She found it great for more effective learning of keywords through use of higher order skills such as analysis and synthesis. I personally found the use of non-examples especially useful. Gretchen highlighted the fact that it is a good teaching strategy for all subjects I’m already thinking about how to use this with Computing classes.

Charlie Barrow – An outward facing classroom using Augmented Reality – Junaio

Charlie repeated his May 11 talk on using augmented reality in the classroom but wanted to inspire teachers to build an Aberdeenshire channel for augmented reality. I’ve included the video of his presentation from May and hope to be working with him in the future on his vision for an Aberdeenshire channel.

More information on his own use of augmented reality in the classroom can be found at http://www.charlesbarrow.com

Stephanie Orr – Medieval Law and Order

Stephanie gave a quick 2-min presentation on using games in class to motivate and educate by stealth. http://www.tudorbritain.org/joust

Ed Walton – Fusion, Meta-cognition and The Learning Story

Presentation written during teachmeet! Ed shared how Fraserburgh Academy used Glow effectively to dissemenate work to pupils unable to attend school during snowdays. Three themes; fusion, meta-cognition And the learning story. Ed showed snow work posted for AH on glow featuring embedded prezis for self-directed learning, stagework.org which allows users to be the director for a scene from His Dark Materials. It looked fantastic! Ed showed Comic Life which he has used with classes and whole-school assemblies to explain meta-cognition. Finally Ed explained how Fraserburgh Academy has been using Honeycomb / I Can as a trial school to build an ePortfolio which remains with the child as they progress from primary through secondary. I was interested to note that because data is stored on a separate server from Glow there is no upload limit so videos and large image files can be posted. To be honest the presentation was actually 3 or 4 but there was lots of useful information.

Darren Gibb describes how he uses a variety of ICT tools to enhance learning and teaching in the English classroom

Darren Gibb – ICT teaching and learning tools

The last talk of the night was delivered by Darren Gibb, teacher of English at Banchory Academy. He exemplified many ICT tools that has augmented his learning and teaching. Again the audience was treated to a suite of presentations on different services from Todaysmeet to Evernote, Wikispaces to Glow.