1. Resources Home
  2. Primary
  3. Computing
  4. Data and information
Using Spreadsheets (8 Lessons)

Using Spreadsheets (8 Lessons)

Using Spreadsheets This Unit could be taught at Key Stage 2 or Key Stage 3 (Year 7). This unit introduces the students to Microsoft Excel. It includes 8 lessons that involves students exploring the software whilst understanding the basics. For example students are asked to: Explain what a spreadsheet is and its uses Edit and format an existing spreadsheet Understand and use basic formula and functions Create and label graphs and charts correctly Produce a report to show evidence of understanding Unit includes an overview of all the lessons and an overall teacher/students assessment checklist.
samoliver368
Network topologies, protocols and layers for OCR GCSE (9-1) in Computer Science (J276)

Network topologies, protocols and layers for OCR GCSE (9-1) in Computer Science (J276)

This student networks workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about computer network topologies to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.5 Network topologies, protocols & layers” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 27-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: Network topologies Star network topology Mesh network topology WiFi Frequency Channels Encryption Packet Switching Bandwidth Ethernet IP address MAC address Network Protocols TCP/IP HTTP HTTPS FTP POP IMAP SMTP TCP/IP model The 4 layers of network protocols Application layer Transport layer Internet layer Link layer
nwilkin
Wired and Wireless Networks for OCR GCSE (9-1) in Computer Science (J276)

Wired and Wireless Networks for OCR GCSE (9-1) in Computer Science (J276)

This student networks workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about wired and wireless networks to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.4 Wired and wireless networks” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 29-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: What is a network? Types of network Local Area Network (LAN) Wide Area Network (WAN) Factors that affect the performance of networks Bandwidth Number of devices Cable or wireless media Error rate Latency The different roles of computers in a client-server and a peer-to-peer network Client Server Peer-to-Peer The hardware needed to connect stand-alone computers to a LAN Stand-alone computer Network Interface Controller/Card Transmission Media Switch Router Wireless Access Points The internet Domain Name Server Hosting Cloud storage Local storage compared to cloud storage Cloud computing Security and ownership of data and software on the cloud Virtual Networks
nwilkin
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
Year 7 Computing/ICT Scheme of work & Resources

Year 7 Computing/ICT Scheme of work & Resources

Complete collection of Scheme of work, lesson plans, Power Points and homework for Year 7 introduction to computing and ICT. Includes: Topic 1 - Introduction & using computers safely and effectively • 7 Lessons, Power Points, Assessment, Homework and Pupil Progress Diary Topic 2 - Introduction to coding through Scratch • 5 Lessons (can be stretched depending on pupil progress), Power Points, Assessment, homework and Pupil Progress Diary Topic 3 - Spreadsheet Modelling • 6 Lessons, Power Points, Assessment, homework and Pupil Progress Diary All lessons are ready to teach and require minimal, if any preperation (may need tweaking to work with your school system) - everything is provided! Pack includes a scheme of work with lesson objectives and lesson overview and how these lessons fit into and satisfy the new National Curriculum for Computing. Ideal resource for non-specialists to follow, or for a specialist to pick up and run with. Feel free to adapt the resources as needed. All lessons are ready to teach. Year 8 and Year 9 packs coming soon.
Confusion101
1&2 Bit Binary Art

1&2 Bit Binary Art

This tool creates 10 by 10 one-bit-per-pixel or two-bits-per-pixel binary images from a binary string of 0 and 1s. The choice of colour palette is left to the user with a default black and white option. Works well with snipping tool to use as part of a computing science digital portfolio. could be used in a wide variety of lessons within the context of data representation.
OliverJennings
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
Binary and Hexadecimal for GCSE

Binary and Hexadecimal for GCSE

A high quality, complete course for the teaching of binary and hexadecimal concepts for GCSE. Students can scan the QR codes in the worksheet to see a video of the question being worked through, step-by-step, this ensures that all students of different ability levels can access the content and practice the skills. Contains: A full set of teaching presentations showing step-by-step how-to guides to each type of conversion (Keynote/PowerPoint/PDF) A comprehensive set of worksheets with explainers and QR code based video workthroughs (PDF) Front page (how-to guide) Binary to Denary Denary to Binary Binary Addition Binary Subtraction Hexadecimal to Denary Denary to Hexadecimal Binary to Hexadecimal Hexadecimal to Binary Bitwise Manipulation (Bit shifting) Answers One PDF file with all of the above Assessment set: Synoptic assessment (Word/PDF) Markscheme (Word/PDF) Markscheme workthrough (PDF) Question level analysis document (Excel) Guide to using the Question level analysis document This covers the specification for all major GCSE courses and can also be used for KS3 and the basis of KS4 Computer Science. Please feel free to mix and match as appropriate.
lessonhacker
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
Lesson:   computer networks

Lesson: computer networks

The lesson on computer networks is appropriate for KS3 and GCSE standard. Lesson plan outlining the structure of the lesson. Starter asking pupils to build a computer network using network components (answers included). Presentation on the advantages / disadvantages of computer networks. Reference to an external video on computer networks. Reference to an external computer network simulation Worksheet requiring pupils to give a definition, example and a diagram of PAN, LAN, WAN computer networks. Presentation on PAN, LAN, Wan describing each kind of network. Stretch & challenge activity, research into WIFI networks sheet Plenary true or false presentation Homework to make a video explaining the different types of computer network
Teacher_aesg
Excel Workbook

Excel Workbook

A workbook containing a mixture of information and tasks based on the subject of Microsoft Excel, including formatting, formulas and graphs
dominicberesford1993
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
GUESS WHO COMPUTATIONAL THINKING CHALLENGE (STEM & DIGITAL TECHNOLOGIES )

