This is a step by step guide on how to create a dashboard using MS Excel. Suitable for pupils studying the BTEC Tech Award in Digital Information Technologies, Component 2 Learning Aim B

Lesson review plan for MS publisher unit

scheme of learning for powerpoints unit

spreadsheet unit sol

This resource teaches the different project planning tools pupils will be required to use in their official btec assignment. Tasks are included.

Topics covered: -networking hardware -internet -world wide web -secure networks -bandwidth -drawing simple networks

For basic introduction of databases, students should be able to recognise key terms , data types, how to use a query, and advantages of databases over physical storage

An end of year exam designed for pupils in year 8 covering the following topics: Networks Cyber security Cryptography Web design/ HTML

End of year assessment designed for pupils in year 7 covering the following topics: E-safety Cyber security (Phishing/malware) Computer hardware Spreadsheet

covers different types of cryptography, students are expected to be able to decode using different techniques, students should know all key terms

End of term assessment and mark scheme

A compilation of a few exam questions on each diagram with answers - data flow diagram information flow diagram flow chart

A complete presentation on the different cryptography techniques. Includes retrieval and exit tickets. Aimed at KS3

This document gives a brief description for each topic covered in ICT showing how the topic links with the next.

topics covered: -VLOOKUP -SUMIF -AVERGAE -COUNT -COUNTA -COUNTIF -GOALSEEK -CELL REFERENCES

This ppt shows pupils how to create gantt charts from scratch with visual examples for each step

This presentation is designed to support pupils studying the BTEC DIT L1/L2 component 1 Gives 2 assignment questions with a clear guide on how to progress from a grade U - Distinction Also includes ‘do now tasks’ Can be used for DIRT time

This presentation includes 2 complete lessons on how computers work. lesson 1 - what is a computer lesson 2 - inputs and outputs Contains activities which can be printed or displayed on board

KS3-4 ICT long term plan for y7-y10 (y11 will be exam prep and completing assignments)

This powerpoint consists of 5 lessons Lesson 1 - intro/uses Lesson 2 - keyterms Lesson 3 - types of databases Lesson 4 - data types Lesson 5 - setting up a database including starters, exit tickets and tasks