Editing an audio or video file is easier than you might think...

Trim audio

Not a lot of people know this but if you need to trim a video or an audio file, like an MP4 (video) or an MP3 (audio), it's easier than you think. Just open the file in Quicktime Player, and use the editing features to trim the track.

Audio trimming in Quicktime

Edited audio can be saved it to iTunes as AAC (Apple's version of an MP3) using the Export option, if you really need it to be an MP3, iTunes can convert audio files to MP3 if you need it to.

Now you can do more complex editing, but not as an audio file, so one way round this is to record the audio as a video, then edit as described below, then at the end discard the video and export as audio only. The same works in iMovie.

Edit video

If you're not bothered about transitions, and picture in picture, then the editing option in Quicktime are all you need. You can trim the video just as you a would audio, (which incidentally is exactly the same on any iOS device, same conventions). But where it really rocketh is in it's accuracy with splitting and deleting bits of video, or moving them around.

Just choose View > Show Clips to reveal a simple editing timeline at the bottom, click to select it (it will have a yellow outline) then move to the section of the video you want to split, you can even nudge the split point frame by frame using the arrow keys.

Once you've found the split point just choose Edit > Split Clip (or command Y) and you will see the video split into two (or more, if you split more than once) lozenges. Those bits can be deleted, or even moved about, simple.

You can even view the audio waveform to make editing easier, see where the quiet parts are...

Combine multiple clips

Just drag a video onto a video you have open and see the magic unfold before your very eyes! Now you can trim, move, split and of the clips. 

When you're finished Export and choose the kind of video you want.

Convert video/audio file formats

For a final phenomenal feature, got video that is to big? No problem just right/secondary click, choose Encode Selected Video Files. The in the dialog window that pops up choose a size, 480p will create a smaller, web friendly version of your video.*

* You can make video files smaller, but you cannot make them bigger! 

Search Smarter

If you ever hear 'boolean operators' mentioned in a sentence, you could be forgiven for giving this whole rigamarole an eye roll and moving on—which I must confess I used to do, but DON'T, if you ignore these fabulous little functions you are missing out; you don't need to use all or even most of them, but you won't go wrong with these...

Just remember when using an operator, this is not an essay, so NO SPACE after the colon or it won't work! 

Six Scintillating Search Strings

So yes, most 'boolean operators' are extremely geeky and only really relevant to highly specialised search gurus, but there are a handful that are useful to anyone, yes that includes you, if you can use Google you can use these; they are:

define: 

Get a dictionary definition not just a webpage with the word in 

“search term here” 

Use quotes to search for a specific term or phrase with exactly those words in exactly that order eg “halt and catch fire“

site: 

eg site:ie to just return websites that are based in Ireland, especially useful for research where you want the perspective of people of a certain nation not just the most popular websites on the Internet. 

intitle: 

eg intitle:gaming will only give you websites where gaming is in the title of the page not just a possibly fleeting reference within an article that is primarily about something else completely different. 

NOT or - to exclude a particular term that keeps messing up your search results, eg maybe you’re searching for Koala, but you keep on getting websites that include the phrase “koala bear“ which you know means that they can’t be particularly authoritative, then you just add the search term -bear now any of the results that included the term “bear” will be excluded, refining your search down to a much better selection of sites. 

Search for transparent images for your Google Slides 

Search for images with other images… 

Mix & Match! 

And of course don’t forget your combos, any/all of the above can be combined to extremely powerful effect, eg

intitle:”halt and catch fire” site:ie  

This will return websites that are based in Ireland that are all almost certainly about the TV show ‘halt and catch fire’ ... 

Internet Filtering & Parental Controls

I am regularly contacted by parents for advice about software they can install on the devices their children use at home that will enable them to filter out or block inappropriate content, usually based on the assumption that we must use some sort of monitoring software on campus. Often these parents are surprised to discover that while we do have filters to block the most egregious of content, it is fair to say that our college filters are not as strict as many might expect. We do use a commercial filter on our internet traffic to block inappropriate sites, however, such filters work on the basis of keywords and blacklists and neither of these methods are foolproof. So why do we take the risk?

Our college policy regarding parental controls goes a long way to explaining this:

In general the College has an ethos of developing personal responsibility in students and ultimately we believe that it is essential for students to develop the skills and attitudes necessary to survive and then thrive in a digitally connected world.

The sentiment behind this policy statement is very similar to the description of 'e-safety' as defined by Becta:

The term e-safety covers a broad range of issues around the need to ensure that children's and young people's experience and engagement with technologies is a safe and positive one. While parents, educators, government and industry all have a role to play in keeping children and young people safe, supporting them to become independent in online environments is critical to nationwide, effective e-safety. ‘Independence' does not mean here that they are expected to deal with every incident themselves: it means that they develop social skills (including resilience); that they know how to identify and manage risk; that they understand their rights and responsibilities and know how to access help and advice if needed. (Becta's Contribution to the Rose Review, 2009)

When we teach our kids how to use the internet, we do so from a position of preparing them for the 'real world' of internet access that most will encounter at home. While there are a minority of families who use some form of filtering software, the reality is that few families have internet filters of any kind on their home connections. This is not a criticism, I have not installed any filtering software at home either. This situation reflects the norm in my experience, a norm that we need to be teaching our students to operate effectively and responsibly within.  For example, you cannot guarantee that even walking down Orchard Road you are not going to see images or overhear a conversation that you feel is inappropriate for your children. So in addition to the filters, arguably, more important than filters is the need to teach our children the skills they need to navigate the internet safely, and how to react appropriately if, or should I say, when something occurs.

