Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Excerpt

This guide walks helps you through making a dynamic timeline in Mandala Visuals. We'll show you how to set up your spreadsheet, then use that data in Visuals. Then, you'll use customization settings to make your timeline look the way you want.  The final timeline will look something like this:

 

To create a

create a collaborative, student-crowdsourced timeline in Mandala Visuals.

Image Added

John Alexander used this timeline for the course he co-taught with Walt Heinecke "Documenting UVA's Future." This course, inspired by the ouster and reinstatement of UVA President Teresa Sullivan, documented the event using oral histories.

Since many students were not in Charlottesville for the ouster, John Alexander helped them make a collaborative timeline of the proceedings in class, which included links to primary sources. This helped them understand the flow of information surrounding the ouster. Afterward, he shared the timeline with his students, so that they could reference it throughout the semester.

To make a crowdsourced timeline: 

  1. Create a Google Spreadsheet
  2. Enter your data 

  3. Format your spreadsheet 
  4. Log in

...

  1. to Visuals

...

  1. Create a new visualization
  2. Invite student contributions in class

  3. Add the visualization to UVaCollab

In this guide, Google and the Google logo are registered trademarks of Google Inc., used with permission.

Anchor
create
create
1. Create a Google Spreadsheet

Visuals pulls data from your Google account to make visualizations. To start making a timeline, put your data into Google Sheets. 

First, go to docs drive.google.com. You'll see the Google log in page.

You can use any Google address as the account. Remember, UVA students have "@virginia.edu" addresses that work with Google Drive.

Section
Column
width50%

Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Modified

Column
width50%

 

 

 

 

Enter your email, then click Next

Log in with your Netbadge credentials. You'll see the University of Virginia Google Drive page (or the standard Google Drive page if you entered a non-UVa UVA address).

Section
Column
width50%

Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Modified

Column
width50%

 

 

 

 

Click New, then Google Sheets to make your new spreadsheet.

Section
Column
width50%

Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Modified

Column
width50%

 

 

 

This is where you will enter your data. Before you start that process, however, you should make your spreadsheet accessible to Audio-Video. To do this, click Share in the top right corner. Make sure to title your spreadsheet if you have not done so.

Section
Column
width50%

Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Modified

Column

 

 

Then, Get shareable link. This automatically turns on link sharing. 

...

The default setting restricts sharing to UVA viewers. We need to make a few more changes so anyone with a link can access your data. If you're not using a UVA standard "@gmail.com" Google Drive Accountaccount, simply change Anyone at with the link can view to can edit. Then you can skip ahead to the next section. If you're using a UVA-affiliated account, continue reading. 

Section
Column
width50%

Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Modified

Column

 

 

 

First, click Anyone at UVa with the link can view. You'll see extra options. Click More to see all privacy options.

Section
Column
width50%

Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Modified

Column

 

 

 

 

Choose On - Anyone with the link, then Savethen make sure "Access" is set to Can edit. Then, you can Save these settings. Click Done to finish adjusting privacy settings.

...

Here, we're making a simple spreadsheet. 

Section
Column
width50%

 Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Added

Column
width50%

 

Enter  Enter all required labels at you need on the top row of the spreadsheet. These are:

  • title
  • description
  • startdate
  • enddatelink

You'll leave the rows themselves blank. In class, each student will add a row to the spreadsheet, creating a single event. Before they can do that, however, you should make sure rows are formatted correctly. 

Anchor
format
format
3. Format your spreadsheet

If you pull up our Timeline reference guide, you'll see that the first row you filled out contains data labels. We need to “freeze” this row. "Freezing" helps Audio-Video read the data you entered.

Section
Column
width50%

 

Column

 

 

To freeze the first row, click View in the top menu, then Freeze. Choose 1 row. A gray line will appear under this row.

 

The Timeline reference guide also has specific data types for each column. Luckily, our example is easy: every column should be in the "plain text" data type.

Section
Column
width50%

 Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Added

Column
width50%

 

 

 

To set the data type, select your column. Click Format from the menu, then Number. Choose Plain Text. Do this for each column.

