Understanding and Using Databases (9 Lessons)

Understanding and Using Databases (9 Lessons)

Understanding and Using Databases This Unit could be taught at Key Stage 2 or Key Stage 3 (Year 7-8). This unit introduces the students to Microsoft Access. It includes 9 lessons that involves students exploring the software whilst understanding the basics. For example students are asked to: Explain what a database is and its uses (give examples) Understand both paper based and electronic databases Design and create a Superhero Database from scratch Add and edit records in the database Ask the database questions in order to search Create different types of queries to search (basic, multiple and Boolean) Produce a report to show evidence of understanding Unit includes an overview of all the lessons and an overall teacher/students assessment checklist.
samoliver368
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
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
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
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
Ancient History Big Bundle!

Ancient History Big Bundle!

THIS BUNDLE CONTAINS EACH OF THE ANCIENT HISTORY KNOWLEDGE ORGANISERS, IN ADDITION TO THE ANCIENT HISTORY POINTLESS GAMES! The clear, detailed and visually-appealing knowledge organisers offer complete reference points for students learning or revising knowledge relating to each of the following ancient history topics: Ancient Egypt; Ancient Greece; The Romans. Each organiser contains a number of comprehensive sections explaining the key elements of the topic, timelines detailing key times and events, diagrams and images to visually aid understanding, and key facts to extend the learning of higher attaining students. The resources are designed to be printed onto A3, and are provided as both PDFs and Word documents (so that you can edit should you wish to). All images used are licensed for commercial use and are cited on a separate document (included). Based on the popular game show, the ‘Pointless’ games are perfect for use as whole lesson resources, enrichment options, or revision tools. The games are editable, so that you can change to any other topic or change questions. Each game contains around 25 slides of sound clips, engaging visuals, and suitably challenging questions and they are effective at both promoting engagement and enhancing learning. There are several full rounds of questions to build or revisit knowledge of Romans, Ancient Egyptians, and Ancient Greeks. The nature of the games ensures that the resources can challenge students of all levels. A blank template has also been added, so that you can create your own games!
TandLGuru
Cluedo murder mystery riddle - adaptation from Einstein's '5 houses' logic puzzle

Cluedo murder mystery riddle - adaptation from Einstein's '5 houses' logic puzzle

**Mr Black has been found dead at Tudor Manor. ** You are the lead investigating detective. You have all six suspects brought to the main hall of the mansion, seated next to each other around a circular table. Every one of them has a motive to murder Mr Black, but only one committed the crime. Can you solve the case and bring the killer to justice? Who killed Mr Black? What weapon was used? Where was the weapon hidden? This activity is an adaptation of mine based off Einstein’s ‘five houses’ logic problem Students extract relevant information from text; create an appropriate data structure to record these facts; and use a process of elimination to solve the problem I have been using it with KS4/5 Computer Science classes to demonstrate computational thinking (abstraction and decomposition)
mailmikejenkins
Marketing 2-Week Outline Lesson Plan  > Project - Activity & Store Promotion + 4 PowerPoints

Marketing 2-Week Outline Lesson Plan > Project - Activity & Store Promotion + 4 PowerPoints

This is a 2 Week Lesson Plan OUTLINE for introducing students to Decision Making & Concept Building for Promotion. Students will take the concept of the “Corner Store” and develop branding and advertising around a theme. This lesson is active and will engage students in critical thinking exercises. The packet comes complete with: Teacher Notes for Guidance All PowerPoints Class Handouts All Grading Rubrics Daily Objectives Time Management Suggestions Lesson Targets & Planning Sheets Plus Lots of How-to Suggestions
PattyAnnsPetProject
Graphic Arts Lesson Plans All-in-One ~ Full Curricula Book + 4 PowerPoints

Graphic Arts Lesson Plans All-in-One ~ Full Curricula Book + 4 PowerPoints

“All-in-One Graphic Arts Lesson Plan” is a complete curriculum- or use as a supplemental educational aid. Lesson ideas are outlined with guidelines. Packed with true-life application assignments! This Teachers Edition comes with: ~ Instructional Aids and Outlines ~ Interactive Activity Lessons ~ Ready-Made Assignments for Full Semester ~ Rubrics Included for Grading ~ Easy Modular Curriculum to Implement ~ INCLUDES 4 PowerPoints -Integrated into the Curriculum.
PattyAnnsPetProject
Lessons:   linear & binary search

Lessons: linear & binary search

Lessons (x1 hour) on linear and binary searches and logic gate presentation GCSE Computer Science. Starter activities Presentation on linear and binary searches View simulations of both searches Worksheet questions Stretch & challenge activities Plenary Homeworks (Logic gate presentation included)
Teacher_aesg
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
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
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
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
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