This is lesson six of the Spreadsheet basics series of lessons. This gets students to understand how to use functions in order to do simple calculations (SUM, AVERAGE, MAX, MIN) for a class of students with a mark-sheet for a fictional class. There is an advanced version of the mark-sheet for those super fast students which also needs them to work out how to calculate ranges and relies on earlier taught content on this course which required them to convert scores to percentages. The lesson comes with teacher exemplars to use with students and a step by step presentation Learning Objectives: • Know how to use the SUM, AVERAGE, MIN and MAX functions • Understand how to speed up setting up spreadsheets with Copy and Paste This Download includes: Presentation Two practical tasks allowing for differentiation Teacher model answers for both tasks 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

This is Lesson 1 to introduce Spreadsheets to students with the aim of dealing with simple Mathematical functions and also introduce some simple formatting. Also includes full step by step teacher examples. The Learning Objectives are: Understand how excel can do calculations based on cell values Know how to use basic formula (add / subtract / multiply / divide) This Download includes: Presentation Two practical tasks with differentiation Extension Task Step by Step examples to show students for all the tasks

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.

This lesson carries on for the previous four lessons to teach the basics of spreadsheets. The focus here is on using IFs and conditional formatting to create self marking quiz. The extension is to lock down a worksheet and protect cells / use a password to restrict access to a sheet / workbook. The files also contain a teacher exemplar to use with the class and a step by step presentation for students to follow. Learning Objectives • Understand how to use the IF function to create a quiz • Know how to protect cells so that only the owner of the document can edit parts of it The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. 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 **all comments and suggestions are very welcome** and will be used to improve future resources. If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources To see other resources in my shop visit https://www.tes.com/teaching-resources/shop/haltest/%22%3e

Full lesson with Lesson Plan / Presentation - used for A Level Learning Objectives • Explain what capital and labour intensive strategies are • Understand the benefits and drawbacks of Capital and Labour intensity • Know how to choose the optimal mix of resources: capital and Labour intensity All necessary resources to run the lesson are included in this download. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. 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 all comments and suggestions are very welcome and will be used to improve future resources. If you have an idea for a topic / resource that you would like to see, also feel free to leave a comment. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources Click here to see other resources in my shop

This lesson builds on lesson 1 to look at the difference between Absolute and Relative Cells Learning Objectives: Understand how to use Absolute and Relative Cells Know how to do currency conversions This Download includes: Presentation Two practical tasks with differentiation Two Extension Tasks Student Presentation to complete Teacher Example

This lesson / resource is for Social and Demographic Factors which is part of PEST / PESTEL / STEEPLE analysis. This lesson has been designed for A Level and IB Diploma Business Studies. It has the following learning objectives shown below: Learning objectives/Outcomes: Understand what Social and Demographic factors are Understand how to analyse external Opportunities and Threats that relate to Social and Demographic factors This download includes: A full lesson PowerPoint Video Case Study 3 case studies Extension - Research Task All necessary resources to run the lesson are included in this download and all my lessons are for a double lesson i.e. to take around 1 hour and fifty minutes so they can be separated into two single lessons if required. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources See my other resources for Business Studies, Computer Science and ICT here

This lesson / resource covers Images in Binary and is part of the unit on Drawing and Manipulating shapes. This lesson was designed for Year 7. It has the following learning objectives shown below: Learning objectives/Outcomes: Understand how color and simple shapes can create art on a computer Know how algorithms might be used to manipulate color Understand the concept of abstraction This download includes: Full Presentation Two practical tasks for students to do Spreadsheets to share with students All necessary resources to run the lessons are included in this download and all resources are for two single lessons per week for Years 7/8/9 i.e. should have enough to cover around 1 hour and fifty minutes. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources.

This lesson is one of a series (scheme of work) to teach Coding techniques in Python and focusses on Types of Variables and Inputs. There is enough content here for 1 double lesson for very advanced students (or a small class) but there is enough challenge here for around 4 hours of teaching time. There are lots of Python challenges for students to try and extension task as well! It has been especially designed for GCSE. Learning Objectives Understand what a Variable is in Python Know what the different types of Variables are and what they are used for Understand and use Operator Precedence Know how to take an input of different data types from the user The resources in this pack will be enough for 2 X double lessons of Computer Science (each double lesson of around 1 hour 50 minutes) . All necessary resources to run the lessons are included in this download. Lesson presentation with examples of the code Eight Challenges to allow students to show their mastery of the concepts Possible solutions for each of the eight challenges Original Python files to allow you to run the programs to see how the programs work Variables Worksheet This lesson is perfect to use to deliver a full lesson or as revision to help students recap skills they have learnt previously. It is also ideal for NQTs and non-specialist teachers who need to learn Python programming or any teacher wanting to fill in gaps in their Python programming knowledge The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. 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. If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. To see other resources in my shop, click here