This policy very much underpins our approach and throughout the Primary School, where, even from K2 (in K1 teachers use Guided Access), all students are effectively 'administrators' of their devices. This applies all the way through the iPad grades (K1-G3), and then on through from Grade 4-5. All students receive their own laptop in G6, where we leave the decision about admin controls up to parents, although we encourage parents to make their child admin if at all possible—or at least to try it. From G7—all the way through to grade 12 we expect all students to have admin rights on their laptop. This means that for most of their school years our students are already accustomed to using and managing their laptops as an 'administrator' whether or not they were even aware of this, which is possible, as we treat this as a 'normal' operating environment. This is an arrangement we encourage all parents to maintain, unless of course a situation arises where you feel that you need to withdraw the privilege of an admin account, in this (hopefully rare) situation, we encourage parents to ensure that this is a temporary arrangement.

"Nearly half of 10 year olds say they have the skills to hide what they're doing online from their parents." (Sky News, Swipe, 2017)

It's worth noting as a practical point, that the process of imposing parental controls is not a simple one, this is mainly because the process of setting the 'tightness' and 'looseness' of controls is a tricky balance to find. If your main concern is distraction rather than access to inappropriate content, there are a range of strategies we encourage at school that you can also model at home, and encourage your children to practise as well. The other critical consideration is that if you are not very careful, you could end up effectively creating an unhelpful dynamic where you effectively teach your child that they are not trusted, at which point you may well be encouraging them to find ways to subvert your attempts at policing their online activity, then when they do encounter problems they are unlikely to come to you for help as they will have to confess their nefarious scheme... For more see this short video on the 'the secret cyber life of young people'...

Road Safe, Web Safe

This is where the analogy of road safety that we use with students comes in. Roads in every country are commonplace, and at some point everyone of our children will need to learn how to navigate them safely and independently. The same can be said of the 'wild wild web'; like roads they are a modern and essential reality, and while they can be dangerous, they shouldn't be treated is if they are inherently dangerous places—although they can be very dangerous places. The solution to both is very similar: education and supervision. Like roads, we expect kids to be able to navigate the web from an early age, but never alone; although any wise parent should be modelling for their kids how they navigate the web, when they are using it together. Just like road safety, there are some basic rules we expect all young children to follow, to make these effective we've kept them simple:

1. Only search the internet with a responsible adult present.
2. If you see something that makes you uncomfortable, show the responsible adult.
3. If you need to search online unsupervised, use a search engine designed for kids like Kiddle or Safe Search Kids.

About point 3, we liken these 'child safe' search engines to playgrounds, spaces that are designed especially for children, this doesn't make them harmless, after all, kids in playgrounds can still get hurt, but it does make the likelihood of this less likely. In the same way we liken searching using Google as tantamount to walking down Orchard Road, not an inherently dangerous space per se, especially in Singapore; but clearly the possibility of encountering something or someone inappropriate is more likely. As children we did not grow up with the dangers of the internet, but we did grow up with dangers, and our parents, in my experience were quite comfortable with allowing us some controlled exposure to risk situations, precisely so we could learn from them. I fell out of several trees, and off several bicycles during my childhood, not to mention the stairs I fell down. Stairs, now those are really dangerous, but I doubt anyone is seriously considering preventing children from using those... So we're not looking to create a zero risk environment for our students, but a managed risk environment, this distinction is essential. This last point is one I've written about before, but a recent article from the Washington Post, entitled, 'Why I don't monitor my kids' texts anymore' does an excellent job of articulating this tension, along with some practical parenting advice.

"As a young and socially inexperienced person, I was sometimes mean, sometimes gross, and sometimes way out of line. Every kid tests his or her own boundaries. That’s how they start to grow up. The queasiness in my stomach or the ache in my heart when I crossed that line is what helped me learn from those mistakes. 

When we hover over our kids’ social interactions, on high alert to catch each mistake and steer them back on course, we squelch their internal barometer for embarrassment and guilt. Had my mom listened to all my conversations and called my behavior out into the light, I might not have learned to read my moral compass."

This does beg the question, "at what age is it okay for my child to browse the internet unsupervised?', and the answer is very similar to "at what age is it okay for my child to cross the road unsupervised?", which is, when you have taught them how to navigate it safely, and what to do if things go wrong. In my experience this is unlikely to be until grade 4 or 5, which is, incidentally, when students are allowed to make their own way home (with parental permission, of course).

Not all families or children are the same, and the home environment is not one that is necessarily conducive to ensuring that young children are never able to go online unsupervised. Given that our policy is to teach responsibility, we'd like to think that even if unsupervised, our students would still make the 'right choice' and either stay offline (working within an app for example) or use one of the child safe search engines that they are encouraged to use in school.  However there are clearly scenarios where this is not a realistic option, in which case you may want to consider some digital tools that can assist with this, but bear in mind these are unlikely to be free if they're any good, for example a one year family subscription to Azoomee costs £40, " No ads, no in-app purchases. And a PIN lock to keep kids inside the app and take away the worries."

As of iOS 12, all iOS devices (iPhone, iPad) now have built in options for parents to monitor/restrict screen time.

When you open Screen Time for the first time, you can specify if you are a parent setting up an account for a child. Then you set a parent passcode that will be required to alter the Screen Time settings. From your device, you can also select “Set Up Screen Time for Family” to set up Screen Time with Family Sharing. You’ll be able to access your child’s Screen Time reports and set controls from your own device. When a child reaches the end of a time limit on the app, they can request more time; the request pops up as a notification on the parent’s device. 

Finally, Screen Time allows parents to set restrictions on downloads, privacy, and other settings. By default, Apple won't set these restrictions, even if it knows it's a kid's phone. Parents will have to manually make these adjustments in Screen Time > Content & Privacy Restrictions. (Wired Magazine) 

This article contains some very practical advice, over and above the 'unplug the router' (one I have to say I like; simple but effective!) strategy, along with some wise caveats,

