## Using PowerPoint to manipulate images: Creating soft edges

This is the second tutorial in a series on ‘Using PowerPoint to manipulate images’. For people like me that doesn’t own nor has the graphical skills to use the high end graphics packages, PowerPoint is my primary image editing tool, even if the end location of the image is going to be somewhere else (Word, Excel, VLE etc.)

A lot of people when adding images to resources will find an image, and chuck it in without thinking about how the image looks, what size it is, what other images are visible alongside it etc. If I am using an image as a ‘decorative’ element designed to break up the text and to act as a ‘memory hook’ for the learner, then one technique that I sometimes use is to change the image to have soft edges. This (as the name suggests) softens its appearance, so it blends into the ‘page’ rather than having the harsh sharp edge that makes it stand out. If someone is going to be spending a lot of time viewing a particular screen, having soft edges can be easier on the eye than the harsh edge of a bordered image.

Here is an example of an image that I have used in a PowerPoint presentation:

Here is the same image that has been turned into an oval and had the edges softened (annoyingly the theme that I use for this blog, puts a grey border around the image that I don’t want!):

The following video shows how easy this is to achieve, note – it is possible to edit multiple images at the same time – if you hold a finger on the ctrl key whilst clicking on the images you can multiple select those images, and then any changes that you make is applied to them all consistently.

## Using PowerPoint to manipulate images: Circling a rectangle

I use images a lot in my work when creating learning resources, and that often requires various forms of editing and manipulating images. I don’t have access to the high end image editing software nor do I have the skill to use them, but I do have access to PowerPoint which can be a very effective tool for basic image manipulation.
In this example I will show how a rectangular image can be converted into a circular image. There a couple of reasons why you may want to do this;

• It takes up less space on the resource, allowing more space for the other items around it.
• It can be easier on the eye having circular images that have no corners compared to squares and rectangles with their hard corners.

This video goes through the steps to do this:

## Creating a RAG system in Excel tutorial

It may sound a bit sad, but I love Excel – once you have mastered a few simple techniques, you can put these techniques together in different orders to create some very powerful effects, and for me one of the most powerful things that I can do in Excel, is analyse some data in a way that will visually highlight an issue to me, so that I can act upon that issue quickly. One such technique that I (and many others) use is using a RAG rating system. RAG stands for Red, Amber, Green – (based on traffic lights), where things that are on schedule and up to date are Green, things that are a possible concern are Amber, and things that are a significant concern are Red.

This following set of videos, are designed as a tutorial to teach you the skills required to create an effective RAG system within your own Excel files.

If you like this tutorial, then please subscribe to my YouTube Channel at:

## Introduction

The first video is an introduction, showing the end product of what will be created.

## Using the Now() function

The Now() function is a very simple way to bring today’s date and time into a cell within the spreadsheet, which can then be used to compare against other dates within the spreadsheet, e.g. to see which are in the past or future.

## Using a basic IF statement

The IF statement in Excel is one of the simplest and most powerful ways to carry out analysis of data in Excel.

## Using a Vlookup function

The Vlookup function, seems a little confusing at first, but once used a few times is relatively straight forwards – and allows you to lookup a value in the left hand column in a table, and then return a value from a specified column in the same row of that table.

## Using the Max and Min functions

The Max and Min function are very simple to use, and will tell you what the largest or smallest value is in a list.

## Using Conditional formatting to create horizontal bars

Conditional formatting is where the appearance of a cell changes based on values (either the value of that cell, or different cells). This video looks at creating horizontal bars that move further right as the value increases.

## Using Conditional formatting to create icons

Another option when applying conditional formatting is to add small icons to cells, for example up and down arrows, traffic lights, warning flags etc.

## Putting this altogether to create the RAG system

The final video shows how the skills covered above can be put together to create the desired RAG effect.

I hope that this tutorial has proved to be useful.

If organisations want training providing in things like using Excel more effectively, then please get in touch via http://www.a6training.co.uk/contact.php

## Template to quickly create a 2 Circle drag and drop activity in Moodle

On Monday I released a template that I have created allowing people to easily create a 3 circle Venn diagram activity in Moodle. Today I have created and released a similar template for a 2 circle Venn diagram activity.

The template is PowerPoint based, and allows the teacher, to quickly and easily create the Venn diagram with the correct dimensions, and then the required coordinates that Moodle uses to identify the different zones are provided for you, so it is possible to create such an activity in a matter of minutes rather than hours.

The following image shows how the activity looks in Moodle, in this case I have used a chemistry example – the beauty of this type of activity, is that it can be used in any subject area (not just maths).

The template file for this, can be downloaded directly via:

http://www.a6training.co.uk/resources/2CircleVennDiagramActivityForMoodle.pptx

And a video explaining how to use this is:

I will be adding more similar templates to this collection in the coming days and weeks, and they will be available at:

http://www.a6training.co.uk/resources_Moodle.php

If you want to keep up to date with similar videos, then subscribe to my YouTube channel via:

## Creating equations in online environments

I am currently working on a project, where I am creating web based resources (using Moodle) to teach maths. As part of this process, I need to create properly laid out formulas (or formulae if you prefer the alternate acceptable plural of formula). We are using what is becoming a widely accepted standard of MathJax which in turn supports the use of something called LaTex to create the desired formulas. So for example if I wanted to create something that looked like:

$y = 3x^{2}+5x+\frac{2}{3}$

I would enter this into the editor using the code:

$$y = 3x^{2}+5x+\frac{2}{3}$$

or

$y = 3x^{2}+5x+\frac{2}{3}$

At first I started to learn the exact syntax and would translate what I wanted into either of the codes above. This proved to be both time consuming and prone to mistakes. Then I discovered an excellent website that helps me do this:

https://www.codecogs.com/latex/eqneditor.php

This website gives me a box into which I construct the equation that I want – above the box is a huge suite of grey buttons which each represent a different mathematical function or options. These take a bit of time to learn, but quite quickly one gets the hang of this, and using the buttons and adding the numbers / letters that you require you can quite quickly create the desired formula that you want. Underneath the white box, your formula is displayed as it will appear, so it is possible to see what you are doing, and check that this is correct.

Once you are happy with what you have created, at the bottom of the screen (in a cream coloured box) is the option to choose the export style that you want – so if you need LaTex, you choose that, if embedding into WordPress, you choose WordPress etc. You then copy the code beneath this, and paste into the editor of whatever you are using.

One of the facilities within the editor, is to create correctly aligned equations:

Which in LaTex is created with the code:

\begin{align*} x+3 &= 7\\ x &= 7-3\\ x &= 4 \end{align*}

This is very hard to manually write out, but quite easy using the codecogs website. The button for this, is the bottom right button on toolbar (letters n and r in brackets) – then under that is a button that has “y=…” as the text, and when you hover over it, it tells you that it is the align tool.

For anyone who is using mathematical formulas regularly this is a really neat tool.

## 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: