Unit 2.2 - Programming Techniques

Dan Roberts
Mind Map by Dan Roberts, updated 10 months ago More Less
Dan Roberts
Created by Dan Roberts 11 months ago


Year 10 Computing Mind Map on Unit 2.2 - Programming Techniques, created by Dan Roberts on 01/27/2019.

Resource summary

Unit 2.2 - Programming Techniques
1 Sequencing
1.1 Allows a programmer to solve complex tasks through a number of simple steps
1.2 Each line follows the next
1.3 Creates simple programs very quickly
1.4 Easy to follow for a small program
1.5 Fundamental principal of a program
1.6 Not efficient
1.7 Becomes very difficult to follow with large programs
1.8 Hard to maintain
2 Selection
2.1 Allows a computer to make decisions
2.2 Changes the flow of a program depending on a set conditions
2.3 Used for validation, calculation and making sense of a user's choice
2.4 Nested Selection
2.4.1 Only evaluates a condition if pre-conditions are met
2.4.2 There is no limit on how many selection statements we can nest
2.4.3 The outside selection is the pre-condition and the inside is the condition
3 An array up to 2D to a file
3.1 Iterate through an array using WRITELINE and writing elements to the file one by one
3.2 Serialise the array (convert to a string) using delimiters e.g. commas for columns and NewLines for rows in case of a 2D array
3.3 Uses numeric index not names
3.4 Array: An ordered collection of related data where each element is accessible by a number index
4 SQL (Standard Query Language)
4.1 A popular readable programming language
4.2 Used to work with databases stored in binary proprietary formats e.g. Oracle, MySQL
4.3 Purpose of SQL S-Search C-Create R-Read U-Update D-Delete
5 Variables
5.1 A "variable" is a memory location that changes throughout the program
5.2 A "constant" is a memory location that is fixed for the duration of the program
5.3 "Assignment" is labelling various inputs, constants and outputs with descriptive names
5.4 Information is stored in memory locations under descriptive names called "identifiers"
5.5 "Concatenation" is joining inputs/text variables together
5.6 "Parameters" are inputs coming from the console, from a file or from elsewhere in a modular program
6 Operators
6.1 Boolean - An outcome of one of two values
6.2 String - A sequence of characters
6.3 Concatenate - Join Together
6.4 Substring - A smaller part of a string
6.5 Delimiter - One or more characters that separates a string
7 Iteration
7.1 "Iteration" is when loops run similar types of data
7.2 A "For Counter" is a loop for when we know how many times we want something to loop so we use a counter
7.3 "Stepping" is when we skip or miss out when counting
7.4 A "While Loop" is used for validation and searching. Evaluates a boolean everytime they run
Show full summary Hide full summary


A level Computing Quiz
Zacchaeus Snape
Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
Output Devices
Jess Peason
Kwame Oteng-Adusei
Pack of playing cards answer
Karl Taylor
Code Challenge Flow Chart
Charlotte Hilton
Computing Hardware - CPU and Memory
Computer Systems
Computer science quiz
Ryan Barton
GCSE Computing - 4 - Representation of data in computer systems