How to Make A Study Calendar

"If it wasn't hard, everyone would do it. 

It's the hard that makes it great."

It is that time of year, it's exam time. The end of the year is so tantalisingly close, a few weeks. But between then and now I have all my exams.

Exam time is always super stressful. It seems like there are too many things to do and not enough hours in the day! I've never done this before, but this year I've decided to make a study calendar.

I haven't really had a chance to use it yet, as today is the first day I had planned. But here are the steps I took to create the study calendar.

First open up a new excel document.

Select the "A" in the first column, and select the columns along, as many as there are days until your last exam.

Drag the A column over until it is double it's original size.


In the top row, add tomorrow's date. Then select the little green box next to the date and drag it across to the rest of the squares you prepared earlier. It will auto fill the dates.


Underneath this, in the A column, I put the day of the week and the tasks that I had that day.

Along the left side, put the times down. I did every 30 mins between 9 and 7.

Next I blocked out times when I had school or other commitments.


Then I added the dates for each test and task I had due

And finally I scheduled my time, basing it around when a task was due. I also added some time to work on this blog, do homework, and some spare time.

Hopefully this will help me get prepared for all my tests. And if you give it a go...I hope it helps you too. 

xxPoppy