|
Link to Intranet
Year 9 Pastoral
Staffordshire
LEA
Staffordshire
Careers
OfSTED
QCA
UCAS
C4 Homework
Help
Feedback on this site
can be forwarded to the
webmaster
| |
September 2004
|
Information & Communication Technology - YEARS 10 and
11
By Option - Long Course
Time allocation - 3
periods per week
Areas of study
|
Examination |
Year |
Modules |
Form of Assessment |
|
1 CLAITPlus |
10 |
Unit 9 - Graphs & Charts, |
OCR set Assignment |
|
Unit 6 - Computer Art, |
OCR set Assignment |
|
Unit 1 - Use of a Computer - Compulsory module |
OCR set Assignment |
|
Unit 3 -Databases, |
OCR set Assignment |
|
11 |
Unit 13 - Presentation Graphics Solutions |
‘Solutions’ |
|
Unit 16 - Web Page Solutions |
‘Solutions’ |
|
OR |
|
|
Unit 17 - MICROSOFT OFFICE SPECIALIST Word - Core Level
|
On-line test |
|
Unit 18 - MICROSOFT OFFICE SPECIALIST Excel - Core Level
|
On-line test |
|
Homework. Students will be
required to complete one assignment each term (total of 5). |
Year 10
|
|
The topic will be specified and presented in a
specific format to complement the work you have been doing for the
examination modules |
Year 11 – with ‘Solutions’ Modules
|
|
The topic will be specified and presented in a
specific format to complement the work you have been doing for the
examination modules. |
Year 11 – with ‘Microsoft Office Specialist’
Modules
|
|
Consolidation tasks from the courseware books
supplied. |
Resources
Where available, groups will be allocated to a Computer Resource area
containing a minimum of 15 stations
For CLAITPlus - Stage II
Each CRA contains:
 | a class set (15 min) of the CLAITPlus student
