Image of Introduction to Microsoft Excel Spreadsheets - Lesson Plans Bundle Image of Introduction to Microsoft Excel Spreadsheets - Lesson Plans Bundle Image of Introduction to Microsoft Excel Spreadsheets - Lesson Plans Bundle Image of Introduction to Microsoft Excel Spreadsheets - Lesson Plans Bundle

Introduction to Microsoft Excel Spreadsheets - Lesson Plans Bundle

£42.50
Purchase

This is the first entire Microsoft Excel bundle to teach youngsters the basic and intermediate skills of the software. This bundle teaches students the very basic skills up to more advanced skills such as absolute cell referencing. The Excel exercises in this bundle also prove to be excellent resources for consolidation work or even mini tests. This bundle also include I Can statements, Task/Help Cards and Question Cards.

Topics in this bundle include:
• Introduction to Excel Spreadsheets
• Calculations in Excel Spreadsheets
• Understanding and Naming Cell references
• Use of simple formulae/calculations such as addition, subtraction and multiplication.
• Functions in Excel Spreadsheets (sum, min, max, average, mode)
• Tallying data in spreadsheets
• Making predictions by changing data
• Components of a graph
• Advantages of spreadsheets over pen and paper methods
• Analysing spreadsheet data
• Inserting spreadsheet rows
• Deleting spreadsheet rows
• Practising and Creating spreadsheets from scenarios
• Understanding, creating & analysing Graphs in Excel
•Absolute & relative cell referencing

Resources included in this bundle:
1) Detailed suggested lesson plans
2) PDF version of PowerPoints
3) Student Worksheets (PDF Files)
4) Microsoft Excel spreadsheet exercises which can be used as mini tests or for consolidation work.
5) I Can Statements which cover the following 6 categories:
• Text & Number Formatting
• Cell Formatting
• Creating & Formatting Graphs
• Using Formulae & Functions
• Sheet Operations
• Sheet Layout & Appearance
6) 19 Task Cards which cover the following topics and allow students to practise these skills independently in Microsoft Excel:
• Creating pie charts
• Customizing pie charts
• Creating bar charts
• Formatting bar charts
• Inserting rows
• Deleting rows
• Addition, subtraction, multiplication, division formulae (including questions)
• =sum()
• =max()
• =min()
• =mode()
• =average()
• =count()
• =counta()
• =countif()
7) 20 Question Cards test students’ knowledge on all areas of Microsoft Excel. These can be used as bell work, starters, plenaries or as a test.