Master SC OG Spreadsheet (800+ Questions)

Question

Hello, everyone, and Happy New Year. I have been working doggedly for the past few months to collate all the SC questions—870 in sum—that have appeared in official guides past and present and put them in one spreadsheet. Where the source was lacking in specificity—e.g., "1000 Series," "Official Guide  ," or, simply, "Official Guide"—I made a note. I also categorized (tagged) every question based on my own observations while I was practicing. Yes, I attempted each question, sometimes first thing in the morning, sometimes after a long day of work. (I tended to get sloppier in those later sessions, but excuses, excuses...) In case you are curious, or if you are the competitive type, the following are my stats. If you want to take up a challenge and beat the Expert, by all means, have a go. I would like to read about your experience, maybe down below or in a debrief. (I simply worked from top to bottom, but the beauty of a spreadsheet lies in its customizability.)

Easy/Low: 392/396 (99.0% accuracy), average 0:35/question   Medium: 277/287 (96.5% accuracy), average 0:48/question   Hard: 173/187 (92.5% accuracy), average 0:57/question   Longest streak on spreadsheet: 143 questions   Second longest streak: 139 questions

I created the spreadsheet as a Google Sheet, but I am uploading it as an Excel sheet. There is nothing fancy or automated. I not only lack the technical knowhow, I also find it useful to spend a little extra time adding notes or comments on questions, whether I get them correct or not.

As always, good luck with your studies.

- Andrew

12 October 2023—Removed download.

kntombat · Answer

AndrewN , this is absolutely amazing. 
Thanks a ton for taking time out for creating such a question bank.
I feel any candidate who uses this judicially will immensely benefit from the excel sheet you created.

Happy New Year and thank you once again for such an amazing New Year's Day present.

AndrewN · Answer

Thank you,   kntombat  , and Happy New Year to you, too. This spreadsheet is just one of several that I have going to track all official questions, both Verbal and Quant. It takes a while to comb through and sort out all the information.   Bunuel   is probably tired of hearing from me about some question or other carrying the wrong tag, but this project means a lot to me, and I think a better study aid is always a plus (as you said, as long as a person puts it to good use).

- Andrew

mohitprabhat · Answer

wow, a nice New Yr gift... thanks!!
Can we expect a similar sheet for CR?

AndrewN · Answer

Yes,  mohitprabhat , eventually. Right now, although I have added 650 questions to my CR OG spreadsheet, I have only worked my way through 335. I am loath to upload an incomplete sheet or one that contains unverified questions.

Happy New Year, and good luck with your studies.

- Andrew

carcass · Answer

Happy New Year

A very good job. It could come in handy

A side note: personally speaking, I would disregard completely the questions that are tagged "1000 series". More often than not they are from the OG. However, a good chunk of it is made by questions re-arranged or from MGMAT and dispatched as official. Or who knows from where they come from.

In doubt, I would go via tag to those questions I am sure they are official.

It was the case, in the past, that some question was literally a piece of crap and people knew it was official.

Be careful

Good job in the end. Compliments

Regards

PS: Above using only the tag official would be enough, though

AndrewN · Answer

Hello,  carcass . I am not sure we have directly crossed paths before, but it is an honor. (I have seen a lot of your work, especially on the GRE Prep Club forum.) I agree that the 1000 Series is a mixed bag. Some questions appear to have been corrupted—that is, if they were ever official questions to begin with—but others have also shown up in the GMAT Advanced guide or as GMAT Prep questions. I decided to take the chance that many of them were legitimate (official) questions, but I felt the need to point out that particular source and a few others. Solver beware, right?

I did not mean to be obnoxious with my tags. I thought I could create a post without a timer attached that would simply appear in the SC forum, the one I thought most appropriate for the spreadsheet. I would welcome any moderator changes that would get rid of the timer and place the post, well, somewhere that seemed fitting.

Happy New Year.

- Andrew

carcass · Answer

Disabled the timer.
Moved under the Verbal resources section which is more appropriate.
Cleaned the tags.

Thank you for the kind words Sir

AndrewN · Answer

The post looks much better now, more in line with what I had initially been picturing. I typically contribute to the forum by responding to Expert reply requests; sharing part of my work in this manner is new to me, even after a couple thousand posts. Thank you for cleaning everything up.

- Andrew

carcass · Answer

If you need help or else just drop me a private message whether is appropriate in your judgment!!! I'll try to help more here on this side of the moon. Usually, I am on the darkest side

Regards

hadimadi · Answer

AndrewN

This is like a miracle, I was looking for something like that but never found it, until i stumbled upon this post.

Just one question: This doesn't include GMAT Prep SC questions, correct? Just OG stuff

AndrewN · Answer

That is correct,  hadimadi . There are no questions on the spreadsheet that are solely tagged "GMAT Prep" on this site. Some older questions from the OG 10 especially may still appear in GMAT Prep tests 1 or 2, since that question pool is so deep, but to my knowledge, no questions from any of the guides with a full year in the title—from OG 2015 onward—have also appeared as GMAT Prep questions.

Good luck with your studies.

- Andrew

aryasharma · Answer

Dear Andrew, Thank you so much for doing this!
I just wanted to ask- has this also been made a part of the question Forum Quiz questions? Meaning, if I wanted to practice comparison questions, should I do the Forum Quiz or this? If this is included there, then it would be 2 birds, 1 stone B)
Again, thank you so much!

AndrewN · Answer

Happy to help,  aryasharma . To answer your query, all of the questions in the spreadsheet can be accessed in the Forum Quiz, as long as they are tagged "Official Guide" or something similar on the site. There may be a few discrepancies in tags, but in general, broad categories such as comparisons should align well. Feel free to practice using whichever method you like.

Good luck with your studies.

- Andrew

Wanderer4 · Answer

Hi  AndrewN  - I am yet to take official practice test 4-6 - Does this include any questions from that? Just want to check. I want to avoid getting an inflated score

Kushchokhani · Answer

Hi  AndrewN

Your signature line mentions 884 SC ques. However, the uploaded Excel spreadsheet has 870 SC ques. Pls reconcile the diff b/w 14 SC ques.

apollo1969 · Answer

AndrewN  
Thank you for this great effort. 
I want to attempt all of the SC questions as a quiz here. But i am not sure how to do it.

I tried by bookmarking few of these questions and then on the quiz, attempting only "bookmarked" questions. But, i don't see it as a very viable approach.

Can you please help me for the same.

bb · Answer

Is there a reason you can't use the drop down for sources and choose the source you want there?
Otherwise, if you want pretty specific questions, I think you would do it just one by one or however you want (or open the book and just pick proper question numbers)

apollo1969 · Answer

Hi bb ,

The reason that I want to attempt these questions only is because here the number of questions are very specific and it takes you to a state of mind where you know exactly what goal is to be achieved (884 SC questions here). Although drop down option in GC Quiz is really good and i have been using it since long, i work better by making small small achievable goals.

Any guidance on this will be appreciated. Thanks

You might find it funny but i have tried using Python and Selenium software to automatically bookmark all questions present in this excel file but was not successful (stuck in finding "button id" for bookmark button

)

Master SC OG Spreadsheet (800+ Questions)

Prep Toolkit

Top 5 GMAT Debrief Videos

615 to 715 in 15 Days (Ria's Strategies)

More than Quant/Verbal Abilities: Speed vs. Accuracy

745 with Only Self-Prep and GMAT Club

From 555 to 765: 210-point Improvement

Perfect 805 Score Debrief by Julia

My Rewards