|
Objective
Use a Microsoft Office Excel spreadsheet to create a timeline. Here's how:
Create a timeline
|
1. |
Plan your timeline. Do any necessary research, and then sketch out the timeline on paper. |
|
2. |
Start Excel with a new, blank spreadsheet open. |
|
3. |
Type a title across the top of the spreadsheet, and format the text as you like. |
|
4. |
Skip several rows, and then type the first date or time of your timeline. You might want to wait
to format all the dates or times at once. |
|
5. |
Type a short description above or below the date or time cell, whichever works best for your
timeline. |
|
6. |
To format the description so it is turned sideways, on the Format menu, click Cells.
In the Format Cells box, click the Alignment tab (see picture). Select the orientation for the text by clicking
the picture sample or by typing a number in the Degrees box. Change the Text alignment (horizontal or vertical), and
then click OK.
Tip: You
might want to format a group of cells (for example, all cells that should be rotated) at the same time. First select the group
of cells, click Cells on the Format menu, apply the formatting you want, and then click OK. All selected
cells will now be formatted the same. Type your text in those cells and press ENTER. The cells will be rotated automatically
because you preformatted them. |
Project: A Day In The Life of …
Task:
1)
Plan a timeline of your typical school. Include
at least (10) events from your day. For
example, you may include waking up, getting dressed, getting to school etc.
2)
Use Microsoft Excel to create your timeline.
Include a time for each event.
3)
Pay close attention to the rubric below when creating your timeline.
Rubric:
|
|
3 |
2 |
1 |
|
Title |
title is centered and merged across cells A1:R1, the font (type and size) has
been changed, the row height has been changed |
one of these was not done. |
two or more of these were not done. |
|
Timeline |
cells A20:R20 are filled with paint. |
cells A20:R20 are partially filled with paint. |
cells A20:R20 are not filled with any paint. |
|
Events |
includes (10) significant events, labeled with times, borders, and rotated text. (Note: alternate placing events
above and below the timeline to save yourself space for the pictures) |
missing some events, labels, borders, and rotated text |
missing many events, labels, borders, and rotated text |
|
Pictures |
includes (10) pictures from files or clip art |
includes (5-9) pictures from files or clip art |
includes 4 or less pictures from files or clip art |
|
Connectors |
includes (10) connectors from events to timeline |
includes (5-9) connectors from events to timeline |
Includes 4 or less connectors from events to timeline |
|