books. |
| sets of Sample Assignments for at least two
CLAITPlus past Assignments. |
| a Teacher's Reference Manual for CLAIT Plus. |
| the 'In-House' help files are available through the
Intranet, |
Assessment
For CLAITPlus - Successful completion of the Compulsory
Module plus 3 further modules will earn an CLAITPlus Pass.
Assessments take place during the Lunch period on at least one day, each
week, in each CRA, when the room is specifically reserved for this purpose.
Pupils must book for assessment of each module as and when their
teacher declares that they have completed the necessary tasks for each
module.
Suggested Approach
Administration:
Each group should have:
| a ring folder for each pupil,
|
| a file record sheet for each
pupil, |
| a set of printed labels for the
group, |
| an attendance register for the
group, |
| a mark record sheet for the
group, |
|
Time-scale:
|
Term
one: CLAITPlus -
Stage II
|
Databases - group taught - with
reference to the 'In-House' help files |
| Use 'Build Up Exercises' Tasks 1-3 from
CLAITPlus student books |
| Pupils then use Practical
Assignments 1 and 2 to consolidate their skills |
|
|
Databases
- Covering: |
1 create and save database
-
set up field names
-
set up data types for fields
-
format fields
-
set appropriate field lengths
-
enter records
-
save table/query/report
|
|
understand
the structure of a database and how it is
created |
|
understand how to set the
format of different field types
e.g. number - integer, fixed, date - dd/mm/yy |
|
understand the importance of
entering data accurately |
|
appreciate the need for
efficient data structures and be
able to set appropriate field length |
|
understand the purpose of
encoding data in an efficient
manner |
|
understand the use and
purpose of various field types (text, number, date/time,
currency, auto number logic field)
|
|
2 format reports
-
alter margins/page orientation
-
use page headers and footers
-
align data
-
insert automatic fields
into headers/footers (page number,
date)
-
insert titles and group headers
|
|
understand how to alter
margins and page orientation |
|
understand the use and purpose
of headers and footers |
|
understand how to align data in
reports |
|
understand the use and
purpose of using automatic fields
(filename, page number, date) in headers and
footers |
|
understand the importance, use
and purpose of titles |
|
understand the use and purpose
of group headers |
|
3 import and interrogate
database
-
import/open datafile
-
add/amend/delete
records/fields
-
use logical operators in
queries
-
use range operators in queries
-
combine search criteria using
logical operators
-
use a calculated field
|
|
understand how to open/import data from
generic files and appreciate why
it might be in that format |
|
understand the use and purpose of adding,
amending and deleting records and
fields |
|
understand the advantages of using the
search and replace functions over
manual methods to find and replace
specific data |
|
understand the use of multiple
search/filter criteria in the
selection of a subset of records |
|
understand the use of range criteria in
selecting data (<, >, <=, >=,
=,<>) |
|
understand the use of AND, OR
and NOT |
|
understand the use and purpose of using
combined logical and range
operators when defining search
criteria (eg >= 16 AND <= 18) |
|
understand the use and purpose
of calculated fields |
|
understand the use of wild cards when
searching for data (*, ?, #)
|
|
4 present and print data
-
data is displayed in full
-
data presented in
specified field order
-
sort data
-
use search results to
produce a report
-
data is presented in
table/list format
-
data is presented in group
format
-
data is presented in
record/columnar format for
label printing
-
display summaries
|
|
understand the effects on
data of different types of sorting
(alphabetical, numeric, chronological) |
|
understand the production
of reports/queries displaying
fields and records in a specified order |
|
understand how to select
and use a variety of report
formats |
|
understand how to produce group
summaries |
|
|
Term
two:
CLAIT Plus - Stage II
|
Graphs & Charts
- group taught - with reference to the 'In-House' help
files |
| Use 'Build Up Exercises' Tasks 1-4
from CLAITPlus student books |
| Pupils then use Practical
Assignments 1 and 2 to consolidate their skills |
|
|
Graphs & Charts
- Covering: |
1 select and control source data
-
open/close/save data file
-
select single data set
-
select comparative data set
-
select subset of large data set
-
select data set from nonadjacent
columns/rows
|
|
understand how to open data from
generic files and
appreciate why it might be in that format |
|
understand how to select a
variety of data sets for
display in graphical form
distinguish between data sets presented in column
format and row format
|
|
understand how to select a
subset of data from a large
data set and how to select data
from non-adjacent
columns/rows |
|
2 present data using graphs and
charts
-
use exploded pie chart
-
emphasise pie chart
segment(s)
-
use bar/column chart for large
comparative data set
-
use line-column graph
-
use xy scatter graph
|
|
distinguish between exploding
pie charts, bar/column
charts, line-column graphs and XY scatter graphs and
understand how to create them
|
|
understand the importance of
emphasising particular
data |
|
understand how to compare many
sets of similar data
using bar/column chart |
|
understand that lines and
bars/columns can be
displayed on one graph |
|
understand the different uses of
scatter graphs (plot data
to identify trends, plot a definite relationship
between two variables x and y)
|
|
3 set parameters of graphs and
charts
-
select/enter titles, and axis
titles
-
select and display data labels
-
apply/remove legend
-
set upper/lower limits and
intervals on axes
-
insert trend line
-
insert trend line equation
-
insert and position text box
|
|
distinguish between titles, axis
titles, labels and
legends and understand how to set them |
|
understand the need for a legend
to correctly identify the
data series displayed on chart |
|
understand how to amend the
graph/chart to display
specific upper and lower limits and intervals on x and
y axis |
|
understand how to apply a linear
trend line to a scatter
graph |
|
understand how to display the
equation of a linear
trend line on a scatter graph |
|
understand how to use text boxes
on a graph/chart to
display additional information |
|
4 format graphs and charts
-
follow house style
-
apply superscript/subscript
effects
-
apply specific numeric
formatting on axes
-
apply/remove background fill
to/from plot area
-
apply fill to bars in data
series
-
join scatter points together
with a line
-
set style and weight of lines
-
apply/remove markers to/from
lines
|
|
understand how to format font
styles, font sizes and
use emphasis in titles, axis titles, data labels,
legends, trend line equations
and textboxes and |
|
understand how to add
header/footer to a
graph/chart |
|
understand how to apply
superscript (x2) and
subscript (H2O) effects to labels |
|
understand how to format the
display of numeric data
on axes (currency, decimal places, date,
negative numbers in red, minus
sign) |
|
understand how to apply/remove
background fill to/from
plot area |
|
understand how to apply a fill
to all bars belonging to
a specific data series |
|
understand how to join points of
a scatter graph together
to show xy relationship |
|
understand how to set style and
weight of lines displayed
on graphs and charts and apply/remove
markers |
|
|
5 print graphs and charts
-
print graphs/charts in landscape
-
print graphs/charts in portrait
|
|
distinguish between landscape
and portrait orientation and understand how to set orientation before
printing |
|
|
Term
three:
CLAITPlus - Stage II
|
Computer Art,
- group taught - with reference to the
'In-House' help files
|
| Use 'Build Up Exercises' Tasks 1&2
from CLAITPlus student books |
| Pupils then use Practical
Assignments 1 and 2 to consolidate their skills |
and
|
Use of a Computer -
(Compulsory module) - group taught - with
reference to the 'In-House' help files |
| Use 'Build Up Exercises'
Tasks 1&2
from CLAIT Plus student books |
| Pupils then use Practical
Assignments 1 and 2 to consolidate their skills |
|
|
Computer Art,
- Covering:
|
1 create artwork incorporating
text and images in layers
-
set artwork size
place text and
images according to a design brief
layer items
enter text
|
|
understand how to create
artwork of a specific size and
appreciate the effects of resolution on printed
outcome |
|
understand how to place text and
images |
|
understand the purpose of
and how to follow a design brief
|
|
understand the use of
layers in producing artwork
understand how to insert text |
|
2 edit and retouch scanned
images
-
remove dust and scratches
-
remove unwanted content
apply colour
correction/amendments
|
|
understand how to use
graphic techniques to remove dust
and scratches from an image, remove red-eye and
remove/replace unwanted image content
|
|
understand the use of
common paint tools (paintbrush,
aerosol, eraser, clone brush, paint bucket) and
selection tools (lasso, marquee,
magic brush) |
|
understand how to alter colour
values (hue, saturation,
lightness) |
|
3 use a variety of graphic
effects
-
apply an image mask
-
set image transparency/applymode
-
use solid/gradient/pattern fills
-
apply drop shadow
-
format text colour and shape
|
|
understand how to
adjust the transparency mode of a
layer to create different effects (eg multiply, darken,
lighten, % transparency)
|
|
understand how to mask
areas of an image and appreciate
the advantages of masking instead of
erasing |
|
understand common graphic
effects such as drop shadow and
fills (gradient, pattern or solid colour) |
|
understand how to sketch, skew,
or transform text |
|
4 create animated image for
electronic media
create
new animation
-
create individual frames
using text, images and graphic
shapes
-
set duration of frames
-
set animation size
|
|
understand how to
create an animation of a specified
size |
|
understand how to use
common drawing/painting tools to
produce simple frames/cells of graphics and
text |
|
understand how to produce
subsequent frames of animation in
chosen software (eg individually or by
automatic process) |
|
understand how to set the
duration of frames in an animation
|
|
5 prepare artwork for
print/electronic publishing
-
set resolution
save artwork/animation in
appropriate format
print full colour proof
display crop marks
produce screen print
|
|
understand print
resolution and appreciate the relationship with print size |
|
appreciate common file formats
for print/electronic artwork (eg encapsulated postscript/animated gif)
and understand how to produce them in chosen software |
|
understand the use and purpose
of crop marks |
|
understand the use and purpose
of full colour proofs |
|
understand the use and purpose
of screen prints |
|
|
Use of a Computer - ( Compulsory module)
- Covering: |
1 manage files and
directories/folders
-
create and name
directories/folders
-
open/close/save files
-
delete files and
directories/folders
-
move files and
directories/folders
-
copy files and
directories/folders
-
rename files and
directories/folders
-
print file structure
|
|
understand common
generic methods for accessing
files and directories/folders |
|
understand how to create, name
and rename |
|
directories/sub-directories/folders |
|
understand the use and
purpose of copy/move/delete files
|
|
understand how to save
files/documents |
|
understand how to access
existing files (text, database,
spreadsheet, image/chart) |
|
identify and access appropriate
software for the task |
|
understand the procedures
for producing printed evidence of
directory/folder contents |
|
distinguish between
documents/files and executable
applications and appreciate the function of file
extensions |
|
2 select and enter data
accurately from data input sheets and amend existing data
-
enter text/numerical data in
specified format
-
enter dates in specified format
-
encode specified data
make amendments to document
use software facilities to check
spelling
|
|
understand the need
for accurate data entry in the
production of documents and the importance of
proofreading both on-screen and on
printed output |
|
understand the use and
purpose of using specified English
date formats (day, month, year) |
|
understand the use and
purpose of using codes for
efficient data entry |
|
understand how to amend a
document (e.g. move, delete, insert, copy) |
|
understand the purpose and
limitations of spellchecker and grammar-checkers |
|
3 create and print an integrated
document create a new document
-
import/open a generic text file
-
import data file
-
import image
-
import chart
-
print integrated document
|
|
understand the procedures
when transferring data between
files |
|
understand the need for
presenting documents as specified
|
|
understand how to import,
place and format text and data
files, images and charts and appreciate why it
might be in that format
|
|
understand the importance
of maintaining the original
proportions of images and charts |
|
understand the importance
of maintaining the integrity of
imported data |
|
4 format page layout and
manipulate text according to a house style
-
set page orientation
-
set up page layout
-
insert headers and footers
insert automatic fields in
headers/footers
apply house style
use bullets/numbering
use special symbols
search and replace
|
|
understand the use and
purpose of changing page orientation |
|
understand the use and purpose
of headers and footers |
|
understand the use and purpose
of including automatic fields in headers and footers |
|
understand the purpose of and
adhere to a specified house style |
|
understand the major layout and
formatting functions of word processors (page breaks, paragraph
breaks, line spacing, margins) |
|
understand how to apply bullets
and numbering |
|
understand how to insert special
symbols (eg é, ê, ä, ©) |
|
understand the advantages of
using the search and replace function over manual methods to find and
replace specific data |
|
understand the reasons for and
how to avoid windows and orphans |
|
5 format tabular data
-
insert table
-
set column widths
-
set column/cell alignment
-
apply gridlines andborders/shading
|
|
appreciate the use and purpose
of indenting text and be aware of the various methods of achieving
this |
|
understand how to create a table
|
|
understand how to alter column
widths |
|
understand the alignment of
tabular data |
|
understand the use of gridlines,
borders and shading and the importance of readability |
|
| Terms
four/five: Internet Technologies - Stage I
| E-Mail |
| Working at own pace with reference to the 'In-House' help files
|
| Use Sample Papers S4, and then, S5 running their LIVE Assignment
in parallel. |
|
|
| receiving mail, |
| saving attachments, |
| replying, |
| forwarding to one or more recipients, |
| new mail to multiple recipients, |
| copying to another recipient, |
| sending an attachment, |
|
| adding to address book, |
| using address book, |
| saving e-mails, |
| saving sent messages, |
| page orientation - 'portrait/landscape',
|
| printing messages, |
|
| Internet Searching |
| Working at own pace with reference to the 'In-House' help files
|
| Use Sample Papers S4 and then, S5 running their LIVE Assignment in
parallel. |
|
|
| use Search Engines, |
| enter an address, |
| bookmark an address, |
| structure bookmarks, |
|
| saving pages, |
| page orientation - 'portrait/landscape',
|
| printing pages, |
| print bookmark list, |
|
| Creating Web Pages |
| Working at own pace with reference to the 'In-House' help files
|
| Use Sample Papers S4 and then, S5 running their LIVE Assignment in
parallel. |
|
| HTML document structure, |
| insert a background colour/pattern, |
| entering text, |
| editing text, |
| text format - font sizes, |
| text format - font type, |
| text format - font colour, |
| text format - bold/underline/italic, |
| insert an image, |
| copying and pasting, |
|
| alignment - left/centre/right/justified,
|
| line breaks/paragraphs, |
| saving and recording filenames, |
| create a hyperlink to a web page, |
| create an e-mail hyperlink, |
| opening HTML documents in a browser, |
| page orientation - 'portrait/landscape',
|
| printing part of the document, |
| printing pages, |
| printing HTML code, |
|
|
Web design by K.Booker
Updated 30/07/07
|
