An Introduction to Spreadsheets Using Number Magic

1
An Introduction to SpreadsheetsUsing Number Magic
Malcolm Wilson ICT Curriculum Support Teacher
(Primary) Falkirk Council
2
An Introduction to SpreadsheetsUsing Number Magic

• What is a spreadsheet?
• Uses of a spreadsheet.
• What is Number Magic?

3
What Is a Spreadsheet?

• Spreadsheets help with a series of calculations
  that need to be repeated often.
• Once they are set up they can be used to explore
  the effect of changing one number on the others.
  
• The data can also be displayed very easily as a
  graph or chart.

4
Uses of a Spreadsheet

• Take rainfall measurements everyday for a week.
  Set up a spreadsheet to find the total weekly
  rainfall.
• A spreadsheet could be set up with the exchange
  rate of a foreign currency and the pound. The
  costs of items could be found.
• A litter survey could be underway for a month.
  The results could be entered daily into a
  spreadsheet. These could be displayed and a
  graph produced of findings.

5
Number Magic

• Use for recording, analysing and presenting
  numerical data.
• Use the Topic bank to include words and pictures
  in work.
• Formula Builder to make automatic calculations
  simpler.
• Data can be analysed and rearranged using simple
  sorting.
• Can use a wide range of different graphs to
  present numerical information.
• Operates on 4 levels of increasing complexity.
• Detector enables to monitor and record sensory
  data, such as light levels or temperature.

6
Toolbar Details
Menu
Formula Bar
Toolbar
7
Moving Around the Spreadsheet
Column Letters
Cells
Row Numbers
Active Cell (Cell Address is D6)
8
Working With Cells

• Selecting
• Single cells click on the cell, a pointer arrow
  will appear. Use arrow keys to move active box
  around the sheet.
• Multiple cells hold and drag down to cover the
  desired cells.

9
Entering Data

• Useful Terms
• Value numbers you want to use in the
  calculation.
• Labels title of spreadsheet, headings for rows
  or columns. 
• Formula the sums entered into a spreadsheet.
• It is very important to label the information you
• are inputting, particularly the results of a
• formula, as it is easy to forget what the values
• mean.
• Click on the cell where you want the data to
  appear. Start typing the values or information.

10
Working With Cells 2

• Copying contents of a cell
• Click Edit. Select Copy.
• Select cell. Click Copy icon.

11
Working With Cells 3

• Pasting contents of a cell
• Select destination cell for contents. Click
  Paste icon.
• OR
• Click Edit. Select Paste.
• Moving Cells
• Select cells to be moved.
• Move pointer to edge of selection, cross will
  change to an arrow.
• Click, hold drag the selection to anywhere on
  the grid.

12
Working With Cells 4

• Deleting cells
• Highlight cell or cells to be deleted.
• Click Edit.
• Select Delete.
• Choose one of the options by clicking on the
  words.
• Click OK.
• Deleting and Replacing Cell Content
• Click on cell containing contents to be deleted.
• Press Delete key.
• To replace contents, click on cell containing
• contents to be replaced, type in new entry.
•  

13
 Working With Cells 5

• Sorting cells
• Columns or rows can be sorted into
• ascending or descending order, numerically or
• alphabetically.
• Highlight column or rows to be sorted.
• Click Grid.
• Select Sort.
• The Sorting window will appear.

14
Working With Cells 6

• Click either Columns or Rows.
• Click on the drop down arrow to select the column
  or row selected, if a block of cells has been
  selected.
• Click on the Ascending or Descending icon.
• Click OK.

15
Formula Number Function Command

• Yellow and Green Levels only
• The Number Function command performs
• Column Total and Column Average.
• Highlight the column of cells (must be more than
  one row).
• Click Grid.
• Select Number Function.
• Select Column Total or Column Average.
• The Total or Average will be placed in the cell
  beneath the column selected.

16
Starting a Formula

• Green Blue Red Levels
• A formula always begins with the equal to sign
  .
• Enter the value of the first part of your
  formula.
• Enter an operator.
• Enter the value of the second part of your
  formula.

