Tag Archives: Music education

StAC Students Team Up To Form Souldrop

Posted on by
1
band

The four members of Souldrop

Recently I caught up with Finn Perring, Anna Bennetto and Grace Dephoff who are part of a wider group of students that make up the band Souldrop. Anna leads the vocals, Finn plays bass guitar and Fin Gilzean (St Thomas of Canterbury College) plays lead guitar whilst Elliot Millar (Burnside High School) is on the drums. Formed in April 2016, their first single Mill Bay was released in August with an accompanying music video shot and edited by Grace Dephoff and their 5 track EP will be available from the 9th September 2016.

UPDATE 25/9/16 The band’s self-titled EP is now available and embedded below via Spotify:

 

I was particularly interested in the technology the band used to record the track as well as edit the video, however to understand all of this it was important to learn of the various musical influences on the band.

  • Elliot is a jazz and big band drummer, representing Burnside High School in various musical competitions.
  • Fin learnt blues and classic rock guitar, mostly from his father
  • Anna has been performing for over ten years in musical theatre shows, as a jazz singer in various bands as well as one soul band.
  • Finn is a classically trained guitarist who plays Spanish flamenco guitar, but bass for Souldrop.

Recording & mastering the audio track:

Most of the audio track was recorded in the St Andrew’s College recording studio with the vocals, drums and bass all being laid down in this environment. The lead guitar parts, however, were recorded in Fin’s bedroom using Apple’s Garageband. Once finished, these guitar recordings were sent to the other Finn (Perring) to add to the other instruments and mix the recording in Apple’s Logic Pro X. To this end, the band never played the entire song together in the same room during the recording process, instead relying on the use of over-dubbing to achieve the best sound.

This slideshow requires JavaScript.

From a non-musicians perspective, I found this a fascinating way to craft a complete song, through the selective and judicious extracting of various takes of the song and merging them all together in an order that produces the best quality song. Additionally, the song was a very collaborative effort with the idea of the song first coming in a formative stage to Finn Perring around two years ago, before drummer Elliot and lead singer Anna co-wrote the lyrics for the song.

Recording & editing the music video:

Grace Dephoff filmed all of the footage for the video in a single afternoon using a Canon 70D camera with the 16-24mm lens and a 50mm lens borrowed from Mr Dave Jensen who works in the TV studio at St Andrew’s College. There was a limited script for the recording of the music video, instead a desire to keep it as natural as possible for the band members. One of the most clever features of the music video is the fact it is in slow motion, whilst keeping the music and singing in real time.

filming

Grace Dephoff filming the band

This was achieved by having the band perform the song at 1.5x normal speed from speakers that they could hear to help them keep time, whilst Grace filmed at 50fps so that it could be later slowed down to 67% normal speed and still look smooth after this editing had taken place. The end effect makes it look like the band are in time to the song, even though they are in slow motion. Grace had learnt of this technique from a former guitar teacher she and the whole band were thrilled with the end result and how it looked.

To edit the hours of video footage, Grace used Apple’s Final Cut Pro, a tool she was largely self-taught in after graduating from using Apple iMovie for a number of years, including winning numerous prizes at the annual St Andrew’s College Film Fest. All up, she spent around 10 hours editing the footage and another 6 hours completing the colour grading in the video.

Distributing and Promoting the single:

The band are using a combination of word of mouth and social media to get exposure for the first single Mill Bay, combining messages on Facebook, Instagram and, of course, the YouTube channel itself. They have added a number of live performances as well, including lunchtime shows in the St Andrew’s College Quad, an assembly at Burnside High School and a performance at St Thomas of Canterbury College as well. There is a planned interview on 98RDU radio station as well on 14th September.

TunecoreLogoThe song has been released through TuneCore which is a digital media distribution company which automatically publishes the song to the main digital music platforms including Spotify, iTunes, Amazon, Google Play, Shazaam and the YouTube channel the band have created as well. Anna and Finn’s focus at this stage is getting the song out to as wide an audience as possible and any revenue that is generated from the track being played is a bonus. TuneCore will send the band monthly statistics around the performance of the song on the various platforms.

In terms of copyright and protecting the song, the band have chosen to use the Creative Commons licensing platform. They recognise that this license might not stop another band from being able to sample their work, but they will be required to acknowledge Souldrop as the source of the original content for the sample.

What’s Next?

The band are keen to keep gigging and playing as many live performances as possible to increase their exposure and improve as a unit. They are also thinking about recording another music video for one of the other tracks on the soon to be released EP.

My Thoughts

I have been super impressed with the members of the band that I have met so far, both in terms of their musical ability but also their technical skills to be able to produce such high quality recordings and videos. It is always pleasing to see that skills that have been taught and learnt at St Andrew’s College are finding a creative outlet in the areas of student’s own interests such as being part of a band.

team

The wider Souldrop crew including Anna Bennetto (back row, second from right), Finn Perring (back row, far right) and Grace Dephoff (from row, first on the left)

This song and video highlight how technology has enabled students to create high quality, professional looking videos and promote them digitally to an international audience. When I pointed this out to Finn, Anna and Grace their reaction was a mixture of pride and nonchalance in the work they had created, highlighting to me just how natural the use of this technology is to students these days. Importantly, they had thought about using Creative Commons to copyright their work demonstrating an inherent understanding of the value of their music and video.

Finally, there is opportunities for this work to be credited against various NCEA internal Achievement Standards in some subjects (mainly English/Music) which would be a serendipitous outcome of what is essentially a passion project for these students. This is, perhaps, one of the biggest outcomes and reasons to pause for thought from this. If schools were able to recognise the creative output of students in areas of their interests perhaps we would finally see the flexibility of NCEA that is often talked about, yet rarely achieved.

eLearning Through The Lens Of Key Competencies

Posted on by
1

