Karteikarten
Year 9 Keywords Definitions
Karten in diesem Stapel (45)
- 1foreign keya field in a database table that is a primary key in another table
- 2validation rulemakes sure data entered is reasonable and sensible
- 3Boolean datadata that can only have one of two values, e.g. true/false, yes/no
- 4integera whole number data type
- 5real number or floata number data type that contains decimals
- 6between ... and ....a database search criteria for searching between 2 number values
- 7>a database search criteria to find a number greater than a specified value
- 8<a database search criteria to find a number less than a specified value
- 9not ...a database search criteria to find all values apart from a specified value
- 10'print' keyword in Pythonoutputs the data to the screen
- 11int()casts a value in Python to integer
- 12str()casts a value in Python to string
- 13stringdata that can contain text, characters, spaces & numbers
- 14input()a command in Python that prompts the user to enter information on the screen in response to a question
- 15variablean area (or 'box') in Python where data a user enters is stored, e.g. a name
- 16loop / iterationa command in a computer program that makes the program keep repeating until a specified event happens
- 17ifmakes a computer program only run under certain conditions
- 18cell referencethe name of a cell in a spreadsheet, e.g. A1
- 19worksheetone sheet within a spread sheet workbook
- 20formulaa calculation in a spread sheet using +, -, * or /
- 21functiona complex calculation built in to a spread sheet that uses words, e.g. SUM, IF, COUNTIF
- 22conditional formattinga cell in a spread sheet changes colour according to data entered into it
- 23macroa series of actions recorded as one action and usually run using a button
- 24cell linka formula that links the data in a cell in one worksheet to a cell in another worksheet
- 25IF functiongives a true or false answer depending on a logical test or comparison between the value in one cell and another value
- 26VLOOKUPlooks up the value in a cell in a range of cells to give an answer from a specified column number in that cell range
- 27COUNTIFcounts the number of cells in a range of cells that contain a specified criteria or value
- 28relative cell referencea cell reference in a formula that will change relative to its position if the formula is copied to another place in the spreadsheet
- 29absolute cell referencea 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
- 30MAX functionfinds the highest value in a range of cells
- 31MIN functionfinds the lowest value in a range of cells
- 32recorda row in a database containing data about one item or person
- 33fielda column in a database containing an individual data item
- 34tablea collection of records and fields in a database
- 35database forma user-friendly place to enter data into a database table
- 36reporta method of printing out a query or table from a database to make it look more attractive
- 37querya place to search for data & store the results of the search, in a database
- 38relational databasemore than one table linked to each other by fields
- 39primary keya database field that uniquely identifies each record and is used to link tables together
- 40+ - * /mathematical operators used to perform calculations in Python
- 41==Python command meaning = in 'if' selections
- 42!=Python command meaning 'not =' in 'if' selections
- 43elsekeyword in Python that carries out the second part of a program if the first 'if' condition is not met
- 44elifif the first 2 parts of a program in Python are not met, this keyword runs the last condition
- 45# (hash)used to add comments to a program to make it easier to understand
Informationen
- Beschreibung
- KS3 Year 9 ICT & Computing Karteikarten am Year 9 Keywords Definitions, erstellt von Fiona Faulkner am 08/05/2013.
- Erstellt von
- Fiona Faulkner
- Aufrufe
- 305
- Tags
- Bewertung