GIT (සාමාන්‍ය තොරතුරු තාක්ෂණය)

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Unit 1 : Describes the computer system using a block diagram
    1. System concept
    2. Introduction to computer
    3. Components of a computer
    4. Hardware
      1. Input / Output devices
      2. Memory devices
      3. Storage devices (Optical, Magnetic, Semiconductor)
      4. Processor
    5. Software
      1. System software (OS, Utilities)
      2. Application software
    6. Block diagram of a computer
      1. Input
      2. Processing unit (ALU, CU)
      3. Output
      4. Memory / Storage
      5. Flow of data and control instructions among components
    7. Data and information
    8. Attributes of quality information

Unit 2 : Identifies the specification of personal computers
  1. Hardware specifications of personal computers
    1. Processor
    2. Memory
    3. Hard Disk
    4. Motherboard
    5. Ports
    6. Chip set
    7. Display
    8. Graphics Processing Unit (GPU)
  2. Software specifications for a PC
    1. Operating System
    2. Application Software
    3. Utility Software

Unit 3 : Describes the data representation used in computers
    1. Number systems
      1. Decimal
      2. Binary
      3. Hexadecimal
    2. Relevant methods of conversion (Positive integers only)
      1. Decimal to Binary
      2. Binary to Decimal
    3. Basic Boolean Operators
      1. AND, OR, Not
    4. Encoding systems used in computers
      1. ASCII
      2. UNICODE

 


Unit 4 : Functions of operating systems
    1. Managing Folders and Files (creating, naming, renaming, deleting, copying and
      moving)
    2. File names and extensions
    3. Making changes in setting Panel
      1. Backup
      2. Fonts
      3. Mouse Settings
      4. Date and Time, Regional and Language Settings
      5. Add Remove Programs
      6. User Accounts
    4. Tools in OS
      1. Character Map
      2. Disk optimization
      3. Disk Checking
      4. Disk Cleaning

 


Unit 5 : Uses the word processing software (Microsoft Word)
    1. Introduction to word processing software
    2. Features of word processing software
      1. Title Bar
      2. Formatting Tools
      3. Editing Tools
      4. Page Setup Tools
      5. View Tools
      6. Designing Tools
      7. Scroll bars
      8. Editing Area
      9. Insertion Point, Cursor
      10. Status Bar
    3. Creating a new document
      1. Page layout and page borders
      2. Headers, footer and page numbers
      3. Typing text, formatting text
    4. Editing a document
      1. Find and replace
      2. Grammar and spell checker
      3. Cut / Copy / Paste
    5. Inserting objects
    6. Inserting equations, symbols, links, breaks, date and time
    7. Short cut keys
      1. open/new/save/select all/cut /copy/paste/undo/redo/print
    8. Creating and formatting tables
    9. Formatting paragraphs
    10. Saving documents in different formats
    11. Printing documents

 


Unit 6 : Uses spreadsheet software (Microsoft Excel)
    1. Introduction to spreadsheet software
      1. Work Book, Work Sheet, Columns, Rows, Cell, Formula bar
      2. Function of cell pointer based on its appearance
    2. Moving around the worksheet
    3. Types of data entries in a cell
      1. Text, Numbers, Formula
    4. Formatting cells
      1. Number, Alignment, Font
    5. Inserting rows and columns
    6. Deleting cells, rows and columns
    7. Worksheet
      1. Rename, Insert, Delete
    8. Naming and selecting cell ranges
    9. Copying and moving cell contents
      1. Cut, copy, paste and paste special
    10. Simple calculations
      1. arithmetic operations with basic Operators ( + , – , * , / )
      2. calculations using cell references and operators
      3. Relative cell references, Absolute cell references
    11. Inbuilt Functions
      1. sum, average, max, min, count and rank
    12. Types of charts
      1. Column, Bar, Line and Pie
      2. Chart tools
      3. design / layout / format
    13. Data filtering
    14. Data sorting
    15. Printing a worksheet
      1. Page setup
      2. Page options
      3. Margin options
      4. Sheet options
      5. Print preview, Print

Unit 7 : Uses electronic presentation software (Microsoft PowerPoint)
    1. Introduction to electronic presentation√
    2. Attributes of an effective presentation√
    3. Features of presentation software√
    4. Usage of presentation software√
    5. Selecting slide layout√
    6. Selecting background√
    7. Inserting text & multimedia contents√
    8. Applying slide transition and custom animation√
    9. short cut keys specific to the presentation√
    10. Saving a presentation with different formats
    11. Printing a presentation with different options√

 


Unit 8 : Uses Database Management System (DBMS) Software (Microsoft Access)
    1. Introduction to database
    2. Comparison of manual database and automated database
    3. Introduction to DBMS software
    4. Objects of DBMS software
      1. Table
      2. Query
      3. Form
      4. Report
    5. Field names
    6. Primary key and foreign key
    7. Data types
      1. Text
      2. Number
      3. Date / Time
      4. Currency
      5. Yes / No
    8. Field properties
      1. Field size
      2. Format
    9. Designing queries
      1. Filter fields
      2. Filter records
    10. Sort records
    11. Form wizard
    12. Report wizard

 


