Pseudocode

Question 1

Description of NOT gate

Answer 1

triangle with circle in front

Question 2

WHERE in SQL

Answer 2

query/condition of data to be displayed

Question 3

COUNT in SQL (2)

Answer 3

counts number of records where field matches condition

used with SELECT

Question 4

RANDOM() Library routine

Answer 4

returns a random number between 0 and 1

Question 5

SUM in SQL (2)

Answer 5

sum of all values in field

used with SELECT

Question 6

Components of decomposition in analysis stage (4)

Answer 6

input - what is put into system

processes - action taken to achieve result

output - what is taken out of system

storage - what needs to be kept in for future use

Question 7

NAND gate rule

Answer 7

if both input = 1, then output = 0

Question 8

Case Statement Structure (4)

Answer 8

CASE OF “Name”

1:
2:

OTHERWISE OUTPUT

ENDCASE

Question 9

ROUND library routine (2)

Answer 9

returns value rounded to specified number of decimal places

rounded to highest or lowest value

Question 10

Validation check meaning (2)

Answer 10

checks that data input is reasonable + meets certain criteria

automated check carried out by computer

Question 11

Bubble Sort (8)

Answer 11

Swap <– False

REPEAT
if variable 1 > variable 2
then var <– variable 1
variable 1 <– variable 2
variable 2 <– var
Swap <– True
UNTIL Swap = True

Question 12

Range check

Answer 12

checks that data is within certain range

Question 13

Coding of Program Development Life Cycle (2)

Answer 13

uses design from previous stage

written using IDE

Question 14

Function structure with parameters (3)

Answer 14

FUNCTION Name (variable : type) RETURNS type

RETURN (“action”)

ENDFUNCTION

Question 15

OR gate rule

Answer 15

output = 1 if either input = 1

Question 16

ORDER BY in SQL

Answer 16

sorts results numerically or alphabetically

Question 17

Extreme Data

Answer 17

largest and smallest data that algorithm should allow

Question 18

Procedure with parameters structure (6)

Answer 18

PROCEDURE Stars (Number : INTEGER)

DECLARE Counter : INTEGER

FOR Counter –> 1 to Number
OUTPUT “*”

NEXT Counter

ENDPROCEDURE

CALL Stars(7) //outputs 7 *

Question 19

Design of Program Development Life Cycle (3)

Answer 19

visually representing program before coding

will help to explain how code works

e.g flowchart

Question 20

MOD

Answer 20

remainder of division

Question 21

Type check

Answer 21

checks that data entered is correct type (e.g integer, string)

Question 22

Substrings code (2)

Answer 22

SUBSTRING(STRING, position of start character, length of substring)

string starts at position 1

Question 23

Description of AND gate

Answer 23

curved rectangle

Question 24

Description of NOR gate

Answer 24

arrowhead with circle in front

Question 25

Analysis of Program Development Life Cycle (4)

Answer 25

understand what program will do abstraction - obtain required input/output information decomposition - breaking the program down into steps indentifying requirements - conditions to be carried out to get final outcome

Question 26

Define format check

Answer 26

checks that input provided has valid formatting (e.g margins, font)

Question 27

File Handling Structure using WRITE (3)

Answer 27

OPENFILE "file name" FOR WRITE WRITEFILE "filename", variable CLOSEFILE "filename"

Question 28

FROM in SQL

Answer 28

indentifies table to use

Question 29

Length check

Answer 29

checks that number of characters is correct

Question 30

Testing of Program Development Life Cycle

Answer 30

ensuring that program works as it should

Question 31

Verification check meaning

Answer 31

checks that data is not changed as it is entered from one source to another

Question 32

DIV library routine (2)

Answer 32

performs integer division answer is whole number

Question 33

Boundary data

Answer 33

data at the limit and data one value beyond (error)

Question 34

Examples of Design in program development cycle (3)

Answer 34

flowchart pseudocode structure diagram

Question 35

Declaring a 2D array

Answer 35

DECLARE Name : Array[number:number] of integer

Question 36

Order of the Program Development Life Cycle (4)

Answer 36

Analysis Design Coding Testing

Question 37

File Handling Structure using READ (3)

Answer 37

OPENFILE "file name" FOR READ READFILE "filename", variable CLOSEFILE "file name"

Question 38

XOR gate rule

Answer 38

output = 1 if input A is 1 AND input B is 0 OR input A is 0 AND input B is 1

Question 39

AND gate rule

Answer 39

output = 1 if both inputs = 1

Question 40

2 types of verification check (2)

Answer 40

double-entry check - data is entered twice to check that no changes are made visual check - user looks through data entered + confirms no changes have been made

Question 41

MOD library routine

Answer 41

returns remainder of division

Question 42

Record in grid

Answer 42

horizontal rows

Question 43

Description of NAND gate

Answer 43

curved rectangle with circle in front

Question 44

Validation checks (6)

Answer 44

Length check Range check type check check digit Prescence check format check

Question 45

Define abstraction (3)

Answer 45

simplifying the problem selecting elements required removing irrelevent data from elements

Question 46

Define prescence check

Answer 46

checks if user has entered data

Question 47

NOR gate rule

Answer 47

output = 1 if neither inputA OR B = 1

Question 48

NOT gate rule

Answer 48

output = 1 if input = 0

Question 49

Field in grid

Answer 49

vertical collumns

Question 50

How program can be written to make it presentable + maintained (4)

Answer 50

use comments to explain purpose of code use meaningful identifier names - clearly identify purpose use procedures + functions - shortens code indentation + space - more readable

Question 51

Description of OR gate

Answer 51

arrowhead

Question 52

SELECT in SQL

Answer 52

fetches specified fields from table

Question 53

Normal Data

Answer 53

data within the algorithm range

Question 54

SQL structure (4)

Answer 54

SELECT FROM WHERE ORDER BY field ASC or DSC;

Question 55

Procedure without parameters structure (4)

Answer 55

PROCEDURE Name OUTPUT "action" ENDPROCEDURE CALL Name

Question 56

Description of XOR gate

Answer 56

arrowhead with line behind

Question 57

Abnormal/Erroneous Data

Answer 57

data rejected by algorithm

Question 58

Linear Search (9)

Answer 58

Found <-- False REPEAT IF Name = Student[Count] THEN Found <-- True ELSE Count <-- Count + 1 UNTIL Found = True OR Count > ClassSize