Home / Video / GIT Syllabus – Competencies

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

About admin

Check Also

GIT Diagnostic Test MCQ 2022 Wayamba

Leave a Reply

Your email address will not be published. Required fields are marked *