1. Resources Home
  2. Secondary
  3. Computing
  4. Digital literacy
End of Year / Activities Week

End of Year / Activities Week

6 hours of easy, no prep fun for activities week - enough to last a whole day on the last day of term. Includes: A big summer End of Year Quiz A creative, fun teamwork lesson where you make an important figure from 2018 out of scrap. A teamwork lesson and a competitive team-building activity. A World Cup Quiz A SPAG + Whole School Literacy Quiz A fun lesson on risk taking, to remind your students to keep safe this summer. A confidence boosting, positive hour-long session to have your students leaving in a happy and life-affirming mood. MORE WHOLE SCHOOL RESOURCES You can also find us on facebook: https://www.facebook.com/ecteachresources/ Twitter: https://twitter.com/ec_publishing and our website psheresources.com
EC_Resources
Quiz : Summer Quiz

Quiz : Summer Quiz

A massive end of year quiz with loads of fun rounds designed to interest a wide range of student tastes (but still be a little educational too!) Rounds include: 2018 So Far, Music, Internet Fun and Jokes, Grammar, Spelling, Maths, Celeb in a Sandcastle and Name that Creature. The quiz is interactive, multiple choice and has hidden humorous youtube clips throughout the questions for extra clues or a commiseration giggle when the class get an answer wrong. There are two ways of playing - either as a whole class, or, you can put the quiz on slide view, skip the answers and read them out at the end (if your class would rather compete in groups). A score sheet and all answers are included. The quiz is completely editable too. If you like this, you can check out more of our whole school resources here: WHOLE SCHOOL RESOURCES You can also find us on facebook: https://www.facebook.com/ecteachresources/ Twitter: https://twitter.com/ec_publishing and our website: psheresources.com
EC_Resources
Basic Computing

Basic Computing

Purchase the full set of 5 resources and the supporting files to enable anybody to learn the basics of computing. Start with how ‘Files and Folders’ should be used then learn some practical tips when ‘Using the Internet’. Following this there are 3 practical lessons on ‘Intro to Word’, ‘Intro to PowerPoint’ and ‘Intro to Excel’. There is a starter activity for each lesson and teacher notes are included in the notes section of the PowerPoint lesson presentations. This includes challenge activities and discussion points to raise with the students. For an average group of 13 year old’s, this will take about 6 hour long sessions to complete. If you find the resource useful, please leave a review as it helps other teachers find it. HackDragn
hackdragn
Basic Computing – Using the Internet

Basic Computing – Using the Internet

This lesson focuses on practical use of the Internet rather than e-safety which is covered by many excellent websites. Students will learn about how personal information can be used against them and the need for strong passwords. There is a look at social media and the online dangers associated with using the Internet. The course then introduces how to search for reliable information and two methods for saving images for use in work. The main task involves searching for information on the Internet and allows students to practice saving and using images. As always, if you enjoyed the resource please leave a review so that others can find it. HackDragn
hackdragn
Data Structures (DS for Kids aONP)

Data Structures (DS for Kids aONP)

10 single-page resources about the abstraction of values from different representations of data. Informal introduction to variable names. For age range 11+
A_Cowie
Data Structures for Kids and Other Normal People

Data Structures for Kids and Other Normal People

(PDF - editable Word documents available) These resources can be used by colleagues teaching high school Computing Science in any education system. In particular, they reflect my interpretation of parts of the (Scottish curriculum) Level 3 and 4 Computing Science Es and Os in the Broad General Education. I have thought for a long time that coding is taught too much from a “just get on and write it” approach and there has been little emphasis on the data structures that underpin what is being written. I have found that when I ask a student to draw and name the data structures they plan to use - even if the structures contain simple, single values - their understanding (their computational thinking skills) and their ability to code independently improve immeasurably. My view of the current Scottish curriculum is that it now allows for this, and that was my motivation when I started building these resources. I have tried to create resources that are superficially appealing whilst containing academic content, in order to engage all levels of ability. These resources may go some way to fill the gap between more practical, coding activities and the theory found in certificate courses in the senior phase at secondary level. There are more to follow… I have deliberately kept each resource to one page so that they can be used out of sequence. I have not included much in the way of teacher exposition within each task, to allow for different levels of depth depending on circumstances, but the Teacher Notes include my rationale for each task, some tips/hints/notes for each resource and a reference to the (Scottish Curriculum) Benchmarks for the Es and Os.
A_Cowie
World Cup 2018 Introduction

