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
About Lesson

Learn how DigiQuick can fit your schedule and some useful tips to make the most from your DigiQuick training.

Previous
Next
0% Complete