EdTech SummitIn the last week of Term 2 I had the opportunity to present at the NZ Tech Advance Education Technology Summit hosted at Massey University’s Albany Campus. Key topics and subjects discussed include:

  • Inquiry | Creativity | Collaboration – The role of technology in modern learning
  • Developing teacher understanding and encouraging implementation of collaborative and digital learning methods
  • Integrating and encouraging digital technology adoption in curriculum and classroom
  • The new narrative: IT training and computational thinking
  • Building technology into the curriculum – lessons, challenges and what we’ve learnt along the way
  • Collaboration at the forefront of today’s teaching environment

When preparing what I wanted to share at the 40 minute session I had been given, I decided on using the Key Competencies from the New Zealand Curriculum to explain why some examples of eLearning from four St Andrew’s College teachers had been successful. Additionally, I wanted to use authentic student voice to highlight this – fortunately, having been blogging on this site for over two years now there was plenty of examples I could draw on.

If you are interested in an independent view of my session then you can see this micro blogs from Nathaniel Louwrens here and this brief reflection from Andrew Corney here. You can download a full copy of my slides from the presentation from this link on dropbox.com.

The Key Competencies are at the heart of great teaching and learning in New Zealand and are the bedrock upon which effective eLearning can be built on.

Key Competencies

The Key Competencies from the NZ Curriculum

It’s worth reading over the entire descriptions of learners who demonstrate the 5 Key Competencies but some highlights I pulled out to share at the conference included:

  • Thinking: is about using creative, critical, and metacognitive processes to make sense of information, experiences, and ideas … Intellectual curiosity is at the heart of this competency … [Students] reflect on their own learning, draw on personal knowledge and intuitions, ask questions, and challenge the basis of assumptions and perceptions.
  • Using Language, Symbols and Texts:  Using language, symbols, and texts is about working with and making meaning of the codes in which knowledge is expressed  … Students who are competent users … can interpret and use words, number, images, … and technologies in a range of contexts … They confidently use ICT to access and provide information and to communicate with others
  • Managing Self: This competency is associated with self-motivation, a “can-do” attitude, and with students seeing themselves as capable learners … It is integral to self-assessment.
  • Relating To Others: Students who relate well to others are open to new learning and able to take different roles in different situations … By working effectively together, they can come up with new approaches, ideas, and ways of thinking.
  • Participating & Contributing: This competency is about being actively involved in communities … They may be local, national, or global. This competency includes a capacity … to make connections with others, and to create opportunities for others in the group.

I started the session off by highlighting the fact that often ICT is talked about in terms of risk. This can come from security breaches, budget blow-outs and ICT project cost overruns, not to mention distracted and off-task behaviour when using technology. I then posed the following questions:

Questions.png

I wanted to highlight how some of the best examples of effective eLearning from teachers at St Andrew’s College was firmly rooted in Key Competencies. I chose examples from the following four teachers:

Teachers

Combining OneNote & MineCraft To Create Pick-A-Path Stories:

This example is explained in more detail here and the basic Learning Outcomes are displayed below with the relevant Key Competencies included:

Learning outcomes from this unit:

  • to produce interactive pick-a-path adventure stories
    • KC: Using Languages, Symbols & Text
  • to work collaboratively online to produce an end product
    • KC: Relating To Others
  • to create stories to share online with a wider audience
    • KC: Participating & Contributing

As mentioned above, I wanted to use authentic student voice as much as possible so I included an abbreviated version of the following video so that the audience could hear students articulating their learning and the impact that technology had made:

An insightful quote from the student called Harry was:

The goal was not to just make something pretty in Minecraft, it was actually to improve the quality of your writing … after writing the story, the idea was to look back in Minecraft and see how you could improve the writing you had already completed.

SAMR DivingTo assist teachers at St Andrew’s College with integration of technology into their teaching and learning, we have adopted the SAMR taxonomy that you can see on the left.

This is a really useful way for teachers to conceptualise how technology might assist the learning outcomes for their students as well as provide them some aspirational goals for extended use of technology. Tom Adams, our eLearning Integrator, has recently written in detail about effective use of the SAMR model which is definitely worth reading if you are new to it. During the presentation, I introduced the audience to a relatively new product from Microsoft called Pulse. This enables the audience to provide real time feedback on a session as well as allowing the presenter to push out questions for quick polls. I asked the audience “What level of SAMR do you feel the Minecraft/OneNote example was operating at?” and below is their response:

Pulse SAMR

Using Microsoft Pulse for instant feedback from the audience

Inspiring Creative Writing Through Constructing Digital Worlds:

The next example I shared was again around creative writing, this time from the High School instead of a Year 6 class. The full reflection can be found here, however the high level overview of the task was as follows (with Key Competencies inserted):

Learning Tasks For This Unit:

  • Write a short story of ~600 words with a theme of “conflict”
    • KC: Using Languages, Symbols & Text
  • Students Must produce at least 4 “drafts”
    • KC: Thinking
  • Drafts must be shared with peers for feedback/feed-forward & act on appropriate advice
    • KC: Participating & Contributing

What was different about this activity is that students had to build their digital world before they started their writing and use it as a source of inspiration and planning, not just as a reflective tool for editing. Settings were constructed in Sketchup, Paint, Minecraft and the source engine of the game Counter-Strike. Here is a student Ralph talking about his world which I again shared with the conference audience:

Again, I find the language used by the student here informative, with some of his comments being:

  • “I wanted readers to grasp that the bombs had come from the bank itself”
    • Clearly, the reader’s experience is at the forefront of his thinking when he is designing his digital world.
  • He blended his natural enjoyment of the game Counter Strike with his school work and learning – a win/win situation!
  • Ralph talks about adding a backstory to the real events of the London Bombings, demonstrating a wider awareness of global communities
  • “As I was designing the level I was constantly thinking of ways I could make the story more interesting.”
    • This was not just technology for the sake of it – it was clearly shaping and informing his understanding of the creative writing task that was the key learning outcome here.
    • This was manifested through his drafting process where he removed a lot of the dialogue to improve the narrative flow and added more descriptive text such as the sound of the gunfire

This impressive learning came on the back of an earlier, easier task where the students in the class had leveraged an existing digital world (Google Earth) rather than having to create their own. Through the lens of the SAMR scale this makes perfect sense – the students build their knowledge and experience of digital toolsets in the lower levels of SAMR and once mastered they can progress to more difficult tasks. Here is a write up of the earlier task where students had to explain the significance of setting in a film, and this is a student talking about their comprehension.

Again, it’s important to pick up on the student’s language – the technology is integrally linked to the learning outcomes, it is not merely there for entertainment or distraction. By requiring students to record their personal reflections in this way, students are using a number of Key Competencies.

Communicate Musical Intention By Composing An Original Piece of Music Inspired By Art:

The final example I shared with the audience came from Level 3 Year 13 Music. On the first day of the conference I had been asked to be part of a Q&A Panel about integrating technology into schools and one question from the audience was essentially around what are real world examples of great technology usage in NCEA subjects. The heart of the question was around the challenge of adapting existing assessments to be technology rich and I answered it by a brief description of this example from Mr Duncan Ferguson our Head of Music.

  • Using AS.91419 (3.4)
    • KC: Using Languages, Symbols & Texts
  • Students are required to reflect on their composition and explain the connection with the art that inspired them
    • KC: Thinking
  • These are largely independent projects that the students need to work on themselves
    • KC: Managing Self

Here is the video of the student reflecting on their learning:

Flipping The Maths Classroom:

I wanted to allow some Q&A at the end of my session so I ran out of time to share this example from Mr Ben Hilliam, so I’ll briefly reference it here. In this example, the key learning outcomes included:

  • Year 9 Maths: solving Linear Equations
    • KC: Using Language, Symbols & Text
  • Students were required to watch the instructional videos and then attempt the practice questions
    • KC: Thinking
  • Students needed to regularly complete check lists indicating their progress
    • KC: Managing Self

Here is an example video made by Mr Hilliam:

What I most liked about this example is that students were not left on their own to just work through it, the teacher is still involved through the process, despite the availability of the instructional videos. The following screenshot is from a OneNote Class Notebook showing how the student has completed their progress reports and the teacher has provided feedback:

Work eg2

I used MS Pulse to ask the audience whether they personally felt that using a “flipped classroom” genuinely created more opportunities for differentiated and personalised learning during class time. Their response was overwhelmingly “yes!”

Flipping The Classroom

An alternative way to show poll results from MS Pulse

I concluded my session with the following thoughts:

Concluding Thoughts

I really enjoyed the opportunity to present at the NZ Tech Advance Education Technology Summit and was fortunate enough to receive some positive feedback from the session:

Modelling Google Earth Tours & Internet Research

Posted on by
Reply

Barry Martin PhotoI was recently invited to speak at the weekly St Andrew’s College Chapel Service. One of the features of these services is the Deputy Head Prefects walking up the centre aisle at the conclusion of the first hymn, and saying “Today we remember ….” and naming an Old Collegian who was killed in action.

For my Chapel, I researched Barry Martin, student #101 at St Andrew’s, who attended from 1918-25 in the Preparatory School and completed his first tour in the RAF before volunteering for a second and eventually completing 46 operational missions over occupied Europe, before being killed on 2nd February 1943.

To visually represent Barry’s life, I opted to build a Google Earth Tour (something I shared on at the recent TeachMeet hosted at St Andrew’s) and indicate places of significance such as his birth (Waiau, North Canterbury), where he attended school (here at St Andrew’s College), through to his various flight training and operational bases (Canada, Mildenhall and Oakington) and his final resting place (Rotterdam General Cemetery). Google Earth tours are something we have encouraged teachers to use and some good examples include:

Targets

The yellow pins in this Google Earth screenshot represent targets Barry Martin navigated his crew to, over the course of his 46 flights.

The entire story that I shared at the Chapel Service can be seen in the video at the top of the blog, however you can see the start of the narrated Google Earth tour here. What has been interesting to me is the amount of teachers and students who were really surprised by the power of Google Earth, having never really used it in any meaningful context before. Consequently, Tom Adams (our eLearning Integrator) has run some professional development sessions for staff interested in using it with their students.

The reality is, whilst the visualisations of Barry Martin’s journey added engagement through technology, the researching of the information for the presentation itself was almost entirely dependent on the power of the Internet. I had used Microsoft OneNote to easily compile a working document of information, starting with links to relevant websites and notes to myself on their usefulness:

The ease of being able to drag ‘n drop and cut ‘n paste information into this notebook accelerated the research considerably:

OneNote for research

Screenshot of my OneNote notebook for researching Old Collegians

One of my goals in this research was to bring to life Barry Martin’s story and show more about him as person and not just a statistic from World War II. Through the searching of PapersPast I was able to find references to Barry’s pre-war life, including his engagement and  attendance at an Old Collegian dance at the Dunsandel Hall with his fiancee, which sounded like an eventful night with the power cutting out!

Other sources that proved invaluable in finding out more about Barry’s life included Google Books, an unexpected source that showed up the research of Stephen Harris in his book Under a Bomber’s Moon and the relationship between his great Uncle Col Jones and Barry Martin. It is from this source that I obtained the photo below of Barry with unnamed friends, along with the entertaining account of Barry cooking up a storm in the barracks with tins of lambs tongues and tomato sauce sent to him from New Zealand:

Dutch Police Report

Original Dutch Police Report on the crash of Barry Martin’s Stirling bomber.

Other sources were not so easy, but did manage to turn up gold for this research. I optimistically posted on the Wings Over New Zealand Aviation Forum and was thrilled to get a reply out of that which led to obtaining a copy of the original Dutch Police Report that detailed the circumstances and location of the crashed Stirling Bomber on the night that Barry Martin’s plane was shot down and he was killed. This was eventually sourced from the book “De Crash Van De Padvinder” by P. van der Leer.

