Topic outline

• 

  General

  Unit 6 - Spreadsheet - Design and Create
• 

  Topic 1

  AO1 Develop a spreadsheet to meet the needs of an organisation

  • AO1 Develop File
  • AO1 Hand Drawn Templates File
  • AO1 Datblygu File
  • AO1 Templedi â llaw File
  • AO1 - Upload your Workbook
• 

  Topic 2

  AO2 Format a spreadsheet to make it user friendly

  • AO2 Formatting File
  • AO2 Fformatio File
  • AO2 - Upload your Workbook
• 

  Topic 3

  AO3 Sort data and use simple Filters

  • AO3 Sorting File
  • AO3 Filtering File
  • AO3 Trefnu File
  • AO3 Hidlo File
  • AO3 - Upload your Workbook
• 

  Topic 4

  AO4 Carry out modelling activities using a spreadsheet

  • AO4 Modelling File
  • AO4 Modelu File
  • AO4 - Upload your Workbook
• 

  Topic 5

  AO5 Analyse data using appropriate graphs/charts

  • AO5 Graphs File
  • AO5 Graffiau File
  • AO5 - Upload your Workbook
• 

  Topic 6

  AO6 Create macros to automate procedures in a spreadsheet

  • AO6 Macros File
  • AO6 Macros (Cymraeg) File
  • AO6 - Upload your Workbook
• 

  Topic 7

  AO7 Test the spreadsheet solution

  • AO7 Testing File
  • AO7 Profi File
  • AO7 - Upload your Workbook
• 

  Topic 8

  Download the Course

  • Cwrs (Uned 6) - Course (Unit 6) File