assignment tracker mahidol university

Free Assignment Tracking Template for Google Sheets

• Last updated December 14, 2023

Are you looking for an assignment tracking template? When your tasks begin to pile up into several imaginary towers, it’s easy for you to be overwhelmed, not knowing where to start. Moreover, you might not even be able to keep track of all of them, resulting in missed assignments and potentially bad marks.

Having an assignment tracker to keep every task means you’ll be able to organize, stay on top, and complete all your assignments on time. All you need to do is open our Assignment Tracking Template , hit the  “Make a copy”  button and start sorting out your to-do list.

Access Template

While it’s easy to navigate, make sure you read ahead to discover how to use our assignment tracking template to the fullest. We also have another assignment tracking template  that lets you map out your assignments throughout the semester—a perfect fit for your syllabus.

Table of Contents

What Should a Good Homework Spreadsheet Have?

In general, you’ll want a few fields that will help describe your assigned tasks and some markers for better organization. Here are some essential components to look for:

• Assignment description: An efficient assignment tracking template will have space so you can jot down assignment notes. This avoids confusion and lets you anticipate the difficulty of your to-dos.
• Dates:  Having dedicated fields for your due dates lets you plan your schedule better. This way, you know how much time you have to complete a task. Additionally, when paired with your assignment notes, you can sort them according to priority levels.
• Completion status: Keeping track of task statuses lets you know which tasks have started, are in progress, are accomplished, or need revision. Moreover, it’s also a great way to remember which tasks you need to return to.
• Subject and type:  You also want to categorize your assignments into their respective subjects. Another way to group them is by assignment type, including papers, lab reports, collaborative work, and similar tasks.

The components above are only a few useful fields in an assignment tracking template. For example, some spreadsheets also include monthly views or trackers for semester-wide assignment lists . Templates such as these will undoubtedly have other categories you’d need to explore.

Basic Assignment Tracking Template

With all the considerations laid out above, we created a simple but effective assignment tracking template you can use for free. While it may only feature a single functional tab, it has nine named columns you can organize according to your tasks.

If you haven’t already, you can download our free assignment tracking template here:

Let’s discuss the template in more detail .

Column A—Days Remaining

This is self-explanatory, but you can refer to this column to see the number of days you have left to do or submit your assignment. Depending on the days remaining, you can also decide which tasks to prioritize according to their deadlines.

The cells under this column are automatically updated using our pre-loaded formulas , so avoid modifying them. Instead, you can change the values under the last two columns of this template.

Columns B to D—Tags for Status, Subject, and Task Type

Under these columns, you can set the categories of your assignments either by their completion status, class, or assignment type. You can select the values from the drop-down lists that come with the template based on the American curriculum.

Additionally, these statuses are associated with specific colors, making them more visual so that you can view and handle multiple ongoing tasks more efficiently. If the subjects listed differ from what you’re currently taking, you can modify the options.

To modify the subject options, follow the steps below:

• First, click on a cell’s drop-down list and locate the pen icon at the bottom.

• Click the pen icon to open the drop-down settings on the left-hand side of your screen.
• Change the values listed on the options, such as editing Math  to Physics.
• Once you’ve set your preferred selection, click the “ Done” button.

• Upon clicking, a pop-out might appear on your screen asking whether to apply the changes to a wider cell range.
• Simply click “Apply   to all”  to replicate the changes to the other cells.

Another handy feature is the filter option in the “Status”  column. You can use this to view your tasks based on their completion level. For example, you can choose to see only the in-progress tasks. Here’s how you do it.

• To get started, click on the filter icon next to the “Status”  label.

• You should see a list of values with checkmarks on their left side once you scroll down.
• To deselect all of them, click on “ Clear.”

• Next, begin selecting the tasks you want to see per status, such as To start  and In-progress.
• Finally, click “OK.”

• To revert the view, simply follow steps one to five, ensuring to select all the categories again.

Columns E to I—Assignment Details

You can start entering the information you know about the tasks at hand. The columns E to G are divided into three categories: Assignment Title, Description, and Files/Links. If your assignment has attachments and URLs, such as resources, you can keep them in the last column mentioned.

Meanwhile, columns H to I serve as fields where you can input the dates when your task is given and when you need to submit it. Take note that these are installed with data validation rules—you can’t enter values that aren’t valid dates. These values are also used to calculate the Days Remaining column.

Semester Assignment Spreadsheet

If you are looking to plan your entire semester ahead of time with your potential tasks, this is a helpful assignment tracking template. It’s much simpler than the previous spreadsheet discussed and gives you a semester-wide overview of your assignments.

Get the template here:   Semester Assignment Spreadsheet

This assignment tracking template has only three fields that you can update. The first field is the (1) Date , which is located under the seven days of the week (with a total of fifteen weeks in the spreadsheet as per the American semester.)

The second is the (2) Tags  field, which allows you to categorize your tasks according to the subject. As with the other template, these tags are color-coded for an easier view. Lastly, you can also populate the (3) Assignment Details , the blank spaces beside the tags.

Why Use Our Assignment Schedule Templates?

You can virtually make a never-ending list of benefits from using a homework spreadsheet, but to name a few, here are some reasons why they’re beneficial for managing your workload.

• Organization: As repeatedly emphasized, these assignment tracking templates help you categorize your tasks according to subject, type, and completion status, making it easier to organize your workload.
• Time Management:  You can keep track of your due dates better with the automated counting of the days remaining for a task. You can manage your time better and learn to prioritize tasks according to deadlines.
• Easy Access:  Our spreadsheets run on Google Sheets , which you can easily access anywhere, as long as you are connected to the internet. On top of that, they’re also ready to be filled out as soon as you make a copy for yourself.

Wrapping Up

Sticking to your deadlines and organizing your tasks doesn’t need to be complicated. You can easily do this with the help of our assignment tracking template on Google Sheets. Access more of these excellent templates by visiting our other blogs too!

If you want to learn about Google Sheets to the next level, consider checking out relevant courses at Udemy .

• 5 Useful Google Sheets Project Management Templates [Free]
• The Free Google Sheets Task List Template [Easy Guide]
• How to Assign a Task in Google Sheets [Easy Guide]
• Free Balance Sheet Template for Google Sheets
• The 9 Best Google Sheets Templates to Streamline Your Life
• Volleyball Statistics Spreadsheet: Free Template

Most Popular Posts

How To Highlight Duplicates in Google Sheets

How to Make Multiple Selection in Drop-down Lists in Google Sheets

Google Sheets Currency Conversion: The Easy Method

A 2024 guide to google sheets date picker, related posts.

Rental Property Spreadsheet: Track Income and Expenses

• Talha Faisal
• July 10, 2024

The Only Project Plan Template You’ll Ever Need

• Princess Angolluan
• June 3, 2024

The Best Habit Tracker Google Sheets Templates

• Chris Daniel
• May 15, 2024

Free Purchase Order Template for Google Sheets (+ How to Use)

• May 6, 2024

Thanks for visiting! We’re happy to answer your spreadsheet questions. We specialize in formulas for Google Sheets, our own spreadsheet templates, and time-saving Excel tips.

Note that we’re supported by our audience. When you purchase through links on our site, we may earn commission at no extra cost to you.

Like what we do? Share this article!

Harvard and MIT’s $800 Million Mistake

Harvard and MIT’s $800 Million Mistake: The Triple Failure of 2U, edX, and Axim Collaborative

The future of Coursera’s only credible alternative for universities rests in the hands of 2U’s creditors.

• 900+ Free Developer and IT Certifications
• 9 Best Kubernetes Courses for 2024
• [2024] 300+ Free Google Certifications
• 10 Best Free Programming Courses for 2024
• 7 Best Reverse Engineering Courses for 2024

600 Free Google Certifications

Most common

• project management
• cyber security

Popular subjects

Communication Skills

Cybersecurity

Popular courses

Understanding Clinical Research: Behind the Statistics

Learn to Program: The Fundamentals

Sustainable Tourism: Society & Environmental Aspects

Organize and share your learning with Class Central Lists.

View our Lists Showcase

Mahidol University Courses

Mahidol University is a leading research university in Thailand that offers an extensive range of academic programs. It has world-class research, high-quality teaching and excellent international collaborations.

• With certificate (16)
• Free course (16)
• University course only (16)
• Social Sciences (4)
• Health & Medicine (3)
• Mathematics (2)
• Humanities (2)
• Science (2)
• Education & Teaching (2)
• Computer Science (1)
• Business (1)
• Engineering (1)
• Art & Design (1)

การอนุรักษ์ความหลากหลายและการใช้ประโยชน์อย่างยั่งยืนของพรรณพืชป่าพื้นเมืองของไทย | The conservation and sustainable use of native Thai plants

เรียนรู้การอนุรักษ์และใช้ประโยชน์อย่างยั่งยืนจากพืชป่าพื้นเมืองไทย เข้าใจความสำคัญของความหลากหลายทางชีวภาพ และแนวทางการอนุรักษ์ในชุมชน

• Free Online Course

การจัดการเรียนรู้วิชาวิทยาศาสตร์แบบสะเต็มศึกษา | STEM Based Learning for Science

" STEM สามารถขับเคลื่อนการเรียนรู้ให้ผู้เรียนได้เรียนรู้เต็มศักยภาพ และมีประสิทธิภาพ ตอบสนองต่อการเรียนรู้และใช้ชีวิตในศตวรรษที่ 21 " วรรณพงษ์ เตรียมโพธิ์

การวิเคราะห์และตรวจสอบโครงสร้างคอนกรีตเสริมเหล็กในกรณีภัยพิบัติ | Reinforced Concrete for Earthquake Disaster Evaluation

การวิเคราะห์และตรวจสอบโครงสร้างคอนกรีตเสริมเหล็กในกรณีภัยพิบัติ Reinforced Concrete for Earthquake Disaster Evaluation

การจัดการสาธารณภัย...ใครๆ ก็ต้องรู้ | Emergency Care in Mass Casualty Incident

เรียนรู้การจัดการสาธารณภัยและการตอบสนองต่อเหตุการณ์ฉุกเฉิน เพื่อเตรียมพร้อมรับมือกับภัยพิบัติที่อาจเกิดขึ้น เหมาะสำหรับบุคลากรทางการแพทย์และประชาชนทั่วไป

การออกแบบโมเดลและงานพิมพ์ 3D เพื่อการบริการชุมชน | 3D Model design & printing for community service

เรียนรู้การออกแบบและพิมพ์โมเดล 3D เพื่อสร้างชิ้นงานที่ใช้งานได้จริง ครอบคลุมหลักการออกแบบ การใช้โปรแกรม และเทคนิคการพิมพ์ เหมาะสำหรับผู้สนใจทั่วไป

การออกแบบวงจรดิจิทัล | Digital Circuit Design

เรียนรู้การออกแบบวงจรดิจิทัลพื้นฐาน ระบบจำนวน และการประยุกต์ใช้งาน เพื่อเป็นพื้นฐานสำคัญสำหรับวิศวกรรมคอมพิวเตอร์และสาขาที่เกี่ยวข้อง

กู้ชีพกู้ใจ...ใครๆ ก็ทำได้ | Basic Life Support

เรียนรู้การปฐมพยาบาลและกู้ชีพขั้นพื้นฐาน เพื่อช่วยเหลือผู้ป่วยในสถานการณ์ฉุกเฉินต่างๆ อย่างถูกต้องและปลอดภัย เหมาะสำหรับประชาชนทั่วไป

ประวัติและตรวจร่างกาย…ใครคิดว่าไม่สำคัญ?

หลักการซักประวัติและตรวจร่างกายทั่วไปสำหรับผู้เริ่มต้น โดยเฉพาะนักปฏิบัติการฉุกเฉินการแพทย์ (EMS personnel)

การจัดการการท่องเที่ยวและการบริการในยุค 4.0 | Tourism and Hospitality Management 4.0

เรียนรู้การจัดการท่องเที่ยวและบริการยุค 4.0 ครอบคลุมอาชีพ การพัฒนาอย่างยั่งยืน กลยุทธ์ธุรกิจ การตลาด และการสร้างประสบการณ์บริการคุณภาพ

วิทย์เพื่อชีวิต | Science for Life

เรียนรู้พื้นฐานฟิสิกส์ เคมี ชีววิทยา และคณิตศาสตร์ที่เกี่ยวข้องกับเทคโนโลยีและชีวิตประจำวัน เช่น พลังงาน ยา วัคซีน และการใช้คณิตศาสตร์เพื่อแก้ปัญหา

กลยุทธ์สู่ประชาคมอาเซียน: การเมือง เศรษฐกิจ และสังคม | ASEAN Strategies: Politics, Economics, and Society

เรียนรู้ระบบการเมือง เศรษฐกิจ และสังคมของประเทศสมาชิกอาเซียน 10 ประเทศ เพื่อเพิ่มโอกาสการลงทุนและสร้างความสัมพันธ์อันดีในภูมิภาค

การจัดการการเปลี่ยนแปลงมิติด้านการบริหารและการจัดการภาครัฐ | Change Management: Dimensions of Public Administration and Public Management

เรียนรู้การจัดการการเปลี่ยนแปลงในองค์กรภาครัฐ ผ่านทฤษฎีและกรณีศึกษาจากอาเซียน เพื่อพัฒนาทักษะการบริหารและตอบสนองความต้องการสาธารณะในยุคปัจจุบัน

การเป็นผู้ดูแลผู้สูงอายุ | Caregivers techniques

การเป็นผู้ดูแลผู้สูงอายุ (Caregivers techniques)

การเรียนรู้วิชาคณิตศาสตร์แบบสะเต็มศึกษา | Learning Mathematics using STEM based approach

เรียนรู้การสอนคณิตศาสตร์ผ่านแนวทางสะเต็มศึกษา เน้นการบูรณาการความรู้และทักษะ พร้อมตัวอย่างกิจกรรมและการประยุกต์ใช้ในชีวิตประจำวัน

EMS สายด่วนฉุกเฉิน | Emergency Medical Service

เรียนรู้ระบบการแพทย์ฉุกเฉิน บทบาทบุคลากร การขนย้ายผู้ป่วย และการช่วยเหลือเบื้องต้นในภาวะฉุกเฉิน เพื่อเพิ่มโอกาสรอดชีวิตของผู้ป่วย

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

• Link to facebook
• Link to linkedin
• Link to twitter
• Link to youtube
• Writing Tips

Assignment Tracker Template For Students (Google Sheets)

6-minute read

• 18th May 2023

If you’re a student searching for a way to keep your assignments organized, congratulate yourself for taking the time to set yourself up for success. Tracking your assignments is one of the most important steps you can take to help you stay on top of your schoolwork .

In this Writing Tips blog post, we’ll discuss why keeping an inventory of your assignments is important, go over a few popular ways to do so, and introduce you to our student assignment tracker, which is free for you to use.

Why Tracking Is Important

Keeping your assignments organized is essential for many reasons. First off, tracking your assignments enables you to keep abreast of deadlines. In addition to risking late submission penalties that may result in low grades, meeting deadlines can help develop your work ethic and increase productivity. Staying ahead of your deadlines also helps lower stress levels and promote a healthy study-life balance.

Second, keeping track of your assignments assists with time management by helping prioritize the order you complete your projects.

Third, keeping a list of your completed projects can help you stay motivated by recording your progress and seeing how far you’ve come.

Different Ways to Organize Your Assignments

There are many ways to organize your assignment, each with its pros and cons. Here are a few tried and true methods:

• Sticky notes

Whether they are online or in real life , sticky notes are one of the most popular ways to bring attention to an important reminder. Sticky notes are a quick, easy, and effective tool to highlight time-sensitive reminders. However, they work best when used temporarily and sparingly and, therefore, are likely better used for the occasional can’t-miss deadline rather than for comprehensive assignment organization.

• Phone calendar reminders  

The use of cell phone calendar reminders is also a useful approach to alert you to an upcoming deadline. An advantage to this method is that reminders on your mobile device have a good chance of grabbing your attention no matter what activity you’re involved with.

On the downside, depending on how many assignments you’re juggling, too many notifications might be overwhelming and there won’t be as much space to log the details of the assignment (e.g., related textbook pages, length requirements) as you would have in a dedicated assignment tracking system.

• Planners/apps

There are a multitude of physical planners and organization apps for students to help manage assignments and deadlines. Although some vow that physical planners reign superior and even increase focus and concentration , there is almost always a financial cost involved and the added necessity to carry around a sometimes weighty object (as well as remembering to bring it along with you).

Mobile organization apps come with a variety of features, including notifications sent to your phone, but may also require a financial investment (at least for the premium features) and generally will not provide substantial space to add details about your assignments.

• Spreadsheets

With spreadsheets, what you lose in bells and whistles, you gain in straightforwardness and customizability – and they’re often free! Spreadsheets are easy to access from your laptop or phone and can provide you with enough space to include whatever information you need to complete your assignments.

There are templates available online for several different spreadsheet programs, or you can use our student assignment tracker for Google Sheets . We’ll show you how to use it in the next section.

How to Use Our Free Writing Tips Student Assignment Tracker

Follow this step-by-step guide to use our student assignment tracker for Google Sheets :

• Click on this link to the student assignment tracker . After the prompt “Would you like to make a copy of Assignment Tracker Template ?”, click Make a copy .

Screenshot of the “Copy document” screen

Find this useful?

Subscribe to our newsletter and get writing tips from our editors straight to your inbox.

2. The first tab in the spreadsheet will display several premade assignment trackers for individual subjects with the name of the subject in the header (e.g., Subject 1, Subject 2). In each header, fill in the title of the subjects you would like to track assignments for. Copy and paste additional assignment tracker boxes for any other subjects you’d like to track, and color code the labels.

Screenshot of the blank assignment template

3. Under each subject header, there are columns labeled for each assignment (e.g., Assignment A, Assignment B). Fill in the title of each of your assignments in one of these columns, and add additional columns if need be. Directly under the assignment title is a cell for you to fill in the due date for the assignment. Below the due date, fill in each task that needs to be accomplished to complete the assignment. In the final row of the tracker, you should select whether the status of your assignment is Not Started , In Progress , or Complete . Please see the example of a template that has been filled in (which is also available for viewing in the Example tab of the spreadsheet):

Example of completed assignment tracker

4. Finally, for an overview of all the assignments you have for each subject throughout the semester, fill out the assignment tracker in the Study Schedule tab. In this tracker, list the title of the assignment for each subject under the Assignment column, and then color code the weeks you plan to be working on each one. Add any additional columns or rows that you need. This overview is particularly helpful for time management throughout the semester.

There you have it.

To help you take full advantage of this student assignment tracker let’s recap the steps:

1. Make a copy of the student assignment tracker .

2. Fill in the title of the subjects you would like to track assignments for in each header row in the Assignments tab.

3. Fill in the title of each of your assignments and all the required tasks underneath each assignment. 

4. List the title of the assignment for each subject and color code the week that the assignment is due in the Study Schedule .

Now that your assignments are organized, you can rest easy . Happy studying! And remember, if you need help from a subject-matter expert to proofread your work before submission, we’ll happily proofread it for free .

Share this article:

Post A New Comment

Got content that needs a quick turnaround? Let us polish your work. Explore our editorial business services.

5-minute read

Free Email Newsletter Template (2024)

Promoting a brand means sharing valuable insights to connect more deeply with your audience, and...

How to Write a Nonprofit Grant Proposal

If you’re seeking funding to support your charitable endeavors as a nonprofit organization, you’ll need...

9-minute read

How to Use Infographics to Boost Your Presentation

Is your content getting noticed? Capturing and maintaining an audience’s attention is a challenge when...

8-minute read

Why Interactive PDFs Are Better for Engagement

Are you looking to enhance engagement and captivate your audience through your professional documents? Interactive...

7-minute read

Seven Key Strategies for Voice Search Optimization

Voice search optimization is rapidly shaping the digital landscape, requiring content professionals to adapt their...

4-minute read

Five Creative Ways to Showcase Your Digital Portfolio

Are you a creative freelancer looking to make a lasting impression on potential clients or...

Make sure your writing is the best it can be with our expert English proofreading and editing.

• Real Estate

Home » Report Templates » Organize Your Study Schedule with this Assignment Planner Template (Excel / PDF)

Report Templates

Organize your study schedule with this assignment planner template (excel / pdf).

An assignment planner template is a useful tool that enables you to organize your assignments and complete them on time. Having this tool is beneficial for both the students and the people who are assigned to work on a specific project over a specific period.

