Versions Compared

Key

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

...

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 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.

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 Google Drive Account, simply change Anyone at with the link can view to can edit. Then you can skip ahead to the next section. 

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 Save. 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 Modified

Column
width50%

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

  • title
  • description
  • startdate
  • link

...

The Timeline reference guide 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 Modified

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

...

Column
width50%

 

...

width50%

 

 

 

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

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

...

Google will ask if you give Shanti permission to see your files: 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. 

...

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 Modified

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 Modified
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%

 

Column
width50%

 

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

Section
Column
width50%

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

Column
width50%

 

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

...

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 Modified

Column
width50%

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

...