The Oxfordshire ICT Scheme of work Year 4

Everything Bold is the statutory links from other NC subjects
Everything Italic is a suggested subject link through which an aspect ICT could be taught

You have to decide when you are teaching the various components – some are short tasks, other may take several weeks. Many of them will slot easily into your rolling programme – other sections may require discrete ICT teaching.

Any activities on this sheet can have your own substitutions slotted in to fit your topic – a blank scheme outline where you can build in all of your own activities is available.

QCA 4A Writing for different audiences.

QCA 4B Developing Images

QCA 4C Branching Data Base

QCA 4D Collecting and presenting information: questionnaires and pie charts (second sheet)

QCA 4E Modelling Effects on Screen

QCA 4B Developing Images

Learning Objectives

Activities

Subject Link

Resources

Learning Outcomes

Graphics

· To be able to use a range of visual effects such as reflection and symmetry.

· To be able to use stamps and/or copy tool.

· To be able to select areas, copy and resize them.

· To be able to use save as to keep draft copies.

Art and Design 5c

· To be able to develop the knowledge, skills and understanding through using a range of materials and processes including ICT.

Maths: Shape Space and Measures

· To be able to transform images using ICT.

QCA 4B Developing images using repeating patterns

Using a digital image as a starting point use a variety of tools to create a collage.

Art

Maths

Art and Design 1c, 2b 5d

Maths Shape Space and Measures 3b,1c

RM Colour Magic

Scanner

Digital camera or clipart

Can use editing skills for visual effects (reflection and symmetry).

Can use copy.

Can use a variety of materials created on and away from the computer and manipulate or arrange them to make a final image.

Most children will be able to use a computer graphics program to develop an image using a variety of tools.

Back to the SoW menu page

Computer Aided Design

Learning Objectives

Activities

Subject Link

Resources

Learning Outcomes

Graphics

· Select Computer Aided Design (CAD) tools of line, new line and grid.

· To understand how IT enables the design in terms of accuracy, efficiency and the ability to draft and redraft.

Design and Technology 2e

· To be able to use finishing techniques to strengthen and improve the appearance of their products using a range of equipment including ICT based sources.

Use CAD tools to create nets for different boxes as part of work on packages.

Maths

Design and Technology

Design and Technology 2e

FlexiCAD 2

Selection of boxes opened up to illustrate nets.

Can use CAD tools to create objects.

Most children will be able to use a computer graphics package to develop an image using a variety of tools; be able to create objects using an object based graphics package.

Back to the SoW menu page

QCA 4A Word Processing

Learning Objectives

Activities

Subject Link

Resources

Learning Outcomes

Word Processing/DTP

· To be able to delete, insert and replace text.

· To be able to use cut and paste within applications to reorder text.

· Combine text and graphics

· To be able to use a spellchecker.

· To be able to amend text using find and replace.

· To develop an increasing awareness of intended audience.

English: Writing 2

· To be able to develop their ideas on paper and on-screen including the skills of planning and proof reading.

History 5c

· To be able to communicate their knowledge and understanding of history in a variety of ways.

QCA 4A Writing for different audiences.

Create a set of documents, about the same historical event, eg:

poster, flyer, newspaper article, brochure

English

History

Geography

Science

Design and Technology

Writing 2

Writing 1,2

History 5c

First Word

Publisher

Newspaper articles

Text files

Can cut, copy and paste, move within document to produce a coherent sequence of events.

Begin to combine simple text and graphics.

Can delete, insert and replace text to improve clarity and create mood.

Show increasing awareness of intended audience – Recognise features of good page design.

Most children will be able to use the advanced features of a word processor to help them match their work to their audience.

Back to the SoW menu page

E-mail

Learning Objectives

Activities

Subject Link

Resources

Learning Outcomes

Word Processing/DTP

Email:

· Read, annotate and reply to email.

Take part in e-mail, Net day projects.

Communicate with other schools and develop links with foreign countries.

English

Geography

Writing 11

Geography 3f

Internet Service Provider

Email program

Read, annotate and reply to e-mail.

Most children will be able to send, receive and reply to e-mails.

Back to the SoW menu page

Music

Learning Objectives

