Teach ICT - New Pages

a

Anonymous — Tue, 20 Nov 2007 06:31:42 CST

A-C

Term	Definition

D-G

Term	Definition

H-L

Term	Definition

M-Q

Term	Definition

R-Z

Term	Definition

Link To Other Resources

Anonymous — Sat, 13 Oct 2007 03:03:41 CDT

The sharing of ICT Resources is ever growing and here are a few other places you may enjoy looking:

GH ICT Wiki

Unit 7.4 - Lesson 1: Alternative, SHS

MrC — Thu, 11 Jan 2007 11:24:29 CST

Learning objectives;
By the end of the lesson students should be able to;

List the benefits of using a spreadsheet
Demonstrate that they can use the fill handle correctly
Identify the different parts of a spreadsheet
Create a formula

Stand behind chairs, race to log on – first to the front, take register

10 mins Starter
Hand out zoo activity on paper – first example, explain how to work out, see who can finish this first. Then add in some changes – Elephants standing on snakes, alligators eating sea lions and eagles flying away. Bring back to front, show zoo activity spreadsheet – make changes on this. Which cells change? What is the benefit of using a spreadsheet? ·

Easy to make changes ·
Automatic calculations ·
No mistakes

Show learning objectives

10 mins Spreadsheets are clever –
using the fill handle Show how to open a blank worksheet, show how it is possible to add text numbers into cells. Put somebody’s name into the cell, put the day in and the month and the date. Use the fill handle to demonstrate the different effects. Add a sequence number, how does the spreadsheet know what to do? Begin to set up a times table square, do 1 and start 2. Students to experiment with fill handle

10 mins Parts of a spreadsheet –
use zoo activity Use powerpoint or IWB to identify; row, column, cell, cell reference, worksheet, text label, numeric data, formula Redo formulas on zoo activity sheet to explain how they work, then use fill handle to copy down formula what will happen?– explain that the shape of the formula is copied.

10 mins Football league
Show students where to find football league table. Set them the task of adding five more teams (make them up if not sure) and putting in some numbers for the wins, losses and draws. Challenge them to create a formula to calculate the games played. 10 mins How to do the points? Ask for suggestions on how to do this – then demonstrate solution and copy down. Lastly demonstrate how to sort the table.

Extension Add the points on the sheet in two different places. Change the formula to use cell references instead of numbers. Explain absolute cell referencing.

10 mins Plenary
Use hotpots to assess learning

Unit 7.4 - Lesson 1: DFES STU

Anonymous — Thu, 11 Jan 2007 11:17:15 CST