Data structures
Learning objectives
- TR.102.SH.1 -Programs and file formats:
- TR.102.SH.2 - Cells:
- TR.102.SH.3 - Sheets:
- TR.102.SH.4 -Reading in data:
- TR.102.SH.5 - Data types:
- TR.102.SH.7.A - Formulas:
- TR.102.SH.7.B - Formulas - Operators :
- TR.102.SH.7.C - Formulas - Functions:
- TR.102.SH.7.D - Formulas - Implementation best practices:
- TR.102.SH.8.A - References to cells and sheets:
- TR.102.SH.8.B - References - Absolute:
- TR.102.SH.9.A - Arrays & named ranges:
- TR.102.SH.9.B - Arrays - As function arguments:
- TR.102.SH.7.E - Formulas - sumif() & averageif():
- TR.102.SH.7.F - Formulas - frequency():
- TR.102.SH.7.G - Formulas - vLookup():
- TR.102.SH.7.H - Formulas - if():
- TR.102.SH.10.A - Pivot tables - Data model:
- TR.102.SH.10.B - Pivot tables - Data preparation:
- TR.102.SH.10.C - Pivot tables - Analysis functions:
- TR.102.SH.10.D - Pivot tables - Extracting and visualizaing:
- TR.102.SH.9.A - Charts - Data series:
- TR.102.SH.9.B - Charts - Types and object classes:
- TR.102.SH.9.C - Charts - Dark art formatting:
- TR.102.SH.9.D - Charts - Optimizing designs:
- TR.102.SH.9.E - Charts - Exporting & sharing:
- TR.102.DS.2.A - Documentation - Data dictionaries: Write a data dictionary entry for each field in a table
- TR.102.DS.2.B - Documentation - Work processlogs:
- TR.102.DS.2.C - Documentation - Data users guides:
- TR.102.DS.2.D - Documentation - Data management plans:
- TR.102.SH.8.A - Practicalities - Protecting and encrypting:
- TR.102.SH.8.B - Practicalities - Exporting:
- TR.102.SH.8.C - Practicalities - Printing:
- TR.102.SH.8.D - Practicalities - Browser-based caveats & sharing:
prerequisites |
None! |
program specification |
This is a motorcycleExercise 1: "Might we be friends?" flowcharting activity paragraph This is a paragraph |
This is a link to nowhere |
Page created in 2019 by Eric Xander Darsow. Original content can be freely reproduced without any permission or attribution according to the site's content use agreement. Any content accessed by links to external sites or content with specific rights notices is governed by its respective use agreements.