This highlights that whilst the Internet can be an outstanding source of quick and accessible information, the importance of human interaction (even if that is via forums, email and text messaging) along with a curiosity not to give up, remains a vital part of any good research. The Christchurch City library had all three volumes of For Your Tomorrow  by Errol Martin which was invaluable for factual details, and the St Andrew’s College library had historical records of Barry’s attendance at the College, 98 years ago.

Old Collegian

I also discovered that Barry Martin’s medals had been auction at Bonhams in 2014:

Bonhams Medals

Barry Martin’s medals – note the Distinguished Flying Cross (DFC) on the left. Barry never knew he had been awarded this, as it was announced only two days after his disappearance.

It was very gratifying to be able to harness the power of technology to shine some light on an Old Collegian of St Andrew’s College and the ultimate sacrifice he made.

UPDATE:

This is the recording of an earlier Chapel Service that I gave on James Samuel Cartwright. He was a former teacher at St Andrew’s College and All Black triallist and was tragically killed only days after the D-Day Normandy invasion:

Duncan Ferguson – Apple Distinguished Educator 2016

Posted on by
Reply
DFE

Mr Duncan Ferguson

Congratulations to St Andrew’s College’s Head of Music Mr Duncan Ferguson who has been selected as an Apple Distinguished Educator for 2016.

Mr Ferguson is one of five New Zealanders to be selected to attend the Apple Distinguished Educators conference in Berlin, Germany.

Attending an ADE Institute provides powerful opportunities for collaboration and ongoing professional growth for ADE alumni members. This 4-day intensive professional learning experience, will bring 400 ADEs together to collaborate, share, and learn. By collaborating directly with peers from across the world, ADEs will return home with a shared sense of purpose as they develop content and promote powerful ideas for improving teaching and learning worldwide.

To see the iBook about Collaborative Composition that Mr Ferguson wrote as a result of the 2015 ADE Institute in Singapore please visit:

https://itunes.apple.com/nz/book/collaborative-composition/id1052956067?mt=13

Congratulations and have a great trip to Berlin!

Guest Post: The Ideal Setup For A School Recording Studio

Posted on by
1

band-recording-in-one-room.png

This is a Guest Post from our Head of the Music Department Mr Duncan Ferguson who is also an Apple Distinguished Educator for 2015. He has posted here before about the integration of technology and music as well as project based learning approaches in Music. You can read the original post here.

Last year I was lucky enough to be granted the Head of Independent Schools Scholarship Trust award. This enabled me to travel to San Francisco and NYC to study how Music Technology is successfully being incorporated into high schools.

As a result of this study I have produced a document called The Music Educators Technology Survival Guide. This is a free download and takes you through recommended equipment required to setup up a music technology programme in your high school. It also provides an overview of the requirements for the NZQA Unit Standards, which you may use to assess your students’ music technology skills.

However, it’s one thing to have all the gear for teaching music technology but I’ve found the physical makeup of your studio/recording/mixing spaces, are critical to student success.

Of course, the quality of the acoustics in your recording space(s) is one of the most important factors but unless you’re involved in a new build of your department there may not be a huge amount you can do (whatever you do, don’t put egg cartons on your walls, they will only make things worse!).

But if you are lucky enough to plan a new setup this is what I recommend you aim for when you’re trying to record a rock band.

Recording Room Setup

Band recording in one room

Some important things to note:

  • All the musicians (apart from the singer) are recording in the same room at the same time but the only instrument that is actually mic’ed up in the recording room is the drum kit.
  • The guitar signal is recorded via a DI box, which is then outputted to an amplifier in a separate ‘amp’ room (using a specialized reamp device). The guitar amp is mic’ed up with one or two mics and those signals are then returned to the recording system. The guitar amp signal is then fed back to the musicians via headphones.
    Guitar Signal Flow
  • The bass player is recorded via a DI box with the signal returned to the musicians headphones. The bass track usually sounds great if you have a good quality DI (like a Radial JDI) but if you need to reamp it later and/or overdub this is also an option.
  • The singer is recorded in the mixing (or other) room with their signal coming back to the musicians’ headphones. If the quality of the singer’s track is not good enough they can be overdubbed later.

Why does this setup work so well?

Generally high schools students are not going to be good enough to record to a click track and retain a good feel, and they’re also not great at overdubbing instruments one by one. So this setup allows them to play all together as they would in a normal rehearsal room, hopefully creating a great groove.

But with our multi-room setup (i.e. having an amp room) we are able to record each instrument on to isolated tracks in our DAW so if one musician makes a minor mistake you don’t have to stop the take as you would if you had the amps in the same rooms as the drum microphones. Any minor mistakes can be cut out and re-recorded (or inserted from another take) just by the musician that made the mistake, without forcing the whole band to do another take.

Having all instruments on isolated tracks (without any ‘bleed’ from the other instruments in their tracks) allows us to fix timing and pitch issues with software like Celemony Melodyne.

On a recent session the bass player had huge trouble locking in with the drums. If the band had recorded to a click track it would be easy to ‘quantize’ the bass audio to the grid but as I said before, most high school bands aren’t good enough to be able to record to click well.

But using the new version of Melodyne 4 you are easily able to generate a ‘tempo map’ of the performance (most likely using the drum kit as your timing reference) which you can then quantize the bass to, making the two musicians perfectly in time with each other (even though they didn’t record to a click). I’ll do a full review of this software and walk through this process in a future blog.

If you want hands on, practical help with understanding how to create a recording setup like this I’m running workshops for teachers – Learning Ideas Teacher Training.

The Power Of Data

Posted on by
6

PowerBIIncreasingly, most organisations are seeking to “do more” with the data they collect and store and in this respect, St Andrew’s College is no different. For the last two years I have been looking at a number of tools that would allow us to easily collect, analyse, display and share critical information amongst key stakeholders.

