1. Resources Home
  2. Primary
  3. Computing
  4. Data and information
  5. Interpreting and presenting data
Computer Science Bundle

Computer Science Bundle

All of my Computer Science resources as I am soon to be moving to another subject.
MZCS
Google Sheets - Data Log with Automatic Graphs

Google Sheets - Data Log with Automatic Graphs

This Google Sheet is setup to create data logs with automatic graphs. It is very easy to use. Students enter their data in the colored cells and the graph is automatically created. Included: • 5 different graph types. One on each tab. • Each graph has room for 200 entries. Decide how many to use. • Information page on using tabs. • Information page on using the chart. • Information page on using the graphs. Some Usage Ideas: • Surveys • Math Facts • Grades • Science Labs Students will never lose their data graphs again as this uses Google Drive!
rombop
Crazy Zoo - Intro to Spreadsheeting

Crazy Zoo - Intro to Spreadsheeting

This presentation is designed for KS3 as an introduction to spreadsheeting. Included files are the presentation, the finished spreadsheet and a homework / assessment sheet.
jkemm
ACID - Database

ACID - Database

The methods of capturing, selecting and exchanging data The referential integrity Transaction processing, ACID (Atomicity, Consistency, Isolation, Durability), Record Locking and Redundancy
Kaujo
Interesting projects with  your micro:bit, How to: Bloodhound SSC

Interesting projects with your micro:bit, How to: Bloodhound SSC

Written by Adrian Oldknow (CCITE) for the Bloodhound Project, this is a comprehensive ‘How -to’ guide to adapt your micro:bit for projects such as an automatic plant waterer, to a smart lighting system. The BLOODHOUND Project is a global Engineering Adventure, using a 1,000mph World Land Speed Record attempt to inspire the next generation to enjoy, explore and get involved in science, technology, engineering and mathematics. For more information on our inspiring workshops, activities, videos, and resources, visit www.bloodhoundssc.com, or follow us on twitter: @Bloodhound_EDU.
Bloodhound_EDU
Using the micro:bit as an accelerometer - customising the script using touch develop.

Using the micro:bit as an accelerometer - customising the script using touch develop.

A guide to adapting the code on a micro:bit to use as an accelerometer in a Bloodhound SSC Rocket car. Create a cheap and reliable data logger for motion and velocity practicals by adapting a BBC micro:bit and free software. This information supports a Bloodhound SSC Rocket Car workshop, designing, building and racing model rocket cars. The BLOODHOUND Project is a global Engineering Adventure, using a 1,000mph World Land Speed Record attempt to inspire the next generation to enjoy, explore and get involved in science, technology, engineering and mathematics. For more information on our inspiring workshops, activities, videos, and resources, visit www.bloodhoundssc.com, or follow us on twitter: @Bloodhound_EDU.
Bloodhound_EDU
Computer Science Flash Activity Sheets

Computer Science Flash Activity Sheets

Prepare your computer science students for Exam season with this great practice resource! This versatile resources is aimed to develop your GCSE computer scientists retrieval skills and practice a range of fundamental skills which consistently appear within GCSE computer science exams. This resource includes a pack of 10 activity sheets within both PowerPoint and PDF format. I have included three different versions: Student pack - activity sheets only Teacher pack - answers (with explanations) only Student self assessment pack - both activity and answers Skills covered include: ASCII conversion Understanding binary and hexadecimal values Binary, denary and hexadecimal conversion Huffman coding Binary addition Memory size conversions These activities can be used as classroom starters, homework or as main classroom activities. It is recommended that these activities are used to practice and assess students ability to perform these skills, not as an introduction. Please leave a review!!!
RobbotResources
KS3 Electronics Design and Technology: Bloodhound SSC: Electrical Systems of a 1000mph Car.

KS3 Electronics Design and Technology: Bloodhound SSC: Electrical Systems of a 1000mph Car.

