Competency 1 Explores the computer and its potential to reap timely benefits
- System concept
- Introduction to computer
- Components of a computer
- Hardware
- Input / Output devices
- Memory devices
- Storage devices (Optical, Magnetic, Semiconductor)
- Processor
- Software
- System software (OS, Utilities)
- Application software
- Hardware
- Block diagram of a computer
- Input
- Processing unit (ALU, CU)
- Output
- Memory / Storage
- Flow of data and control instructions among components
- Data and information
- Attributes of quality information
- Hardware specifications of personal computers
- Processor
- Memory
- Hard Disk
- Motherboard
- Ports
- Chip set
- Display
- Software specifications for a PC
- Operating System
- Application Software
- Utility Software
Competency 2 representation of data inside a computer
- Number systems
- Decimal
- Binary
- Hexadecimal
- Relevant methods of conversion (Positive integers only)
- Decimal to Binary
- Binary to Decimal
- Basic Boolean Operators
- AND
- OR
- NOT
- Encoding systems used in computers
- ASCII
- Unicode
Competency 3 Operating System (OS)
• Introduction to Operating System
• Basic functions of an OS
• Managing Folders and Files (creating, naming, renaming, deleting, copying and moving)
• File names and extensions
• Creates folders and files with proper names
• Identifies the file types by their extensions
• Making changes in Settings Panel
▪ Backup
▪ Fonts
▪ Mouse Settings
▪ Date and Time, Regional and Language Settings
▪ Add Remove Programs
▪ User Accounts
• Tools in OS
▪ Character Map
▪ Disk Defragmentation
▪ Check Disk
▪ Disk Clean Up
Competency 4: Uses Application software in day to day activities
4.1 Uses the word processing software in day to day activities
• Introduction to word processing software
• Features of word processing software
• GUI components in word processing software
▪ Title Bar
▪ Formatting Tools
▪ Editing Tools
▪ Page Setup Tools
▪ View Tools
▪ Designing Tools
▪ Scroll bars
▪ Editing Area
▪ Insertion Point, Cursor
▪ Status Bar
• Creating a new document
▪ Page layout and page borders
▪ Headers, footer and page numbers
▪ Typing text, formatting text
• Editing a document
▪ Find and replace
▪ Grammar and spell checker
▪ Cut / Copy / Paste
• Inserting objects and usage of relevant editing tools
▪ pictures/charts/shapes/clip art /word art /text box etc.
• Inserting equations, symbols, links,
• Uses relevant short cut keys
• Inserts columns, rows to a existing table breaks, date and time
• Short cut keys
▪ open/new/save/select all/cut /copy/paste/undo/redo/print
• Creating and formatting tables
▪ Methods of creating a table
Selecting rows and columns with mouse /insert table/draw table
▪ Insert and delete rows and columns
▪ Merge and split cells
▪ Change row height/column width
▪ Table borders
▪ Styles
• Formatting paragraphs
• Saving documents in different formats
• Printing documents
▪ Print preview
▪ Print setup
▪ Printer properties
4.2 Uses spreadsheet software to solve simple mathematical problems
Introduction to spreadsheet software
- GUI of spreadsheet software
- Work Book
- Work Sheet
- Columns
- Rows
- Cell
- Formula bar
- Function of cell pointer based on its appearance
- Moving around the worksheet
- Types of data entries in a cell
- Text
- Numbers
- Formula
- Formatting cells
- Number
- Alignment
- Font
- Inserting rows and columns
- Deleting cells, rows and columns
- Worksheet
- Rename
- Insert
- Delete
- Naming and selecting cell ranges
- Copying and moving cell contents
- Cut, copy, paste and paste special
- Simple calculations
- arithmetic operations with basic Operators ( + , – , * , / )
- calculations using cell references and operators
- Relative cell references
- Absolute cell references
- Inbuilt Functions
- sum, average, max, min, count and rank
- Types of charts
- Column, Bar, Line and Pie
- Chart tools
- design / layout / format
- Data filtering
- Data sorting
- Printing a worksheet
- Page setup
- Page options
- Margin options
- Sheet options
- Print preview
4.3 Uses electronic presentation software to enhance presentation
- Introduction to electronic presentation
- Attributes of an effective presentation
- Features of presentation software
- Usage of presentation software
- Selecting slide layout
- Selecting background
- Inserting text & multimedia contents
- Applying slide transition and custom animation
- short cut keys specific to the presentation
- Saving a presentation with different formats
- Printing a presentation with different options
4.4 Uses Database Management System (DBMS) Software to manage data in a database
- Introduction to database
- Comparison of manual database and automated database
- Introduction to DBMS software
- Objects of DBMS software
- Table
- Query
- Form
- Report
- Field names
- Primary key
- foreign key
- Data types
- Text
- Number
- Date / Time
- Currency
- Yes / No
- Field properties
- Field size
- Format
- Designing queries
- Filter fields
- Filter records
- Sort records
- Form wizard
- Report wizard
Competency 5: Creates Multimedia contents
Designs still graphics using a graphic software
- Types of graphics
- Raster
- Vector
- Properties of a digital image: pixel, resolution, size, color
- Graphic file formats and their features
- Jpg, png, gif, bmp etc.
- Image capacity and compression:
- lossy formats
- lossless formats
- Basic operations of a graphic software
- Open, save and edit
- Importing images
- Sizing and transformation
- Selections, cut, crop, replace
- Working with layers
- Working with Text
Edits audio contents using an audio editing software
- Recording audio contents
- Editing (editing a relevant segment from original content)
- Audio file formats
- Mp3, wav, au etc.
- Edits videos using an video editing software
Manipulating and rearranging video
- Video file formats
- Mp4, avi, wmv etc.
Competency 6: Uses the Internet
- Explores the architecture
- Purpose of computer network
- Data communication
- Sharing resources
- Network types
- PAN (Personal Area Network)
- LAN (Local Area Network)
- WAN (Wide Area Network)
- Communication devices of a network
- Modem
- Router
- Network Interface Card(NIC)
- Switch
- Wireless Base Station
- Mobile communication
- GPRS, GSM etc.
- Connectivity types
- Guided
- Unguided
- Wired and wireless networks
- Client server model
- Peer to peer
- Hybrid
- Uses the internet services to access relevant information
- Uniform resource locator (URL) / Uniform resource identifier(URI)
- Web browsers and search engines
- Internet services
- WWW
- Information sharing and electronic transactions
- Social Media
- Internet based text and video based communication (Internet relay chat (IRC) / SMS / video calls etc.)
- Blogging and micro blogging
- Cloud Computing
- Cloud based services
- Internet of Things(IoT)
- Definition
- Characteristics
- Needs
- Applications
- Enabling Technologies
Competency 7 : Develops websites
- Contents of a website
- Home page
- Link page
- Building blocks of a web page
- Text, graphics, audio, video, animation
- Hyperlink
- Organization of contents
- Layout, frames, lists, tables
- Defining the objectives of a website
- Contents to be displayed
- Introduction to Hyper Text Mark-up Language
- Basic HTML tags of a web page
- Page definition
- <html>, </html>
- Head section,
- <head></head>
- <title></title>
- Body section
- <body></body>
- Background color
- Text formatting
- <h1>…<h6>tags
- <p></p>
- <br/>
- Underline, bold, italic
- <font:></font>
- Size and color
- Adding comments
- Lists
- Ordered lists
- Unordered lists
- Multimedia objects
- Image
- Audio
- Video
- Introduction to web authoring tools
Competency 8: Uses ICT efficiently and effectively
- Application of ICT
- Education
- Learning / Teaching Process
- Learning Management System
- School Management System
- Health
- Investigation tools such as MRI scan, CAT scan etc.
- Simulations in medical education
- Tele-medicine
- Agriculture
- Linking rural agricultural communities
- Communicating with the administration
- Meteorological Information
- Computer controlled devices
- E- Business
- Travel
- Online shopping
- Bank (ATM, Credit Card)
- On-line Jobs
- E – Governance
- Issuing of identity cards, driving licence and passports
- Issuing birth, marriage, death certificates
- Career opportunities related to ICT profession
- Software Engineer
- Software Quality Assurance Engineer
- Business Analyst
- IT Project Manager
- Graphic Designer
- Software Architect
- Quality Assurance Leader
- Technical Leader
- Network Administrator
- Database Administrator
- Computer Application Assistant
- IT Manager etc.
- Makes safe use of ICT
- Privacy
- Piracy
- E- Laws
- Sri Lanka Computer Emergency Readiness Team (SLCERT)
- Unauthorised access
- Ethical behaviour on cyberspace
- Cyber stalking
- Intellectual property (patent, copyright)
- Plagiarism
- lackmail
- Ethical and legal issues in social media
- Inappropriate materials
- Security
- Hardware protection
- Physical protection
- UPS
- Surge arresters
- Environmental protection
- Dust, Humidity, Sunlight, Heat
- Protection from natural disasters
- Software protection
- Anti-threat software
- Firewall
- Precautions in using internet
- Health & Safety
- Repetitive Strain Injury (RSI)
- E-Waste and green computing