Secondary computing resources

IGCSE Computer science unit of work for computer Architecture, Languages and Operating systems

Worksheet for IGCSE computer science Logic Gates unit, covers all spec points in unit.

Worksheet for IGCSE computer science input devices unit, covers all spec points in unit.

Worksheet for IGCSE computer science sensors unit, covers all spec points in unit.

Worksheet for IGCSE computer science memory, storage and media unit, covers all spec points in unit.

Worksheet for IGCSE computer science output devices unit, covers all spec points in unit.

Worksheet for IGCSE Computer Science that covers the full units content.

Full set of worksheets for iGCSE computer science security unit.

Full set of worksheets for iGCSE computer science units included programming concepts, pseudo code and flowcharts and algorithm design and problem solving. Intended to be taught as linked units for a more comprehensive learning style.

Kodu is a friendly graphical programming language where students can build their own world and program objects within. This series of lesson uses kodu to introduce computer science terminology such as algorithm and variables to develop computational thinking skills.

Complete notes for paper 1 and 2

Hardware revision sheet.

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.

This is the second part of a two part resource aimed at helping teachers present how to complete the project unit R013 for the new OCR nationals in ICT. It is a work in progress and other units will be placed on TES when available. I have uploaded this work prior to completion of all the units because I cannot find many free resources in this area of study and wanted to help other teachers if I could.

This is part 1 of a two part resource aimed at helping teachers present the Project Life Cycle. It is a work in progress and is designed to help with the creation of the project R013 element of the course but could also be used to cover many elements of unit R012 (Theory Exam). Please also upload part 2

Last week I found a small UK tech company which was giving out great computer prizes and no-one was entering them. I decided to use them to create a drawing competition in my class - after all what is more motivational to a class than a great chance of winning! I used it to share ideas about what makes a great invention. We discussed ideas of what would or would not win - then created our work of art. INVENT THE 2098 WORLD CUP Future Inventors, we have a new challenge for this week. The World Cup is about to start and it got us thinking: what will the 2098 World Cup look like? Flying referees? Virtual stadiums? Techno-vuvuzelas? Submit your ideas and the winner gets a FREE kit and see it become a project on Club Make! We accept ALL ideas: practical, fun to absolutely bonkers. Entering the challenge is super easy: just draw your idea and share it below! They accept submissions until the 24th of June at http://bit.ly/WinARobot.

A worksheet that allows pupils to convert between binary and denary / denary binary.

Understanding variables and loops are the most significant aspects of coding. It is important for students in early stages to grasp the concept of how loops work if the are to be successful candidates for computer science. This power point presentation is a scaffold building fundamental steps required in understanding and applying loops using python. Students must already know how to use basic input and output functions in python. The language and terminology used is simple enough for a non specialist to use and teach a coder at beginner level. The python idle software is available to download for free at https://www.python.org/downloads/. After students have fully grasp the concept of loops and how they work, they extension task will provide a challenge for them to apply their knowledge, using computational thinking to improve their code.

Computer Science GCSE CIE 0478 Unit: 3 Topic: Logic Gates A task to match up the name, symbol, description and truth table for each logic gate. The task produces a single A4 sheet/table which is great for a reference/revision of the topic. Students complete a table with four headings; name, symbol, description and truth table. All the details are provided and can be copied and pasted into the table. Final results can be printed and used for revision or as a quick reference guide during the topic. A homework has been included to reinforce the learning. Please leave some feedback.

A worksheet activity adding binary numbers and conversions to denary. Starts with 4 bits (nibble) and moves on to 8 bits (byte) additions. There is also an accompanying answer sheet. The activity also has some general questions about binary for students to answer, which could be part of an extension or small research activity.

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

Teach the basics of Microsoft Excel to beginners. Students will learn the difference between workbooks and worksheets, cell referencing, simple calculations, auto complete, formatting and functions (SUM, AVERAGE, MAX and MIN). There is a starter activity and 3 tasks to complete in a student spreadsheet which can be distributed. There are teacher notes in the comments for each slide, along with key points for demonstration and challenges for students if they complete the work. As always, if you enjoyed the resource please leave a review so that others can find it. HackDragn

This is possibly my most favourite piece of work to do with the students. I do it as an end of year activity when they are a bit more confident with the material. We create a zombie survival text adventure game and I have recently updated it to include questions similar to what has been in the recent exam and in the exemplar exam What is covered Local and Global Variables Variable Types Input and Validation Conditional Loops Fixed Loops Arrays Subprogram calls (Functions, Procedures and Pre-defined) Libraries Complex conditions and selection Repetition and Iteration What is included Word document with instructions, task overview and more detail on the activity Student Starting Python file (in zip folder) Teacher completed exemplar file Answer document to questions

