Paper 2 Revision

Paper 2 Revision

1. SQL

   • *SELECT *FROM *WHERE *LIKE "%" *ORDERBY

2. Computational thinking

   • Abstraction
     • Removes unnecessary detail to make problems less complex
   • Decomposition
     • Break down problems to make them easier to solve
   • Algorithmic Thinking
     • Logical steps to solve a complex problem

3. Maintaining code

   • *Indentation *Comment your Code * Using constants *Meaningful variable names

4. Syntax/logic errors

   • Syntax error: Error in the rules of the language (spelling of a command word) Logic error: Code runs, just not as you expect it to

5. DIV and MOD

   • DIV: Uses floor division(whole number) MOD: Returns remainder after division

6. Testing

   • Used to find defects before releasing a program

7. Sub Programs

   • Allow you to reuse in other programs and avoids repetition

8. Storing Data

   • Variable
     • Data can change when the program is running
   • Constant
     • Data cannot change when the program is running