#my: studyblr

[97note]

some old spreads from this semester! i’m going to post a ton of my old spreads since i didn’t have time to post them during the semester ;u; drawings from the lovely @94mlk ❤️

journal: rhodia goalbook pens: tombow dual brush pen, zebra sarasa 0.4, kuretake zig brushables

my studygram: 97note

[97note]

I mentioned this course tracker / revision planning spreadsheet in an ask on my main blog and here it is, finally!

LINK TO THE SPREADSHEET

Here 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.

[97note]

decided to kick off the revival of studyblr content on this blog with a collection of my washi tapes ❤️ semi-inspired by @pridebulletjournal! i’ve collected these over several years so i don’t really remember exactly where i got most of them, but they’re mostly from taobao / aliexpress or 10x10!

journal: moleskine cahier large squared notebook

[97note]

yesterday’s summary notes for statistical databases! today i’ve got to finish a compsci assignment and review this week’s stats lectures;; studygram: 97note

details: written on goodnotes 4 with ball pen in 1.5 🖊 blue accents with tombow brush pen in 553  💙 8mm dot grid paper generated from gridzzly

[97note]

An old spread from September with a red theme 😌❤️ I was inspired by a lot of people that used kraft paper a lot in their spreads so around this time is when I started using it more! Featuring my Holika Holika x Milky Peko Glow Cushion!

stationery info journal: rhodia goalbook pen: zebra sarasa study, 0.5 black markers: crayola supertips, tombow dual brush pens

my studygram: 97note

[97note]

I made a physical version of this semester’s timetable to pin on my wall! The circle is a little lopsided oops~ My studygram: 97note 🌱

Supplies: Plain washi tapes from Aliexpress, Kuretake Brushables in Pure Black, Tombow Dual Brush Pens in 192 and 772, Sharpie Fine (not pictured)

[97note]

some old bujo spreads from earlier in the year that i never got around to uploading  🌻 studygram: 97note

[97note]

yesterday’s revision: making summary sheets for compsci before doing some practice papers! i also got an essay assignment back that i was really worried about but i managed to get 88 ;u; | studygram: 97note