Skip to content

Instantly share code, notes, and snippets.

@equivalentideas

equivalentideas/2018-02-05_working_with_spreadsheets_outline.md

Created February 7, 2018 08:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save equivalentideas/3cdd14d2ca0a6f7853f4b1c6a226eac8 to your computer and use it in GitHub Desktop.
Save equivalentideas/3cdd14d2ca0a6f7853f4b1c6a226eac8 to your computer and use it in GitHub Desktop.
Download ZIP
Outline for Working with spreadsheets, Free Class at Frontyard Projects
Raw
2018-02-05_working_with_spreadsheets_outline.md

2018-02-05 Working with spreadsheets, Free Class at Frontyard Projects

Session Outline

  • What is data?

    • Things and their attributes
    • How do spreadsheets present data? Rows and columns, things and attributes
    • Example, plants? Coconut tree, fig tree, parsley, strawberry, silver beat
    • Why use a spreadsheet to work with this data? Graphic and usable way to build and organise data
    • Quick and powerful analysis tool

  • Building spreadsheet data

    • Let's open a Google Spreadsheets
    • Attendees come up with their own examples and make a spreadsheet

  • Basic tools

    • Provide a spreadsheet for people to use
    • Formatting, what can you do, what's recommended?
    • Sorting
    • Data types, what are they about?
    • Text to columns to remove formatting and use the correct data type: remove the "$" in "$10,123.70"
    • Filtering

  • Pivot tables

    • Questioning data
      • What is the total X?
      • How does A compare to B?
    • Building a pivot table

  • Simple data formats

    • csv
    • json

Tools

Basic spreadsheet tools:

Specialist tools:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment