GIT (සාමාන්ය තොරතුරු තාක්ෂණය)
About Course
Unit 1 : Describes the computer system using a block diagram
-
- 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
Unit 2 : Identifies the specification of personal computers
- Hardware specifications of personal computers
- Processor√
- Memory√
- Hard Disk√
- Motherboard√
- Ports√
- Chip set√
- Display√
- Graphics Processing Unit (GPU)√
- Software specifications for a PC
- Operating System√
- Application Software√
- Utility Software√
Unit 3 : Describes the data representation used in computers
-
- 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
- Number systems
Unit 4 : Functions of operating systems
-
- Managing Folders and Files (creating, naming, renaming, deleting, copying and
moving) - File names and extensions
- Making changes in setting Panel
- Backup√
- Fonts√
- Mouse Settings√
- Date and Time, Regional and Language Settings√
- Add Remove Programs√
- User Accounts√
- Tools in OS
- Character Map√
- Disk optimization√
- Disk Checking√
- Disk Cleaning√
- Managing Folders and Files (creating, naming, renaming, deleting, copying and
Unit 5 : Uses the word processing software (Microsoft Word)
-
- Introduction to word processing software
- Features of 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
- Inserting equations, symbols, links, breaks, date and time
- Short cut keys
- open/new/save/select all/cut /copy/paste/undo/redo/print√
- Creating and formatting tables
- Formatting paragraphs
- Saving documents in different formats
- Printing documents
Unit 6 : Uses spreadsheet software (Microsoft Excel)
-
- Introduction to 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√
- Introduction to spreadsheet software
Unit 7 : Uses electronic presentation software (Microsoft PowerPoint)
-
- 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√
Unit 8 : Uses Database Management System (DBMS) Software (Microsoft Access)
-
- 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 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
Unit 9 : 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 and 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.
- Types of graphics
Unit 10 : Uses the Internet efficiently and effectively to access and communicate information
-
- 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
- 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
- Purpose of computer network
Unit 11 : Develops websites incorporating multi-media components
-
- 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
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/> - Underline, bold, italic
o <font:></font>
- Page definition
- Size and color
- Adding comments
- Lists
- Ordered lists
- Unordered lists
- Multimedia objects
- Image
- Audio
- Video
- Introduction to web authoring tools
- Contents of a website
Unit 12 : Uses ICT efficiently and effectively to be successful in life
-
- 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 Employment
- E – Governance
- Issuing of identity cards, driving license and passports
- Issuing birth, marriage, death certificates
- Career opportunities related to ICT profession
- Ethical and legal Issues
- Ethical and legal issues in social media
- Security
- Precautions in using internet
- Health & Safety
- Repetitive Strain Injury (RSI)
- E-Waste and green computing
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