Access keys Search Skip navigation

Challenges and appendices

 

Challenge 1: Identifying the components of a computer system

Understanding the technical language associated with hardware

Appendix 1.1 Number bustin' with ICT questions

Appendix 1.2 Understanding software terminology

 

Challenge 2: Understanding software terminology

Appendix 2.1 Card set

 

Challenge 3: Grasping the meaning and use of the greater than > and less than < functions

Appendix 3.1 Greater than/less than visual aid

Appendix 3.2 Making comparisons

 

Challenge 4: Understanding wild card searches, using the correct symbols and identifying when and how to use them

 

Challenge 5: Using appropriate data types to match the data used

 

Challenge 6: Conceptualising an Excel worksheet

Navigating a worksheet and understanding the distinction between columns and rows

Appendix 6.1 Battleship sample grid

 

Challenge 7: Understanding the relationship between a card index database and a computer database

Appreciating how and why computerised systems can be so effective

Appendix 7.1 Sample record card

Appendix 7.2a Sample database

Appendix 7.2b Sample worksheet

 

Challenge 8: Using appropriate formatting such as currency and decimal places

Appendix 8.1 Introductory activity - use of decimal places

Appendix 8.2 Example spreadsheet

 

Challenge 9: Recognising the knock-on effect of changing a value in a spreadsheet

Appendix 9.1 Spreadsheet functions

 

Challenge 10: Using the spreadsheet functions SUM, MIN and MAX appropriately

Appendix 10.1 Spreadsheet functions

 

Challenge 11: Using the find and replace function in Word

Appendix 11.1 'Find and replace' activity and worksheet

 

Challenge 12: Managing files - sorting different documents into relevant folders and files

Appendix 12.1 Managing files card set

 

Challenge 13: Understanding how to sort A to Z and Z to A

Appendix 13.1 Sorting exercise

 

Challenge 14: Improving the final presentation of a piece of work

Appendix 14.1 Spell checker poem

 

Challenge 15: Using and understanding health and safety terminology

Appendix 15.1 Health and safety matters