Session 7
Outcomes

By the end of the session you should:

have knowledge of pupils' progression in data handling (related to Finding Things Out thread of National Curriculum
looked at resources needed to teach data handling
investigated branching databases
looked at examples of the use of data handling

have knowledge of pupils' progression in ICT, related to NC levels and strands
considered the reasons for assessment - formative/summative
have looked at some tools for recording pupils' progress

become more familiar with spreadsheets: understanding some of their possible uses.

Data handling in the National Curriculum

Look at the list of units in the QCA Scheme of Work - list the units which you think are concerned with handling data.
Compare your list with your neighbour
Look at the "Where the unit fits in" section to check your thoughts
group consensus

Look at the resources needed to teach these units - does creating a pictogram require a specialised program?Promethean Flipchart (will only open if you have Promethean software installed - save as and change the suffix to .flp)

Branching Database

Sorting games from NAACE Primary, followed by looking at Textease branching database.

Conventional data handling application

Whodunnit - click here to re-visit the NAACE Primary site, and select Whodunnit?

Functions of a database:

Sorting
Searching
Graphing

Spreadsheet modelling

Information and Communication Technology in the National Curriculum.

QCA Unit 5d -Modelling - cost of a party - a file I prepared earlier!
QCA Unit 6B

Assessment of ICT

NC level expectations (i.e. level most children should achieve at end of each KS)?
Advice on assessment from QCA
Paper exercise - matching pupils' work to attainment level. The examples used have been taken from the National Curriculum in Action website.
Types of assessment document from N.E. Lincs

Implications to consider when assessing pupil progress in ICT

This page is an index to other assessment documentation from N.E. Lincolnshire (the "Assessing pupil progress.." documents are particularly useful).

Spreadsheets

What are they? - a brilliant tutorial from Brad James (University of South Dakota)
Collecting information- use >GroupInfo
Performing calculations- create file to calculate area and perimeter of a rectangle - or average height of group
Displaying information in graphs (charts)back to group info file

Session 7 Outcomes