This lesson / resource is for Marketing Mix and has been designed A Level and IB Diploma Business Studies. It has the following learning objectives shown below: Learning objectives/Outcomes: Know what the 4 Ps are and the meaning of the Marketing Mix Understand some problems in coordinating a marketing mix Know the role of the customer and the 4 Cs This download includes: A full lesson PowerPoint Starter Two Video case studies What went wrong? 4 Ps errors Creative Task with 2 examples Printable Business sheet to randomly allocate to students Differentiated Plenary Extension Multiple Choice Questions All necessary resources to run the lesson are included in this download and all my lessons are for a double lesson i.e. to take around 1 hour and fifty minutes so they can be separated into two single lessons if required. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Harvey Taylor. See my other resources for Business Studies, Computer Science and ICT here

This lesson / resource covers **Shapes and Patterns ** and is part of the unit on Drawing and Manipulating shapes. This lesson looks at abstraction and the use of shapes to create graphics. It also introduces the idea that colors can be controlled by the computer to create gradients and color changes which is explored further in a later lesson. This lesson was designed for Year 7. It has the following learning objectives shown below: Learning objectives/Outcomes: Understand how colour and simple shapes can create art on a computer Know how algorithms might be used to manipulate colour Understand the concept of abstraction This download includes: Full Presentation Practical task for students Teacher Examples All necessary resources to run the lessons are included in this download and all resources are for two single lessons per week for Years 7/8/9 i.e. should have enough to cover around 1 hour and fifty minutes. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources

This resource part of a series to check understanding of the Basic Economic Problem (scheme of work) to check understanding of Opportunity Costs and Production Possibility Curves. ⠀ This resource has 24 multiple choice questions to check student understanding with a full presentation with the answers. ⠀ Resources to run the lesson(s) included in this download: Printable Test with 24 multiple choice questions Answer sheet for teacher Presentation with answers for teacher to review with students ⠀ ⠀ The Scheme of Work for this unit is as follows: Introduction to Economics - Basic Economic Problem Factors of Production Opportunity cost Production Possibility Curves End of Unit Test Questions (with Answers) ⠀ All necessary resources are included in this download and all resources are for a double lesson (or two single lessons) i.e. there should be enough to content to cover around 1 hour and fifty minutes. ⠀ This lesson is part of the topic of understanding the Basic Economic Problem ⠀ The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. ⠀ All activities and resources have been used in classes and any errors will be fixed and resources updated as soon as I am aware them. 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 all comments and suggestions are very welcome and will be used to improve future resources. ⠀ If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. ⠀ The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. ⠀ See our other resources for Business Studies, Computer Science and ICT here

This lesson / resource is for Business Objectives and has been designed GCSE and iGCSE Business Studies. It has the following learning objectives shown below: Learning objectives/Outcomes: Know the need for business objectives and their importance Know how objectives differ for different types of business and how they can change over time Know how to set effective and achievable (SMART) objectives Understand the difference between the Public and Private Sectors This download includes: A full lesson PowerPoint Differentiated Brainstorm Activity Printable group work Activity Knowledge Check Extension Question All necessary resources to run the lesson are included in this download and all my lessons are for a double lesson i.e. to take around 1 hour and fifty minutes so they can be separated into two single lessons if required. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. See my other resources for Business Studies, Computer Science and ICT here

This is lesson two of the Word Processing basics series of lessons. This gets students to understand how to use landscape, insert and deal with tables / rows / columns, and formatting of cells and text Learning Objectives: Know how to create a timetable in Microsoft Word Understand how to create and format a table Know how to add / remove / merge Columns or Rows This Download includes: Presentation Practical tasks allowing for differentiation with lots of extension tasks Teacher exemplar 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 The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources See my other resources for Business Studies, Computer Science and ICT here

