1. Resources Home
  2. Secondary
  3. Computing
  4. Data and information
  5. Collecting and organising data
Website Basics: EASY Lesson Plans 4 Teachers = Full Curricula with Activities!

Website Basics: EASY Lesson Plans 4 Teachers = Full Curricula with Activities!

A great introduction to website construction. Use as a complete curriculum or as a supplemental educational aid. Packed with lesson activities! Highlights Include: ~ Learn basic HTML codes ~ Use notepad to construct a website ~ Web terminology ~ Page design and re-designs ~ Create a personal website ~ Story boarding ~ Project planning with project charters ~ Create tables, lists, links + more ~ About browsers, domains and web hosting ~ JavaScript and Cascading Style Sheets Comes with: ~ Self Guided Lessons ~ Teachers Grading Rubrics and Criteria ~ Student and Peer Evaluations ~ Empty Rubric Templates** This is a full semester’s worth of curricula. If you need a pre-made, EASY lesson plan for “Website Basics” > Here it is!
PattyAnnsPetProject
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
Stack data structure

Stack data structure

The presentation describes what a stack data structure is, introduces the principle operations of PUSH / POP along with the stack pointer using simple, easy to understand diagrams. The presentation includes pseudo code for the PUSH / POP operations and describes three uses of the stack data structure.
Teacher_aesg
Presentation about data types

Presentation about data types

The presentation introduces five different data types; boolean, integer, real, date/time, string. Each slide describes the data type and gives examples of what they can represent.
Teacher_aesg
Unit 18 / 19 / 20 Cambridge Technicals Level 3 *Triple Pack*

Unit 18 / 19 / 20 Cambridge Technicals Level 3 *Triple Pack*

**Unit 18 / 19 / 20 Cambridge Technicals (2016) Level 3 Triple Pack ** This rescource will provide you with the relevant resoucres to complete the following units on the Cambridge Technicals units: Unit 18 - Hardware Unit 19 - Software Unit 20 - Technical Support Combine these 3 units with the examination units (1 & 2) to achieve 1 A Level for your students! Each unit is available on their own in my shop, the 3 together offered at over 40% off!
msmarwaha
ICT/INPUT, OUTPUT AND STORAGE DEVICES

ICT/INPUT, OUTPUT AND STORAGE DEVICES

A totally animated presentation that explains the concept of input, output and storage devices. The presentation also includes 20 questions that makes fun the recap part. Also there are an assessment and a poster in this resource. May this will be helpful for everyone.
Copolat
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
Unit 20 - Technical Support- Full Unit, Cambridge Technicals Level 3 (2016)

Unit 20 - Technical Support- Full Unit, Cambridge Technicals Level 3 (2016)

Here you will find the resources to complete Unit 20 in the level 3 Cambridge Technicals. All of the Learning Objectives have been covered within the lessons provided. The assignment which has been used has also been checked using the Assignment Checking service from OCR. (Service is £30 per assignment) Enjoy!
msmarwaha
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 micro:bit for data logging and modelling, How-to Guide Bloodhound SSC

Using micro:bit for data logging and modelling, How-to Guide Bloodhound SSC

Written by Adrian Oldknow (CCITE) for the Bloodhound Project, This comprehensive guide helps you set up your micro:bit for physics practicals recording temperature, light intensity and more. 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
Turn your micro:bit into an accelerometer data logger using free bitty app. How to:

Turn your micro:bit into an accelerometer data logger using free bitty app. How to:

Need a quick and reliable motion data logger for speed/ distance practicals? Add a battery pack to your micro: bit and download the free bitty software.( www.bittysoftware.com ) This ‘how-to’ guide can work alongside the Bloodhound SSC Project, 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/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
SQLite3 in Python

SQLite3 in Python

This bundle contains a worksheet and powerpoint guiding students through SQLite 3 in Python using Object Oriented methods and classes - this is therefore aimed at A Level students. Teachers should go through the Powerpoint slide by slide with their students, and then at each new stage get the students to copy and adapt the code into their own programs, so they learn how to build the class step-by-step. A comprehensive worksheet has also been provided to allow students to evidence and check their knowledge, as well as create a dictionary of all new vocab and statements. A copy of the powerpoint should be given to students.
mro2013
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
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
Visual Basic / DataSet / Data Table ( Part 1 )

Visual Basic / DataSet / Data Table ( Part 1 )

For Student in college of computer Science ,software engineering, and information technology . it is very helpful content about storing data in the data base by using visual basic interface . Resources : Microsoft 4 by Tim Patrick
saif_4tech
Visual Basic /DataSet / Data Table ( Part 2)

Visual Basic /DataSet / Data Table ( Part 2)

For Student in college of computer Science ,software engineering, and information technology . it is very helpful content about storing data in the data base by using visual basic interface . Resources : Microsoft 4 by Tim Patrick
saif_4tech
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
Excel Skills Development

Excel Skills Development

This resource consists of a PowerPoint and Excel Spreadsheet. Originally designed for ECDL but can be used to develop a students skills in the following: - Formatting - Formulas - Functions - Copy Handle - Sorting Data - IF Statements - Charts - Freezing Panes
ndaviesmadeley
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
Spreadsheet and Chart Drawing Guide and Activities

Spreadsheet and Chart Drawing Guide and Activities

Guide and Activities for Year 11-13 spreadsheets, charts and spreadsheet modelling and applications aimed at the 9626 or AS Applied ICT curriculum. Also useful for GCSE ICT and iGCSE students. One file did not upload as it is an Access file. Email em at enderoth@hotmail.com for this or a zip of everything.
enderoth
BTEC L3 NQF - IT - Unit 5: Data Modelling

BTEC L3 NQF - IT - Unit 5: Data Modelling

This resource takes BTEC Level 3 students through how to do the skills needed for Unit 5 of the BTEC NQF Level 3 course. It contains 66 videos which take students through how to use the basics and more advanced features of MS Excel. This is a tried and tested unit which works with a broad range of abilities and usually takes about 8 hours to complete in full. Students need to create a school production spreadsheet which contains IF Statements, charts, vLookups, Macros, Conditional Formatting to name but a few. The pack contains a checklist which students can use to monitor their progress. The checklist also links to all of the videos.
aglasgow