No video

How to Study for Exams with Google Sheets

  Рет қаралды 592,328

Ali Abdaal

Ali Abdaal

Күн бұрын

Пікірлер: 815
@aliabdaal
@aliabdaal 4 жыл бұрын
🎬 Check out my FREE 36-video online class on how to study for exams - skl.sh/2UOx68x
@lenardbasinga6955
@lenardbasinga6955 4 жыл бұрын
YOU ARE A SAVIOR FOR THE LOT OF US 💖💖✨😭
@miat789
@miat789 4 жыл бұрын
Ali Abdaal Hi I noticed you said you know how to code. How would you set up google sheets to help out with learning to code ( Java for example )
@bio10155
@bio10155 4 жыл бұрын
I'm 39 and will be starting medical school this fall. Being so out of studying for many of years I'm a bit apprehensive in getting back into the flow. I'm trying to research new studying methodologies, and Ali has been inspirational to a oldie like me!
@pamita11
@pamita11 3 жыл бұрын
Ali the dram of every mom can you do a featuring whit kzbin.info/door/0QHWhjbe5fGJEPz3sVb6nw both you guys are the dream of every mom
@squidwardswift
@squidwardswift 4 жыл бұрын
Ali is the only KZbinr with studying tips that actually work. I mean, they are golden! I'm tired of seeing students make videos about how to take fancy notes, they are time consuming and aren't helpful at all.
@swanandjoshi333
@swanandjoshi333 4 жыл бұрын
True Story🍺
@Elovexxx
@Elovexxx 4 жыл бұрын
yep. I make scruffy notes because I find notes as a waste of time and then i make flashcards from those notes and thats what I use primarily.
@sugamon3692
@sugamon3692 4 жыл бұрын
Well put.
@gauravshinde6306
@gauravshinde6306 4 жыл бұрын
I'll tell u a little secret. The people who take those notes are hard working. Here's why. They either are like focused by nature, but for us ADHD people making a routine will help alot. I started by giving myself 5 hours and 1 hr pomodoro sessions to literally study inconsiderate of productivity. Once I made it a routine, I realized that I wanted to learn more about something I dont understand in that time period instead of getting up and grabbing an ice cream or something. And that's where they come from. All the detailed notes. It seems impossible but they have been perfecting it and becoming efficient at it their entire life. So dont get discouraged find patterns, make habits, and eventually you too will get there. Because I will tell u, that amount of note taking and revision is the only way to pass medschool. No other memorization metbhods work.
@squidwardswift
@squidwardswift 4 жыл бұрын
gaurav shinde there’s nothing wrong with taking efficient notes! I do that. what i’m talking about is videos that focus more on aesthetic rather than efficiency. these are a waste of time!
@A-Pro100
@A-Pro100 5 жыл бұрын
Ali - the ambassador for Active recall. xD
@silentaria3241
@silentaria3241 5 жыл бұрын
Active-recall Learning Instructor (a-l-i)
@Zetsuke4
@Zetsuke4 4 жыл бұрын
Lol
@user-tw1wb5xq1z
@user-tw1wb5xq1z 11 сағат бұрын
He is the ambassador for every thing
@thuraiyaalrawahi1473
@thuraiyaalrawahi1473 5 жыл бұрын
Am I the only one who feels so motivated to study after watching his videos?!
@gridg1896
@gridg1896 5 жыл бұрын
same
@aromalsubhash3750
@aromalsubhash3750 5 жыл бұрын
And feels demotivated a little later🙃🙃
@spiritrenewed3019
@spiritrenewed3019 5 жыл бұрын
I concur but can't you use past papers for questions instead
@CardboardBoxed
@CardboardBoxed 5 жыл бұрын
@@spiritrenewed3019 In undergrad courses, especially Medicine (things like OSCEs), past papers really aren't applicable. But past papers would work great up to and including A-levels.
@beatriceambrosca8358
@beatriceambrosca8358 5 жыл бұрын
Thuraiya AlRawahi sameee
@KharmaMedic
@KharmaMedic 5 жыл бұрын
I've been waiting for this ever since I heard you mention it in an older video! I'm definitely going to be implementing this in second year of med school, thanks for sharing the technique with us Ali 🙂
@shrinidhivengatasamy
@shrinidhivengatasamy 3 жыл бұрын
Waiting for his video to doing a video with him-goals!
@astudentstudying6199
@astudentstudying6199 3 жыл бұрын
What a gem I've found here
@tasfiaahsan6262
@tasfiaahsan6262 3 жыл бұрын
Aha...my study buddy😁😁
@inyourheart6899
@inyourheart6899 3 жыл бұрын
guys, i swear by this method. i used this in order to study for my biology tests and my chemistry finals. i used to be those types of people who would "almost pass" for biology, and i would normally fail for chemistry. after trying this method, i would end up getting over 65% in my biology tests (keep note that only around 35% students pass biology in my grade) as for my chemistry finals, only 5 people passed chemistry, and i was lucky enough to be one of them. earlier on, i had only 38% for my mid-terms, and i ended the finals with a 57%. it may not be much, but progress is still progress :) what i love most about this method is that i do not have to keep reopening my book and memorizing everything again and again, since every important question is already jotted down in my google sheets. anyways, 10/10 recommend this method, it works !!
@rosilove28
@rosilove28 3 жыл бұрын
hi, how did you use spaced repetition for this method? (if you did)
@inyourheart6899
@inyourheart6899 3 жыл бұрын
@@rosilove28 hi !! i'm so sorry for the late reply but i used ali's timetable to study at the time, since it was the finals :) just to note, my school always has tests, so i can't not study, so i feel like my school's schedule helped me implement spaced repetition because of the amount of tests we do. but for usual, i'd automatically press on a topic when i felt like studying that particular topic, or id press on the topic where i felt like i needed to work on :) i don't really restrict myself on doing a specific topic, just going w the flow typa thing
@rachelnxr
@rachelnxr 2 жыл бұрын
YAY GREAT JOB!!!! :D ✨✨✨
@tufailabbas1337
@tufailabbas1337 2 жыл бұрын
in your heart didn’t you use Ali’s retrospective revision timetable
@JakariaKhalilDraws
@JakariaKhalilDraws 5 жыл бұрын
This method managed to get me all grade 9s (new grade system) for GCSEs and I only discovered it like a months/2 months b4 my exams. I've already begun doing it for A levels and honestly you've totally changed my perspective on learning. I honestly am so interested in the science of learning now and I find myself sharing what I learn with others where I always reference you. Hope you realise how helpful you've been to everyone. Keep it up man 👊👍
@keplar7243
@keplar7243 4 жыл бұрын
Damn I need to do this. I was using Anki for like two months, so I'll probably switch to this. In what scenarios are flashcards better and how did you revise for English lit and Lang with this method
@aroobmanzoor9255
@aroobmanzoor9255 4 жыл бұрын
Keplar I got a 9 in eng lit and Lang from just past papers I didn’t even read the books all I did was do a past paper mark it and understand where I’m going wrong
@aroobmanzoor9255
@aroobmanzoor9255 4 жыл бұрын
Keplar and then if u want to spend extra tike make a google sheet or quizlet or Anki for quotes related to themes/characters
@keplar7243
@keplar7243 4 жыл бұрын
@@aroobmanzoor9255 okay thanks
@hadirashid6389
@hadirashid6389 4 жыл бұрын
Aroob Manzoor how did u revise physics from this ?
@xmodmodifier
@xmodmodifier 5 жыл бұрын
I used to love flashcards but it took all my energy in making it rather than in studying. I'll definitely start using this method now and give it a go
@bellasadventure.s
@bellasadventure.s 4 жыл бұрын
How did it go?
@PinkyMinions
@PinkyMinions 4 жыл бұрын
How did it gooo
@salsayunika6905
@salsayunika6905 3 жыл бұрын
How did it go?
@stbk51
@stbk51 3 жыл бұрын
Go it did how?
@__skullchess__7607
@__skullchess__7607 3 жыл бұрын
Goo goo goo
@jeezradz
@jeezradz 4 жыл бұрын
I wish I had friends like you. People who are your friends are super lucky.
@anishaseles2505
@anishaseles2505 5 жыл бұрын
You make studying look so cool. And thank you for emphasising on active recall in more efficient way. You’ve no idea how much it has helped me through my studies.
@A-Pro100
@A-Pro100 5 жыл бұрын
This question is crucial and I think you should make a video on it. Q , How did you run businesses and still got good grades in Med school at the same time? How did you manage your time and energy?
@rafathchowdury1968
@rafathchowdury1968 5 жыл бұрын
Animepro100 too clever ??
@subhasishnathdev
@subhasishnathdev 5 жыл бұрын
Yes Ali plz make a video on that :)
@RameshKumar-ng3nf
@RameshKumar-ng3nf 5 жыл бұрын
Good point. Please Ali bro make a video on this . Will be helpful for all. Thanks!
@satwickram
@satwickram 5 жыл бұрын
Please make this happen.
@user-yi4mt4hp8u
@user-yi4mt4hp8u 5 жыл бұрын
yes, please make this video. I'm currently in med school and have recently launched my own online store (even with some employees), it's doing unexpectedly well made 30k profit in its first month, launched it in the holidays. Now that's school is starting, I still find quite hard to manage my time, my grades are quite average not the best I want to be. How did you maintain really high grades in med school while doing business?
@nmaurok
@nmaurok 5 жыл бұрын
Used this + Anki flashcards for my Classics A-Level, nailed it with an A*. Totally recommended!
@jaqui4524
@jaqui4524 3 жыл бұрын
I was searching for this comment..
@AuraAzarcon
@AuraAzarcon 5 жыл бұрын
I use google sheets too! :) I'm trying to figure out how to use conditional formatting to hide the answers though! And i still end up downloading the file as .csv to upload to Anki :) i'm making a video on this for sure! Love learning from your approach!
@med8615
@med8615 5 жыл бұрын
Please make a video on this. Thanks
@msmukaijo
@msmukaijo 5 жыл бұрын
Two of my fave doctors 😍
@ryanfernando8330
@ryanfernando8330 3 жыл бұрын
Thank you for this, I did not know that you could do this.!!!!
@IB-ow3gt
@IB-ow3gt 3 жыл бұрын
hide the answers by making the font white?
@camille7965
@camille7965 3 жыл бұрын
Believe it or not, I’ve learned about active recall and spaced repetition because I binge watch your videos nowadays. I’ve started using Notion for creating questions for myself. Now, I am watching this because I am starting to consider google sheets for my reviewer in my upcoming exam. This is definitely better than my previous study method which is highlighting so much 😂 I think I am becoming a better student because of you, Ali.
@Sam.21.904
@Sam.21.904 3 жыл бұрын
Hey. I just got into law school and I'll be using active recall and spaced repetition for studying. Can explain me how did you start like how you use it to learn new content?
@camille7965
@camille7965 3 жыл бұрын
@@Sam.21.904 hello. Well, I am studying in the medical field but, I think what I did may work for you too :)) Basically, what I did was kinda similar to Ali’s. I have my book in front of me, and I as I read along, I type questions for the things I needed to remember straight into notion. I specifically use the toggle option for it now. Ever since I’ve been doing that, I’ve realized that I somehow was able to retain info just by that method alone, but it will be stored in your long term if you used the spaced repetition :)
@Sam.21.904
@Sam.21.904 3 жыл бұрын
@@camille7965 ahh thank you so much camille. I'll surely try this method and then use spaced repetition. I'll try this for one month or two and will let you know the progress. Thanks a ton :)
@friendchasecar511
@friendchasecar511 3 жыл бұрын
@@Sam.21.904 how was it?
@Sam.21.904
@Sam.21.904 3 жыл бұрын
@@friendchasecar511 hey. I totally forgot about this hahaha. But jokes aside, i started using notion and the toggle feature. What happened was it kinda became a headache for me to write all the content and go through toggle. Plus i didn't even use anki, as creating flashcards was another tedious task. What i did was stopped using notion completely. Instead, i use REMNOTE. It's a game changer. You can make notes and create flashcards at the same time. Saves a tone of time. I would suggest you to do the same. If any questions, shoot!
@kristajarolan
@kristajarolan 4 жыл бұрын
I’m a 2nd year med student and I just learned we’ll be having comprehensive exams on all 1st and 2nd year subjects by the end of the school year before entering year 3. This is such an awesome (and free!) alternative to Quizlet! I’ve always thought that flashcards are the way to go for making test questions in bulk. Thank you for this! More power from the PH 🇵🇭
@entsubar8248
@entsubar8248 10 ай бұрын
For people who think that making these questions is time consuming I got a very clever solution , basically copy the whole lecture than past it in chat gpt , you have to ask it to make questions based on the text you provided , then ask it again for the answers , after that you have to go ro google sheet and install the chat gpt extension , after that ask it to paste all the questions on collum A and the answers on B , and yeah that's it , it took me less than 10 minutes to create 40+ questions , you have to give it a try
@adilamuhammed1536
@adilamuhammed1536 5 жыл бұрын
I’ve been doing this Google sheets method since the past three weeks, I have my finals in a week. I’ll let you know how it goes after I’m done with my exams.🙌🏻 Thank you for structured study techniques you share!💙
@khaledgamal9842
@khaledgamal9842 Жыл бұрын
what do you think is netter google sheets or flashcards?
@TarequeMdKhan
@TarequeMdKhan 4 жыл бұрын
7:20 "Google sheet just makes it a super low commitment thing to sit down and study" This is the gist I was looking for....
@RobertThompsonEshun
@RobertThompsonEshun 5 жыл бұрын
Bro you have no idea how crucial this video was for me. I read the make it stick book and bought into the active recall method but having so many flash cards was a huge annoyance. Thanks again!
@aria2357
@aria2357 4 жыл бұрын
i would say that flashcards are for specific vocabulary terms and definitions, and then google sheets for questions, as you said in the video.
@user-oe1nt4pp8n
@user-oe1nt4pp8n 5 жыл бұрын
So glad this was recommended to me. I use to read all my notes passively and did a few example question to test my knowledge. This is much better!
@salomeachour6863
@salomeachour6863 5 жыл бұрын
The problem I found with the Gsheet method IS the lack of commitment, with Anki I'm "forced" to review all my cards, I can't skip a card, I have to review it in order to access to the others. The Gsheet method ask me discipline I don't have, sometimes in front of a question I'm like "nah I don't feel like doing this one, lets gently skip it" and woosh you skip it unnoticedly, and there isn't anki to harass you with this card you're having so much trouble getting in... I like the structure of Anki, and the feeling that it schedules the revisions for me ^^
@mrharpmanmd3386
@mrharpmanmd3386 5 жыл бұрын
Would be interesting if it is possible to transfer a gsheet into flashcards. Edit: Ok, a quick google search later I found lots of easy ways to convert a gsheet or similar file into quizlet flashcards. Hope this solves your problem. :)
@lebronjames5287
@lebronjames5287 5 жыл бұрын
I don't know if it's just me but if you even have the motivation to get up and study, it seem surprising that you're too lazy to review some information. And there are a lot of information that you already know, i think sometimes you would wanna skip a card instead so.
@now_n_abhi
@now_n_abhi 5 жыл бұрын
You can use conditional formatiing
@Sanjay-wy8bx
@Sanjay-wy8bx 4 жыл бұрын
Thank you! This was the thing I immediately got in my mind.....
@raosush9824
@raosush9824 4 жыл бұрын
Even the images as well
@traderdox
@traderdox 5 жыл бұрын
Hey, cheers! Great video. I also find active recall is the best way to learn a material. Recently, I started making powerpoints. I put the question on the title and the answer will have animation "appear" which appear when I press enter. The advantage of PowerPoint is that we can add pictures and appear after you press enter and have attempted the recall.
@rachelnxr
@rachelnxr 2 жыл бұрын
Great idea!!!
@BrendanEvan
@BrendanEvan 3 жыл бұрын
It’s the simple things like white font that make all the difference in a tool being so useful!
@ruthalmodal9902
@ruthalmodal9902 5 жыл бұрын
Yess Ali! I just started using Google Sheets (on your recommendation) to do SR for my A-Levels and I’m already seeing a massive difference in retention. So happy you decided to make a dedicated video to it, keep it up!
@ReiAnneD
@ReiAnneD 4 жыл бұрын
Ali. I just discovered your vids like 3 days ago! I'm in my 3rd year in medical school and I've been doing passive reading all my life. It's a daily struggle that's why I'm so grateful for your vids. Super thanks!
@suzy988
@suzy988 5 жыл бұрын
Northeastern Student! I love this!! I can't believe I never thought of this before. It reminds me of ANKI which is what I tried to use but didn't like.
@hajirafarrukh446
@hajirafarrukh446 5 жыл бұрын
love this method but i needed this like 6 years ago when i was in college now i am just watching :D
@oscarliu4582
@oscarliu4582 Жыл бұрын
This episode actually solved my confusion with flash card apps which are sometimes too random to be systematically reviewed. Thanks Ali, YOU ARE LEGEND!
@Mrlegitbeans
@Mrlegitbeans 5 жыл бұрын
THIS IS GENIUS. I'm studying for the MCAT right now, and I use google sheets, but I used to just cover the answer part up with my hand. Not the brightest idea after seeing this video.
@eushinkang4137
@eushinkang4137 5 жыл бұрын
Hi Ali! Thanks for all of your videos. I did my international GCSEs last year and with active recall as my secret weapon got a 97% average and three top in NZ subject awards. I'm sure I'll be using your videos as help and advice for the rest of high school and hopefully also during medical school. All the best.
@francishuynh5528
@francishuynh5528 3 жыл бұрын
Hi Ali I started doing this I went from an C to an A in all my exams! thanks man
@LVDNhan
@LVDNhan 2 жыл бұрын
Column A: question Column B: the answer (white letters ) Differentiate colors (column A) at different memory levels, or you can hide rows if you know the answer
@paanch110
@paanch110 5 жыл бұрын
Man, this KZbin channel is underrated af. This guy is so impressive!
@menace2819
@menace2819 4 жыл бұрын
Your revision techniques are the most useful ones I've ever come across and I'm not even exaggerating. This and all the other related videos are really helpful, thanks a lot!!
@June-oe6rx
@June-oe6rx 10 ай бұрын
One thing I love the color part and using randomize range. When you feel like you are remembering the order, you can just mix them all up
@mariaisabelacardiasegato2003
@mariaisabelacardiasegato2003 5 жыл бұрын
I literally spend all my day doing this because you've recommend it in an older video Hope it works, I'm trying to get into a medical college in Brazil, where I live, and we have to do this HUGE text on the end of the year to pass I am already using some of your tips Thank you! And sorry for my bad English, it isn't my mother language
@elainesladen5260
@elainesladen5260 5 жыл бұрын
Good luck! U will make it
@mariaisabelacardiasegato2003
@mariaisabelacardiasegato2003 5 жыл бұрын
@@elainesladen5260 thank you ♥️
@GabrielRodrigues-qw1qq
@GabrielRodrigues-qw1qq 5 жыл бұрын
Me too, is it working?
@rheaespinosa9523
@rheaespinosa9523 4 жыл бұрын
How did this work for you? Were you successful?
@danb4717
@danb4717 5 жыл бұрын
This is probably better than the average Quizlet set, but Anki can be more effective than a sheet. I get your idea but Anki/Quizlet offers image occlusion, cloze deletions, enumerated lists, spaced repetition algorithms, etc. It also seems like there are settings to fix your issues with Anki. For example, you say anki gives you cards randomly and you understandably don't like that - however, one can always custom study with tags, keywords, sort by date created, or make more specific decks. Everyone has their own methods and this probably works great, I just think Anki still comes out ahead. And thanks for your videos I've benefited a lot from them.
@QuantumNetwork
@QuantumNetwork 5 жыл бұрын
Dan Bergholz 100% agree, I use anki for everything but have them categorised , when I'm reviewing I do them all at once but when I need to revise something specific for a test etc I'll custom study the category needed. I find it much handier than google sheets
@haruny100
@haruny100 5 жыл бұрын
Pretty much all I could think during this video!
@tomhepz
@tomhepz 5 жыл бұрын
I agree, I think he misses out the concept of the tagging system and deck separation. Also having addons which can automate some of the stuff for you for a specific solution to a problem
@QuantumNetwork
@QuantumNetwork 5 жыл бұрын
anki has addons?
@lbo5650
@lbo5650 5 жыл бұрын
Agree ! There are so much setting on.anki
@Chinekeh
@Chinekeh 4 жыл бұрын
This is exactly what I need to go back to school. I am from the States and Shit student. I never knew how to study and maximize my time. Now I have a really. Good idea. I finished you Skill share class. It is great.
@alixnight5318
@alixnight5318 4 жыл бұрын
You almost make me want to have an exam to study for. Almost.
@rimshafawad8788
@rimshafawad8788 5 жыл бұрын
How do you know what I need in my life?
@voteformylogo
@voteformylogo 5 жыл бұрын
Ok but where is the pen twizzle tutorial
@aljosanpedro3424
@aljosanpedro3424 5 жыл бұрын
oh, it’s up now alright. wasted three hours. no regrets whatsoever *spins*
@LAisyourgirl
@LAisyourgirl 4 жыл бұрын
Thank you! This is exactly the method I needed during my final year of vet school. I thought I was the only one who dreaded making and going through Anki. You’re a lifesaver! 🙏👍🏻😊
@med8615
@med8615 5 жыл бұрын
bro I googled ali abdaal and the first suggested search was "ali abdaal death" shit scared me for a sec. May u live a long life lol.
@megangardner_science_and_art
@megangardner_science_and_art 3 жыл бұрын
You have the best study content on the internet. Wish I knew this when I was doing my biomedical science degree. But this technique works for learning information for my career so very happy I came across your videos 👌Thanks Ali
@fajitaboys
@fajitaboys 5 жыл бұрын
In 1921, Ludwig WIttgenstein published the Tractatus Logico-Philosophicus and took the world by storm with the metaphysical and phenomenological analysis therein. Later, a post-humous manuscript was released that rejected much of his initial writings, but nevertheless took the world by storm once more! Ali, you are the VVIttgenstein of flashcards. We follow your brilliance.
@backpackerschecklist
@backpackerschecklist 3 жыл бұрын
Hi Ali this is Subhajit from India. I’m a junior resident at Medical College, Kolkata. I just felt I needed to say this. Your videos and tips made me more productive and knowledgeable about my own studies. It really helped me grasp and recall some difficult concepts and semantics during my final year too. Thank you so much for these tips and nudges.
@zach7559
@zach7559 3 жыл бұрын
Ali - I used this method and it efficiently got me very high scores on my biology exams. Thanks
@Jamtarts2025
@Jamtarts2025 4 жыл бұрын
Ali you are my saviour!!! I have to take the ONCE and some other exams and I was freaking out so I started using active recall and so far it's working great!
@michaelacheong
@michaelacheong 5 жыл бұрын
my maths teacher was talking to us at the start of this year about active recall and so i started doing this just in a word document because i was only concerned about doing spaced repetition by date, but it seems really helpful to do it by overarching subject/topic too! thanks for making this video
@RegisteredNerds
@RegisteredNerds 5 жыл бұрын
I love how you make your videos so organized.
@azyrroth8164
@azyrroth8164 5 жыл бұрын
Now I'd like a video about how to formulate your questions and answers, as in what are bad questions and what are questions that will help you grasp stuff faster and demand a more broad knowledge.
@xclvrfip
@xclvrfip 5 жыл бұрын
Thanks for this, Ali! A big help to everyone who’s trying to do better in school. ♥️
@nuriamonne
@nuriamonne 5 жыл бұрын
I’m a Law student and I think you just gave THE idea to study the articles from the different codes. Love your channel! 🙌🏼
@ellekei1800
@ellekei1800 5 жыл бұрын
you should use conditional formatting so that you just have to type 1, 2, 3 to turn the boxes green yellow red. itll save you time and maybe you can even turn the question and answer into a light grey font!
@stolencinnamon6230
@stolencinnamon6230 4 жыл бұрын
Google should sponsor this guy he's advertising them like crazy
@sirijanthakur
@sirijanthakur 2 жыл бұрын
hey man, I used to feel completely exhausted while studying, Untill I watched your videos and found out I was doing studying all wrong all these years. I was marking all the things I already knew, and ignoring the others bunch I didn't knew thinking they ain't important and understanding way less, Thus finding boredom and extreme difficulty. It was all reading and completing a chapter quicker to me, Never working on actually what I don't already know, As you said, real learning happens when you see something new. This is where I started to read first, ask myself questions over a topic, see what I already know, take a mcq test over the topic, and then re read the topic marking what I don't know, not giving away all my secrets now xD. You literally changed my life, I scored a full 50/50 in my bio lol, in such a tough topic. I found that I'm having to place way less effort into studying now cuz now I'm actually enjoying it, instead of just trying to complete it. Science is one amazing field I must say, wish if I found "how to study" earlier lol. You changed everything, TY !
@Clostridiumbotulinum37
@Clostridiumbotulinum37 2 жыл бұрын
I've started using sheets to study spanish vocab. This is the opposite, I think, to what you said about keeping your subjects seperated, because the nature of a conversation, at least not a meaningful one, is that your not going to spend large amounts of time talking about the same thing. So I like google sheets because I can randomize the rows easily. Also, I have a column this the subject in it, so if I want to, I can filter the rows to only show the cards in that subject, but I can just as easily remove the filter and study them all together. I also have a column where I write how hard it was for me to recall the word, 1 through 5, and then I can filter that column too or put them in assending order or something. I use numbers instead of colors because I'm blind. I came up with this idea myself while talking with another person, and came here to see if anyone else was doing it to see if they liked it or if it just got annoying. Thanks for this video, your explanations are clear and you are excellent at using examples. Thanks again.
@harshamaloo2080
@harshamaloo2080 5 жыл бұрын
So thankful for making this illustrative video on spread sheets. Your content is to the point and really helpful. I’m a medical student as well and I do find the advantage of active recall. All thanks to you!! Much love
@laibakhan3843
@laibakhan3843 5 жыл бұрын
YASS ALI GCSE's IN 3 MONTHS, I NEEDED THIS THANK YOU!!!
@markpparkinseoul
@markpparkinseoul 7 ай бұрын
This literally made me memorize 30,000 GRE vocabs! Thank you so much :)
@tmujir955
@tmujir955 5 жыл бұрын
Honestly Ali you are changing my life. I have never actually understood how to study until I learned from your videos. I cannot thank you enough and I wish you the utmost success.
@widmawod
@widmawod 3 жыл бұрын
01:20 - The Google Sheets Method 04:05 - Why I prefer Google Sheets 08:14 - FAQs 10:45 - Wrapping up
@ski3133
@ski3133 3 жыл бұрын
thank u 💕
@megs8752
@megs8752 5 жыл бұрын
Hi Ali, Thank you so much for making this video. I have been using this method to prepare myself for a qualifying exam of high voltage facility management which I am taking this coming Autumn. Though I am not worried about calculation problems, I was feeling insecure about memorising all the laws and ordinances. I didn't want to cram in at the last minute and get away with, because if you cannot pull the information out of your brain when needed in actual practice, there would be no use being qualified. I AM SO GLAD I found your channel which led me watch this video! (I've just done with my study session for today and AM I feeling confident in what I am doing so I thought I would come back to this video and thank you ;)) Making questions myself and typing out answers are time consuming but it is totally worth the effort. Again, thank you so very much! Cheers from Japan🇯🇵
@romaissach497
@romaissach497 5 жыл бұрын
your Google sheets method has been a life savior for me, seriously it works, it's easier, faster and more productive! a mistake that I used to do is writing everything, so my take away from this video is to just put the question and explain it in my head when it's about concepts or long explanation, or just put key points/words.. anyway, the video is amazing and motivating as always, looking forward for more .
@krishtinasaru
@krishtinasaru 3 жыл бұрын
I’m so fortunate to have come across your videos on active recall & spaced repetition before my As level commence. I have been binge watching your videos for a couple of days now & will surely use these methods to prepare for my Alevels. Super thankful for your tips! ☺️
@charleswahome2699
@charleswahome2699 5 жыл бұрын
hello Ali thanks alot for your videos ,they have really helped me in my engineering studies especially the active recal method
@jaymata1218
@jaymata1218 5 жыл бұрын
Btw . . to add multiple lines to a single cell press ctrl+enter . . . .
@jonathansuresh589
@jonathansuresh589 5 жыл бұрын
Ali I love you, you're literally going to save my degree
@pradiptamoypaul6349
@pradiptamoypaul6349 5 жыл бұрын
Love from India Love u ... Thnx for ❤️
@pradiptamoypaul6349
@pradiptamoypaul6349 5 жыл бұрын
@@aliabdaal really liked ur song "Paheli nazar main Kaise jaadoo kar diya"
@dkboss4805
@dkboss4805 5 жыл бұрын
Same here
@meghalakshmis
@meghalakshmis 5 жыл бұрын
Same here..❤❤
@kulrajbirsinghsandhu4219
@kulrajbirsinghsandhu4219 5 жыл бұрын
Loved it... That's a practical one to do active Recall... I was motivated by you to make Flashcards earlier but soon realized that it was not my cup of tea... & now this method of Google Sheets is easy to prepare and Recall... Thanks Alot... Love your Videos... You are One of my Favourite KZbinrs...
@portraitofalion
@portraitofalion 4 жыл бұрын
You could get it to give you random questions. a separate column with a number in it might make the colours easily (conditional formatting and scores 1,2,3.
@nush.a
@nush.a 3 жыл бұрын
why didn't i think of using this technique when i was doing my undergrad?!! uugghh i couldn't have gotten better grades with this technique. Definitely going to use this technique for my MBA.
@tri378
@tri378 3 жыл бұрын
Been trying this active recall using anki flashcards for one term in nursing school and I can say it's damn effective but it requires a lot of work. My grades went from C to A. I might switch into this for my final term and see the results.
@MK-ih6wp
@MK-ih6wp 3 жыл бұрын
Any update? Do you prefer anki or gsheets?
@dr.kenzotenma780
@dr.kenzotenma780 3 жыл бұрын
.
@RikemagCola
@RikemagCola 5 жыл бұрын
Omg, yes, yes, yes, I just realized why Anki never used to work for me. Around what you said at minute 5, about med study being better without random questions but in order. I study Japanese but I could never remember vocabulary from flashcards. It's because I didn't learn them in context. While reading I always got much more into my head. Rather than just having one boring example sentence with them, completely without any reference to similar things, I need context. And this is perfect to build maps of vocabulary in context.
@jessicak2530
@jessicak2530 5 жыл бұрын
SO simple, yet seems very effective. Will give this a try!
@didoragab1217
@didoragab1217 5 жыл бұрын
"Hey Ali, wanna study wi-?" "ACTIVE RECAL!"
@monti-rs1vp
@monti-rs1vp 5 жыл бұрын
I've just been using this for a couple of days and it's worked wonders. Thanks!
@HSP565
@HSP565 5 жыл бұрын
Thanks for the video. I have two reasons for sticking with flashcards: (1) Even though I might remember something very well now, I might forget it in the long run. If I would color code it, I would probably just skip over it after a period of time. (2) I am putting images in my flashcards, which is not suitable for a spreadsheet.
@sagarbaishya4977
@sagarbaishya4977 5 жыл бұрын
I have been using google sheets from a long time I got the idea from your early videos helped a lot but it’s very case specific
@sunn0188
@sunn0188 5 жыл бұрын
You’ve inspired me to use this technique, loving it so far, thanks.
@piotrzaecki8254
@piotrzaecki8254 5 жыл бұрын
I am a hardcore flashcard enthisiast but you actually convinced me to try this method :D . Great video!
@guidonirukiye1373
@guidonirukiye1373 7 ай бұрын
woouh ..... 👌The best and simplest space repetition method ever.
@happyhusky3
@happyhusky3 4 жыл бұрын
I really love this method, thank you for sharing it. I'm not a huge fan of flashcards because they take a long time to input and like you said, I would have to put precises points rather than explanations. I tend to print the google sheets out and write down answers which i find to be extremely helpful to me but is quite time consuming. Do you have any tips there? I work better in a more systemic environment.
@rahulchobdar6943
@rahulchobdar6943 2 жыл бұрын
Great Video Ali. I use "Group" feature to group questions chapter wise. Helps to keep the sheet concise and limits scrolling.
@khansaiqbal7945
@khansaiqbal7945 5 жыл бұрын
I've just completed semester 1 of my medicinal chemistry degree and realised that the few topics I had make content summaries for (a structured bulleted list of things covered in that lecture/session) were revised so effectively.I realised that a lot of time was wasted on trying to categorise things in my notes/lecture slides/textbooks. This method will definitely help to impose structure on the topic and group all relevant things together, and the question format makes revision a lot more directional in the sense that a specific thing is being asked (unlike content summaries) that you must find the answer to. Thanks for the tips!
@KodiakBear872
@KodiakBear872 4 жыл бұрын
Amazing! I do exactly the same thing for my math studies. What I added though is the date of the last repetition, the importance, the amount of right answers and the reliability of my answer, to be able to sample well and concentrate on the most important ones on this day. My sheet also tells me when to repeat stuff based on the amount of right answers, so after the 1st time a 0 day wait period, then a 1 day wait, 2 ,4 ,6 days and so on.
@baebelieves
@baebelieves 3 жыл бұрын
That's very clever of you! @Kodiak Bear
@DrShubhamMandiya
@DrShubhamMandiya 5 жыл бұрын
My exams just ended and I'm watching this 😂
@DrAdnan
@DrAdnan 5 жыл бұрын
That’s a clever idea- I’m going to try it out, thanks!
@rllhasnain
@rllhasnain 5 жыл бұрын
DR. Active Recall you have helped me so much.
@alex2143
@alex2143 5 жыл бұрын
This is pretty awesome. You might be able to improve this with another column where, for instance, you grade how well you think you know the answer on a 5 point scale. Then, you'd be able to set a filter to only show stuff you've graded 1-3, or use conditional formatting to color the cells based on how well you graded yourself. You could also make graphs to get more insight into how well you understand certain topics, which may help you prioritize where you have to put in some more study time. One thing that I like you mention, that sometimes I tend to forget, is that it's a means to an end, and that you should look at what works best for you based on personal preference and the task at hand. Something programmers often say is that "if all you know is a hammer, everything you see starts to look like a nail".
@Jumpman-zc6tl
@Jumpman-zc6tl 5 жыл бұрын
I have been using this and it's great but now I've now colour coded my questions which is so much better thanks Ali. One tip I'd share is using command + \ which is a handy keyboard shortcut to remove formatting on the question to make the answer cell black and command + z to go hide it again - saves extra effort using the trackpad or mouse :)
@dcummins22J
@dcummins22J 5 жыл бұрын
On the note of timing, I'd be interested to understand why you take an "outcomes" based approach to studying as opposed to hitting a certain number of study hours per week (assuming your effectiveness is the same)
@cloudy6113
@cloudy6113 5 жыл бұрын
So weird.I was just searching a day ago on how to make revision questions on Google docs.This video was a God sent.Thanks man
@cosmicboneyard863
@cosmicboneyard863 4 жыл бұрын
this really helped me a lot in figuring out how to study effectively, thank you!
@studykendrick2029
@studykendrick2029 5 жыл бұрын
Been trying to learn this study method. Its amazing!
@CaritoCarrion
@CaritoCarrion 5 жыл бұрын
Nice to see another video of you Ali!... Thanks for your tips and tricks on studying and productivity!
@thomasmineo
@thomasmineo 5 жыл бұрын
I've been using a method like this except on OneNote for a few years now and i was so supprised that no one was talking about even though it works so well.
@doktorazoe
@doktorazoe 4 жыл бұрын
Thanks for all your tips!! I’ve used your other recommendation using google sheets to track your progress and how you can really see it. That’s been helpful for me to keep track of what I need to study what I need to review. Super loved that idea. I’m going to try this now. I’ve started on it. And wow it does take more time to do but since it’s community quarantine; hopefully I can start doing this a little faster and see the progress! Thank you thank you!
@JMS_Hunter
@JMS_Hunter 5 жыл бұрын
this is really good idea. and it is even possible to arrange the questions in different orders for people who might need that.
How to Study for Exams - An Evidence-Based Masterclass
2:49:37
Ali Abdaal
Рет қаралды 1,7 МЛН
How To Remember Everything You Learn
12:12
Ali Abdaal
Рет қаралды 793 М.
🩷🩵VS👿
00:38
ISSEI / いっせい
Рет қаралды 20 МЛН
Revolutionary Uses for Leftover Styrofoam
00:19
Делай сам
Рет қаралды 6 МЛН
Вы чего бл….🤣🤣🙏🏽🙏🏽🙏🏽
00:18
Gli occhiali da sole non mi hanno coperto! 😎
00:13
Senza Limiti
Рет қаралды 16 МЛН
Study Tips - How to learn new content
12:24
Ali Abdaal
Рет қаралды 1,5 МЛН
How to study for exams - The Retrospective Revision Timetable
13:43
Ali Abdaal
Рет қаралды 1,3 МЛН
If I Was a Student Again, I'd Do This
12:48
Ali Abdaal
Рет қаралды 1,2 МЛН
11 Ways to Spaced Repetition in 11 Minutes
11:02
Koi
Рет қаралды 305 М.
How to study for exams - Evidence-based revision tips
20:59
Ali Abdaal
Рет қаралды 5 МЛН
How I Manage My Time - The Trident Calendar System
19:02
Ali Abdaal
Рет қаралды 3,3 МЛН
7 Mistakes Students Make Every Year
15:33
Ali Abdaal
Рет қаралды 417 М.
How I Consistently Study with a Full Time Job: My Scheduling Formula
14:15
Elizabeth Filips
Рет қаралды 4,2 МЛН
🩷🩵VS👿
00:38
ISSEI / いっせい
Рет қаралды 20 МЛН