"While we can certainly recommend a bunch of apps and devices for you, this is more about your approach than the tools you’re going to use. Kids generally don’t like being spied on and dislike being spied on without their knowledge even more. While a number of monitoring tools can run without children knowing about them, we strongly recommend being transparent with your kids about when and how you’re tracking them. 

You know your kids better than we do, and we can’t prescribe the right approach for every type of child, but whatever your situation it pays to be open and honest about the dangers out there on the web and in the real world."  (David Nield)

To Skill or not to Skill?

Teaching ICT skills ...

Pickering (2007), found that a focus on skills and fixed knowledge to be acquired was criticised by the teachers in his study, although Daly et al (2009), citing his findings, conceded that:

“Clearly, ICT use demands that teachers acquire certain generic skills (p 27).” 

Understandably, there is a general hesitancy* by tech integrators to embrace ICT skills teaching, as it tends towards,

“superficial, one-off and ‘box-ticking’ approaches which emphasise the development of functional skills and relegate pedagogical development to teachers’ ‘spare’ time (Daly et al, 2009, p 41).” 

Now, somewhat ironically, the situation seems to be becoming reversed – with the emphasis very much upon the development of pedagogical skills and the relegation of ‘functional development’ (skills) to teachers’ ‘spare’ time.

So teachers are now effectively expected to acquire skills,

“by studying manuals, talking to each other, talking to the instructor, and seeking out other locally available experts” (Mishra & Koehler, 2006, p 1038). 

The problem is this ‘grappling experience’ (ibid) or ‘productive failure’ (Kapur & Bielaczyc, 2012), while a powerful way to learn, if not managed carefully, can become a tedious, frustrating process. "Good pedagogy should challenge not frustrate" (ibid) but it is difficult to judge when it is better to let people ‘wrestle’ or to mitigate the potential tediousness of a long process of discovery, by providing a ‘short cut’. The challenge of managing this ‘zone of proximal development’ (Vygotsky, 1987) is significant, the distance between the actual developmental level as determined by their need to engage in independent problem solving (trouble shooting) and the point at which they know they cannot proceed any further without ‘expert’ guidance, or collaboration with more capable peers, a 'knowledgeable other' (ibid) – or even, or perhaps more likely, students.

Frustration is common with digital technologies,

“any given technology is not necessarily appropriate” (Mishra & Koehler, 2006, p 1040). 

The plethora of software available to do even the most basic of tasks, means that even choosing an inappropriate tool can turn a task from a challenge to a crisis, like attempting to using Photoshop for image cropping, which is tantamount to using a Ferrari to deliver milk. What is likely to occur, is a situation where,

“teachers were so caught up in learning how to use the tools that they lost sight of the design tasks.” (Angeli and Valanides 2008, p 10). 

The “cognitive load” (ibid, p 9) imposed by learning how to use the tools was so high, that teachers were left without enough “cognitive resources” to attend to the actual exercise.

Although skills training is clearly vital to being able to integrate technology into teachers’ practice, more often than not teachers are plagued by an unconscious incompetence - they ‘do not know, what they do not know’.  Despite the proliferation of literature expounding the virtues of an integrated model, mention is rarely made of any consideration of a prerequisite skill set, one of these rare examples follows:

“The model assumes the existence of ICT standards [...] At a basic level these would include: basic ICT literacy, such as familiarity with and confidence in using the Windows operating system, basic word processing, PowerPoint and data software such as Excel and SPSS, software installation, and knowledge of the Internet such as how to use the Internet for resource searching, downloading and uploading files, communication via emails, video calls or web cameras.” (Hu & McGrath, 2011, p 54)

Balance is clearly critical here – one where an articulated skill set is defined that can be acquired within an authentic, integrated context. How much teachers know about technology makes a big difference in their uses of technology. Once technology is truly integrated, teachers and beliefs and knowledge are changed as well (Fisher et al, 1996). New pedagogical knowledge and practices emerge from the integration of technology, but only when teachers reach a certain level of technological understanding.

Unfortunately with the pendulum swinging well and truly away from a skills focus, we are in danger of throwing out the proverbial baby with bathwater, an issue alluded to in the recent Nesta report,

“…the lack of emphasis upon [ICT] skills, is a concern (2012, p 55).” 

When considering what teachers should know about technology, we must consider how much they need to know to even be able to begin.

Skills mapping and audits

"A potential barrier to ICT CPD is staff not knowing what the gaps are in their own ICT knowledge. Many schools have found an ICT audit mapped to the curriculum a valuable tool in helping staff to gain a clear indication of the ICT skills, competencies and pedagogies they need to have." (Becta, 2009, Point 81)

In order to avoid the skills element having a negative impact on learning, at the end of a unit of study, or even the end of the academic year, the teachers ‘traffic light’ the ICT core skills matrix to identify which skills have, or have not, been acquired, in order to determine which skills may have need to be focused on explicitly in other authentic contexts in the future.

Example of a skills audit - post reflection

This is not a question of skills vs pedagogic integration. Teachers and students need to acquire ICT skills before they can start to harness technological expertise for the purposes of student learning. This re-purposing of the TPACK  (Mishra & Koehler, 2006) framework, ensures that the focus remains pedagogically centred, but balanced and facilitated by clearly articulated ICT core skills.


The continued reluctance to engage with this issue should be resisted, as Becta's contribution to the Rose Review (2009) emphasised,"[ICT skills] should be regarded as an essential skills for learning and life, alongside literacy and numeracy." (Point 91) With warnings regarding the possibilities of neglecting this vital area:

“… there are two significant dangers: the first is that young people will develop an incomplete and unreflective capability, unsupported by adult guidance, with risks both to their learning progress and their safety. The second is that a digital underclass, lacking opportunities for wide-ranging use of technology, will be permanently excluded from a world mediated by ICT." (Point 94)

NETS - are not enough.