2 min 26 video showing how we rig the Electronic System of Bloodhound SSC. The electronic systems are are the lifeblood of the car. In a state-of-the-art racing car with three engines, three braking systems and over 500 sensors, the electrical systems are key. Systems Technician Milton explains the wiring loom in the cockpit. The BLOODHOUND Project is not only about building a car to go 1,000mph, but it is also a perfect vehicle for education of STEM subjects. Over the life of this project we’ve been able to inspire over 2 million young people! For more activities, videos, resources and information on workshops visit, www.bloodhoundssc.com, or follow us on twitter: @Bloodhound_EDU.
Bloodhound_EDU
KS3/GCSE Computing Telemetry Bloodhound SSC Jet and Car Sensors and Data video

KS3/GCSE Computing Telemetry Bloodhound SSC Jet and Car Sensors and Data video

The BLOODHOUND Project is not only about building a car to go 1,000mph, but it is also a perfect vehicle for education of STEM subjects. Over the life of this project we’ve been able to inspire over 2 million young people A two minute video clip demonstrating how we collect data using hundreds of sensors and use this data to adapt and improve the car. Sensors and data will play a key role in getting BLOODHOUND SSC safely to 1,000mph. Find out how BLOODHOUND’s engineers will be using them at every step of the journey, from UK runway testing to the high speed runs on the Hakskeen Pan, South Africa
Bloodhound_EDU
Complete IGCSE ICT 0417 teaching and learning resources / Grade 9-10 / Year 10-11

Complete IGCSE ICT 0417 teaching and learning resources / Grade 9-10 / Year 10-11

Hi ICT teachers, I have created this resource bundle with teaching resources that will last for two academic years. You can view details of all of them individually. I am sure you will find these very useful not only for conducting ICT lessons, but also managing the ICT department in your school. NOTE: Please make sure to download this resource immediately upon payment. You can send me a private message or contact me on my site for any further FAQs.
zsirajdin
GCSE Computing Exam Style Questions and Answers - OVER 30% OFF

GCSE Computing Exam Style Questions and Answers - OVER 30% OFF

**GCSE Computing Exam Question for Students and Teachers. ** Great for analysing answers in class as a starter or student revision. These questions are worth between 6-8 marks and are concerning Ethical, Legal and Clutural Issues. The questions are based off of the OCR (9-1) GCSE New Exam Papers. OVER 30% OFF as apposed to buying separately!
ET-5063
Using Minecraft to display binary ASCii codes

Using Minecraft to display binary ASCii codes

Who is this for: This is an introductory lesson to get pupils thinking about how computers use binary to store information, then displaying representations of ASCII characters using Minecraft. Pupils will not need to know exactly how binary conversion takes place, this can be covered in later lessons. The focus of this lesson is to understand that data such as text can be represented by 1’s and 0’s. Resources Included: Powerpoint to cover main theme of lesson ASCii Worksheet for pupils to use to convert their name to ASCII and Binary Binary Converter.xlsx to help pupils convert denary to 8 bit binary Review Short 7 question review test I have started recently to use MinecraftEDU in my computer Science lessons as a large proprtion of my Y7 and 8 pupils are very interested in it. Working in an SEND school the use of Minecraft has really helped to engage my pupils and has led to some great learning adventures for them and myself. In lessons I will usually join pupils on the server so that I can assist them and get involved first hand with their learning. This lesson introduces binary in a fun way to get pupils thinking about how data can be represented in a computer, then uses Minecraft to represent binary data. I have extended this lesson sometimes to give pupils the challenge of decoding messages other pupils have set up using minecraft torches. The possibilities are endless! Please share any ideas and Review if you find it useful. Thanks If you would like any help setting up MinecraftEDU or advice please contact me : email: twitter: MrT_CompSci
MrTCompSci
Database Query-by-example

Database Query-by-example

Practice exercises for query-by-example database questions. Created for a GCSE Computer Science class but suitable for anybody who needs to use query-by-example in databases or for users of software (such as MS Access) which use query-by-example grids.
astburyp
Questionnaires (everything you need to know)

Questionnaires (everything you need to know)

