Revision notes.

Try this with Computer Science

1. Close your notes and write the main idea in two sentences from memory.
2. Reopen the source and correct the first mistake or omission you find.
3. Add one example and one question to test whether you can apply the idea.

View Computer Science resources on ATARMAXXING ↗

Topics in the resource inventory

• Control structures, data types, operators and Boolean logic
• Modular code: functions, parameters, scope and parameter passing
• Data structures: one- and two-dimensional arrays and dictionaries
• Search and sort algorithms and Big O notation
• Classes, objects, inheritance, encapsulation, abstraction and polymorphism
• Development framework, linear vs iterative processes and good programming practice
• Testing, error types, debugging and desk checking with trace tables
• Impacts of software and the rights and responsibilities of software developers
• Privacy Act 1988, Australian Privacy Principles (APP5, 8, 10, 11, 12), Notifiable Data Breaches and data ethics
• OSI and DoD TCP/IP models, layer roles and packet architecture
• TCP vs UDP, ports, DNS, default gateways, IPv4 vs IPv6 and public vs private addressing
• IP addressing schemes, subnet masks, subnetting and CIDR notation
• Network components, Cisco network diagrams, topology, bandwidth, ping and traceroute
• External and internal network threats, malware and zero day vulnerabilities
• Security solutions, mitigation strategies, the CIA triad, the AAA framework and red vs blue teams
• Symmetric and asymmetric encryption, certificates, secure communication and early ciphers
• Relational database concepts: entities, keys, relationships, data types, anomalies, ACID and ODBC
• ER diagrams in crow's foot notation, relational notation, data dictionaries and resolving M:N
• Data integrity, data quality and normalisation to 3NF
• SQL: CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, joins, aggregates and GROUP BY