Unit 9 : Designs still graphics using a graphic software
    1. Types of graphics
      1. Raster
      2. Vector
    2. Properties of a digital image: pixel, resolution, size, color
    3. Graphic file formats and their features
      1. Jpg, png, gif, bmp etc.
    4. Image capacity and compression: lossy formats and lossless formats
    5. Basic operations of a graphic software
      1. Open, save and edit
      2. Importing images
      3. Sizing and transformation
      4. Selections, cut, crop, replace
      5. Working with layers
      6. Working with Text
    6. Edits audio contents using an audio editing software
      1. Recording audio contents
      2. Editing (editing a relevant segment from original content)
      3. Audio file formats
        1. Mp3, wav, au etc.
    7. Edits videos using an video editing software
      1. Manipulating and rearranging video
      2. Video file formats
        1. Mp4, avi, wmv etc.

Unit 10 : Uses the Internet efficiently and effectively to access and communicate information
    1. Purpose of computer network
      1. Data communication
      2. Sharing resources
    2. Network types
      1. PAN (Personal Area Network)
      2. LAN (Local Area Network)
      3. WAN (Wide Area Network)
    3. Communication devices of a network
      1. Modem
      2. Router
      3. Network Interface Card(NIC)
      4. Switch
      5. Wireless Base Station
      6. Mobile communication GPRS, GSM etc.
    4. Connectivity types
      1. Guided
      2. Unguided
    5. Wired and wireless networks
    6. Client server model
    7. Peer to peer
    8. Hybrid
    9. Uniform resource locator (URL) / Uniform resource identifier(URI)
    10. Web browsers and search engines
    11. Internet services
      1. WWW
      2. Information sharing and electronic transactions
      3. Email
      4. Social Media
      5. Internet based text and video based communication (Internet relay chat (IRC) / SMS / video calls etc.)
      6. Blogging and micro blogging
      7. Cloud Computing
      8. Cloud based services
    12. Internet of Things(IoT)
      1. Definition
      2. Characteristics
      3. Needs
      4. Applications
      5. Enabling Technologies

Unit 11 : Develops websites incorporating multi-media components
    1. Contents of a website
      1. Home page
      2. Link page
    2. Building blocks of a web page
      1. Text, graphics, audio, video, animation
      2. Hyperlink
    3. Organization of contents
      1. Layout, frames, lists, tables
    4. Defining the objectives of a website
    5. Contents to be displayed
    6. Introduction to Hyper Text Mark-up Language
    7. Basic HTML tags of a web page
      1. Page definition
        o <html>, </html>
      2. Head section,
        o <head></head>
        o <title></title>
      3. Body section
        o <body></body>
      4. Background color
      5. Text formatting
        o <h1>…<h6>tags
        o <p></p>
        o <br/>
      6. Underline, bold, italic
        o <font:></font>
    8. Size and color
    9. Adding comments
    10. Lists
      1. Ordered lists
      2. Unordered lists
    11. Multimedia objects
      1. Image
      2. Audio
      3. Video
    12. Introduction to web authoring tools

Unit 12 : Uses ICT efficiently and effectively to be successful in life
    1. Application of ICT
    2. Education
      1. Learning / Teaching Process
      2. Learning Management System
      3. School Management System
    3. Health
      1. Investigation tools such as MRI scan, CAT scan etc.
      2. Simulations in medical education
      3. Tele-medicine
    4. Agriculture
      1. Linking rural agricultural communities
      2. Communicating with the administration
      3. Meteorological Information
    5. Computer controlled devices
    6. E- Business
      1. Travel
      2. Online shopping
      3. Bank (ATM, Credit Card)
      4. On-line Employment
    7. E – Governance
      1. Issuing of identity cards, driving license and passports
      2. Issuing birth, marriage, death certificates
    8. Career opportunities related to ICT profession
    9. Ethical and legal Issues
    10. Ethical and legal issues in social media
    11. Security
    12. Precautions in using internet
    13. Health & Safety
    14. Repetitive Strain Injury (RSI)
    15. E-Waste and green computing
Show More

What Will You Learn?

  • Describes the computer system using a block diagram
  • Identifies the specification of personal computers
  • Describes the data representation used in computers
  • Functions of operating systems
  • Uses the word processing software (Microsoft Word)
  • Uses spreadsheet software (Microsoft Excel)
  • Uses electronic presentation software (Microsoft PowerPoint)
  • Uses Database Management System (DBMS) Software (Microsoft Access)
  • Designs still graphics using a graphic software
  • Uses the Internet efficiently and effectively to access and communicate information
  • Develops websites incorporating multi-media components
  • Uses ICT efficiently and effectively to be successful in life

Course Content

First Term

  • Describes the computer system using a block diagram(පරිගණක පද්ධතිය)
  • Describes the computer system …..(පරිගණක පද්ධතිය) (Video – 1)
    29:50
  • Describes the computer system …..(පරිගණක පද්ධතිය) (Video – 2)
    17:29
  • Identifies the specification of personal computers (පුද්ගලික පරිගණකවල පිරිවිතර )
  • Identifies the specification of …… (පුද්ගලික පරිගණකවල පිරිවිතර ) – (Video – 1)
    28:37
  • Identifies the specification of …… (පුද්ගලික පරිගණකවල පිරිවිතර ) – (Video – 2)
    25:39
  • Data Communication (දත්ත සන්නිවේදනය)
    00:00
  • Describes the data representation used in computers(පරිගණකවල භාවිතා වන දත්ත නිරූපණය)
    00:00
  • Functions of operating systems (මෙහෙයුම් පද්ධති)
    00:00
  • Functions of operating systems (මෙහෙයුම් පද්ධති) – (Video – 01)
    10:33
  • Functions of operating systems (මෙහෙයුම් පද්ධති) – (Video – 02)
    19:00
  • Word processing software (Microsoft Word)
  • Microsoft Word – (Video-01)
    37:58

Second Term

Third Term