Assignment Tracker Spreadsheet

FacebookTwitterPinterestStumbleuponWhatsappEmail

Advertisement

Updated by Tina Sieber on 28 February, 2017.

Is your life a hotch-potch of missed deadlines, forgotten shopping, and reneged commitments? Sounds like you need to get organized. Where better to start than with hard numbers and figures?

For this, you might want to take advantage of the many spreadsheets available on Vertex42 that allow you to keep track of your time, belongings, projects and money.

Here are 10 of the best Excel spreadsheet templatesAn Excel Template for Every OccasionAn Excel Template for Every OccasionSkip the steep learning curve and sort your life with the power of Excel templates. We have compiled a selection of auto-updating templates to track budgets, manage projects, and more.Read More to organize your life.

1. Excel Money Management Template

If you’re anything like me, your finances are scattered around a smattering of savings and checking accounts, with the odd credit card thrown in. Perhaps you’ve even got a mortgage. This makes it incredibly challenging to keep on track of your income and expenses.

Sure, you could lean on a product like You Need A Budget. Or you could take this spreadsheet for a spin. Your shout.

The template allows you to create a yearly budget to handle all your income and expenses for multiple accounts in a single worksheet. This will let you track your spending habits and plan for unexpected costs.

2. To-Do List

Visualizing what you have to do as a list is a valuable tool in increasing your productivity. There’s no shortage of tools on the market that help you do this. Personally speaking, I’m quite partial to Wunderlist (use this Wunderlist tipHow to Use New Wunderlist Folders to Boost Your To-Do ListHow to Use New Wunderlist Folders to Boost Your To-Do ListWunderlist got a big update with two new features essential for a good to-do app: organizing and quickly adding tasks. Do these help it become the productivity app of your choice?Read More).

But if you want a simpler solution, check out this to-do list spreadsheet.

It lets schedule tasks, set a priority, and get things done on time. Best of all, you can easily customize it to your needs. You can even use it to schedule tasks among team members.

3. Medication List

Got any long-term health problems? If you’re on a number of medications, you may find it challenging to organize what you take, the amounts taken, and when you take them.

Thankfully, this spreadsheet takes away all the stress of managing your medication.

Just add what you need to take when and how. You can add notes to keep track of who prescribed it, why you’re taking this, when you should stop taking it, what the pill looks like, or anything else you notice while taking your medication.

4. Travel Budget Worksheet

Are you planning a vacation soon? It’s easy to fall into the quagmire of expense that comes with traveling. There are flights, hotels, and food to pay for, and everything in between. If you’re not careful, it’s really easy to find yourself paying more than you’ve intended to.

Now this Travel Budget Worksheet makes it incredibly easy to keep on track of your expenses when you’re seeing the world.

Set your total budget before you start booking, then insert individual expenses to keep track of how much room is left in your budget. The spreadsheet will also visualize your spending.

5. Checkbook Register

You don’t need a paper checkbook to take advantage of a checkbook register. In its simplest form, it allows you to track each and every incoming and outgoing payment, and then add (or subtract) that from a running total. This allows you to keep current on your checking account, and to avoid falling into the mire of debt. You can use paper for this, but why not try Excel?

6. Home Inventory Checklist

If you’re moving house, or renting out one of your spare rooms, you probably want to keep track of each and every item you have. This home inventory checklist makes it easy to see what you own, and what’s missing. And all from within an Excel spreadsheet.

The preset items in this list are optimized for insurance purposes, hence you’ll find columns for recording details on warranty, price, condition, serial, and model numbers. However, you can expand the list with anything else you’d like to inventory.

7. Meal Planner

If you’re on a highly restrictive dietHow to Build Perfect Meals with The IIFYM Calculator and ExcelHow to Build Perfect Meals with The IIFYM Calculator and ExcelYou can easily design meals that meet your nutrition intake targets. Achieve your fitness goals by using the free IIFYM Calculator and an Excel spreadsheet for healthy meals every day.Read More, or if you’re just trying to cut down on food wastage, you’ll want to keep a meal planner.

This meal planner template allows you to organize breakfast, lunch, and dinner for a week, as well as your grocery list.

You can check meals from a drop-down menu and the spreadsheet will automatically compile your grocery list.

8. Project Schedule Template

If you’re planning a DIY project, or have a massive school assignment to get done, you might want to consider doing a bit of project managementThe 5 Best Project Management Tips for BeginnersThe 5 Best Project Management Tips for BeginnersIf you are taking on a project manager role for the first time, here are just five project management tips to help you get started.Read More.

Vertex42’s Project Schedule Template manages to transform each step of what you’re trying to accomplish, all in the form of a pleasing Gantt Chart.

If you appreciate this template, also have a look these Excel templates for project management10+ Useful Excel Templates for Project Management & Tracking10+ Useful Excel Templates for Project Management & TrackingTemplates are to project managers what knives are to professional chefs: indispensable. We show you how you can replicate successful projects by using ready-made templates in Microsoft Excel and beyond.Read More or Word templates for managing projectsHow to Manage Your Project with Word TemplatesHow to Manage Your Project with Word TemplatesIn project management, preparation is half the battle. To organize and document your project, you may need many different reports, forms or plans. We have compiled a selection of Word templates to get you started.Read More.

9. Yearly Planner Calendar

Got a busy year ahead? The Yearly Planner Calendar spreadsheet allows you to visualize your schedule for months to come, whilst sticking to a single page. And there’s even room for notes.

If this calendar layout isn’t quite what you need, why not craft a custom calendar for the yearCraft a Printable Calendar for the New YearCraft a Printable Calendar for the New YearDon't like the calendars you seen in the shop or want to create something unique? Here we show you the eight best tools for crafting you own printable calendar.Read More?

