Pilot – Session Register Which Tracks Demographics With Google Sheets

About Course

In this course you will learn to use Google Sheets to create a spending tracker for one grant.

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

Course Content

Pilot – Introduction
Learn how the DigiQuick pilot works

Introduction

01:08

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.

Pilot – Close and next steps
Thank you for being a part of this pilot. Learn how to give us some feedback and access your bonus lesson

Student Ratings & Reviews

5.0

Total 1 Rating

1 Rating

0 Rating

Emily

1 month ago

Use this in my projects. Made grant reporting my easier

Pilot – Session Register Which Tracks Demographics With Google Sheets

About Course

Course Content

Pilot – Introduction
Learn how the DigiQuick pilot works

Introduction

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

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

Pilot – Close and next steps
Thank you for being a part of this pilot. Learn how to give us some feedback and access your bonus lesson

Thank you and next steps

About Course

Course Content

Pilot – Introduction Learn how the DigiQuick pilot works

Introduction

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

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

Pilot – Close and next steps Thank you for being a part of this pilot. Learn how to give us some feedback and access your bonus lesson

Thank you and next steps

Student Ratings & Reviews

Pilot – Introduction
Learn how the DigiQuick pilot works

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.

Pilot – Close and next steps
Thank you for being a part of this pilot. Learn how to give us some feedback and access your bonus lesson