- 75 (Registered)
Information Technology (IT) continues to evolve in response to the need for more efficient techniques to manage the significantly increased volume and sophistication of the knowledge reservoir of mankind. It merges the study of Computer Science, Information and Communications Technology (ICT) and Office Automation. It involves the collection, processing, storage, retrieval, and dissemination of information, and impacts both work and social activities. The evolution of the field of Information Technology continues at a rapid pace. New technologies are constantly emerging and existing ones become obsolete soon after they appear. The rapid advances in technology undoubtedly have a profound effect on information technology education and, as such, Information Technology curricula must be refreshed to remain relevant.
The syllabus aims to:
- prepare students to function effectively in a dynamic technological era;
- promote the development of computer-related skills for application to real-life situations;
- prepare students to use information technology responsibly;
- facilitate the development and application of problem-solving and other twenty-first century skills;
- provide a foundation for post-secondary education; and,
- prepare students for suitable employment.
SECTION 1: Fundamentals of Hardware and Software
- A. Welcome Back To School – A Must Watch
- SBA Part One – Spreadsheet
- SBA Part Two – Database Management
- SBA Part Three – Word Processor
- SBA Part Four – Programming and Problem Solving
- SBA Part Five – Web Development and Designing
- 1. Describe a general-purpose computer system; Major functions of systems: input, processing, output, storage.
- Quiz 1: Fundamentals of Hardware and Software
- 2. Explain the functions of the major hardware Central Processing Unit (CPU): control unit and components of a computer system; ALU; main memory/immediate access storage, secondary storage, input/output devices.
- Quiz 2: Hardware Component of a Computer System
- 3. outline the functions and uses of primary Bistable devices, PROM, EPROM, RAM, ROM. storage devices;
- Quiz 3: Primary Storage Device Uses and Functions
- 4. Manipulate units of storage; Bit, byte, kilobyte, megabyte, gigabyte, terabyte, word, word size.
- Quiz 4: Unit of storage
- 5. compare the types of secondary storage media Magnetic tape, floppy disk, hard disk (fixed head, moving with respect to portability, speed and capacity; head, external), optical disks (CD, DVD), flash drive, flash memory cards.
- Quiz 5: Secondary Storage Media
- 6. use terms associated with storage devices; Read/write head, sectors, tracks, buffers, cylinders, access time, sequential access, direct access; device interfaces such as: SCSI, IDE, SATA.
- Quiz 6: Secondary Device Interface
- 7. explain the uses of various input devices and Optical mark reader (OMR), character readers media; (OCR, MICR), mouse, joystick, bar code reader, document scanner, light-pen, touch terminals, voice response unit, pads and tablets, point of sale (POS), keyboard, digital camera, biometric systems, sensors, remote control, sound capture, pointing devices, webcam.
- Quiz 7: Input and Output Media
- 8. state the types and functions of output devices; Visual display unit: resolution, types, sizes. Printers: impact and non-impact, types: (character, line, page, laser, inkjet, dot matrix). Characteristics: (speed, quality, storage capacity); plotters; audio output devices (for example, speakers, head-phones, earphones); microfilm. Also terms such as hard copy, soft copy, human readable and machine–readable.
- Quiz 8: Type and function of Output Devices
- 9. describe how data are stored and Binary, octal and hexadecimal number systems; binary manipulated within the computer; addition and subtraction. Integers (positive and negative): sign and magnitude, BCD, two’s complement; representation of characters, ASCII.
- Quiz 9: Manipulation of Data
- 10. interpret the hardware specifications of a CPU type and speed; memory: capacity, type, word size, computer system; speed. Hard drive: capacity, speed; fire wire, expansion slots, ports.
- Quiz 10: Hardware Specifications of a Computer System
- 11. distinguish between systems programs and Systems software: operating systems, translators, utilities: application programs; Application software: general purpose, special purpose, custom written. Customization, integrated software.
- 12. explain the functions of an operating system; File management, memory management, security, device management, input/output management, user interface, process management.
- Quiz 11 & 12: System and Application Program
- 13. distinguish among multitasking, multiprocessing Basic treatment of these terms. (See glossary). and multiprogramming;
- Quiz 13
- 14. explain the different types of processing modes; Batch processing, real-time, on-line, time-sharing.
- Quiz 14: Processing Modes
- 15. distinguish between types of user interface. Software interface: Command driven, graphical user interface (GUI) (menu driven, pull-down and pop-up menus, icons). Hardware interface: touch screens, non- visual interface, sensors, and Braille keyboards.
- Quiz 15: User Interface
SECTION 4 A: INTERNET AND COMMUNICATIONS TECHNOLOGY
- 1. use terms associated with data communications and networks; Definitions of data communication and network; types of networks: (local area network, wide area network, metropolitan area network), types of transmission media: cable/wired media (coaxial, fibre-optic, twisted pair), wireless media (satellite, microwave, infra-red), wireless network technology: (Bluetooth, Wi-Fi), hotspot, modem, bandwidth (broadband, narrowband, voiceband), communication modes: (simplex, duplex, half duplex), point-to-point, and broadcast.
- Quiz 16: Data Communications and Network
- 2. distinguish among Internet, intranet and extranet;
- Quiz 17: The Internet, Extranet and Intranet
- 3. explain concepts associated with the Internet; Including Electronic mail (e-mail), newsgroups, Internet Relay Chat (IRC), Telnet, File Transfer Protocol (FTP), upload, download, World Wide Web (WWW), web browser, HTTP, Hypertext Markup Language (HTML/XHTML), web page, website, blogging, webserver, URL, e-commerce, e- learning, HTTP, pod-casting, bulletin board, VoIP.
- Quiz 18: The Internet
- 4. describe measures to secure data and maintain data integrity; Software Restrictions: passwords, encryption, virus protection, firewall; physical access restrictions: biometric systems, guards, locks; fire/water proof cabinets; archiving; backup and recovery procedures; propriety data and software.
- Quiz 19: Protecting and Maintain Data Integrity
SECTION 4 B: APPLICATIONS AND IMPLICATIONS
- 1. Misuse of Information
- Quiz 20: Misuse of Information
- 2. Hardware and Software in the Industries
- Quiz 21: Hardware and Software in the Industries
- 3. The Developmental of Trends in Technology
- Quiz 23: Information Technology on Job Skills and Careers
- 4. Information Technology – Job Skills and Careers
- Quiz 22: The development of Trends in Technology
- 5. Computer Related Professions
- Quiz 24: Computer Related Professions
SECTION 2 AND 3: Problem-Solving and Programming and Program Implementation
- 1. Generation of Programming Language
- Quiz 25: Generation of Programming Language
- 2. Problem Solving and Programming – Non Computer Based
- Quiz 26: Problem Solving and Programming – Non Computer Base
- 3. Problem Solving and Programming – Computer Based
- Quiz 27: Problem Solving and Programming – Computer Base
- 4. Problem Solving and Programming – Selection Statements
- Quiz 28: Problem Solving and Programming – Selection Statement
- 5. Problem Solving and Programming – Loop Statements
- Quiz 29: Problem Solving and Programming – Loop Statements
- 6. Problem Solving and Programming – Flowcharts Algorithm
- Quiz 30: Flowchart Algorithm
- 7. Problem Solving and Programming – Test and Validate Solution
- Quiz 31: Test and Validate Solution
- 8. Problem Solving and Programming – Introduction to Pascal Programming
- 9. Problem Solving and Programming – Conditional Statements in Pascal
- 10. Problem Solving and Programming – Looping Constructs in Pascal
- Quiz 34: Implementing the Program – Loop Construct in Pascal
- 11. Problem Solving and Programming – Documenting the Program
- Quiz 35: Documenting The Program
SECTION 5: Information Processing
SECTION 6: Word-processing, Presentation and Web Page Design
- A: WORD PROCESSING: 1. select appropriate editing features in the Deleting and inserting characters, words, lines, sentences, preparation of a document; paragraphs. Type-over mode. Selecting blocks of text. Copying and moving sections of text.
- 2. describe commonly available features; Page numbers, page breaks, text alignment, wordwrap, margins, tabs, page length, default settings, font size.
- 3. select appropriate formatting features for the Margins, tab stops, line spacing, page breaks, page preparation of a document; numbers, left and right justification, centre line, underline, highlight, uppercase, bold, and italic.
- 4. use headers, footers, footnotes and endnotes appropriately;
- 5. combine documents;
- 6. perform block operations;
- 7. use columns and tables appropriately;
- 8. apply appropriate character formatting Underline, bold, italics, font types and sizes, superscript features; and subscript.
- 9. use search and replace functions appropriately;
- 10. use mail-merge facilities; Creation of primary documents and data files in mail merge application; Field names.
- 11. use spell-check;
- 12. import documents; Text files, graphics, tables including options such as automatic
- B: PRESENTATION – 13. explain the uses of presentation software; For example, to enhance public speaking; to deliver lectures; to present project reports; to effectively present sales or marketing ideas.
- 14. explain the concepts of wizards, templates and slides;
- 15. choose appropriate slide layout; Slide layout must relate to the type of information being presented.
- 16. apply design templates to slides; Choosing from a list of presentation designs.
- 17. use formatting features effectively to enhance Changing background colour, font size and other attributes, presentation; such as font colour and bullets.
- 18. create slide headers and footers; Use of the slide master to personalize the slides.
- 19. create and use speaker notes;
- 20. apply various types of animation effects to Flying, drive-in, camera effects; flash-once, typewriter; laser, slides; reverse-texts, drop-in effects. Custom animation; timing and sound effects.
- 21. insert graphics and moving pictures into a slide;
- 22. manipulate multiple slides; Insertion and deletion of slides; use of the slide sorter.
- 23. present a slide show. Use of slide show tools such as slide navigator, pointer options, screen attributes.
- C: WEB PAGE DESIGN : 24. plan the website; Reasons for the website; the intended audience; number of web pages desired; content of each page; layout of the web pages.
- 25. create a simple web page; Choosing an appropriate design for a page; inserting and deleting text and graphics; wrap text with image; create thumbnail image, index page, home page, hyperlink.
- 26. create hyperlinks; Linking to another web page; link to a location within the web page; link to an email address; link to user-created files.
- 27. test the website; Use of a web browser; verify that all the hyperlinks work correctly; use a test audience.
- 28. publish and maintain a website. Registering domain names; locate hosting company; the use of the file transfer protocol (FTP) for uploading files.
SECTION 7: Spreadsheets
- 1. Explain the purpose of a spreadsheet; Definition of spreadsheet: a spreadsheet is a table consisting of cells (rows, column locations) that hold accounting or financial data and simulates the traditional physical spreadsheet; it captures displays and manipulates data.
- 2. Use appropriate terminology and notions Row, column, cell, cell address, label, value, formula, function, commonly associated with spreadsheets; worksheet, template, range, title, window, record.’
- 3. Formula errors – troubleshooting; Select basic pre-defined systems functions; Including sum, average, date, maximum, minimum, count, if, vlookup, rank.
- 4. Create advanced arithmetic formulae; Formulae involving addition, subtraction; multiplication; division; powers; square roots, the use of brackets.
- 5. Relative, Absolute and Mixed References.
- 6. Invoke row and column title locking; Horizontal, vertical, both.
- 7. Manipulate data on a spreadsheet; Effects of move, copy, delete operations on formulae.
- 8. Manipulate columns and rows; Insert and delete columns and rows.
- 9. Format a spreadsheet; Numeric data formatting, text formatting, alignment, borders.
- 10. Sort a spreadsheet; Primary field, secondary field, ascending vs. descending order.
- 11. Explain the purpose of charts; creating charts, tables.
SECTION 8: Database Management
- 1. explain the concept of a database; Definition of database: repository of information; collection of tables that are related to each other.
- 2. use terminology commonly associated with Database terminology: table (relation), entity, tuple, attribute, a database; primary key, secondary key, composite key, candidate key, alternate key, foreign key.
- 3. distinguish among terminology associated Row (tuple, record), column (attribute, field), key. with files and databases; Data types: alphanumeric; numeric; data; logical.
- 4. outline the advantages and limitations of Comparison with files with regards to: Speed; Ad hoc queries; databases; standardization; present multiple views of the same data.
- 5. create a database; Table structure with at least three data types and populate with at least twenty-five records. Use of wizard is prohibited.
- 6. modify a table structure; Adding new fields, deleting fields, changing field definitions.
- 7. sort a database; Arranging data in numeric, alphabetic; or alphanumeric format. Report generating facilities of the database package, including use of sorting, grouping statistical and summary features, for example, count, sum and average.
- 8. establish relationships; Use of joins, merge tables/files.
- 9. query a database using multiple search Using more than one criterion; use of select, calculated fields. conditions;
- 10. determine the results of a search on a database given multiple conditions; Two or more fields involving the use of relational and logical operators.
- 11. generate reports to the screen, printer and files. Report generating facilities of the database package, including use of sorting, grouping, statistical and summary features, for example, count, sum and average.
Very appreciative of IITAE. I was able to complete the CSEC Examination and successfully pass , I want to reassure those to come that it is fantastic and most definitely worth it!
IITAE is an amazing platform which i have used to better myself. It has given me an opportunity to take part in the Csec examination and pass. I have gained much knowledge,and hope that persons to come will have a great educational experience.
Having done the course Information Technology, I feel more prepared for the world of business. Truly appreciative.
This course is a must if you are looking to pass your CSEC exam. Amazing teaching method, with quizzes after each chapter, keeping your memory fresh and your work ethics in order.
This course has helped me achieve greater standards in my academics.Thank You!