Making a Calendar

Using Spreadsheets to create a Calendar

1. Complete Learning.com

be sure to complete all lessons on spreadsheet in learning.com

2. Create a "To Do" list for project or activity

In GClassroom- Open Assignment- Add- DOC

In your Google Doc- you will type your list of ten things to do.

Big picture

Write your numbered to do list. Here is an example:

Big picture

3. Create a One Month Calendar

In GClassroom- Open Assignment- click- Add- Sheet

Open your Google Sheet and start creating your calendar:



  1. Choose a month for your project or activity. (any month is fine)
  2. You will need to know how to format cells and make the calendar easy to read.
  • Format Cells by adding borders
  • numbers for the days of the week
  • Merge top boxes to add the month you chose
  • center align text for days of the week
  • Bold your font for Month and days of the week



3. Type the steps of your project or activity on the days you plan to do them.


Proofread your spreadsheet/calendar!

Big picture

4. Turn in!

Turn in GClassroom


  • you should have a GDoc
  • and a GSheet
Big picture