How to Study for Exams with Google Sheets
VloĆŸit
- Äas pĆidĂĄn 13. 07. 2024
- đ Pre-order my book to get an exclusive ticket to The Feel-Good Productivity Annual Planning Workshop!
Website: www.feelgoodproductivity.com/...
Amazon: go.feelgoodproductivity.com/b...
đŹ Check out my FREE 36-video online class on how to study for exams - skl.sh/2UOx68x
Squarespace free trial - squarespace.com/aliabdaal
Use the code ALIABDAAL to save 10%
In this video, I talk through exactly how and why I use Google Sheets as a flashcard alternative for effective studying. We discuss the method of using a spreadsheet as an Anki/Quizlet alternative, and then talk about some of the reasons why you might want to. Enjoy xx
--------
MY FREE ONLINE COURSES:
đ Productivity Masterclass - Principles and Tools to Boost Your Productivity - go.aliabdaal.com/course/produ...
đŹ Video Editing with Final Cut Pro X - From Beginner to CZcamsr - go.aliabdaal.com/course/video...
đ How to Study for Exams - An Evidence-Based Masterclass - go.aliabdaal.com/course/studying
đ How to be Happier - Stoicism Masterclass - go.aliabdaal.com/course/stoicism
TOOLS OF THE TRADE:
đ„ My CZcams Camera Gear - kit.co/AliAbdaal
âšïž My Keyboard - Wireless Coral mechanical keyboard (Cherry Blue) - go.aliabdaal.com/keyboard
đ My favourite iPad Screen Protector - Paperlike - go.aliabdaal.com/paperlike
đ My Desk Accessories + Todo List - Ugmonk - go.aliabdaal.com/ugmonk
đ How I remember what I read - Readwise - go.aliabdaal.com/readwise
đ” Where I get my Music (amazing for CZcamsrs) - go.aliabdaal.com/epidemicsound
đ» Where I get my Website Themes from - go.aliabdaal.com/ghost-themes
đ» My personal Ghost Website Theme - go.aliabdaal.com/ghost-theme-ali
What I Use For Analytics - go.aliabdaal.com/tubebuddy
đ My website platform (Ghost) - go.aliabdaal.com/ghost
OTHER RECOMMENDED COURSES
đ Effortless Output with Roam Research - go.aliabdaal.com/course/roam
đ Building a Second Brain - go.aliabdaal.com/course/basb
đMy weekly podcast - / notoverthinking
My brother and I host a weekly podcast where we discuss happiness, creativity and the human condition. You can find it by searching âNot Overthinkingâ on any podcast app (eg: Spotify, Apple Podcasts, Google Podcasts etc).
BE MY FRIEND:
đ Sign up to my weekly email newsletter - aliabdaal.com/newsletter/
đ My website / blog - www.aliabdaal.com
đž Instagram - / aliabdaal
đŠ Twitter - / aliabdaal
đź Twitch - / aliabdaal
WHO AM I:
I'm Ali, a junior doctor working in Cambridge, UK. I make videos about medicine, technology, productivity and lifestyle design. I also have a weekly podcast with my brother ( / notoverthinking , and I write a weekly email newsletter that contains some quick thoughts + links to interesting things (aliabdaal.com/newsletter/).
đ My website / blog - www.aliabdaal.com
GET IN TOUCH:
If youâd like to talk, Iâd love to hear from you. Tweeting @AliAbdaal directly will be the quickest way to get a response, but if your question is very long, feel free to email me at hi@aliabdaal.com. I try my best to reply to things but there sadly aren't enough hours in the day to respond to everyone đ
PS: Some of the links in this description are affiliate links that I get a kickback from đ
đŹ Check out my FREE 36-video online class on how to study for exams - skl.sh/2UOx68x
YOU ARE A SAVIOR FOR THE LOT OF US đđâšđ
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 )
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!
Ali the dram of every mom can you do a featuring whit czcams.com/channels/0QHWhjbe5fGJEPz3sVb6nw.html both you guys are the dream of every mom
Ali - the ambassador for Active recall. xD
Active-recall Learning Instructor (a-l-i)
Lol
Ali is the only CZcamsr 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.
True Storyđș
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.
Well put.
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.
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!
Am I the only one who feels so motivated to study after watching his videos?!
same
And feels demotivated a little laterđđ
I concur but can't you use past papers for questions instead
@@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.
Thuraiya AlRawahi sameee
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 đ
Waiting for his video to doing a video with him-goals!
What a gem I've found here
Aha...my study buddyđđ
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 !!
hi, how did you use spaced repetition for this method? (if you did)
@@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
YAY GREAT JOB!!!! :D âšâšâš
in your heart didnât you use Aliâs retrospective revision timetable
I wish I had friends like you. People who are your friends are super lucky.
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
How did it go?
How did it gooo
How did it go?
Go it did how?
Goo goo goo
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 đđ
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
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
Keplar and then if u want to spend extra tike make a google sheet or quizlet or Anki for quotes related to themes/characters
@@aroobmanzoor9255 okay thanks
Aroob Manzoor how did u revise physics from this ?
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.
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!
Please make a video on this. Thanks
Two of my fave doctors đ
Thank you for this, I did not know that you could do this.!!!!
hide the answers by making the font white?
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?
Animepro100 too clever ??
Yes Ali plz make a video on that :)
Good point. Please Ali bro make a video on this . Will be helpful for all. Thanks!
Please make this happen.
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?
Used this + Anki flashcards for my Classics A-Level, nailed it with an A*. Totally recommended!
I was searching for this comment..
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!
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 đ”đ
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!
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!!
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! đđđ»đ
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!
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! âșïž
Youâve inspired me to use this technique, loving it so far, thanks.
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....
hello Ali thanks alot for your videos ,they have really helped me in my engineering studies especially the active recal method
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
This is EXACTLY what I needed! Thank you so much!
omg, I was just thinking about this earlier! Another brilliant video Ali! Thank you! x
Nice to see another video of you Ali!... Thanks for your tips and tricks on studying and productivity!
I love how you make your videos so organized.
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!
Thanks for this, Ali! A big help to everyone whoâs trying to do better in school. â„ïž
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
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!
I've just been using this for a couple of days and it's worked wonders. Thanks!
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.
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?
@@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 :)
@@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 :)
@@Sam.21.904 how was it?
@@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!
Just in time for the start of the new semester!! Thanks Ali! :)
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!
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
this really helped me a lot in figuring out how to study effectively, thank you!
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.
Thank you for your revision techniques your helping me get through my GCSEs!
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.
love this method but i needed this like 6 years ago when i was in college now i am just watching :D
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.
This episode actually solved my confusion with flash card apps which are sometimes too random to be systematically reviewed. Thanks Ali, YOU ARE LEGEND!
was waiting for this love your videos!! đđ
Amazing videos Ali! Keep up the great work.
Love from the US! :)
Itâs the simple things like white font that make all the difference in a tool being so useful!
Thanks so much, Ali, for sharing this study method!
You almost make me want to have an exam to study for. Almost.
Thank you very much for all these tips!
Finally!
I was waiting for your video all week long !
Keep going man ! đ„
this is absolutely brilliant, love your work Ali!
Been trying to learn this study method. Its amazing!
Thatâs a clever idea- Iâm going to try it out, thanks!
Thank you so much!!! based on your tutorial i found my way of studying to tests, thanks
this is really good idea.
and it is even possible to arrange the questions in different orders for people who might need that.
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đŻđ”
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 ^^
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. :)
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.
You can use conditional formatiing
Thank you!
This was the thing I immediately got in my mind.....
Even the images as well
SO simple, yet seems very effective. Will give this a try!
This is wonderfully minimalistic and neat!
Great video!!! Thank you so so much, Ali!!! đđđâ€â€â€âšâšâš
Great points on the usage of google sheets and anki! Ty Ali!!!
Was really looking forward for this comparison!!
Thank you so much for this video! Makes so much sense
YASS ALI GCSE's IN 3 MONTHS, I NEEDED THIS
THANK YOU!!!
woouh ..... đThe best and simplest space repetition method ever.
i would say that flashcards are for specific vocabulary terms and definitions, and then google sheets for questions, as you said in the video.
Great Video Ali. I use "Group" feature to group questions chapter wise. Helps to keep the sheet concise and limits scrolling.
Iâm a Law student and I think you just gave THE idea to study the articles from the different codes. Love your channel! đđŒ
This is a very interesting video. I have been developing a Google Sheets backbone for Spanish-language study and the points you make are causing me to reconsider and perhaps modify my approach. Iâm going to explore your other videos for related ideas. Thanks!
Your videos are so helpful! Thank you so much
I am a hardcore flashcard enthisiast but you actually convinced me to try this method :D . Great video!
thank you for this, iâm def going to try it for my final exams!!
This is so useful! Thank you Ali!
Just recently used this because of you. ITS GREAT!!!!
This is really helpful. Thanks for sharing such ideas.
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.
This was actually really helpful Thnaks!
How do you know what I need in my life?
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 CZcamsrs...
Love watching your videos when i need of motivation to study.
Thanks a lot ! This is the right time to upload this .
this is so smart!! THANK YOU!!
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.
Great idea!!!
Thank you very much for your contentđ you're so inspiring. Keep doing! I hope that your advice in studying will help me succeed in this semester.đđ
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!đ
what do you think is netter google sheets or flashcards?
Subscribed!! Great content!!
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
This is absolutely golden thank you so much Ali
Ali - I used this method and it efficiently got me very high scores on my biology exams. Thanks
The one thing I love Anki for (I guess Quizlet can do that too) is the Image Occlusion function. I used it a lot for anatomy, I would just take snippets from the textbook (I had the ebook) and put it into Anki. But I'll definitely try this method next.
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
Ali, I totally agree with you.. thanks for sharing
This is perfect, was looking for an anki alternative to prepare for OSCEs (already have enough of that to do)
This is awesome! Currently giving it a try for IB chemistry, hopefully works as no other method has been successful to me. This is very unique and different - seems promising
This literally made me memorize 30,000 GRE vocabs! Thank you so much :)
so glad i found your channel!!! x
Ok but where is the pen twizzle tutorial
oh, itâs up now alright. wasted three hours. no regrets whatsoever *spins*
Nice method. I would add that you can set some condition formatting for cells. For example if you end cell with "/1", "/2" , "/3" or any other characters you want, it could automatically set up background color for this cell. I use it for my google sheets planning, if I write a dot on the end of the cell its background color changes so I know it's marked as done.
You, sir, are a legend. Thanks so much, this could could work really well on the iPad in conjunction with note taking apps as well. â