This thorough pack includes: A detailed but simple presentation on questionnaires Examples of open and closed questions + activity. Advantages and disadvantages of questionnaires in depth. Activity for students to create their own questionnaire based research experiment (template provided).
Cecil6
Excel Project from beginner to advanced

Excel Project from beginner to advanced

This is a mini project that lasts about 60-100 minutes depending on the ability of the students. I used this for my year 9 and 10 students but it can also be used for other years. Allow them to create the project themselves as they will learn how to merge cells and add borders to the cells as well as other formatting skills. This project includes using a lot of functions and useful tools in excel and is great if you want the students to learn independently. This project is super easy to mark as all you need to do is check whether they have completed the set tasks and give them a grade and a comment. If the students forget or do not know how to create Vlookups or If statements then I direct them my Youtube channel which actually has a tutorials on how to do both of them. The link can be found below. Let me know if this is useful or helpful to any of you.
MrSaleem
Crack the Binary Code – Seasonal Monthly Messages (Save £10)

Crack the Binary Code – Seasonal Monthly Messages (Save £10)

Teach your students how to encrypt and decrypt binary messages as well as understand binary code. This resource includes a hidden seasonal themed message for each month of the year which students need to decrypt using the key (ASCII Table). Students are also given the option to write their own encrypted binary message. This is a perfect CS unplugged activity and can be used as an introduction to a lesson, for homework, for early finishers or even when you have no access to computers in the computer lab. This is an ideal activity for the ISTE Standard of Computational Thinking/ Thanks to the following for all images: • A Sketchy Guy • www.edu-clips.com • https://www.teacherspayteachers.com/Store/Krista-Wallden-Creative-Clips • http://www.teacherspayteachers.com/Store/Monster-Wrangler-Mike • http://www.teacherspayteachers.com/Store/Artifex • http://www.teacherspayteachers.com/Store/Teachers-Clipart • “Template/Clipart courtesy of Activities by Jill @ http://www.teacherspayteachers.com/Store/Activities-By-Jill • Watson Works: http://www.teacherspayteachers.com/Store/Watson-Works • www.teacherspayteachers.com/Store/Classroom-Doodle-Diva • Teachers Scrap Book: • http://www.teacherspayteachers.com/Store/Teacherscrapbook • http://www.teachersnotebook.com/shop/TeacherScrapbook/products • REVIDEVI - http://www.teacherspayteachers.com/Store/Revidevi) • Chirp Graphics: https://www.teacherspayteachers.com/store/chirp-graphics • Whimsy Clips: www.whimsyclips.com
balsamgr8
Excel Spreadsheets Seasonal Mystery Pictures Fill Color Bundle - Computer Lab

Excel Spreadsheets Seasonal Mystery Pictures Fill Color Bundle - Computer Lab

Save £21 by purchasing this bundle Students will need to use the “FILL TOOL” to color certain cells in the spreadsheet to reveal a hidden seasonal picture. This resource is for both students beginning to learn Microsoft Excel and for experienced users. This resource includes 34 hidden mystery pictures (excel files) – with instructions on how the image can be revealed. This bundle contains the following hidden pictures: • 4 Presidents Day Mystery Pictures • 6 St. Patricks Day Mystery Pictures • 6 Valentine’s Day Mystery Pictures • 6 Halloween Mystery Pictures • 12 Christmas Mystery Pictures • 6 Easter Mystery Pictures Answer Key included
balsamgr8
Spreadsheet Essentials - Everything you need for 10 lessons for KS3 Computing / ICT

Spreadsheet Essentials - Everything you need for 10 lessons for KS3 Computing / ICT

10 Lessons dedicated to teaching Students everything they need to master the basics of Spreadsheets: • Calculations • Simple Functions • IFs • Conditional Formatting • Relative and Absolute Cells • Copying and Pasting Formulas to speed up work Each lesson has full resources and exemplars and reflection sheet to round off the unit of work (good for life after levels) Lessons included are: • Spread Sheets 1 - The Basics - Maths Functions / Simple Formatting • Spread Sheets 2 - The Basics - Exchange Rates and Absolute Cells • Spreadsheets 3 and 4 - Collecting / Collating Data AND Intro to Graphs / Charts • Spread Sheets 5 - The Basics - IFs and Conditional Formatting • Spread Sheets 6 - The Basics - Functions - Averages, Max, Min • Spread Sheets Lesson 7/8/9/10 - The Basics - Spreadsheet Battleships - Putting it all together 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 Harvey Taylor (2018)
haltest
Intoduction to Spreadsheets