This lesson / resource is about **Sampling / Market Mapping ** with the following learning objectives and been designed for A Level / IB Diploma: Learning objectives/Outcomes: Know the different methods of Sampling Understand the problems and benefits of the different sampling methods Know how market maps are constructed Understand what a Gap in the Market is This download includes: A full lesson PowerPoint A fun starter to show problems with sampling Printable slides to a classroom teasure hunt for the pros and cons of the sampling methods A Case Study for Discussion with questions All necessary resources to run the lesson are included in this download and all my lessons are for a double lesson i.e. to take around 1hour and fifty minutes so they can be separated into two single lessons if required. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources See my other resources for Business Studies, Computer Science and ICT here

This lesson / resource is about Business Size with the following learning objectives and been designed for GCSE: Learning objectives/Outcomes: Know how to measure Business Size Number of employees Sales revenue Capital employed Market share Number of outlets Value of the business Understand there are many ways to measure business size and know how to choose the best comparison Know how to assess and compare different businesses in terms of size This download includes: A full lesson PowerPoint Student Sheets with the 6 methods to measure business size Top Trumps Activity / Ranking Task in case internet access is not available Research Task (Internet Access is required for this task) Revision of Enterprise and Entrepreneurship skills (preveious lesson) All necessary resources to run the lesson are included in this download and all my lessons are for a double lesson i.e. to take around 1hour and fifty minutes so they can be separated into two single lessons if required. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. See my other resources for Business Studies, Computer Science and ICT here

This lesson / resource is for Enterprise and Entrepreneurs and has been designed GCSE and iGCSE Business Studies. ⠀ This lesson has the following Learning Objectives: Know what Enterprise means Understand the characteristics of an Entrepreneur Know the difference between a Good and a Service ⠀ Resources to run the lesson(s) included in this download: A full lesson PowerPoint Printable video case study Activity Knowledge Check ⠀ All necessary resources to run the lessons are included in this download and all resources are for a double lesson (or two single lessons) i.e. there should be enough to content to cover around 1 hour and fifty minutes. ⠀ The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. ⠀ Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. ⠀ The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources ⠀ See my other resources for Business Studies, Computer Science and ICT here ⠀

This lesson / resource is for Breakeven Scenario. This lesson has been designed for A Level and IB Diploma Business Studies and is one of a series that covers breakeven in full detail. Lesson 1: Costs and Revenue for Breakeven Lesson 2: Breakeven Basics Lesson 3: Breakeven Advanced Concepts and Changes to Breakeven Lesson 4: Full Scenario It has the following learning objectives shown below: Learning objectives/Outcomes: Know how to calculate breakeven Understand Margin of Safety Know how changes to Price and Costs and affect breakeven This download includes: A full lesson PowerPoint Retrieval Practice Printout Printable Case Study All necessary resources to run the lesson are included in this download and all my lessons are for a double lesson i.e. to take around 1 hour and fifty minutes so they can be separated into two single lessons if required. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources See my other resources for Business Studies, Computer Science and ICT here

This lesson / resource is about Added Value with the following learning objectives and been designed for AS/AS/IB Business Studies Learning objectives/Outcomes: Understand the concept of creating/adding value - the idea of selling for a higher price than the cost of bought-in materials Know how to calculate Added Value at different stages Explain some ways that business can add value This download includes: A full lesson PowerPoint Calculation exercises of Added Value at different stages of production Practical examples for students to discuss A worksheet with answers for students All necessary resources to run the lesson are included in this download and all my lessons are for a double lesson i.e. to take around 1 hour and fifty minutes so they can be separated into two single lessons if required. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources See my other resources for Business Studies, Computer Science and ICT here

This lesson / resource is about Critical Path Analysis with the following learning objectives and been designed for AS/AS/IB Business Studies. This is the first lesson for CPA and focusses on drawing the diagrams with fully worked examples. The second lesson focusses on Float and Total Float and looks at some of the advantages and disadvantages of CPA as a planning tool Learning objectives/Outcomes: Understand the terms associated with Critical Path Analysis Nodes / Activities / Earliest Start Time/ Latest Finish Time / Float / Dummy Activities Understand to construct a network diagram Know how to find and calculate the Earliest Start Times and the Latest Finishing Time Know how to determine the Critical Path This download includes: A full lesson PowerPoint 3 Fully worked examples All necessary resources to run the lesson are included in this download and all my lessons are for a double lesson i.e. to take around 1 hour and fifty minutes so they can be separated into two single lessons if required. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. 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 all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources See my other resources for Business Studies, Computer Science and ICT here