While useful as overarching standards,  I do not believe NET Standards are enough on their own - they are too generic to be of practical use in ensuring a broad and balanced curriculum; they are descriptions of (any) curriculum, not applications of digital technologies. Remove the token references to ‘digital’ and ‘technology’ and you're left with a description of curriculum, but nothing which in and of itself actually requires the use of ICTs, or more importantly, that could not be achieved without the use of digital technologies at all. For example,

“Students leverage technology to take an active role in choosing, achieving and demonstrating competency in their learning goals...” 

(NETS(S) 2016, strikethrough mine).

To use the analogy of literary genres/strands (which I find helpful, but you could use science and mathematics strands just as easily) they need to be specific to the nature of the sphere of experience. Literacy genres are, NETS are not.

They need to be specific not generic. Yes you can argue that English literature is a 'subject' and ICT no longer is; this is just semantics. Who cares what we are defining them as now, we all know that just a few years ago 'IT' was a discrete subject, and it still is based on the definition of 'subject' it's just not 'discrete' anymore…

subject: a branch of (technological) knowledge studied or taught in a school, college, or university.

discrete: individually separate and distinct.

ICT is a 'subject' that is now integrated - and should be subject (see what I did there?) to the same rigorous checks and balances of any other 'subject'. The same argument can easily be made for English language, or Science, or Mathematics - these are core competencies that are applicable and a prerequisite for success in any domain in the 21st century. So call them what you like and distribute them how you will - but a broad and balanced education requires that the essential elements of these subjects are not neglected.

Vitamin D (VITAD)

Five Essential Domains: VITAD: video, image, text, audio, data - 'Vitamin D' 

Just like all subject domains, tech has its own overarching domains or strands that are an efficient way to organise the essential skill sets needed for true digital literacy.  We should not neglect opportunities to read and write, for example, realistic fiction, or physics or shape and space in Mathematics, I believe the same applies to what could be called the 'digital domains' or literacies of ICTs, such as, text, image, video, audio and data (with coding/control waiting in the wings) - none of which the NETS explicitly describe or mandate, thereby rendering them useless as a means to articulate the effective use of digital technologies.

Digital Illiteracy... 

An easy easy way to recall these essential areas is with the acronym 'VITAD', 'vitamin digital', now when you're considering whether not you can consider yourself, your students or any 21st century citizen to be truly digitally literate, how do they measure up to VITAD?

1. Can they view, edit, create, compose with video?
2. Can they organise, edit, resize, manipulate, incorporate image?
3. Can they browse/read/search text? Are they proficient at word processing, commenting, curating  texts?
4. Can the manage audio files, organise, edit, create, compose audio using multiple audio tracks/sound effects?
5. Do they know their way around a spreadsheet? Can they organise data efficiently, perform basic calculations, use functions and formulae, analyse, synthesise, and model data?

When, and only when you can confidently answer a confident yes to all the above, then, and only then can you call yourself digitally literate!

To put it another way - we're talking about students becoming holistically literate, that literacy has to incorporate 'multiliteracies' including language, scientific/methodological ways of thinking, mathematical literacy and of course digital literacy. ALL of these can be defined as 'subjects', all of these could also be (and arguably should/could be) taught in an integrated way. Just because we've chosen to integrate a subject, does not mean it should be treated less rigorously - integration should not mean invisibility - at least not for teachers. (I'd argue invisibility would be great from a student's perspective, but so would it be for maths and science et al - they don't see it as a 'subject' it's just another natural (for them) way of thinking and working)

What gets monitored gets done

An article published in the ASCD makes this point quite powerfully,

What do we monitor?

In most organisations, what gets monitored gets done. When a school devotes considerable time and effort to the continual assessment of a particular condition or outcome, it notifies all members that the condition or outcome is considered important. Conversely, inattention to monitoring a particular factor in a school indicates that it is less than essential, regardless of how often its importance is verbalised.

"In Sweden, young adults ages 16–24 topped the charts in an assessment of technology skills that was administered in 19 countries. Participants were asked to perform tasks at three levels of difficulty: to sort e-mails into folders, organize data into a spreadsheet, and manage reservations for a virtual meeting room. Fewer than one-third of U.S. young adults could complete tasks more complicated than sorting e-mails, a performance that put them at the bottom of the list of performers from the 19 countries. The study underscored the need for equality of access to technology because major discrepancies were noted among the results for young adults from varying socioeconomic backgrounds.”

(March 2014 | Volume 71 | Number 6, Using Assessments Thoughtfully [paywall], p8-9, ASCD)

The use is not equity or access, it is ignorance.  With the current neglect of skills teaching in schools, despite the proliferation of screens, less and less people are actually taught skills with any rigour or balance, a generation of students could find themselves proficient with Social media, web browsing, poster making and maybe image manipulation, and that will be it!

We have these mandatory strands in each of most (of not all) subject literacies that are carefully monitored because we expect all students to have multiple experiences with these domains during their time in school, ideally in each grade, scoped and sequenced properly. I can't see how a student could be considered to be mathematically literate if, say, they had never been taught how to multiply, or in science, never experimented with forces, or in literacy, never read or written poetry, or in terms of digital literacy, never learned how to edit or use video. None of the strands in these subjects are left to chance, or to ad hoc integration. We carefully design authentic ways to ensure they are all experienced, all I'm arguing for is that we do not allow exceptions, especially not for one of the core competencies of the 21st century.

Put simply, if we believe that articulating a coherent scope and sequence of essential skills in the domains of language and mathematics are necessary, then how much more so in what is arguably THE prerequisite skill set of the 21st Century? 

For a Google Doc version of our Primary School ICT skills scope and sequence matrix that you can copy, click here, but please include acknowledgement of UWCSEA as the original owner if you do :)

An example of a section of our skills matrix

