1. Resources Home
  2. High School
  3. Vocational studies
Most used Excel functions - function, syntax, description quick reference sheets

Most used Excel functions - function, syntax, description quick reference sheets

This resource contains a Table of the most used functions in Excel. It is separated by Core functions, Date Functions, Text Functions, and Lookup / Reference Functions. It is set out attractively in a table, the column headings being: Function Name, Syntax and Description. It gives a quick reference to over 35 different functions. It is available in a pdf and word document so that you can make any changes required.
Resource_Creator
BTEC Level 3 Health and Social Care Unit 5 Meeting Individual Care and Support Needs Learning Aim B

BTEC Level 3 Health and Social Care Unit 5 Meeting Individual Care and Support Needs Learning Aim B

A 21 page booklet covering the content of the BTEC Level 3 Health and Social Care Unit 5 Meeting Individual Care and Support Needs content for Learning AIm B; B1 and B2. It is a wrod document which can be added to or altered to suit your teaching style. The booklet helps students to be organised with their notes and keep information together. There are SIX PowerPoints to aid your delivery and areas for students to make notes, complete activities and sign posting about the assignment assessment criteria. Powerpoints on Ethical theories and application, Managing conflict, Conflict of Interest, The Care Act, Equality Act and the Mental Capacity Act. Some of these have approriate videos embedded within and are designed to be engaging and interesting. The spec content covered with this package is… B1 Ethical issues and approaches • Ethical theories to include consequentialism, deontology, principlism and virtue ethics. • Managing conflict with service users, carers and/or families, colleagues. • Managing conflict of interests. • Balancing services and resources. • Minimising risk but promoting individual choice and independence for those with care needs and the professionals caring for them. • Sharing information and managing confidentiality. B2 Legislation and guidance on conflicts of interest, balancing resources and minimising risk • Organisations, legislation and guidance that influence or advise on ethical issues. All legislation and guidance must be current and applicable to England • Organisations, e.g. National Health Service (NHS), Department of Health (DH), National Institute for Clinical Excellence (NICE), Health and Safety Executive (HSE). • Legislation, e.g. Mental Health Act 2007, Human Rights Act 1998, Mental Capacity Act 2005, National Health Service Act 2006 Section 140, Equality Act 2010, Care Act 2014. • Guidance, e.g.: • the DH Decision Support Tool • Five Step Framework • NICE and NHS guidance on Care Pathways and Care Plans • Managing Conflicts of Interest: Guidance for Clinical Commissioning Groups • NHS • HSE guidance on risk assessments. • How this guidance may be counterbalanced by other factors, e.g. religion, personal choice, government policies. For more Level 1, 2 and 3 Health and Social Care resources, follow me on TES to find the full range of resources in the same place with a handy search facility, to save on time. https://www.tes.com/member/HSCresources
HSCresources
Homeostasis system the balancing blood glucose level and energy use and diabetes

Homeostasis system the balancing blood glucose level and energy use and diabetes

Presentation on Glucose Homeostasis and a flow chart activity to check understanding. Presentation about the pancrease, alpha/beta islet cells and diabetes For more health and social care resources, follow me on TES to find a range of Levels 1, 2 and 3 resource packages in the same place with a handy search facility, to save time https://www.tes.com/member/HSCresources
HSCresources
Homeostasis thermoregulation body temperature, hypothermia and hypothermia

Homeostasis thermoregulation body temperature, hypothermia and hypothermia

PowerPoint about the thermoregulation process with embedded video and activity to check understanding. Additional PowerPoint to explain both hypothermia and hypothermia. For more resources for Health & Social Care Levels 1, 2 and 3, follow me on TES to find all my resources in one place with a handy search facility. https://www.tes.com/member/HSCresources
HSCresources
BTEC Health and Social Care Level 2 Tech Award COMPONENT 3 Learning Aim B PPoint & Workbook

BTEC Health and Social Care Level 2 Tech Award COMPONENT 3 Learning Aim B PPoint & Workbook

FOR BTEC Health and Social Care Level 2 Tech Award COMPONENT 3 Learning Aim B COMPLETE PowerPoint Covering all LA:B content from specification. Includes workbook for all student notes linked to PowerPoint Directions for homework End of unit assessment (25 minute exam paper) with full mark scheme. I have put hours of work in to this so I would appreciate a review if you purchase it! Many thanks xx Extensive Learning Aim A also available to purchase Learning Aim C to follow over coming weeks!
betbar
Individual Lesson Objective booklet

