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.

#### Excel Workbook

A workbook containing a mixture of information and tasks based on the subject of Microsoft Excel, including formatting, formulas and graphs

#### Assignment (DS for Kids aONP)

10 single-page resources. A beginner’s guide to the assigning of values to data structures held in memory. For age range 11+

#### 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+

#### 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.

#### 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

#### Computer Science Y8 Extended Essay Research Activity

My activity sheets for Y8 extended essay Included marking rubric and levelling descriptors for this task

#### 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 &amp; 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.

#### OCR GCSE Computing - Translators presentation task

Student are required to create a presentation on translators in groups or pairs, to present to rest of the class

#### 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!

#### 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)

#### 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 &amp; 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 &amp; Planning Sheets Plus Lots of How-to Suggestions

#### Graphic Arts Bundle> Activities + Projects + PowerPoints=Complete Semester Pack!

Graphics Semester Bundled for Bonus \$avings! Curricula Outlined for ENTIRE Semester Worth of Projects. Individual Accompanying Aids, PowerPoints &amp; Assignments

#### 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.

#### Graphic Arts PowerPoints 4-Pack = *Logos *MockUps *Thumbnails *Project Charters

Save on this Informative Graphic Arts 4-Pack bundle packed with Activities and creative techniques . Includes ALL 4 of these PowerPoints that can be purchased separately as well.

#### 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 &amp; challenge activities Plenary Homeworks (Logic gate presentation included)

#### ORAL CoMmUnIcAtiOn, WRITTEN & LANGUAGE Arts Skills Complete Curricula Bundle!

Bundled Bonus \$avings! Every Patty Ann Communication Book is Included in this Packet!

#### 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!

#### 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.

#### 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.

#### ACID - Database

The methods of capturing, selecting and exchanging data The referential integrity Transaction processing, ACID (Atomicity, Consistency, Isolation, Durability), Record Locking and Redundancy

#### 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.

#### 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.

#### 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.

#### 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.

#### Logic Gates and Types of Data

The 5 Types of Data are described with 10 Questions per type of data. With Logic Alphabet explained with 5 exercises.

#### 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!!!

#### 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

#### 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.

#### 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!

#### GCSE Computing Exam Style Question with Answer: School Software

GCSE Computing Exam Question for Students and Teachers. Great for analysing answers in class or student revision. Based off the OCR (9-1) GCSE See the Full Bundle for a Discounted Price!

#### GCSE Computing Exam Style Question with Answer: School Saving Pupil Data

GCSE Computing Exam Question for Students and Teachers. Great for analysing answers in class or student revision. Based off the OCR (9-1) GCSE See the Full Bundle for a Discounted Price!

#### 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.

#### 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).

#### AS & A2 Computer Science Searching and Sorting Revision Questions

AS &amp; A2 Computer Science Searching and Sorting Revision Questions. 65 marks worth of questions with mark scheme.

#### 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.

#### 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

#### 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

#### 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