SeeIt3 Correlations Tutorial (Work in Progress)

One or Two Graph View

To display two graphs on screen, click the "Two Graphs" button in the bar at the top of the screen. To display only one graph, clikc the "One Graph" button in the top bar, or click the "X" button in the top right of the graph your want to remove.

Remove

To remove a graph, click the "X" button in the top right corner.

Display Options

The "Display Options" button in the top bar will open a menu where the appearance of SeeIt can be altered. The size of dots used in the graphs can be increased or decreased, as well as the size of text. Graphs can be displayed in black and white for compatibility with printers by selecting the "Black" checkbox. Data points can be displayed as solid or as colored rings by selecting the "Solid" checkbox. Additionally, the data points may be hidden entirely so that other visualizations can be more clearly seen. To hide data points select the "Hide" checkbox. To close the display menu, either click the "Display Options" button a second time, or click the "X" button in the top right of the menu.

Graph Options

The wrench icon at the top left of a graph allows you to specify different visualizations. These will be covered in more details in Section 2 and 4.

Worksheets

Data is divided into worksheets which have been imported from Google Documents or created in SeeIt. Click the worksheet's title in the data menu to expand it and reveal its options and the categories it contains.

Categories

Each Worksheet contains several categories of data which are titled and assigned colors.

Adding Data to Graph

To view a category of data in a graph, simply click and drag a category from the dataset menu to the X or Y axis of the graph you want to add to. To remove a category from a graph, click and drag the category off the side of the screen to remove it completely, or drag it another axis or another graph to move it there.

Edit

The pencil icon under each worksheet's title opens a menu that shows that worksheets data in a tab separated table. This menu will be covered in more detail in Section 3.

Refresh

If you have made changes to the data in a worksheet loaded from Google Documents and want to reload it, click the circular arrow icon below that worksheet's title.

About

A worksheet can include text with a description of data it contains. To view this description click the question mark icon below a worksheet's title. To close the description window, click the question mark button again, or click the "X" button in the top right corner of the description window.

Link to Google

To view a worksheet with Google Documents click the document icon below that worksheet's title.

Formats Allowed

Data is formatted as rows of entries separated by tabs or commas but not both. The top row designates the titles of each category, and any row after the first contains data. The leftmost column contains labels for datapoints. Data is displayed in the edit menu in a way that makes it easy to copy and paste directly into a spreadsheet. Columns may not be properly aligned when viewed in the edit menu.

Delete

To remove an entire worksheet from the data menu, click the delete button at the bottom of the worksheet edit menu, and click yes on the confirmation dialogue that appears.

Label or no Label

When creating a new dataset, you can choose to not specify labels for data by unchecking the "First Column is Label" checkbox. If you uncheck this option, the leftmost column will be considered the first category of data. A default label will be assigned to any data entered in this way.

Using a Link

If you have data saved in a Google Documents spreadsheet, and the spreadsheet has been published (covered in the next section) you can add the spreadsheet to SeeIt by opening the add worksheet menu, clicking the "Load worksheet from URL" button, pasting the link to the google spreadsheet in the textbox that appears, and clicking the "Submit" button.

Formatting

SeeIt requires data imported from Google Documents spreadsheet to be in a specific format. The left most column contains labels for the data in each row. The top left cell is for the title of the labels. For instance, the top left cell could contain the word "State" indicating that the labels in the leftmost column correspond to different states in the U.S. The top row of the spreadsheet, excluding the leftmost cell, contains the titles of the categories of data. The cells below each category title contain the data in the that category. Finally, to include a description of the data which can be read in SeeIt, place text beginning with "*" in the cell below the last label in the leftmost column.

Permissions and Publishing

For a Google Documents spreadsheet to be imported into SeeIt it must be published to the web. To do this, in the Google spreadsheet click File and then click the "Publish to the Web..." option. In the menu that appears click the "Start Publishing" button. Now the URL for the spreadsheet can be pasted into SeeIt.

Paste or Link

Alternatively, you can copy the contents of a Google spreadsheet and paste it into the textbox in the add worksheet menu.

Adding Via URL

A spreadsheet can be imported into SeeIt automatically as it loads by using a special URL. At the end of the URL to SeeIt Correlations

http://centerforbiophotonics.github.com/SeeIt3/correlationsv3.html

add a questions mark followed by the URL of the spreadsheet you want to load. For example:
http://centerforbiophotonics.github.com/SeeIt3/correlationsv3.html?https://docs.google.com/spreadsheet/ccc?key=0AuGPdilGXQlBdHRyYlc4c2RFZllZY2J2RXdhUmFOX1E#gid=0

The link above will load SeeIt with two additional worksheets pre-loaded.

By Text

To change the scale of a graph, first click the wrench icon in a graph to bring up the graph options. To change the lower bound of a graph enter a number in the "Min" textbox. To change the upper bound of a graph enter a number in the "Max" textbox. If you enter a number in the "Min" textbox that is larger than the number in the "Max" textbox, or visa-versa, the value will revert to the whatever it was previously.

Fitting Scales to Data in a Single Graph

To set the scale of a graph to closely fit the data it contains, first click the wrench icon in a graph to bring up the graph options, then select the "Fit scales individually" checkbox.