Topic B: Representing Data
Description
Laboratory Work
Number Systems
Positional Notation
Number System Bases:
decimal
binary
octal
hexadecimal
Binary Representations of Data
:
numeric
text
ASCII
audio
images & graphics
RGB demo
video
Simulators for some of these topics are available at
here
.
Chapter 1
data in a spreadsheet (Excel)
simple calculations in a spreadsheet
visual organisation and layout of spreadsheet data
Chapter 2
simple formulas
.
multiple worksheets
.
Chapter 3
IF function
LOOKUP function
An Example
Chapter 4
Logical functions
Information functions
Text functions
Dale & Lewis:
Chapter
2
,
3
Other Readings:
Dale & Lewis: Chapter
12
,
eg
,
14.1
Topic A
Topic B
Topic C
Topic D
Topic E