Hero image

Computing with Barney

Average Rating4.00
(based on 4 reviews)

ICT/Computing teacher since 2003 and Vice Principal. Interested in technology, gadgets, game design and software/web development. Owner of Barney - a rather grumpy at times but loveable West Highland Terrier who sometimes features in my resources!

ICT/Computing teacher since 2003 and Vice Principal. Interested in technology, gadgets, game design and software/web development. Owner of Barney - a rather grumpy at times but loveable West Highland Terrier who sometimes features in my resources!
Theme Park Spreadsheet Assessment
jonmwardjonmward

Theme Park Spreadsheet Assessment

(0)
This spreadsheet tests students ability to make a prediction from a model, create a graph, use the SUM and Goal Seek functions, write an IF statement and use data validation. The last sheet in the spreadsheet contains formulas that indicate when the student has completed each task correctly to help with marking.
MyCinema Spreadsheet Model
jonmwardjonmward

MyCinema Spreadsheet Model

(0)
This spreadsheet activity task requires students to use the SUM, MIN, MAX and AVERAGE functions to complete the weekly sales figures for their cinema. They can also demonstrate the use of the fill handle to copy down or along formulas. When the formulas have been added they need to answer the questions below it, using the data above. There is an extension activity which requires students to add conditional formatting to highlight which movies are doing better or worse than the average ticket sales. Teacher Ref version (with answers!) included.
Computing Timeline Display
jonmwardjonmward

Computing Timeline Display

(0)
A computing timeline I produced to go around my classroom like a frieze. It covers Babbage's difference engine in 1822 up to 2017. I use it when teaching to show how technology has evolved over a relatively short space of time.
Democracy (British Values) Assembly
jonmwardjonmward

Democracy (British Values) Assembly

(0)
Looks at British democracy from the Magna Carta to the suffragette movement and then on to the UK-EU referendum. The final slides cover the importance of being an informed voter to play a full part in democracy.
Teamwork Assembly
jonmwardjonmward

Teamwork Assembly

(1)
This is an assembly I did on teamwork and the importance of being a good team player. It has a starting slide that asks students to review four images and identify the common theme. I then show several examples of teamwork, i.e. ants working together to create a bridge, meerkats defending against a snake and a great quote from the England team captain from the recent World Cup talking about the importance of teamwork as opposed to having standout players. There are then two videos of an F1 pit crew… the first one to demonstrate the speed at which they work and then the second one is slowed right down so pupils can see the whole team working together, each with their own job and dependent on each other to achieve the same aim. I then finished posing some questions regarding what makes a good team player and provide some guidance on things they could do next time they are working in a group/team.
Representing images using Binary
jonmwardjonmward

Representing images using Binary

(0)
This lesson looks at how computer graphics have developed and how a simple 1-bit image can be encoded using binary. Students then have the opportunity to encode and decode their own binary images. They need to be able to convert binary to denary and vice versa before doing this lesson.
Pacman Challenge (Scratch)
jonmwardjonmward

Pacman Challenge (Scratch)

(2)
This lesson focuses on students identifying and writing pseudocode for the Pacman game (on the worksheet). Students can then move on to the pacman challenge game in Scratch with some of the coding already completed so they can transfer the pseudocode they have written into code. The aim of the lesson is for students to see the relevance of pseudocode and planning before launching straight into coding. The pacman challenge game is available at Barney Game Studios: https://scratch.mit.edu/projects/162290425/
Computing 101
jonmwardjonmward

Computing 101

7 Resources
A set of 7 topics that provide an introduction to the following Computing topics: binary, binary logic, CPU, network topologies and storage technologies.
BBC Micro:bit Project
jonmwardjonmward

BBC Micro:bit Project

(0)
This is an 18 lesson unit of work around Microbits, combining programming using the online microbit interface and electronic components. The components I used were sourced from http://microbit-accessories.co.uk but you could make your own or source from elsewhere as well. Helpsheets are provided for each of the electronic components. The students each have a workbook for the whole unit divided into sections that can be easily marked by the teacher, with opportunity/space for student reflection and response. Students start off learning about microbit theory, i.e. safe handling (static) and polarity, inputs, outputs and programming structures IF statements and loops. They then need to design the “next big thing” - a device that solves a problem, using the microbit. They will need to produce a design brief and circuit diagram. Once they have built it, there is a lesson on gathering user feedback and evaluation. At the end of the unit, they have the opportunity to create a business pitch for their new device. This is a great end to the unit as each student/group gets to share their creation to the rest of the class, with prizes for the best entries (at teacher’s discretion!) The course mainly links towards the D&T criteria (with reference to the relevant criteria at the end of each powerpoint) but could be used in Computing as well.
Flowol Mimics
jonmwardjonmward

