The syllabus given here is based on competency levels.
Unit 1 : Data and Information
(Investigates the place of the computer in the world of information)
- Investigates the contribution of ICT towards national development
- Definition of ICT
- Application of ICT in the society
- e-government, agriculture, education, health, industry, entertainment
- Investigates the computer as a system for converting data into information
- Components of a system
- Difference between data and information
- Data as input and information as output
- Processing as the method for converting data into information
- Explores the evolution of computers to identify its major developments
- Computer generations
- Evolution of processor technology
- Vacuum tubes
- Transistors
- Integrated circuits: LSIC,VLIC
- Improvements in system characteristics
- Size
- Capacity
- Speed
- Accuracy
- Efficiency
Unit 2 : Fundamentals of a computer system
(Selects and uses computer hardware)
- Classifies computers using a variety of methods
- Explores computer systems by function
- Functions of a computer and its peripherals
- Input
- Processing
- Output
- Storage
- Communication
- Identifies and connects basic peripherals to the computer
- Basic computer components: keyboard, mouse, system unit and monitor
- Ports
- PS/2 port
- Serial port
- Parallel port(obsolete)
- USB port
- RJ 45
- Video port & HDMI, Audio(mic, speaker)
- Uses the basic block diagram to demonstrate the computer system
- Flow path
- Data and instruction signals
- Control signals
- Investigates benefits and concerns of computer networks for optimal communication
- Purpose of computer networks
- Data communication
- Resource sharing
- Components of a network
- Network Interface Card
- Internal and external devices
- Transmission media: guided and unguided
- Network cables: twisted pair, co-axial, fiber optics
- Modem, hub, switch, router
- Network operating system
- Types of computer networks: LAN,MAN,WAN
- Advantages and disadvantages of networks
Unit 3 : Data Representation Methods in the Computer system
(Investigates the methods used to represent data in computer systems)
- Uses the binary number system to represent data in computer systems
- Methods of data representations
- 1 and 0 to represent two states
- Binary number system
- Converts decimal numbers to Binary, Octal and Hexa Decimal
- Number systems: Decimal, Binary, Octal, Hexa Decimal
- Methods for number systems conversions
- Converts Binary numbers to Decimal, Octal and Hexa Decimal numbers and vice versa
- Methods for conversions (positive integers only)
- Binary to Decimal
- Binary to Octal
- Binary to Hexa Decimal
- Determines the capacity of data storage
- Units of measurement
Bit, Byte, Kilo Byte, Mega Byte, Giga Byte, Tera Byte - Order of capacities of different storage devices:
Cache, RAM, ROM, hard disk, compact disk, USB drives & magnetic tapes - Explores coding systems in computers
- BCD
- EBCDIC
- ASCII
- Unicode
Unit 4 : Logic Gates with Boolean Functions
(Uses Boolean logic to work effectively with logic gates)
- Identifies basic logic operators and draws truth tables to illustrate their functions
- Operators: AND, OR, NOR, NAND,NOT
- Introduction to Truth Tables (maximum of three inputs)
- Applies concepts of Boolean logic to find solutions to simple day-to-day life problems
- Design of logic for simple real world applications.
- Alarm systems
- Selection criteria
Unit 5 : Operating Systems
(Works effectively with Operating Systems)
- Explores operating systems by type, functions, benefits and concerns
- Introduction to OS
- Evolution of computer/human interface
- Types of operating systems: single user, multi user, multi tasking, real time
- Functions of the OS: user interface and resource management
- Benefits of the OS
- Utilities of an OS: Partitioning, Formatting, Defragmentation
- Handles files and folders in Operating Systems
- Introduction to the files system
- Drives
- Folders
- Files and file extensions
- File and folder operations
Unit 6 : Word Processing
(Uses Wordprocessing Software to Solve Day-to-day problems)
- Explores the concept and features of wordprocessing
- Performs basic tasks in wordprocessing software
- Functions of wordprocessing software
- GUI of wordprocessing software
- Uses different types of formatting in wordprocessing
- Formatting text
- Graphics: Insertion and formatting
- Shapes : Insertion and formatting
- Manipulates table feature in wordprocessing software
- Insertion of tables
- Column width and height
- Deletion, insertion, splitting and merging of cells
- Creates and prints documents
- Spelling and grammar checking
- Find and replace of text
- Page setup: paper size, margins, orientation and selection of printers
- Print options: copies and page range
- Uses the Mail Merge facility
- Document types
- Common document
- Source data
Unit 7 : Electronic Spreadsheet
(Uses Spreadsheet to solve simple statistical problems)
- Explores a Spreadsheet to identify its basic features and functions
- Moves around the worksheet to gain hands on experience of data entry
- Introduction spreadsheets
- GUI of spreadsheet software
- Worksheet, columns, rows and cells
- Moving around worksheet.
- Data entry (label, number, formulae)
- Performs basic mathematical operations
- Simple calculations using values and operators (+, -, *, /,^)
- Simple calculations using cell addresses and operators (+, -, *, /,^)
- Uses inbuilt functions for calculations
- SUM, AVERAGE, MAX, MIN, COUNT
- Formats a worksheet
- Font, Font size, Boldface, Italic etc.
- Alignment (centre, left, right, justify)
- Decimal places (increase and decrease)
- Uses relative versus absolute cell references appropriately
- Absolute and Relative cell references
- Creates charts using Spreadsheets to explain data
- Charts: chart type, chart options
- Chart types: Bar, column, line and pie
Unit 8 : Electronic Presentations
- Produces effective presentations integrating multimedia
- Introduction to presentation software.
- Changing background, slide layout, slide designs.
- Inserting text and multimedia
- Applies suitable animations to enhance the quality of presentations
- Slide transitions
- Custom animations
Unit 9 : Database
(Develops simple databases to elicit information)
- Develops simple databases to elicit information
- Introduction to databases.
- Definition of a database.
- Advantages of databases.
- Features of databases: Absence of redundancy, Efficiency, Accuracy, Consistency, Security, Validity, Simplicity.
- Manual and electronic databases: comparison and contrast.
- Introduction to Relational Databases: Tables, records, fields, key fields
- Creates a simple database with a single table, manually
- Field name, unique field, data types, field size
- Converts a manual database into electronic media
- Field name, data types, field size, Primary key, Field properties
- Design a simple relational database
- Tables, fields and key fields: Primary key, foreign key, relationships
- Uses DBMS software to create relational databases
- Creation of a database
- Identification of primary and foreign key
- Creation of relationship between tables
- Uses forms to view and update data
- Form design
- Manipulation of properties of a form
- Insertion of controls: Delete button
- Creates Queries to extract information
- Design of queries using query tool without using SQL structure.
- Use of criteria.
- Sorting of records
- Creates reports to present information
- Use of report Wizard
- Printing of reports
No comments:
Post a Comment