2.1 Spreadsheets

• explain the importance of spreadsheet productivity tools in manipulating data
• select spreadsheet productivity tools in manipulating data
• use spreadsheet productivity tools to manipulate data
• appreciate the role of spreadsheet productivity tools in solving real-life problems

“Why might spreadsheet productivity tools be better than other productivity tools in manipulating data?”

“How are spreadsheet productivity tools used to make decisions?”

The titles are open to everyone. Reading a lesson needs an account — sign in or create one.

1. What a spreadsheet is
   40 min · 1 practice tasks · quiz
   Describe a spreadsheet and why it is good for manipulating data.
2. Choosing a spreadsheet tool
   40 min · 1 practice tasks · quiz
   Compare spreadsheet tools and select one for a task.
3. Creating, formatting and editing
   40 min · 1 practice tasks · quiz
   Create, format and edit a spreadsheet to present data clearly.
4. Functions and formulas
   40 min · 1 practice tasks · quiz
   Use formulas and functions to manipulate data.
5. Organising data in a spreadsheet
   40 min · 1 practice tasks · quiz
   Use sorting, filtering, validation, conditional formatting and grouping.
6. Graphs and charts
   40 min · 1 practice tasks · quiz
   Create charts to visualise a data set.
7. Sharing outputs and real data
   40 min · 1 practice tasks · quiz
   Share spreadsheet outputs and analyse real-life data.