Module 1 - E-Safety and a Global society
End Points for Module – Knowledge
- What are the expectations and routines in Computing?
- What can we do to stay safe online?
- What is a digital footprint?
- What is cyber bullying?
- What are the issues with online gaming?
- Who to contact if there are any concerns about online activity?
End Points for Module – Skills
- Students will be able to use google classroom and the G Suite (slides, docs, sheets) and Adobe Spark effectively.
- Students will be able to research efficiently and be able to gather different sources to provides evidence for a certain point.
- Students will be able to recognise different online threats and know what to do if faced with these threats.
- Students will build up resilience to online threats.
Module 2 - Computational thinking
End Points for Module – Knowledge
- What is an Algorithm?
- What is Pattern Recognition?
- What is Abstraction?
- What is Decomposition?
- What is a flowchart?
- What are the different functions that can be used in a flow chart?
End Points for Module – Skills
- Students will be able to describe what computational thinking is and how it is used to solve problems.
- Students will be able to break down problems logically and efficiently and produce useful solutions.
- Students will be able to write detailed algorithms.
- Students will be able to apply flowcharts to help gather thoughts and apply solutions to problems.
- Students will be able to identify and use different functions in flowcharts.
Module 3 - Block-based coding
End Points for Module – Knowledge
- What is iteration?
- What is selection?
- What are variables?
- What are sub-routines?
- What are operators?
End Points for Module – Skills
- Students will be able to describe what Iteration is and how to use it in block based coding.
- Students will be able to describe what Selection is and how to use it in block based coding.
- Students will be able to describe what Variables are and how to use it in block based coding.
- Students will be able to describe what sub-routines are and how to use it in block based coding.
- Students will be able to describe what Operators are and how to use it in block based coding.
Module 4 - Data Representation
End Points for Module – Knowledge
- What does data representation mean?
- What is Binary?
- What is Denary?
- How do we add binary numbers together?
- What is ASCII?
- What is a bitmap image?
End Points for Module – Skills
- To be able to describe the difference between Binary and Denary.
- To have an understanding of how our base-10 number system is different to base-2 number system.
- To be able to understand how computer systems use binary to translate complex information into a format it can understand.
- To be able to convert denary to binary and binary to denary.
- To understand how binary numbers are able to represent alpha-numerical data that humans can understand.
- To be able to understand how binary is used to represent images.
Module 5 - Systems Architecture
End Points for Module – Knowledge
- What is hardware?
- What is software?
- What are the peripherals of the computer?
- What is an input?
- What is an output?
- What is a CPU?
- What is RAM?
- What is ROM?
End Points for Module – Skills
- To be able to describe what Computer hardware is.
- To be able to give detailed description of what the peripherals of a computer are and identify the difference between input and output peripherals.
- To be able to identify the functions of the CPU.
- To be able to understand the difference between RAM and ROM storage and the features of both types of data storage.
Module 6 - Spreadsheets
End Points for Module – Knowledge
- What is modelling?
- What is a spreadsheet?
- How do you analyse data?
- What is formatting?
- What is the difference between data and information?
- What is the difference between primary and secondary sources of data?
End Points for Module – Skills
- To be able to identify columns, rows, cells, cell references in spreadsheet software.
- To use formatting techniques in a spreadsheet.
- To be able to use basic formulae to perform calculations using +-/*
- To be able to use the autofill tool to replicate cell data.
- To be able to create charts and graphs.
- To be able to use functions such as SUM, AVERAGE, MAX and MIN
- To be able to apply conditional formatting to data in a spreadsheet.
- To be able to sort and filter data.
Module 1 - Intro to Python
End Points for Module – Knowledge
- What is Python?
- What is coding?
- What is Syntax?
- What is Syntax error?
- What is turtle?
- What is iteration?
- What is input?
End Points for Module – Skills
- To be able to understand what coding is and how humans develop high-level programming languages to manipulate computer devices.
- To be able to effectively use coding conceptions to solve problems and create in Python.
- To be able to use the turtle function in Python to conceptualise and describe how input to the computer needs to be accurate for the computer to understand the instruction.
- To be able to use the turtle function in Python to code simple digital images.
Module 2 - Chatbots in Python
End Points for Module – Knowledge
- What are logical errors in code?
- What is selection?
- What is sequencing?
- What are variables?
- What are sub-routines?
- What are operators?
End Points for Module – Skills
- To be able to recognise certain errors in code and rectify those errors.
- To be able to use a high-level programming language to explore complex coding concepts.
- To be able to sequence a text-based coding project accurately.
- To be able to provide evidence of using abstraction to break down problems and use algorithmic thinking to provide a step by step approach to find a solution for the problem.
Module 3 - Advanced Graphics Development
End Points for Module – Knowledge
- What is a digital campaign?
- What is influence?
- What is marketing?
- What is a logo?
- What are graphics?
- What are animations?
- What is an infographic?
End Points for Module – Skills
- To be able to use various online resources to analyse, design, create and evaluate a social media campaign.
- To be able to identify how marketing and influence is used to make products/services more popular.
- To be able to create a logo.
- To be able to create mini animations and infographics for design and part of a campaign.
Module 4 - Intro to websites
End Points for Module – Knowledge
- What is the WWW?
- What is search?
- What is an index?
- What is a website?
- What are websites used for?
- What are links?
End Points for Module – Skills
- To be able to understand how search engines work.
- To be able to describe how the WWW works and how the different networks connect.
- To be able to design and develop a website on google sites.
- To be able to publish websites and create links on the website.
- To be able to include multiple forms of media on websites.
Module 5 - Website development (HTML)
End Points for Module – Knowledge
- What makes a good website design?
- What is navigation?
- What is HTML?
- What are Tags?
- What is a target audience?
End Points for Module – Skills
- Be able to add images, hyperlinks, background colours to a HTML page.
- Be able to create a webpage using HTML.
- Be able to judge the purpose of websites.
- Use tables in notepad to create the structure of the HTML page.
- Be able to format the font size, type, colour and font of the text in HTML.
Module 6 - Databases
End Points for Module – Knowledge
- What is a database?
- Who uses databases?
- What are the advantages and disadvantages of using database?
- What are the differences between paper based and digital databases?
- How can information be grouped?
- What is structured and unstructured data?
- What are validation checks used for?
- What is a query?
End Points for Module – Skills
- To be able to record information and data into a database.
- To be able to enter data using tables and form.
- To be able to sort and filter data in a database.
- To be able to query a database.
- To use data and create reports to show findings.
- Use the booleans AND and OR to refine data selection.
- Use multiple criterias to answer a given question about the data.
- Select charts appropriately to visually compare data.
Module 1 - Programming with Python
End Points for Module – Knowledge
- What is Python?
- What is coding?
- What is Syntax?
- What is Syntax error?
- What is turtle?
- What is iteration?
- What is input?
End Points for Module – Skills
- To be able to understand what coding is and how humans develop high-level programming languages to manipulate computer devices.
- To be able to effectively use coding conceptions to solve problems and create in Python.
- To be able to use the turtle function in Python to conceptualise and describe how input to the computer needs to be accurate for the computer to understand the instruction.
- To be able to use the turtle function in Python to code simple digital images.
Module 2 - Advance Programming in Python
End Points for Module – Knowledge
- What are logical errors in code?
- What is selection?
- What is sequencing?
- What are variables?
- What are sub-routines?
- What are operators?
End Points for Module – Skills
- To be able to recognise certain errors in code and rectify those errors.
- To be able to use a high-level programming language to explore complex coding concepts.
- To be able to sequence a text-based coding project accurately.
- To be able to provide evidence of using abstraction to break down problems and use algorithmic thinking to provide a step by step approach to find a solution for the problem.
Module 3 - Systems Security
End Points for Module – Knowledge
- What is spam?
- What is malware?
- What is phishing?
- How might someone steal your identity online?
- What is Hacking?
- What is a Ethical Hacker?
End Points for Module – Skills
- To be able to explain what malware is and describe the different types (virus/trojan/ransomware).
- To be able to identify spam and phishing emails and how to deal with them.
- To be able to explain how individuals, businesses and organisations can protect themselves from online threats.
- To be able to explain why updates occur so often.
- To be able to understand why hacking can be lucrative.
- To be able to understand the need for ethical hacking.
Module 4 - Beetle Blocks - 3D Design
End Points for Module – Knowledge
- What is 3D design?
- What is a turtle?
- What is 3D printing?
- What is “Random” in computer science?
- What is iteration?
- What is 3D art?
End Points for Module – Skills
- To be able to explain what 3D design is.
- To be able to design and create a 3D object to be printed off.
- To be able to program 3D art using logical steps.
- To be able to explain the importance of random in a program.
- To be able to understand the use of iterations in programming.
Module 5 - Data Representations
End Points for Module – Knowledge
- What are pixels?
- What are digital images?
- What is resolution?
- What is colour depth?
- What is digital conversion?
- What is analogue sound?
- What is digital sound?
- What are samples?
- What is sample rate?
- What is sample size?
- What are vector graphics?
- What is MIDI?
End Points for Module – Skills
- To be able to understand how pixels make up everything we see on a computer and how each colour has a binary representation.
- To be able to explain what true colour is and how it is represented in colour depth in computing.
- To be able to demonstrate how images are stored in files, and how files sizes will impact storage capacities.
- To be able to explain differences in analogue sound and digital sound.
- To be able to explain what samples are and how samle rates increase the need for storage.
- To be able to understand the need for compression and what this looks like with vector graphics and MIDI audio.
Module 6 - Boolean Logic
End Points for Module – Knowledge
- What is logic?
- What is a logic gate?
- What is an AND gate?
- What is an OR gate?
- What is a NOT gate?
- What is logic in programming?
End Points for Module – Skills
- To be able to explain what logic gates are and how they function.
- To be able to explain how logic gates function.
- To be able to understand and implement logic gates in systems.
- To be able to translate the meaning behind logic gates and what it means for computer systems when run.
- To be able to expand logical reasoning from the computer system to computational thinking.