Create your own awesome maps

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, undertenminutes

Lesson ideas

@simonhaughton, spreadsheet quiz

@chrisleach78, 12 Days of Christmaths

Terminology

Rule, variable, label

Formula, function

Column, row

Cell, reference, range

Worksheet, spreadsheet

Absolute cell reference

Relative cell reference

Input, process, output

Lesson ideas

NGfL, Intro to terminology

Functions

Sum, Average

Min, Max, Mode, Median

Count, CountIF, Countblank, CountA

Goalseek

IF, nested IF, Sumif,

Absolute vs Relative references

Data Validation

Lesson ideas, NGfL, Creating drop down lists

Dependant data validation

Naming ranges

Calculations on dates, NOW

Randbetween

Vlookup

Concatonate

IF AND, IF OR

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

Lesson ideas

NGfL, Understanding Functions

Shortcuts

Fill Handle

AutoSum

Autofill, fill series

GoTo

Predicting outcomes

Goal seek

WhatIf

Examples in real world

Reliability

Comparable data

Additional external sources of data

Test prediction

Change rules

Change variables

Complex questions (lines of enquiry)

Calculate revenue, cost, VAT, profit, markup

Analysing results

Identifying a bias

Reasons for bias

Evaluating a spreadsheet

Efficient?

Ease of use?

Appropriate?

unreliable input = unreliable output

Using filters, autofilters

Pivot tables

lesson ideas, undertenminutes, Using for data analysis

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

Multiple columns

Single column

Ascending

Descending

Filters, Excel 2007

Conditional Formatting

Based on numbers

Based on text

Lesson ideas, @simonhaughton, Spreadsheet Quiz

Adding comments

Transposing columns to rows

hide, show columns, rows

Adjust height, width of rows, columns

Cells

Borders

Fill

Text, Font, Alignment, Text wrap

Numbers, Currency, Decimal places, Date, etc

Merge cells

Layout for questionairre

Layout for Gantt Chart

Articles

Designshack, How to make your spreadsheet less lame

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

Assigning, editing buttons

Linking data between spreadsheets, worksheets

Printing

Pages

Gridlines

Orientation

Set print area

Adjust margins

Page break view, adjust

Repeat headings

Add hyperlinks

Form Controls

Audiences

Graphs vs Tables

Links to other software

Web Queries

Auto refresh

Real world examples

Mail merge

CSV vs xslx

Datalogging

Analogue vs digital sensors

Data from sensors, Reliability of data?

Web query vs datalogging

Reliability of data?

What data to select?

Embedding spreadsheet / graph into ppt, doc

Creating graphs

Types of graphs

Line

Bar

Pie

Selecting data

Adjacent cells

Non-adjacent cells

Formatting

Titles

Axis

Scale

Series

Legend

Text alignment

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

Chartle

2graph

Lesson ideas, @simonhaughton, Graph / analyse TV ratings

Lesson ideas

NGfL Cymru, Interactive finding answers from graphs

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/

Google Forms

Pictograms

Lesson ideas

@simonhaughton

Intro to Spreadsheets

Theme Park Project

@chrisleach78

Toyshop spreadsheet

Wizard's Apprentice

6 Nations Dream Team

data resources

calories

ictstarters.wikispaces.com

Who wants to be a millionaire?

@MrAColley

Spreadsheet Quiz Scheme (7 Lessons)