Spreadsheet Techniques

SHEETS (Spreadsheet Commands, Functions and Calculations)

Watch each of the following videos.  Practice the commands and functions using the accompanying spreadsheet files as well as files you have created on your own.  Provide links in your checklist to each file that demonstrates competence of the task.

(1) Quickwrites

• Quickwrites - Collaborative Spreadsheets [6:44]

  • Task: 616 Quickwrite

(2) Manipulating text

• Split, Concatenate, Transpose, [4:49]

  •  Task:  names of scientists

(3) Importing data from other spreadsheets

• ImportRange command to link spreadsheets [7:27]

  • Task: two-way linking between instructor's master sheet and each student sheet. 

(4) Sorting Data

• Sorting on a calculated column [3:37] 

  •  Task: forest area

(5) Tabulating Data

• Count, CountA, CountIF, CountIFS, CountBlank [8:10]

  •  Task: birds of southern California

(6) Data Validation

• Data Validation [4:46] 

  •  Task: ecological succession following fire 

(7) Filtering data

• Filter [9:43]

  •  Task: earthquakes and volcanoes

(8) Referencing quantities

• Absolute and Relative References [2:31]

  •  Task:  forest distribution

(9) Translating languages

• Translate [3:49]

  •  Task: science terms - cognates

(10) Performing calculations on remote data 

• Performing operations on data in a remote spreadsheet [6:15]

  •  Task: practice file

(11) Formatting Spreadsheets

• Formatting spreadsheets [24:28]

•  Task:  properties of the elements - try to replicate all features shown in video.

(12) Protecting Data

• Protecting data [5:54]

• Task: nutrition analysis - protect rows, columns, blocks, sheets