This lesson combines science and computer science as students explore the water cycle through an expedition in the hydrosphere and use the programming language Scratch to create their own model. Objectives: Students will discuss how all water moves through a never ending cycle identifying key points in all stages. Students will apply their understanding by creating a model of the water cycle in Scratch. Standards: ESS2C: The Role of Water in Earth’s Surface Processes 5-ESS2-1 MS-ESS2-4 CSTA 1B-AP-10: Create programs that include sequences, events, loops, and conditionals. CSTA 1B-AP-17: Describe choices made during program development using code comments, presentations, and demonstrations. Additional videos / resources: Crash Course Kids: The Great Aqua Adventure https://www.youtube.com/watch?v=z5G4NCwWUxY Google Expedition Research Journal https://drive.google.com/file/d/1cd-NZMmx4dwzMsWNOuBg8Y375_iDJm6G/view?usp=sharing Create your own Google Logo Activity https://csfirst.withgoogle.com/c/cs-first/en/create-your-own-google-logo/overview.html Scratch Project Rubric https://docs.google.com/document/d/1jxxNbEITs4SDxNjsl0fXoq-XRX3t2HpY6aRfL_iKDyk/edit?usp=sharing Optional/Additional Lesson Plans/Resources Hydrologic (Water) Cycle Multimedia Text Set https://docs.google.com/presentation/d/e/2PACX-1vROakYmPuB2lMPONXbnF2kh28gPHC9EWM2ojZp7tvu9pFHUqgOjUFlb-URpx9w5zZnfCFf6qK28Wqht/pub?start=false&loop=false&delayms=3000 NASA Precipitation Education: Exploring the Water Cycle https://pmm.nasa.gov/education/lesson-plans/exploring-water-cycle

Exam preparation questions on coding for Paper 2 Content Question sheet Zipped folder of Python code

Four different activities for researching different areas of Computing. 4 research essays bundled.

Directed research activity to compare different brands of smart phones in an ‘Extended Essay’ type format

Activity sheet for researching and presenting on the History and development of Games Consoles

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

This is my handout for a research and extended essay type activity that I do with my Y8 students. Levelling criteria is included

Activity to practice encoding and decoding messages with the Vigenere Cipher

Simple activity to practice encrypting and decrypting messages with the Caesar Cipher

Activity for encrypting and decrypting messages with the Rail Fence Cipher

Activity Sheet with directed research questions for searching and recording information about how sound is stored in a Computer System

These are a bit dated looking, but still relevant. Have attached word files so they can be edited. Covers Binary Signed Bit Twos Complement Memory Size Conversion Graphics Calculations Floating Point Representation Binary Addition and Subtraction Binary Multiplication Hexadecimal

Covers Fetch Execute Cycle Read Instruction Write Instruction Parts of the Processor Buses Clock Interrupt and non-maskable interrupt Addressable memory and associated calculations Registers, Cache and Main Memory Different types of RAM Measures of performance

This is another of the mini projects that I get my students to complete in preparation for completing the coursework. Lesson Overview Depending on ability level, we start by completing flow charts and pseudocode to complete the design of the program. I sometimes prepare a complete one, but blank out some of the steps to give to my weaker students. Better students I will give blank designs to and somewhere in between for the other students. At end of this lesson, we look at how the code works In preparation for the next lesson, I get the students to watch the video as a homework task. The next lesson, the students complete the program using their pseudocode / flow charts completed in previous lesson. If they are still struggling, they can watch the video again in class time, as well as me able to wander around and help. Students who are better at coding will easily be able to add more functionality to this project Included Zipped file contains: 2 CSV files required for the project and the completed solution file (1 of the CSV files is the file writing part) Video Support of completing the solution Whilst this is mainly aimed at students, it would be useful PD for any Computer Science teachers who are still struggling to understand the complex programming side of the course What this teaches File Reading from CSV file File writing back to CSV file Storing Data in 2D arrays Functions/Procedures Parameter Passing Complex Functions (Finding Minimum algorithm using 2D arrays) Combining

This is a smaller project that uses File Reading, 2D arrays and some manipulation of the data stored in it. A complex project, smaller than a final year project, but building in complexity. Included: 3 solution videos, completed solution file (.py) and zipped (TES doesn’t allow this file type) with the CSV file to access - save these in the same folder, or your program will not work

NthLib is a set of Mac and iOS tools that are designed to enable non-professionals to build, configure, and deploy iOS apps for iPad and iPhone. Once the apps are built, they are easily configured, reconfigured and multiconfigured for various user groups. The key feature that sets NthLib apart from the sea of app builders available is multiconfigurability. A single app can be configured and reconfigured for any group or sub-group of users. A single user can install any number of app configurations and can switch between them with a single tap. This is finished turnkey software that I have used for several years to build and distribute my own iOS apps. I’ve recently made the tools available for 3rd-party use. The library is described in detail in the docs linked below. Briefly, K-12 use cases are endless. NthLib configurations provides a virtual venue for displaying work done by students that is suitable for public distribution and viewing. Student created content could range from artwork, photography, and videos, to short stories, poetry, and history papers - there are virtually no limits. See the link below that lists system requirements. The target audience can be other students, faculty, and parents. For schools that are already working with iOS devices, entry into NthLib provides easy access to app development and deployment. NthLib was originally modeled as a subscription service for small and mid-size enterprise. For now, I am offering the service to educators for use free of charge. And for subscribers who take me up on this offer, I will extend the free part indefinitely. In other words, if you start out free, you can continue free as long as you find NthLib of use. In exchange, feedback would help me. Beyond feedback, if your students cook up app configurations they are proud of and that are appropriate for demo distribution, I am always looking for high quality content to distribute as examples of NthLib’s capabilities.

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.

I have created small tasks/projects for Year 9 going into year 10 (or can be used to prepare students who have not been taught Com Sci in Key stage 3) and year 10 going into year 11. There is also one for KS3 students. This is for students to complete over the summer holidays.

This is the test my students complete after they have finished my Algorithms and Problem Solving unit.