Spreadsheet
Skills required to achieve Level 3
c Is able to give a suitable title to a graph and label the axes. Is able to arrive at simple conclusions from the graph
b Can use functions and formulae in a spreadsheet, copy it into another cell
a Is able to format cell contents change alignment and apply borders and shading
Skills required to achieve Level 4
c Can make changes to data in a spreadsheet and understand its effects
b Is able to format numbers into currency
a Is able to change the paper size, page orientation and margins
Skills required to achieve Level 5
c Is able to answer questions to modelled scenarios
b Is able to identify the most suitable type of graph for the scenario
a Is able to modify data in a spreadsheet to answer questions
Skills required to achieve Level 6
c Can produce a chart to suit the purpose give a meaningful title and label graphs.
b Can make changes to data in a spreadsheet and understand its effects
a Can work with basic formulae and use functions
Skills required to achieve Level 7
c Can filter records based on simple criteria
b Is able to appropriately use a range of formatting tools available in a spreadsheet program
a Is able to look for errors in a spreadsheet and correct them
Skills required to achieve Level 8
c Can make suggestions for improvements and modify a spreadsheet to make it suitable for its purpose
b Can work with advance functions such as IF function
a Can understand the difference between absolute and relative cell referencing
No comments:
Post a Comment
You may leave your comments here: