Using Databases Defnyddio Cronfeydd Data

1
Technoleg gwybodaeth a chyfathrebu Information
and communication technology
Using Databases / Defnyddio Cronfeydd Data Level
5 Music database / Cronfa ddata Cerddoriaeth
2

• Pupils create their own databases and search
  or sort on more than one field to follow
  particular lines of enquiry.

Bydd y disgyblion yn creu eu cronfeydd data eu
hunain ac yn chwilio neun didoli ar fwy nag un
maes er mwyn dilyn llwybrau ymholi penodol.
Using Databases / Defnyddio Cronfeydd Data Level
5 Music database / Cronfa ddata Cerddoriaeth
3
ICT2 A weak example
4
ICT2 A good example
5
ICT2 Esiampl gwael
6
ICT2 Esiampl dda
7
A database with 15 records and five fields
Artist, Album, Favourite Track, Label, Rating
(13).To collect the data he printed a table in
Word with five columns and 20 rows. He took this
home, entered the details of part of his CD
collection and brought the completed table back
to school to enter the data into his database.
1
8
Cronfa ddata gyda 15 cofnod a phum maes Enw, CD,
Hoff Gân, Cwmni, Sgôr (13).I gasglur data mae
angen tabl yn Word gyda phum colofn ac 20
rhes.Aeth â hwn adref, bwydodd fanylion rhan oi
gasgliad CDau a daeth âr tabl wedii gwblhau yn
ôl ir ysgol i fwydor data iw gronfa ddata.
1
9
Sort alphabetically by Artist
2
10
Trefnu fesul Enw yn nhrefn y wyddor
2
11
Search for CD Single
3
Search for CD Single AND a Rating of 1
4
Search for Polydor OR Parlophone Labels
5
12
Chwilio am CD sengl
3
Chwilio am CD sengl A Sgôr o 1
4
5
Chwilio am Gwmni Polydor NEU Parlophone
13
ICT2 A good example
14
ICT2 Esiampl dda
15
Additional evidence .

• The task sheet
• Annotation on work
• Printout of the database
• Evidence of how the searches/sorts were
• carried out (screen shots)

Tystiolaeth ychwanegol .

• Taflen waith
• Gwaith wedi ei anodi
• Cronfa ddata wedi ei argraffu
• Tystiolaeth o sut gwnaethpwyd y chwiliadau /
• trefnu (gan ddefnyddio llun or sgrin)