Download Full Text (918 KB)
Microsoft Excel is extremely useful for many different types of digital scholarship projects. This one looks at the ability of Excel to create time lines for historical projects using an Excel template developed for project time lines. Before starting I will warn the reader that because of the way Excel stores and handles dates, these time lines only work for dates after Jan. 1, 1900. There are some potential fixes for this that I hope to address in the future.
The timeline which was developed for this project can be found at http://chuckkann.com/timelines/excel/Mandela.xlsx. You can download this and see the finished product.
Attached is a pdf files with step-by-step instructions on how to implement this project. Additional material may be available at http://chuckkann.com.
The Microsoft site https://templates.office.com/en-us/Timelines has timeline templates in other formats, but they generally work in a similar fashion to the timeline I am using. So once you have done a time line following these steps, you should be able to handle any Excel formatted time line.
If you do timelines using this document, let me know what you think...
Adult and Continuing Education and Teaching | Curriculum and Instruction | Instructional Media Design | Junior High, Intermediate, Middle School Education and Teaching | Online and Distance Education | Public History
Kann, Charles W. III, "Implementing Time Lines in Microsoft Excel Templates" (2017). Gettysburg College Open Educational Resources. 4.
Adult and Continuing Education and Teaching Commons, Curriculum and Instruction Commons, Instructional Media Design Commons, Junior High, Intermediate, Middle School Education and Teaching Commons, Online and Distance Education Commons, Public History Commons