Here are some other great examples of ICT skills matrices that run K-12:

Common Core State Standards K‐12 Technology Skills Scope and Sequence

TASIS Technology Skills Scope & Sequence



*Another reason for a 'general hesitancy' is the acceptance of the myth that technology skills are changing to quickly to bother with, fueled in large part by fundamentally flawed quotes like this:

...the rapid rate of technological change ensures any knowledge gained about specific technologies or software programs would quite quickly become out of date. (Mishra et al, 2009, p 151). 

The subject of the myth of change in the domain of digital technology skills, see my other post, Keeping Pace with Technological Change - Futile, or Fundamental?

[Originally posted in 2013, updated in 2018. Changes to the matrix in the interim? Very few, which just goes to show, skills don't change that much or that quickly, people do.]

Spreadsheets Made Simple on an iPad

As part of our commitment to ensuring a broad and balanced range of ICT skills that facilitate true digital literacy, we introducing our children and their teachers to the wonderful world of spreadsheets on iPad using Google Sheets in Grade 3!

For some this may seems a little excessive, but that's because they probably suffer from a little known condition known as 'spreadsheetitus'—where individuals have an irrational reluctance to use a powerful digital tool for no other reason than they were never introduced to it when they were their age. But fear not, spreadsheets are easier to use than you might think...

Spreadsheets are wondertools, the calculators of the 21st Century, and like calculators they can do incredibly complex mathematics, or, as in this example very simple mathematics indeed.

Our approach to ensuring ICT skills are not neglected, while still using and learning these skills in an authentic, integrated learning environment is to look for opportunities within the curriculum to utilise tools where it makes sense. Finding an opportunity to integrate spreadsheets isn't too difficult. In this case our Grade 3 track their use of water over the course of a week, and use that guided enquiry as a basis for maths work, cue spreadsheets!

This example introduces the app and shows how to calculate the total of a column of figures using a Function (SUM) and how to perform a custom calculation (ie multiplying 2 numbers) by creating a Formula, which is really as simple as, "take whatever is in that cell, multiply it by whatever is in that cell, and put the answer here..."

Make a Graph/Chart

This is as simple as 'select to affect', but it doesn't work if you just select everything, you need to only select the data you need to use. The video below demonstrates how this works.... 

Super easy PDF commenting for better collaborative reading and comprehension

In recent years lots of teachers would have spotted students developing the habit and tendency to skim read online and the shallow comprehension skills that follow. We constantly give students resources to read over to supporting their thinking and their understanding of case studies, yet many students will read too quickly and superficially without processing the information.

A lesson I did last week really changed my perspective on this, using a super simple PDF commenting trick in Google Drive. A colleague Sean McHugh spotted a few weeks ago that Google had added a comment function into any PDF you have stored in Google Drive. With a couple of quick clicks you can print an article off any website and save as a PDF and then save this into your Google Drive. You can then choose to share the PDF ‘with a the link’ and thus give the viewer the ability to comment on the document. You can click and see the explore the example below.

You can set this up as follows;

• Find your article online or find your saved PDF
• If you have an online article click to print but change destination to – Save as PDF
• Drag PDF into your Google Drive
• Click in the top right to share and then choose – Share so ‘Anyone with link can comment‘
• Then share this with your students, they can comment on individual words or top right to drag an area to comment.

At our school you can link directly from our Online Learning Platform ‘Teamie’ can it will sort the permissions for you. To save the craziness of an entire class commenting on one PDF best top copy and duplicate your file a couple of times and have smaller reading groups.

As an assessment trick, I asked them very specifically to look for definitions or examples of the concept we were studying in the article and to add a comment where they found them. I could scan the documents and see how they were going or add a comment to nudge them along.

EdPuzzle: video questions for formative assessment

Like all teachers, we see our face-to-face time with my classes as incredibly valuable and precious. I want to spend as much of this time as possible checking for understanding, exploring key questions and helping student grapple with complex ideas where I can coach, probe and support.

When introducing a new concept we often default to a mini lecture and some slides and ask a couple of questions to keep the students on track. With laptops and online tools such as EdPuzzle there are some really effective ways for students to work through a tutorial at their own pace and for you as a teacher to collate answers from all students.  Developing an online flipped instruction resource is a skill that teachers should have in their repertoire thereby being able to use the data to check for understanding and then plan how we might adapt our plans for the next lesson.

 

When other school activities, trips, or absences mean that weeks disrupted and we struggle to maintain the flow with our students an EdPuzzle can help you make the most of your precious time in class.

The following slides help you how to set up with EdPuzzle and how to add questions to a video. Signup with your Google Apps account here.

The essential steps are...

1. You can add any video from YouTube or other platforms
2. Just copy the URL and paste into the EdPuzzle search tool
3. Trim the video to highlight a certain passage of a longer clip
4. Click to add either open response, multiple choice questions or your comment on video
5. Save and publish to your students and then sharing the link via your online class.
6. Check your teacher dashboard to see summary of student responses, either by student or by question.

Notetaking with Evernote

Evernote is a great application for writing and collating notes and now it looks even better. Over the last month Evernote has had a refresh and remains one of the most effective note taking tools for school.

You can download Evernote from the App Store and signin to get started. The free account allows you to do everything you might need as a student.

If you are someone who saves school work in separate word documents, Evernote is the tool for you. Once you sign up for a free account your notes are saved both in the app and on the web. Your notes are also easily searchable by key words, tags and titles. Use the associated app Evernote Web Clipper to save websites and notes as you surf the web.

Some top tips to become an Evernote ninja

Master the Left Hand Sidebar

The sidebar has been updated to help you navigate through your notes more easily. The most recent notes show up, plus any Notebooks you drag to the shortcut section at the top. Try drag notebooks from each of your subjects into this shortcut bar.

Tags

Tags are a way that you can label notes so that you can search them later. Much like tagging a friend in a photo in Facebook, tagging should be part of your routine when taking notes and researching. The new tab icon in the lefthand sidebar help you see an overview of your tags and work.

Notetaking

Within each note there are lots of features to support your writing. Think about using the check list icons, bullet points, table and different colours. You can use these ideas to collate ideas or summarise viewpoints. Also try the record button to save some audio or the teachers talk into the note.

Saving from the Web

Evernote Webclipper is a Chrome Extension you can download from within Evernote Preferences. This allows you to grab snippets from a website and save this research back into your Evernote notebook. It is a brilliant way to keep track of your research.

The Fundamental Four!

The Fundamental 4

The Essential Tech Slide Deck: bit.ly/uwctechdeck

There are lots of aspects to digital organisation, but the four that are most essential, and that also happen to be synergetic, ie all four are codependent, are:

1. Get Connected

Open up the Chrome Browser, then click in the little icon in the top right corner and sign in to Chrome. Sign in with your account details and agree to Link data when prompted. 

This means that everything you do with account is continually synchronised with your Google 'cloud' online, so if you lose your laptop, and have to either use a loaner or start with a new one, as soon as you sign in a sync—voila—everything in your Google life will reappear in seconds. Note, this just synchronises your browser content, files on your hard drive will not be backed up, to do this you'll need Backup & Sync*.

2. Organise your Drive

Open up the Chrome Browser, and go to your Google Drive online. Make sure you have folders created for all subject areas. You might want to add a folder for your own personal files, but remember, your drive is a school space, not your personal space.

There should only be folders in your drive, no loose files. If you have files from previous years that are making a mess, just create a folder called Archive (if you haven't already) and drop them in.

3. Desktop (almost) Zero: Drive it or Dump it. 

Your desktop is not a good place to keep your files—it makes them handy, but once they build up it comes very difficult to find anything. Worse, if you have any problems, none of those files are safe, so make sure any files you do have their a strictly temporary. Like the desk in your classroom, at the end of the lesson, make a decision; drive it (move it to your drive) or dump it (move it to the bin). Now you have your Drive synchronized this is as easy as a drag and drop, or within the Finder. 

4. Bookmarks on the Browser Bar, Trim your Tabs

All of the websites you rely on to function effectively from day to day should be organised along the bookmark bar. Make sure you are signed in so these are all synchronised to your cloud account. That means that those bookmarks, stored in folders, are backed up, and accessible on any other device that you sign in to.

Too many Tabs 

Too many open tabs is a symptom of poor bookmark organisation, if you know you can easily find any page you need in you bookmarks, you don't need to have 50 tabs open 'just in case'. If the site matters, then bookmark it, if not then close it if you don't need it now; an easy to do this is just use command+w to close any tab you have open.

To quickly close loads of tabs, just control click on a tab and choose one of the options, like Close Other Tabs!

Less than 10 tabs is ideal

This many tabs is unmanageable, and bad for you! 

(While you're there why not quit the apps you're not using and close any open windows as well?)

bit.ly/fundamental4

There are more than four?

Yes, but don't panic, one a week will see you reach organisational nirvana within a few months, with fabulous habits for life! 

What kinds of things? Well simple but powerful tips like this one for example:

Using the slide deck below, all you need to do is commit 10 minutes a week, until you have the fundamental four covered.

Here's the tech slide deck, open it, drop it on your (nice and tidy) bookmark bar and check it out once a week!

Poetry - Made Multimodal!

This incredible, beautiful example inspired me to approach our English teachers to consider making their work with poetry multimodal; showing this to them was a pretty persuasive pitch.

One of the many great things about my job is that I get to work with teachers and students throughout the college, from Kindergarten to Grade 12. One of the fabulous aspects to this is how often the fundamentals that are introduced in the Primary School, are just as effective and just as powerful in the Middle and High Schools.

We have been making a concerted effort to ensure that when we talk about 'digital literacy' we back that with some fundamentals, specifically the expectation that as our students move through the college they move from introduction to consolidation to competence in the five core domains of video, image, text, audio, and data. What follows is one example this year of integrating three of these into students experiences with poetry, by making it multimodal.

Multimodal Poetry

This work began by focusing on our Grade 4 students, nearing the end of a Writing Workshop focus on poetry. Instead of leaving it as a text only celebration, we asked the students to reimagine one of their poems, adding imagery—be it still or moving image. Some students were more literal in their interpretation, others more abstract, but the best skilfully combined both. Then they added the power of sound, choosing music and even sound effects to complement their own narration.

What I find really exciting though, is that as why I was able to take these videos to our Grade 7 teachers, whose students were ending a focus on poetry, only in this case they had been analysing and exploring an anthology of poetry. So we asked them to choose one... and make it multimodal. 

Grade 4

Grade 7

Whether it was a grade 4 poem the students wrote themselves, or a poem chosen by a Grade 7 student from an anthology, the teachers consistently commented on how powerful and insightful it was to see each students understanding of poetry made visual, made audible; made multimodal. 

Resources

If you're keen to have a go, here's a link to the site page where I collated the resources—I used the same resources with both Primary and Middle School classes. 

http://findsounds.com/ 

http://bbcsfx.acropolis.org.uk/ 

These sites are fabulous for downloading music:

https://www.bensound.com/ 

http://freemusicarchive.org/

https://www.jamendo.com/ 

Spreadsheets for Everyone

Spreadsheets rock my world.

Spreadsheets are, at least in my experience, probably the least appreciated of the five core domains of ICT, unappreciated at least by people who have never used them. But, once you get a glimpse into the sheer mathematical beauty of the way these sheets of interconnecting cells, rows and grids can empower mere mortals to manipulate screeds of data like magnificent mathematical machines, well, you won't look back.  The ways that modern spreadsheets help people organise data from the miniscule to the massive, and free us to focus on the meaning of the numbers as opposed to the mere mechanics, is nothing short of transformational. 

5 core domains: Text, Image, Audio,  Video and Data - which ones are you weakest in?

And yet many, if not most educators languish in lethargic reticence; whether it's apathy or antipathy, who can say? What I do know is that the with the developments in terms of sheer processing power and refinement of control interfaces, the information and data management tools that used to be extremely complex operations, the purview of financial professionals only, are now suitable for anyone with or without a mathematical background. Spreadsheet applications like Numbers and Google Sheets have made it easier for the ordinary user, even kids as young as Grade 2 (Year 3) and below to manipulate, edit, and share the data stored in spreadsheets, using different functions and computations.

And no, it's not just about graphing. You can do that in a Word Processor or a Presentation tool. No. Spreadsheets are all about manipulating and managing data.

For examples of how I've used spreadsheets with kids as young as Grade 2, see this post. If you are a total spreadsheet noob and need to start from zero... read on.

So you feel like a novice when it comes to spreadsheets? Well it only takes 10 minutes to fix. Here is a labsite lesson I ran for our Grade 4 teachers, to get them from spreadsheet zeroes to spreadsheet heroes in one lesson. The whole thing is available below, in it's entirety (40 minutes) or in convenient bite sized attention deficit sized morsels below. You only need to know about 'Functions & Formulae' to get started.


The entire lesson took 40 minutes, here it is in sections:

Spreadsheet skill review:

Review cell address, and ranges of cells, eg: A1:B6

Functions & Formulae 

Review adding the contents of cells, by by using the SUM function and by writing a formula, eg A2+B3.

Critical to the 21st Century classroom model, is ensuring that you as the teacher are NOT a prerequisite for success. Students need to be empowered to resolve their own challenges. The sooner you establish this as 'normal' practice, the easier it will be.

The students should not 'need' you to learn.

This section is purely concerned with the appearance of the spreadsheet. No Maths required, resizing columns and rows, adding text,. and outlines.

Students build a framework within with they can insert relevant data.

Now that the framework is ready, this section guides students through 'telling' the spreadsheet what kind of data will be entered into certain cells.

IMPORTANT: In a spreadsheet you cannot just add a $ sign to indicate currency, symbols like these actually contain 'functionality' in a spreadsheet, so in short, nothing will work.

Instead if you writing dollar signs, let the spreadsheet do that FOR you, by telling it to format certain cells as currency.

This feature as other uses as well, for example making certain cells display percentages. You cannot do this by just adding a % sign.

Students enter specific data that need to be totalled using the SUM function.


As more information is entered, the total at the bottom of the sheet should automatically update, this allows students to begin 'modelling' 'What if?' scenarios:

What if we buy 15 of those?

Then students can write a subtraction formula to subtract the $20 that they were initially loaned from their overall total.

Student's that finish early, should be used as 'quality control' ie checking on their peers to make sure that they are finished properly, and that their sheets are working properly.

 

Challenger

This section is an 'extension' section.

This means that the spreadsheet will do what they need, but these features will make it even better... IN particular enabling more effective 'modelling'.

• Inserting additional columns to allow better management of multiple quantities.
• Refining the use of formulae to add and subtract
• Creating a 'ripple' effect whereby cells reference other cells
• Using conditional formatting to change the colour of a cell when the value changes.

Students will need time to 'play' with these interrelated features, in order to get to a point where the logical sequencing of calculations makes sense.

They may also use ways to get it working which are not the same as yours... it may even be better...

Google's Applied Digital Skills 

Google have created an entire curriculum devoted to skills acquisition, totally supported with video tutorials, that can lead you thorough lessons, step by step. The skills span the entire Google Apps Suite, but the Sheets focused lessons are particularly well designed. 

A great example is this lesson on budgeting to make better financial decisions: 

Junior School Sheet Activities

Our Maths Coach has created the following website to collate some of the core activities we use to integrate the effective use of spreadsheets into Junior School Maths lessons: 

PDFs, Pragmatism & WWPP

WWPP,  a pragmatic compromise: WP, WWW, PPT & PDFs

If there is one thing I've learned in my now almost a decade as a digital literacy coach (DLC), and from now over 20 years working with 'edtech' or the technology enhanced learning (TEL) in the classroom from K-12, it's that there is a fundamental shift, in terms of how opportunities to learn and to create with digital tools are experienced as students move though their school lives. There is a gradual progression. During their primary/elementary years, students at UWCSEA regularly (ie, at least once a year) work across all five of the domains that span what I what I would describe as true digital literacy, or perhaps a better word is competency; video, image, text, audio, data—or VITAD. Then as they progress through middle and then high school, there is a narrowing of focus as students become more specialised in their learning, and their range of learning experiences narrows, from VITAD, to something I call WWPP:

• Word Processing
• Websites & Web Search
• PowerPoint Slideshows (or similar)
• Printing, PDFs, Posters (yes I realise that's more than one P)

WWPP describes the fundamental domains that are the norm for most teachers in most subjects in terms of the tools they rely on to do their own work, and so, not surprisingly, represent the kinds of digital technology they are comfortable using with their students, and in (hopefully, but not necessarily) expecting their students to use. This means, whether you like it or not, this represents the actual reality in most secondary school classrooms, especially those that are organised around the premise of preparing students for high stakes examinations.

This doesn't mean that VITAD is non existent in secondary schools, it just means that it will be more isolated and consigned to certain subject areas, eg data handling in the Sciences, image in the Arts, audio in Music, video in Film et cetera. This doesn't mean these experiences aren't beneficial in other subject areas, the work they do in primary school clearly demonstrates that it is, it's just that, having worked on trying to facilitate this, I've had to concede that it just doesn't happen much, if at all, once students are taught by subject specialists. This observation is one I have observed both as a teacher and a parent for many years, and it is one that is borne out by the literature. I've already written a post about this phenomenon, that can be summed up by these quotes from two recent studies into the dominant use of digital technologies in secondary schools is in terms of their assumed and actual use: 

Laptops are typically purchased by schools and sometimes by parents, and they are largely used to write and revise papers, conduct Internet searches, and engage in personalized instruction and assessment using educational software or online tools. (Zheng et al, 2016, p2)

... schools revealed moderate use of many well-established digital technologies, such as word processing, presentation software, and quiz games. (Hughes et al, 2018, p1)

... students reported using word processing, spreadsheets, presentation tools, and web searches most frequently in class. (ibid, p2)

So the fact is that, like it or not, what studies repeatedly show as 'effective' use, is use that can be translated into evidence that is measured using a standardised test score. And if that is the only metric we are prepared (or able) to consider, then WWPP is the model that works, and WWPP is a model that works for preparing students for high stakes examinations; until those examinations change in terms of their expectations, then WWPP is here to stay. 

Now I'm not ecstatic about this, but I am pragmatic; by this I mean if we're going to accept that this narrowing of expectation exists, that the least we can do is teach these skills properly. The danger at the moment, is that in the same way that these skills reflect their teachers ICT skills, they also reflect their teachers competency, or as is more often the case in my experience, their teachers' gradually increasing competency. Now—don't get me wrong—I don't blame teachers for this, it's very powerful when a teacher can model for their students that they are also 'lifelong learners' and anyway, if they are anywhere near my age, they didn't actually own a computer until they were in their 20s, and even then they were never taught how to use them, they were just expected to figure it out themselves by trial and tribulation. I've written more on this skills issue in another post, but suffice it to say here, that at the very least, if we're going to narrow our focus, can we at least expect these skills to be taught properly? To be used in a skilful, or especially at high school level, a competent way? I think we can, and I think we should. The benefits to both teachers in terms of their ability to do their jobs more effectively, and to their students are clear. 

What does skilled WWPP look like?

It looks like the expectations for any adult who would be deemed to be digitally literate, any adult who wants, no, needs to function effectively in the vast majority of workplaces in the 21st century. Some suggestions below:  

Skilful Word Processing 

• Use and format tables: insert & delete rows, columns, & merge cells
• Use the tab key (also add new row to a table/indented bullets)
• Use commenting tools to give, receive & respond to feedback
• Paste text without formatting, or to match destination formatting
• Insert/format/manage page numbers
• Add/use headers/footers 
• Use, modify, and create templates
• Use document page breaks, section breaks & styles
• Use automatic features like table of contents (TOC), references, citations
• Reference source materials, ie MLA, APA et cetera
• Extend these same skills to the building of web resources/sites

Skilful Web Browsing/Searching

• Use History and bookmarks effectively instead of relying on excessive tabs
• Use multiple accounts with web browsers to manage private/professional practice
• Access and find information in an online database not just Google/Bing et al.
• Identify key words, names, & phrases for a search
• Appreciate the advantages & disadvantages of a variety of sources
• Use the find command to locate specific words on a page
• Upload & download files as appropriate, understand the associated file sizes. 
• Understand & carry out an (advanced) multiple field search
• Search using Boolean terms (site:, intitle:, —)

Skilful PowerPoints/Slide Shows

• Create well designed slideshows that rely on image, not text  
• Format & customise well designed themes 
• Create presentations that use multimedia effectively, eg video, sound &/or animation
• Format & edit master slides to manage the formatting of a presentation
• Use appropriate images, eg pixel width, proportion, illustration not just decoration
• Crop & enhance images to complement your slides 
• Select, trim and incorporate video clips/animations
• Visualise data effectively using charts and graphs 
• Understand the affordances of different tools, eg PowerPoint, Keynote, Google Slides... 
• Use slide aspect ratio intentionally (wide screen v 4:3)
• Use the slide sorter view to manage/organise your presentation 

Skilful use of PDFs & Posters

• Organised and synchronised online for ease of access/sharing
• Edit to isolate certain pages, extract specific content, reorder content
• Annotate, comment, and highlight 
• Convert (hard or soft) documents to/from PDF 

• Create well designed posters that balance the use of image with text  
• Format & customise pre-designed themes 
• Understand the differences between an infographic (screen) and a poster (print)

Pragmatism

I've been hesitant to concede these facts, but I console myself with the knowledge that if the students have been given the appropriate foundations and experiences what span VITAD in Primary and some extent, Middle School, their ongoing development in terms of digital literacy is now something they should be able to pursue independently throughout High School, and for the rest of their lives. This means that High School teachers have one focus, and one focus only, that is to enable their students to succeed in their examinations, in the same way they have for the past 50 years. Until the examinations change, there little point expecting teachers to change, Especially as the efficacy of their teaching practice is often based, either explicitly or implicitly, on their students’ grades. 

It’s obvious internationally that many if not most schools don’t understand this, or don’t care.  This is why Google Chromebooks and similar budget computers are thriving in comparison with iPads and MacBooks in schools. The former is fine all you want students to experience is WWPP, but if you want them to demonstrate true digital literacy with VITAD and all of the wonderful combinations and permutations between those domains, budget computers can’t and don’t deliver this. 

References

Hughes, Joan E. and Read, Michelle F. (2018) "Student experiences of technology integration in school subjects: A comparison across four middle schools," Middle Grades Review: Vol. 4 : Iss. 1 , Article 6.
Available at: https://scholarworks.uvm.edu/mgreview/vol4/iss1/6

Zheng, B., Warschauer, M., Lin, C. H., & Chang, C. (2016). Learning in One-to-One Laptop Environments A Meta-Analysis and Research Synthesis. Review of Educational Research, 0034654316628645.