Session Register Which Tracks Demographics With Google Sheets

About Course

In this course you will learn to use Google Sheets to create a session register which tracks demographics and attendance.

This course is perfect for people who have never used spreadsheets before and will help make grant reporting a breeze.

The total time for this course is 2 hours 39 minutes.

Skills you will learn in this course:

Accessing Google sheets
Key terminology in spreadsheets
What to do if you make a mistake in a spreadsheet
Basic spreadsheet skills
Data validation
The Counta formula
The Countif formula
The Countifs formula
The Sum formula
Your feedback is invaluable to DigiQuick! Share your thoughts with the feedback form on the lesson homepage, or leave us a 5-star review if you enjoyed the course.

Course Content

Section 1 – Introduction
Learn the basics of Google sheets and start making your session register

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

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.

Section 4 – Age ranges
Learn how to use the Countifs formula to automatically count the number of people between ANY age range.

Section 5 – Number of interventions
Learn how to use the Sum formula to automatically count the total number of interventions your project has had.

Quiz

Student Ratings & Reviews

5.0

Total 2 Ratings

2 Ratings

0 Rating

Portland Jones

1 week ago

it was good. I hadn't used google sheets before and now feel confident in using them.

Emily

6 months ago

Use this in my projects. Made grant reporting my easier

Session Register Which Tracks Demographics With Google Sheets

About Course

Course Content

Section 1 – Introduction
Learn the basics of Google sheets and start making your session register

How to use DigiQuick

Introduction

Getting started with Spreadsheets 1

Getting started with Spreadsheets 2

Getting started with Spreadsheets activity

Layout

Data validation

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

Introduction

Counta formula introduction

Counta formula activity

Implementation

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.

Introduction

Countif formula introduction

Countif formula activity

Implementation – gender and ethnicities

Implementation – “aged above”

Section 4 – Age ranges
Learn how to use the Countifs formula to automatically count the number of people between ANY age range.

Introduction

Countifs formula introduction

Countifs formula activity

Implementation

Section 5 – Number of interventions
Learn how to use the Sum formula to automatically count the total number of interventions your project has had.

Introduction

Sum formula introduction

Sum formula activity

Implementation

Quiz

Session register quiz

About Course

Course Content

Section 1 – Introduction Learn the basics of Google sheets and start making your session register

How to use DigiQuick

Introduction

Getting started with Spreadsheets 1

Getting started with Spreadsheets 2

Getting started with Spreadsheets activity

Layout

Data validation

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

Introduction

Counta formula introduction

Counta formula activity

Implementation

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.

Introduction

Countif formula introduction

Countif formula activity

Implementation – gender and ethnicities

Implementation – “aged above”

Section 4 – Age ranges Learn how to use the Countifs formula to automatically count the number of people between ANY age range.

Introduction

Countifs formula introduction

Countifs formula activity

Implementation

Section 5 – Number of interventions Learn how to use the Sum formula to automatically count the total number of interventions your project has had.

Introduction

Sum formula introduction

Sum formula activity

Implementation

Quiz

Session register quiz

Student Ratings & Reviews

Section 1 – Introduction
Learn the basics of Google sheets and start making your session register

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

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.

Section 4 – Age ranges
Learn how to use the Countifs formula to automatically count the number of people between ANY age range.

Section 5 – Number of interventions
Learn how to use the Sum formula to automatically count the total number of interventions your project has had.