GIT Application 2025

·   Identifies the computer as a system (IPO)

·   Recognizes a computer as a component of a system

·   Lists and describes the hardware components of a computer

·   Distinguishes peripherals as input devices, output devices, and input/output devices

·   Lists and briefly describes the types of software

·   Draws the block diagram of a computer and names its components

·   Briefly explains each component of a computer

·   Distinguishes data and information with examples

·   Names and briefly describe attributes of quality in a format

·   Block diagram of a computer

§  Input

·   Data and information

·   Attributes of quality information

Identifies the specification of personal computers

§  Processor

§  Memory

§  Hard Disk

§  Motherboard

·   Prepare the specification of

01

§  Chip set

§  Display

§  GPU (Graphics Processing Unit)

·   Software specifications for a PC

§  Operating System

§  Application Software

§  Utility Software

·   Selects software according to user requirements

Describes the data representation used in computers and the related fundamental concepts

§  Decimal

§  Binary

§  Hexadecimal

·   Relevant methods of conversion (Positive integers only)

§  Decimal to Binary

§  Binary to Decimal

·   Identifies the usage of number systems in computers

·   Converts a decimal number into binary

·   Converts a binary number into a decimal

02

Identifies Basic Boolean Operators

§  AND

§  OR

§  NOT

·   Draws Truth Tables for given Boolean expressions

01

Describes different character representation and their usage

§  ASCII

§  Unicode

·   Explains and compares ASCII and Unicode encoding

01

Investigate the contribution of OS to the functioning of a computer

·   Basic functions of an OS

·   Lists the basic functions of an OS

·   Distinguishes CLI and GUI

01

Uses the functions of operating systems

·   File names and extensions

·   Making changes in the 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

·   Identifies the file types by their extensions

·   Demonstrates the following operations for the existing files and folders

§ rename

§ copy and move

§ delete

·   Adjusts the settings in the settings panel when necessary

·   Identifies and uses the appropriate system tools for relevant tasks

02

Uses Application software in day-to-day activities

Uses the word processing software in day-to-day activities

·   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,

·   Briefly explains the usage of word processing software

·   Discusses the features of word processing software

·   Lists the components available in the GUI of a word processing software

·   Creates a new document

·   Applies proper text formats

·   Applies proper paragraph formats

·   Uses editing features to edit a document if necessary

·   Uses a grammar and spell checker tool

·   Inserts relevant graphic objects and edits those using relevant editing tools

·   Inserts equations, symbols, links, breaks, date, and time if necessary

·   Uses relevant shortcut keys

·   Creates a table using a preferred method

·   Inserts columns and rows into an existing table

·     Deletes unnecessary

06

· Shortcut keys

§ open/new/save/select all/cut

/copy/paste/undo/redo/print

·      Creating and formatting tables

§  Methods of creating a table

o Selecting rows and columns with a 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

·   Applies cell formats to a table

·   Merges and splits cells

·   Changes the height and width of rows and columns according to requirements

·   Saves documents in different formats according to the needs

·   Previews the document before printing

·   Prints a document after applying the necessary print setups

Uses spreadsheet software to solve simple mathematical problems

·   GUI of spreadsheet software

§  Work Book

§ Worksheet

§  Columns

§  Rows

·   Lists available spreadsheet software

·   Lists the functions of

06

§  Formula bar

§  Function of the 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

·   Identifies the components and features of the GUI of spreadsheet software

·   Moves around the worksheet

·   Lists the types of data entered into a cell

·   Applies relevant formats to the cells according to the requirement

·   Inserts rows and columns according to requirement

·   Deletes unnecessary rows and columns

·   Inserts, deletes, and renames worksheets according to requirement

·   Selects and names a range

·   Copies and moves cell contents according to requirements

·   Performs simple calculations using numbers and basic operators

·   Performs simple calculations using relative cell references and absolute cell references

·   Uses built-in functions to perform simple calculations

·   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

o   Page setup

§  Page options

§  Margin options

§  Sheet options

o   Print preview

o   Print

·   Creates charts

·   Uses the filter tool to query information

·   Uses sorting tool to organise data in an orderly manner

·   Sets the page according to the requirements

·   Previews and prints the worksheet

Uses electronic presentation software to enhance 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

· Shortcut keys specific to the presentation

·   Saving a presentation with different

·   Lists and explains the attributes of an effective presentation

·   Briefly explains the usage of presentation software

·   Discusses the features of presentation software

·   Creates a presentation attractively using

·   Printing a presentation with different options

·   Selects an appropriate layout relevant to the content

·   Inserts texts, pictures, sounds, videos, graphics, shapes, clip arts, tables, smart art, header and footer, page numbers, hyperlinks, action buttons, etc.

·   Applies a slide transition

·   Applies background

·   Applies a suitable custom animation to the content

·   Saves presentation in the required format

·   Presents the presentation

·   Uses relevant shortcut keys

·   Previews the Slides before printing

·   Prints the presentation to suit different needs

Uses Database Management System (DBMS) Software to manage data in a database

·   Comparison of manual database and automated database

·   Introduction to DBMS software

·   Objects of DBMS software

§  Table

§  Query

§  Form

·   Distinguishes manual from automated database

·   Defines DBMS

·   Identifies the need for a DBMS

·   Lists objects of the DBMS

·   Uses the fields and creates a table

06

·   Field names

·   Primary key and 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

·   Briefly describes the usage of the primary key and the foreign key

·   Selects and sets the most suitable field as the primary key

·   Applies the relevant field properties according to the requirements

·   Retrieves required information by using queries

·   Sorts records as required

·   Creates form using form wizard

·   Creates reports using the report wizard

Designs still graphics using a graphics software

§  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 and lossless formats

·   Basic operations of a graphics software

§   Open, save, and edit

§   Importing images

§   Sizing and transformation

§   Selections, cut, crop, replace

§   Working with layers

§   Working with Text

·   Creates attractive graphics using graphics software tools

·   Edits digital graphics as required

·   Uses basic text effects to enhance the appearance

Edits audio content using an audio editing software

·   Editing (editing a relevant segment from the original content)

·   Audio file formats

§ MP3, wav, au, etc.

·   Edits a relevant segment of audio from the original

·   Converts audio files to other formats as required

Edits videos using video editing software

·   Video file formats

§ MP4, avi, wmv, etc.

·   Converts video files to other formats as required

2

Uses the Internet

Explores the architecture

§  Data communication

2

·   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

·   Lists and briefly describes the communication devices of a network

·   Distinguishes between guided and unguided media

·   Briefly describes

§ Client-server model

§   Peer to peer

§   Hybrid

·   Distinguishes between wired and wireless networks

Uses the internet services to access relevant information

·   Web browsers and search engines

·   Internet services

o   WWW

§  Information sharing and electronic transactions

o   Email

o   Social Media

·  Briefly describes the Internet and its services

·  Uses web browsers and search engines for accessing Information

·  Creates an email account

·  Uses emails in

§  Blogging and microblogging

o   Cloud Computing

o   Cloud based services

·         Internet of Things(IoT)

o   Definition

o   Characteristics

o   Needs

o   Applications

o   Enabling Technologies

·  Downloads required information

·  Describes instant messaging and its types

·  Uses internet-based IRC, SMS, video calls, etc. for communication

·  Defines blogging and microblogging

·  Creates and uses blog to share information

·  Defines cloud computing

·   Uses cloud computing to store, manage and process data or information

·   Defines IoT

·   Briefly describes the characteristics of IoT

·   Identifies the need for IoT

·   Discusses the applications of IoT

·   Identifies Enabling Technologies for IoT

Develops websites incorporating multimedia components

Explores the arrangement and the composition of websites

§  Home page

§  Link page

·   Building blocks of a web page

·  Identifies the contents of a web page

§  Hyperlink

·   Organization of contents

§  Layout, frames, lists, tables

Analyses user requirements (multimedia contents) for web pages

·   Contents to be displayed

Uses HTML to create web pages

·   Basic HTML tags of a web page

§   Page definition

o   <html>, </html>

§   Head section,

o   <head></head>

o   <title></title>

§   Body section

o   <body></body>

§   Background color

§   Text formatting

o   <h1>…<h6>tags

o <p></p>

o   <br/>

o   Underline, bold, italic

o   <font:></font>

·         Size and color

·  Saves the source document with suitable extensions

·  Designs the web page by inserting appropriate multimedia objects according to user requirements

·  Organizes data using lists on the web page

§   Lists

o   Ordered lists

o   Unordered lists

§   Multimedia objects

o   Image

o   Audio

o   Video

Uses an authoring tool to create web pages

Explains the contribution of ICT towards national development

§ Education

–    Learning / Teaching Process

–    Learning Management System

–    School Management System

§ Health

– Investigation tools such as MRI scans, CAT scans, etc.

–    Simulations in medical education

–    Tele-medicine

§ Agriculture

–    Linking rural agricultural communities

–    Communicating with the administration

–    Meteorological Information

·  Lists and briefly describes the applications of ICT in various fields

·  Appreciates the contribution of ICT in national development

§ E- Business

–    Travel

–    Online shopping

–    Bank (ATM, Credit Card)

– Online Employment

§ E – Governance

–    Issuing of identity cards, driving licences and passports

–   Issuing birth, marriage, and death certificates

Seeks ICT career opportunities and paths to suit one’s life

§  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.

·  Identifies the tasks related to each ICT profession

Makes safe use of ICT

§ Cybercrime

§  Piracy

§  E- Laws

§  Sri Lanka Computer Emergency Readiness Team (SLCERT)

§  Unauthorised access

§  Ethical behaviour on cyberspace

–    Cyber stalking

–    Intellectual property (patent, copyright)

–    Plagiarism

–    Blackmail

·  Ethical and legal issues in social media

§  Inappropriate materials

·  Security

§  Hardware protection

–    Physical protection

o   UPS

o   Surge arresters

–    Environmental protection

o   Dust, Humidity, Sunlight,

Heat

o   Protection from natural disasters

§  Software protection

–    Anti-threat software

–    Firewall

·  Precautions in using the internet

·  Health & Safety

·  Gets aware of e-laws and SLCERT

·  Lists the good and bad impacts of social media

·  Identifies the threats to computer system

·  Take precautionary measures to protect the computer hardware and software

·  Identifies the issues arising from unsafe use of the internet and takes precautionary measures to prevent them

·  Identifies the health issues that arise from using a computer

·  Takes precautionary measures to avoid health issues when using computers

·  understands good and unfavourable computer habits

·  Defines e-waste

·  Briefly describes the adverse effects of improper disposal of E-waste

·  Disposes of e-waste in a

§  E-Waste and green computing

·  Recognizes and appreciates green computing

·  Adapts relevant workplace practices to minimize the health issues when working for a long hours with computers