Information Technology

{"examination": "CSEC Information Technology", "syllabus_topics": {"Section 5: Spreadsheets": ["Purpose and common features of spreadsheets: workbooks, cells, formulas, and functions [27, 28]", "Use of pre-defined system functions (SUM, AVERAGE, IF, VLOOKUP, etc.) [28]", "Creating advanced arithmetic formulae and replicating them using relative and absolute addressing [28, 29]", "Data manipulation: sorting, filtering, and creating Pivot Tables [29]", "Charting operations and linking data across multiple worksheets [30]"], "Section 6: Database Management": ["Database concepts as repositories of related tables [31, 32]", "Database terminology: tables, records (rows), fields (columns), and various keys (primary, foreign) [32]", "Defining table structures and establishing relationships (one-to-one, one-to-many) [32, 33]", "Manipulating data through forms, queries (simple and complex), and reports [33, 34]"], "Section 8: Program Implementation": ["Applying programming language code to automate tasks [38]", "Translating algorithms into end-user applications using translators [39]", "Coding logic: input/output, conditional branching (if-then-else), and iterations (loops) [40]", "Testing programs with test data and correcting logic errors [31, 39]"], "Section 7: Problem-Solving and Program Design": ["Steps in problem-solving: define, propose, evaluate, develop algorithm, and validate [35]", "Structured approach: decompose large problems into smaller tasks [35]", "Defining problems using IPO (Input-Process-Output) charts [36]", "Distinguishing between variables, constants, and data types [36]", "Representing algorithms using flowcharts and pseudocode [37]", "Testing algorithms for correctness using trace tables (desk checks) [37]"], "Section 4: Word-Processing and Web Page Design": ["Creating and formatting documents using a range of sources and objects [21]", "Editing features: search and replace, block operations, and columns [22]", "Advanced features: Mail Merge, Table of Contents generation, and document protection [23, 24]", "Creating fillable electronic forms using content controls [24]", "Planning website structure, intended audience, and layout [24, 25]", "Creating web pages with text, graphics, and hyperlinks [25, 26]", "Evaluating websites for accuracy and user-friendliness [26]"], "Section 2: Computer Networks and Web Technologies": ["Types of networks: LAN, MAN, WAN, and mobile networks [11]", "Wireless technologies: Bluetooth, Wi-Fi, and hotspots [12]", "Network privacy levels: Intranet, Extranet, and Internet [12]", "Functions of network components: transmission media, switches, routers, modems, and NICs [12, 13]", "Importance and suitability of mobile networks for various fields [13]", "Key Web technology concepts: WWW, HTML, HTTP, HTTPS, URL, FTP, and hyperlinks [13, 14]"], "Section 1: Computer Fundamentals and Information Processing": ["Definition and scope of Information Technology [1]", "Major types of computer systems: Super Computers, Mainframes, Desktop, Mobile, and Embedded devices [2]", "Functions of hardware components: CPU, primary memory (RAM/ROM), secondary storage, and input/output [3]", "Input-Processing-Output-Storage (IPOS) cycle [4, 5]", "Relative merits of cloud storage versus local storage [4]", "Selection of appropriate input/output devices for specific applications [4, 6]", "Role of Operating Systems and types of Application Software (general-purpose, custom-written, etc.) [6]", "Merits of different user interfaces: command line, menu-driven, graphical user (GUI), and touch [6]", "Troubleshooting basic hardware problems (cables, monitors, printers) [7, 8]", "Distinguishing between raw data and processed information [6]", "Evaluation of information reliability from online sources [9]", "Data validation and verification methods and differences [9, 10]", "File organization methods: sequential, serial, direct, and random [10]"], "Section 3: Social and Economic Impact of Information and Communications Technology (ICT)": ["Concepts of computer security, cybersecurity, and computer misuse [15]", "Impact of computer systems misuse: cyberbullying, hacking, identity theft, and piracy [16]", "Countermeasures for threats: firewalls, biometrics, encryption, and antivirus software [16]", "Effect of automation on job security and productivity [17]", "Roles of ICT personnel: Network Engineers, Programmers, Systems Analysts, and Web Developers [17, 18]", "Economic and social impact of ICT on Education, Medicine, Business, Law Enforcement, and Recreation [18-20]"]}}