As part of this investigation we have looked at tools such as Crystal Reports, Tableau and Microsoft Excel connected via MS-Query to our MS-SQL server and outputting pivot tables for analysis. Here are some examples of this:

A custom Crystal Report showing a student’s Fortnightly Notes score.
A chart in Tableau comparing the performance of StAC students with Decile 8-10 schools in a Year 11 Maths standard
A PowerPivot Map that plots home addresses by gender

In the end, we decided to progress with Microsoft’s PowerBI solution, which is described on their website as:

Power BI transforms your company’s data into rich visuals for you to collect and organize so you can focus on what matters to you. Stay in the know, spot trends as they happen, and push your business further.

Some of the reasons we selected this solution include:

  • It’s browser based – you can access it from “anywhere” and see live data. You can also bookmark certain reports in your browser for near instant access.
  • There is also an app available (iPhone/iPad/Android/Windows10) so the data is accessible anytime / anywhere
  • We can tweak reports / visuals quickly and easily, based off feedback from stakeholders
  • Being browser based, you don’t need a local file on your computer that is “out of date” once a new version with improved features is built. What you see is always the “latest version”
  • It’s part of our existing Office365 Suite, so our existing username/password logs you into the reports.
  • Security permissions are centrally managed based off AD users and role based groups.
  • It connects to our on-premise MS-SQL Server, allowing for scheduled data updates (hourly / daily).

To best demonstrate the power of this tool, we built a proof of concept based around analysing NCEA student achievement, in particular University Entrance requirements and course/subject endorsement. Here is a screencast walking through the tool:

Note: identifiable data such as student names / ID numbers have been blurred out in this video.

To accelerate the development of some of this reporting, we have:

  • Partnered with DataCom New Zealand and are getting expert advice from their Business Intelligence team in terms of configuring the ETL process via Microsoft SSIS, building a tabular data model and connecting to PowerBI in the cloud for presenting the data to staff.
  • Hired a new staff member to join the ICT Services team in the role of Business Intelligence Report Writer. The responsibilities for this role will be to interface with the various business units in the College (e.g. Academic Data, Enrolments, Development, Communications etc), understand their reporting requirements and then build the reports in PowerBI.

The key with any Business Intelligence project is to help inform the decision making process and not just be contented with pretty visualisations. To that end, a robust conversation and scoping of what is required to be seen by the stakeholder needs to be established. However, with a wide range of visualisations being added regularly to PowerBI, there is a number of ways to present data in an easily comprehensible format. One of my favourites in a 3D, interactive globe that significantly improves on the PowerMap in Excel (see above):

This visualisation could be very useful in mapping where our current students or Old Collegians live or identifying where donations are coming from globally mapped either by volume or value for example.

We are in the very early stages of this project, yet the potential is very obvious to the leadership teams at St Andrew’s. The focus over the next few weeks will be configuring the backend infrastructure: the ETL processes (Extraction, Transformation, Loading), the Data Warehouse and the connectivity into PowerBI. Subsequently, the rapid development of reporting dashboards will proceed.

If this interests you, please do check back regularly on the blog for updates or drop a comment below to discuss further.

Guest Post: Collaborative Composition In Music

Posted on by
1

This guest post today comes from Mr Duncan Ferguson, Head of Department of Music here at St Andrew’s College. Previous posts have featured his work integrating technology in his practice that you can read here and here. Today’s post looks at his Project Based Learning (PBL) with his Year 10 Music Options class. You can read the original blog post here.

Over the last five weeks I’ve been trying a new way of running collaborative composition in my year 10 Option Music class.

This year I’ve been blessed to have a large class of highly motivated and talented students, so they were the perfect class to take a risk and jump into what is for me a new way of teaching composition.

The basic summary of what we did is that I divided the class into five groups.  In the first week each group had to start writing and recording a song (in a rough demo format).  In the 2nd week the groups swapped songs and continued on with what another group had started the previous week.  We did this for five weeks so that in the end, every group had been involved in the composition process on each of the five songs.

Initially the students were very nervous about this process as I’d done very little in terms of how to actually write songs.  However, that didn’t worry me as within each group of five members I knew that there were people with various strengths that when combined would make the process go smoothly.

Prior to this we had done a little work on what makes a good chord progression (mainly analysing four chord songs) and an effective melody but within the context of their own personal compositions, which they recorded/sequenced in either Garageband or Studio One Free.  It wasn’t much, but it proved to be enough to get the students on the way with the process.  What was critical to the process though (which I didn’t realise until we got a few weeks into the process) was that a strong knowledge of how to use technology and specifically MIDI keyboards/guitars with software sequencers made all the difference to the success of students being able to pass on their work to the next group (only a few students in the class had strong notation/theory skills so technology bridged the gap very effectively).

Here is a little video where I show one of the songs and how each group contributed towards it week by week:

And here some of the songs created by the students (please keep in mind that these are only supposed to be at ‘demo’ quality… we still intend to record them properly at a later date):

This whole process has been an incredibly empowering experience for the students and is a great demonstration of the high end of the SAMR model:

SAMR Diving

Software like Garageband and Studio One has enabled students to achieved a huge amount in a very short time and made it possible for this separate group collaborative thing to happen.  Students that recorded audio onto iPhones or wrote down music with traditional notation were no where near as effective in the sharing of their music with others.  By far the best way for this process to succeed was for students to compose using MIDI for the instruments and microphones/audio for the vocals… all along with a click so the music could be easily edited and rearranged by different groups.

Here are a couple of short videos watching students in action as they were creating their songs:

