• Dave Foord
  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,624 other followers

  • Dave Foords Twitter

    Error: Twitter did not respond. Please wait a few minutes and refresh this page.

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:


Image of 2 carnival goes wearing skeleton masks and hats. The image is rectangular with a hard border.

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!):

Image of 2 carnival goes wearing skeleton masks and hats. The image has soft edges and no border.
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.

Image showing a simple RAG system created in Excel

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:

https://www.youtube.com/channel/UCWuDqvf7nO6-00JMMxm1lIw?view_as=subscriber


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).

Image showing the example activity

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:

https://www.youtube.com/channel/UCWuDqvf7nO6-00JMMxm1lIw?view_as=subscriber

 

Easily create a Venn diagram drag and drop activity in Moodle

There is an excellent plugin for the Moodle VLE called ‘Drag and Drop Markers‘ which allows someone to create quiz questions, where the learners have to drag and drop markers onto an uploaded image. This can be used to name parts of an image (e.g. bones in the skeleton, or geological features of a glacier), or to create effective categorisation questions. One of my favourite question types, is where the learners take pieces of information, and categorise these by placing them in the correct position on a Venn diagram.

To create this from scratch, would be extremely time consuming, so to make my life easier, I have used PowerPoint to create templates for myself, meaning that I can now create these questions in a matter of minutes, rather than hours, and I will release these to the wider community over the coming days and weeks (as I get time to tidy them up etc.) The first such template for release, is for a 3 circle Venn diagram categorisation activity.

The basic principle is:

  1. Name the 3 circles with the correct titles.
  2. Save the slide as an image.
  3. Upload this to the Moodle quiz question.
  4. Identify what markers you want to use.
  5. Identify which of the 8 possible drop zones is correct for each marker.
  6. Copy and paste the coordinates for each dropzone into Moodle.

This takes a matter of minutes to do, and allows someone to create challenging and more effective questions, as part of the formative assessment process.

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

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

And a video explaining how to use this is as follows:

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:

https://www.youtube.com/channel/UCWuDqvf7nO6-00JMMxm1lIw?view_as=subscriber

 

 

Adding a date picker to Excel

As a huge user of Excel, I am often entering dates into cells. Different versions of Microsoft have had date pickers as an optional add on, but they haven’t always worked for me with all versions or consistently.

I have however just discovered this free tool:
http://samradapps.com/datepicker/

Which is created by Sam Radakovitz , which does exactly what I want.

Once set up, if a cell in Excel is set as a date, clicking on that cell, will bring up a small calendar icon to the right of the cell:

Image showing the calendar icon to right of the selected cell

Which when clicked on, will bring up the calendar tool, making it easier to enter dates, and not have to worry about the correct format, or whether the spreadsheet has been set up in UK or USA format.

 

F

Full credit to Sam for this one, I am just blogging about this mainly for my own benefit so that I can relocate this in the future when I change computers.

Spreadsheets: How to Sort Data Onto Sub Sheets based on values in a given column

One of the most popular posts on this blog, is one I published back in 2011, titled How to automatically pull data between different google spreadsheets  I am often asked by people, is it possible to filter the data based on the value in a column, before pulling the data across?

I have created a video which shows a technique whereby data is filtered internally within a workbook, so data is pulled onto subsequent sheets, based on values in a certain column. In this example I am using a class of students, and all the grade A students are copied onto a sheet called “A”, all the grade B students are copied onto a sheet called “B” etc. This principle could easily be used to organise a list of sales by sales rep, or by region.

The video is about 13 minutes long, but well worth watching, if you are interested in this technique.

For this example I have used Excel, but this would also work with other spreadsheet systems such as OpenOffice or Google Sheets.

The file used in the video example can be downloaded here, if you want to see or copy the formulas used.

Spreadsheet – sort data onto new sheets Shared

The mechanism also uses a technique to display the sheet name in a cell in the spreadsheet. More details on this can be found at https://davefoord.wordpress.com/2015/04/16/how-to-display-the-sheet-name-in-a-cell-in-an-excel-spreadsheet/

I hope that this helps people to make better use of Spreadsheets, whether it is in education, work, or for personal use.