Introduction to Spreadsheets
Year 6 - Computing - Spring 2
Core Learning
Concepts:
Identify questions that can be answered using spreadsheet data
Explain what an item of data is in a spreadsheet
Outline that there are different software tools to work with data
Explain how the data type determines how a spreadsheet can process the data
Explain that formulas can be used to produce calculated data
Recognise cells can be linked
Explain why data should be organised in a spreadsheet
Recognise that a cells value automatically updates when the value in a linked cell is changed
Evaluate results in comparison to the question asked
Skills:
Calculate data using a formula for each operation
Use functions to create new data
Use existing cells within a formula
Choose suitable ways to present spreadsheet data
Vocabulary
data, collecting, table, structure, spreadsheet, cell, cell reference, data item, format, formula, calculation, spreadsheet, input, output, operation, range, duplicate, sigma, propose, question, data set, organised, chart, evaluate, results, sum, comparison, software, tools
What came before?
In Year