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
Network topologies, protocols and layers for OCR GCSE (9-1) in Computer Science (J276)

Network topologies, protocols and layers for OCR GCSE (9-1) in Computer Science (J276)

This student networks workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about computer network topologies to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.5 Network topologies, protocols & layers” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 27-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: Network topologies Star network topology Mesh network topology WiFi Frequency Channels Encryption Packet Switching Bandwidth Ethernet IP address MAC address Network Protocols TCP/IP HTTP HTTPS FTP POP IMAP SMTP TCP/IP model The 4 layers of network protocols Application layer Transport layer Internet layer Link layer
nwilkin
Wired and Wireless Networks for OCR GCSE (9-1) in Computer Science (J276)

Wired and Wireless Networks for OCR GCSE (9-1) in Computer Science (J276)

This student networks workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about wired and wireless networks to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.4 Wired and wireless networks” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 29-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: What is a network? Types of network Local Area Network (LAN) Wide Area Network (WAN) Factors that affect the performance of networks Bandwidth Number of devices Cable or wireless media Error rate Latency The different roles of computers in a client-server and a peer-to-peer network Client Server Peer-to-Peer The hardware needed to connect stand-alone computers to a LAN Stand-alone computer Network Interface Controller/Card Transmission Media Switch Router Wireless Access Points The internet Domain Name Server Hosting Cloud storage Local storage compared to cloud storage Cloud computing Security and ownership of data and software on the cloud Virtual Networks
nwilkin
Most used Excel functions - function, syntax, description quick reference sheets

Most used Excel functions - function, syntax, description quick reference sheets

This resource contains a Table of the most used functions in Excel. It is separated by Core functions, Date Functions, Text Functions, and Lookup / Reference Functions. It is set out attractively in a table, the column headings being: Function Name, Syntax and Description. It gives a quick reference to over 35 different functions. It is available in a pdf and word document so that you can make any changes required.
Resource_Creator
Year 7 Computing/ICT Scheme of work & Resources

Year 7 Computing/ICT Scheme of work & Resources

Complete collection of Scheme of work, lesson plans, Power Points and homework for Year 7 introduction to computing and ICT. Includes: Topic 1 - Introduction & using computers safely and effectively • 7 Lessons, Power Points, Assessment, Homework and Pupil Progress Diary Topic 2 - Introduction to coding through Scratch • 5 Lessons (can be stretched depending on pupil progress), Power Points, Assessment, homework and Pupil Progress Diary Topic 3 - Spreadsheet Modelling • 6 Lessons, Power Points, Assessment, homework and Pupil Progress Diary All lessons are ready to teach and require minimal, if any preperation (may need tweaking to work with your school system) - everything is provided! Pack includes a scheme of work with lesson objectives and lesson overview and how these lessons fit into and satisfy the new National Curriculum for Computing. Ideal resource for non-specialists to follow, or for a specialist to pick up and run with. Feel free to adapt the resources as needed. All lessons are ready to teach. Year 8 and Year 9 packs coming soon.
Confusion101
1&2 Bit Binary Art

1&2 Bit Binary Art

This tool creates 10 by 10 one-bit-per-pixel or two-bits-per-pixel binary images from a binary string of 0 and 1s. The choice of colour palette is left to the user with a default black and white option. Works well with snipping tool to use as part of a computing science digital portfolio. could be used in a wide variety of lessons within the context of data representation.
OliverJennings
Mobile Application Development Activity

Mobile Application Development Activity

This could be used whilst teaching ‘Appshed’ to KS3 students. It would be a good homework for either the 1st or 2nd week as it begins to questions the features of mobile applications which will support when students begin to draft their own applications. This could either be used as an activity in class or as a homework.
HDLouise
Binary and Hexadecimal for GCSE

Binary and Hexadecimal for GCSE

A high quality, complete course for the teaching of binary and hexadecimal concepts for GCSE. Students can scan the QR codes in the worksheet to see a video of the question being worked through, step-by-step, this ensures that all students of different ability levels can access the content and practice the skills. Contains: A full set of teaching presentations showing step-by-step how-to guides to each type of conversion (Keynote/PowerPoint/PDF) A comprehensive set of worksheets with explainers and QR code based video workthroughs (PDF) Front page (how-to guide) Binary to Denary Denary to Binary Binary Addition Binary Subtraction Hexadecimal to Denary Denary to Hexadecimal Binary to Hexadecimal Hexadecimal to Binary Bitwise Manipulation (Bit shifting) Answers One PDF file with all of the above Assessment set: Synoptic assessment (Word/PDF) Markscheme (Word/PDF) Markscheme workthrough (PDF) Question level analysis document (Excel) Guide to using the Question level analysis document This covers the specification for all major GCSE courses and can also be used for KS3 and the basis of KS4 Computer Science. Please feel free to mix and match as appropriate.
lessonhacker
Researching the Aztecs - KS2

Researching the Aztecs - KS2

