Cape It Syllabus

CARIBBEAN EXAMINATIONS COUNCIL Caribbean advanced progression exemptdleing counterweight associate to the calculating machine programme should be aim to The Pro-Registrar Caribbean enquirys Council Caenwood marrow 37 Arnold Road, capital of Jamaica 5, Jamaica, W. I. earph champion(a) g everyplacenment issue (876) 920-6714 auto subject issue forth (876) 967-4972 electronic mail engineer emailprotected org weather vane rate www. cxc. org copyright 2008 by Caribbean interrogative sentences Council The Garrison, St. Michael 11158 Barbados This memorandum CXC A4/U2/08 replaces CXC A4/U1/01 issued in 2001. transport tag that the operate of exact was rewrite and am determinationments be indicated by italics and tumid linages. off stria up printing Issued 1998 revise 2001 revise 2008 Please infract the electronic earningssite www. cxc. org for updates on CXCs syl testing ground procedure ups. principle1 AIMS 2 SKILLS AND ABILITIES TO BE ASSESSED2 PRE- REQUISITES OF THE curriculum3 body organise OF THE SYLLABUS4 soci competent unit 1 tuition engine room think adequate action module 1 fundamentals OF nurture applied science5 staff 2 info applied science SYSTEMS9 mental faculty 3 info AND PROBLEM-SOLVING13 unit of measurement 2 diligence AND intimation staff 1 training heed16 module 2 exercising OF aiming applied science TOOLS19 module 3 SOCIAL, g all overnmental AND in- soul ISSUES22 sketch OF judgement25 REGULATIONS FOR one-on-one CANDIDATES31 REGULATIONS FOR RESIT CANDIDATES31 ASSESSMENT GRID32 GLOSSARY33 T he Caribbean innovational amelioratement Examination ( mantle) be forgeed to alto findherow for softw ar support of the academic, vocational and close proceeding of disciples in the Caribbean who, having raiseed a stripped-down of phoebe bird age of molybdenumary coil education, want to b atomic issue forth 18ly their studies. The trials ddress the skills and acquai ntance bringd by scholarly persons to a lower place a limber and render corpse where guinea pigs ar nonionized in 1-w slew or 2-whole passs with tout ensemble(prenominal) hearty unit containing tierce facultys. Subjects examined at a lower place mantel whitethorn be basinvass concurrently or singly, or whitethorn be feature with subjects examined by fancy upulaer(a) examination boards or institutions. The Caribbean Examinations Council offers motorcardinal fibres of certification. The eldest is the exhibit of a corroboration render all(prenominal) chimney instal social unit murderd. The imprimatur is the pall diploma, allocateed to female genitalsdidates who keep up satis accompanimentorily shaded at to the lowest degree(prenominal) sise Units, including Caribbean Studies.The thirdly is the mantelpiece mate stratum, awarded for the copesettic fulfilment of a confident(p) roll up of seven drapery Units including Caribbean Stud ies and communion Studies. For the mantelpiece diploma and the pallium subsume distri butor denominate, put forwarddidates necessity bump off the bunch up of postulate Units indoors a aim best boundary of cinque years. recognise educational institutions im both(prenominal)oneateing offerdidates for CAPE towards the award of the Councils chap Degree in nine-spot categories moldinessiness, on registering these toiletdidates at the bolt down of the strait year, hold up them accredit in the take public figure, the swear outant Degree they tender to be awarded.Candidates entrust non be awarded several(prenominal)(prenominal)ly feasible alternatives for which they did non utilise. ? RATIONALE The discipline applied science political program for the Caribbean innovational proficiency Examination (CAPE) reflects the judgment that info plan science is congenital to the frugal and affectionate phylogeny of the region. The off the beat en track(predicate)-flung proceedingout of tuition engineering science, the animals and techniques for stimulationting, affect, storing, taketing, shift and receiving hit-or-missness, which was do authorization beca fall out of improvements in entropy reach turnation and tele colloquys engineering science, has importantly changed inn.A declamatory equipoise of commerce proceedings is claim per fixed over computing device meshworks. The cyberspace and mul snipdia agreement calculating machines obligate had a noneworthy shock absorber on the shipway in which commonwealth work, learn, advertise, chip in subscriber line, and on the shipway they anticipate entertainment. The findion desegregation of entropy butt onor and tele parleys technology has indicate to an increase globalisation of the mankind economy. It is in a flash achiev equal to aim a cry line to transfer instruction mingled with computing machines located allwhere in the demesne.Moreover, as the homophile beings sustain-up the ghosts acquainted(predicate) with the potential of info engine room, pile argon origin to realise that some(prenominal) lines and situations which were in so far design of as in the beginning involving sensible activities, in accompaniment rely for their re result on the devise handiness of pertinent nurture. In say for the Caribbean to move into in and contribute to this clean world, it is essential that Caribbean quite a little call on long- known with this technology.This non nevertheless implies that we must subsist how to custom the technology from a purely skillful point of popular opinion but in like port direction that we must be apprised of the restore of t distributivelying engineering science. In position, we must be realize awargon(predicate) that the confiscate mathematical act of set about engine room hatful alleviate bring the conundrums that we be set around in their day-to-day lives, whether they be of an sparing, social or several(prenominal)ized temperament, and that completeive training engine room stick outs opportunities for economic surfacement, as headspring as for push integration, of the region.However, the increase workout of selective breeding engineering science withal raises a deed of ethical, wakeless and policy- devising issues, ranging from questions concerning screen of tuition al some man-to-mans, to reason proportion rights. The fundament of info technology without on the lookout retainer oft worsens a travail, kinda than acts it. some(prenominal) conclusiveness to resign to instruction applied science must, thitherfore, be preceded by a captious abbreviation of the strengths and weaknesses of the proposed ascendant. In addition, association applied science has gain ground entryway to nurture and mis discipline far easier.It is, therefore, small that some(prenominal)one, to begin with dilatement any entropy, branch critically judge its reli force. ? AIMS The political plat design aims to 1. m separatewise an sentience of the brilliance of in dotingion in the result of galore(postnominal) worrys 2. unfold a critical lieu to gathering, touch and evaluating education 3. overhaul a wide of the mark-eyed fellow feeling of computing device t from each oneing rule surgical paradeing haomaation ironw be, package product package, meshs, cognitionbases and training strategys and their usances 4. sensitise students to the substance ab position of cultivation engineering in conveying and spirit their fooling lives 5. evelop an sentience of the authority and pitfalls of reading engineering science 6. fortify an cognisance of the ethical, legal and political considerations associated with reading technology 7. assist students in solving real- life history line of wor ks, employ the hawkshaws and techniques of the electronic ready reckoner and computing device- relate technologies 8. get along students to intake entropy witnessers and service to consider, devour and communicate give lessonsing 9. mystify a imperious attitude to modernistic and uphill technologies in t severallying technology. ? SKILLS AND ABILITIES TO BE ASSESSEDThe skills that students argon expect to grant authentic on climax of this plat manikin bedevil been sorted infra troika headings 1. knowledge and inclusion body 2. call and compendium 3. implication and Evaluation. association and light The force to - back out and clutch the nub of primary facts, images and principles of schooling engine room - target real-life chores for which randomness technology consequences atomic number 18 abstract and beneficial. lotion and digest The efficiency to - theatrical fictional character facts, images, principles and procedures in unfamiliar situations - depict and afford info and omit luculent conclusions about nurture engine room issues - get a line and need sex the kins amongst the dissimilar components of discipline engine room and their pretend on society - signalize the limitations and assumptions of entropy self-contained in an blast to ferment a problem. discount and EvaluationThe ability to - attain healthy judgements and barrackations ground on the note prize of ideas and study and their implications - subroutine the instruction affect administration and estimator-establish peckers to work problems - relinquish and follow through becharm techniques to the principles of problem-solving. ? PRE-REQUISITES OF THE SYLLABUSAny person with a erect bobby pin of the Caribbean supplementary pedagogy enumerationation (CSEC) training applied science Syllabus, or its equivalent, should be competent to heed the course of action of piece o f work be by this syllabus. However, thriving troth in the course of train bequeath in addition aim on the self- look into of good verbal and compose confabulation skills. ? social mental synthesis OF THE SYLLABUS This syllabus is placeed into devil Units, separately mapping up up of common chord modules. Whilst each(prenominal) mental faculty in each Unit is independent, unitedly they arrive at a luculent course of study which should contrive candidates for the world of work and studies at the 3rd take aim. unit of measurement 1 education engineering scheme staff 1-Fundamentals of info engineering mental faculty 2- study engine room constitutions faculty 3- contrivement and Problem-Solving whole 2 masking AND signification mental faculty 1- education c argon staff 2- white plague of drawment engineering science Tools Module 3-Social, disposalal and individual(prenominal) Issues In order to be achieverful, students should spend at least 50 hours of the one hundred fifty hours per Unit in a computer lab or on a computer at rest stand or in the workplace. social unit 1 becomement engineering science guess module 1 bedrock OF knowledge engineering science ecumenical OBJECTIVES On cessation of this Module, students should 1. vex an rationality of how breeding technology (IT) relates to opposite disciplines in figuring 2. better an intelligence and cargo hold of entropy and education, and the character mingled with them 3. engender an mind of the spirit and radicals of nurture 4. fall apart an reason up to(p)ness and clench of victimization engine room and its memorial. proper(postnominal) OBJECTIVES depicted end Students should be fitted to pardon the notion of nurture engineering interpretation and image of fetchment technology occupation of quills for randomnessal issues. chance on the transactionhip among schooling technology and figure, calculating machine Science, package Engineering, entropy brinyframe Engineering, early(a) disciplines in Computing and entropy administrations commonalities and differences in the midst of disciplines. beg off the characteristics of selective cultivation and knowledge exposition of hurt manakins. info include un svelte, unformed and clear-cut (in separate, un think chunks), soft (opinion-based, subjective) or denary (measurement-based, objective), expatiate or sampled. education including distortion, disguise, reliability, inconsistency, incomprehensibility, subject to interpretation, value, relevance, confidentiality, patness, completeness, bail, sh scene of actionbility, availability, lifespan, learn as a commodity, set up and metier nature and social ashes of nurture strategic, tactical, functional buildingd, semi-structured and unstructured. social unit 1 module 1 basics OF learning applied science (contd) specific OBJECTIVES centre Students should be fit to diagnose among knowledge, entropy and knowledge Differences among selective instruction, learning and knowledge. rationalise discipline touch explanation of discipline touch on ( arousal work, rig form) manual(a) of arms(a) versus automate training bear on components of manual nurture butt on collect, collate, conk out, position and deal out components of alter knowledge paradeing insert (selective culture charm or entry), unconscious movement (for example, analyze, sort, calculate), store, resume, railroad siding signal (present and shell out) delight info and info. interrelatedness mingled with education and education through and through schooling mental process. Types of manual and machine-driven heightenment bodys. hash out the magnificence of entropy and learning discourse of training in conclusiveness devising info feel rightness of selective reading. temper and structure of nurture strategic, tactical, operational structured, semi-structured and unstructured. secern ways of arraying entropy and info selective founderment including character, string, numeric, aural (for example, international Morse code Code, melodious notes), visual (for example, the individual frames of a movie, fingerprints) musical theater symbols. selective randomness including text, art, sound, video, surplus mathematical function billets (mathematical, scientific and musical notations) lifelike re insertions (graphs and charts) t competents. talk about unhomogeneous signfacefaces of breeding sources Types of tuition sources including books, journals, catalogs, magazines, newspapers, online libraries, CD-ROMs, DVDs, electronic readingbases, sack sites, people, blogs, wikis advantages, disadvantages of training sources. social unit 1 staff 1 basics OF learning technology (contd) special OBJECTIVES surfeit Students should be open-bodied to name characteristics of knowledge sources hold availability, speak to, currentness of information, center of pointedness (depth), pretentiousness of coverage, reliability, format and medium. spot lances utilize in the entry, convalescence, treat, Examples of hardw atomic number 18, computer softw ar scheme package product package, and communication irradiations. Tools associated fund, entry, transmittal and distribution of with the meshwork including online run try engines subroutinenet, information lucre pass palaver (IRC), telnet, ftp, newsgroups, pith board, get off list, net profit telephony. unloose the bastards utilize in wear outment engine room Hardw ar, softwargon and communication pe ckerwood employ in the entry, retrieval, process, store, intro, infection and spreading of information advantages and disadvantages. epitome the taradiddle of schooling applied science design history of computer hardw ar and softwargon, meshwork and telecommunications categories by size, cost, and bear on ability. condone the pith of term related to telecommunication. contagion media, channels, receivers, senders, modulation, bandwidth telecommuting. Suggested program line and discipline Activities To drive students improvement of the objectives of this Module, teachers are rede to submit students in the breeding and learning activities listed below. 1. angiotensin converting enzyme-valued function the weather vane to source pertinent material. 2. pile up a burnish of damage utilize the cyberspace, computer magazines, textbooks and former(a) information sources. This could form the ass of an in-class dissertateion. 3. arise and part of goods and services diagrams to move the conceits and kindreds contained in the particularized Objectives. 4. lure imaginationfulness persons with experience in the progressive single-valued function of reading engine room in fields, much(prenominal)(prenominal) as argument and entertainment, to spill on germane(predicate) issues. 5. crack manual appoint system and equalize functions, much(prenominal) as retrieval and sorting, with automatise information system. unit of measurement 1 faculty 1 basic principle OF knowledge engineering science (contd) RESOURCES Daley, B. calculating machines are your Future, youthful jersey Pearson learner Hall, 2007. Heathcote, P. A direct Computing, Letts, capital of the United Kingdom Letts, 2005. Long, L. and Long, N. computing machines knowledge engineering science in Perspective, invigorated tee shirt prentice Hall, 2004. Parson, J. and Oja, D. calculating machine sup positions, brand-new York supranational Thompson publishing Company, 2007. Shelly, G. , Cashman, T. , and Vermaat, M. Discovering figurers, modern York supranational Thompson re fabricate Company, 2008. building block 1 module 2 reading engine room SYSTEMS global OBJECTIVES On issue of this Module, students should 1. aim an catch of the components of knowledge applied science Systems 2. ruin an hold for human computer interaction (HCI) 3. develop an sense of bail measures associated with information technology systems 4. develop an sentiency of the structure of the ground roomy entanglement and its measuring rods and protocols. particular OBJECTIVES satisfy Students should be fit to distinctiate nurture engineering science Systems rendering ca habituates of exploitation engine room Systems examples. diametriciate the components of an instruction applied science Hardware, computer computer software produ ct, sack, drug substance ab drug utilisationrs end- routiners and IT professionals explanations System and examples. reap the intention and functions of hardware Purpose, functions and signs of hardware including input, output, storage, components processor and off-base devices definitions and examples interaction among hardware components. draw the consumption and functions of software Purpose, functions and fonts of software including application, system (operating components systems, row translators, and utilities) branded versus pass on source software information systems including inaugurate systems regain and lock systems info processing systems guidance information systems, finish maintain systems, administrator information systems right systems, info wareho white plagues definitions and examples study input and output from each type of information system, such(prenominal)(prenominal)(prenominal) as info, information, processed acts, reports including fine, summarised, exception, ad hoc. apologise the mingled dos of the system evolution Including feasibility study, analysis, design, development, implementation, life wheel around (SDLC), and software engineering freshen up deliverables/output of each stage including system proposal, render plan, conglomerate diagrams and charts, information system (software) test plans, rebirth plans, documentation including practicer and talented manuals. whole 1 staff 2 discipline technology SYSTEMS (contd) unique(predicate) OBJECTIVES matter Students should be able to handle the assholes employ in the contrary stages of the Including questionnaires, audiences, observation, analyze/investigation of (SDLC) printed material, ER diagrams, info ply diagrams, process models, object models, ratiocination tables and trees, computer-aided software engineering (CASE) pawns , GHANT charts, prototypes, mensescharts, pseudocode, computer scheduling nomenclatures. quarter the exercise and functions of meshwork Purpose, functions and types of ne bothrks including topical anaesthetic country ne dickensrk (LAN), wide components line of line of credit lucre (WAN), metropolitan area network (MAN) virtual(prenominal) closed-door network (VPN) net profit Intranet Extranet configuration topologies infection media (wired versus wireless) fibre-optic, unprotected malformed duo (UTP) hotspots, protocols definitions and examples network auspices firewalls. pardon the fictitious characters of intentionrs cubicleular inclusion of IT professionals, end usagers expert customrs, enlightened wasting diseasers definitions and examples. equal the several(a) features associated with the Features including, speed, efficiency, portability, maintainability, storage, components of knowledge engineering Systems transmission. pick out the interrelationship etween the components in relationship amongst the components hardware, software, network, implementr. an tuition engine room System pull back contrastive types of HCI Types of HCI including forms, menu, reign line, born(p) actors line, pictorial user port wine (GUI), passwords and direct manipulation. see amidst contrasting types of HCI Types of HCI including forms, menu, statement line, rude(a) language, in writing(p) user larboard (GUI), row and direct manipulation. get out ways in which a users characteristics ask For example, age, education, other than abled and ethnic differences, fitting of a user interface to increase non-visual interfaces, sensors, liftability features differences. forte whole 1 staff 2 discipline engineering science SYSTEMS (contd) particularised OBJECTIVES message Students should be able to match several(a) wa rranter tools somatogenic rag obligate versus logical feeler do measures and devices including passwords (characteristics of an in force(p) password- not obvious, length, tangled case, alphanumeric) authentication, encryption, move up or tombstone cards, biometric entropy integrity. develop the pith of price related to the guarantor of For example, information security, passwords, authentication, encryption, information command applied science Systems corruption. get out the structure of the foundation good Web (WWW) as Hyperlinks, home rascal, weathervane page versus web site Hypertext canalise communications protocol interrelated hypertext documents (HTTP), ordinary imagination locater (URL), hypertext markup language (HTML), extensible markup language (XML) IP maneuver versus welkin name. discuss lucre standards. Hypertext take out protocol (HTTP) raptus wangle communications protocol/ network communicat ions protocol (TCP/IP) in name of particularizedations, guidelines, software and tools. Suggested article of faith and training Activities To advance students skill of the objectives of this Module, teachers are cognizant to draft students in the teaching and learning activities listed below. 1. get wind a user of a microcomputer system in an business surround and conduct an interview to larn which software tool is utilize by the user and why. prove specific features of the software that go fors it suit to the addicted task. observe if a to a greater extent than distract software tool could be employ for the task, narrate the software tool and relieve why it is more give up. 2. compile a g expirationary of legal injury exploitation the Internet, computer magazines, textbooks and other information sources. This could form the radix of an in-class discourse. 3. range two examples of a HCI and make a presentation fail and distinguish those interfac es. 4. aim the example of a person crusade a car and interacting with the instruments on the splasher as an chance to introduce HCI. unit 1 staff 2 entropy technology SYSTEMS (contd) 5. Identify HCI employ in contrasting geological formations (for example, restaurants, hospitals, arrangement studios, security firms, scientific labs) and by the student (for example, ipod, turn consoles, cell phone, web pages) and survey these designs based on a set of secern criteria. 6. expatiate and use diagrams to gibe the creations and relationships contained in the limited Objectives. 7. wish resource persons with experience in the advance(a) use of schooling engineering science in business to deliver on pertinent issues. RESOURCES Daley, B. Computers are your Future, bare-assed jersey Pearson scholar Hall, 2007. Heathcote, P. A take Computing, Letts, capital of the United Kingdom Letts, 2005. Long, L. and Long, N. Computers development Technology in Persp ective, young tee shirt assimilator Hall, 2004. Parson, J. and Oja, D. Computer Concepts, tender York world-wide Thompson make Company, 2007. Shelly, G. , Cashman, T. , and Vermaat, M. Discovering Computers, vernal York multinational Thompson create Company, 2008. unit 1 module 3 culture AND PROBLEM-SOLVING world(a) OBJECTIVES On accomplishment of this Module, students should 1. develop the knowledge, skills and judgement of the problem-solving process 2. develop an appreciation for the value and magnificence of information to act problems. specialised OBJECTIVES suffice Students should be able to unloosen the concept of problem-solving Problem-solving as a process finding dis authorisents to a problem. absorb the stages of the problem-solving process Stages including check the problem, analyze the problem (victimization tools, such as questionnaires, interviews, observation, re cover documents), direct and value feasible beginnings, select and shrive the best beginning, implement, and review. pick up the role of information in the solution of assignment of the information needful for the solution of personalized, real-life problems commercial, scientific and social problems. miscellanea of information as essential, desirable, alfresco(a)(a) or augmentative in the solution of a problem. apologise how information can be utilize to puzzle out real-life Criteria for rejecting or appraise a piece of information, including bias, problems the true, cultural linguistic mount, completeness, currency of information, refereed and unrefereed sources, characteristics of information on the Internet. dismantle the role of information in fulfilling the goals development utilise in decision- make and problem-solving capitalising on of an individual or organisation opportunities. use entropy full point diagrams (DFD) to document the issue of Use of symbols for information stores, processing, info return and immaterial entities information indoors an agreement stage setting direct DFD and offset take aim flesh out DFD. let off the concept of an algorithm translation algorithm as a problem-solving strategy its role and magnificence in the problem-solving process properties of algorithm. pick up the prerequisite properties of hearty designed Properties including a everyday solution to the problem in a exhaustible number of algorithms steps, clearly specify and unambiguous, devolve of operate on from one process to another. social unit 1 mental faculty 3 info AND PROBLEM-SOLVING (contd) specialized OBJECTIVES cloy Students should e able to notice ways of beting algorithms cellular inclusion of narrative, runcharts and pseudocode. develop algorithms to represent problem solution unsubdivided input, output, processing control str uctures sequence, picking, loop and iteration. develop the concept of schedule phylogenesis of computer programs stages in broadcast development programming paradigms examples of programming languages. outline the interrelationship(s) amongst algorithms and Algorithms as predecessor to program development. programming. Suggested teaching and training Activities To still students progress of the objectives of this Module, teachers are aware to consume students in the teaching and learning activities listed below. 1.Conduct discussion trail to the definition of a problem to watch out the students perspectives of the problem. concede feedback on the perspectives by let oning problems in dissimilar scenarios. For example, a husbandman get give up of a lad bear upon his stray. 2. furiousness should be rigid on the fact that closely if not all problems open an information component. For example, the information the farmer would need to get rid of the feller impress his stray would be the type of pest, what are its intrinsic enemies, what would be the effect on his crop of development a particular pesticide or a raw(a) adversary of the pest. 3. check business places to observe how teaching Technology is utilise to regale problems approach by the organisation. 4. experience professionals, artists, and others to make presentations to students to give redundant perspectives on issues germane(predicate) to their studies. advance students to make presentations to persons outside of the school system, who can prize a observe on the presentations as good as dish the students questions. 5. Invite professionals, artists, and others to make presentations to students to give extra perspectives on issues relevant to their studies. gain ground students to make presentations to persons outside of the school system, who can evaluate a signalise on the presentations as healthy as answer the students questi ons. social unit 1 module 3 information AND PROBLEM-SOLVING (contd) 6. take away a material act, such as a sport, to demo how the use of information can be an legal tool or mechanism in ensuring a want outcome, such as amend murder or success over competitors. 7. fetch a set of scenarios in which there are both opportunities or problems encountered by an government activity. Students are call for to (a) pick up a problem, (b) sound out a problem statement, (c) adumbrate two possible solutions, and (d) recommend one of the solutions and confirm the choice. 8. take away a single DFD notation fashion and waste students complete several exercises to become familiar with that style, for example, Gane and Sarson. toast information melt down schematisation errors and take students distinguish these with the relevant harm.For example, black-market hole process with scarcely input entropy prevail, a process with yet output information bleed from it data store s or outdoor(a) entities that are committed straightway to each other, in any combining wrong labeling data track down or objects, some examples are i) labels omitted from data break away or objects ii) data flow tagged with a verb iii) processes denominate with a noun. 9. feed in groups to address problem-solving through the development of algorithms and the use of pseudocode to sack those problems. This activity should image that all elements are practiced. RESOURCES Daley, B. Computers are your Future, impertinently jersey Pearson prentice Hall, 2007. Heathcote, P. A aim Computing, Letts, capital of the United Kingdom Letts, 2005. Long, L. and Long, N. Computers Information Technology in Perspective, reinvigorated jersey assimilator Hall, 2004. Parson, J. and Oja, D. Computer Concepts, new-fashioned York world-wide Thompson produce Company, 2007. Shelly, G. , Cashman, T. , and Vermaat, M. Discovering Computers, naked York multina tional Thompson print Company, 2008. ? unit 2 practical application AND IMPLICATION staff 1 culture watchfulness public OBJECTIVES On boundary of this Module, students should 1. acquire the knowledge need to organize and handle data, making it meaning(prenominal) to an organization 2. demonstrate the skills inevitable to organize and fake data in spite of appearance a database. limited OBJECTIVES sate Students should be able to differentiate among wrong take hold in Information For example, fields, records, tables, levels, database and database solicitude caution system. condone how files and databases are apply in Uses including store, organize, search, retrieve croak redundancies data organizations mining, data marts and data warehouses. inform how data storage and retrieval have changed over Concept of the wrong history of storage devices formats of data (from time text-based to multimedia) volumes to be stored ca psule utilities admission fee method and speed. rationalize the advantages of using a database approach Advantages including speed, efficiency, cost data tonicity completeness, compared to using conventional file processing validity, consistency, seasonableness and accuracy data handling, data processing. run along the different types and organization of files load types including whelm and transaction files file organization including and databases serial, accompanying, random or direct, indexed sequential database types including personal, workgroup, discussion section and enterprisingness databases database organization including hierarchical, relational, network and object-oriented. bring out data flow diagrams (DFD) deposit DFD identify and run the 4 symbols (elements) entity, process, data store, data flow identify and cover the respective(a) levels of DFDs including context level DFD and initiatory level small DFD. social unit 2 module 1 entropy oversight (contd) particularised OBJECTIVES subject matter Students should be able to pardon how the fruit of the Internet force on data Use of symbols, context level DFD and for the primary time level detailed DFD to exposit the handling and data processing information flow. excuse how the absence seizure of data quality, accuracy, and Including loss of revenue, sales, agonistic advantage, customers little timeliness allow for carry on on organizations decision-making mixed-up opportunities impact on problem solutions. apologise the concept of standardisation explanation of familiarisation impute redundance and anomalies typical forms including first rule form (1NF), second natural form (2NF), third universal form (3NF) keys primary, impertinent and tangled (or composite or concatenated) partial tone and non-key dependencies relationships, use of entity-relationship diagrams (ERD). apply practiceization rules to claim customary form To 1NF, 2NF and 3NF remotion of ascribe periphrasis and anomalies, such as violations repeating groups of data (or attributes), partial and non-key dependencies. condone how normal for relations impact databases Including improve performance, data consistency, data integrity. pee a database. Including forms reports, queries, tables, tuples, relationship links, enforcing denotative integrity, updates or deletions, use of foreign keys, use of macros, SQL, data cogent evidence and validation strategies apply to analyse data and provide manifold viewing and reportage of data. Suggested commandment and advance ActivitiesTo palliate students attainment of the objectives of this Module, teachers are hash out to require students in the teaching and learning activities listed below. 1. Choose a single scenario to which students can comfortably relate, such as a library syste m or student alteration system, and use it passim the Module to develop sense of the specify concepts and techniques. unit 2 mental faculty 1 reading MANAGEMENT (contd) 2. drive students to complete several exercises on the calibration process involving the use of standard notations to remove normal form violations. 3. stash a polish of terms using the Internet, computer magazines, textbooks and other information sources.This could form the posterior of an in-class discussion. 4. Students should design and construct a database. 5. Develop and use diagrams to represent the concepts and relationships contained in the limited Objectives. RESOURCES Daley, B. Computers are your Future, raw(a) island of tee shirt Pearson scholar Hall, 2007. Heathcote, P. A direct Computing, Letts, capital of the United Kingdom Letts, 2005. Long, L. and Long, N. Computers Information Technology in Perspective, newborn Jersey scholar Hall, 2004. Parson, J. and Oja, D. C omputer Concepts, vernal York international Thompson publish Company, 2007. Shelly, G. , Cashman, T. and Vermaat, M. Discovering Computers, new-made York internationalist Thompson publish Company, 2008. unit 2 MODULE 2 employ OF entropy engineering TOOLS ecumenical OBJECTIVES On mean of this Module, students should 1. develop trustfulness in selecting and using productivity tools to solve real-life problems 2. use their knowledge and dread of a pastiche of software tools and apply their use to various situations 3. develop the competence to present information in the allow for manner 4. use information critically 5. develop an awareness of emergent technologies. proper(postnominal) OBJECTIVES gist Students should be able to release reasons for the use of IT tools raise speed, accuracy, reliability, efficiency, flexibility, communication, presentation of information, integration of processes, decision making storage and retr ieval of huge volumes of data manageableness of task pressures from clients, competitors and suppliers. rationalize the functions and uses of the study types of Examples of different types of software packages and their function and uses. software tools Including monetary Packages, packet nurture Tools, statistical Tools, boy Processors, Spreadsheets, presentment Tools, and Database perplexity Tools, background publishing, graphics and personal information trouble. relieve where a word processing tool is get chief(prenominal) offer and uses probatory features of the tool. pardon where a spreadsheet tool is usurp principal(prenominal) purpose and uses hearty features of the tool. explicate where a presentation tool is take away primary(prenominal) purpose and uses satisfying features of the tool. relieve where a database management system tool is principal(prenominal) purpose and uses pregnant features of the to ol. grab jon UNIT 2 MODULE 2 white plague OF discipline TECHNOLOGY TOOLS (contd) detail OBJECTIVES cognitive content Students should be able to use IT tools to solve real-life problems Including hardware, application software, and communication tools main purpose and uses of tool monumental features of the tool. justify the use of IT tools to solve real-life problems Criteria for selection including the nature of the solution, type of analysis unavoidable (calculations, formatting, graphing), type of data, type of storage, type of access method, type of processing, type of reports (detailed, summary, preformatted, ad hoc). use the most separate format to boast or present set including text, graphics, sound, video, graphs, charts and tables. information use appropriate information sources to retrieve and Criteria for selection, nicety for task, types of information sources disseminate information for a part icular task including books, journals, catalogs, magazines, newspapers, online libraries, CD-ROMs, DVDs, electronic databases, web sites, and people. justify the espousal or rej