pptx, 1.03 MB
pptx, 1.03 MB
pdf, 89.63 KB
pdf, 89.63 KB
pdf, 99.87 KB
pdf, 99.87 KB
zip, 1.74 KB
zip, 1.74 KB
xlsx, 18.9 KB
xlsx, 18.9 KB
This lesson has the following objectives

Know how to collate data using Microsoft Excel

Understand how to produce charts and graphs to show your data



It leads on from Lessons 1 and 2 which covered formatting and relative / absolute cells and goes onto introduce how to create tables in excel and then how to create graphs and charts.



This Download includes:

Presentation

Two practical tasks with differentiation

Extension Task

An optional data collection survey



This resource has enough for 2 lessons X 50 minutes with extension tasks for those students that get through their tasks quicker than all the rest.

Get this resource as part of a bundle and save up to 46%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Bundle

Spreadsheet Essentials - Everything you need for 10 lessons for KS3 Computing / ICT

10 Lessons dedicated to teaching Students everything they need to master the basics of Spreadsheets:<br /> &bull; Calculations<br /> &bull; Simple Functions<br /> &bull; IFs<br /> &bull; Conditional Formatting<br /> &bull; Relative and Absolute Cells<br /> &bull; Copying and Pasting Formulas to speed up work<br /> <br /> Each lesson has full resources and exemplars and reflection sheet to round off the unit of work (good for life after levels)<br /> <br /> Lessons included are:<br /> &bull; Spread Sheets 1 - The Basics - Maths Functions / Simple Formatting<br /> &bull; Spread Sheets 2 - The Basics - Exchange Rates and Absolute Cells<br /> &bull; Spreadsheets 3 and 4 - Collecting / Collating Data AND Intro to Graphs / Charts<br /> &bull; Spread Sheets 5 - The Basics - IFs and Conditional Formatting<br /> &bull; Spread Sheets 6 - The Basics - Functions - Averages, Max, Min<br /> &bull; Spread Sheets Lesson 7/8/9/10 - The Basics - Spreadsheet Battleships - Putting it all together<br /> <br /> The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work.<br /> All activities and resources have been used in class and any errors will be fixed and resources updated as soon as I am aware of any errors. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but <strong> all comments and suggestions are very welcome </strong> and will be used to improve future resources. <br /> If you have an idea for a topic / resource that you would like to see, also feel free to leave a comment.<br /> The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources

£10.99

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.