Learning with Spreadsheets

Primary 4

• Basic operations
• Open and close a workbook
• Explain the difference between a workbook and worksheet
• Create a new spreadsheet
• Open an existing spreadsheet
• Save a workbook
• https://www.youtube.com/watch?v=lgIWIPDJuPo
• https://youtu.be/EBGrJckHadw?t=28s
• https://youtu.be/yTHgz8Vwik8?t=28s
• https://youtu.be/qRShQc-v3LI
• Cells
• Understanding cells
• Enter text and numbers into cells
• Edit cell entries
• https://youtu.be/6mSKsaquTAM
• Rows and columns
• Select columns and row
• Change the width of columns
• Change the height of rows
• Insert a column
• Insert and delete a row
• Adjust columns automatically
• https://youtu.be/9s0OdXiuqL0

Primary 5

• Format cells
• https://youtu.be/etAMC0KRuBE
• Type multiple lines into a cell
• https://www.youtube.com/watch?v=7NFCK97tVVQ
• Number formats in cells
• Date
• Time
• Percentages
• Currency
• Decimals
• https://youtu.be/fjyOG7Ls7BA
• Printing
• Preview a spreadsheet
• Print a spreadsheet
• Define a print area
• Print the specific area of the spreadsheet
• Print a specific page of a spreadsheet
• Print multiple copies of a spreadsheet
• https://youtu.be/8XcFTeCu98k

Primary 6

• Formulas
• Enter formulas with basic operations (+ - * /)
• Edit the formulae
• https://youtu.be/xc14gFFyiTw
• https://youtu.be/J-W3thqtDpQ