PD

Google sheet for Slack rota

Module
Fundamentals
Skill
[Professional Basics]
Minutes
15

Learning Objectives

  • Apply the knowledge of how to set up a Google Sheet by creating one on the cohort drive
  • Post a question, idea or notes on Slack at least once a week

Preparation

One trainee must volunteer to create the Google Sheet.

Introduction

Knowing how Google Sheets work is essential as it enables efficient data organisation, analysis, and collaboration, enhancing productivity and enabling effective decision-making.

Effectively using Slack is also important since it will be part of your journey at CYF - and in your tech journey too. So let’s practice posting simple things.

Exercises

This is our Slack Rota spreadsheet (10 minutes)

Goal: Have 1 shared file in which trainees can organise the Slack rota

One trainee will set up a Google sheet on the cohort drive

  • The title of the spreadsheet should be XXX Rota (substitute XXXX for the region initials and cohort number, for example, GLA 6)
  • Save the file on the cohort drive
  • The name of the tab should be “Slack Rota”
  • The first tab must have at least the columns Date and Name
  • Add all the dates for the Fundamentals course months
  • Post a message on the cohort Slack with the shared spreadsheet and the instructions on what to do (see below)

Instructions

  • Go to the tab Slack rota and add your name against one date.
  • Be carefule not to overwrite if someone else is adding their name.
  • Once you have done so, add a “Done” emoji on this post. You should have the same number of emojis added as trainees in your cohort.
  • If you know people who haven’t added their names yet, tag them in this thread to remind them.
  • This file will be the rota of that person’s daily messages posted on Slack. You have more information about it in your Coursework.