Year 9 Keywords Definitions

Description

KS3 Year 9 ICT & Computing Flashcards on Year 9 Keywords Definitions, created by Fiona Faulkner on 08/05/2013.
Fiona Faulkner
Flashcards by Fiona Faulkner, updated more than 1 year ago
Fiona Faulkner
Created by Fiona Faulkner almost 11 years ago
277
0

Resource summary

Question Answer
foreign key a field in a database table that is a primary key in another table
validation rule makes sure data entered is reasonable and sensible
Boolean data data that can only have one of two values, e.g. true/false, yes/no
integer a whole number data type
real number or float a number data type that contains decimals
between ... and .... a database search criteria for searching between 2 number values
> a database search criteria to find a number greater than a specified value
< a database search criteria to find a number less than a specified value
not ... a database search criteria to find all values apart from a specified value
'print' keyword in Python outputs the data to the screen
int() casts a value in Python to integer
str() casts a value in Python to string
string data that can contain text, characters, spaces & numbers
input() a command in Python that prompts the user to enter information on the screen in response to a question
variable an area (or 'box') in Python where data a user enters is stored, e.g. a name
loop / iteration a command in a computer program that makes the program keep repeating until a specified event happens
if makes a computer program only run under certain conditions
cell reference the name of a cell in a spreadsheet, e.g. A1
worksheet one sheet within a spread sheet workbook
formula a calculation in a spread sheet using +, -, * or /
function a complex calculation built in to a spread sheet that uses words, e.g. SUM, IF, COUNTIF
conditional formatting a cell in a spread sheet changes colour according to data entered into it
macro a series of actions recorded as one action and usually run using a button
cell link a formula that links the data in a cell in one worksheet to a cell in another worksheet
IF function gives a true or false answer depending on a logical test or comparison between the value in one cell and another value
VLOOKUP looks up the value in a cell in a range of cells to give an answer from a specified column number in that cell range
COUNTIF counts the number of cells in a range of cells that contain a specified criteria or value
relative cell reference a cell reference in a formula that will change relative to its position if the formula is copied to another place in the spreadsheet
absolute cell reference a cell reference in a formula that won't change if the formula is copied to another position in the spread sheet; the dollar sign is used to make a cell reference absolute
MAX function finds the highest value in a range of cells
MIN function finds the lowest value in a range of cells
record a row in a database containing data about one item or person
field a column in a database containing an individual data item
table a collection of records and fields in a database
database form a user-friendly place to enter data into a database table
report a method of printing out a query or table from a database to make it look more attractive
query a place to search for data & store the results of the search, in a database
relational database more than one table linked to each other by fields
primary key a database field that uniquely identifies each record and is used to link tables together
+ - * / mathematical operators used to perform calculations in Python
== Python command meaning = in 'if' selections
!= Python command meaning 'not =' in 'if' selections
else keyword in Python that carries out the second part of a program if the first 'if' condition is not met
elif if the first 2 parts of a program in Python are not met, this keyword runs the last condition
# (hash) used to add comments to a program to make it easier to understand
Show full summary Hide full summary

Similar

Python revision quiz
Fiona Faulkner
SCRATCH
Fiona Faulkner
Python revision quiz
Martin Covill
Ebola Virus Disease
rubyduggan
Revolutions and Turmoil: Russia 1905-1917
Emily Faul
Quick tips to improve your Exam Preparation
James Timpson
Sociology- Key Concepts
Becky Walker
Fractions
Kayleigh Elkins
organic chemistry
osgoconqr
PHR and SPHR Practice Questions
Elizabeth Rogers8284
Contract Law
sherhui94