Programming

Question 1

MOD

Answer 1

Remainder of division

Question 2

DIV

Answer 2

Answer without remainder

Question 3

Subprogram

Answer 3

Large program broken down into smaller subprograms.
Focus on specific function
Help decompose complex programs

Question 4

Return in subprograms

Answer 4

Send value (perhaps a variable only in the subprogram ) back to line where function was called on- so it can be used on the line
Ie: to be printed

Question 5

Two types of subprogram

Answer 5

Function
Procedure

Question 6

Function

Answer 6

Subprogram that returns a value (using return)

Question 7

Procedure

Answer 7

Doesn’t return value

Question 8

Advantage of using subprograms

Answer 8

Breaks down complex problems into smaller parts- easier to design and test
Each can be tested separately and use abstraction to simply the problem
Reuse the code, quicker to develop other programs
Avoids code repetition, shorter programs (which are easier to develop and maintain and debug)
Split work between different programmers to work on different subprograms at a time.

Question 9

Array

Answer 9

Static data structure, hold fixed number of same data type elements
Python does not use array (uses lists)

Question 10

How is an element in an array accessed?

Answer 10

Using it’s index (location number)
Usually starts at 0

Question 11

Static data structure

Answer 11

Fixed number of elements (cannot be resized)
Elements can change

Question 12

Dynamic data structure

Answer 12

Memory efficient and not fixed capacity
Number of data items is only constrained by overall memory allocated to program

Question 13

How to transverse an array?

Answer 13

Transverse (‘move through’)
Use for loop
For I in Array:
Print (I)

Question 14

How to add a value to an array?

Answer 14

Cannot change amount of elements, change value of already existing element

Array[3] = “change”
Remember the 3 is the 4th value

Question 15

How to delete a value from an array?

Answer 15

Fixed size so cannot delete value but overwrite as blank

Array[2] = “ “
The 2 is the 3rd value

Question 16

How to search for value in an array?

Answer 16

Use for loop and see if equal to item
For value in Array:
If value == “change”
Print(value)

Question 17

What is a two dimensional array

Answer 17

Same data type but multiple rows and columns

Question 18

How to measure in two dimensional array?

Answer 18

Row first, then column
Row (down), column (across)

Question 19

How to search two dimensional array?

Answer 19

Print(Array[3][5])
Prints 5th column on 3rd row
x,y,z,a,(3,5)
That’s the 3rd row, 5th column

Question 20

Record

Answer 20

Store data of different types which are made of information of one person or thing
Each piece of information in the record is a field

Question 21

Field (record)

Answer 21

A row name (piece of info)

Question 22

What is a key field (records)?

Answer 22

Unique data that indentifies each record

Question 23

How to present records and fields/database tables?

Answer 23

2D array

Question 24

SQL

Answer 24

Structured query language

Question 25

What is SQL used for?

Answer 25

Used to search for data in a database

Question 26

Format of SQL

Answer 26

Select (field/ wildcard (all)) From (table- usually given) Where (criteria, truth/boolean)

Question 27

Wildcards

Answer 27

* -presents all fields

Question 28

Name all data types

Answer 28

Integer Float (real) Boolean Character String Null (nothing)

Question 29

What is the code for all data types?

Answer 29

Integer= int Float(real)= float Boolean= bool Character= char String= str

Question 30

What is an integer?

Answer 30

Whole numbers (positive and negative)

Question 31

What is a real/float?

Answer 31

Numbers including decimal places

Question 32

What is a Boolean?

Answer 32

Based on logic, True or False (only two options) bool(1) #itll be True bool(0) #itll be False

Question 33

What is a character?

Answer 33

Single letter, number, symbol

Question 34

What is a string?

Answer 34

Represents text (collection of characters)

Question 35

What is casting?

Answer 35

Converting one data type into another

Question 36

Using ASC and CHR (psuedocode)

Answer 36

ASC converts the character into its ASCII number CHR converts ASCII number into its character

Question 37

What is sequence?

Answer 37

Order in which instructions occur and are processed

Question 38

What is selection?

Answer 38

A block of code is executed depending on whether a condition is true or false

Question 39

Example of selection statement:

Answer 39

If statements Switch statements (unsupported in python)

Question 40

What is iteration?

Answer 40

Repeating a section/ block of code until a certain condition is met (or a number of times)

Question 41

What is a condition-controlled iteration?

Answer 41

ie: indefinite iteration Block of code is repeated based on a condition that is evaluated

Question 42

Example of condition-controlled iteration:

Answer 42

While loops Do while Repeat until

Question 43

Difference between Do-until and Do-while

Answer 43

Do-until= execute block of code, stops once condition is true Do-while= executes block of code as long as the condition is true (break by condition being false)

Question 44

How does Do-until loop work?

Answer 44

Controlled by condition at the end of the loop Code always runs at least once!!

Question 45

How does a while loop work?

Answer 45

Controlled by condition at the start of the loop The code may never be run (if condition is false)

Question 46

What is a count-controlled iteration?

Answer 46

ie: definite iteration Group of instructions is repeated a specific amount of times

Question 47

Examples of count-controlled iteration:

Answer 47

For loops

Question 48

What would be printed in: for count in range(1,6) print(count)

Answer 48

1 2 3 4 5

Question 49

What would be printed in: for i in range(3, 31, 3) print(i)

Answer 49

3 6 9 12 15 18 21 24 27 30 (Prints all 3 time tables from 3 to 30)

Question 50

Sign for exponentiation

Answer 50

** (To the power of ie: 2**3 = 8)

Question 51

//

Answer 51

DIV Division without the remainder

Question 52

%

Answer 52

MOD (modulo) Only reminder of a division

Question 53

How to use ‘NOT’ in an if statement?

Answer 53

If NOT score == “2”:

Question 54

If you wanted to print 006290 would it be str or int?

Answer 54

Str(“006290”) As an int, the 0 in the front would be dropped

Question 55

How to find length of string?

Answer 55

len() ie: Password = input (“ Enter: “) LengthOfPassword = len (Password)

Question 56

How to make a string with a length of 0?

Answer 56

String = “” (No spaces, a space is a character)

Question 57

How to make whole string uppercase?

Answer 57

Uppercase = (string).upper()

Question 58

How to make whole string lowercase?

Answer 58

Lowercase = (string).lower()

Question 59

Can a variable name start with a letter?

Answer 59

Yes

Question 60

Can a variable name start with a number?

Answer 60

No

Question 61

Is the variable ‘hello’ the same as ‘Hello’?

Answer 61

No, they’re case-sensitive

Question 62

How to convert ASCII code into letter (code)?

Answer 62

chr(code)

Question 63

How to convert letter into ASCII code (code)?

Answer 63

ord(“ “)

Question 64

What is concatenation?

Answer 64

Joining of string

Question 65

How to code string concatenation?

Answer 65

Print( “hello” + name )

Question 66

How to code concatenation with other data types?

Answer 66

Print ( “You have ” + str(newMessages) + “ new messages”) Or Print (f “You have {newMessages} new messages”)

Question 67

How to append to list?

Answer 67

List.append(“add this”)

Question 68

How to insert an item into a specific integer of a list?

Answer 68

List.insert(2,”insert this”) #this will insert into the 3rd position because it starts at 0

Question 69

How to loop 5 times?

Answer 69

for i in range(5): #will only go 5 times