Be able to add a second data series
Be able to add alternative text/screentip to an object
Be able to add and delete bookmarks/hyperlinks
Be able to add presenter notes
Be able to adjust the brightness of an image
Be able to adjust the contrast of an image
Be able to adjust the maximum and minimum values of an axis scale and set incremental values
Be able to apply bullets including shape, alignment, line spacing and indent
Be able to apply classes to elements within a web page
Be able to apply consistent animation effects on text, images and other objects
Be able to apply consistent transitions between slides
Be able to apply font styles including font face, type (serif, sans-serif), point size, colour
Be able to apply spacing including paragraph (before and after) and line
Be able to apply text alignment including left, right, centre, fully justified
Be able to apply text enhancement including bold, underline, italic
Be able to attach comments to an external stylesheet
Be able to create a bookmark within a web page using an id attribute
Be able to create a new presentation using a text file
Be able to create a table with a specified number of rows and columns
Be able to create and edit primary and foreign keys
Be able to create external styles to be tagged in a web page including h1, h2, h3, p, li
Be able to create formulae using cell references
Be able to create or edit headers and footers
Be able to create or edit lists including bulleted, numbered
Be able to create relationships between tables
Be able to create the content layer of a web page
Be able to create the presentation layer of a web page
Be able to create, modify, update and apply styles to ensure consistency of presentation
Be able to display either formulae or values
Be able to enter and modify text and numbers with total accuracy
Be able to find and replace text including matching case, whole words
Be able to format master slide objects including headings, subheadings, bullets, background colour
Be able to format numerical values to a specified number of decimal places
Be able to format numerical values to display currency symbols
Be able to group and layer images including grouping and ungrouping, moving to the front or back
Be able to hide and display rows and columns
Be able to hide slides within a presentation
Be able to insert a table including table header, table rows, table data
Be able to insert cell(s), row(s) and column(s), delete cell(s), row(s) and column(s), merge cells
Be able to locate stored files
Be able to move or delete a slide
Be able to open and import files of different types
Be able to perform searches using a variety of operators including AND, OR, NOT, >, <, =, >=, <=, <>
Be able to perform searches using wildcards
Be able to place an image with precision
Be able to place appropriate content in the body section of a web page
Be able to place text or objects in a table
Be able to reflect (flip) an image horizontally or vertically
Be able to replicate formulae using absolute and relative cell references where appropriate
Be able to resize an image as specified to maintain or adjust the aspect ratio of an image
Be able to save files in a planned hierarchical directory/folder structure
Be able to save files using appropriate file names
Be able to save styles in cascading stylesheet format
Be able to select subsets of data using a single criterion, or multiple criteria
Be able to select the graph or chart type
Be able to set display format of Boolean/logical field (yes/no, true/false, checkbox)
Be able to set display format of date/time data
Be able to set sub-types of numeric data including percentage, number of decimal places
Be able to set the orientation to portrait or landscape
Be able to specify the font properties including font family, size, colour, alignment, bold, italic
Be able to use a single criterion, or multiple criteria to select subsets of data using a query
Be able to use arithmetic operators in formulae including add, subtract, multiply, divide, indices
Be able to use external data sources within functions
Be able to use named cells and named ranges
Be able to use nested functions
Be able to use the
Be able to use validation routines to minimise data entry errors
Be able to wrap text around a table, chart or image including above, below, square and tight
Be able to wrap text within cells so that all data is fully visible
Know and understand advantages and disadvantages of the different types of operating systems
Know and understand advantages and disadvantages of using cloud storage compared to other methods
Know and understand advantages and disadvantages of using computer modelling rather than humans
Know and understand analysing the needs of an audience when creating ICT solutions
Know and understand biometrics including the use of biometric data
Know and understand card fraud including shoulder surfing, card cloning, key logging
Know and understand characteristics and use of absolute and relative cell referencing
Know and understand characteristics and uses of patient records, pharmacy records
Know and understand characteristics of a desktop computer
Know and understand characteristics of a style and a class including the difference between them
Know and understand characteristics of analogue and digital data
Know and understand characteristics of backing storage
Know and understand characteristics of good form design
Know and understand characteristics of input and output devices
Know and understand characteristics of primary key and foreign keys
Know and understand characteristics of ROM and RAM
Know and understand characteristics, advantages and disadvantages of internet shopping
Know and understand characteristics, uses and purpose of an extranet, intranet and the internet
Know and understand characteristics, uses and purpose of technical and user documentation
Know and understand connecting a device to a network using Bluetooth
Know and understand connecting a device to a network using wi-fi
Know and understand differences between analogue and digital data
Know and understand differences between backing storage and internal memory
Know and understand differences between input and output devices
Know and understand differences between ROM and RAM
Know and understand differences between types of operating systems
Know and understand digital certificate including its purpose and contents
Know and understand firewall including its purpose
Know and understand fixed and portable solid-state drive (SSD) including SSD, pen drive, flash drive
Know and understand hacking including the measures that must be taken in order to protect data
Know and understand hardware as the physical components of a computer system
Know and understand how data is stored, managed and shared using cloud computing
Know and understand identifying and justifying suitable hardware and software for the new system
Know and understand input formats including data capture forms
Know and understand internal memory including random access memory (RAM), read-only memory (ROM)
Know and understand magnetic drives including magnetic hard disks, magnetic tape
Know and understand optical discs including CD, DVD, Blu-ray
Know and understand optical drives including CD, DVD, Blu-ray
Know and understand output formats including screen layouts and report layouts
Know and understand privacy and confidentiality of data transfer
Know and understand purpose and uses of a corporate house style
Know and understand scanning the data/software when downloading
Know and understand scanning the storage media used to transfer data
Know and understand school management systems are used to manage learner registration and attendance
Know and understand showing a clear sense of audience and purpose
Know and understand similarities and differences between Bluetooth and wi-fi
Know and understand solid-state media including memory cards (SD, xD, CFast)
Know and understand system software provides the services that the computer requires to operate
Know and understand the causes of these health issues and strategies for preventing them
Know and understand the causes of these safety issues and strategies for preventing them
Know and understand the characteristics, uses and issues relating to cloud computing
Know and understand the difference between a formula and a function
Know and understand the differences and similarities between an extranet, intranet and the internet
Know and understand the differences between strong and weak passwords
Know and understand the function of a hyperlink
Know and understand the function of an anchor
Know and understand the need for eSafety when using the internet, email, social media, online gaming
Know and understand the need for generic file formats
Know and understand the need for validation as well as verification
Know and understand the need to reduce file sizes for storage or transmission
Know and understand the need to test the system before implementation
Know and understand the operation of removing/quarantining viruses using up to date software
Know and understand the presentation layer is used to display and format elements within a web page
Know and understand the purpose of headers and footers
Know and understand the purpose of setting gutter margins
Know and understand the purpose of setting page, section and column breaks
Know and understand the purpose of the head and body sections of a web page
Know and understand the reason relative file paths must be used for attached stylesheets
Know and understand the reason tables are used to structure elements within a web page
Know and understand the use of anti-malware and anti-virus software
Know and understand the use of live data
Know and understand the uses of wi-fi and Bluetooth
Know and understand two-factor authentication including its purpose and function