Creating a YouTube based discussion activity in Moodle

I run a lot of training on effective uses of a VLE (usually Moodle) and one of the easiest activities that I show, is finding a video on YouTube, and then embedding this into a forum activity within the VLE.

The reasons for doing this are:

  1. By embedding the video (rather than simply linking to it) – we remove all the distractions, adverts, etc. that appear on YouTube around the edges.
  2. By adding this as a discussion activity, we ask the students a question – this will focus their attention whilst watching the video, rather than just passively  ‘absorbing’ it.

It doesn’t matter if students don’t actually post their answers to the forum (although useful if they do), as they will still benefit from watching the video with the question in their mind.

The following video goes through the steps of how to embed the video, and the basic settings within a Moodle forum activity.

And if you want to only show a portion of the video you can always identify the exact start and end points that you want to play, by following these instructions:

Trimming and Embedding a YouTube Video into PowerPoint

I have blogged many times in the past about things to do with PowerPoint, including how to embed a YouTube video, or how to use TubeChop to embed a YouTube video.

In more recent versions of PowerPoint (2013 and 2016), the ability to embed a YouTube video has been made easier, and the following video will take you through the steps:

Although easier to do than in the past, this technique has been unreliable for some people in some organisations, so I always recommend to people to paste the video’s URL onto the slide somewhere as a live link, so if this doesn’t work, you have the fall back of simply accessing the video via the YouTube website.

This technique is showing how to embed the video – this means you still need access to the Internet when viewing the presentation, and it won’t work if the organisation blocks YouTube.

This technique replaces the older method of using the shockwave flash object, or using TubeChop to trim the video.

Ask staff what they want their VLE to be able to do

Yesterday I was running a series of training sessions for a college starting to use Moodle as their VLE. At the end of the day I set up a very simple activity (using the Database activity) where I asked the staff to identify “Wouldn’t it be great if Moodle could….?”. I asked them to try and think outside of the box – e.g. what would make a huge difference to their teaching, but you don’t think Moodle can do.
wishing tree
I then quickly went through all the suggestions (8 in total) and explained which were or were not possible. Of the 8 suggestions, 6 of them were possible – this had a wow factor with the staff, most of whom had suggested things they didn’t think could be done. I then tried to reinforce the idea that you start with identifying what you want to do, rather than what you know how to do.

Of the suggestions, one of the ‘not possible’ ones, was taking the dogs for a walk. From the 6 possibles – ideas were things like:

  • Ability to set up a blog for them to carry out reflective practice (achievable with the OU blog plugin).
  • Ability for students to store files on the system (achievable with the Private files function).
  • Include an online video meeting space (achievable in various ways with a web conferencing tool).

This is the first time I had tried this activity. I set it up expecting some of the suggestions to be possible – I wasn’t expecting 75% of them to be possible. I will certainly be repeating this activity in the future.

Phote source:

Bulk uploading items to a Moodle Glossary

The Moodle Glossary is one of the simplest activities to use within Moodle. It’s primary purpose is to set up a glossary that the students populate or at least add to, rather than the tutor populating it – however there are occasions when it is useful for the tutor to populate the glossary. This could be if the tutor wants to provide the students with a ‘correct’ list of technical terms and their definitions, or if the tutor wants to create a crossword using the Moodle Game Activity plugin – which pulls the data out of a glossary activity.

If the tutor is populating the glossary, they could enter the data manually item by item, but this is very time consuming, especially if they already have the data to hand in a spreadsheet or similar. Luckily there is a way to bulk upload these items. It is a little complex, but once you have done a few not too bad, and certainly a lot easier than manually typing in lots of items.

Firstly – we need to create the glossary, the following video from Moodle, goes through this step:

Then the clever part is importing the list of terms from an external source. This is covered in this video:

The XML converter that is used, can be located here: with the direct link to the actual file itself being:

You only need to download and unzip this once – as long as you can remember where you have saved it to. Although it may seem a little convoluted at first, this technique will save serious amounts of time compared to manually entering lots of data.

