All statements about Google Sheets

52 statements about Google Sheets in 23 sources, by upload date.

Back to Google Sheets.

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-08-23 · The Perfect Note-Taking App — recommendation: Ali: Asked whether to write active recall questions in Google Sheets or Notion, Ali says either works, and he prefers Notion. — creator comment
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

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-20 · My Favourite iPad Pro Apps — Ali: In Ali's 2018 spreadsheet the questions are colour-coded by whether he got them right last time, with the answers in white text in column B. — 00:03:18
2019-01-20 · My Favourite iPad Pro Apps — announcement: Ali says he will make a much more detailed video on exactly how he uses Google Sheets, hopefully in the next couple of weeks. (hedged) — 00:03:18
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
2019-01-31 · How to Study for Exams with Google Sheets — Ali shows the Google sheet he used a few months earlier to revise for his final-year medical school exams at Cambridge, with one sheet per subject. — 00:01:27
2019-01-31 · How to Study for Exams with Google Sheets — Ali: 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
2019-01-31 · How to Study for Exams with Google Sheets — Ali colour-codes the questions in his Google sheet by how well he knew the answer: green when he is pretty sure he knows it, yellow when he only half knew it. — 00:03:05
2019-01-31 · How to Study for Exams with Google Sheets — Ali: Towards his exams Ali hid the spreadsheet columns he no longer needed to go through, such as those full of green questions. — 00:03:35
2019-01-31 · How to Study for Exams with Google Sheets — Ali's first reason for using Google Sheets instead of flashcards: a spreadsheet gives a systematic structure for reviewing your material. — 00:04:13
2019-01-31 · How to Study for Exams with Google Sheets — 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
2019-01-31 · How to Study for Exams with Google Sheets — recommendation: Ali starts with the questions he marked red in his Google sheet, those he could not answer the last time he tested himself. — 00:05:12
2019-01-31 · How to Study for Exams with Google Sheets — Ali's third reason: Google Sheets make it slightly easier to study with friends; preparing for medical school exams, they put his sheet on his big monitor and worked through the questions one at a time. — 00:06:27
2019-01-31 · How to Study for Exams with Google Sheets — recommendation: Ali: 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
2019-01-31 · How to Study for Exams with Google Sheets — Ali: Marking a well-recalled question yellow or green gives Ali a small gamified burst of good feeling about studying. — 00:07:52
2019-01-31 · How to Study for Exams with Google Sheets — Ali: With spare time before exams, Ali opens his Google sheet on his iPhone, iPad, laptop or any browser. — 00:07:52
2019-01-31 · How to Study for Exams with Google Sheets — Ali calls "what's the deal with polymyalgia rheumatica?" a bad flashcard question, since flashcards work best with a distinct fact; such broad, open-ended questions go in his Google sheet. — 00:08:52
2019-01-31 · How to Study for Exams with Google Sheets — recommendation: 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-01-31 · How to Study for Exams with Google Sheets — Ali calls preferring Google Sheets to flashcards a personal preference, and made this video because many people asked about it. — 00:11:04
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
2019-02-14 · Valentine’s Day Live Stream — announcement: Ali: 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

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
2018-04-09 · How to Study for Exams - Spaced Repetition · Evidence-based revision tips — recommendation: 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-10 · Study with me + My revision method - Cambridge University medical student VLOG #30 — Ali: On the 40-minute train from St Albans, Ali answers the morning's questions in Google Sheets on his phone instead of rereading the notes, practising what he preaches about active recall. — 00:04:22
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
2018-04-14 · Last Minute Study Tips, Flashcards, Essays & Maths - Exam Revision Q&A with Cambridge students — 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
2018-04-14 · Last Minute Study Tips, Flashcards, Essays & Maths - Exam Revision Q&A with Cambridge students — 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-18 · Study With Me + 10 Productivity / Revision Tips - Cambridge University medical student VLOG #31 — recommendation: Ali: Asked by a viewer for a video on his magical active recall system, Ali replies that he has made one, "How to study for exams with Google Sheets". — creator comment
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 prefers Google Sheets to Excel: it loads quickly in a browser on any device, and it is very easy to share, with people updating it live. — 00:26:55
2018-06-12 · Live Stream - Tuesday Evening Hangout — Ali: Past papers in Ali's first and second years had no mark schemes, so his group made their own in a Google Sheet for each subject: one did a paper, another marked theirs against those answers and commented on disagreements. — 00:26:55
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-10-10 · iPad vs Macbook for Students - Can a tablet replace your laptop? — Ali: Google Sheets can be used on an iPad, Ali says, but formulas, conditional formatting and dragging formulae across cells are much faster on his MacBook. — 00:07:07
2018-10-21 · My Study Method + Revision Tools - Cambridge junior doctor — Ali found getting through his Anki flashcard decks became a real chore, so he stopped using Anki and switched to his Google Sheets method. — 00:06:49
2018-10-21 · My Study Method + Revision Tools - Cambridge junior doctor — Ali: Instead of a revision timetable, Ali tracks his spaced repetition in Google Sheets as a retrospective timetable: he logs each topic once he has studied and actively recalled it. — 00:08:18
2018-10-21 · My Study Method + Revision Tools - Cambridge junior doctor — announcement: Ali promises a more detailed video on how he builds his retrospective revision timetable in Google Sheets. — 00:08:18
2018-10-21 · My Study Method + Revision Tools - Cambridge junior doctor — Ali also uses Google Sheets for active recall: the broad topics of each chapter sit in his sheet, colour-coded by how well he knows them, so he sees at a glance what to test himself on. — 00:08:18
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
2018-11-23 · Study with Me - Resuscitation Training · Life as a Junior Doctor — announcement: Ali is working on a video explaining his active recall spreadsheet in more detail. — 00:01:27
2018-11-23 · Study with Me - Resuscitation Training · Life as a Junior Doctor — Ali: 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
2018-11-23 · Study with Me - Resuscitation Training · Life as a Junior Doctor — Ali: The colour-coded questions make Ali's spreadsheet a very easy way to see the holes in his knowledge when he looks through it again. — 00:02:16
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

2017

2017-07-26 · We're trying something new... · Medical Students Making an App - Episode 1 — Ali finds filling in a surgical logbook spreadsheet at home a pain; the Google Sheets phone app, which some students use, is not an easy input system. — 00:00:46