World Cup 2018 Introduction

This resource allows pupils to investigate the world cup and complete some basic sentences. The resource also include basic trivia questions which challenge research and maths skills.
Klewis21
Coding Concepts: Concurrency Vs Dependency - Delve in, for twelve min!

Coding Concepts: Concurrency Vs Dependency - Delve in, for twelve min!

These resources accompany Part 6 of my online CPD sessions, “Delve in, for twelve min!” In this session, I highlight the issue of pupils using time as the trigger for sprite and background changes (concurrency), rather than making the sprites and backgrounds interact with each other (dependency). Please watch the YouTube tutorial first, and use these Scratch projects as examples to secure your knowledge before you teach. Please see www.rundontwalk.co.uk for more resources, or to book me for your school’s computing CPD needs.
PhilWickins
ScratchUp! A cunning combination of Sketchup (3D CAD) and Scratch (Coding)

ScratchUp! A cunning combination of Sketchup (3D CAD) and Scratch (Coding)

This is ScratchUp! A cunning combination of Sketchup (3D CAD) and Scratch (Coding) to bring your pupils’ programming projects to life! The idea for this emerged after teaching my classes Sketchup as a specific CAD tool within the DT curriculum to design lunar buggies, before then proceeding to the build stage. I was so impressed at their grasp of the software and 3D design as a concept, that I wanted to set a new challenge. Similarly, they had progressed extremely well in my computing lessons until they were quite proficient using coding constructs and concepts within Scratch, so what was the next step? I noticed that their sprite and background design within Scratch always fell short of their best, probably as they were so keen to code and get their project working. It was all coloured blobs and stick men; purely functional, but little in the way of inspiring graphical user interfaces! Enter: Sketchup. I decided that they could use their design skills to create high quality sprites, then export them as a 2D graphic to be loaded into Scratch as a costume. And then it hit me.  Why not export a series of rotations of a 3D sprite, load multiple images into a sprite’s costume, then animate it, so it appears as a rotating 3D sprite? The possibilities are endless! Take a look around this resource which includes my presentation from the CAS (Computing at School) National Conference 2018, the list of angles I used for my car direction, my ScratchUp examples, pupil Sketchup and ScratchUp examples and a Sketchup help sheet. Let me know how you get on!!! www.rundontwalk.co.uk
PhilWickins
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
Microsoft Word Shortcut Keys A-Z

Microsoft Word Shortcut Keys A-Z

This resource is a worksheet that contains a list of Word shortcut keys from Ctrl A to Ctrl Z. Learners fill out the worksheet to the best of their ability either individually or as a group exercise. An answer sheet is provided. They can then go and try out all the shortcuts for themselves.
Resource_Creator
Win A Robot World Cup Football Drawing Competition

Win A Robot World Cup Football Drawing Competition

Last week I found a small UK tech company which was giving out great computer prizes and no-one was entering them. I decided to use them to create a drawing competition in my class - after all what is more motivational to a class than a great chance of winning! I used it to share ideas about what makes a great invention. We discussed ideas of what would or would not win - then created our work of art. INVENT THE 2098 WORLD CUP Future Inventors, we have a new challenge for this week. The World Cup is about to start and it got us thinking: what will the 2098 World Cup look like? Flying referees? Virtual stadiums? Techno-vuvuzelas? Submit your ideas and the winner gets a FREE kit and see it become a project on Club Make! We accept ALL ideas: practical, fun to absolutely bonkers. Entering the challenge is super easy: just draw your idea and share it below! They accept submissions until the 24th of June at http://bit.ly/WinARobot.
peterfogarty
Under the Sea #GoogleExpedition