Activities

Subject Link

Resources

Learning Outcomes

Music

· To be able to edit musical phrases, by adding or deleting phrases or notes.

Music 5d

· To develop the knowledge, skills and understanding of music through the use of ICT to capture, change and combine sounds.

Experiment with different sounds to create jingles. Perform and amend in light of performance.

Music

Music 5d

Music 4c

Tape recorder

Microphone

Music Explorer

Can use editing skills to present/organise/reorganise sounds/musical phrases.

Can create save, retrieve and record sounds.

Most children will be able to develop and refine a musical composition and adapt in the light of a performance.

Back to the SoW menu page

Modelling

Learning Objectives

Activities

Subject Link

Resources

Learning Outcomes

Modelling

· To be able to enter data into a computer simulation.

· To begin to make accurate predictions.

· To be able to enter different values into a spreadsheet.

Maths: Number

· To be able to recognise, represent and interpret simple number relationships, constructing and using formulae in words then symbols.

See also Control Year 4

Modelling effects on the Screen

Using a CD ROM simulation such as Castle Explorer ask the children to explore a castle. They have to interact with other occupants to arrive where they want to get to.

As part of a topic on the Romans, tell the children they are going to plan a Roman feast for a visiting Senator. Using a prepared spreadsheet eg Party* give the children a budget and ask them to calculate the cost of the feast by changing variables such as the number of guests attending. Ask them to comment on the results, eventually making predictions about the effects of the changes.

Explore a prepared spreadsheet eg Find my Rule* to explore number patterns and/or simple rules.

Construct and use a formula to transform one list of data to another.

History

Geography

Science

Maths

Maths:

Number 4d

Maths Solving Problems

CD ROMs:

DK Castle Explorer

Logical Journey of the Zoombinies

Excel

RM Number Magic

Dig

* Spreadsheet Activities for KS 1 – 3 published by OQSA.

Can investigate different options in a model or simulation.

Can enter and change data in a simple model.

Beginning to make decisions whilst using a model or simulation and trying to predict the outcome.

Most children will use a spreadsheet to explore different models and investigate patterns and rules.

Back to the SoW menu page

QCA 4C Branching Data Base

Learning Objectives

Activities

Subject Link

Resources

Learning Outcomes

Finding Things Out

· To understand that a tree diagram can be used to organise information.

· To be able to search a branching data-base.

· To be able to create a simple branching data base.

Maths: Processing, Representing and Handling Data

· To be able to represent and interpret discrete data using graphs and diagrams, including pictograms, bar charts and line graphs, then interpret a wider range of graphs and diagrams, using ICT where appropriate.

Science: Scientific Enquiry

· To be able to use a wide range of methods including diagrams, drawings and ICT to communicate data in an appropriate and systematic manner.

QCA4C Branching data bases

Investigate properties of different types of: food; tree types; minibeasts

Maths:

Processing, Representing and Handling Data 2c

Science 2h

Science Life Processes 2b, 4a

FlexiTREE

Decision Tree

Can search a branching database to identify objects.

Can produce a tree diagram.

Most children will be able to develop and search a branching database.

Back to the SoW menu page

Using the Internet

Learning Objectives

Activities

Subject Link

Resources

Learning Outcomes

Finding Things Out

CD ROMs and Internet:

· To purposefully navigate a CD ROM or Internet page.

· Begin to use search engines and URLs.

Use the Internet to find out information related to various topics.

Study a contrasting locality

Look for examples of the work of William Morris. In groups find the names of two Impressionist painters. Print off a copy of your favourite painting to share with the other groups.

Use CD ROMs or the Internet to research scientific topics that cannot be directly observed eg the heart, skeleton, sun, moon, and earth.

History

Science Geography

Art

Design and Technology

Geography 2d,3d,3f

Art and Design 5d

Science: Life Processes 2c,2e,2f,5b, Materials and their properties 2e, Physical Processes 4b,4c,4d

Reference CD ROMs

Internet Web Browser

www.bbc.co. uk/education

CD ROMs

Human Body

Being a Scientist

Space and the Universe

Can search a CD ROM or Internet page using hot/hyperlinks.

To begin to search using search engines.

