Unit xx. Spreadsheets – I’m a business analyst

This unit is planned but development has not yet started. Our plans may change in the future as we continue to review our scheme of learning.

Unit description

Using software to format, calculate and present small data sets.

Unit career

I’m a business analyst

“As a business analyst I change data into information. This includes working with spreadsheets to make calculations and present data in visual charts for other people. My goal is to give meaning to data.”

Key Question

All the activities in this unit enable students to answer the key question:

How can software be used to effectively format, calculate and visualise data sets?

Knowledge statements

This is achieved by students studying 4 “Learn-it” lessons, each of which focus on one knowledge statement:

1. Know that cells can be formatted in different ways depending on the data they are showing.
   • E.g. decimal places, currency & date.
2. Know how to insert new data and format a sheet to make it easier to read.
   • E.g. inserting rows, headers, table designs & borders.
3. Know that formulas should be used to automate calculations to make recalculation of new data quicker.
   • E.g. =a*b, sum, average & count.
4. Know how to make and format charts from data.
   • E.g. bar for comparing categories, pie for percentages, line for trends.

What is included in this unit?

• Teacher guide providing a detailed overview of the unit.
• 6 Lesson folders:
  • 4 “Learn-it” lessons with a teacher PowerPoint and student workbook.
  • 1 “Make-it” lesson with assessment materials for teachers and students.
  • 1 “Review-it” lesson with an end of topic MCQ test, assessment grid, peer assessment and self-reflection.
• Any additional resources and materials needed for the activities are provided in the lesson folders.
• 6 detailed lesson plans explaining how to teach the 3 lesson phases.
• Extension activities with model answers.
• 3 independent homework question sheets supported by 3 online videos hosted on Tella.