Page History

...

1. remove original lots, polygon, annotation

2. Figure out whether to do this in class or outside meetings or follow written instructions

3. TxtMemoClean

   TxtMemo.strip()

    

4. After join, show sort missing and reverse join to see which don't have it, or symbolize by join count (we don't have time for data cleaning)

5. Export with join

Data Cleaning

How to replace nulls with zero so that the variables show up.

Joining

1. Add formatted Excel spreadsheet
2. Right-click Lots_withID > Joins and Relates > Add Join.
3. For Layer Name or Table View keep Lots with id
4. For Input Join Field, select TxtMemo
5. For Join Table, selcet outside Excel table
6. For Output Join Field, Select Lot, exact name is in Google spreadsheet.

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

Symbology Instructions

1. In the Contents pane, right-click the LotswithID layer name and select Symbology to open the Symbology pane on the right.
2. For primary symbology, use the drop-down to select Graduated Colors (assuming you have numeric data.)
3. For Field, select variable of interest.
4. Classification 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 > 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
11. The symbology pane applies to whichever layer is selected in the Contents pane,
12. For normalization, optionally select the population universe field, if a percentage is desired.
13. Click Advanced symbol options button (4th button with paintbrush) at top of Symbology pane.
14. Expand Format labels, for category, select Percentage.
15. Change radio button to Number represents a fraction if you values are between 0 and 1.
16. For decimal places, pick something like 0 or 1.

Notes

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