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.
Split, Concatenate, Transpose, [4:49]
Task: names of scientists
ImportRange command to link spreadsheets [7:27]
Task: two-way linking between instructor's master sheet and each student sheet.
Sorting on a calculated column [3:37]
Task: forest area
Data Validation [4:46]
Filter [9:43]
Absolute and Relative References [2:31]
Task: forest distribution
Translate [3:49]
Task: science terms - cognates
Formatting spreadsheets [24:28]
Task: properties of the elements - try to replicate all features shown in video.
Protecting data [5:54]
Task: nutrition analysis - protect rows, columns, blocks, sheets