Beyond 20/20
For advanced users only.

YOU NEED TO HAVE THE BEYOND 20/20 BROWSER DOWNLOADED BEFORE YOU CAN CONTINUE.

1. On the bottom of the web page, click on the Beyond 20/20 Browser icon.
   

2. A box with the heading File Download may appear. You are given the choice to either Open it or Save it to disk, click on Open it and then on OK.
   If any errors occur while the Browser opens, simply click on the 'x' in the top right-hand corner of screen to close it. Click on the Beyond 20/20 Browser icon again.
   

3. The Beyond 20/20 Browser is now open and you should see your information listed under the headings Characteristics and Geography.
   Note: The Beyond 20/20 Browser is not a spreadsheet program.
   

4. Because of the limited screen space, you are not able to see all of your data. Click on the heading Geography, and hold the left mouse button. The shape of the mouse pointer and tile, merge into a downward-pointing arrow contained within a dashed border. Position the pointer over the Characteristics heading and let go of the left mouse button.
   

5. The data under your census tract number should now be displayed vertically. You are now able to read your data and the corresponding variables without any difficulty. (SHOW ME)
   

6. Click Item on your menu bar. Highlight Select All and click on it. All of your data should now be highlighted. The highlighted area is your selected dimension.
   

7. Click View on your menu bar. Highlight Distributions… and click on it. The Distributions dialogue box is displayed. (SHOW ME)
   

8. Under the heading Distribution Items, you have four options listed: Values, Row Distributions, Column Distributions, and Total Distributions.
   

Values Option
You select Value if you want the values of the original (actual) data in your selected dimension to be displayed in your new dimension.

Row Distribution Option
You select Row Distributions if you want the percent distribution of each value displayed in your selected dimension, based on the row's total value.

Column Distribution Option
You select Column Distributions if you want the percent distribution of each value in your selected dimension displayed, based on the column's total value.

Total Distribution Option
You select Total Distribution if you want the percent distribution of each value in your selected dimension displayed, based on the dimension's total value.

9. In this situation, we are going to use the Column Distribution option. Click on the other three options so that only the Column Distribution option has an 'x' beside it. Click on OK.
   

10. You'll notice that values have changed on your table. The values are now in percent. (SHOW ME)
    On the top of your table there is a new title (highlighted) Distributions: Col Pct. This title lets you know that you have formatted your selected dimension using the Column Distribution option to display percent distribution values.
    

11. Click on one of the rows or columns within your dimension to activate the table. Click Item on your menu bar. Highlight Select All and click on it. All of your data should now be highlighted. On your table, click on your right mouse button. Highlight and click on Chart.
    

12. You now have a bar graph on screen with all of the variables chosen.  (SHOW ME)
    

13. On your chart, click on your right mouse button. Highlight and click on Print.
    

14. Click on the 'x' in the top right-hand corner of the chart window to close it.
    

15. Click File on your menu bar. Highlight Save As… and click on it. Be sure that the Browser has been configured to save files on the floppy drive (usually a:\). Type in a filename that captures the essence of the table and press ENTER.
    Click the 'x' in the top right-hand corner of your screen to close the Browser.
    

16. Click on the BACK button once.
    

17. In the Characteristic section, scroll down in the text box to the variable heading Total income of Female non-family persons 15 years and over (approximately three-quarters through the variables). Move down to the next variable and click on it. Hold down your SHIFT key and use your down cursor key to highlight the next 16 variables (i.e. Under $1,000 to/including $60,000 and over …).
    

18. You should now have the variables Under $1,000, …$60,000 and above highlighted.
    Scroll further down the web page. Click on the Geographic List icon.
    

19. You will now see on screen the geographic codes for all of the census tracts for the city you chose. Review the census tract number you want to use by looking at question #1 on Handout #2. Note: your tract number code is the last 5 digits on the right, including the decimal and the two 00's (ex. #065.00). Click on your census tract number.
    

20. Scroll to the bottom of the web page. Click on the Beyond 20/20 Browser icon. Click on Open it and then on OK.
    

21. The Beyond 20/20 Browser is now open and you should see your information listed under the headings Characteristics and Geography.
    