Most children will be able to search a CD ROM or Internet page purposefully following straightforward lines of enquiry.

Back to the SoW menu page

Finding Tings Out

Learning Objectives

Subject Link

Resources

Learning Outcomes

Finding Things Out

English: Reading

7a, 9b

·        To be able to read a range of materials including print and ICT based reference and information materials (eg dictionaries, encyclopaedias, CD ROMS, Internet)

History

4a,4b

·        To be able to find out about the events, people and changes studied from an appropriate range of sources including ICT based sources.

·        To be able to ask and answer questions and to select and record information relevant to the focus of the enquiry.

Use the Internet to find out information related to various topics.

Research information relating to a specific topic eg Roman roads using BBC Education pages. Use the information to answer questions and produce topic work.

English:

Reading 7a, 9b

Reading 2a

History 4a, 4b

Reference CD ROMs

Internet Web Browser

www.bbc.co. uk/education

Can search a CD ROM or Internet page using hot/hyperlinks.

To begin to search using search engines.

Most children will be able to search a CD ROM or Internet page purposefully following straightforward lines of enquiry.

Back to the SoW menu page

QCA 4D Collecting and presenting information: questionnaires and pie charts

Learning Objectives

Activities

Subject Link

Resources

Learning Outcomes

Finding Things Out

·        To be able to design a simple questionnaire to record numbers, text and choices.

·        To be able to add records and fields to a file.

·        To use ICT to create and interpret pie charts.

·        To understand that pie charts can be used to make comparisons.

·        To use ICT to create line graphs.

·        To understand that line graphs can be used to show continuously changing information.

History 4b

·        To be able to ask and answer questions and to select and record information relevant to the focus of the enquiry.

QCA 4D Collecting and presenting information: questionnaires and pie charts

Maths

Science

Geography

History

History 4b

Information Workshop / or Magic

First Workshop

Excel

Can design questionnaires, which match the structure of the database.

Be able to add information to a file.

Can present and interpret a range of appropriate graphs to answer a simple question.

Most children will be able to collect data in a way that aids entry into a data handling package and use it to create bar charts, pie charts and line graphs.

Back to the SoW menu page

QCA 4D Collecting and presenting information: questionnaires and pie charts

Learning Objectives

Activities

Subject Link

Resources

Learning Outcomes

Finding Things Out

Maths: Processing, Representing and Handling Data 2c

· To be able to represent and interpret discrete data using graphs and diagrams, including pictograms, bar charts and line graphs then interpret a wide range of graphs and diagrams using ICT where appropriate.

Science: Scientific Enquiry 2h

· To be able to use a wide range of methods including diagrams, drawings and ICT to communicate data in an appropriate and systematic manner.

QCA 4D Collecting and presenting information: questionnaires and pie charts.

Maths:

Processing, Representing and Handling Data 2c

Science: Scientific Enquiry 2h

Can design questionnaires, which match the structure of the database.

Be able to add information to a file.

Can present and interpret a range of appropriate graphs to answer a simple question.

Most children will be able to collect data in a way that aids entry into a data handling package and use it to create bar charts, pie charts and line graphs.

Back to the SoW menu page

QCA 4E Modelling Effects on Screen

Learning Objectives

Activities

Subject Link

Resources

Learning Outcomes

Control and Measurement

· To be able to write a list of commands to produce a pre-drawn shape.

· To be able to record instructions.

· To be able to use the repeat command.

· To be able to use increasingly more sophisticated sequences of instructions eg pen up, pen down, set pen colour.

Maths:

Shape Space and Measures 1c

· To be able to approach spatial problems flexibly, including trying alternative approaches to overcome difficulties.

QCA 4E Modelling Effects on Screen

First three short focussed tasks

Maths

Maths: Shape Space and Measures 1c, 2c

Super Logo

Can write a series of instructions to produce a pre-planned route or shape.

Can record instructions and use these to begin to correct mistakes.

Can use the repeat command to produce regular shapes.

Can use increasingly sophisticated sequences of instructions involving repeat, pen up, pen down.

Most children will be able to program a screen turtle to produce a regular shape and be able to move the screen turtle without drawing a line.

Back to the SoW menu page