1. Resources Home
  2. Primary
  3. Computing
  4. Evaluating digital content
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
Mobile Application Development Activity

Mobile Application Development Activity

This could be used whilst teaching ‘Appshed’ to KS3 students. It would be a good homework for either the 1st or 2nd week as it begins to questions the features of mobile applications which will support when students begin to draft their own applications. This could either be used as an activity in class or as a homework.
HDLouise
Researching the Aztecs - KS2

Researching the Aztecs - KS2

This resource includes: PPT Starter Integrated handbook for students to complete all about ‘the Aztecs’ ‘Code breaker’ plenary Lesson plan Support ‘cheat sheet’ for L.A Students This lesson plan is based around using ‘microsoft encarta’ for researching, however the lesson could easily be used alongside other similar software. Enjoy!
HDLouise
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
R081 - Creative I-Media Exam - Personal Learning Checklist

R081 - Creative I-Media Exam - Personal Learning Checklist

This personal learning checklist is perfect for students when monitoring/self assessing their strengths and weaknesses in the R081 OCR Creative I-Media Exam. This document can be updated by students during and outside of lessons and is a perfect revision tool that covers all of the main topics.
Charliesep21
R081 - Creative I-Media Exam - Knowledge Organisers

R081 - Creative I-Media Exam - Knowledge Organisers

These 5 knowledge organisers outline everything students need to know for the R081 OCR Creative I-Media exam. They each fit on one single side of A4 paper and are neat and orgnaised. Students can use them to learn content and then test themsleves in and out of lessons, they can also be used to asisst teachers with key information and topics to cover.
Charliesep21
R081 - Creative I-Media - Flashcards

R081 - Creative I-Media - Flashcards

In this document there are over 60 Flashcards that can be used to test students on all of the key knowledge for the R081 OCR Creative I-Media exam. The flashcards cover all learning objectives and can be used both in lessons and at home.
Charliesep21
R081 - Creative I-Media Exam - Scheme of Work

R081 - Creative I-Media Exam - Scheme of Work

This detailed and comprehensive scheme of work for the R081 Creative I-Media exam will enable teachers to cover all of the relevent course content in detail. Embedded into this scheme of work are all four Learning Objectives, interleaving and spacing and retrieval plenaries. Assessment points have also been added to assist teachers with low risk high frequency assessment tracking.
Charliesep21
Animation Planning and resources Y5 and Y6

Animation Planning and resources Y5 and Y6

This resources is for a 5 week plan for animation using Ipads for a mixed 5/6 class. It compromises of 6 lessons, differentiated with white board slides to follow and resources; including learning intentions and worksheets to plan. It looks at the world of Morph and dips into shaun the sheep. this resource is easily editable to suit a different key stage 2 age group or adapt to use different apps or resources. Each lesson lesson 1 - looking a apps for animating lesson 2- planning an animation lesson 3 - creating the animation lesson 4 - script writing lesson 5 - evaluating the app
bgjwh06
Past, Present and Future Technologies (STEM Activities)

Past, Present and Future Technologies (STEM Activities)

Teach your students about technologies that changed the world. What made them so successful? How did some become completely superseded or obsolete? And what will replace them in the future based upon what we know about history and the wants and needs of our society? This collection of 20 beautiful past and present technology cards are accompanied with 4 easy to follow activities and lesson plans to get your students thinking like a STEM designer, entrepreneur and innovator.
Innovativeteachingideas
Paper Helicopter STEM Challenge (PBL)

Paper Helicopter STEM Challenge (PBL)

Can you make the ultimate paper helicopter? Do you understand the principles of flight and gravity? How will you design, enhance, “tinker” and most importantly record your data and evidence of your findings? All these essential questions will be answered through these excellent HANDS ON STEM activities. Everything is here for you NO PREP REQUIRED The only materials required are paper, paper clips and scissors. This project can be distributed individually via Google Classroom, OneNote or a similar platform or you can teach it to the entire class. All content and materials are easy to follow and fully prepared. Become an engineer today and have some great fun learning about the basic principles of flight and gravity.
Innovativeteachingideas
STEM Accelerators - KS3 Computing Online Safety

STEM Accelerators - KS3 Computing Online Safety

Due to the prevalence of technology, cyber security is one of the greatest opportunities and threats humankind knows. Your pupils will already use computers on a daily basis, but probably don’t pay much attention to personal data, or even know what it is! It’s time to change that, and this lesson is a great place to start bringing together elements of both the IT and computing curriculum. It will also teach your class the Army-inspired skills of critical thinking, team work, leadership and perseverance.
BritishArmySupportingEducation
Excel Pivot Table Exercise / Task

