Hero image

Computer Science Resources (A-Level / GCSE)

A teacher and HOD of Computer Science at GCSE and A-Level. This shop brings together resources that have been used successfully over the delivery of the courses.

37Uploads

12k+Views

1k+Downloads

A teacher and HOD of Computer Science at GCSE and A-Level. This shop brings together resources that have been used successfully over the delivery of the courses.
Database Normalisation
dsmith00dsmith00

Database Normalisation

(0)
Some activities and information regarding Database Normalisation with a task sheet and a walk through of the answers. Includes a handout on normalisation and a few different activities.
NEA - Initial Project Proposal / Ideas
dsmith00dsmith00

NEA - Initial Project Proposal / Ideas

(0)
Letters given to all Computer Science students with a range of project ideas to help them decide on an idea of their own. Once an idea is chosen further work is completed using the project proposal in order to propose their final idea. Used for AQA Computer Science A-Level
AQA - Food Magnate (Short Mock 1 & 2) Computer Science
dsmith00dsmith00

AQA - Food Magnate (Short Mock 1 & 2) Computer Science

2 Resources
Two 60 minute mock exam papers covering Section C & D for AQA Computer Science - A-Level. Food Magnate. Paper 1 gives sample solutions in C# but generic marking points for all programming languages Paper 2 gives sample solutions in C# and VB.Net as well as marking points generic for all languages. Paper 1 & 2 can be used for two different mock exams to allow students to get used to the pre-release material for 2020
Compilers, Interpreters, Assemblers (Language Translators)
dsmith00dsmith00

Compilers, Interpreters, Assemblers (Language Translators)

(1)
This set of resources is designed for one lesson in which students will learn the differences between how Compilers and Interpreters work. This is designed as an interactive lesson to take the pressure off the tutor in delivering this topic. This topic is useful for both GCSE Computer Science and designed specifically for A-Level Computer Science with the AQA specification in mind.
Exam Key terms / definitions - A-Level Computer Science AQA/OCR
dsmith00dsmith00

Exam Key terms / definitions - A-Level Computer Science AQA/OCR

8 Resources
A variety of Knowledge Organisers for the topics of: Database Languages Generations Language Translators HArdware OOP Object Oriented Programming TCP/IP Network Internet Individually this would cost £16 - offer of half price All definitions and explanations are taken from mark schemes from A-Level AQA
Functional Programming (A-Level Computer Science)
dsmith00dsmith00

Functional Programming (A-Level Computer Science)

(0)
A set of commands to use with an online Haskell program https://ghc.io/ in order for students to develop their understanding of Haskell for A-Level Computer Science AQA specification. The resource has commands that will take students 30 minutes to play with and develop their understanding of by trying variations of these. Accompanies are some sample exam questions that have been made up based on the specification and also a different take on some of the specimen questions. Answers are included.
AQA - A-Level Computer Science (Text Adventure) (Short Mock Paper 1)
dsmith00dsmith00

AQA - A-Level Computer Science (Text Adventure) (Short Mock Paper 1)

(0)
The first in the series of mock exam papers designed around AQA A-Level Computer Science pre-release material Text Adventure. This mock exam paper is designed to be sat in a 45 minute period and give students an initial practice with the pre-release skeleton code for 2019 paper 1 series. There is a mark scheme that contains sample code in C# (hopefully this can be easily adapted to other programming languages).
A-Level Computer Science - Hardware vs Software
dsmith00dsmith00

A-Level Computer Science - Hardware vs Software

(0)
Two powerpoints, a lesson plan including follow up questions and links to flipped learning resources on the topics, two follow up activities related to the flipped learning. This covers the content for A-Level Computer Science on Hardware and Software - this is tailored to AQA specification and makes use of definitions from the exam board mark schemes. This topic is also useful for GCSE Computer Science.
AQA - A-Level Computer Science (Food Magnate) (Short Mock Paper 2)
dsmith00dsmith00

AQA - A-Level Computer Science (Food Magnate) (Short Mock Paper 2)

(0)
The** second** in a series of mock exam papers designed around the 2020 Prerelease material for AQA Computer Science - Food Magnate. A-Level. 60 minute Question Paper - Section C & D This is a 50 mark assessment EAD (Electronic Answer Document) Possible Mark Scheme which includes sample code for C# and VB.Net. The Mark scheme also gives a description of where mark points would be awarded for users of other languages. The Question Paper is still relevant for all languages, but sample solutions are only available in C# and VB.Net.
Machine Programming (AQA A-Level Computer Science) - RISC Instruction Set
dsmith00dsmith00

Machine Programming (AQA A-Level Computer Science) - RISC Instruction Set

(0)
Resources to support using RISC simulator online for the topic of Machine Architecture and Machine Programming for A-Level Computer Science AQA. This topic is useful to be taught practically. There is an initial grid with three programs that can be coded in the online simulator along with suggestions on how to edit the programs. A sheet explaining some of the RISC instruction set with examples and some programming challenges. A further sheet introducing more RISC instructions with further programming tasks. Two trace table sheets to use in conjunction with the online software.
AQA Computer Science - 4.6.2 Classification of Programming Languages
dsmith00dsmith00

AQA Computer Science - 4.6.2 Classification of Programming Languages

(0)
Knowledge Organiser for the topic on programming languages. What is a programming language? What is the difference between low and high level programming? What is the difference between Software types? What is the difference between a compiler and an interpreter? What is a Declaritive Language? Imperative Language?
Operation of Laser Printer, Barcode Scanner and Digital Camera
dsmith00dsmith00

Operation of Laser Printer, Barcode Scanner and Digital Camera

(0)
A series of resources to support the learning and understanding of the operation of a Laser Printer, Barcode Scanner and a Digital Camera. These three external hardware devices feature on AQA Computer Science AS and A-Level. Students need to be able to describe their operation. Powerpoints have been used as flipped learning, and pdf as follow up for students to demonstrate their understanding. Also included are the key mark scheme points from the exam board.
Linking Visual Basic . Net with a Database using SQL
dsmith00dsmith00

Linking Visual Basic . Net with a Database using SQL

(0)
Workbook that takes students through a Computing Project of building a VB solution for Mia's Sandwich Shop Problem. There are free resources on Mia's Sandwich Shop online that can be used prior to this workbook being used. Students will learn how to develop a fully functional program for ordering/retrieving sandwich orders. Database also included as Zip file.
Bitmapped Images
dsmith00dsmith00

Bitmapped Images

(0)
An introduction to bitmapped images with a paint by numbers (using Binary) activity. Also some publisher documents showing how images are made up using pixels. Some good starter points for Bitmapped / Pixels.
Computer Science - Software Topic
dsmith00dsmith00

Computer Science - Software Topic

6 Resources
Within this bundle is a lesson including ppt, lesson plan and activities on Hardware vs Software. The bundle also includes mind-maps to use as revision on Hardware, Software (and the categories associated), Generations of Languages. To accompany the language translator section of software is a set of resources for the differences between compilers and interpreters, with an accompanying mind-map summary. Overall a full set of resources to cover Differences between Hardware & Software, Categories of Software, Language Translators and how they work.