Downloading data

1. In a web browser, go to the University of Pittsburgh Comparative Archaeology Database at http://www.cadb.pitt.edu/.
2. Click Datasets by Goegraphic Region >>.
3. Scroll down to the CENTRAL AMERICA section.
4. Click on the dataset assigned to your project group: Rio Tonosi Valley, San Ramón de Alajuela, Masaya, OR Volcán Barú. (NOTE: The demonstration was performed using Upper Térraba.)
5. Scroll down to THE DATASET section.
6. Under the Spatial Information section, the coordinate system is listed. Record this information.
7. Under the Spatial Information section, click Collection lots:.
8. Click the DXF file link to download.
9. On the browser, click the back button to return to your main dataset webpage.
10. Under the Numeric Data section, click ?
11. Scroll to the bottom and click the XLS file link to download

...

1. Add formatted Excel spreadsheet
2. Right-click Lots_withID > In the Contents pane, right-click the LotsWithIDs layer and select Joins and Relates > Add Join.
3. For 'Layer Name or Table View' keep Lots with id
4. For 'Input Join Field', scroll down to the very bottom and select TxtMemo
5. For 'Join Table', selcet select outside Excel table
6. For 'Output Join Field', Select Lot, exact name is in Google spreadsheet.
7. In the Contents pane, right-click the LotsWithIDs layer and select Attribute Table. Scroll to the right and ensure that your variables are appearing okay.
8. (Can repeat the join process with multiple tables to create a single mega-table)

Symbology Topics

1. Variables: Total sherds
2. Total sherds for each time period, pick 2 that contrast well for demo
3. Decorated in one period, normalized by total in one period to symbolize percent decorated in that period

Make Group Layers

1. Right-Click on Map and select New Group Layer.

Symbology Instructions

1. In the Contents pane, right-click the LotswithID layer name and selectSymbology to open the Symbology pane on the right.
2. For primary 'Primary symbology', use the drop-down menu to select select Graduated Colors (assuming you have numeric data).)
3. For 'Field', select variable of interest.use the drop-down menu to select your Field of interest (e.g. Total Sherds). 
4. For MethodsClassification methods, previewing Natural Breaks is default, also try Quantile, then think about both implications of numbers and also rounding to easy numbers if exact statistical breaks are less important than quick interpretation by your reader.
5. number of classes, we recommend 3 or 4 if possible, no more than 5 unless you spend a lot of time customizing the colors
6. 5/10/25/100 for total sherds
7. Color ramps, format color scheme and triangle button to flip ramp, show adjusting individual colors in the ramp
8. More drop-down > In the Symbology pane, at the top-right of the Symbol table, click More and select format all symbols, properties tab, change outline color and/or width
9. For full zoom out, might want to completely remove borders
10. In Contents pane, copy lots with id layer and right-click Map at top of Contents pane and paste, do 3 copies for 4 total (Chirqui Decorated/Chiriqui sherds) (Total quebradas vs total chiriqui)
11. The symbology pane applies to whichever layer is selected in the Contents pane,

Normalized Graduated Colors

1. In the Symbology pane, for 'Normalization', For normalization, optionally select the population universe field, if a percentage is desired.
2. Click Advanced symbol options button (4th button with paintbrush) at top of Symbology pane.
3. Expand Format labels, for category, select Percentage.
4. Change radio button to Number represents a fraction if you values are between 0 and 1.
5. For decimal places, pick something like 0 or 1.

Copy layers

1. In the Contents pane, right-click the LotsWithID and select Copy
2. At the top of the Contents pane, right-click the name of the map, likely "Map" and select Paste. This can be repeated for as many layers of interest.

Notes

1. What are they handing in?
   1. Appendix, inset, side x side frames
   2. directional dist, opt hot spot, cluster outlier, kernal density