null
US
Entrar
Registre-se gratuitamente
Registre-se
Detectamos que o JavaScript não está habilitado no teu navegador. Habilite o Javascript para o funcionamento correto do nosso site. Por favor, leia os
Termos e Condições
para mais informações.
Próximo
Copiar e Editar
Você deve estar logado para concluir esta ação!
Inscreva-se gratuitamente
43476
Chapter 4
Descrição
ICT Mapa Mental sobre Chapter 4, criado por smita089 em 11-04-2013.
Sem etiquetas
ict
ict
Mapa Mental por
smita089
, atualizado more than 1 year ago
Mais
Menos
Criado por
smita089
aproximadamente 11 anos atrás
81
0
0
Resumo de 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.
Quer criar seus próprios
Mapas Mentais
gratuitos
com a GoConqr?
Saiba mais
.
Semelhante
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
Explore a Biblioteca