This resource includes: PPT Starter Integrated handbook for students to complete all about ‘the Aztecs’ ‘Code breaker’ plenary Lesson plan Support ‘cheat sheet’ for L.A Students This lesson plan is based around using ‘microsoft encarta’ for researching, however the lesson could easily be used alongside other similar software. Enjoy!
HDLouise
OCR GCSE Computer Science Student eBook

OCR GCSE Computer Science Student eBook

Frustrated with the lack of a straightforward, to-the-point text book for this course (OCR GCSE Computer Science J276), I decided to compile the lesson resources that I have written over the past two years into this free eBook. Besides written content and diagrams to explain concepts, I have included links to many YouTube videos that will allow pupils to go deeper into topics and learn in ways other than just reading. You should be able to simply click on the image on all “Video” pages to link to the appropriate YouTube page straight from the PDF. This eBook is released under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license, so please feel free to share it with others - teachers, pupils or whomever you think might be interested in it! However, if you do so, please do point them back to this page as means of attribution. This is the first resource that I have published on TES.com so I would love to receive your feedback, particularly if find it useful or if you have suggestions for improvement. I have worksheets that I have written for each topic with this spec that I hope to upload in due course. Other resources that might be useful to you If you do find this eBook useful, you may be interested in my YouTube channel where I have produced a number of original videos to explain Computer Science topics as well as put together playlists of great videos from other YouTubers: https://www.youtube.com/mrawdimmick Finally, if you are teaching GCSE Computer Science then you might be interested in my online Python course hosted on repl.it. As a “community” classroom you can point your students directly to it for some self-learning or you can “Import and Teach” the class into your own Repl.it Classroom for you to invite your pupils to join so that you can track their progress and provide feedback on their work: https://repl.it/community/classrooms/29589
adimmick
Try Except ValueError lesson

Try Except ValueError lesson

A one hour validation lesson which engages students and shows them why, and how we use validation. They must be taught integer input first to understand this lesson. There are bronze silver and gold outcomes and resources are on the ppt itself.
hoof_hearted
Lesson:   computer networks

Lesson: computer networks

The lesson on computer networks is appropriate for KS3 and GCSE standard. Lesson plan outlining the structure of the lesson. Starter asking pupils to build a computer network using network components (answers included). Presentation on the advantages / disadvantages of computer networks. Reference to an external video on computer networks. Reference to an external computer network simulation Worksheet requiring pupils to give a definition, example and a diagram of PAN, LAN, WAN computer networks. Presentation on PAN, LAN, Wan describing each kind of network. Stretch & challenge activity, research into WIFI networks sheet Plenary true or false presentation Homework to make a video explaining the different types of computer network
Teacher_aesg
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
Excel Chart Types Activity

Excel Chart Types Activity

This resource can be used during a lesson with Excel Charts. It is useful to become familiar with different chart types and their application. The activities can be carried out individually, in pairs or in teams. It is always more fun to team up, as two heads are better than one and lots of discussion can be generated. Files are available in both pdf and docx format for editing if required. Preparation for Mix N Match Activity: Print out the document named ‘Chart Type Activity Answers’ Laminate the sheets (optional) Cut out all the segments Learners now match up all three elements (Chart name, Description, Picture). This activity can be timed and completed in teams to add a competitive edge. Other Activity Options: Print out the document named ‘Chart Type Activity without Chart Type’. Learners will review the description and the pictorial view and name the Chart Type. Print out the document named ‘Chart Type Activity without Description’. Hand out the cut outs of ‘Descriptions’. Learners place them in the appropriate slot. Print out the document names ‘Chart Type Activity without Picture’. Hand out the cut outs of ‘Pictures’. Learners place them in the appropriate slot.
Resource_Creator
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 Poster: How to read and write Edexcel pseudo code

Computer Science Poster: How to read and write Edexcel pseudo code

This handy poster is a great revision tool to help your GCSE computer scientists prepare for their computational thinking problem solving paper! Although focused around Edexcel specification, it is also easily applicable for others. This poster will help your students to both understand what the pseudo code means within exams as well as help them write their own, well structured pseudo code. Update: High Resolution 1440x2560 in both PNG & JPEG Please leave a review
RobbotResources
STEM/Coding Activities

STEM/Coding Activities

STEM & Coding Resource Get your students engaged in fun hands on STEM activities! Use everyday materials in your classroom and get building! This resource also comes with 10+ computer coding activities for beginners.
VanessaHM11
OCR CAMBRIDGE NATIONAL in INFORMATION TECHNOLOGIES LEVEL 1/2 (Lessons 21-32)

OCR CAMBRIDGE NATIONAL in INFORMATION TECHNOLOGIES LEVEL 1/2 (Lessons 21-32)

