Hero image

168Uploads

225k+Views

105k+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
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
EdExcel GCSE ICT Worksheets
clickschool

EdExcel GCSE ICT Worksheets

(17)
I created these some time ago when I worked in another school. Covers TB1: What can mobiles do, problems associated with mobile use, GPS, Kinds of Computer, Features of a computer, Socialising over the web , The Internet for Work, Internet Dangers, Digital Divide, TB2: Online shopping, trusting a web site (or not), privacy, online customer rights, setting up an account online, what makes a strong password, CAPTCHAs, paying online, online banking, fraud, personal data, creating a safe working environment, collaborative working, storing and backing up, working any time, anywhere.
Seating / Seat Plan Generator Excel or Online Web App
clickschool

Seating / Seat Plan Generator Excel or Online Web App

(35)
https://www.clickschool.co.uk/seatplan **LATEST**: Online seating plan generator - paste lists from SIMS or similar, group/distribute students, show/hide sensitive data, upload/download plans etc. NB No student data is transferred to the internet, it is all local within your web browser. Excel spreadsheet basic version
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.
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 Business Studies 9-1 The role of marketing, The purpose of market research
clickschool

OCR GCSE Business Studies 9-1 The role of marketing, The purpose of market research

(0)
2.1.1 The Role of Marketing: What marketing involves, what is a market, why the customer is king, adding value, how the marketing department works with other departments. Reflecting on your own purchase. (1 page) 2.1.2 The purpose of market research: Defining a market segment - looking at this in relation to car advertisements. The importance of asking the right questions. Introduces primary and secondary research in name only. (2 pages)
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.
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.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.