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
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 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
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
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
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
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
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
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
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
OCR Computer Science - Data Representation - Lesson 1 - 1-9

OCR Computer Science - Data Representation - Lesson 1 - 1-9

Lesson explaining how Data representation works. There is a PowerPoint which walks through two methods of conversion but it also specifies how to use binary. It explains to students place value and compares denary to binary. Lesson 1 in a series of 4 lessons. Students will also learn about: - Switches Binary Exam questions Binary conversion using switches Binary conversion using division Binary grid method Least / Most significant bit] Worksheet provided Content written by Ray Chambers - National Teaching Award Winner - 2015 - Innovative use of technology
r_chambers
Excel Bundle

Excel Bundle

This package includes all my top selling Excel resources including How2Excel, an introductory guide to the use of Excel and Excel Jurassic Park, where you're put in charge of the finances and budget of your own dinosaur Park! Also included within the bundle: How to create an interactive spreadsheet Excel sport tournament planner (includes some really useful ranking techniques to create live changing league tables.
RobbotResources
Learning to Create Infographics using Piktochart - Internet Research Project

Learning to Create Infographics using Piktochart - Internet Research Project

In this lesson, students learn more about what makes an effective infographic as they analyze existing infographics and then create their own. Included with the lesson is a Microsoft PowerPoint presentation for whole class instruction (editable) to learn about infographics and analyze them as a class. Infographics with discussion questions are included in the PowerPoint. Next, students choose a topic of interest, research their topic and then create an infographic using Piktochart (www.piktochart.com), a free Web 2.0 tool that does not require download. A Quick Start Guide for the program is included to help students navigate the program. Topic suggestions are included in the teacher/student resource material. These infographics look great printed and displayed in the hallways! This lesson was designed for middle school (grades 6-8) but could be used in upper elementary grades or high school as well. It can be used for any subject that wants to incorporate technology in a lesson. Files included: • Teacher & Student Resources • Infographics Presentation (whole class with discussion questions) in MS PowerPoint (editable) • Research worksheet (two versions – for individual or teams) • Infographic Project: Student expectations, instructions and grading rubric • Quick start tutorial for Piktochart
innovationsintechnology
Year 5 (KS2) -Investigating Network (& Internet Safety) Computing Lesson Plan & PowerPoint Resources

Year 5 (KS2) -Investigating Network (& Internet Safety) Computing Lesson Plan & PowerPoint Resources

A complete lesson plan designed for Year 5, Key Stage 2. The lesson is part of the Investigating Networks lessons. The lesson has a 5 minutes on Internet Safety (a current Ofsted focus), then a 15-20 minute main input time and then 30 minute group/individual activity. All resources are listed, along with key assessment questions. A full PowerPoint is also included in this lesson. Please add reviews and comments.
jbullen
Virtual Road Trip -Research, Planning & Budgeting Project

Virtual Road Trip -Research, Planning & Budgeting Project

***Want to bring more real-world learning to your classroom?**** This is the perfect project to get kids excited about learning how to research, plan and budget for a road trip. They will choose their destination, the accommodations and three attractions to visit - all while having to stay within their $1000 budget. This project includes math and language arts. Students will answer word problems and balance their budget. They will also write their opinion on attractions they have visited. The final part of the project is creating three virtual postcards from locations your students have "visited". I have provided a template in PPT and a link for the Google Classroom. All you have to do is print this out and the project is ready to go. Complete Student Examples Included for each step of the project. Project rubric included.
sarah_mcnamara43
Microsoft Excel Video Guides - School Production

Microsoft Excel Video Guides - School Production

This resource contains 66 videos which take students through how to use the basics and more advanced features of MS Excel. An intro video showing what students will create can be found here. https://drive.google.com/file/d/0B_VegnuzyG2GOGR5NFdxZnFoRUk/view?usp=sharing 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