Intoduction to Spreadsheets

2 interactive coloured spreadsheets which allow the user to work out the answers ucing formulae. Perfect for introducing how to perform calculations on spreadsheets.
tesmny
An interactive resource that explains how digital images are created and stored on computer.

An interactive resource that explains how digital images are created and stored on computer.

This is a short introduction to how digital images are created and stored on computers. I have used that as an introductory lesson for the Creative iMedia course R082 unit. Further lessons can go into much more technical detail, but this lesson introduces the concept of pixels and bit depth. An interactive macro-enabled spreadsheet allows students to create a 32 X 32 image using only 8 colours to simuate using a 4-bit image. The denary and binary representations of the image are then displayed in the spreadsheet. A print button prints out students work, pre-formatted to fit on one page. The spreadsheet is similar to PixelArt that students create in Minecraft. A starter Word-Fit of keywords is included, and a suggested plenary activity. Update: Have now fixed issue in the Spreadsheet that stopped the values updating across the three worksheets.
MrTCompSci
Make worksheets, edit images and sign docs

Make worksheets, edit images and sign docs

This tutorial teaches you how to use the screenshot feature in iOS11 to annotate images, create worksheets and sign documents. Answer tests without printing: You can also follow the worksheet section of the tutorial to allow pupils to fill in a document without printing it off. Just send the document to the pupils who can then take a screenshot of the form, test or worksheet and then add text boxes to fill in their reply.
osiejiofor316
Roman Statistics

Roman Statistics

A range of statistics around a Roman theme. Contains statistics on population and area data during the Roman Republic and Empire. Can be used for maths or computing activities. Statistics have been collected from a range of sources: there may be some inaccuracies due to the long time scales.
Danny7107
Binary Tarsia Puzzle

Binary Tarsia Puzzle

This tarsia puzzle has binary to denary conversions, binary addition, units of measurement and questions to gauge the understanding of binary and denary.
MZCS
Full Set GCSE Computing Revision Flash Cards!

Full Set GCSE Computing Revision Flash Cards!

GCSE Computing Revision Flash Cards for Students. This bundle has money off, as apposed to buying the Flashcards separately. £25 instead of over £30! 20% Off compared to if you bought them separately. Based off of the OCR Specification (9-1)
ET-5063
Python Programming Project on Animated Movies

Python Programming Project on Animated Movies

Over 1000 downloads but only 1 review so far. Kindly do give your feedback/comments on it. To know this, is important for me to bring further exciting free resources. A small practical programming project is designed and developed to learn the programming. It specifically teaches about creating and using functions, selection, iteration and file I/O, list, dictionary and string objects and how to combine them all into solving some practical problems. One other important thing students will learn is the importance of Data, how to get and manipulate it for different interesting results. You can use it independently with students to practice the basic building blocks of programming and improving their problem soling skills. You can also find the sample solutions which were developed in IDLE with Python version 3.6.3 I hope you and your students will enjoy it and please do give the feedback/comments on how you find it as it will be very useful for me to bring further interesting projects or worksheets. Happy Coding
shahidcaan
Variables for Computer Science. KS3 / GCSE

Variables for Computer Science. KS3 / GCSE

A great intro to Variables to reflect on the best practices for potential computer scientists when dealing with variables! Deals with: •Understand what variables are •Know the different variable types •Understand how variable names are chosen 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. The contents of this page and all downloaded materials are copyrighted Harvey Taylor (2018)
haltest
Starter For Ten Enterprise Project

Starter For Ten Enterprise Project

