Just Completed And Submitted The Final Version Of My Extended Essay !!! °˖✧◝(⁰▿⁰)◜✧˖° 

I LOVE Excel! I took an Excel class during University and I’ve never stopped using or learning about it since. During my summer internship, I would literally use Excel functions and macros for hours every single day. Even if you don’t want to be an Excel fanatic, learning a few basic functions will make your life easier (and even impress a few managers along the way!).

I’ve outlined below some of the most useful Excel functions to learn. Some of these functions are very basic but can make a huge difference. These functions save time, automate procedures, and make your life easier! And if you need some help on how to learn them, I’ve listed some helpful resources to get you started. With all of us social distancing at home, now is as good of a time as any to add a skill to your resume. 

Excel Functions to Know:

SUM: returns sum of cells selected

SUMPRODUCT: multiplies ranges or arrays together and returns the sum of product

IF: return one value for a TRUE result and another for a FALSE result

SUMIF: returns the sum of cells if the cell meets a single condition

AVERAGEIF: computes the average of the numbers in a range that meets a certain criteria

VLOOKUP: lookup and retrieve data from a specific column in a table can be exact or approximate match

LEFT: returns a given number of characters from the left side of text string

RIGHT: returns a given number of characters from the right side of text string

CONCATENATE: joins the text of cells together and returns the joined text in one cell

LENGTH: returns the given number of characters in a text

Resources:

Excel Jet: Very useful as a type of Excel dictionary to look up syntax and specific formulas you don’t know

Excel Easy: almost like on online textbook for Excel (great resource for those who have no knowledge of Excel at all!)

Udemy: paid excel course with lots of videos, assignments, and downloadable resources

Coursera: self-paced learning option, quizzes and assignments, and a course certificate

Excel Youtube Course by Technology for Teachers and Students

Prologue to my Excel series

I’ll also be posting Excel tips, tricks, function explanations, and some basic Excel tutorials so if you’d like to see more appear on your dash in the future, follow my blog and look for my Excel series.

difference between a report & a research paper

sources used: my history teacher & “Tips for Writing Analytic Research Papers.” (1998): n. pag. Harvard Kennedy School Shorenstein Center, 19 May 2009. Web. 29 May 2015.

• report

- organized regurgitation of facts gathered from research

- thesis statement is a general statement summarizing what your whole report is about

- thesis statement is NOT opinion or argument to be proven

- topic sentences of body paragraphs summarize what facts you’ll describe in that paragraph

- research + writing facts = report

• research paper

- organized analysis of facts gathered from research

- thesis statement identifies the overall argument or academic opinion that you will prove in your paper

- thesis statement must be (academic) opinion and argumentation

- research + writing facts + analysis = research paper

• so what is analysis? how do i do it?

analysis is basically breaking apart the facts you have found in your research and demonstrating critical thinking about those facts. make your analysis explicit - your reader should not have to infer or guess what your analysis is. it looks like:

• dissecting or breaking down larger events or concepts to explore the smaller parts [“dr. king’s plan comprised of three specific political and social actions” - then the author explains the parts]

• cause/effect [author describes situation that outrages dr. king - “this outrage motivated dr. king to deliver his speech”]

• identification or explanation of significance [“this speech is iconic in american history because…”]

• comparison of ideas from different sources, or differing opinions; examination of counterarguments [“critics of dr. king said…” “historians disagree…” “others have said…”]

• connection to broader ideas and themes in the relevant discipline [“king’s actions exemplify the overall trend in social activism towards nonviolent action to achieve change”]

• connection to experiences, examples in other geographic areas, time periods or disciplines [“this behavior is explained by psychologists as…” “the american civil rights movement was inspired by actions in…” “another leader who inspired people in similar ways was nelson mandela in south africa”]

Me: I love fanfiction with slow burn and slow built relationships, I love the pining and I want to wait 1628 chapters and three eternity before they get their shit together and end up dating

Also me, two lines into the fanfiction: WHY DON’T THEY JUST KISS OH MY GOD THIS IS SO FRUSTRATING IT’S SO OBVIOUS THAT THEY LOVE EACH OTHER! JUST KISS ALREADY!!!

time blocking method

