Online Mind Mapping and Brainstorming

Create your own awesome maps

Online Mind Mapping and Brainstorming

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account? Log In

Digital Literacy - Spreadsheets by Mind Map: Digital Literacy - Spreadsheets
0.0 stars - reviews range from 0 to 5

Digital Literacy - Spreadsheets

Spreadsheets using Mario Karts: http://www.tes.co.uk/teaching-resource/Teaching-Spreadsheets-using-Mario-Kart-6165071/

Formulae

+, -, /, *

Absolute vs Relative references

Lesson ideas

Terminology

Rule, variable, label

Formula, function

Column, row

Cell, reference, range

Worksheet, spreadsheet

Absolute cell reference

Relative cell reference

Input, process, output

Lesson ideas

Functions

Sum, Average

Min, Max, Mode, Median

Count, CountIF, Countblank, CountA

Goalseek

IF, nested IF, Sumif,

Absolute vs Relative references

Data Validation

Dependant data validation

Naming ranges

Calculations on dates, NOW

Randbetween

Vlookup

Concatonate

IF AND, IF OR

Relational operators =,<, >, <>, <=, >=

Lesson ideas

Shortcuts

Fill Handle

AutoSum

Autofill, fill series

GoTo

Predicting outcomes

Goal seek

WhatIf

Examples in real world

Reliability

Comparable data

Test prediction

Calculate revenue, cost, VAT, profit, markup

Analysing results

Identifying a bias

Reasons for bias

Evaluating a spreadsheet

unreliable input = unreliable output

Using filters, autofilters

Pivot tables

Split Screen

Annotating using text boxes

Introduction

What is a spreadsheet?

Examples of how they are used in the 'real world'

What is a spreadsheet model?

What is a spreadsheet simulation?

What are the advantages of using spreadsheets?

What are the disadvantages of using spreadsheets?

Formatting

Sorting

Conditional Formatting

Adding comments

Transposing columns to rows

hide, show columns, rows

Adjust height, width of rows, columns

Cells

Layout for questionairre

Layout for Gantt Chart

Articles

Editing

Cut, copy

Paste, paste special

Find and replace

Insert, delete, columns, rows

Adding, deleting worksheets

Renaming worksheets

Publishing tools

Protecting cells

Freeze panes

Headers, footers

Macros

Linking data between spreadsheets, worksheets

Printing

Add hyperlinks

Form Controls

Audiences

Links to other software

Web Queries

Mail merge

CSV vs xslx

Datalogging

Web query vs datalogging

Embedding spreadsheet / graph into ppt, doc

Creating graphs

Types of graphs

Selecting data

Formatting

Analysing real world examples

Washington Post 2011 in 11 graphs (ask pupils to analyse before showing the sidebar commentary): http://www.washingtonpost.com/business/economy/2011-in-11-graphs/2011/12/22/gIQA0HWJMP_gallery.html#photo=1

Create charts online

2graph

Lesson ideas

Alternatives to Excel

Open Office

Adobe Acrobat Suite

Google Docs

How to make web based searchable google charts: http://www.poynter.org/how-tos/newsgathering-storytelling/126595/how-to-make-simple-web-based-google-charts/ Website - 50 Google charts tricks: http://www.collegeathome.com/blog/2008/06/05/50-cool-things-you-can-do-with-google-charts-api/

Pictograms

Lesson ideas

@simonhaughton

@chrisleach78

data resources

ictstarters.wikispaces.com

@MrAColley