51ºÚÁÏ

Included in this teaching pack is the full set of resources that have been used to complete the BTEC first unit 3- Digital Portfolio It includes all the relevant PowerPoints to guide students towards completion of the unit. The resources cover the full specification of the unit and will enable the students to gain the Pass, Merit or Distinction levels. Enjoy!

This python workbook starts with the very basics and guides the students in developing their skills. It hasd multiple tasks throughout the booklet and covers topics such as: Print Data Types Operands Variables Loops Indexing

A introduction to inputs and outputs for KS3, this was part of the Hardware and Software unit that was delivered. Lesson includes an introduction to the topic and tasks to complete. Extensions tasks also included. The full SOW can also be bought in the shop

NEW J277 SPECIFICATION: Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.1 – Algorithms Principles of computational thinking: o Abstraction o Decomposition o Algorithmic thinking Identify the inputs, processes, and outputs for a problem ¨ Structure diagrams ¨ Create, interpret, correct, complete, and refine algorithms using: o Pseudocode o Flowcharts o Reference language/high-level programming language ¨ Identify common errors ¨ Trace tables Standard searching algorithms: o Binary search o Linear search ¨ Standard sorting algorithms: o Bubble sort o Merge sort o Insertion sort The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Enjoy!

A straight forward lesson which explains the ways in which you perform binary addition, the lesson outlines the rules for binary addition and also has example questions. Answers are included on the final slide.

An easy to follow worksheet designed to revisit the CPU and its features as part of 1.1 Systems Architecture in the Computer Systems component. The worksheet s designed for students to read over their notes, and attempt the questions, Answer sheet is included.

A introduction to 3d printing and Google SketchUp, which was used as part of our 3d printing topic with keystage 3. It requires the students to look into the ways in which 3d printing works as well as introducing them to Google Sketchup Also included is a worksheet to remind students of the tools in SketchUp ***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***

part of the BTEC Level 3 Diploma in Information Technology which i delivered to level 3 students, pack contains all resources that i used including assignments

An introduction to logic gates which i used at KS3 and KS4. Easy to understand and straight forward. Included are: Teachers powerpoint (walks the students through the gates with examples) Progress log (Track students progress) Self marking spreadsheet that includes tasks, extension and a helpsheet

Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.2 Programming techniques 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 and string casting the common arithmetic operators the common Boolean operators. The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Check out my shop to save on buying multiple sheets!! Enjoy!

NEW J277 SPECIFICATION: Here you will find easy to follow revision sheets which will help your students to recap the topic: 1.1 Systems Architecture which includes: The purpose of the CPU: o The fetch-execute cycle ¨ Common CPU components and their function: o ALU (Arithmetic Logic Unit) o CU (Control Unit) o Cache o Registers ¨ Von Neumann architecture: o MAR (Memory Address Register) o MDR (Memory Data Register) o Program Counter o Accumulator How common characteristics of CPUs affect their performance: o Clock speed o Cache size o Number of cores ¨ The purpose and characteristics of embedded systems ¨ Examples of embedded systems The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Enjoy!

NEW J277 SPECIFICATION Here you will find easy to follow revision sheets which will help your students to recap the topic: 1.2 Storage and Memory which includes: The need for primary storage The difference between RAM and ROM The purpose of ROM in a computer system The purpose of RAM in a computer system Virtual memory ¨ The need for secondary storage ¨ Common types of storage: o Optical o Magnetic o Solid state ¨ Suitable storage devices and storage media for a given application ¨ The advantages and disadvantages of different storage devices and storage media relating to these characteristics: o Capacity o Speed o Portability o Durability o Reliability o Cost ¨ The units of data storage: o Bit o Nibble (4 bits) o Byte (8 bits) o Kilobyte (1,000 bytes or 1 KB) o Megabyte (1,000 KB) o Gigabyte (1,000 MB) o Terabyte (1,000 GB) o Petabyte (1,000 TB) ¨ How data needs to be converted into a binary format to be processed by a computer ¨ Data capacity and calculation of data capacity requirements Numbers ¨ How to convert positive denary whole numbers to binary numbers (up to and including 8 bits) and vice versa ¨ How to add two binary integers together (up to and including 8 bits) and explain overflow errors which may occur ¨ How to convert positive denary whole numbers into 2-digit hexadecimal numbers and vice versa ¨ How to convert binary integers to their hexadecimal equivalents and vice versa ¨ Binary shifts Characters ¨ The use of binary codes to represent characters ¨ The term ‘character set’ ¨ The relationship between the number of bits per character in a character set, and the number of characters which can be represented, e.g.: o ASCII o Unicode Images ¨ How an image is represented as a series of pixels, represented in binary ¨ Metadata ¨ The effect of colour depth and resolution on: o The quality of the image o The size of an image file Sound ¨ How sound can be sampled and stored in digital form ¨ The effect of sample rate, duration and bit depth on: o The playback quality o The size of a sound file ¨ The need for compression ¨ Types of compression: o Lossy o Lossless The revision sheets include over 50 exam questions at the end of each topic to help the students recap their revision and apply it to a question. Enjoy!

NEW J277 SPECIFICATION: Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.2 – Programming fundamentals ¨ 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: o Sequence o Selection o Iteration (count- and condition-controlled loops) ¨ The common arithmetic operators ¨ The common Boolean operators AND, OR and NOT The use of data types: o Integer o Real o Boolean o Character and string o Casting The use of basic string manipulation ¨ The use of basic file handling operations: o Open o Read o Write o 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-dimensional (1D) and two-dimensional arrays (2D) ¨ How to use sub programs (functions and procedures) to produce structured code ¨ Random number generation The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Enjoy!

A simple resource to teach the students about sequencing and flow charts at KS3, it includes all the terminology needed as well as the correct way to develop a flow chart using the correct symbols. Also included is a task related to the use of a "Big Trak" which was used to programme a sequence of instructions. I used this for 2 lessons to get the students used to the ideas of flow charts and sequencing prior to programming. **If Big Traks are unavailable you can also switch this task to something like Flowol as the resource will have already given insight into flow charts

A checklist i gave to my students to help them cover the key aspects of the specificiation. They tick each box as they go along and feel confident in that area. A good tool to locate weaknesses and improve!

DB Browser is a handy tool you can use for SQLite, it is freeware which is available at: http://sqlitebrowser.org This little guide take you through how to make use of DB Browser for SQLite!