10. Continuous Monthly Calendar

The Continuous Monthly Calendar is a bit like the Yearly Planning Calendar, but with one major exception. It doesn’t show any breaks between months. It’s all just one contiguous block. Just input the start date, and it will populate the cells with days and months.

You might also want to try one of these sites to create a free custom and printable calendar template10+ Sites To Find The Perfect Free Printable Calendar Template All Year Long10+ Sites To Find The Perfect Free Printable Calendar Template All Year LongYou can never have enough reminders that your most valuable personal resource is limited. Our selection of printable weekly, monthly, and yearly calendars will help you manage your time wisely.Read More.

Organize Your Life

The 10 templates above only scratch the surface of how you can use spreadsheets to get your life in order.

If you can’t find the perfect template, here’s how you can create a custom Excel templateHow to Quickly Create a Custom Excel Template to Save TimeHow to Quickly Create a Custom Excel Template to Save TimeExcel templates are universally useful — they can help you keep your finances in order, manage a project, and organize your life. We show you how to create your own custom template.Read More. And if you need a physical copy, be sure to format your spreadsheet so it will print to one single pageHow to Print an Excel Spreadsheet on One Single PageHow to Print an Excel Spreadsheet on One Single PageA beautifully crafted spreadsheet loses all its appeal when it comes printed on nine sheets of paper, with half of them empty. We show you how to get everything nicely on one single page.Read More.

Do you have any particular strategy for staying organized? Found any useful spreadsheets on Vertex42 I might have missed? Tell us about it. The comments box is below.

5 Useful Resume Sites for Preparing a CV That Gets Read in 2018The Risks And Rewards Of Renting Out Your Apartment On AirBnb

The major thing different in college classes from high school classes is the syllabus. I don’t know about you, but my syllabus in high school was always pointless. It always stated the same grading scale, the same attendance policy, and the same general information about every class.

In college, it’s different. Some professors put some assignments on the syllabus and then never speak of them again. No reminders the day before it’s due, no mentioning it in class, nothing. You need to be on top of your own work.. and I love that.

I have to admit, it was a little intimidating at first… but then I found this idea for an assignment planner by Kirsten at Organized Charm. I loved it.

 

So this idea was 100% from her. I changed it a tiny bit to fit me, but not much.


First, I gathered all of my class syllabus’ (syllabi?) together and highlighted all the important dates: due dates, exams, field trips, whatever I had to remember.


I opened up Microsoft Excel (this can also be done in Google Drive Spreadsheets if you do not have Microsoft Excel) and made a spreadsheet with 3 columns.

1 for the due date, 1 for the class, and 1 for the assignment.


Below that I merged the row together and wrote the first month. Then I skipped about 10 rows and wrote the next month.. and repeated until all the months for the term were on there.



Then I began to write in the dates for each class. I started with one class and added in each assignment under the month that it was due. In the assignment section I made sure that I was short and sweet, so that it didn’t grow too big.

Go class by class so that you don’t get overwhelmed with having to go day by day.


Once you’ve entered in all the assignments, arrange them by due date. If you’re not computer or spreadsheet savvy, this one might get a little confusing for you so I’ve laid it out in small steps below.

 1) Highlight the Area

Click on the cell in the top right corner of the month (the first due date) and drag until you have selected all the assignments, classes, and due dates for that month.

2) Click the A-Z Button

Click on the button on your toolbar that says A-Z. There should then be a menu telling you a variety of different things. The most common is that it will say sort it A-Z (alphabetically) but that is not what you want to do. If it already says to sort smallest to largest, just click that and you’re done. If it does not, then click on the custom sort button.

3) Custom Sort: Smallest to Largest

When you click on the custom sort button, this box should pop up. Simply select to sort column A (your due date column) by smallest to largest and press ok!

Then your month should be all sorted out by due date! Nice and easy 🙂

Go on and select the rest of the months and do it again one at a time.


Now that you’ve made the spreadsheet, how do you use it?

I have mine taped up right next to my desk. When I start an assignment I highlight it in yellow. When I finish an assignment I highlight over the yellow highlight in orange. Then when I turn the assignment in I cross it out with a black pen. This way I can keep track of every step of the process.


Using this spreadsheet has already saved my grade, and I’m only 6 weeks into the semester! I was leaving for my morning class and I wanted to make sure that I had finished any homework due for that day, so I glanced at my assignment planner before I left. Turns out I had done the homework for that class, but I hadn’t done the homework for the one after it! It was an assignment that my professor had put up on the syllabus but had not mentioned anything of it in class. It was a very simple task, so I did it while I was waiting for my first class to start.

Turns out that everyone in that class forgot to do it, except me! Luckily I had the time to remind a couple of my friends in that class to get it done, and they were able to turn it in on time.

Since I made this planner one of my roommates has stolen the idea as well and made it her own. She doesn’t print it out, just keeps it as a spreadsheet on her computer, and strikes it off digitally every time she completes an assignment.

 

This spreadsheet is only one of the ways that I make sure I’m on top of my work. My main source of school organization is my planner, but my favorite? My post-it note calendar. I absolutely love my post-it note calendar.. but that I’ll be saving till next time!


 

What do you do to stay organized for school? Tell me about it in the comments and maybe I’ll try it out!

Like this:

LikeLoading...

Related

Tagged on: Academics    assignment planner    assignment spreadsheet    blogging101    college    craft    diy    do it yourself    high school    highlighter    how to    life    my desk    organize    planner    productivity    schedule    school    spreadsheet    university

Share this amazing post with your friends:

DaniOctober 8, 2014College, My Desk, Organization + Planning, Organize, Tech

0 thoughts on “Assignment Tracker Spreadsheet

Leave a Reply

Your email address will not be published. Required fields are marked *