Miscellaneous
A-Z of Computing
The A-Z or Alphabet of computing and ICT. Use this as an example and then ask students to create their own. A great ice breaker lesson, cover lesson etc. Can be used at the start of a new topic - students should then be told to create the A-Z using relevant words about that topic.
Alphabet Task
This is a paper based starter in which students are simply asked to write down an ICT related word for each letter.
.
Attach a You Tube Video to a Presentation in MS2007
The following resources will help you to attach specifice video from You Tube to a PowerPoint presentation in Microsoft 2007
China aims to become supercomputer superpower
China is ramping up efforts to become the world's supercomputing superpower.
Read the full article: http://news.bbc.co.uk/1/hi/technology/10181725.stm
China is ramping up efforts to become the world's supercomputing superpower.
Christmas Activities
A collection of ICT related activities for students to keep students busy on the wind down to Christmas.
Advent Calendar
Students can use this template PowerPoint or higher ability students could create one from scratch. Students should put images, information, games and quizzes (word searches etc.) on each slide. These can then be printed and taken home by students.
Christmas Quiz
A 35 question Christmas Quiz!
Fun Christmas Quiz
A fun Christmas quiz that can be done as a whole class.
Santa's Spreadsheet
Studens are given a scenario in which santa needs to work out whether his income (generated through selling the mince pies etc. left out by the people he visits) is enough to cover his spending (the cost of presents, elf wages etc.)
A template spreadsheet is provided for students and a completed spreadsheet including formatting etc. is provided for teachers.
Cinema Booking System Model
SKU: 0134
A complex spreadsheet that models a cinema booking system.
You can use this to showcase the simple elements with weaker classes or get confident classes to attempt to fully recreate it. This file should be used as an example to demonstrate to students how to build their own. Techniques students will develop in order to build a similar model include:
• Merging Cells
• Formatting Cells (colour, font size, centre alignment)
• Borders
• Conditional Formatting
• Data Validation (Selection from a drop down list)
• SUM function
• The IF function to display a 'sold out' message
• The COUNTIF function to count the number of booked and available seats
• Selecting data from another worksheet
Price: £1.49
Countdown Game
Source: http://www.subtangent.com
Play the popular numbers & letters game. Carol could not appear, alas.
GPS and GIS
What are GPS and GIS and how can you use them in lessons? Check out the attached presentation for some ideas.
How many days old are you?
This fun excel workbook works out how many days old you are. Great for a quick starter or plenary to demonstrate the power of spreadsheets.
How to use Goal Seek in Excel
Here is a quick guide that explains the basics of goal seek.
Interesting Ways to use an iPad in your classroom
58 Interesting ways to use an iPad in the classroom.Learning Dreamweaver
The first task is to learn how to use Cascading Style Sheets in Dreamweaver. This is covered in the next three documents. Load Part 1, 2 and 3 and work through the tasks.
Part 1: This covers the setting up of a Dreamweaver web site.
Part 2: This covers setting up a cascading style sheet (CSS).
Part 3: This covers how to apply a CCS to web pages.
Logo Starter
If your designing a logo u could use this as a starter. There a famous brands and logos that have been cropped. what the pupils have to do is try and guess what brand/logo are.
Newspaper Template
A newspaper template that can be used by students to produce publications on any subject. A Word and Publisher version are included.
Ofcom unveils anti-piracy policy
Lists of Britons who infringe copyright are to be drawn up by the UK's biggest ISPs, under proposals from the regulator Ofcom.
Read the full article: http://news.bbc.co.uk/1/hi/technology/10183820.stm
Ofcom unveils anti-piracy policy
Picto Selector - Visual Learning Resources Software
Picto Selector is a freeware Windows program designed to help teachers create visually appealing resources for students. Particulally useful for visual learners and those on the autistic spectrum. Time consuming tasks such as creating timelines, action plans, behavioral maps etc. can be done much faster.
Parents can use it to visualize daily tasks.
Teachers can use it to create workbooks: clocks, writing (write
down the name of the animal in this picture etc.) or create a sheet with
photos and names of all the students
AAC trainers can use it to create overlays for communication
devices
You can download the software free from www.pecsforall.com
Print preview of a picto sheet
Podcast Planner
This is a planning document for a radio podcast. This could be used for KS3 lessons or during an ICT club. The scripts can then be used to prompt students when recording their podcasts.
Prezzi
Prezzi is the new Powerpoint! Online, interactive, fun and easy to use. Here are some hints and tips.
QR Codes
QR Codes. What are they and how can you use them in the classroom? See the attached presentation for some interesting ideas.
Revision Mapping
Here's a really good maind mapping / brain storming / thought showering offering from BBC Bitesize:
http://www.bbc.co.uk/schools/gcsebitesize/maps/index.shtml
.
Smokescreen
Smokescreen is a cutting-edge game about life online. We all use Facebook, MySpace, Bebo and MSN to keep up with our mates - and we've all heard the stories about parties on Facebook being mobbed, or people getting stalked on MSN. The question is, what would you do if it happened to you?
The site is a great resource to show in a citizenship or PSHE lesson, as well as whole school meetings to discuss cyberbullying and online safety.
Over 13 missions, Smokescreen follows the story of Max Winston and Cal Godfrey, two mates who've set up an exclusive social network called White Smoke. After Cal's involved in a car accident and falls into a coma, White Smoke becomes huge - and starts attracting huge problems. Each mission sees you explore the world of White Smoke, and find out who you can trust - and who you can't.
Play the game at http://www.smokescreengame.com/
Spreadsheet Football Stadium Model
Here is the makings of a fun spreadsheet model to learn about conditional formatting and formulas. It needs tailoring to your own requirements but the majority of the work is done.
*Updated* - A guide sheet is now included. This isn't really explicit; instead students should try to figure things out for themselves using the 'Help' feature and Google. Students could try to produce their own stadium working in small groups.
.
Spreadsheets Starters
Just some starters I have created and prepared to share, the students seem to enjoy them and it helps with spelling and becoming familiar with ICT terminology.
Techy Tips For Not So Techy Teachers
Techy Tips For Not So Techy Teachers
World Cup 2010 Resources
A selection of ICT World Cup themed resources.
Euro 2000 Football Stadiums Database Task
Football Shirts
The football shirts worn by the World Cup 2010 teams.
Making A World Cup Planner
This resource, along with related interactive learning games, was originally published at http://www.what2learn.com/world_cup_2010/
Ode To The Spellchecker
This resource, along with related interactive learning games, was originally published at http://www.what2learn.com/world_cup_2010/
In this exercise students will create an accurate document suitable for publication.
Learning aims:
To recognize the problems in being over-reliant on spellcheckers
To learn how to present text in columns
To develop understanding of how to position graphics and text to create an effective layout.
Lesson outline:
To help students understand that spellcheckers cannot be trusted begin by showing the presentation ‘ode to the spellchecker’. After discussion of the presentation students should be given a copy of the ‘word processing instructions’ sheet and directed to open an electronic copy of the document ‘Ronaldinho fails to make the cut’. They should begin by trying to find the fifteen mistakes in the document – by highlighting the errors (none of which will be highlighted by spellchecker) they will be able to keep count of the number they have found. A whole-class focus on what the mistakes are should follow. Students should then follow all instructions on the rest of the worksheet.
Racism in Football
A cross curricular activity looking at racism in football. This PowerPoint contains information, quotes and points for discussion before students complete ICT related tasks including writing a letter to the football authorities about racism and designing a racism awareness poster for the World Cup 2010.
Original resource by Claire Davis
Soccer City Stadium Google Street View
World Cup 2010 Brochure
Students should use the attached Publisher template to design a brochure containing information about the 2010 World Cup. This could include details about the teams, players, accommodation, South Africa etc.
World Cup 2010 Spreadsheet
A great spreadsheet with all the groups for the 2010 World Cup. Students can change the fonts and colours, enter the formulas to work out the points total and goal difference and try to hyperlink the country's flags to the relevant Wikipedia articles.
World Cup Database
A Microsoft Access database of the countries taking part in the 2010 World Cup. The database includes the country name, three letter country code, capital city and currency used.
You can ask students to create queries to search for all countries that use the Euro for example or create a report and sort in alphabetical order.
World Cup Group Project
The activity involves co-operative learning groups who pretend to be travel agents, each given their own set of customers , researching and planning a trip to South Africa! they learn the process of booking planes, searching for hotels for suitable dates, comparing prices, using online converters to convert rands into pounds and putting it all together into a PowerPoint presentation to present to their peers. My class loved the context and learned a great deal of ICT skills as well as South African geography from Google maps and places to visit. There was also a continuous emphasis on meeting their customers criteria which allowed them to critically think of others needs and preferences.
World Cup Internet Research Quiz
A quiz that students should attempt to complete by using the Internet to find the answers! Students could then try to produce their own similar quiz.
Focus can be given to the design and layout as well as the questions.
World Cup Photos
Some fantastic photos taken during the opening weekend of the 2010 World Cup in South Africa. These photos could be used by students when designing tickets, posters, shirts, brochures, PowerPoints etc.
Source: http://www.boston.com/bigpicture/2010/06/opening_weekend_-_2010_world_c....
A man watches the opening match of the 2010 World Cup between South Africa
World Cup Presentations
Several World Cup 2010 PowerPoint templates that can be used by students to carry out research into the World Cup and present back to the class.
World Cup Quiz
Guidance for student to follow.
The task involves students creating quizes for each other about the World Cup, football and the countries involved.
Students then swap quizzes with someone else in the classroom and attempt to find the answers using the Internet.
World Cup Ticket Design
This resource, along with related interactive learning games, was originally published at http://www.what2learn.com/world_cup_2010/
World Cup Tracking Spreadsheet
A tracking spreadsheet for round 1 and round 2 of the 2010 world cup.
Year Dot: Not Going To Uni
Taken from the Year Dot documentary. This series of videos follows Tom Mursell as he sets up his own website and business http://www.notgoingtouni.co.uk
Follow his progress online at http://www.yeardot.co.uk/whoweare-12/tom-mursell.html