A Reminder....

For the end of year exam (and next year's IGCSE exam) please use the following site to help you study:

http://www.teach-ict.com/gcse/gcse_topics.html

The site has a new section for exam questions and they are excellent study helpers.

Good luck!

Homework due for May 23, 2008

Please read pages 114-115 and answer the questions found on pg. 115.

Good luck!

Homework due for May 22, 2008

Please read pages 110-113 and answer the following questions:

Pgs 110-111

1. Define Data Capture. (1 pt)
2. What is a hindering feature of Bar Code Devices? (1 pt)
3. What do the following options do: Auto Enter, Value List, Check Box? (1 pt each)
4. What is data validation? What are the 6 main data validation checks? (7pts)
5. Explain how data verification is different from data validation. (4pts)

Pgs 112-113

1. When you search a database what must you do? (2 pts)
2. To do a search, what do you many database systems require? (3 pts)
3. Explain the use of AND, OR, NOT in searches. (3 pts)
4. Define the following: Found Set (1 pt), Sorting (3 pts), merging (2 pts).
5. What is the best way to show patterns comparisons and trends in data? (1 pt)

Good luck!

Homework due for May 20, 2008

Please read pages 106-109 and answer the following questions:

Pgs 106-107

1. What is a database? What are the four main properties? (5 pts.)
2. Give an example, not found in the reading, of a small database. (1 pt.)
3. Give two examples of large databases that might be used to help members of the public. (2 pts.)
4. Describe a GIS and how it is used. (4 pts.)
5. Explain what is meant by: file, record, and field. (3 pts.)
6. Look carefully at the table on page 107. In your opinion, do the advantages of a database outweight the disadvantages? (3 pts.)

Pgs 108-109

1)Explain what is meant by the following terms:

• field attributes (1pt)
• fixed field length (2pts)
• variable field length (1 pt)
• key field (2 pts)
• forms (2 pts)

2) Give two reasons why choosing the correct field type is important (2 pts).

3) Give two reasons why setting the maximum length of a field can be important (2 pts).

Good Luck and please remeber to work on your review webpages as well. They are due for Friday May 23, 2008.