The only other thing to note, is the default settings of the glossary may allow the students to add their own items to this glossary, if you don’t want this to happen, you can stop this by using either of the following options:

  1. In the glossary settings – make it so the ‘Approved by default’ option is set to ‘no’.
  2. Go into the permissions for that glossary and next to where is says ‘Create new entries’ delete students from the list of roles that can do this.



Correcting problem with Outlook 2013 not always sending messages

I have recently upgraded my windows computer from Windows 8 to Windows 10, which in general is great, but it did cause a problem with outlook 2013, in that some messages wouldn’t send. The problem wasn’t consistent, which was confusing, I tried searching the internet for help, but the solutions offered all seem very complicated, so I contacted my web host, who talked me through the solution, which worked, so I thought that I would share this here.

Please note – I am not technically orientated, I am just repeating the steps for my benefit in case I need it in the future – if you follow these steps, you do so at your own risk, and if it doesn’t solve your problem, please don’t ask me – I won’t know the answer.

So to solve the problem:

  1. I right clicked on Windows icon.
  2. I selected command prompt (admin)
  3. I typed “sfc/scannow” then enter.
  4. I let this run the scan (took about 15 minutes).
  5. Once scan had finished I closed down Outlook and then restarted it.

As mentioned earlier, I am not technically minded, so I have no idea what is happening with the above apart from it appeared to fix my problem.

How to trim a YouTube video and embed it into WordPress

Regular followers of my blog, will know that I have previously blogged about different ways of trimming or cropping YouTube videos to use in different situations, e.g:

Trimming videos can be really valuable, as often (in education) there may be a key message or element in a video, that we want to draw attention to, without having to show the entire video, so carefully selecting sections of the video can drastically improve the impact of using that video as a resource.

Up until recently, something that I couldn’t do was to get this to work in WordPress, I could only embed the whole video – however today I found out that I can do trim a video, if you follow these instructions exactly:

  1. Locate the video you want on YouTube.
  2. Under the video choose ‘Share’ and then ‘Embed’.
  3. Underneath the preview, there will be some tick boxes – make sure the one called ‘Show suggested videos when the video finishes‘ is unticked (this is really important).
  4. Copy the embed code that is above the preview.
  5. Go into your WordPress post, and into the HTML editor.
  6. Paste the copied embed code in the correct position.
  7. Preview your post.
  8. Go back to edit your post, and again into the HTML editor.
  9. The code that you pasted in, will have been changed, towards the end of it, locate the text rel=0.
  10. Immediately after rel=0 add &start=xxx&end=yyy (where xxx is the number of seconds you want the video to start at and yyy is the number of seconds you want the video to end at).
  11. Preview your post – if it works then publish.

So – if I have a video that I want to start at 2:35 and end at 3:15 – I convert these into seconds (2:35 = 155, 3:15 = 195) – and the end of the code will change from:




Below is an example of one of my YouTube videos, trimmed to start at 155 seconds and end at 195 seconds.

How to display the sheet name in a cell in an Excel spreadsheet

I use Excel a lot, not just for crunching numbers, but for creating teaching resources, lesson planning, managing my accounts and invoices and various other uses. One feature that I often use, is the ability to have the sheet name appearing inside a cell in the spreadsheet – so for example with my invoices – I rename the sheet name with the invoice number, this then updates the invoice within the sheet.

To do this I use the following formula below.

This may seem a complex formula, and it doesn’t matter if you don’t fully understand it (I don’t), you just need to copy and paste this into a cell in the spreadsheet, and the sheet name will appear. If you change the sheet name, the cell will change accordingly.

The only caveat is, that the workbook has to have been saved at some point for this to work – so if you do this with a new workbook, it won’t work until it has been saved.

This technique is unique to Microsoft Excel, it doesn’t work with other spreadsheet tools such as Open office, Google sheets or Apple’s Numbers.


Get every new post delivered to your Inbox.

Join 1,514 other followers