Furthermore, the assignment planner streamlines your process of planning the assignment and ensures an organized approach to your work. Using this template improves time management, reduces stress, and enhances the quality of your assignment.

Why should you use the assignment planner template?

The assignment planner template provides you with an effective way to manage your assignments. Anyone whose aim is to achieve academic or professional success should use this template. It ensures that your assignment is comprehensive and aligned with the set objectives. The planner helps you improve time management skills and key competencies that are crucial in both academic and professional settings. In addition, it enables you to break down complex tasks into manageable steps so that you can complete your task systematically. Also, it improves the quality of your final product by reducing the last-minute rushes.

Important components of the assignment planer:

The assignment planner should include the following details;

Assignment overview

In this section, you have to specify the assignment’s main topic or question. Describe your assignment precisely to avoid confusion.

Mention the due dates in front of each assignment so that you know how much time you have to complete them. You can organize them according to your priority level.

Completion status

When you keep track of your assignment status, it informs you which work you have started, are in progress, is completed, or require revision.

Subject and type

Classify your assignments into their respective subjects or group them by type.

School assignment planner:

An assignment planner is very important for the students as they are mostly bound to have assignments. It provides them with due dates for different assignments that they have to do. The planner can be used as a timeline that makes sure the students are on time in terms of the assignments.

Assignment Planner Excel Template

Assignment Planner Template Excel

Assignment Schedule Template

Free Printable Assignment Planner

Printable Weekly School Assignment Planner Template

School Assignment Schedule Template

Student Assignment Planner Template

Weekly Assignment Planner Template

Work assignment planner:

Professionals can use the work assignments planner to record special projects if they are assigned to do a lot of tasks daily . Also, they use it to write additional responsibilities that are assigned to them by the company. The planner also helps them in managing their time.

The assignment planner template can be used by students , researchers, and professionals who have been assigned different assignments along with the due dates.

You May also Like

Sharing is caring!

I am Ryan Duffy and legal writer. I received a bachelor of business administration (BBA) degree from London Business School. I have 8+ years of writing experience in the different template fields and working with ExcelTMP.com for 7 years. I work with a team of writers and business and legal professionals to provide you with the best templates.

Get the Reddit app

Welcome to Purdue!

COLLEGE TIP: The Assignment Tracker [FREE]

Whether you’re an incoming first year student or entering your senior year, having one place to reference all of your assignment due dates is a great way to make sure you start your semester off strong.

Last summer, I developed the HHSStudentLife Assignment Tracker, which is a Google Sheets template that allows students to enter assignment information from their syllabi in one place to keep track of readings, homework, lab reports, projects, exams, and more. The Assignment Tracker is available for FREE, and features full customization, instructions for use, and a lot of other fun stuff, like:

A place to add your classes, schedule, and professors.

Percent completed calculator for assignments, per class and overall.

Automatic formatting based on assignment status, class, and assignment type.

A warning when an assignment is due in two days or less.

A calendar that auto populates assignment due dates from your masterlist.

A to do list that you can transfer tasks to from your masterlist with the click of a button.

Grade tracking.

If this interests you, head over to @HHSStudentLife on Instagram or click the link below to make your own copy and get started!

Assignment Tracker Link

By continuing, you agree to our User Agreement and acknowledge that you understand the Privacy Policy .

Enter the 6-digit code from your authenticator app

You’ve set up two-factor authentication for this account.

Enter a 6-digit backup code

Create your username and password.

Reddit is anonymous, so your username is what you’ll go by here. Choose wisely—because once you get a name, you can’t change it.

Reset your password

Enter your email address or username and we’ll send you a link to reset your password

Check your inbox

An email with a link to reset your password was sent to the email address associated with your account

Choose a Reddit account to continue

• -3 more templates
• No results for

University / assignment tracker | aesthetic

About this template

Looking for a streamlined system to effectively keep track of assignments, manage coursework, and fully embrace college/university life by ensuring productivity and avoiding backlogs? I've created a free aesthetic university/assignment tracker to help you stay organized and achieve your goals. I hope you find it helpful!

• Back to school
• Student Life
• Student Planner
• Study Planner

About this creator

• Email the creator

More by Aishi

More like this.

College Organizer

University Dashboard

Student Dashboard

Zen Treasure

Featured in