This is my version of a random name generator. 'Ultimate' as it allows you to select whole class, just SEN, just G&T, or girls/boys. It also uses a big red button to run the generator which looks great on an interactive board as you can just whack it to bring up a name. Setup information is included on the first sheet. This file contains a macro which you must enable. Always take care when downloading files with macros as they can contain viruses. This file does not contain a virus. If you don't need to select specific groups of students, check out my PowerPoint Toolkit on here which is much better in every way (apart from not selecting groups).
This spreadsheet will allow students or the teacher to play with amplitude and phase differences between two waves showing the resultant wave. It can also animate the phase change and resultant wave so students can see the cyclic effect of constructive and destructive superposition.
Brief introductory quiz about astronomy to get a feel for what students already know about the solar system and beyond, and some key figures in cosmology.
A quick test to check students' understanding of flowcharts. Each flowchart will produce a definite number which if identified correctly and typed into the cell above the flowchart will highlight.
A spreadsheet that graphs three complete cycles of a wave. On the same graph there is a variable trace for a wave that can be put out of phase with the first. It can be put out of phase by any amount but there is a button included to vary the phase difference by 5 degrees at a time so it can be easily demonstrated on an interactive board. This could even be shared on a VLE as part of a homework.
Tools embedded into a PowerPoint file so you never need to leave your presentation again. Includes interactive games, dice, random number generator, random name generator for 10 classes, group creator for creating groups of any size, secret student, detention timer, hour glass timer, large and small timers, clock, RAG voting system, general voting system, quick web access, quick calculator access, notepad within PowerPoint, a plenary generator for ideas and a button to end the presentation quickly. All available on every slide from the toolbar at the top. All information saved from one lesson to the next. All without ending your presentation. And all for free.
This spreadsheet will accept your comments appropriate for the key stage 3 levels, and process them against a class list to generate a set of reports that can be copied into whatever report writing software is used, or a word processor. Instructions are given throughout and buttons guide you through each stage.
Activity that shows students how vlookups work, then gets them to build all of the necessary parts to a vlookup system. Instructions given along with prompts throughout the file. Students should work through each of the sheets in the workbook in order.
Traditional Monopoly board with rules designed to get students thinking about questions and testing each other. It can be used for any subject. Students are likely to take a long time creating the questions so some time may be needed. Even once the game is being played, however, creation of new questions does not stop.
These videos were created using Stellarium (free to download). They show and explain various phenomena: lunar eclipse, phases of the moon, seasons, solar eclipse, sunrise and sunset. May require Quicktime, or better still, VLC to play videos.
A lesson about minimum spanning trees meant as an introduction to networks. It has the lesson plan, a worksheet and an interactive spreadsheet that students can use to try out their solutions.
A lesson plan and resources to introduce to students some simple programming concepts: IF statements, InputBox, MsgBox (output), variables and looping. The teacher file works entirely. The student file has clear instructions in the module where the code needs to be written. Aimed at KS3 but could be used for KS4 as well.
Starter to get pupils to show how well they can write basic formulae in Excel. Cells change colour based on whether or not pupils have the correct answer.
This spreadsheet will produce data for free fall for a given initial height, initial velocity and gravitational field strength, using a specified time division. On Windows this will produce the s/t and v/t graphs in front of your eyes. On OS X it will do the calculations and show the graphs at the end. The data can be used to get students to draw their own graphs or it can be used to demonstrate what the graphs will look like given certain parameters.
This is a spreadsheet that simulates radioactive decay. You start with a grid of 1s that decay to 0s. The decay for each is random. It runs through 8 'generations' of decays. Each 'generation' can be assigned any unit of time you wish. A record of everything that happens is recorded into a results table that can be used by the class to plot results. A log graph and a linear graph are both produced, each of which can be printed for a class to use (changes the axes as you see fit). The decay modifier changes the half-life and is an arbitrary value, so play around with it.
Almost classic Snakes and Ladders. Teachers will need to have some questions in mind as players are asked questions on each of the snakes and ladders to either prevent them going down or to allow them to go up. Macros need enabling for this to run. Could make for a fun plenary to set both sides of the room off against each other, or to play the girls off against the boys.
A program that will ask the user some questions to determine what animal they are thinking of. A classification key is provided along with the beginning of the program in Scratch. Student will need to use what is there to work out how it should be finished. The program will teach students about IF statements, messages (sub-routines), variables, inputs and outputs.
Students should gather data about GCSE grades and digit ratio for their population of participants. Input the data directly into the spreadsheet to get a Spearman's Coefficient. Students will be testing the hypotheses: maths ability correlates with digit ratio; language ability correlates with digit ratio. ****Must use 10 participants to work correctly**** Lots to evaluate with this activity afterwards.
Activity to get students learning about VBA's IF and Case functions. The first activity deals with validation and has room for it to be evaluated. Students should work through each of the sheets in the workbook. Each section has the code displayed alongside its implementation of the worksheet and the code is marked up with instructions.