I mentioned this course tracker / revision planning spreadsheet in an ask on my main blog and here i

I mentioned this course tracker / revision planning spreadsheet in an ask on my main blog and here it is, finally!LINK TO THE SPREADSHEETHere are some notes to read before you use:To save your own copy: File > Make a copy  Feel free to edit as much as you want once you have saved your copy  but please don’t redistribute as your own work.This sheet will need some basic knowledge of how to use Sheets or Excel if you want to change the formulas but for the most part, you only need to enter dates, copy and past, and add rows and columns. I’d recommend filling it out at the start of semester once you receive your class schedule. It does take a little while to enter everything so doing it as early as possible will give the maximum benefit! The ‘review’ columns are formatted to fill out automatically once you enter the date in lecture column, except the test and exam dates, which will fill out once you enter the test and exam dates. For editing the test / exam dates: the rightmost columns are for writing important dates (I put test and exam but you can change to fit you). If you add more dates, you’ll have to input the formula yourself. The test and exam revision columns are on default set to a date 7 days before the date entered. You can change the date of revision for each cell by changing the ’- 7’ part of the formula to something else. It only works for the first date entered in the date column. In the dated columns, the cell will be highlighted if it’s today’s date as a reminder. If the highlighted dates are incorrect, please go to File > Spreadsheet settings and change the timezone! I think it defaults to Pacific Standard Time.  You can duplicate the ‘COURSE 101’ sheet to however many courses you have, and you can rename it of course. In my personal sheet, I also added in assignment and test dates to the main column. I didn’t include it here because it’s a bit cluttery, but you can easily add in your own rows.  You can message me if you need help! I’d also appreciate suggestions on how to make this spreadsheet better if you have any! I have some examples under the cut! I just wanted to share some ways to customise this spreadsheet depending on your needs.  Here is what I did for my STATS class. Each new week is highlighted by the lecture no. (alternate weeks are coloured). I added a new row for assignment due dates, test dates (not shown) and also included labs. This is what I did for my Korean course. I changed the columns because we don’t have lecture recordings but I do want myself to practice vocab on Quizlet after every lesson. I was going to add a new row for due dates but it would’ve gotten quite messy, so I made a bolded column instead. -- source link

More pics about