scratch 3 gamemaker python desktop apps flask & web html css js sql actionscript 3.0 computational thought technical representation assessment games applications resources

1. Look at the **marks** first, then work out **how long** it is worth spending on *each section*:

You do not lose marks for wrong answers, so attempt **every** question.

**2. Pseudocode**

- Write
**BEGIN**and**END**on__every__algorithm or module - → Indent consistently
- IF remember to use
**THEN**and**ENDIF** - WHILE remember to use
**ENDWHILE** - IF and WHILE only execute when TRUE
- Use your left index finger to point (program flow)
- Draw up 2 tables with right hand – one variables, one output
*Modular*algorithms, parameter passing & return values*GLOBAL*vs*LOCAL*variables (scope)

**3. SQL**

**SELECT** aggregate(x.field) AS alias

**FROM** x INNER JOIN y on x.field == y.field

**WHERE** x.field<val1 AND filter2 OR filter3

**GROUP BY** aggregate(y.field)

**HAVING** y.field>val2 ...

**ORDER BY** x.col1 ASC, y.col2 DESC

If you see CREATE, INSERT, DELETE or UPADTE, don't panic - think back to past assignments.

**4. Block cipher shifts**

Y | Z | A | B |
---|---|---|---|

24 | 25 | 0 | 1 |

- MOD (%)
**wraps everything** - write the word
**mod**when using in pseudocode - base 26 system:
- 28 mod 26 == 2 (shift A
*forward*28 spaces will get me to C) - -24 mod 26 == 2 (shift A
*backward*24 spaces will get me to C)

- 28 mod 26 == 2 (shift A
- Works same for base 10 system:
- 11 mod 10 == 1 (shift 0
*forward*11 spaces will get me to 1) - -9 mod 10 == 1 (shift 0
*backward*9 spaces will get me to 1)

- 11 mod 10 == 1 (shift 0
- Preserving case, space and grammar creates patterns in ciphertext that make it weaker

**5. Expect the unexpected**

```
ALTER TABLE Students
ADD FOREIGN KEY (StudentID)
REFERENCES Medical(StudentID)
ON DELETE RESTRICT
ON UPDATE CASCADE;
```

**READ ALL SLIDESHOWS AND COMPLETE ALL EXAM PRACTISE ACTIVITIES**

Deal with the unexpected by being strategic & problem solving. Content may appear from *year 11*, *past assignments* or *unfamiliar sources*. You are a __Digital Solutions__ student, so __find a solution__.