Individual Lesson Objective booklet

This is a professional, well put together booklet for learners to fill out during a lesson. Each session learners are to give themselves an objective and state what they plan to achieve. The booklet has an example, some ideas of what they could write and words they could use. This document gives learners a target as well as stretch and challenge tasks. This booklet will also show progression over 1 to 36 weeks. It is to the point and easy to fill in. I use this for a particular group of Carpentry learners that do not have a training booklet or any other proof of progression. Ideal for OFSTED and observations.
Ga3hill
Level 3 BTEC Health & Social Care Anatomy & Physiology Student Guide to Body Systems

Level 3 BTEC Health & Social Care Anatomy & Physiology Student Guide to Body Systems

This is a 38 page guide to the body systems needed for the Level 3 BTEC Extended Diploma in Health & Social Care Unit 3 - Anatomy & Physiology Exam. Much of the content is a ‘revision’ from GCSE material with diagrams of each body system and structure and function of each of the parts of each system. It is a good resource to give students to take over the summer to ensure they are ready to start the unit in September, or it can be used as resource alongside their other learning materials.
funkyteach
Respiratory system

Respiratory system

Used for observation lesson. Introduction to the pathway of air through the respiratory system with differentiated worksheets for L.A, M.A & H.A.
kimscott1311
World cup bid challenge

World cup bid challenge

Students have to bid for the world cup to be held in their country based on the success criteria and the information on the sheets. This is basic information taken from the internet and others resources. My year 9 group loved it and im sure it could be adapted for year 8 and below
victoria68mcgowan
BTEC Tech Award Health and Social Care Component 1 Level 1 - Learning Aim A and B basic resources

BTEC Tech Award Health and Social Care Component 1 Level 1 - Learning Aim A and B basic resources

BTEC Tech Award Health and Social Care Component 1 Level 1 (not Level 2)- Learning Aim A and B basic resources A.1P1 - A3 resource - Identify aspects of growth and develoment PowerPoint of words to include under ‘identify’ A.1P2 - A3 resource - Factors affecting growth and development BTEC Tech Award Health and Social Care Component 1 Level 1 (not Level 2)- Learning Aim B resource B.1P3, B.1P4 - A3 resource - Life Events impact and the support received For more Level 1, Level 2 and Level 3 Health and Social Care resources, follow me on TES to find them all in the same place with a search facility https://www.tes.com/member/HSCresources
HSCresources
Sustainable tourism assessment

Sustainable tourism assessment

This is a short ( 3 mins approx) mid-unit test to check students understanding on the concept of sustainable tourism. It could also easily be set as a classwork or homework task. Students must show they can define sustainable tourism, explain the negative impacts of mass tourism, and annotate an ecolodge with its sustainable features. This was originally written for year 9 as an introduction to the Unit 1 travel and Tourism Btec course ( and unit 1 examination). It could also easily be used for Ks3 Geography. Would go well with my other resource on ’ Sustainable tourism & Ecolodges’.
victoriabennett
Sustainable Tourism & Ecolodges

Sustainable Tourism & Ecolodges

This lesson introduces the concept of ‘sustainable toursim’ and then students are given a task of designing an eco-lodge according to the principles of sustainability. there is a peer assessment grid to judge the sustainability of pupil designs. This lesson was made for the Unit 1 examinatioin for Btec Travel and Tourism, but equally as good for Ks3 Geography.
victoriabennett
Unit 5: How do Hurricanes effect worldwide tourism?

Unit 5: How do Hurricanes effect worldwide tourism?

These resources were created to help students complete learning aim A in their unit 5 coursework for Btec ( climatic factors that effect tourism). There is a help-sheet for students to read about the impacts of Hurricane Sandy on the USA tourism industry. Students then use this information to complete / fill out the Power-Point slide to show their understanding from Pass to Merit level. Links for further study are provided. This template has been used successfully in my school to gain MERIT level awards. please see my other resources for Learning aim A: Snowfall in the Alps.
victoriabennett
Factors that affect Tourism: Snowfall in the Alps MERIT EXAMPLE

Factors that affect Tourism: Snowfall in the Alps MERIT EXAMPLE

This is a teacher-made example of part of a UNIT 5 coursework ( learning aim A); Factors that effect Worldwide Travel and Tourism. The factor here is snowfall, and how this impacts on the appeal of the ALPs, in France. The work shows the difference between describe and explain, and was used to help students understand the detail and quality that examiners look for in MERIT work. There are no formal activities linked to this, however students could use this to judge against their own work.
victoriabennett
Electric and Mobile Ticketing Unit 1

Electric and Mobile Ticketing Unit 1

This is a lesson which introduces the concept of e-tickets and m-tickets. Students then complete a grid to assess the advantages and disadvanatges of using these types of tickets. this resource was produced for the Unit 1 examination in Travel and Tourism.
victoriabennett
Excel Chart Types Activity

Excel Chart Types Activity

This resource can be used during a lesson with Excel Charts. It is useful to become familiar with different chart types and their application. The activities can be carried out individually, in pairs or in teams. It is always more fun to team up, as two heads are better than one and lots of discussion can be generated. Files are available in both pdf and docx format for editing if required. Preparation for Mix N Match Activity: Print out the document named ‘Chart Type Activity Answers’ Laminate the sheets (optional) Cut out all the segments Learners now match up all three elements (Chart name, Description, Picture). This activity can be timed and completed in teams to add a competitive edge. Other Activity Options: Print out the document named ‘Chart Type Activity without Chart Type’. Learners will review the description and the pictorial view and name the Chart Type. Print out the document named ‘Chart Type Activity without Description’. Hand out the cut outs of ‘Descriptions’. Learners place them in the appropriate slot. Print out the document names ‘Chart Type Activity without Picture’. Hand out the cut outs of ‘Pictures’. Learners place them in the appropriate slot.
Resource_Creator
A Level Psychology and Extended Project Qualification (EPQ) taster lesson

A Level Psychology and Extended Project Qualification (EPQ) taster lesson

Psychology taster focuses on Attachment types and encourages students to complete a quiz to find out their own (sensitive questions!) It also included the ‘Marshmallow Test’ by Mischel. EPQ taster session briefly outlines the course and then allows students to practice critical thinking skills by examining sources for and against the ‘Legalise Cannabis’ debate. Both are roughly 45 minutes, summer preparation booklets compliment these lessons.
Findlotte
Psychology & HSC Handbooks / Independent Learning

Psychology & HSC Handbooks / Independent Learning

Includes; 2 handbooks for AQA Psychology and BTEC Health and Social Care which you’ll need to adapt to meet your own departments needs. ‘Nandos’ themed differentiated tasks for Approaches and Attachment (Psychology) and Unit 1 and Unit 2 (HSC) - Again, adapt these if needed, the template is very easy to create additional topics. Independent Record Book template - Students to fill in what activities that are completing in ‘Private Study’ periods and what they have learnt from it.
Findlotte
PSHE : One Year's KS4 / KS5 PSHE

PSHE : One Year's KS4 / KS5 PSHE

One year, (36 hours) of PSHE lessons for KS4 / KS5 : 1 whole year of highly-rated and popular PSHE resources. From financial and study skills to bullying, relationships education, applying to uni, recognising fake news and finding a career - this really is a comprehensive pack for KS4 or KS5. If you were looking for the Complete KS3 Three Year’s of PSHE Pack, then you can find that here. Complete KS3 PSHE Pack for 7, 8, 9. This pack contains 36 x fully resourced, highly-rated PSHE lesson packs and units (KS4/5). All 36 lesson packs (bundled into 20 downloads) are complete with at least one hour-long powerpoint, accompanying differentiated worksheets, clip links with questions, plenaries, clear LOs, starters and engaging activities and all are well differentiated to three levels throughout. These resources have been highly-rated individually by TES users, follow the same consistent format and are easy to pick up and use. They are all planned according to 2018/19 PSHE Association guidance and created in preparation for the new statutory RSE guidance from the DfE. **EC Resources has created lessons for The Children’s Commissioner, MACS Charity, The CCRC and has completed PSHE commissions for schools across the UK. ** These resources could also be used in Tutor Time, in which case there is enough material for 72x half an hour sessions. There is zero extra work required (although everything is editable if you do want to adapt it), and the whole bundle also follows specific KS3/4 PSHE Association topic recommendations and Ofsted latest RSE/Safe Students guidance. I use all of these myself as a Head of PSHE and I really hope you find them excellent value. I’ve put literally months of time into this to make these lessons top quality for my own school team. I also have a **ONE YEAR OF CITIZENSHIP **bundle (37 lessons) available here. and I have a ONE YEAR OF RE bundle (36 lessons) available here: and finally a **ONE YEAR OF KS3 HISTORY **(36 lessons) available here. Many more inexpensive and free resources for each secondary year group at my shop:
EC_Resources
Careers KS4 Unit

Careers KS4 Unit

6 hour PSHE careers unit to help prepare students for the world of work. Originally created for KS4 but easily editable forany secondary school class too. This unit covers: Writing an amazing CV Preparing for and being excellent at work experience Preparing for and nailing job interviews Your rights and responsibilities as an employee The rights and responsibilities of employers to you The benefits of joining a trade union Includes: 6 x 1 hour Powerpoints, differentiated worksheets for all tasks, clips with question activities, group tasks, fun paired activities, literacy focus tasks, measurable, colour-coded LOs to three levels of challenge throughout - everything you need to teach an engaging PSHE unit. More PSHE lessons for KS3, KS4 and KS5 can be found here.
EC_Resources
End of Term Activity Pack!

End of Term Activity Pack!

End of Term Activity Pack 10 PAGE pack of classroom-ready summer end of term activities will enthuse and engage students. Suitable for KS3 and KS4 students to celebrate the end of term through a variety of activities. This booklet has been created by a dedicated team of experts and will allow competition, peer reflection and SMSC. It can be used to help students engage, through a range of stimulating exercises, encouraging discussion and liven up lessons through structured engagement between students. This Booklet Contains: o Various thought provoking challenges o Design Activities o 10 pages of ready-to-use student worksheets designed to be written on o A wide range of activities, to suit all types of learners. o Minimal preparation required – Just print and go! Can be used for a whole lesson or two. This resource will engage, educate and motivate your students – fantastic for quick and easy planning! Like us on Facebook Follow us on Twitter
thecre8tiveresources
Transition Activity Pack

Transition Activity Pack

Transition Activity Pack 12 PAGE pack of classroom-ready activities will enthuse and engage students. Suitable for KS3 and KS4 students to get to know each other through a variety of activities. This booklet has been created by a dedicated team of experts and will allow competition, peer reflection and SMSC. It can be used to help students engage with one another, through a range of stimulating exercises, encouraging discussion and liven up lessons through structured engagement between students. This Booklet Contains: o Topical debates of issues surrounding the school environment o Various thought provoking challenges o Design Activities o 12 pages of ready-to-use student worksheets designed to be written on o A wide range of activities, to suit all types of learners. o Minimal preparation required – Just print and go! Can be used for a whole lesson or two. This resource will engage, educate and motivate your students – fantastic for quick and easy planning! Like us on Facebook Follow us on Twitter
thecre8tiveresources
World Cup 2018 : Bingo

World Cup 2018 : Bingo

World Cup 2018 : Bingo Use this in conjunction with our <a title=“World Cup Selector” href=“https://www.tes.com/teaching-resource/world-cup-2018-world-cup-2018-selector-interactive-11911414”>World Cup Selector</a> This is a simple Bingo template for you and your pupils to use during the World Cup Festivities. It includes a blank Bingo template and a sheet with the names of the 32 countries taking part in the World Cup. We hope that you enjoy this resource! We would love your feedback, if you like what you see, please follow us: on Tes <a href=“https://www.tes.com/teaching-resources/shop/TeachElite”>TeachElite’s Shop</a> click the’Follow this Author button’ . We will keep you updated on any sales we throw or FREEBIES we upload. <br /> <br /> You can find us on Twitter: https://twitter.com/TeachEliteRE<br /> and Facebook: https://www.facebook.com/TeachElite/
TeachElite
VCERT UNIT 1 EXEMPLAR

VCERT UNIT 1 EXEMPLAR

FOR THOSE COMPLETING THE LEVEL 2 IN CRAFT. THIS UNIT IS ONE I PRODUCED WITH MY GROUP IT IS CRITERION REFERENCED AND IS A GOOD EXAMPLE OF HOW TO GO ABOUT COMPLETING A STAND ALONE FOLIO FOR UNIT 1. IT HAS BEEN STANDARDISED BY A MODERATOR AT MERIT/DIST LEVEL.
abiann123
Environment Drop Down Day

Environment Drop Down Day

5 x fully resourced, hour long lessons all about caring for the environment and living sustainably (KS3/4). Each includes: a one hour PowerPoint, worksheets, clips, is differentiated fully for MA,LA + Core and is designed to fit Ofsted criteria for’ Good’ to ‘Outstanding’. Everything is fully editable. Each resource pack has individually been rated highly by Tes users. Many more inexpensive and free resources at my shop: EC_Resources Leave me a review and pick any other resource for free :)
EC_Resources
Whole Unit of Work for Structures (Construction/ Engineering) The Spaghetti Challenge

Whole Unit of Work for Structures (Construction/ Engineering) The Spaghetti Challenge

A whole Unit of work covering lots of different aspects of Structures. Student’s build their knowledge on how structures are stable and how they are built. They then can use this knowledge to design and build a Spaghetti Structure which can withstand external force or pressure. A student friendly Powerpoint with lots of a activities, leveled WALT’S/ WILFs for each lesson and main work sheets/ resources which can be printed directly from the powerpoint. This is versatile for any Design Technology/ Construction or Engineering Course or STEM activities. Topics/ Lessons: Famous Structures Mega Structures Types of Structure Materials Forces: Compression Tension Torsion Shear Technical Drawing (Very Basic) Defects and Decay Triangulation Quality Control Bridges Planning Domes Geodesic
hridgus
BTEC Tech HSC - C2 LA.A

BTEC Tech HSC - C2 LA.A

3 powerpoints which include a variety of lessons and activity. Coursework support activities to prepare students LA.A Brief and case studies are included for ease but are available for free on the Pearson website.
Findlotte
Practical Construction Skills (Bricklaying/ Tiling/ Painting)

Practical Construction Skills (Bricklaying/ Tiling/ Painting)

A set of lessons presented in a student friendly powerpoint which includes lots of different classroom based activities for Tiling, Painting and Bricklaying. WALTs and WILF’s are leveled and allows students to build up knowledge before they start practical tasks. Originally designed for WJEC Construction and the Built Environment course it is very versatile activities for all vocational Construction courses. Lots of ideas you can use :)
hridgus
BTEC Tech Award Health & Social Care Component 3 Health plan Case study example - Mrs.Green

BTEC Tech Award Health & Social Care Component 3 Health plan Case study example - Mrs.Green

A 27 slide PowerPoint case study of Mrs.Green which includes her physical health indicators; BMI, Chloresterol, peak flow and fitness leves as well as a mental health assessment. There is an overview of short and long term goals for students to start getting an idea of planning to improve someone’s health. All areas of the Component spec are considered as discussion starters, giving your students an overview of this unit and the 3 hour exam they face. For more CTEC and BTEC Levels 2 and 3 Health & Social Care resources, follow me on TES to find my wide range of resources in one place with a handy search facility to save time. https://www.tes.com/member/HSCresources
HSCresources
BTEC Tech Award Health & Social Care Component 3 A1. Physical and lifestyle factors affecting health

BTEC Tech Award Health & Social Care Component 3 A1. Physical and lifestyle factors affecting health

A package of NINE PowerPoints to aid in the delivery of Component 3 A1. Physical and lifestyle factors affecting health, the content covered is below:- Definition of health and wellbeing: a combination of physical health and not just the absence of disease or illness. Including a range of perspectives about health and how people view health advice. Genetic inheritance, including inherited conditions and predisposition to other conditions, with reference to Angelina Jolie’s decision to have a douoble mascetomy and uterus/ovaries removed. Physical and lifestyle factors that can have positive or negative effects on health and wellbeing and government recommendations… • ill health, the difference between - acute and chronic • diet (balance, quality and amount) • amount of exercise; stamina,strength, flexibility, balance and co-ordination • substance use, including alcohol, nicotine • personal hygiene and infection control For more CTEC and BTEC Level 2 and 3 resources, follow me on TES to find all my resources in one place with a handy search facility, to save time. https://www.tes.com/member/HSCresources Happy teaching :-)
HSCresources