Instructions+indexes

This covers the questions from 1969 to 1998 - both AB and BC exams. There are 2 pages on each Excel sheet - a Main page and a Printable page. I think the Main page shows the comments, and the Printable page hides them if I remember correctly.

The questions are categorized by year, AB vs BC, Question number, Calc vs Non-Calc sections, Topics (multiple topics for some questions). Lesson number (multiple lessons for some questions), highest lesson number (so I knew when I could actually use the question), correct answers, and a column where I could check off whether I had used it during a specific year. You can filter each column by its heading (depends on how familiar you are with Excel if you already know how to do that).

It is color-coded as well. Dark blue means that the question is repeated between the AB and BC exams for that year - the comment usually tells where exactly the repeat is located. Yellow means that it is a BC topic only. Green is notes to myself (questions that are rare nowadays, L'Hopital's Rule which I teach as a shortcut for limits even for AB students though it is not required as an AB topic, etc.). Red on the C notation for calculator means that a calculator is actually required to solve the problem (if I remember correctly). Light blue means that it is no longer an AP topic at all (AB or BC).

You should be able to use the filter tool within Excel to make the index easier to use. (Don't try to sort - the sorting tool tends to have problems with merged cells.) If the file comes through the same way that I have it on my computer, you will see a triangle in the lower right corner of each main heading. Clicking on the arrow will generate a list of checkboxes that list all of the possible things in that column. You can then uncheck all of them and then only check the ones you want. Excel will then only display those specific questions. For example, you could use the Topics heading and check "derivatives (trig functions)" to see all questions related to derivatives involving trigonometric functions. If you use the Larson book (7th Edition), you can use the Highest Lesson heading and choose a specific lesson number or numbers to find questions related to specific lessons to help with generating a quiz.


 * If someone else would like to add other textbooks and corresponding lessons, that would be great too.**

The lessons refer to the Larson, Hostetler, Edwards 7th Edition so that may not be helpful to you.

I use this along with the PDF file of the questions from College Board as practice questions in class. I have a SmartBoard so I can show everything directly from my computer screen to make it easier. I also use some of the questions (or modified forms of the questions) on quizzes and tests.


 * This project took me a significant amount of time, but I do not mind sharing it with others. All I ask in return is that if you find it helpful, that you would consider sending me (and possibly posting on here) a worksheet that you have found helpful for your own students (definition of the derivative, slope fields and separable differential equations, inverse function derivatives, etc. are some of the topics that seem to cause difficulty for some of my students no matter how much time or how many different ways I seem to teach them). My e-mail address is aoats hpcacougars.org (add your own @ in place of the space to reduce the amount of spam I get).**