I'm going to be posting my answers to the exercises and I invite everyone to critique them and let me know if my answers differ from your own so we can discuss the differences until we have agreement on a final, correct answer.
[Sixth Bullet] Try the following equations and observe the change in number of records in the attribute table associated with the layer.
Question 1: "Population" > 50,000
Question 2: "Population"<50,000
Question 3: Using the Switch tool (right-click on the "cities" layer, then choose "selection", then "switch selection"; or open the attribute table of the "cities" layer, "options", "switch selection").
- The map display toggled between the results for "greater than" and "less than" 50,000.
Question 4: "Population">50,000 and "Capital"="y"
[Eighth Bullet] Type in equation "Population">=25,000 AND "Population"<50,000. See howm any records are selected.
[Tenth Bullet] Type in equation "Population">=50,000 AND "Population"<100,000. See how many records are selected. Why.
- Only 4 out of 606 records were selected as only these records met the stringent criteria.
[Twelfth Bullet] Type in equation "Population"<=50,000 AND "Population">100,000. See how many records are selected. Why.
- No records were selected (0 out of 606) because the requirements are conflicting and produce mutually exclusive solutions. In other words, a city CANNOT have 50,000 citizens or less while simultaneously have 100,000 citizens or more.
[Fourteenth Bullet] Type in equation "Population">=50,000 AND "Population"<100,000. See how many records are selected. Why.
- Only 25 out of 606 records were selected as only these records met the stringent criteria.
[Sixteenth Bullet] Type in equation "Population">=50,000 AND "Population"<100,000. See how many records are selected. Why.
- The following message appears on the monitor due to the syntax error.
Following thru to the end of the exercise, the report I generated looked like this:
Posts
No comments:
Post a Comment