Microsoft Excel Scheme of Work

Scheme of Work for Microsoft Excel targetted at Year 8 and 9 Students. Focus of the unit is on Data Collection, both Primary and Secondary Data Sources are discussed as well Quantitative and Qualitative data. This resource includes a Workbooklet for students, PowerPoint Presentation, Digital Worksheets and Pre-Recorded videos.

All Lessons Include Retrieval Starters, Written Activities and Digital Literacy Practice Activities (Applied Knowledge Activities)

Lesson One - Excel Basics
Lesson on the basics of Microsoft Excel, discussing what the difference between Data and Information is, Basic Formulae and how to use Cell Referencing.
Lesson Objective
To construct formulas for the purpose of data analysis in Spreadsheet Applications such as Microsoft Excel.
Included Resources; PowerPoint, Workbooklet Tasks and Pre-Formatted Excel Spreadsheet.

Lesson Two - Research of Data
Lesson discusses the ideas behind Primary and Secondary data collection - with a concentration on Secondary Data. Students are given the task of researching the average cost of bills.
Lesson Objective
Learners will be able to explain the difference between data and information whilst explaining the differences between primary and secondary sources.
Included Resources; PowerPoint, Workbooklet Tasks and Pre-Formatted Excel Spreadsheet.

Lesson Three - Surveys for Data
Lesson shows how students can use Microsoft Forms for the collection of data. Students discuss that this is a Primary Data Collection Method.
Lesson Objective
Learners will be able to explain the difference between quantitative and qualitative data and how it is collected.
Included Resources; PowerPoint, Video Demonstration, Workbooklet Tasks

Lesson Four - Data Analysis
Lesson discusses methodologies for data analysis, and ensuring that we are able to create information from research.
Lesson Objective
Learners will be able to create information from data using data analysis techniques.
Included Resources; PowerPoint, Video Demonstration, Workbooklet Tasks and Pre-Formatted Excel Spreadsheet.