This is the full set of resources which make up the Starter For Ten project. Starter For Ten is a whole term, cross-curricular project for upper primary classes. A series of lessons provide the class with the knowledge and skills they need to start their own businesses in small groups. Groups are loaned £10 to start their business with the businesses running for four weeks after around six weeks learning and preparation. Starter For Ten provides a highly motivating, real world context for learning with pupils taking full responsibility for their businesses. The pupils are also responsible for making key decisions including what to spend any profit on and whether to act as philanthropists and opt to donate a proportion of their income to charity. The full project covers a number of curriculum areas: literacy, numeracy, health and wellbeing, religious and moral education, social studies and technologies. All lessons are fully linked to the Scottish Curriculum For Excellence. Each of the fourteen lessons includes a lesson plan, a PowerPoint presentation and any worksheets or other resources required. Lesson plans include learning objectives, suggestions for differentiation, a starter activity, a main lesson, a plenary activity, suggestions for further development, opportunities for display, and relevant second level Curriculum For Excellence experiences and outcomes.
activelinkslearning
Starter For Ten Enterprise Project. Lesson Nine - Market Research

Starter For Ten Enterprise Project. Lesson Nine - Market Research

This is the ninth lesson in a series of fourteen which make up the Starter For Ten project. Starter For Ten is a whole term, cross-curricular project for upper primary classes. A series of lessons provide the class with the knowledge and skills they need to start their own businesses in small groups. Groups are loaned £10 to start their business with the businesses running for four weeks after around six weeks learning and preparation. Starter For Ten provides a highly motivating, real world context for learning with pupils taking full responsibility for their businesses. The pupils are also responsible for making key decisions including what to spend any profit on and whether to act as philanthropists and opt to donate a proportion of their income to charity. The full project covers a number of curriculum areas: literacy, numeracy, health and wellbeing, religious and moral education, social studies and technologies. All lessons are fully linked to the Scottish Curriculum For Excellence. Each of the fourteen lessons includes a lesson plan, a PowerPoint presentation and any worksheets or other resources required. Lesson plans include learning objectives, suggestions for differentiation, a starter activity, a main lesson, a plenary activity, suggestions for further development, opportunities for display, and relevant second level Curriculum For Excellence experiences and outcomes. LESSON 9 OVERVIEW: During this lesson the uses of Market Research for businesses are discussed using a theoretical business ‘The Pencil Case Company’ as an example. The children then design, conduct and present their own market research. LESSON 9 LEARNING OBJECTIVES: 1. I can create a questionnaire which will provide me with information to help my business. 2. I can analyse and present data to show what my customers want from my business.
activelinkslearning
Python Coding- A Beginners Revision and Activities Booklet

Python Coding- A Beginners Revision and Activities Booklet

Python Coding- A Beginners Revision and Activities Booklet. For students studying computer science and using python in their work. This booklet covers: Python- definition of what it is and what it does Identifiers- examples, definition and how they are used Variables -examples, definition and how they are used Functions -examples, definition and how they are used Modules -examples, definition and how they are used Classes -examples, definition and how they are used Activity Key Words -examples, definition and how they are used Syntax -examples, definition and how they are used Structure -examples, definition and how they are used Logical Operators -examples, definition and how they are used Variables and Value -examples, definition and how they are used Function -examples, definition and how they are used Syntax of Function -examples, definition and how they are used Function Call -examples, definition and how they are used Doc string -examples, definition and how they are used The Return Statement -examples, definition and how they are used Activity Classes -examples, definition and how they are used Modules -examples, definition and how they are used The dir() Function -examples, definition and how they are used Input and Output -examples, definition and how they are used Create a Code -examples, definition and how they are used Create a flow chart -examples, definition and how they are used Activity Loops-examples, definition and how they are used Activity Breaks-examples, definition and how they are used Activity Arrays -examples, definition and how they are used Activity That's about it really, it goes off on the basics as well as some tricky questions, there are additional activities but I have not got all day to list them. I am a very busy lady with no planning time. Put together by me and has helped my Year 11's and Year 10's understand it a lot more.
fizzysparkler