22. Because of the limited screen space, you are not able to see all of your data. Click on the heading Geography, and hold the left mouse button. The shape of the mouse pointer and tile merge into a downward-pointing arrow contained within a dashed border. Position the pointer over the Characteristics heading and let go of the left mouse button.
    

23. The data under your census tract number should now be displayed vertically. You are now able to read your data and the corresponding variables without any difficulty.   (SHOW ME)
    

24. Notice that the variables listed under the heading Characteristics vary in scale. For example, the variable $1,000 - $2,999 (Female 15+) has a $2,000 increment, where the variable $30,000 - $34,999 (Female 15+) has a $5,000 increment. In this workshop, we are going to "create" variables with a $10,000 increment. Our graph will also end up looking a lot better because of the lower number of variables.
    

25. Click on the first variable Under $1,000 (Female 15+). On the bottom of your screen is the status bar. In the status bar, you will notice the heading Active Cell: C1 (characteristic #1). If you press down your down cursor key, the Active Cell will change to C2 consecutively until your last characteristic (C16). C1, C2, …, C16 are called Item Codes.
    

26. Activate C1. On the menu bar, click on Item, then highlight and click on Insert….
    

27. You are now asked to enter an Item Code. In order to create a variable with a $10,000 increment, we need add the values from C1 to C5. So, type in C1+2+3+4+5 for your Item Code. You are now given a choice to insert the item before or after the highlighted characteristic (C1). Click on Before Active Item and then click on OK.   (SHOW ME)
    

28. On your table you will have a blank characteristic with a value of 0. Click on the blank characteristic and notice that on your status bar the active cell is C1+2+3+4+5.
    

29. Click View on your menu bar. Highlight and click on Dimension. The blank characteristic and its item code are highlighted. Click on the blank characteristic. Type in the following: Under $ 1,000 - $ 9,999, (Females 15+). Press ENTER.
    

30. Click on the 'x' in the top right-hand corner of the Insert Item in Characteristics window to close it. Our new characteristic is now displayed on our table.   (SHOW ME)
    

31. Click on the variable Under $ 1,000, (Female 15+). Hold down the left button of the mouse and move your mouse down to highlight the next four variables and then let go of the button.
    The variables Under $ 1,000… to/including $ 7,000 - $ 9,999… should be highlighted.
    

32. Click Item on the menu bar. Highlight and click on Define Group…. The Define Group window will now appear. Notice that the number of Group Members is 5, since we selected five variables on our table. You are now asked to enter a Group Code, which is similar to an Item Code, except that the Group Code defines the cell for the "group" rather than for one variable. Type in C1+2+3+4+5 as your Group Code. Notice that this is the same code given to our inserted item earlier. Since we would like to add the values from this group, make sure that Total - Members of Group are Summed is selected.   (SHOW ME)
    

33. Click on OK. You are now told that the code already exists (the code given to our inserted item), and you are asked if you would like to overwrite it. Click on OK. By doing this, we are assigning the total values from the defined group to this cell.
    

34. On the table, the value in cell C1+2+3+4+5 is still zero. This is because we need to "calculate" the sum of the group defined. Click View on the menu bar. Highlight and click on Calculate. You are now told that the calculation was successful, so click on OK.
    

35. You now have the total value calculated from your group in cell C1+2+3+4+5. Since we have the summed value from the variables Under $ 1,000… to/including $ 7,000 - $ 9,999…, we do not need them on our table any longer. Highlight the five variables.
    

36. Click Item on the menu bar. Highlight and click on Delete Item. You are asked if you would like to proceed with the deletion, click on OK. Even though the five variables are deleted, your value in C1+2+3+4+5 does not change.
    

37. Highlight C6. Click Item on the menu bar. Highlight and click on Insert….
    

38. You are now asked to enter an Item Code. In order to create another variable with a $10,000 increment, we need add the values from C6 to C8. So, type in C6+7+8 for your Item Code. You are now given a choice to insert the item before or after the highlighted characteristic (C6). Click on Before Active Item and then click on OK.
    

39. On your table you will have a blank characteristic with a value of 0. Click on the blank characteristic and notice on your status bar that the active cell is C6+7+8.  (SHOW ME)
    

40. Click View on your menu bar. Highlight and click on Dimension. The blank characteristic and its item code are highlighted. Click on the blank characteristic. Type in the following: $10,000 - $19,999, (Females 15+). Press ENTER.
    

41. Click on the 'x' in the top right-hand corner of the Insert Item in Characteristics window to close it. Our new characteristic is now displayed on our table.
    

42. Highlight cells C6, C7, and C8.
    

43. Click Item on the menu bar. Highlight and click on Define Group…. Notice that we now have 3 Group Members. Type in C6+7+8 as your Group Code. Total - Members of Group are Summed should also be selected. Click on OK. Click on OK again when asked whether you would like to overwrite the cell with the same code.
    

44. Click View on the menu bar. Highlight and click on Calculate. Click on OK when you are told that the calculation was successful.
    

45. You now have the total value calculated from your group in cell C6+7+8. Since we have the summed value from the cells C6, C7, and C8 we do not need them on our table any longer. Highlight the three variables.
    

46. Click Item on the menu bar. Highlight and click on Delete Item. You are asked if you would like to proceed with the deletion, click on OK. Even though the three variables are deleted, your value in C6+7+8 does not change.   (SHOW ME)
    

47. Highlight C9. Click Item on the menu bar. Highlight and click on Insert….
    

48. You are now asked to enter an Item Code. In order to create another variable with a $10,000 increment, we need add the values from C9 to C10 So, type in C9+10 for your Item Code. You are now given a choice to insert the item before or after the highlighted characteristic (C9). Click on Before Active Item and then click on OK.
    

49. On your table you will have a blank characteristic with a value of 0. Click on the blank characteristic and notice on your status bar that the active cell is C9+10.  (SHOW ME)
    

50. Click View on your menu bar. Highlight and click on Dimension. The blank characteristic and its item code are highlighted. Click on the blank characteristic. Type in the following: $20,000 - $29,999, (Females 15+). Press ENTER.
    

51. Click on the 'x' in the top right-hand corner of the Insert Item in Characteristics window to close it. Our new characteristic is now displayed on our table.
    

52. Click on the variable $20,000 - $24,999 (Female 15+). Hold down the left button of the mouse and move your mouse down to highlight the next variable and then let go of the button.
    The variables $20,000 - $24,999 (Female 15+) and $25,000 - $29,999 (Female 15+) should be highlighted.
    

53. Click Item on the menu bar. Highlight and click on Define Group…. Type in C9+10 as your Group Code. Total - Members of Group are Summed should also be selected. Click on OK. Click on OK again when asked whether you would like to overwrite a cell with the same code.
    

54. Click View on the menu bar. Highlight and click on Calculate. Click on OK when you are told that the calculation was successful.
    

55. You now have the total value calculated from your group in cell C9+10. Since we have the summed value from the variables $20,000 - $24,999 (Female 15+) and $25,000 - $29,999 (Female 15+) we do not need them on our table any longer. Highlight the two variables.
    

56. Click Item on the menu bar. Highlight and click on Delete Item. You are asked if you would like to proceed with the deletion, click on OK. Even though the two variables are deleted, your value in C9+10 does not change.  (SHOW ME)
    

57. Keep going until all the variables on your table have a $10,000 increment.
    

58. Click Item on the menu bar. Highlight and click on Select All.
    

59. On your table, click on your right mouse button. Highlight and click on Chart.
    

60. You now have a bar graph on screen with all of the variables chosen.
    

61. On your chart, click on your right mouse button. Highlight and click on Print.
    

62. Click on the 'x' in the top right-hand corner of the chart window to close it.
    

63. Click File on your menu bar. Highlight Save As… and click on it. Be sure that the Browser has been configured to save files on the floppy drive (usually a:\). Type in a filename that captures the essence of the table and press ENTER.
    

64. Click the 'x' in the top right-hand corner of your screen to close the Browser.

Extension of this workshop:

1. You could use more than one census tract and create a 9-category income scale that can be used in a comparative pie chart (right-click on chart and select Chart Options) that automatically creates a percentage comparison.
   
2. Do steps #15-62 but substitute Males 15 years and over with income.