# Clickschool's Shop

Resources for KS3 and GCSE Computer Science and ICT

222k+Views

Resources for KS3 and GCSE Computer Science and ICT

#### KS3 CT Computational Thinking Series

KS3 CT Computational Thinking 14 key worksheets designed to be completed electronically to teach some of the trickier aspects of the KS3 National Curriculum, including: 1. Linear search 2. Binary search 3. Bubble sort 4. Simple logic gates 5. Logic gate circuits 6. Representing numbers 7. Binary to decimal 8. Decimal to binary 9. -TBC 10. Binary addition 11. Text representation 12. Picture representation 13. Sound representation 14. Instructions 15. Instruction sets 16. (brief introduction to algorithmic thinking) Lots of editable explanations, tasks and activities for varying abilities.

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

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

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

#### Bravery St George's Day Drama 23rd April Assembly / Camp fire skit for 11-13s, panto style, funny

This is a funny script taking around 10 minutes to perform. It is essentially about a knight plucking up the bravery to ask out the prince/princessss. There’s a couple of slightly different versions to choose from and play about with. It is designed to be performed by 4 main characters and some one line parts for others. Other roles include looking after props and sound/music and performing a rap. Other students may wish to devise a dance set to a song about bravery, thus using as many people as your group allows. Costumes can be sourced from places such as ebay or scrounged from friends/family! Ask around, you’ll be surprised what people have. All sound effects provided in this resource are, to the best of my knowledge, royalty free. You are welcome to use the ‘rap’ loop, which I made. I advise also sourcing: Tudor music, Hall of Fame (by The Script) and/or “Brave” by Sara Bareillies. Evidently not included because of copyright.

#### 1.7 OCR GCSE Computer Science System Software Exam Questions

16 GCSE Examination style questions for OCR GCSE Computer Science unit 1.7 Question sheet Answer sheet 24 marks available.

#### Database Validation Rules Information & Activities

Access Database validation checks

#### Database worksheet, defining and creating

who uses a database true/false quiz how the police use databases define database terminology design a simple table create a simple table

#### AQA GCSE Computer Science Revision Notes

8 pages literally crammed full of theory covering the syllabus in amazing detail - perfect preparation for the exam. It is written closely to the specification to assist optimal learning. Students will quickly reinforce their learning and have complete confidence. You will be pushed to find anything as concise. Save a fortune on photocopying and revision guides... it's all here. Please note that this document DOES NOT fully apply to the new syllabus for first teaching from September 2016.

#### EdExcel GCSE ICT Worksheets

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.

#### Information Reliability and Bias Worksheets

Information Reliability and Bias Worksheets Several to choose from... or use the lot.

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

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

#### GCSE 9-1 OCR Computer Science Component 1 study guide notes book

Study notes for component 1 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

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

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.

#### GCSE 9-1 OCR Computer Science Component 2 study guide notes book

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

#### Jingle Bells backing track 80bpm, 90bpm, 100bpm and PowerPoint notes and words

I first did this in 1997 (when I used to have a life!!), but it's still good fun to do today! Target age - Year 6 or 7, but I've also done this with older students too. Give students chime bars, jingle bells and a triangle to play along with the notes in the presentation...the test can sing along! Good fun. The backing track is just that - piano chords and bass. The tune is played and/or sang by students. I've also included a bonus track with ideas for how chime bars could be used with other traditional Christmas songs... Just one verse and chorus, but you can use 3 different playback speeds as they get better and better. The backing track is piano and bass only.

#### AQA Computer Science Practice Exam Questions (Full version)

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: &gt; 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

#### Image Representation Worksheet

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

#### GCSE 9-1 OCR Business Studies Topic Test 1.5 Stakeholders in business

Editable 23 mark paper (and answers) to test student knowledge of stakeholders. Questions are based around High Speed 2, British Telecom and ASOS.

#### CAMBRIDGE NATIONALS R001: UNDERSTANDING COMPUTER SYSTEMS STUDY GUIDE

Cambridge Nationals in ICT R001 (J800, J810, J820): One site licence to create photocopies of a complete set of worksheets covering all assessment objectives: AO1: Understand how ICT can be used to meet business needs AO2: Working with information &amp; data to meet specific business needs AO3: How ICT is used to support business working practices AO4: How legal, ethical, safety and security issues affect how computers should be used This concise publication has been created to encourage learners to interact with the contact based on various questions, matching and dragging é dropping activities. It also includes links to engaging videos Many pages are relevant to other courses of study, and can therefore be reused in the future. This publication includes an extremely helpful section about exam technique and some 'top tips' to help students pick up valuable marks.

#### KS3 CT Computational Thinking Series An Introduction to logic and logic gates in circuits

An introduction to logic gates KS3 PoS: Understand simple Boolean logic [for example, AND, OR and NOT] and some of its uses in circuits Know Electronic circuits are made up of logic gates Logic gates in modern circuits are made from transistors The names and symbols used to represent three basic logic gates (AND, OR, NOT) An example of a use for logic gates Understand Different combinations of inputs can alter the single output of a logic gate circuit Be Able To Given a scenario involving AND, OR and NOT, Apply understanding of logic gates to produce a logic gate circuit Apply understanding of logic gates to produce a truth table

#### CPU: Fetch, Decode, Execute (GCSE LEVEL)

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