a use appropriate application software

• identify appropriate software for the task (eg spreadsheet/database/statistical software)
  understand correct procedures for using chosen software

• appreciate the differences between data modelling software and purely graphical alternatives (eg live data modelling)

a use pie chart
b use line graph
c use bar/column chart

• distinguish between pie charts, line graphs and bar/column charts and comparative graphs/charts and understand how to create and format them

a select single data set
b select comparative data set
c select subset of single data set

• understand how to select a variety of data sets for display in graphical form, using contiguous data

• understand how to compare two sets of similar data using line graphs and bar/column charts

a set axes upper & lower limits
b select and display data labels
c select/enter headings and axes titles
d use a legend where appropriate
e ensure comparative data is distinctive

• understand how to amend the graph/chart to display specific upper and lower limits for continuous data

• understand how to amend default/automatic formatting where necessary
  distinguish between titles, axes titles, legends and labels and understand how to set and amend them

• appreciate the need for a legend to correctly identify comparative data sets

• appreciate the need to ensure comparative data is distinctive, and the effects of printing coloured graphs in grey

a open existing data document
b save data document
c save charts/graphs
d print graphs/charts
e close document

• understand the document management techniques for the chosen software and the differences from generic document management terms (eg saving charts, tables, data)

• understand how to print from the chosen software using default print settings

1 Identify and use database software correctly

                    a use appropriate application software

• identify appropriate software for the task (eg database)

• understand correct procedures for using chosen software

• appreciate the differences between databases and spreadsheets (live data handling, multiple views (forms), flexible query/search/present facilities)

2 Use an input device to enter and edit data accurately

a create new records
b enter data
c delete record
d amend data
e replace specified data

• understand the use of an input device to enter data

• appreciate the need for accuracy and the importance of checking output against expectations

• understand the software's tools for adding and deleting records and appreciate the effects on the database

• understand how to amend an existing record

• appreciate the advantages of a search & replace tool over manual editing of multiple items in a large database

3 Create simple queries/searches on one or two criteria

a select data on one criterion
b select data on two criteria
c present only selected fields

• understand the software's facility for producing simple database queries/searches/filters and how to save them for later use

• understand the use of =, <, >,<=, >= in search criteria

• understand the use of the software's query or filter facility to select a subset of data matching one and two criteria (text, numbers & date)

• understand how to select which fields will be presented/printed

4 Present selected data sorted alphabetically, numerically and by date

a sort data alphabetically
b sort data numerically
c sort data by date

• understand how to present data sorted alphabetically and numerically (both ascending and descending) and by date

5 Manage and print database files

a open an existing database
b save data
c save query/filter
d print data in table format
e close database

• understand the document management techniques for the chosen software and the differences from generic document management terms (eg automatic saving of data)

• understand how to print a table from the chosen software using default print settings

• understand how to present and print the results of a query/filter as an unformatted tabular report

a switch on computer and monitor safely
b use a personal computer and printer to produce a document
c navigate the operating system
d load application software
e use an input device to enter data
f shut down operating system

• identify, distinguish between and be able to operate hardware and software
• understand the generic components of common operating systems and their functions (windows, icons, buttons, menus, pointer, cursor, toolbars, etc )
• identify and distinguish between software elements (applications, data files/documents, directories/folders)
• appreciate the advantages of a Graphic User Interface in Using IT (WYSIWYG etc)
• appreciate safe working practice in using a computer (location and positioning of workstation, chair, screen, keyboard) to reduce risk of strain-type injuries

a gain access to data using a login and/or password
b use file search facilities
c find a specified file

• appreciate the need for security in the production of documents, and the risks and consequences of unauthorised access to computers and networks (viruses, secure data, computer misuse etc
• understand simple login procedures
• understand how to change a password and be aware of good practice in selecting passwords
• understand how to locate data and files using the features of the system software

a enter text
b enter numbers
c enter symbols
d amend an existing document

• understand how to use a keyboard or other input device to enter text, numbers and symbols (=-/#.,:@?!�&%+*), including use of the shift key and return or enter key
• understand the need for accurate data input
• understand the role of the cursor and mouse/pointer combination in selecting the edit point

4 Print a document using the default printer settings

a switch on printer safely
b load paper
c print document

• understand the safe use of the selected print facility
• understand how to load paper correctly
• understand the use of default print facilities

5 Manage documents and data

a create a new document
b open an existing document
c save an existing document
d save a document with a new filename
e close document

• understand generic document management terms and operations (file menu, new, open, save, save as, close)
• understand how to navigate filing systems from within generic open/save dialogs
• understand the need to save documents on a regular basis and the reasons for saving with a new filename