For other teachers who are wanting to run this sort of unit I’ve found that the following will make the process go very well:

  • Ensure that each group has at least one person who plays the following instruments: piano, guitar, drums, voice.  Often drummers don’t have a huge amount to do in the first week or two but as the weeks went by I discovered they were increasingly taking charge of the projects… running the technology (i.e. the computer DAW/sequencer)… which was critical when it came to restructuring ideas previous groups had come up with into coherent song structure of intros, verses, choruses, etc
  • Try and have a computer with a MIDI keyboard and a microphone setup in each room.  If you are using student laptops instead make sure you have a dedicated USB drive that holds the files that they work off… minimise copying of files between computers.  We ended up a losing a complete work from one room that students were working in as they mistakingly copied the wrong files then deleted the proper one.  The most successful songs were those that came out of rooms that had dedicated computers that students used each week.
  • Use the note pad facilities of your DAW (like Garageband or Logic) for writing down chord progressions, lyrics, ideas, etc  Don’t have things on scraps of paper as they may get lost.  Keeping everything with the DAW file is an elegant solution for keeping everything in the same place.
  • Don’t record piano/guitar ideas as audio… try to record them as MIDI.  This will enable successive groups to edit what was recorded.  If it’s audio, they’re stuck with it and are unable to improve upon it.

For me this process has been such an eye opener.  The students surprised themselves with what they could come up with.  The loved the process (they always arrived early from lunch so they could start as quickly as they could) and they grew so much as the weeks went by.

I will be making sure that this way of composing will be incorporated to NCEA composition at our school.  It will grow the numbers of students taking music and will help to break down the perception that you must be an orchestral musician who has been learning since you’re seven years old to be able to succeed in NCEA (even after five years at my school I’m still trying to destroy this myth!).

But overall… it was a heck of a lot of fun.  And that is what teaching and learning should be… shouldn’t it?

Online Ticketing A Great Success

Posted on by
1

PatronBaseAt St Andrew’s College there are a lot of ticketed events showcasing student talent and performances, from the annual Preparatory Ballet Show through to the Senior Production. On top of these, there are fundraisers, guest speakers and the upcoming Centenary celebrations in 2017, all of which require ticket design, printing and selling.

Historically, these tickets were designed in-house by our Communications team, bulk printed and then sold via the reception desk in the Secondary School. Whilst this worked, it tended to be inflexible if people wanted to change the night they were attending and it was also time consuming for reception staff showing students and parents what seats were still available and then processing the purchase of tickets.

In 2014 the College re-examined online ticket sales as an option and partnered with PatronBase, a Christchurch based company with customers throughout Australasia, the United Kingdom and Spain. We had some clear goals in mind to improve our sales of tickets to events, including:

  • The ability for students, parents and wider community members to see what events were happening at St Andrew’s, choose their preferred seats (where allocated seating was being used) and to purchase tickets online.
  • The ability to pay for tickets online using Visa or MasterCard.
  • Customers to be able to print their tickets at home and for reception staff to be able to print tickets on a “as needed” basis.
  • Event organisers to be able to see very accurately how many tickets were sold/remaining
  • Accurate reporting at the conclusion of an event for reconciliation of payments and disbursement of funds.

The team at PatronBase worked hard to help create a custom skin that accurately matched our College branding and also supported the technical requirements for connecting with BNZ’s BuyLine product for processing online credit card payments.

The PatronBase hosted solution for online ticketing accurately reflects the St Andrew's College branding.

The PatronBase hosted solution for online ticketing accurately reflects the St Andrew’s College branding.

guys and dollsA decision was made to trial the PatronBase system with the 2014 Senior Production of Guys and Dolls with tickets being available for sale online for the first time ever, as well as via the “Box Office” in the College reception. The ability to sell tickets both online and via the reception was a real advantage over the previous ticket system used and reception staff were confident that tickets were never going to be accidentally sold twice.

Furthermore, because tickets could be re-printed as needed, it did not matter if a customer changed their mind about the night they wished to attend a performance, because the tickets could easily be transferred with new tickets being printed and the original seats being released for other customers to purchase.

Ticket view for Reception staff showing booked and available tickets.
The corresponding online view for customers purchasing tickets at home.

The “Box Office” view on the left used by Reception staff to see status of available seats and the corresponding web view to parents at home allowing them to choose their preferred seats.

As can be seen from the above images, the seating layout from the College Theatre could be recreated in PatronBase allowing allocated seating to be selected by students and parents. However, after the initial success of online sales for Guys and Dolls other events in different venues were also sold via the new ticketing system, including:

Parent response to the new system has been incredibly positive, such as this unsolicited feedback we received:

The new ticketing system is really great. It is great to be able to purchase with a credit card and to have a choice of whether to print or collect tickets.

When booking shows in the theatrette it was fantastic to be able to choose your own seats and it was very easy to use. It really was great to be able to see exactly where you would be sitting.

Keeping the self print tickets simple is good. I have had to print out tickets from other places before and they have wasted so much ink printing fancy pictures. 

Your ticketing system is excellent.

A selection of shows through PatronBase with the online sales clearly proving popular

A selection of shows through PatronBase with the online sales clearly proving popular

The ease and convenience of purchasing tickets online is evident from the table on the right, and this encouraged the College to explore other possibilities with PatronBase such as sales of the fundraising recipe book “Recipes From The Tartan Kitchen“. This book, sold to raise funds for the new College Chapel, was launched in late 2014 with the accompanying promotional video:

Since then, 150 copies of the book have been sold through the PatronBase system, often by Old Collegians overseas who wish to have the book couriered directly to them.

A more recent form of fundraising online came after the devastating Cyclone Pam struck Vanuatu. A full blog was written about this that you can read here, and at the time of writing donations during the sale of tickets to UrineTown and Style at StAC are approaching $1000 for Onesua Presbyterian College in north-east Efate,Vanuatu.

Finally, the Old Collegians Association of St Andrew’s College, having seen the value of online ticket sales, will soon be using PatronBase as well for all their ticketed events and reunions. A custom theme is being developed to match the branding of the Old Collegians and then tickets will be available for all events.

With an eye to the future, having run over 15 ticketed events through PatronBase over the last 12 months, the system will definitely be used for managing ticket sales for the 2017 St Andrew’s College Centenary. It is pleasing to be able to deliver an improved service to students and parents that makes the purchase and attendance of ticketed events at the College so much simpler and easier.

