Digital Literacy - Spreadsheets

Kom i gang. Det er Gratis
eller tilmeld med din email adresse
Digital Literacy - Spreadsheets af Mind Map: Digital Literacy - Spreadsheets

1. Shortcuts

1.1. Fill Handle

1.2. AutoSum

1.3. Autofill, fill series

1.4. GoTo

2. Predicting outcomes

2.1. Goal seek

2.2. WhatIf

2.3. Examples in real world

2.4. Reliability

2.5. Comparable data

2.5.1. Additional external sources of data

2.6. Test prediction

2.6.1. Change rules

2.6.2. Change variables

2.6.3. Complex questions (lines of enquiry)

2.7. Calculate revenue, cost, VAT, profit, markup

3. Analysing results

3.1. Identifying a bias

3.2. Reasons for bias

3.3. Evaluating a spreadsheet

3.3.1. Efficient?

3.3.2. Ease of use?

3.3.3. Appropriate?

3.4. unreliable input = unreliable output

3.5. Using filters, autofilters

3.6. Pivot tables

3.6.1. lesson ideas

3.6.1.1. undertenminutes

3.6.1.1.1. Using for data analysis

3.7. Split Screen

3.8. Annotating using text boxes

4. Introduction

4.1. What is a spreadsheet?

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

4.3. What is a spreadsheet model?

4.4. What is a spreadsheet simulation?

4.5. What are the advantages of using spreadsheets?

4.6. What are the disadvantages of using spreadsheets?

5. Formatting

5.1. Sorting

5.1.1. Multiple columns

5.1.2. Single column

5.1.3. Ascending

5.1.4. Descending

5.1.5. Filters

5.1.5.1. Excel 2007

5.2. Conditional Formatting

5.2.1. Based on numbers

5.2.2. Based on text

5.2.3. Lesson ideas

5.2.3.1. @simonhaughton

5.2.3.1.1. Spreadsheet Quiz

5.3. Adding comments

5.4. Transposing columns to rows

5.5. hide, show columns, rows

5.6. Adjust height, width of rows, columns

5.7. Cells

5.7.1. Borders

5.7.2. Fill

5.7.3. Text

5.7.3.1. Font

5.7.3.2. Alignment

5.7.3.3. Text wrap

5.7.4. Numbers

5.7.4.1. Currency

5.7.4.2. Decimal places

5.7.4.3. Date

5.7.4.4. etc

5.7.5. Merge cells

5.8. Layout for questionairre

5.9. Layout for Gantt Chart

5.10. Articles

5.10.1. Designshack

5.10.1.1. How to make your spreadsheet less lame

6. Links to other software

6.1. Web Queries

6.1.1. Auto refresh

6.1.2. Real world examples

6.2. Mail merge

6.3. CSV vs xslx

6.4. Datalogging

6.4.1. Analogue vs digital sensors

6.4.2. Data from sensors

6.4.2.1. Reliability of data?

6.5. Web query vs datalogging

6.5.1. Reliability of data?

6.5.2. What data to select?

6.6. Embedding spreadsheet / graph into ppt, doc

7. Alternatives to Excel

7.1. Open Office

7.2. Adobe Acrobat Suite

7.3. Google Docs

7.3.1. Google Forms

7.4. Pictograms

8. Formulae

8.1. +, -, /, *

8.2. Absolute vs Relative references

8.2.1. lesson ideas

8.2.1.1. undertenminutes

8.3. Lesson ideas

8.3.1. @simonhaughton

8.3.1.1. spreadsheet quiz

8.3.2. @chrisleach78

8.3.2.1. 12 Days of Christmaths

9. Terminology

9.1. Rule, variable, label

9.2. Formula, function

9.3. Column, row

9.4. Cell, reference, range

9.5. Worksheet, spreadsheet

9.6. Absolute cell reference

9.7. Relative cell reference

9.8. Input, process, output

9.9. Lesson ideas

9.9.1. NGfL

9.9.1.1. Intro to terminology

10. Functions

10.1. Sum, Average

10.2. Min, Max, Mode, Median

10.3. Count, CountIF, Countblank, CountA

10.4. Goalseek

10.5. IF, nested IF, Sumif,

10.6. Absolute vs Relative references

10.7. Data Validation

10.7.1. Lesson ideas

10.7.1.1. NGfL

10.7.1.1.1. Creating drop down lists

10.8. Dependant data validation

10.9. Naming ranges

10.10. Calculations on dates, NOW

10.11. Randbetween

10.12. Vlookup

10.13. Concatonate

10.14. IF AND, IF OR

10.15. Relational operators =,<, >, <>, <=, >=

10.16. Lesson ideas

10.16.1. NGfL

10.16.1.1. Understanding Functions

11. Editing

11.1. Cut, copy

11.2. Paste, paste special

11.3. Find and replace

11.4. Insert, delete, columns, rows

11.5. Adding, deleting worksheets

11.6. Renaming worksheets

12. Publishing tools

12.1. Protecting cells

12.2. Freeze panes

12.3. Headers, footers

12.4. Macros

12.4.1. Assigning, editing buttons

12.5. Linking data between spreadsheets, worksheets

12.6. Printing

12.6.1. Pages

12.6.2. Gridlines

12.6.3. Orientation

12.6.4. Set print area

12.6.5. Adjust margins

12.6.6. Page break view, adjust

12.6.7. Repeat headings

12.7. Add hyperlinks

12.8. Form Controls

12.9. Audiences

12.9.1. Graphs vs Tables

13. Creating graphs

13.1. Types of graphs

13.1.1. Line

13.1.2. Bar

13.1.3. Pie

13.2. Selecting data

13.2.1. Adjacent cells

13.2.2. Non-adjacent cells

13.3. Formatting

13.3.1. Titles

13.3.2. Axis

13.3.3. Scale

13.3.4. Series

13.3.5. Legend

13.3.6. Text alignment

13.4. Analysing real world examples

13.5. Create charts online

13.5.1. Chartle

13.6. 2graph

13.6.1. Lesson ideas

13.6.1.1. @simonhaughton

13.6.1.1.1. Graph / analyse TV ratings

13.7. Lesson ideas

13.7.1. NGfL Cymru

13.7.1.1. Interactive finding answers from graphs

14. Lesson ideas

14.1. @simonhaughton

14.1.1. Intro to Spreadsheets

14.1.2. Theme Park Project

14.2. @chrisleach78

14.2.1. Toyshop spreadsheet

14.2.2. Wizard's Apprentice

14.2.3. 6 Nations Dream Team

14.3. data resources

14.3.1. calories

14.4. ictstarters.wikispaces.com

14.4.1. Who wants to be a millionaire?

14.5. @MrAColley

14.5.1. Spreadsheet Quiz Scheme (7 Lessons)