Skip to content

1. Introduction to Create a Study Schedule to Meet Your Goals

Playback Speed:

Setting short or long term goals is a great way to improve yourself.

But you also need a plan to reach your goal.

If you want to get a job, go to college, or get a better grade on an exam and you don’t have a plan, you won’t reach those goals.

A step-by-step plan to reach your goal makes that goal feel reachable and motivates you to start working.

In this lesson, your goal is to build better study habits and improve your test scores.

You will create a study schedule in a spreadsheet to help track your study habits.

Spreadsheets are useful for categorizing and organizing data.

You will format a spreadsheet to make it easier to organize and track your study schedule.

Then you will add tasks — or steps — you can take to help reach your goal.

For example, studying notes and taking a practice test.

You will also assign due dates. Setting a due date for each step in the process is one way to make sure you meet your final deadline and don't miss any steps along the way.

Then, set up statuses so you can track each task.

This lesson uses Google Sheets, but you can use any spreadsheet application you like, or even a piece of paper or notepad.

As you complete this lesson, you will: Create a new spreadsheet, Format columns, Work with text, Use data validation to limit entries for a cell, And format numbers as dates.

To begin, sign in to your Google account.

If you don’t have a Google account, create one before beginning this activity.

Then, open a new tab in your browser.

Navigate to Google Drive, and create a new, blank spreadsheet in Google Sheets.

Name your spreadsheet. Then, move on to the next video to start the first activity.

Now, it’s your turn: Create a blank spreadsheet in Google Sheets, and rename it.


  1. Create a blank spreadsheet in Google Sheets.
  2. Rename it.