17
The Formula Bar
Click to gain access to Formula Builder
Accept Click to accept formula. This is the same
as pressing the Enter key.
Reject Click to cancel any changes made to cell
contents.
Displays contents of cell
18
Using The Formula Bar

• Click the cell where you want the formula result
  to be.
• Type sign
• Type cell address, then operator, then cell
  address to make up formula. E.g. (D10D9)
• Press Enter.

19
Using The Formula Bar 2

• Click the cell where you want the formula result
  to be.
• Type sign
• Click on the cell to include in your formula.
  The cell address will automatically appear into
  the formula.
• Type the operator, then click on the next cell to
  include in your formula, it will appear in the
  formula.
• Press Enter.

20
Number Function

• Click the cell where you want the formula result
  to be.
• Click on Grid. Select Number Function.
• Click on a number function. Select the function
  you want.
• Click on the cells or type the details of the
  cells to include in the formula.
• Click OK.

21
Formula Builder

• Click on a cell where you want to enter your
  formula.
• Click Activities.
• Click Formula Builder.
• On the Formula Builder keyboard, click on the
  value of the cell you want to include in the
  formula, click on the operator, click on the
  value of the next cell to include in the formula.
  The Formula Builder converts this automatically
  into a formula.
• Click Enter.
• More than 2 cells can be included in the formula.
• E.g. if a pupil wanted to multiply cell H3, value
  being 3, with H9, value being 6, they would key
  3, multiplication sign, 9.

22
Report Sheet

• Inserting a Report Sheet
• Click File.
• Click File Information. Type relevant
  information in File Box Window.
• Click Grid.
• Click Insert Report Sheet.
• Teacher enters information in the Questions box.
• Child can fill in Conclusions box.
• Click Worksheet tab to return to the Grid.

23
Graphs - Inserting

• Highlight the cells that contain the information
  to be graphed.
• Click Graph.
• Select Insert New Graph
• OR
• Select Graph icon.

24
Graphs - Viewing
Click the appropriate icon
Grid Graph
Grid Only
Graph Only
Or
Select View, then your choice.
25
Graphs Deleting Copying

• Copying
• Select Edit. Select Copy Graph.
• Deleting
• Select Graph. Select Delete Graph.
• Select Yes.

26
Graphs - Formatting

• Select Graph. Select Format Graph.
• Gallery changes type of graph.
• Click the icon to make the changes you want.
• Layout adds labels to your graph.
• Select options and enter information.
• Axis use to label the axes of your graph.
• Click on the box and enter details.
• Colour change the display information colours.
• Click on area of graph to change colour.
• Click the new colour from the colour palette.

27
Inserting Columns or Rows

• Click a cell.
• Click Edit.
• Move down to Insert. Follow arrow. Select Row
  or Column.

28
Formatting Data - Numbers

• Highlight the cell or cells to format.
• Click Grid.
• Move pointer down to Format.
• Follow arrow. Select Numbers.
• Select the number format you need.
• Select OK.

29
Formatting Data - Alignment

• Highlight the cell or cells to format.
• Click Grid.
• Click Alignment.
• Click OK.

30
Formatting Data - Font

• Click Grid.
• Click Font.
• Click OK.

31
Formatting Data Border

• Blue and Red Levels only
• Highlight the created grid.
• Click Grid.
• Select Border.
• Select the Border Style you want. Select OK.

32
Formatting Data - Background

• Blue and Red Levels only
• Highlight created grid.
• Click Grid.
• Select Background.
• Select the colour you want. Select OK.

33
Using the Topic Bank

• Click View.
• Select Topic Bank.
• OR
• Select Topic Bank icon.

34
Using the Topic Bank

• Use the Index or Arrow keys to reveal the
  subjects.
• Choose a subject.
• Select the picture.
• Click and drag picture or word from Topic Bank to
  active cell.

35
Number Patterns

• Blue and Red Levels only
• Click Activities.
• Click Number Patterns.
• Click in the white boxes to enter values.
• Click Create Grid button.

36
Grid Format

• Blue and Red Levels only
• Select Grid.
• Move pointer down to Format.
• Select Protection.

37
Adding Number Functions

• Blue and Red Levels only
• Click Grid.
• Select Number Function.
• Choose the function you want from the list.