BTEC First ICT Practitioners: Core units and selected specialist units for the BTEC First Certificate and Diploma for ICT Practitioners

285 Pages·2007·19.13 MB·English

by  Sharon Yull

BTEC First ICT Practitioners
Core units and selected specialist
units for the BTEC First Certificate and
Diploma for ICT Practitioners
This material has been endorsed by Edexcel and offers high quality support for the delivery of
Edexcelqualifications.
Edexcel endorsement does not mean that this material is essential to achieve any Edexcel
qualification, nor does it mean that this is the only suitable material available to support
any Edexcel qualification. No endorsed material will be used verbatim in setting any Edexcel
examinationandanyresourcelistsproducedbyEdexcelshallincludethisandotherappropriate
texts.WhilethismaterialhasbeenthroughanEdexcelqualityassuranceprocess,allresponsibility
forthecontentremainswiththepublisher.
Copies of official specifications for all Edexcel qualifications may be found on the Edexcel
website–www.edexcel.org.uk
BTEC First ICT Practitioners
Core units and selected specialist units
for the BTEC First Certificate and Diploma
for ICT Practitioners
Sharon Yull
AMSTERDAM•BOSTON(cid:127)HEIDELBERG(cid:127)LONDON(cid:127)NEWYORK(cid:127)OXFORD
PARIS(cid:127)SANDIEGO(cid:127)SANFRANCISCO(cid:127)SINGAPORE(cid:127)SYDNEY(cid:127)TOKYO
NewnesisanimprintofElsevier
NewnesisanimprintofElsevier
LinacreHouse,JordanHill,OxfordOX28DP
30CorporateDrive,Burlington,MA01803
Firstpublished2007
Copyright©2007,SharonYull.PublishedbyElsevierLtd.Allrightsreserved
TherightofSharonYulltobeidentifiedastheauthorofthisworkhasbeen
assertedinaccordancewiththeCopyright,DesignsandPatentsAct1988
Nopartofthispublicationmaybereproducedinanymaterialform(includingphotocopyingor
storinginanymediumbyelectronicmeansandwhetherornottransientlyorincidentallyto
someotheruseofthispublication)withoutthewrittenpermissionofthecopyrightholder
exceptinaccordancewiththeprovisionsoftheCopyright,DesignsandPatentsAct1988or
underthetermsofalicenceissuedbytheCopyrightLicensingAgencyLtd,90TottenhamCourt
Road,London,EnglandW1T4LP.Applicationsforthecopyrightholder’swrittenpermissionto
reproduceanypartofthispublicationshouldbeaddressedtothepublisher
PermissionsmaybesoughtdirectlyfromElsevier’sScienceandTechnologyRightsDepartment
inOxford,UK:phone:[phone];fax:[phone];
e-mail:[e-mail]queston-lineviatheElsevier
homepage(http://www.elsevier.com),byselecting‘CustomerSupport’andthen‘Obtaining
Permissions’
BritishLibraryCataloguinginPublicationData
AcataloguerecordforthisbookisavailablefromtheBritishLibrary
LibraryofCongressCataloguinginPublicationData
AcataloguerecordforthisbookisavailablefromtheLibraryofCongress
ISBN:978-0-7506-8324-1
ForinformationonallNewnespublications
visitourwebsiteatwww.newnespress.com
PrintedandboundinItaly
07 08 09 10 10 9 8 7 6 5 4 3 2 1
‘To my dad, I miss you everyday’

Contents
Preface xi
1 Using ICT to present information (Unit 1) 1
2 Introduction to computer systems (Unit 2) 49
3 Website development (Unit 4) 103
4 Networking essentials (Unit 6) 141
5 Database software (Unit 9) 177
6 Spreadsheet software (Unit 10) 199
7 ICT graphics (Unit 18) 225
Index 265
Note from
Isn’t it funny how life unfolds, it wasn’t so long ago that I was in
the author detention for some misdemeanour at school. After being told that
Iwouldneverreallyamounttomuchanddiscouragedtostayonand
doA’levelsbymyteachers,Ithought‘I’llshowyou’,andatthisstage
inmylife,InowfeelthatIhave.
Forever the pragmatist, I always believe that things happen for a
reason and that your life is mapped out for you from beginning to
end; and although I have images of grandeur, fame and worldwide
recognition–thenextbestsellingauthor,dramatisedintwopartson
televisionandfilm,Iremainconvincedthatmycontributionalthough
notongloballife-changingscalewillmakeadifference.
And so my message to you is always aim high, be realistic in your
goals,remainoptimisticofwhatthefuturewillbringandbeincharge
ofyourowndestiny.
Don’t look back on your life and regret the things that you haven’t
done,lookbackfondlyandreflectonthethingsthatyouhave.
Tomymother,husbandanddaughterthebestthingsinmylife.
SharonYull
About the
Addingauthortomylistofachievementsfeaturesquitehighlyonmy
list.AlthoughIhavecontributedtoarangeofpublicationsinthepast, author
writing a complete book is something that I have wanted to do for a
longtime,buttimingandcircumstanceshavedictatedotherwise.
IfeltthatIcouldnotwriteabookwithoutunderstandingthecontext
ofFEandICTqualifications,thereforeoneofmyotherrolesinlifeis
that of Senior Lecturer at a large FE and HE college. Being a practi-
tioner, for over 10 years has provided me with a range of skills and
a certain level of understanding of the education arena that I have
appliedtootheraspectsinmyworkinglife.
Inadditiontobeingapractitioner,Ihavealsoactedasaneducational
consultant for Edexcel, LSDA and QCA and I still remain heavily
involved with Edexcel in my role as Senior Subject Examiner for
HigherNationalsinComputing.
Finally as if I wasn’t wearing enough hats, I am also the Director
of The Training and Education Company that was set-up to provide
supportintheformofmaterials,trainingandconferencestoCentres
across the country offering ICT and computing qualifications at all
levelsoftheNQFframework.
SowhatelsedoIdo,mygreatestachievementisbeingamotherand
to me the most rewarding, challenging, dynamic and fulfilling job
rolethatIcouldeveraddtomyCV.