Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
38 Cards in this Set
- Front
- Back
|
What 2 operations can this symbol perform?
|
Assignment operator and comparision operator
|
|
|
What is wrong with this: 5 + 6 = total
|
The VARIABLE should be on the left and the EXPRESSION should be on the right
|
|
|
What is the value of total: total = 13 DIV 5
|
2 (do the division as normal and chop off the decimal)
|
|
|
What is the value of total: total = 2 DIV 5
|
0 (if the left number if smaller than the right number the answer will always be 0)
|
|
|
What is the value of total: total = 13 MOD 5
|
3 (there is 3 left over that cannot be divided by 5 )
|
|
|
What is the value of total: total = 2 MOD 9
|
0
|
|
|
==
|
equal to
|
|
|
< >
|
not equal to
|
|
|
<
|
less than
|
|
|
>
|
greater than
|
|
|
>=
|
greater than or equal to
|
|
|
<=
|
less than or equal to
|
|
|
TRUE AND TRUE = ?
|
TRUE
|
|
|
FALSE AND TRUE =?
|
FALSE
|
|
|
TRUE AND TRUE AND FALSE = ?
|
FALSE
|
|
|
FALSE OR TRUE = ?
|
TRUE
|
|
|
FALSE OR FALSE = ?
|
FALSE
|
|
|
What is meant by operator precedence?
|
The DEFAULT ORDER that operators are evaluated
|
|
|
What is the value of total: total = 4 + 4 * 2
|
12
|
|
|
How can you change the natural operator precedence?
|
Use brackets
|
|
|
Why is it considered good practice to use brackets?
|
It will make the CALCULATION easier to understand
|
|
|
What does concatenating mean?
|
Joining multiple strings together in order to make one String E.G “You will need “ + marks + “to get an A”
|
|
|
What would this output: LEFT(“application”, 3)
|
“app”
|
|
|
What would this output: RIGHT(“application”, 3)
|
“ion”
|
|
|
What would this output: MID(“application”, 6,3)
|
"cat"
|
|
|
What would this output: LENGTH(“Jurassic World”)
|
14
|
|
|
What does this function return? ASCII()
|
returns the ASCII code for the character passed to it
|
|
|
What does this function return? char()
|
returns the character that is represented by the character code passed
|
|
|
Does this expression equate to true or false? "FLOYD" == "Floyd" |
False Uppercase and lowercase values are stored using different character codes |
|
|
Explain why: "2" < "11" = FALSE |
Numbers stored as Strings are sorted by comparing individual digits and not the value of the number. The character codes of the individual digits are compared and the lowest char code will go first. |
|
|
Describe how a computer compares Strings
|
Characters are compared from left to right using their CHARACTER CODES The character with the lower code goes first The first characters are compared first. If they are the same, the next characters are compared UPPERCASE characters have a lower value than their LOWERCASE equivalent A space character has a lower value than all the letters Numbers stored as Strings are sorted by comparing individual digits and not the value of the number |
|
|
What is meant by the term 'validation'?
|
Validation is a check performed by the computer to ensure data entered is sensible. The data entered if checked against pre programmed rules and if the rule is broken an error will occur.
|
|
|
What is meant by the term 'verification'?
|
Verification is where data is checked to see if it matches with the original.
|
|
|
Name 1 method of verification
|
Double entry |
|
|
Describe how double entry works
|
Data is entered twice (by the same person or two different people) The system will compare the two inputs If there is a difference between the inputs an error message will appear and the data needs to be entered again. |
|
|
Name 6 types of validation check
|
presence check existence check range check length check format check character check check digit |
|
|
Length check
|
Checks the number of characters in the field is within set limits e.g
|
|
|
|
|
