never miss a due date again!
My spring classes start soon so I made a new tracker for this semester! I had some people ask me how to make this on Google Sheets, so here is an easy step-by-step. Let me know if you want me to explain something further!!
📌STEP 1: Add titles for all the columns you want to use.
I have a column for each of the following (5 total): assignment name, course, due date, days left to complete, and status.
📌 STEP 2: Make a drop down menu for your courses.
• Select every row in column B.
• Click on "data" at the top of the menu bar.
• Click on "data validation" and then "add rule."
• Make an option for each of your classes.
• Pick a color for each class.
• Click done to input the drop down menu.
📌 STEP 3: Write due dates for each assignment.
You can put any date you want in cell C2 for right now. This column will be filled out later, but you need something in C2 to complete step 4!
📌 STEP 4: Write the formula for the days left column.
• Click on cell D2.
• Type the following into the formula bar at the top: = C2 - TODAY().
• If you want overdue assignments to say "overdue", then type the following instead: =IF( C2 < TODAY(), "Overdue," DAYS(C2, TODAY()))
📌 STEP 5: Make a drop down menu for assignment status.
• Select all the rows in column E.
• Click on "data"
• Click on "data validation" and "add rule"
• Add the following options: complete, in progress, not started.
• Select a color for each option.
• Click "done."
📌 STEP 6: Input info from your syllabus.
Use the syllabus from each of your courses to add all assignments, papers, quizzes, and tests.
📌 STEP 7: Make it nice and pretty!
• Color every other row for a nice visual appeal.
• Click on "format" on the menu bar and then "turn into table"
• You can also add anything extra to make it aesthetic.
#productivity #college #collegetips #academicsuccess #planner
Creating an assignment tracker in Google Sheets can significantly improve your academic productivity. With a structured layout, you can effortlessly manage due dates for your courses, including papers, quizzes, and exams. This tracker enhances organization, allowing students to visualize their workload and prioritize tasks accordingly. To start, customize your columns for assignment names, courses, due dates, days left, and status. Implement dropdown menus to make data entry quick and efficient. You'll want to write formulas to automatically calculate how many days are left until each deadline. For example, using =C2 - TODAY() allows you to track upcoming due dates easily. In addition to the basic steps, consider adding conditional formatting to automatically highlight overdue assignments. This visual cue will prompt you to take action and helps maintain focus. Also, actively input information from your syllabus; this increases your accountability and reduces the likelihood of overlooking critical deadlines. Another useful tip is to celebrate your progress by updating the completion status of each assignment. This self-motivation can keep you on track and make the learning experience more rewarding. Lastly, making your tracker visually appealing with color coding and table formats adds a personal touch that makes the process enjoyable. By following these strategies, managing your academic responsibilities will become less daunting.
@bay @MacKenzie ✨♋️ here's that tutorial i promised! hope it's helpful!! 💚