Under the Sea #GoogleExpedition

Under the Sea - using Google Expedition to explore Coral Reefs around the world and create a short animation using Scratch to show the different animals and highlight the impact humans are having on Coral Reefs. Grade 3 Geography and Computer Science Google Expedition - Underwater Excursion Scratch - creating a short animation
r_coathup
[GCSE + IGCSE] TCP/IP Revision Tasks

[GCSE + IGCSE] TCP/IP Revision Tasks

A few of my revision activities bundled together which were previously listed separately which were highly downloaded. Fill in the blanks activity for students to complete (I have included my answers for this) Second activity as part of the revision to cut out and place the correct answers to correspond to how data is processed through the protocol stack
PaperAirplane
[GCSE + IGCSE] The Bigger Picture (Emerging trends, issues and impact)

[GCSE + IGCSE] The Bigger Picture (Emerging trends, issues and impact)

This is my unit of work to introduce the majority of the Bigger Picture unit. It also is a good research and discussion activity that links to other areas of the course - networking for example and the Internet of Things which has been in several exemplar question papers. It also gives rise to discuss Embedded Systems, discussions covering the whole of Topic 5 and making it relevant to real world examples. I have included in the file my overview of the three lessons that I spend on this. Of the four subsection of Unit 6. It has activities that can be used to introduce, or recover 6.1.1 - 6.1.3 The carousel activity features 5 real world scenarios linked to smart devices, embedded systems which students then record and share their thoughts on the impacts that it has. Class teacher/Students can gather thoughts and lead discussion based on students thoughts - good revision activity, or to assess understanding before progressing in this unit of work.
PaperAirplane
Cipher Wheel for Primary Cryptography

Cipher Wheel for Primary Cryptography

Encryption & Decryption Cipher wheel for primary pupils from iCompute’s primary computing scheme of work 6-8 week cryptography unit. Teach your pupils about encryption methods and learn the importance of privacy in the modern digital world with iCompute. Credit : www.icompute-uk.com
iCompute
Coding Apps with BitsBox - Lesson Plan

Coding Apps with BitsBox - Lesson Plan

Design & Develop Mobile Apps A computing lesson plan and associated resources for KS2 children designing and developing a game for mobile devices. Includes step-by-step lesson plan, support materials and pre-written program files. More free primary computing lessons and resources available at iCompute
iCompute
World Cup Ticket Design

World Cup Ticket Design

Graphics lesson in ICT that can be taught over 2 lessons to teach skills in a graphics software. Had to remove all images relating to Fifa due to copyright issues with the last resource I put up.
nicci86uk
Child Sexual Exploitation - CSE

Child Sexual Exploitation - CSE

A unit of 7 x 1 hour long, fully resourced PSHE lessons (in 6 downloads) with a focus on CSE (Child Sexual Exploitation). This pack has been prepared to fit the PSHE Associations recommendations for 2018/19. Everything is well differentiated, contains well-structured and easy to follow Powerpoints, clips and worksheets but also is all editable, so you can always change it to suit your classes if you like. All the lessons have been highly rated and reviewed by Tes users and I have always used these as Head of PSHE / Life Skills too. Variety of different level tasks for MA,LA or Core - Differentiated to 3 levels - Designed to fit Ofsted criteria for’ Good’ or above - Meets all Ofsted ‘Safe Students’ requirements. Many more inexpensive or free resources can be found at my store: EC RESOURCES
EC_Resources
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
Creative iMedia R082 Literacy Mat

Creative iMedia R082 Literacy Mat

A complete literacy mat for use with the R082 Creating Digital Graphics unit of the L1/2 Cambridge Nationals Creative iMedia course. Featuring: Graphics Terms Learning Objective Terminology File Formats Sentence Types Review Key Words The download is a hi-res PDF, optimised for printing up to A3.
tomcorney