Start learning
Course Content
Section 1 – Introduction
Learn the basics of Google sheets and start making your session register
0/7
How to use DigiQuick
04:43
Introduction
06:54
Getting started with Spreadsheets 1
04:23
Getting started with Spreadsheets 2
14:45
Getting started with Spreadsheets activity
06:11
Layout
16:25
Data validation
09:39
Section 2 – Sessions attended and people worked with
Learn how to use the Counta formula to automatically count: - the total number of people you have worked with - the number of sessions each person has come to
0/4
Introduction
02:55
Counta formula introduction
07:45
Counta formula activity
05:37
Implementation
07:32
Section 3 – Genders and ethnicities
Learn how to use the Countif formula to automatically count how many people you have worked with of different genders and ethnicities.
0/5
Introduction
02:24
Countif formula introduction
12:21
Countif formula activity
05:22
Implementation – gender and ethnicities
06:51
Implementation – “aged above”
06:02
Section 4 – Age ranges
Learn how to use the Countifs formula to automatically count the number of people between ANY age range.
0/4
Introduction
02:53
Countifs formula introduction
07:45
Countifs formula activity
03:59
Implementation
08:16
Section 5 – Number of interventions
Learn how to use the Sum formula to automatically count the total number of interventions your project has had.
0/4
Introduction
01:48
Sum formula introduction
08:27
Sum formula activity
03:53
Implementation
02:40
Quiz
0/1
Session register quiz
Session Register Which Tracks Demographics With Google Sheets
Previous
Next
0% Complete