Mr. Dillon's Technology Class

Assignments

Home | Register for hotchalk | Meet Mr. Dillon | Assignments

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