Narrating Teaching Moments with Office Mix

Posted on by
4

office mixEvery Thursday lunchtime throughout Term 4 I have been running lunchtime professional development for our teaching staff. I’ve been pleased with the uptake from the teachers, who can book a place in the lunchtime sessions via Moodle using the Booking module we have installed.

Each session focuses on one of the following topics:

  • The new OneNote Class Notebook Creator tool which many teachers have wanted to learn more about.
  • Using Office Mix to record lessons or explanations on critical concepts for students.
  • Using Moodle Forums to assist students with revision for examinations.

In this blog I am going to cover a neat feature of Office Mix – the ability to upload a Mix to Microsoft’s platform, and how permissions can be managed to control the visibility of the content. I have blogged about using Office Mix as a digital whiteboard already and how the ability to narrate ideas and concepts is helping some of our teachers flip the classroom, like Mr Kevin Barron.

The Office Mix add-in for PowerPoint is a new way to tell your story with voice, video, inking, screen recording and interactive magic.

It’s important to distinguish the two types of recording available in Office Mix:

  1. Record: This feature will load up whatever Powerpoint presentation you have open, and allow you to narrate and annotate via “inking” each slide as you progress through the deck.
  2. Screen Recording: when this is selected Mix will return the user to whatever application they were last in before going to PowerPoint and allow you to start recording everything on your screen even if you change between applications.

MixThere are some excellent screen recording software options on the Apple platform and I have used Screenflow for recording many tutorials for staff ever since I saw a Year 13 student record a narration of his musical composition using Screenflow:

However, there have been limited options in the Windows environment, and certainly no great ones for free. Office Mix does change this by allowing staff and students to easily record and share screencasts. The icing on the cake is the built in ability to upload directly to the web for sharing of the recorded Mix, without the need to publish to a third party video platform such as YouTube or Vimeo.

Whilst both Mr Matt Nicoll and Mr Kevin Barron are both comfortable creating playlists in their YouTube channels, for other teachers the ability to publish directly from Office Mix holds big appeal. The following video provides a great overview of how to upload and share a Mix:

As the video points out, Mix offers four levels of sharing to help teachers and students decide what the best level of visibility is:

  1. Organisation: Essentially, only teachers or students at the school would be able to view the Mix
  2. Limited: Users might be outside of the school, but would still need to sign in using a Microsoft account to be able to view the Mix
  3. Unlisted: Anyone with the direct link could view the Mix, but it was not searchable on the internet
  4. Public: Anyone can search and view the Mix.

The only downside with the above is that if you want to embed your Mix into your Moodle class site then the sharing settings must be set to either Unlisted or Public.

After the most recent Thursday training session, our Assistant Head of English Ms Tam Yuill Proctor was keen to give it a go and created her very first Mix to help her Year 11 English class with the basics of writing an essay. She blogged about the experience here and you can watch the mix below:

Tam Mix

In this Mix, she recorded it on a Surface Pro 3 as part of the trial group we have going at St Andrew’s College and used the inking features to highlight different points as she went through them. The initial feedback from her students is that it was really helpful to have this visual and aural guidance especially from their own teacher and not just a random clip off YouTube.

SUMMARY:

It is really pleasing to see our teachers attending professional development sessions and then giving it a go and implementing new technologies that will benefit the learning outcomes for our students. As most teachers will confirm, it’s not always easy to record and publish your teaching moments for others to replay again and again and yet it is precisely this type of resource that can help cement student understanding of complex ideas.

I am encouraging our teachers to embed their Mix recordings into their Moodle class sites as well, since this will allow them to use the reporting tools within Moodle to see precisely which students have actually watched the clip, and how many times.

Whilst having the ability to write on the screen during the Mix recording through using a Surface Pro 3 is a nice feature, there is plenty of applications for this in other areas with a traditional laptop as well, such as:

  • Recording how to create a spreadsheet or graph in Commerce classes
  • Recording tips and tricks in subject specific applications such as Photoshop or Sibellius
  • Recording how to write up a bibliography in History
  • Recording how to change certain network settings in Windows 7 or 8 to improve wireless performance.
  • And the list goes on!
  • UPDATE: Darrell Webster, an Office365 & Microsoft MVP, suggested some other useful ideas for recorded Office Mix by teachers: to record an overview of the course or promote an upcoming assessment or project. Excellent idea! Darrell has also recorded a good introductory overview to Office Mix that you can see here. 

I am excited to see which directions our teachers will take this functionality in 2015 and I know that many of them will also encourage their students to use it as well. With changes to English standards, students no longer need to stand in front of their peers to deliver a speech – they could record a presentation like this using Office Mix for assessment instead.

Finally, as useful a tool as Office Mix is, it is clearly no substitute for the teacher. If anything, it reaffirms the central role the teacher plays in guiding students and assisting with the clear explanation of complex ideas. Many eLearning tools allow students to listen and watch again a key learning moment from the teacher and in the end, this must help with knowledge building.

Suspect: The Murder Mystery Musical

Posted on by
8

banner

Mr Duncan Ferguson, Isaac Shatford and Ms Ginny Thorner.

Mr Duncan Ferguson, Isaac Shatford and Ms Ginny Thorner.

UPDATE: This story profiled on TVNZ’s Seven Sharp on Friday 24th October and can be seen here.

The buzz around St Andrew’s College lately has all been focused on the annual Middle School Production, largely for the fact it has been mostly written by Year 13 student Isaac Shatford, with contributions from a number of other senior students in the area of lyrics and plot. I knew something like this would always involve significant use of technology as the Musical Director was Head of Music Mr Duncan Ferguson, and was actually the first person I interviewed for a story for this blog.

Consequently, I sat down for an hour with him to learn what was involved and was impressed to learn that the following tools were just some that were used during the composition and performance of Suspect:

