Study Hub
Year 11 Computing Study Guides
Every lesson below links to a pupil-friendly study guide with key notes, vocabulary, common mistakes, and quick questions with answers.
Cyber threats and security
- Careers in cyber security Study Guide
- Common ciphers Study Guide
- Defence against malware Study Guide
- Encryption tools to protect communication Study Guide
- Malware: malicious software Study Guide
- Social engineering techniques Study Guide
- Testing as a form of defence Study Guide
- The cost of cyber crime and hacker motivation Study Guide
- The impact of fake news Study Guide
Databases and SQL
- Big data Study Guide
- Data and privacy Study Guide
- Data management with SQL statements Study Guide
- Data protection, copyright and the law Study Guide
- Database design Study Guide
- Database fundamentals Study Guide
- SQL fundamentals Study Guide
- SQL searches Study Guide
- The environmental impact of data systems Study Guide
Digital media
- Creating a multi-page website Study Guide
- Creating digital graphics Study Guide
- Creating digital video Study Guide
- Digital artefact types and uses Study Guide
- Initiation and planning digital artefacts Study Guide
- Legal and ethical considerations in creating digital artefacts Study Guide
- Plan and create a digital artefact from a given brief Study Guide
- Project lifecycle Study Guide
HTML programming project
Network fundamentals
Programming: dictionaries and data files
- Careers in programming Study Guide
- Dictionary challenge Study Guide
- Programming project - dictionaries I Study Guide
- Programming project - dictionaries II Study Guide
- Reading CSV files Study Guide
- Reading text files Study Guide
- Records and dictionaries Study Guide
- Writing to CSV files Study Guide
- Writing to text files Study Guide
Python programming project
- Approaching a programming project Study Guide
- Developing code for a programming project Study Guide
- Evaluating the success of a programming project Study Guide
- Project design Study Guide
- Refining code for a programming project Study Guide
- Refining code in a programming project Study Guide
- Software design principles Study Guide
- Testing and refining a programming project Study Guide
- Testing principles Study Guide
- The project brief Study Guide
Spreadsheets
- Data validation in a spreadsheet model Study Guide
- Formatting in a spreadsheet model Study Guide
- Formulas in a spreadsheet model Study Guide
- Improving a spreadsheet model Study Guide
- Lookup and reference functions Study Guide
- Spreadsheet modelling Study Guide
- Spreadsheet project I Study Guide
- Spreadsheet project II Study Guide
- Visualising data using charts in a spreadsheet Study Guide
The internet and web technologies
Using IT in project management
- Carrying out a project part I Study Guide
- Carrying out a project part II Study Guide
- Evaluate your project Study Guide
- Evaluating the success of a project Study Guide
- Execute your own project Study Guide
- Interpreting project briefs Study Guide
- Introduction to project management Study Guide
- Setting project aims and objectives Study Guide
- Start your own project Study Guide
- Tools for project planning Study Guide
Using physical computing to create a robot buggy
- Adding additional features to your buggy Study Guide
- Chassis design and build Study Guide
- Creating an autonomous vehicle Study Guide
- Introduction to physical computing Study Guide
- Optical sensors for navigation Study Guide
- Presenting a physical computing project Study Guide
- Ultrasonic sensors to measure distance Study Guide
- Working with motors Study Guide