Transcript Timelines in the Science Curriculum

Timelines in the
Science Curriculum
Kaye Placing
UniServe Science
July 2008
Examples taken from
Science Focus 3 & 4 (2004)
published by
Pearson Education Australia:
 Construct a time line of major [volcanic]
eruptions in the last century.
 Research gene switching and gene expression.
You could start by considering the work of F.
Jacob, J. Monod and H. Harris. Summarise
your findings using a time line.
 Research the lives of the Curies and use a time
line to summarise key events in their lives.
Timelines in Science
http://science.uniserve.edu.au/school/profdev/timelines/
 Examples of science based timelines available




on the Web;
Web sites for developing simple paper based
timelines;
Online tutorials for creating more sophisticated
timelines using common application programs
such as Word, Excel and Inspiration;
Interactive timelines; and
Timelines to support NSW syllabuses that have
been developed by UniServe Science using the
some of the resources identified and featured
on the web page.
Application software tutorials
 Excel
 Word
 Inspiration
Using Excel
How to Create a Timeline in Excel
http://www.vertex42.com/ExcelArticles/create-a-timeline.html
Using Excel
How to Create a Timeline in Excel
http://www.vertex42.com/ExcelArticles/create-a-timeline.html
Planck vs Einstein
Einstein publishes three papers
Einstein Nobel
Prize in Physics
Einstein granted Sw iss citizenship
Einstein renounces German citizenship
Einstein resigns from KWI, to Princeton
Einstein w arns of potential German atomic bomb
Einstein graduates
Einstein dies aged 76
Albert Einstein born
Manhattan Project begins
World War I ends
World War II ends
World War I
World War II begins
Hitler appointed Chancellor of Germany (Nazi)
1840
1860
1880
1900
1920
1940
Planck meets Hitler
Max Planck born
Planck
blackbody
radiation
1960
Planck's son, Erw in
implicated in
assassination
attempt on Hitler
Planck Nobel
Erw in killed by Gestapo
Prize in
Physics
Planck President of KWI
Planck signs Manifesto of the 93 Intellectuals, professor University of Berlin
Planck saves KWS from
disbandment, dies aged 89
Planck Professor
University of Berlin
Set Up the Data Table




Open up a new Excel workbook.
Starting with cell B5=1, create a column of numbers 1-10.
Starting with cell C5="Event 1", create a column of event labels.
Set up a column starting with cell E5 that will represent the
heights of the leader lines in the timeline.
 In cell F5, enter the following formula:
=OFFSET($B$4,ROW()-ROW($F$4),0,1,1)
 In cell G5, enter the following formula: =OFFSET($C$4,ROW()ROW($G$4),0,1,1)
 Copy the formulas in F5 and G5 down to F14 and G15,
respectively.
http://www.vertex42.com/ExcelArticles/create-a-timeline.html
Create the Timeline Chart
 Start the Chart Wizard (Insert > Chart...)
 In Step 1, choose the XY Scatter Chart (see image).
 In Step 2, set the X and Y values as follows (see image):
X Values: =Sheet1!$F$5:$F$14
Y Values: =Sheet1!$E$5:$E$14
 In Step 3, do the following in each of the tabs ...
Titles: Leave all fields blank (unless you want a Title)
Axes: Turn off the y-axis
Gridlines: Turn off all gridlines
Legend: Turn off the legend
Data Labels: Turn on the Y values (see image).
 Click Finish
http://www.vertex42.com/ExcelArticles/create-a-timeline.html
Add the Leader Lines









The leader lines are created by adding one-sided error bars to the data series.
Right-click on a data point (not the label) and select "Format Data Series..." to
open the Format Data Series dialog box, or use the Chart toolbar to do the same
thing:
In the Y Error Bars tab, select the Minus display and set the Percentage to 100
(see image).
Select OK. You're done with this part.
Add the Leader Lines
The leader lines are created by adding one-sided error bars to the data series.
Right-click on a data point (not the label) and select "Format Data Series..." to
open the Format Data Series dialog box, or use the Chart toolbar to do the same
thing:
In the Y Error Bars tab, select the Minus display and set the Percentage to 100
(see image).
Select OK. You're done with this part.
http://www.vertex42.com/ExcelArticles/create-a-timeline.html
Add the Timeline Event Labels
 This step is the most tricky if you are new to Excel charts (and
even if you aren't). But, hopefully the images will help explain
things.
 Select the first Data Label (the one on the far left as shown in
the image below).

 Click on the data label once more so that you are editing just
the one label.
 Press the = key, or click inside of the Formula Bar.
 Either type in the reference, or click on cell G5. The result
should look like the following:
 Repeat the first 4 steps for the rest of the data labels.
http://www.vertex42.com/ExcelArticles/create-a-timeline.html
Einstein Planck debate
Albert Einstein
born
1840
1860
Max Planck born
1880
1900
1920
1940
1960
Distance of the planets from the Sun
Pluto
Neptune
Uranus
Saturn
Jupiter
Mars
Earth
Venus
Mercury
0
5
10
15
20
25
Astronomical units
30
35
40
45
Interactive Timelines
 xtimeline
 Timeline creator
 Timeline Tools
 SIMILE Timeline
xtimelines
 http://www.xtimeline.com/
 Beta version
 Web-based
 Free
 Registration necessary
 Timelines are hosted by web site
 Can have public or limited editing
 Public or limited viewing
Examples of xtimelines
 Space exploration
 Development Of the Atomic Theory
 History of Astronomy
 History of Transistors
 Biography of Albert Einstein
 Timeline of Extinctions
 History of the AIDS epidemic
Timelines Creator
 http://timeline.cer.jhu.edu/
 Center for Educational Resources,
Johns Hopkins University
 Download from web site, use locally
 Available for Windows or Macintosh
 View locally or from personal web site
 Player must be present on local
computer for viewing
Timeline Tool
 http://www.learningtools.arts.ubc.ca/timeline.htm
 University of British Columbia
 A web based learning object template which
allows an instructor to quickly construct an
interactive timeline with audio and visual
effects. The finished timeline can serve as a reuseable learning object which can be easily
distributed and shared over the web. This
learning object template is built in Flash, PHP
and XML
SIMILE Timeline
 http://simile.mit.edu/timeline/
 Simile, MIT
Thank you!
Time to explore
http://science.uniserve.edu.au/school/profdev/timelines/
Kaye Placing
[email protected]