This series of resources includes: presentations, worksheets, home learning tasks, etc. covering lessons 21-32. They follow module 6, activity 1 through to module 9, activity 3 of the OCR scheme of work (delivery guide). Each of the presentations follows an identical format: introduction, starter, objectives, research, tasks, home learning, and plenary. Please note: although Home Learning tasks have been produced as separate worksheets, these same home-learning tasks also exist in each lesson worksheet.
ttootle
OCR CAMBRIDGE NATIONAL in INFORMATION TECHNOLOGIES LEVEL 1/2 (Lessons 11-20)

OCR CAMBRIDGE NATIONAL in INFORMATION TECHNOLOGIES LEVEL 1/2 (Lessons 11-20)

This series of resources includes: presentations, worksheets, home learning tasks, etc. covering lessons 11-20. They follow module 3, activity 4 through to module 5, activity 3 of the OCR scheme of work (delivery guide). Each of the presentations follows an identical format: introduction, starter, objectives, research, tasks, home learning, and plenary. Please note: although Home Learning tasks have been produced as separate worksheets, these same home-learning tasks also exist in each lesson worksheet.
ttootle
OCR CAMBRIDGE NATIONAL in INFORMATION TECHNOLOGIES LEVEL 1/2 (Lessons 1-10)

OCR CAMBRIDGE NATIONAL in INFORMATION TECHNOLOGIES LEVEL 1/2 (Lessons 1-10)

This series of resources includes: presentations, worksheets, home learning tasks, etc. covering lessons 1-10. They follow module 1, activity 1 through to module 3, activity 3 of the OCR scheme of work (delivery guide). Each of the presentations follows an identical format: introduction, starter, objectives, research, tasks, home learning, and plenary. Please note: although Home Learning tasks have been produced as separate worksheets, these same home-learning tasks also exist in each lesson worksheet.
ttootle
GDPR Lesson (General Data Protection Regulation)

GDPR Lesson (General Data Protection Regulation)

GDPR Lesson (General Data Protection Regulation) Lesson Objectives Learn about the General Data Protection Regulations Understand the consequences of breaking the GDPR This lesson takes students through the new GDPR rules, risk areas and explains how companies can comply with the new regulations. This is more of an introduction lesson for Key Stage 3 (could be used for Key Stage 4). Consequences are also briefly covered. Students then answer questions using a test paper to check their learning.
samoliver368
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
GCSE Computer Science - Number systems resource pack

GCSE Computer Science - Number systems resource pack

Pack of all my resources for Computer Science number systems topics. Includes: Posters and wall displays for converting denary to binary and vice versa Posters and wall displays for converting hexadecimal to binary and vice versa Number line wall display including denary, binary, and hexadecimal numbers Number line wall display including denary and negative binary numbers (in sign and magnitude and two’s complement) Binary shifts worksheets (with answers) Binary revision worksheets (with answers) End of unit binary test (with answers) Binary crossword
csteacher2048
GCSE Computer Science posters pack

GCSE Computer Science posters pack

A collection of posters suitable for GCSE Computer Science and IB Computer Science. Includes: Matching binary, hexadecimal, and denary numbers Converting between binary, denary, and hexadecimal numbers 14 unique posters total, each with black background and white background versions.
csteacher2048
Computer Science denary to hexadecimal posters

Computer Science denary to hexadecimal posters

Collection of 8 hexadecimal themed classroom posters (plus variations). Perfect for GCSE Computer Science and IB Computer Science classroom displays. Collection includes: 2 posters for calculating the denary value of hexadecimal numbers 2 posters for calculating the hexadecimal value of denary numbers 2 posters for matching denary to hexadecimal 2 posters for matching binary to hexadecimal Posters are fully editable Word documents and each includes a version with a black background and a version with a white background (to save ink). A3 sized, but obviously can be printed smaller.
csteacher2048
Most Used Excel Functions

Most Used Excel Functions

Teach your students the most used Excel functions. All explained with details and includes an example each. The presentation can be adapted to your class activities. Functions that include in the presentation: SUM ( ) AVERAGE ( ) MAX ( ) - MIN ( ) COUNT ( ) COUNTA ( ) CONCENATE ( ) IF ( ) COUNTIF ( ) VLOOKUP ( ) SUMIF ( ) Assessment supports learning abilities and gives a chance to practice them in carefully designed examples with instructions for each. (All functions are used). The “Assessment_SOLVED” file gives the answers of each question. Please make sure you leave a review after your use. THANK YOU!!!
Copolat
What is an ALGORITHM

What is an ALGORITHM

An introduction to algorithms using a flowchart with sequence, selection and iteration. The worksheet provided enables students to slow down their thinking to focus on each instruction in the algorithm until the last instruction is executed and the program ends.
chris_vidal
Microsoft Word Shortcut Keys A-Z

Microsoft Word Shortcut Keys A-Z

This resource is a worksheet that contains a list of Word shortcut keys from Ctrl A to Ctrl Z. Learners fill out the worksheet to the best of their ability either individually or as a group exercise. An answer sheet is provided. They can then go and try out all the shortcuts for themselves.
Resource_Creator