Model /Data model - A digital data representation of a real-life scenario; the scenario is broken down into individual attributes, which are represented as data items in the model., Simulator - A model that is interactive, changing the model in real-time. Simulators can be used to predict outcomes and are particularly useful in training and experiments., Data - Raw facts and figures., Spreadsheet - An application that uses rows and columns to organise data and carry out calculations using that data., What-if analysis - A way of investigating a scenario using a data model, where one or more pieces of data are adjusted to see how it affects other parts of the model., Database - An application that is used to organise data that can then be stored, processed and accessed electronically., Primary key field - A field in a database that is unique, Data-capture form - A predefined document (electronic or paper based) that contains headings and instructions to collect appropriate data for a specific purpose., Input mask - A special input or layout that controls how data is entered into a data-capture form, Validation / Data validation - An automatic check to reduce the chance of errors being made when data is entered into a computer system., Field length - The number of characters a field in a database application allows to be stored., Validation rule - A rule that specifies the characteristics of a valid data item in a database field., Which one is an example of a cell range? - C5:G10, Which is an equation to explain a simulator? - model + real-time interaction = simulator, Scalability - Determines its ability to handle increasing amounts of data or complexity, Type check - Ensures it is a certain data type, Length check - Ensures the data item has the correct number of characters, Presence check - Ensures the data item is not left empty, Format check - Ensures that data is a certain data type, Range check - Ensures that the date or number is within an upper/lower range limit,

Computing Grade 7 - Managing data

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?