Quite a list! So how exactly were these being used?

Selection of Scenes from Suspect for Seven Sharp

COMPOSITION & REHEARSAL: 

Noton on iPad

Notion on the iPad

For starters, one of the challenges was that the orchestra members and cast needed to start rehearsing before the score was actually completed and with extensive collaboration ongoing between Isaac, Mr Ferguson and Ms Thorner there needed to be some way for them to see updates.

The answer was to use a combination of a shared folder in Dropbox, which was storing the score files being written in Notion. This allowed the three contributors to always be able to see the latest edits of the score at any time and also contribute edits and corrections that the others would receive immediately. The use of Notion also allowed Mr Ferguson to check the tempos and help the students ensure they were keeping accurate time with their playing. He did note, however, that the one drawback with Notion is that it doesn’t automatically update when the source files change. This was overcome by the notifications from Dropbox which would alert each of those working on the score that new changes were available.

As the product was used on both MacBook laptops and on an iPad, Mr Ferguson could use the iPad to play the score directly during rehearsals. He also used a Bluetooth foot pedal which would automatically “change pages” of the score on his iPad when playing, and if there were any changes required during rehearsals he could make them directly on the iPad, with the changes being synchronised back to Isaac in real time. This process created a great digital workflow for the writers and I asked Mr Ferguson to walk through how this looks:

“Loves a Lie” a song not completed in time for the show but will be included in the professional soundtrack recording in November.

There were a number of benefits of using Notion which included:

  • It resulted in far less printing of scores, as the digital sharing via Dropbox enabled real time collaboration to take place. In the future, it would be ideal if all orchestra members had iPads so they could also get updated copies of the latest scores in real time.
  • Because of Mr Ferguson’s other departmental commitments he could not attend every rehearsal of Suspect, but because of the excellent quality sound recordings created by Notion then the other staff involved in running rehearsals could work with the correct tempo music (particularly important for the dance choreography).

Tempo Advance AppNotion does focus on orchestral sounds and was not so strong in drums and bass, so Pro Tools was used to round out the music in this way. During orchestral rehearsals Mr Ferguson used an iPad app called Tempo Advance which allowed him to program the tempos for all the songs into a playlist and just work through them directly.

Technology has definitely allowed for the streamlining of the writing process of this show, resulting in a remarkable nine month period between the conception of the idea and the production of the show. As mentioned above, rehearsals had to start before the script was completed and to aid the students in practicing, video clips of the songs and music were embedded into a dedicated Moodle course to increase access e.g.

Moodle MusicSongs and lyrics were also distributed via Moodle in this way – with a nice mention about respecting copyright ownership of Isaac Shatford (Digital Citizenship should be taught in all classes after all!)

Moodle was later supplemented with a closed Facebook group for cast members, allowing for even further reach for sharing and practicing. Here is an example of the theme song recorded by senior students for the Middle School cast members to practice with:

[audio https://dl.dropboxusercontent.com/u/58349924/Blog%20Data/1%20Murder%20in%20the%20night.mp3 ]

Murder In the Night – practice recording

This reveals one of the benefits of doing a show like this that was written by a student at the College: the ability to work directly with the score, modify and share it with cast and orchestra members directly. This is simply not possible with major productions that are licensed for performance (such as the Senior Production Guys and Dolls performed earlier this year).

I questioned Mr Ferguson how common this sort of “digital workflow” is amongst other schools and he believes it is essentially unique within New Zealand, describing it as the perfect model for other schools to consider implementing. He did admit, however, that working with Isaac made it easier:

Isaac is a musical prodigy, a stunning musician and I’ve never know another student who was able to produce this amount of work to this quality ever before. He’s written great songs, but it is the sheer amount of songs he has written that is just unheard of. There has been nothing to this level that has ever happened before to the best of my knowledge.

PERFORMANCE ON THE NIGHT:

Set design for the stage show Suspect

Set design for the stage show Suspect

Due to the complex set design, members of the orchestra could not all see the stage (see image to the left). To help get around this, Year 13 student Ella Harris came up with a simple, yet ingenious, workaround as explained by Mr Ferguson:

I had the iPad Mini beside my keyboard near the orchestra, and I placed an iPhone at the back of the auditorium that could easily see the entire stage. Before the performance started I simply started a Skype video call between the two devices, meaning I could see everything happening on stage at any time.

It is this type of thinking, use of technology and problem solving, that typifies what happens in the music department at St Andrew’s College. It was also during live performances that Mr Ferguson used MainStage 3 with a Midi keyboard plugged into his MacBook Pro to play the glockenspiel during performances.

During the first performance of Suspect Head of Culture Sophie Wells and Mr Dave Jensen from the TV & Media Studio, were tasked with using HD video cameras to film the show with some close up shots. Whilst the final performance was going to be filmed by the College’s TV & Film crew, it would be shot only from the back of the auditorium making close up shots challenging. With the performance captured, Mr Ferguson used Final Cut Pro to edit the two camera feeds into a rough mix of the entire show and then shared it with the cast members via the closed Facebook group.

This allowed them to reflect on their performances and actually see and hear in detail what guidance they were receiving from Ms Thorner and Mr Ferguson about their performances and to truly “get” the message.

[audio https://dl.dropboxusercontent.com/u/58349924/Blog%20Data/More%20than%20just%20a%20friend.mp3 ]

More Than Just A Friend – practice recording

 SUMMARY:

It’s pretty clear from this blog post that significant amounts of technology are deeply embedded into the practices within the Music Department at St Andrew’s College, and that they serve to enhance the creation and production of top quality music.

It’s worth reiterating that when talking to Mr Ferguson it was very clear that the use of this technology was always targeted around efficiency gains in collaboration and never simply because “they could.” Ultimately, this is how technology can assist learning outcomes – when used authentically and deeply integrated into the learning it is a fantastic tool, and in this case one that made the production of a show possible within only nine short months.