To get the "Rookie Mode Complete" achievement, you are required to complete the 11 story missions, and these include:
1. A Vintage Year
2. Curtains Down
3. Flatline
4. A New Life
5. The Murder Of Crows
6. You Better Watch Out
7. Death on the Mississippi
8. Till Death Do Us Part
9. A House Of Cards
10. A Dance With The Devil
11. Amendment XXV
12. Requiem**
**It is not required to complete the level Requiem to obtain the achievement, but you could still complete it anyways if you wanted to.