Hi all, this is werelivingarts, a new post about time management method: TIME BLOCKING! Time blocking allows you to divide your day into big blocks and helps you to complete similar tasks in one-go without any interruptions! 

You can do your time blocking on:

Google Calendar (simple and easy to use)

Plan (drag your to-do list and organize them in blocks)

TickTick Premium (offer pomodoro timer)

Hope you find this helpful! ⭐️

happy 69th birthday Robin Williams. you’re missed so dearly :)

— dead poets society (1989)

How to Brace Yourself for a New School Year

August is fast approaching once again! Though I’m all for “starting the year/ school year right”, I think it’s pretty much unavoidable for us to get off track. A lot. Because of that, I put together this infographic to help minimize those stressful moments in your brand new school years.

First of all, get your shit together. And I mean both physically and emotionally.

it’s a new start my friend!! detox your mind of all those negative thoughts (and people) and embrace the opportunity to start over. 

gather all the supplies you need. if you’re moving into a dormitory, make sure it’s equipped with everything you need to feel at home. 

her campus college packing list

do’s and don’ts

don’t go overboard with this step, but go get yourself some new stationery. choose wisely, and ensure that you’ll actually use it and it’s not just for purposes of aesthetic. we all want nice instagram feeds, but don’t let that be a reason for you to buy too much pretty stationery.

why not think of a note taking system before classes begin? 

the cornell system

mind mapping

flashcards

not all may find the idea of going back to school exciting, but you gotta have the motivation to keep that positive mindset in your head throughout the year! go you.

Organize your study space. You may have to stay in it much longer than usual now.

lighting is important. it’s oversaid, but never untrue. opt for natural lighting when you can, but if you can’t or you’re a night owl, get a good study lamp to brighten up those long hours of work.

I did say you’re probably gonna be staying here for some long bouts of time, but that doesn’t have to be a bad thing. make your desk one of your favorite places to be in. if you want to, make it really pretty. hang up some motivational posters or quotes - perhaps you even want a color scheme with that. 

desk inspiration

quote posters to get you going

quotes from writers

have an accessible stash of stationery on your desk at all times so that you don’t have to go looking for a pen and a sticky note when you need to write something down. keep pens, pencils and highlighters in a jar near you.

keep something green on your desk, like a succulent. plants are adorable and the sight of them can boost your productivity.

have a planner or a bullet journal, and make space for that too.

a bujo masterpost 

if working with music helps you, have headphones with you as well. always have a study playlist on hand. go for instrumentals or wordless tracks.

study playlist masterpost

make it a habit to keep your space in check every night before you go to bed. it really could make a big difference in how much work you’re gonna be able to do. don’t forget to stay clear of distractions!

Create a stress management system.

okay. this is what i’m telling you to brace yourself for. there are gonna be those days or those moments when you’re gonna feel really depressed or panicked. you’re gonna be okay. feel free to message me or any other studyblr - we’re here to listen =)

take some time out to practice self care and put off work, even for a bit. school is not the most important thing in the world, keeping yourself alive and healthy is. you can sleep, be kind to yourself.

self-care reminders

soothe yourself

go get some food too. you can prep some of your own if you’d prefer.

food masterpost

mood boosting food

never ever ever underestimate the power of exercise. the feeling of finishing a workout is so so so satisfying and I can guarantee you will feel better in no time.

the seven minute workout

popsugar fitness

take out your mat and do some yoga. stretch out all those muscles you held in place for so long sitting at your desk.

I find it important to always have a mini-collection of unread books. if you don’t have any, one of my favorite places to be in is a bookstore or library - and I just read whatever I find. the results can be life changing.

take time to hone your skills in your hobbies. if you can, do it everyday - do that one thing that makes you really happy daily. maybe you like singing. or playing the guitar. or painting. whatever it is, go do it.

write it down! I keep an electronic journal and it really helps to just spill your thoughts out on a notebook or your phone.

honey, please talk to someone if you need to. it won’t hurt. 

Get a headstart on academics.

especially on subjects that are easier with advanced reading. if you already know what books you’re going to be tackling for english or literature, go read them.

sparknotes

shmoop

