# Modelling Data

## 1 Familiarisation with spreadsheets (Microsoft Excel)

Video from my first lesson in my Modelling Data Series (an alternative to NCCE's 'Year 7 Modelling data using spreadsheets' unit).

## 2 - Arithmetic Formulas in spreadsheets

Video from my second lesson in my Modelling Data Series (an alternative to NCCE's 'Year 7 Modelling data using spreadsheets' unit).

## 3a - What is the difference between data and information?

Video from my third lesson in my Modelling Data Series (an alternative to NCCE's 'Year 7 Modelling data using spreadsheets' unit).

## 3b - How to make a chart in Microsoft Excel

Video from my third lesson in my Modelling Data Series (an alternative to NCCE's 'Year 7 Modelling data using spreadsheets' unit).

## 3c - How to make a chart in Google Sheets

Video from my third lesson in my Modelling Data Series (an alternative to NCCE's 'Year 7 Modelling data using spreadsheets' unit).

## 3d - Using the Control Key to select specific data for a chart

## 4 - SUM MIN MAX COUNTA spreadsheet functions

Video from my fourth lesson in my Modelling Data Series (an alternative to NCCE's 'Year 7 Modelling data using spreadsheets' unit).

## 5a - Average spreadsheet function

Video from my fifth lesson in my Modelling Data Series (an alternative to NCCE's 'Year 7 Modelling data using spreadsheets' unit).

## 5b - IF Statements in spreadsheets

Video from my fifth lesson in my Modelling Data Series (an alternative to NCCE's 'Year 7 Modelling data using spreadsheets' unit).

## 5c - COUNTIF spreadsheet function

Video from my fifth lesson in my Modelling Data Series (an alternative to NCCE's 'Year 7 Modelling data using spreadsheets' unit).

## 5d - Sorting a Microsoft Excel spreadsheet

## 5e - Sorting a Google Sheets spreadsheet

## 5f - Filtering a Google Sheets spreadsheet

## 6a - Conditional Formatting in a Microsoft Excel spreadsheet

Video from my sixth lesson in my Modelling Data Series (an alternative to NCCE's 'Year 7 Modelling data using spreadsheets' unit).

## 6b - Conditional Formatting in a Google Sheets spreadsheet

Video from my sixth lesson in my Modelling Data Series (an alternative to NCCE's 'Year 7 Modelling data using spreadsheets' unit).