GIT Syllabus – Competencies

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
• 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

▪ Print

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
• Print

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
  • Email
  • 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