GUESS WHO COMPUTATIONAL THINKING CHALLENGE (STEM & DIGITAL TECHNOLOGIES )

☀️ This has got to be one of our most engaging STEM activities yet!!! An absolute cracker of a resource for teaching COMPUTATIONAL THINKING, ALGORITHMS, MATHS and TECHNOLOGY. The challenge is simple… CAN YOU CREATE THE PERFECT FACIAL RECOGNITION ALGORITHM? It draws upon the classic game “GUESS WHO?” to instantly engage students with ease. The learning is incredibly deep and this resource could easily FILL A WEEK of class time or a single 90 minute session depending on how far you wish to go… And it’s completely EDITABLE Whats inside ⭐Computational Thinking resources and activities related to the topic ⭐Teacher Hints and Tips ⭐ Complete lesson plans ⭐ Facial Recognition Lessons and Content ⭐ Removable / Hints and Tips for Beginners ⭐ Lessons on Data and Attributes ⭐ Custom made Graphic Organizers ⭐ Custom made Flowcharting Activities ⭐ Heaps of digital video and interactive content ⭐ Literacy related tasks to the ethics of facial recognition ⭐ Glossary of terms ⭐ Video tutorial explaining the perfect solution ⭐ Assessment and Reflection Tool Compatibility with Google Classroom and NO PREP REQUIRED
Innovativeteachingideas
Computer Science Poster: How to read and write Edexcel pseudo code

Computer Science Poster: How to read and write Edexcel pseudo code

This handy poster is a great revision tool to help your GCSE computer scientists prepare for their computational thinking problem solving paper! Although focused around Edexcel specification, it is also easily applicable for others. This poster will help your students to both understand what the pseudo code means within exams as well as help them write their own, well structured pseudo code. Update: High Resolution 1440x2560 in both PNG & JPEG Please leave a review
RobbotResources
STEM/Coding Activities

STEM/Coding Activities

STEM & Coding Resource Get your students engaged in fun hands on STEM activities! Use everyday materials in your classroom and get building! This resource also comes with 10+ computer coding activities for beginners.
VanessaHM11
GDPR Lesson (General Data Protection Regulation)

GDPR Lesson (General Data Protection Regulation)

GDPR Lesson (General Data Protection Regulation) Lesson Objectives Learn about the General Data Protection Regulations Understand the consequences of breaking the GDPR This lesson takes students through the new GDPR rules, risk areas and explains how companies can comply with the new regulations. This is more of an introduction lesson for Key Stage 3 (could be used for Key Stage 4). Consequences are also briefly covered. Students then answer questions using a test paper to check their learning.
samoliver368
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
GCSE Computer Science - Number systems resource pack

GCSE Computer Science - Number systems resource pack

Pack of all my resources for Computer Science number systems topics. Includes: Posters and wall displays for converting denary to binary and vice versa Posters and wall displays for converting hexadecimal to binary and vice versa Number line wall display including denary, binary, and hexadecimal numbers Number line wall display including denary and negative binary numbers (in sign and magnitude and two’s complement) Binary shifts worksheets (with answers) Binary revision worksheets (with answers) End of unit binary test (with answers) Binary crossword
csteacher2048
GCSE Computer Science posters pack

GCSE Computer Science posters pack

A collection of posters suitable for GCSE Computer Science and IB Computer Science. Includes: Matching binary, hexadecimal, and denary numbers Converting between binary, denary, and hexadecimal numbers 14 unique posters total, each with black background and white background versions.
csteacher2048
Computer Science denary to hexadecimal posters

Computer Science denary to hexadecimal posters

Collection of 8 hexadecimal themed classroom posters (plus variations). Perfect for GCSE Computer Science and IB Computer Science classroom displays. Collection includes: 2 posters for calculating the denary value of hexadecimal numbers 2 posters for calculating the hexadecimal value of denary numbers 2 posters for matching denary to hexadecimal 2 posters for matching binary to hexadecimal Posters are fully editable Word documents and each includes a version with a black background and a version with a white background (to save ink). A3 sized, but obviously can be printed smaller.
csteacher2048
What is an ALGORITHM

What is an ALGORITHM

An introduction to algorithms using a flowchart with sequence, selection and iteration. The worksheet provided enables students to slow down their thinking to focus on each instruction in the algorithm until the last instruction is executed and the program ends.
chris_vidal
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
Data Storage - Presentation Project

Data Storage - Presentation Project

The resource is specifically based against the IGCSE Computer Science syllabus, but is suitable for any Data Storage module. It includes some knowledge tests at the beginning and leads on to creating 5 groups to work on a presentation about a different element of Data Storage. The group worksheets can be handed out or sent electronically and each has a series of keywords to prompt research. Each group is challenged with answering one Big Question and explaining it to the class at the end of the lesson. If you find the resource useful please leave a review so that others can find it. HackDragn
hackdragn
World Cup 2018 Spreadsheet Project Resource Pack

World Cup 2018 Spreadsheet Project Resource Pack

An ICT Spreadsheet project all set up to launch the 2018 FIFA World Cup in Russia - Aimed at Year 9 and KS4 3 resources available: a student template, with no formatting, formulae or functions; a teacher demo version, containing examples of a number of advanced features; finally a fully functioning working model showing a range of advanced features. A great motivational resource for teaching IF / COUNTIF Functions; relative & absolute cell referencing; defining cell names; macros; there is also further scope to develop the project further by incorporating graphs / charts; conditional formatting and VLOOKUP Functions. The project is set up to run through the entirety of the World Cup until its conclusion on 15 July.
craigman