Term
|
Definition
| a field of computer science devoted to making computers percieve, reason, interpret and respond to new situations without direct instructions |
|
|
Term
|
Definition
| webpage/software that pulls info from rss feeds - tracks what's been read - allows you to add remove feeds |
|
|
Term
|
Definition
| the connection to the isp - high bandwidth - always on - uses broadband modem |
|
|
Term
|
Definition
| an irreversible form of compression when encoding data that results in a loss of quality in exchange for smaller file size - eg jpeg, mp3 |
|
|
Term
|
Definition
| a reversible form of compression where there is no loss of quality. The initial file can be recreated from the compressed one |
|
|
Term
|
Definition
| Database Management System |
|
|
Term
| Database Management System |
|
Definition
| a program that manages and processes the data inputted on to the databases furthermore it maniplulates the data so that it can be interrogated during searches |
|
|
Term
| a Database Management System provides....... |
|
Definition
|
|
Term
|
Definition
| an interface that allows a user, a computer and an instrument to interact |
|
|
Term
|
Definition
| the address of a cell eg b3 |
|
|
Term
|
Definition
| a series of concurrent cells in a spreadsheet that are described by the putting the top left and the bottom right cell references separated by a colon e.g. B10:C22 would be the cell range that covered all of the cells from b10 to c22 inclusive |
|
|
Term
|
Definition
| a cell reference in a formula which when the formula is copied to a different cell, changes the formula to include a reference to a different cell which has the same spacial relationship to the formula as the original. eg copying formula a1*3 from d1 to d2 would change the formula to a2*3 automatically |
|
|
Term
|
Definition
| a cell reference in a formula which when the formula is copied to a different cell, still points to the original cell reference - usually marked by $ signs. e.g. eg copying formula $a$1*3 from d1 to d2 would result in the formula in both being $a$1*3 |
|
|
Term
|
Definition
| a step by step process for calculating a number on a spreadsheet typed in by the user - it automatically updates itself if the contents of the cells it refers to changes |
|
|
Term
|
Definition
| a predefined calculation that is inbuilt into spreadsheet software such as sum or average |
|
|
Term
|
Definition
| a database that uses a series of tables to hold data about each entitiy |
|
|
Term
|
Definition
| an object, thing or person about which data is held in a database |
|
|
Term
|
Definition
| a database object that is used to interrogate the data - ie get information out of the data |
|
|
Term
|
Definition
| an interface part of the database that is used both for input of data and output of information to the user - can be used to enter data into a table or display the results of a sort or search (query!) |
|
|
Term
|
Definition
| graphical user interface - the buttons, boxes and user friendly menus that are used to help the users navigate the database forms |
|
|
Term
|
Definition
| selects records that meet the criteria set in one or more fields |
|
|
Term
|
Definition
| a printed output from a database that usually displays the results of a query |
|
|
Term
|
Definition
| the storage of pictures as collections of lines, sapes, and other objects that can be manipulated as a whole, rather than just a selection of pixels - used in animation, films, modelling for architects and engineers and computer games |
|
|
Term
|
Definition
| graphics produced by storing the instruction of how to create the image (a line x cm long, a curve x cm long with a radius of 3 cm etc) - scalebale without distortion, and smaller size, but can't do images like photos |
|
|
Term
|
Definition
| a 'map' of which pixel is which colour is stored either one by one (eg bmp) or in some compressed format (eg jpg) |
|
|
Term
|
Definition
| a 'picture element' or dot on a computer screen or printout of which all output is composed |
|
|
Term
|
Definition
| 'coder-decoder' - a piece of software usually used for audio or video files to encode or decode a file in a given format - their are lots of different proprietary formats and each needs its own codec before you can play it |
|
|
Term
|
Definition
| a set of rules for the exchange of data between two computers. Common ones used on the internet include tcp/ip and http |
|
|
Term
|
Definition
| the combination of hardware and operating system software upon which applications software is built |
|
|
Term
|
Definition
| the ability of a peripheral device to work on more than one platform eg USB can be used with both Windows and Macs |
|
|
Term
|
Definition
| a bug fix usually published on the software manufactures support page - applying these is often an effective way of stopping security vulnerabilities being exploited by hackers |
|
|
Term
|
Definition
| an automated procedure often programmed/recorded by the user, that performs a series of commonly used steps in a piece of sofware. Eg printing a particular sheet with the current data, running a query and exporting the data or copying data from one file to another |
|
|
Term
|
Definition
| the layout of the wires in a wired network - the common ones are bus, star and ring (although mesh also exists rarely) |
|
|
Term
|
Definition
| a network that has a topology that is made up of more than one type of topology |
|
|
Term
|
Definition
| a card that looks like a standard credit card, but features an embedded microprocessor and memory instead of a magnetic strip |
|
|
Term
|
Definition
| a device that when energized by a nearby rfid reader, broadcasts information to the reader for input into a computer |
|
|
Term
|
Definition
| an rfid tag that contains its own power supply and is not dependent on being engergised by a reader - it has a longer range |
|
|
Term
|
Definition
| a radio device designed to communicate with tags - different types dependent on the range and device |
|
|
Term
|
Definition
| processing that happens in control systems - medical monitoring, datalogging, environmental control, robotics |
|
|
Term
|
Definition
| computer processing that happens when you are dealing with data (databases, information processing systems) - a transaction is adding a record, deleting one, editing one, even reading one |
|
|
Term
|
Definition
| Structured query language - the most widely used language for managing data in relational databases. It has been standardised and DBMS vendors now certify their products as being compliant with this. |
|
|
Term
|
Definition
| the form of transaction processing where each transaction is dealt with in turn and each is completed before the next is started. Used where time is a factor and you don't want things to get out of date eg cinema tickets, online banking |
|
|
Term
|
Definition
| transactions are collected into batches over a specified period of time (e.g. a day for cheques, a month for utility bills). They are then entered, validated, sorted and then in one go used to update the master file. The result is a new master file, and the old one is kept as a father file |
|
|
Term
|
Definition
| An informal term that is used to describe the use of deception to get individuals to reveal sensitive information. eg pretending to be someone else and get their password reset so you can access their account. Often easier to do than technical hacking |
|
|
Term
|
Definition
| a malicious network of bots (zombie computers) often used for spamming, malicious software attacts, DNS attacks and pornography |
|
|
Term
|
Definition
| an internet connected computer that has been hijacked using viruses or other tools to perform malicious acts without the knowledge of their owners/users |
|
|
Term
|
Definition
| the use of a computer model to replicate reality. used extensively in training, research, gaming |
|
|
Term
|
Definition
| the use of computers to create abstract mathematical models of objects, organisations, organisms and processes. eg bacteria, economy of Brazil, an alien space ship |
|
|
Term
|
Definition
| the discovery and extraction of hidden predictive information from large databases |
|
|
Term
|
Definition
| the extaction of information from the combination of data from two different databases using a common key eg passport number, social security number, date of birth combined with address. Allows for matching of police records with education records for eg |
|
|
Term
|
Definition
| the processing of going through a database and getting rid of records that contain errors - makes the data more valuable |
|
|
Term
|
Definition
| an integrated collection of data stored in one location belonging to one organisation |
|
|
Term
| data warehousing software |
|
Definition
| software used to create and maintain huge databases |
|
|
Term
|
Definition
| a collection of data stored in an organised form that can be interrogated to produce information |
|
|
Term
|
Definition
| a database that has only one table (and so should have only one entity!) - if it is about more than one thing, it will have problems with data redundancy which leads to errors |
|
|
Term
|
Definition
| a database that has only one table (and so should have only one entity!) - if it is about more than one thing, it will have problems with data redundancy which leads to errors |
|
|
Term
|
Definition
| that act of checking that data which is being input is reasonable - it falls into a particular range, is present, is in a particular format, has a particular number of characters etc |
|
|
Term
|
Definition
| the act of reducing input errors by comparison - in double entry verification it is entered twice and compared by software to detect the errors, in visual verification, it is usually done by the person typing and they compare the typed version to the original source of the data. |
|
|
Term
|
Definition
| a form of validation found usually on barcodes or other automatic input methods. One of the numbers is calculated from the others using an algorithm when the barcode is produced. When the data is inputed using the barcode, the calculation is repeated and the check digit compared with the result of the calculation to check they are the same |
|
|
Term
|
Definition
| a unique identifier for one record in the table of data. Each record has just one primary key and each primary key applies just to one record. e.g. your school 4 or 5 digit number |
|
|
Term
|
Definition
| a primary key from a different table used to create a relationship between 2 tables. Eg in the class table for your lessons, it has its own primary key, but your school id will be in the table to link you to the class |
|
|
Term
|
Definition
| the test devised by Alan turing where a human tester talks (using text ) to 2 'people' in different rooms - one is a person the other is the supposedly intelligent computer. The conversation can be about anything. If the tester cannot tell which is human and which is the computer, then the computer must be intelligent |
|
|
Term
|
Definition
| malware that pretends to be something else in order to gain access to your system |
|
|
Term
|
Definition
| the technical experts that make networks in organisation run |
|
|
Term
|
Definition
| a feature of word processing software that allows a form letter/labels or other standard format to be combined with output from a database query in order to produce personalised mailings/labels/newsletters etc |
|
|
Term
|
Definition
| global positioning system - the use of satellites (somewhere between 24 and 32) to pinpoint the location of a gps device on the planet. Different accuracy for different applications - originally military |
|
|
Term
|
Definition
| Transmission Control Protocol/Internet Protocol. The protocols that control the chunking of data into packets and the passing of it over networks. It governs the use of IP addresses to define locations on a network |
|
|
Term
|
Definition
| hypertext transfer protocol - the protocol that controls the transfer of webpages |
|
|
Term
|
Definition
| a simple network device that sends messages out to nodes on a network - it does not manage traffic |
|
|
Term
|
Definition
| a network device (hardware) that directs traffic on a network to its destination |
|
|
Term
|
Definition
| a device that directs internet transmissions |
|
|
Term
|
Definition
| a router that is used to connect a home network to the internet |
|
|
Term
|
Definition
| a platform neutral object oriented programming language for use on multiplatform networks |
|
|
Term
|
Definition
| a platform neutral object oriented programming language for use on multiplatform networks |
|
|
Term
|
Definition
| universal serial bus - a data path standard that allows multiple peripheral devices to be chained together from a single port - much faster and more flexible than traditional serial or parallel ports |
|
|