try asking upper years who used to take your classes if they still have their course outlines, or any material they were given before. this can save lives.

gonna be taking a language class? why not start learning it already?

duolingo

memrise

find textbooks and start using them!!

don’t have any idea of what you’re going to study yet? that doesn’t mean you should stop learning something new. you can listen to a ted talk or join an online course.

ted

crash course

coursera

Finally, set SMART goals for the school year. And have a concrete plan for how you’ll reach them.

what average are you aiming for? what organizations do you want to join? make your goals realistic and specific.

motivation is very important, but honestly, you can’t count on it to be with you every single day, every single moment of your life while you’re working for your goals. what will push you forward then? discipline.

building discipline

surround yourself with a community people who support you. like I said in the first step, detox all those negative people from your life. find ways to work with your friends and help each other in attaining goals.

set rewards for yourself too, not just in the long run but for the little things like finishing a good study session or passing a paper early.

study reward ideas

that being said, don’t underestimate the power of setting your short-term goals. those will be your stepping stones to pursuing the bigger picture you envision for yourself.

Tumblr and Pinterest, provided you don’t go too far in using them, can serve your daily doses of inspiration. don’t just use them for the sake of looking at aesthetically pleasing shots, though.

on a final note, don’t let academics take over your life. I hope you have a fantastic year, and good luck!

self-discovery journal prompts

I’m really struggling with finding my real life and identity. Journaling not only helps me to discover myself and reflect on my personal beliefs and values, but also teaches me to embrace my flaws and improve my esteem. So hop on to one-month journaling prompt to explore and find your true self.

What am I most proud of?

How would I describe myself to someone I have never met before?

What would I look like in 10 years?

What are you are really good at?

What are my weaknesses?

Describe yourself positively in 10 words.

What is my background? How can it affect my beliefs?

What do I love about myself?

What am I passionate about?

What are my hobbies? What roles do they play in my identity?

Who or what motivates and inspires me?

What are my 3 biggest goals?

Describe your ideal version of your dream life.

What do I need to let go?

What are flaws that you accept and how can you looks at these flaws in a positive way?

What do I feel like my life is missing and how can I get more of what I need?

What areas that I can improve on?

What are 5 simple things that make you smile? Describe them.

When am I the happiest version of me?

If I could be anything in the world, what would I be?

If you could make 1 wish come true, what would it be?

If I already know that everything I want is coming, how would I show up differently?

If I could travel anywhere in the world, where would I go?  

How did someone change my day for the better?

How can I change someone else’s day for the better?

What doubts do I currently have? How can I ease them?

What can I do to nurture and mind, body, and soul more?

What are things that no one can understand about you? How can you express them?  

What is your life motto? Describe.

Write yourself a thank you letter.

Productivity Printables

Hey everyone! The semester has kicked off for many of us already, myself included, and I just gotta say, it’s been pretty crazy. I wanted to share some tools that have helped me and hopefully can help you too in having at least some semblance of organization this semester.

A couple notes: The first preview will show both high and low contrast versions. Remaining previews will show high contrast only but there are low contrast versions available. I have no idea why but the reviews may look different on different browsers/screens. They should print out fine, though. Click images for better quality, or go straight to the download link.

Anyway, here are the printables!

Daily Printables

Daily View (High Contrast (left) | Low Contrast (right))

Attention Management (High Contrast | Low Contrast)

Energy Management (High Contrast | Low Contrast)

Weekly Printables

Weekly Overview - Monday Start

Blank (High Contrast | Low Contrast)

Task-based  (High Contrast | Low Contrast)  

Time-based  (High Contrast | Low Contrast)  

Weekly Overview - Sunday Start

Blank (High Contrast | Low Contrast)

Task-based (High Contrast | Low Contrast)  

Time-based (High Contrast | Low Contrast)

Monthly Printables

Undated Monthly Overview - Monday Start (High Contrast | Low Contrast)

Undated Monthly Overview - Sunday Start (High Contrast | Low Contrast)  

Misc

Einstein Matrix (High Contrast | Low Contrast)

–

Hope you enjoy them, and if you’re looking for any of my printables, they all can be found in my Study Drive. Have an awesome semester!

THE GARDEN