...

.


Anchor
log-in
log-in
4. Log in to Visuals

Go to Visuals at https://visuals.shanti.virginia.edu

 

Section
Column
width50%

 Image Added

Column
width50%

 

 

 

Click on the Main Menu icon icon (  ) in the top right corner. Then, Log in via Netbadge. 

 

 Enter your Netbadge credentials to finish logging in. Now we'll make your visualization.

Anchor
create-time
create-time

...

5. Create your timeline 

...

Make sure to log in before making your timeline. Then: 

Section
Column
width50%

 Image Added

Column
width50%

 

 

Click  Image Added> Collections > Create. A list of visualization types will open.

Section
Column
width50%

Column

 

 

 

 

Choose Relationships, then Create under "Timeline."


You'll see the visualization editor and a preview of your timeline. Now we need to add your spreadsheet to the editor.

Section
Column
width50%

Image Added 

Column
width50%

 

 

 

Find the "Source of events" field and click on the

...

triangle Google Drive icon

...

 next to it. 

You'll see a list of your Google Drive accounts. Log If prompted, log in to the account that holds your data spreadsheet. Google  Google will ask if you give Shanti permission to see your files: click Allow.  You may not have to do the last two steps: you might see your Google Drive files directly.

click Allow. You'll see a Google Drive window in Visuals with a list of your files.  

Section
Column
width50%

 Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Modified

Column




Select the spreadsheet you made in step 1. 

Since your students fill in the events, you won't see any information on the timeline. You might also notice that the range of times in the window dondoesn't suit your needs. You want the timeline to show all the dates your students add your student's events at first view. 

Section
Column
width50%

 Image Added

Column
width50%

 

 

First, set "Center date of timeline." In our case, we checked UVA Magazine's timeline

...

 of the ouster and realized that events happened in a window between June 8,

...

 2012 and June 29, 2012. Therefore, we centered the timeline on June 18, 2012. Since according to the visualization index you use a DD/MM/Year format for "Center date

...

of timeline,"

...

we entered 18/06/2012.

However, the scope of the timeline still isn't quite right. The ouster happened over the course of a month, but we are zoomed out to the level of years in the timeline.

We can adjust this scope using "Initial zoom of timelineof timeline." Since the value of this field is tricky to determine, we'll create two reference events for the "beginning" and "end" points of our timeline, then adjust the value of "Initial zoom." 

Section
Column
width50%

Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Added 

Column

First, go back to the spreadsheet. We're going to create two events – one with

...

a start date of June 8,

...

 2012 and one with

...

a start date of June 29, 2012. We'll call the first event "start" and the second event "end." Don't worry about names too much – these are temporary reference points, and we'll delete them at the end. Use the DD/MM/Year format for the dates.

 

Now go back to the visualizations editor. Adjust the "Initial zoom of timeline" by small increments, increasing the value to zoom out, decreasing the value to zoom in, until you can see the "start" and "end" events at the opposite ends of the timeline.

Section
Column
width50%

 Image Added

Column
width50%

 

 

 

 

Here are the values we ended up with. Notice we also had to adjust "Center date of timeline

...

" by a few days.

Notice the text "start" and "end" are a bit large. Remember, you're going to have to have students recording many events on this timeline. To set the size of the font, we're going to make a column called "importance." 

Section
Column
width50%

Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Added

Column

 

 

 

Enter "importance" in the first row of column E, then give all rows in the column a value of 20. 

Section
Column
width50%

 

Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Added
Column
width50%

 

 

 

 

Now "hide" the column to prevent your students from worrying about this value. Visuals can still read data in hidden columns. To hide column E, select the entire column, then right click on it and choose Hide from the menu.

Section
Column
width50%

 Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Added

Column
width50%

 

 

 

 

This is the hidden column. To unhide this data, click on the two arrows (< >) between columns D and F. 

Section
Column
width50%

 Image Added

Column
width50%

 

 

 

When you go back to your visualization, you'll see "start" and "end" are now smaller.  

