null
US
Iniciar Sesión
Regístrate Gratis
Registro
Hemos detectado que no tienes habilitado Javascript en tu navegador. La naturaleza dinámica de nuestro sitio requiere que Javascript esté habilitado para un funcionamiento adecuado. Por favor lee nuestros
términos y condiciones
para más información.
Siguiente
Copiar y Editar
¡Debes iniciar sesión para completar esta acción!
Regístrate gratis
43476
Chapter 4
Descripción
ICT Mapa Mental sobre Chapter 4, creado por smita089 el 11/04/2013.
Sin etiquetas
ict
ict
Mapa Mental por
smita089
, actualizado hace más de 1 año
Más
Menos
Creado por
smita089
hace alrededor de 11 años
81
0
0
Resumen del Recurso
Chapter 4
Modelling
Model - an artificial re-creation of an object or event that should behave in the same way as the real thing.
Object Modelling - allows you to create a virtual representation of the item within the computer.
Mathematical Modelling - uses spreadsheets. Involves replication - the copying of a cell either horizontally or vertically.
Advantages
Less risky (safer and cheaper) to test.
Only one model needs to be created.
Can be backed up and shared.
Can be accelerated or slowed down.
Variables, Formulae, Rules and Functions
Variable – a changeable identifier associated with a particular cell.
Formula - the way that a calculation is represented in a spreadsheet.
Rules - a set of procedures that must be followed.
Function - represents a formula that is too complex or too long to expect an ordinary user to enter.
What if...? questions - an attempt to find out what is going to happen in the future.
Parts
Worksheet - large grid of cells on a single sheet.
Workbook - a collection of more than one worksheet in the same spreadsheet.
Row - a range of cells that goes across the spreadsheet. Column - a range of cells that go down the spreadsheet.
Cell - an individual data store identified by a column and row indicator, in that order for example A4 or AC154.
Labels - any text in a cell describing the data in a row or column(titles, headings that identify data).
Data - any values (text or numbers) that are entered for the use of calculation.
Formulas and functions - mathematical calculations carried out automatically.
Range - a group of cells. Reference range - top left cell reference: bottom right cell reference.
Cell Referencing
Relative referencing - the cell referenced in a spreadsheet formula changes when the formula is copied to other cells.
Absolute referencing - the referenced cell in a spreadsheet formula needs to remain exactly the same when the formula is copied to other cells.
Mostrar resumen completo
Ocultar resumen completo
¿Quieres crear tus propios
Mapas Mentales
gratis
con GoConqr?
Más información
.
Similar
Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
Output Devices
Jess Peason
Networks
Will8324
General ICT Quiz
leahshaw
ICT Revison Flash Cards
Arun Johal
FLAT FILE VS RELATIONAL DATABASE
rosiejones
Online World - Learning Aim A
andysedge
Business Aims and ICT Strategies
scrt
User Interfaces
Skeletor
General ICT Quiz
Jade Fantom
Explorar la Librería