Tip Sheets | Home   

ICT Skills for Teachers (Office 2016 / Office 365)

Create a class timetable (Beginner level)

As an educator, you may like to see your teaching program for a week at a glance. Use Microsoft Excel to create a planning template that you can fill in by hand or electronically, print out, file, and re-use from week to week. In cases like this, where you will be drawing many different lines and columns, Microsoft Excel could be more convenient to use than Microsoft Word.

By the end of this task you could achieve the following outcomes:

Download an example - Enter text into spreadsheet
- Change the appearance of the text
- Adjust row heights and column widths
- Apply borders, colours and shading to cells
- Print the class planner

Create your own class planner - one which you will find useful. Alternatively, follow this example. To do so you would typically work through the following steps:

1. Start Microsoft Excel. See how »
2. Type the text headings: Arrange the labels in the rows and columns so that there is at least a blank row or column between them.
3. Save your Weekly Plan: Remember to save your Weekly Plan regularly. See how »
4. Add or delete rows or columns: You can insert and delete rows and columns if you make a mistake. See how »
5. Modify text: You can change the appearance of text to suit your needs. See how »
6. Insert lines: Use lines to mark the areas in which you need to write. See how »
7. Align the text: In some cases you may want to centre the text in a cell. See how »
8. Save your weekly plan: It is always wise to save before printing. See how »
9. Print the file: Print your weekly plan.
10. Close Microsoft Excel.

Related scenarios

» Write a good news note
» Draw up a budget
» Create curriculum learning resources

Self Assessment  Back to Activities