To finish, make sure that "Minimum zoom of timelineof timeline" and "Maximum zoom of timelineof timeline" are considerably  are considerably smaller and larger, respectively, than the initial zoom value. This lets your students scroll in and out. 

That looks a lot better. Now we can see all the events in the default viewNow you can be sure all your student events will be visible in class. Remember, you can always zoom on the finished timeline. This method just helps you set the general scope

The timeline still isn't very informative, however – how will viewers understand the significance of events? Let's make the visualization show a description of the event, which we entered your students enter in column B of our your spreadsheet. 

Section
Column
width50%

Image Added

Column

 

 

 

To do this, change Show the description from false to true. Now when a viewer clicks on an event, a description will pop up

...

. In the example, we've also entered the "Title of timeline."

Now we're done .

Section
Column
width50%

 

Column

 

 

 

This is what your timeline should look like.

with the main visualization.

Remember, you can find out more about the different options for your timeline with the Visualization Index

To finish making your timeline, give the visualization record a title in the "Title" field at the top of the page, then choose Public under the "Visibility" options at the bottom of the page. Making the timeline public lets you add it to UVaCollab in step 8

Switch the status of the timeline from Draft to Published at the top of the page. Then, Save your visualization. You're all ready for your class to create a collaborative timeline together. 7

Anchor
invite
invite
 6. Invite student contributions in class

For the class, you should have a way to project your visualization. Once you've set up the projector, you can open your visualization by logging into Visuals, then: 

Section
Column
width50%

 Image Added

Column
width50%

 

 

 

Click Image Added> My Content > My Visualizations. You'll see a list of all your visualizations. Click on your timeline to open it.

Before the class, ask your students to bring:

...

Share the timeline spreadsheet with your students. To do this, you should use the URL of the spreadsheet at Share > Copy Link in Google Sheets. If you've followed the spreadsheet setup process correctly, all your students need is the URL of the document to edit it. 

Section
Column
width50%

Google and the Google logo are registered trademarks of Google Inc., used with permission.Image Added

Column
width50%

 

 

 

In class, you can ask each of your students to add their event in a new row of the spreadsheet, like so

...

. 

You'll see the timeline grow gradually, giving your students a sense of how information flows through time. 

You can make this timeline available to your students after class in UVaCollab. 8

Anchor
uvacollab
uvacollab
7. Add the timeline to UVaCollab

Open Now, we'll add the timeline your students created together to UVaCollab. This lets them reference the data throughout the semester. To begin, open your class site in UVaCollab.

Section
Column
width50%

 Image Added

Column
width50%

 

 

 

Go

...

to Resources

...

 in the sidebar.

Section
Column
width50%

Image Added

Column
width50%

 

 

 

Find the folder where you want to add the timeline.

...

 Next to the folder's name,

...

click Actions,

...

then Create HTML Page.

...

An editing tool will open. 


Now you need to fetch your timeline from Visuals. To do this, open the visualization, then click the Share icon (Image Added).

Section
Column
width50%

Image Added 

Column
width50%

 

 

 

From the window that opens,

...

click iFrame. This tab contains HTML code that will let you embed your timeline directly into the new UVaCollab HTML page. Copy the code and return to UVaCollab. 

To insert the code into the page, you need to switch the UVaCollab editor mode to edit HTML.

Section
Column
width50%

Image Added 

Column

 

 

 

 

To do so,

...

click Sources

...

 in the editor toolbar.

Section
Column
width50%

 Image Added

Column
width50%

 

 

 

 

Paste the iFrame code into the editor, then Continue.

You'll see a form with metadata fields, where you can add a title and restrict access to your HTML page. Then, paste the code from Visuals and Continue.   Fill out the fields as needed, then Finish. The new page will appear under the Resources. If you click on the site, you'll see the interactive timeline your students created collaboratively

This code also lets you add the visualization to a WordPress course site. Follow the Add an iFrame guide for help

Now you're finished with your project. To learn more about making visualizations, you can use this Visuals in Mandala guide. 

...