Hero image

168Uploads

220k+Views

103k+Downloads

Resources for KS3 and GCSE Computer Science and ICT
Computer Systems, Input, Output and Storage Devices
clickschool

Computer Systems, Input, Output and Storage Devices

(2)
9 high quality worksheets packed with including activities about: - Types of computer systems (desktop, laptop, netbook, tablet, smartphone) - Matching a computer system to different people (e.g. plumber, teacher etc) - Matching up Input, Output, Storage and Connectivity descriptions - Writing examples of input, output, storage and connectivity devices - Actuators - Types of printers (dye sublimation, inkjet, laser, dot matrix) - Storage types (optical, magnetic, solid state, cloud) - including comparisons and definitions - Exam style questions Links to web videos Suitable for KS3 and KS4 This is an extract from my Cambridge Nationals workbook. Designed to aid efficient learning and save photocopying by making efficient use of page space.
AQA Computer Science Practice Exam Questions (Full version)
clickschool

AQA Computer Science Practice Exam Questions (Full version)

(1)
Thoroughly prepare your students for the Summer 2016 AQA GCSE Computer Science Exam. This download includes over 180 carefully thought out exam style questions (matches to the specification), along with separate answers. The perfect resource to use with your students to give them the confidence they need to secure success. Great for revision, assessment and teaching...and for getting top examination results! Covering the curriculum as follows: 3.1.1 Constants, variables and data types 3.1.2 Structure 3.1.3 Program flow control 3.1.4 Procedures and functions 3.1.5 Scope of variables, constants, functions and procedures 3.1.6 Error handling 3.1.7 Handling external data 3.1.8 Computer structure: > 3.1.8.1 Systems 3.1.8.2 Hardware 3.1.8.3 CPU (Central Processing Unit) 3.1.8.4 Memory 3.1.8.5 Secondary storage 3.1.9 Algorithms 3.1.10 Data representation 3.1.11 Software development life cycle 3.1.11.1 Prototyping 3.1.12 Application testing 3.1.13 Networking 3.1.13.1 Client server 3.1.13.2 Web application concepts 3.1.14 Use of external code sources 3.1.15 Database concepts 3.1.15.1 Query methods (SQL) 3.1.16 The use of computer technology in society
How to mark and get high marks for OCR A-Level H446 coursework - NEA Mark Scheme Decomposed!
clickschool

How to mark and get high marks for OCR A-Level H446 coursework - NEA Mark Scheme Decomposed!

(0)
I've taken the H446 mark scheme to pieces, and then put it back together in a much more manageable way, taking account of extensive experience of marking projects. With this document, you will be able to: - Quickly and accurately mark and assess A-Level projects - Guide your students to getting maximum marks, and focus on what it is that gets marks. What more could you want?! This document includes a clear mark scheme and a guide about what to include for each part of the project. NB: This is for GUIDANCE ONLY and high marks are not guaranteed! This resource is NOT endorsed by OCR.
Python3 code bank for KS4, core reference for NEA
clickschool

Python3 code bank for KS4, core reference for NEA

(0)
This 5* rated resource does NOT contain complete solutions for OCR NEA 2018 - 2020. But what it does contain are clearly presented code snippets, designed to help reinforce application of programming knowledge, helping students to understand code and create their own solutions without giving up hope, in a relatively short space of time. I’ve been programming, and teaching for a long time, and understand that some students can struggle to code. This one-stop shop aims to give students the confidence to work out their own solutions from this one easily-accessible reference guide. This resource shows how to complete tasks such as file handling; in the most straightforward way possible. File handling needn’t be complicated. I’ve seen some trying to use SQL, CSV or JSON formatted data. This often leads to needless confusion amongst those just starting their programming journey. None of this is necessary. This resource shows you how to use simple code to manage files…and much much more. This resource helps students to have those ‘eureka’ moments as they piece together ideas and get to grips with programming (it can also help staff!) It is clearly presented and contains enough ideas to help students to feel good about being able to code their own solution. …Python3 code bank for KS4 Quick reference guide with adaptable code snippets… Covers… File handling Iterating over dictionaries Iterating through numbers Input Print (and formatting technique) Generic game loop Generic login Random shuffling Random number generation Removing items from a list Adding items to a list Modulus arithmetic operator Thinking about using primitives or lists Dictionaries Len function String methods: lower(), title() Sorting a list of dictionaries Casting integers to strings Generic menu code: showing use of functions
GCSE 9-1 OCR Computer Science complete set of study notes book
clickschool

