Use selection, variable declaration and iteration in programs
Apply nested selection and nested iteration to a given problem
Understand the difference between definite and indefinite iterations
Use, understand and know how the following statement types can be combined in programs: variable declaration, constant declaration, assignment, iteration, selection, subroutine (procedure/function)
Evaluate the purpose of meaningful identifier names and simplifying programming structures. E.g. While play: instead of While play = True
Use basic formulas and functions in a spreadsheet
Remember how to fix a cell reference to aid with duplication of formulas
Apply charts to a spreadsheet and format them appropriately
Analyse effective formulas and functions for a given scenario
Analyse different print layouts and features to aid the user of a spreadsheet
Evaluate the effectiveness of spreadsheets with reference to purpose and audience
Create a spreadsheet for a given purpose