Excel Pivot Table Exercise / Task

This resource has been developed as a practice Exercise for learners who have been introduced to Pivot Tables in Excel. It is a practical task that can be undertaken in teams, pairs or individually. It includes a set of data that needs to be analysed. Learners are required to brainstorm questions that a Sales Manager would need to know about the transactional data. They then create pivot tables based on the questions. There is a second spreadsheet that contains 8 sample questions and pivot tables that relate to the questions. This activity has been well received in my classroom of adult learners. They become very engaged in the process and develop a better understanding of the use of pivot tables.
Resource_Creator
Spreadsheet A&E - OCR Cambridge Nationals Information Technologies

Spreadsheet A&E - OCR Cambridge Nationals Information Technologies

This is a resource that goes through each of the formulae that students need to know for the course. It has an activity for them to practice each formula and apply it to a working situation. My students come back to this when they build any spreadsheet and can’t remember how to do a certain formula.
gwhiting7
KS3 Unit - Innovators in Technology

KS3 Unit - Innovators in Technology

Yr 7, 8 or 9 unit of work looking at several innovators in technology including Turing, Ive, Musk, and Zuckerberg. Students complete an activity for each innovator Ciphers, Design, AI, and Data Protection respectively. During the final lesson they choose an innovator of their own to research. Each lesson they complete the above activity, research the innovator, and add to a brochure (or other document) which is their final assessed piece of work. Unit includes: Teachers PowerPoints - has answers, videos and timers on each* Student PowerPoints - basic tasks One Homework assignment - assessed using teacher feedback and student response format (separate so they don’t need to take workbooks home with them) - ready to print in A5 two to a page One final assessed brochure (or easily modified for other DTP; website, PPT, etc) with Marks Scheme based on iMedia course Student workbook which could either be held online (Google Classroom, O365) or printed for each student to work through. This unit is particularly good for non-specialists or cover staff to deliver and can be easily scaled up or down depending on your students ability. *Our school uses “silent tasks”, therefore each lesson will have a period of time where students will complete a task in silence. This is denoted by a character motioning for silence. Lessons are not reliant on this occurring.
dave_w_kling
PSHE: Year 11 / KS5 PSHE

PSHE: Year 11 / KS5 PSHE

18 x fully resourced, highly-rated PSHE lesson packs and units suitable for Year 11 or KS5. From Revision and Study Skills, Living Independently, RSE, Finance and Careers to Body Image, Sleep, The Dark Web and University Applications - this really is a comprehensive KS4 or KS5 PSHE lesson bundle. All 18 lessons are complete with at least one hour-long powerpoint, accompanying differentiated worksheets, clip links with questions, plenaries, clear LOs and starters. All are well differentiated to three levels throughout to enable clear evidence of progress for all students. These resources have been highly-rated individually by TES users, follow the same consistent format and are easy to follow. There is zero extra work required, and the whole bundle follows PSHE Association topic recommendations and Ofsted latest SRE/ PSHE Association guidance for Year 11. 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. Please leave me a review and I’ll send you any other resource of your choice for free. If you like the look of this, I also have a popular complete KS4 one year of PSHE pack here. Many more inexpensive and free resources at my shop - where you can find my bundles for other year groups: EC_Resources Leave me a review and pick any other resource for free :) You can also find us on facebook: https://www.facebook.com/ecteachresources/ Twitter: https://twitter.com/ec_publishing and our website psheresources.com 20s5
EC_Resources
Primary ICT / Computing report templates and statements of progression

Primary ICT / Computing report templates and statements of progression

New UK Curriculum for Computing in Prmary assessment and reports statements for year 1-6 at three levels of progression across Digital LIteracy, Digital CItizenship and Computer Science. Use the sentences as a guide for what to include in your reports for the computing segment. While these do not cover the entire spectrum of assessment for computing, they are a good representation of the most notable standards per strand for the age expected ability and represent what should be taught. Could also be used in a backwards planning model to also develop learning objectives, success criteria and lesson plans or an entire vertical curriculum.
habeebafett
Computer Science Bundle

Computer Science Bundle

All of my Computer Science resources as I am soon to be moving to another subject.
MZCS
Presentation:   how to test a system (x11 slides)

Presentation: how to test a system (x11 slides)

The presentation introduces the idea behind testing and covers the ideas behind the idea of creating a test plan, difference between a fault and an error and shows a blue screen error. It describes the importance of reliability, using different test data (typical, erroneous, exaggerated data) and how to formulate a test plan.
Teacher_aesg
SCRATCH - making a game stage 2

SCRATCH - making a game stage 2

This PowerPoint has video descriptions of how to add features to a simple driving or maze navigation game. I used it with year 3 and made this to help the teachers who were not confident or familiar with SCRATCH themselves. They were able to play the pages and then get the children designing, making, innovating and debugging their games. It is a large file, so allow time for it to download.
NickAHutson
Website Evaluation (Editable in Google Docs)

Website Evaluation (Editable in Google Docs)

This is a checklist to use to check websites for reliability. This can be used for extra practice looking for high quality sites or during the research process. Students must look for certain criteria in their selected website. They then add up the totals to see if the website can be used as a reliable source of information. Included is a printable PDF file as well as an editable Google Doc. This way you can change the website evaluation before printing it out for your students or you can provide them a digital copy.
rombop
Secure your Google Account: 2 Step Verification Guide

Secure your Google Account: 2 Step Verification Guide

When it comes to data you want secured, your email accounts are probably close to the top of the list. Strong passwords can help, but to be as secure as possible, you want to enable two-step authentication. This is a great resource to print out and have your students follow. It teaches students about 2 step verification! What You Get: • What is two-step authentication? • Setup your Google account • Alternative second steps
rombop
Timeline Template (Editable in Google Slides)

Timeline Template (Editable in Google Slides)

Best of all, this resource is available in both printable pdf format as well as a Google Slides editable format. This timeline template allows students to create a timeline with linked information for each event.The timeline page supports 11 events and has the age range of 0 to 17. If you need more events for your timeline, duplicate the slide. Your students are able to click the arrow and point it at the appropriate time. They can also double click the event boxes and write in their description. The template is locked, so your students can’t mistakenly move or delete the background. If you choose to print the PDF, have your students draw the arrows themselves. This resource includes one version with arrows on each event box and one version without any arrows, ready to print.
rombop
Blank Rubric Template Editable in Google Docs

Blank Rubric Template Editable in Google Docs

This package contains 10 different blank rubric templates. You can fill in your own grading criteria by printing them out and writing in all the information for your assignment. Alternatively, you can customize these rubrics by using Google Docs to edit them. Includes: • Google docs editing directions • Categories worth 2 points • Categories worth 3 points • Categories worth 4 points • Categories worth 5 points • Categories worth 10 points • Categories worth 3 points and 5 points (mixed) • Categories worth 3 points, 4 points and 5 points (mixed) • 3 different project based learning rubric templates
rombop
PSHE: New PSHE 2018-19 Part 2

PSHE: New PSHE 2018-19 Part 2

10 hours of new PSHE lessons on some of the most pertinent and pressing issues facing students in 2018/19. These topics have been identified by the PSHE Association as essentials for the coming year and so this bundle has been planned following their recommendations. This is part two of a two part pack. PART ONE All 10 lesson packs are complete with at least one hour-long powerpoint, accompanying differentiated worksheets, clip links with questions, plenaries, clear LOs, starters and engaging, varied main task activities.All are well differentiated to three levels throughout to enable clear evidence of progress for all students. These lessons have been selected to be in this bundle as they all focus on relatively new issues or ones which need further awareness amongst young people in an ever-changing world full of mental health issues, new technology, crime and potentially tough futures which lie ahead. These resources have been highly-rated individually by TES users, follow the same consistent format and are easy to follow. There is zero extra work required, although each lesson is still completely editable too. I use all of these myself as a Head of PSHE and Citizenship 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 have ‘One Year of PSHE’ Packs for Years 7, 8, 9 and KS4. You can check them out at the shop link below. Please leave me a review and I’ll send you any other resource of your choice for free. Many more inexpensive or free resources at my shop: EC_Resources
EC_Resources
Technology in the News Activity

Technology in the News Activity

**Technology in the News Activity ** The resource includes a word processing and a PowerPoint version. There are links within the resources to a variety of news articles which students can browse and investigate. The activity is applicable to KS3 and KS4 computer studies and links to Legal, Ethical, Cultural and Environmental aspect of GCSE computer studies. Activities can be saved and used as an ongoing activity. The activities can be used as a starter, plenary, homeworks or as part of a class activity leading on to discussions about various aspect of computer science / studies.
conxxion