GCSE 9-1 OCR Computer Science complete set of study notes book

18 Resources
Study resources for OCR Computer Science - the complete set! Over 150 pages, tailored to this GCSE course: 1.1 System Architecture 1.2 Memory 1.3 Storage 1.4 Wired and wireless networks 1.5 Network topologies, protocols and layers 1.6 System Security 1.7 Systems software 1.8 Ethical, legal, cultural and environmental concerns 2.1 Algorithms 2.2 Programming technique 2.3 Producing robust programs 2.4 Computational Logic 2.5 Translators and facilities of languages 2.6 Data representation +Handy revision section
Computer Law, phishing, health & Safety, Data Protection Act, Copyright, Computer misuse, Ethics
clickschool

Computer Law, phishing, health & Safety, Data Protection Act, Copyright, Computer misuse, Ethics

(0)
Worksheets: Phishing Health & Safety Act (Cloze) Data Protection Act (information) Copyright (matching activity) Computer Misuse (information) Business Ethics (comprehension) Cyberbulling (information) Workplace surveillance (methods, e.g. GPS, web monitoring, CCTV, RFID) (Comprehension, discussion) Cookies & Disabling Cookies (matching activity) Key logging Mobile phone triangulation Loyalty Schemes Cyber Wars (matching threats to description) Disciplinary procedures Countermeasures (- to cyber threats - matching activity) This is an extract from my Cambridge Nationals workbook
Image Representation Worksheet
clickschool

Image Representation Worksheet

(2)
What better way to learn about how bitmap graphics are created than to create a bitmap image! This editable Word document and can either be completed electronically, or printed and completed without need for a computer. (i.e. for homework). Outcomes:  Drawing of an image and written binary representation  Calculation of total pixels in an image  Decoding of RGB values Vocabulary: c Bit c Bitmap c Binary c Colour-depth c Pixel c Pixelated c Pixel density c Resolution c RGB
Stop Motion Animation: Lesson PowerPoint, Plan and Basic Guide to Monkey Jam
clickschool

Stop Motion Animation: Lesson PowerPoint, Plan and Basic Guide to Monkey Jam

(1)
PowerPoint which could be used to develop lessons in stop motion animation - covers four phases: research, preparation, production, publication. Gets students thinking about what makes a good stop motion animation. Includes links to interesting videos featuring those that work in the industry.Monkey Jam is free stop motion animation software. Included is a one-page guide to using the program. Web cam required!A lesson plan for a half-day session for adaptation.Storyboard
Blogging and Posting: A Short Introduction
clickschool

Blogging and Posting: A Short Introduction

(6)
Inspire yourself or your students: gets you thinking about the impact of blogs - from making money, to freedom of speech etc. Content: Blogging terminology BASICS: Understand what a blog is Name different forms of blogs Explain the purpose of blogs Identify features of a blog Name blogging "platforms" Abide by e-safety rules when creating a blog INTERMEDIATE: Explain why people use blogs and how an organisation can benefit from blogging Explain the purpose of blogs Explain what makes a good blog, taking account social and legal implications Explore money-making opportunities for bloggers Understand how blogs are used for business and pleasure EXPERT: Explain what a spam bot does, and measures for combating them Critically evaluate the effectiveness of a good and not so good blog - suggesting and justifying possible improvements Use blogging as a tool to benefit YOU (reflective learner, share & develop ideas) Manage your very own blog responsibly 19 pages.
OCR GCSE 9-1 Computer Science 1.8 Ethical, legal, cultural and environmental concerns
clickschool

