null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
43476
Chapter 4
Description
ICT Mind Map on Chapter 4, created by smita089 on 11/04/2013.
No tags specified
ict
ict
Mind Map by
smita089
, updated more than 1 year ago
More
Less
Created by
smita089
about 11 years ago
81
0
0
Resource summary
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.
Show full summary
Hide full summary
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
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
Browse Library