Flowol Mimics

(0)
These are three mimics I created using Mimic Creator that can be used in Flowol. These should appear in Flowol when the files & folders in the zip are copied across to the mimics folder. There are worksheets and solutions with each mimic and a short video showing the ride.
Business Studies Blockbusters
jonmwardjonmward

Business Studies Blockbusters

(0)
This is a Revision tool based on the old Blockbusters game format with a gameboard that can be customised with your own questions and can be used as a whole class revision resource or in pairs on their own computers. The player selects the hexagon and the question automatically appears at the bottom of the screen. The answer can be revealed by clicking the “Reveal Answer” button. The hexagon can then be turned blue or white depending on who won the hexagon or black if they got it wrong. The gameboard is currently loaded with GCSE revision business-related questions but can be changed by clicking on the “Questions” sheet and changing the information. After updating the Questions and Answers, click “Reset Gameboard” to rebuild the gameboard with your new questions and answers. If you have answers starting with the same letter then you can enter two letters to differentiate your answers. This opens the game to more possibilities. Note: This excel spreadsheet uses macros in order to work. Please enable them upon loading the spreadsheet.
GCSE Computing Blockbusters
jonmwardjonmward

GCSE Computing Blockbusters

(0)
This is a Revision tool based on the old Blockbusters game format with a gameboard that can be customised with your own questions and can be used as a whole class revision resource or in pairs on their own computers. The player selects the hexagon and the question automatically appears at the bottom of the screen. The answer can be revealed by clicking the “Reveal Answer” button. The hexagon can then be turned blue or white depending on who won the hexagon or black if they got it wrong. The gameboard is currently loaded with GCSE revision computer-related questions but can be changed by clicking on the “Questions” sheet and changing the information. After updating the Questions and Answers, click “Reset Gameboard” to rebuild the gameboard with your new questions and answers. If you have answers starting with the same letter then you can enter two letters to differentiate your answers. This opens the game to more possibilities. Note: This excel spreadsheet uses macros in order to work. Please enable them upon loading the spreadsheet.
Excel Battleships
jonmwardjonmward

Excel Battleships

(0)
An excel spreadsheet that can be played with a class as a quick recap to ensure they can identify and use cell references and understand that the letter (column) goes before the number (row). When I play this with my classes, students take turns in giving a cell reference which I then click on to display the square underneath. You could play this competitively by dividing the class into two teams and seeing who can sink the most battleships.
Computer Systems & Architecture Introduction
jonmwardjonmward

Computer Systems & Architecture Introduction

(0)
This lesson introduces von Neumann architecture briefly and then focuses on inputs and outputs. Students explore the input and outputs devices that would be used in a self-service checkout and several other scenarios.
CPU - Computer Architecture
jonmwardjonmward

CPU - Computer Architecture

(1)
This lesson introduces the CPU (Central Processing Unit) and explains how the clock speed, cache size and number of cores affects the performance of a computer with animated examples. There is a cloze worksheet for students to complete which provides an opportunity to take notes.
Goal Seek - Currency Converter (Excel)
jonmwardjonmward

Goal Seek - Currency Converter (Excel)

(0)
This lesson teaches students about goal seek and how it works in Excel. Students imagine they have just won a million on a "Who wants to be a millionaire?". They use goal seek to work out which country they would rather win the show in. When they have finished, they can then use an online currency converter to find out today's rates and then see how that changes things. This can lead to discussions on how small changes in currency rates can have big impact when transferring money between countries and depending on the ability of your class you can even end up discussing what causes exchange rates to rise and fall - particularly topical at moment given Brexit and the new US President and their impact on the markets.
Teaching Spreadsheets Bundle
jonmwardjonmward

Teaching Spreadsheets Bundle

4 Resources
SAVE 20% on purchasing resources separately. A bundle of 4 resources to help teach spreadsheets, including cell references, SUM, MIN, MAX, goal seek and conditional formatting. The Theme Park spreadsheet assessment task provides a set of tasks for students to complete to demonstrate knowledge of graphs, functions, data validation and IF statements.
Python Mini Test
jonmwardjonmward

Python Mini Test

(0)
Short activity that could be used as a starter to encourage students to work through some code snippets in their head and write down the output.
Binary, Hex and Denary Converter
jonmwardjonmward

Binary, Hex and Denary Converter

(0)
This resource converts between binary, hex and denary. It can be used in a whole class situation on the whiteboard or given to students to use to check their answers to any conversion questions. Useful when teaching binary and hex.
Economics worksheets
jonmwardjonmward

Economics worksheets

(0)
Two worksheets with questions based around news articles regarding economics. Used with my GCSE Business & Economics students to check understanding of the impact of interest rates, exchange rates, manufacturing output and infrastructure spending on the economy.