OCR GCSE 9-1 Computer Science 1.8 Ethical, legal, cultural and environmental concerns

(0)
Get better value by buying this as part of my GCSE OCR Computer Science bundle.  How to investigate and discuss Computer Science technologies while considering: ethical issues, legal issues, cultural issues, environmental issues, privacy issues.  How key stakeholders are affected by technologies  Environmental impact of Computer Science  Cultural implications of Computer Science  Open source vs proprietary software  Legislation relevant to Computer Science: The Data Protection Act 1998 Computer Misuse Act 1990 Copyright Designs and Patents Act 1988 Creative Commons Licensing Freedom of Information Act 2000.
CPU: Fetch, Decode, Execute (GCSE LEVEL)
clickschool

CPU: Fetch, Decode, Execute (GCSE LEVEL)

(1)
A resource aimed at OCR Computer Science Students. A presentation to explain very clearly how the CPU goes about adding up two different numbers. It shows every step of execution, clearly explaining the purpose of each of the registers that students need to know about. 27 slides in total. NB: It demonstrates the concept and is suitable for up to GCSE Level (9-1).
OCR GCSE 9-1 Computer Science 2.2 Programming technique (Python, Pseudocode and Flowcharts)
clickschool

OCR GCSE 9-1 Computer Science 2.2 Programming technique (Python, Pseudocode and Flowcharts)

(2)
Get better value by buying this as part of my GCSE OCR Computer Science bundle. Suitable for teaching Python from the ground up - either for OCR GCSE as intended, or for any course of study requiring a good foundation in Python, Pseudocode and Flowcharts.  The use of variables, constants, operators, inputs, outputs and assignments  The use of the three basic programming constructs used to control the flow of a program: sequence, selection, iteration (count and condition controlled loops)  The use of basic string manipulation  The use of basic file handling operations: open, read, write, close  The use of records to store data  The use of SQL to search for data  The use of arrays (or equivalent) when solving problems, including both one and two dimensional arrays  How to use sub programs (functions and procedures) to produce structured code  The use of data types: integer, real, Boolean, character, string. Casting.  The common arithmetic operators  The common Boolean operators.
OCR GCSE 9-1 Computer Science  2.3 Producing robust programs
clickschool

OCR GCSE 9-1 Computer Science 2.3 Producing robust programs

(1)
Get better value by buying this as part of my GCSE OCR Computer Science bundle.  Defensive design considerations: input sanitisation/validation, planning for contingencies, anticipating misuse, authentication, maintainability, comments, indentation  The purpose of testing  Types of testing: iterative, final/terminal  How to identify syntax and logic errors  Selecting and using suitable test data.
KS3 CT Computational Thinking Series: Searching and Sorting
clickschool

KS3 CT Computational Thinking Series: Searching and Sorting

(0)
Electronic worksheets designed for use by students. Tasks for varying abilities including programming algorithms in Python for the most able. The worksheets detail how the algorithms work (linear search, binary search, bubble sort) and how to code them using Python, followed by questions. Includes links to interactive self-marking quiz. These files are available as part of a bundle, covering computational thinking skills for KS3.
Operating Systems and Applications
clickschool

Operating Systems and Applications

(0)
Worksheets (5 pages) about: - Types of operating systems - Utility software - Customisation - Software updates - Application software This is an extract from my Cambridge Nationals workbook
OCR GCSE 9-1 Computer Science 1.6 System Security
clickschool

OCR GCSE 9-1 Computer Science 1.6 System Security

(0)
Get better value by buying this as part of my GCSE OCR Computer Science bundle.  Forms of attack  Threats posed to networks: malware, phishing, people/social engineering, brute-force attacks, denial of service attacks, data interception and theft, the concept of SQL injection, poor network policy  Identifying and preventing vulnerabilities: penetration testing, network forensics, network policies, anti-malware software, firewalls, user access levels, passwords, encryption.