Skip to content

Google Sheets

app · in 24 sources (2017–2020)

Sources by year: 2017: 1 · 2018: 10 · 2019: 6 · 2020: 7

Threads

Also named in the threads: Ali says he is going to work on his own Skillshare classes, taking a deep dive into how he makes his videos: filming, editing and post-production. · Ali jokes that he is on a quest to become a Gymshark athlete (2019)

Often together

What comes up in the same parts of the videos; the number is how many parts.

active recall (16) · spaced repetition (13) · Quizlet (5) · Anki (7) · Microsoft PowerPoint (2) · Singapore (2) · Wikipedia (2) · Notion (5) · Skillshare classes (2) · MacBook (3)

What the videos say

The most important statements of each year; all statements.

2020

  • 2020-03-13 · The KEY Study Techniques for Exam Success — recommendation: Ali's near-identical method was his retrospective revision timetable: instead of projecting a subject a day, a week and a month forward, he marked in a Google Sheet the date he did each topic. — 00:38:16
  • 2020-04-11 · My New Favourite Laptop - MacBook Air 2020 Review — Ali: By basic things Ali means browsing the web, watching Netflix, typing Word documents, making PowerPoint presentations, crunching numbers in Excel or Google Sheets, email and the occasional Zoom call. — 00:00:56
  • 2020-05-29 · How I Ranked 1st at Cambridge University - My Secret — announcement: Ali: Section three of Ali's Anki class answers questions hundreds of people sent via his Instagram story: how long a flashcard should be, avoiding overload, staying motivated, what to put on a card, and Anki versus Notion, Google Sheets or Quizlet. — 00:01:27
  • 2020-06-03 · All the Apps I Use in a Day — Ali tracks his home workouts in Google Sheets; he used to track them in Notion but switched because his online personal trainer uses Google Sheets. — 00:04:52
  • 2020-12-20 · 20 Lessons that Improved My Life — Ali: In the first lockdown of March 2020, dreaming of becoming a Gymshark athlete, Ali started home workouts that soon lapsed, until Yusuf of the Propane Fitness podcast became his online trainer: a workout plan in a Google Sheet, macros tracked in MyFitnessPal, a screenshot sent every week. — 00:08:26
  • …and 1 statement more in 2020 — all statements of 2020

Also named in: My Favourite Note-Taking App for Students - Notion

2019

  • 2019-01-20 · My Favourite iPad Pro Apps — recommendation: Ali uses Google Sheets as a flashcard alternative when he does not want the rigmarole of making a card in Quizlet or Anki: he writes himself questions down the side of a sheet. — 00:02:49
  • 2019-01-31 · How to Study for Exams with Google Sheets — Ali explains how he uses Google Sheets as an alternative to flashcards for efficient studying. — 00:00:00
    • In Ali's Google Sheets method questions go in column A and answers in column B; once written, the answers are turned white, so looking through the sheet he cannot see them and each question makes him actively recall the answer. — 00:01:57
    • Ali's first reason for using Google Sheets instead of flashcards: a spreadsheet gives a systematic structure for reviewing your material. — 00:04:13
    • Ali's second reason: his Google sheet shows at a glance where the holes in his knowledge are, while with Anki or Quizlet he must trust the spaced repetition algorithm and often goes through 100 cards to find the 20 he struggles with. — 00:05:12
    • Google Sheets make studying low-commitment for Ali: even with five or ten minutes he opens the sheet, finds the red questions, tries to recall them and looks up what he does not remember on Google, Wikipedia or in a textbook. — 00:07:22
    • Ali has no strict line between flashcards and Google Sheets, but prefers flashcards for distinct, isolated facts, such as a drug dose, and Google Sheets for more general concepts, with a lot of overlap. — 00:10:34
  • 2019-02-14 · Valentine’s Day Live Stream — recommendation: Ali: For A-level revision Ali says Google Sheets is not even needed: use CGP revision guides and past papers and memorise the mark schemes to get good marks. — 00:07:17
    • After the stream Ali is going to film a video on how he uses Google Sheets for his retrospective revision timetable. — 00:45:15
  • 2019-02-24 · How to study for exams - The Retrospective Revision Timetable — Ali's retrospective revision timetable in Google Sheets: the list of a subject's topics down column A and, along each topic's row, the dates he revised it, ideally colour-coded by how well he knew it before looking at the book. — 00:11:09
  • 2019-05-18 · The Best Productivity Apps for Students — Ali: As a student Ali managed his time with his retrospective revision timetable in Google Sheets: after active recalling a topic he wrote down the date, sometimes colour-coding it by how good he was at it. — 00:08:01
  • 2019-08-16 · Money, Relationships and Hair Loss - Answering your Assumptions — Ali: At medical school Ali started a shared Google Drive of essay plans and a Google Sheet of past papers on which he and about 16 college friends crowdsourced mark schemes. — 00:20:55
  • …and 11 statements more in 2019 — all statements of 2019

2018

  • 2018-04-09 · How to Study for Exams - Spaced Repetition · Evidence-based revision tips — recommendation: Ali advises keeping the revision spreadsheet in Google Sheets rather than Excel: it loads easily and its phone app lets you update it anywhere, on the bus or in the library. — 00:11:35
    • Ali colour-codes each date box by how well he recalled the topic: green if he knew it very well, yellow if he knew about 50%, red if he did not know it at all. — 00:14:55
  • 2018-04-14 · Last Minute Study Tips, Flashcards, Essays & Maths - Exam Revision Q&A with Cambridge students — recommendation: Ali prefers his spreadsheet method to Anki for much of his revision because spreadsheets are easy and Anki takes effort to set up: anything that reduces friction between wanting to do something and doing it is worth doing. — 00:14:45
    • Ali can rarely be bothered to use Anki properly, skipping features such as cloze deletions and image occlusion, and keeps it simple with Google Sheets. — 00:15:43
    • Paul says active recall needs neither Anki nor Google Sheets: it is a way of life, trying to think about things every time before you look up the answer. — 00:17:02
  • 2018-04-24 · Study with Me + Revision tips from friends - Cambridge University medical student VLOG #32 — recommendation: Ali builds his active recall spreadsheet in Google Sheets with friends: for each neurology topic the group brainstorms questions an examiner could ask, writes them in column A and works out the answers for column B. — 00:04:28
  • 2018-06-12 · Live Stream - Tuesday Evening Hangout — recommendation: Ali: A trick for getting through university, and medical school especially, is working together with other people in your university and college, Ali says, which Google Docs and Google Sheets really help with. — 00:27:38
  • 2018-10-10 · iPad vs Macbook for Students - Can a tablet replace your laptop? — Ali uses Google Sheets for many things, including his active recall spreadsheets and spaced repetition. — 00:07:07
  • 2018-11-23 · Study with Me - Resuscitation Training · Life as a Junior Doctor — Ali: While working through the Advanced Life Support modules, Ali adds a sheet to his 2018–19 active recall spreadsheet with questions on what he did not know: a flashcard alternative he finds works better than flashcards for some material. — 00:01:27
    • In Ali's active recall spreadsheet each question has its answer in the next column; when testing himself he turns the answer font white, then colours the questions he struggled with yellow, orange or red by how bad his recall was. — 00:01:27
    • Ali is working on a video explaining his active recall spreadsheet in more detail. — 00:01:27
  • 2018-11-29 · Study with Me + Active Recall tips · Life as a Junior Doctor — Ali: Answering students' worries about what counts as active recall, Ali says it just means testing yourself, however you do it: flashcards, Anki, Quizlet, Google Sheets or questions written by hand. — 00:05:24
  • …and 10 statements more in 2018 — all statements of 2018

2017