Computer Training Manual 2020

Input, Output, Storage, Processing Devices, Memory types, System software and Application Software
Classification of Computers
Character Codes, Numbering System, Logic Gates
Windows Operating System
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Access
Internet Facilities WWW
Working With Web Browser
use Search Engine
Creating Email address and working with Email

Essentials in ICT for Government Offices (C212)

Introduction to RTI Concept
RTI & people Rights
What is Electronic Data & How to create Electronic Data
Information Security
Cyber Security & Cyber Crimes
Cyber Laws & Cyber Acts
World Wide Web & Web Browsing
Using Search Engines, Downloading & uploading
Handling mails & Attachments
Messaging services, Video based
Communication & Social media networking
Internet Based Remote Access
Reading / Uploading files to Virtual Drivers
Sharing files & Setting Permission
Introduction to Viruses / Malware
Installing Viruses Guard
What is QR code & Generating QR code
Scanning Documents, Burning CD / DVD Voice Recording…

National Certificate in Information Communication Technology (NVQ Level 4) (C213)

Input, Output, Storage, Processing Devices, Memory types, System software and Application Software
Classification of Computers
Character Codes, Numbering System, Logic Gates
Windows Operating System
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Access
Internet Facilities WWW
Working With Web Browser
use Search Engine
Creating Email address and working with Email
Install Windows Operating System and Drivers
Install Virus Guard and Install Application Software Network Types, Topologies, Data Transmission Methods, Networking, Trouble shooting
Use Photoshop Software to Design Graphics
Basic Knowledge of HTML and CSS
Create Static web using Dream viewer
Design Interfaces using VB.Net
Structure programming (Pseudo Code, ER diagram and flow Charts)

Certificate in Microsoft Project (C214)

Getting Start with MS Project
Define a project
Creating and organizing tasks
Maintaining a project plan
Manage resources
Executing a project
Monitoring project progress
Controlling a project plan
Progress reports
Customizing the application

Certificate in Data Analyzing (C215)

Advance Excel Functions
If Analysis
Advance Filtering
Pivot Table & Chart
Using analyzing tools

Certificate in Database Designing (C216)

Introduction to Database Designing
Relationship Diagrams
Normalization concepts
Create Forms/Reports

Certificate in Creating & Managing Electronic Files (C217)

What is Electronic Data & How to create Electronic Data
Scanning Images/Documents with different formats
Video Editing
Pictures Editing with Photoshop
Updating OS & Application Software

Introduction to IT Procurement (W106)

Identifying the requirements (SON/SOR)
Identifying major cost elements and Components parts of the equipment.
Aggregating similar requirements to reduce purchase price & cost
Letter of Acknowledgement
Tendering Instructions
Conditions of Tender
Form of Tender
Contract Documents

C218 - ICT and E-Government for Executives

Role of Information Systems in an organization
Classification of Information Systems
Information system implementation
Critical Success Factors
Computer system architecture
Mega trends in digital development
Computer Networks and related technologies: LAN, and WAN; Wire and wireless technologies
Classification of computer networks.
Basics in cloud concept
AI applications and Industry usage
The principles of E-Government
E-Government Maturity models
Future of eGovernment
Changing attitudes to move towards E-Government
Role of Manager in E-Government implementation
Issues and challengers faced in project implementation
Measures taken to achieve target and overcome challengers and issues
Success factors & failures in the e Government initiatives in Sri Lanka
Requirement of national policies
Issues of authentication and authorization.
Common vulnerabilities and attacks; prevention and detection.
Definition of Personal information
Introduction to E-Commerce
E-Laws and Policy E-Government Policy
Different Laws related to computers

Certificate in Statistical Analysis for Decision Making (Computer Based Hand-on Experience) (C-219)

Items in a scientific research
Research problem, questions, objectives, and hypothesis of the study
What is an Empirical Analysis?
Role of Statistics in Management
Effective presentation of data
Identification of Variables & Data types
Crating a database / Save/ Open data/ output file. Working with data files
Bar charts/ Pie charts /Scatter plots/ Box plots /Histograms
Editing a chart/graph/ Importing charts/ graphs into Word document
One-way table, Two-way table
Tables with percentages
Summary measures
Introduction to Inferential data analysis
Estimation and Hypothesis testing
Parametric and Non-parametric tests
Mean comparisons / One sample test
Two Independent-Samples/Multiple samples
Chi-Square Tests with Contingency Tables
Cramer’s V and Contingency Coefficient
Correlation analysis with Pearson’s Test / Spearman’s test1
Linear regression models, significant variables, accuracy of the model, and Predictions
Factor analysis and Reliability analysis
Presenting and interpreting the results

Certificate in Procurement of IT related Goods and Services (C220)

Success and failure factors of IT Procurement IT Procurement Challenges and Planning Requirements
Intellectual Property Rights
IT Procurement ethics
Importance of domain experts
Prequalification process in IT Procurement
Preparation of Standard Bidding Documents for IT Procurement

Technical Requirements

Business Function & Performance Requirements
Technical Specifications
Testing Requirements
Implementation Schedule
Systems Integration elements
Training
Technical Support
Maintenance (Warranty & Post-Warranty)

Recurrent Costs, maintenance cost, Installation Costs, Migration cost, Training costs, etc.
Service level agreements
Evaluation Methodologies
Bidder Qualifications

Case studies - IT Goods and Services

Certificate in Computer Networking Fundamentals (C221)

History of Networking/Internet
Introduction about Networking
Introduction about Internet
Networking Terminology
Types of Networks
Network Topologies
Network Communication Devices
Modes of Transmission
ISO Referencing Models
Protocols
Domain Name Service
IP Addressing
Structured Cabling
Windows Server Installation
Structured Cabling
Windows Server Installation
Windows Server Services
Network Administration
Disk Management
Cloud Computing
Virtualization Concepts
Configure Network Device
Troubleshooting

Diploma in Information and Communication Technology (NVQ Level 5) (D301)

Main Subject Areas	Content Outline
· Database Systems 1 K72T001M01 5	Introduction to DBMS Database architecture and modeling Database design process Relational Data model Entity-Relationship model Data Normalization process and the normalization Data manipulation using SQL Physical database design
· Database Systems 11 K72T001M02 8	Advanced Databases Concepts Data manipulation with SQL Programming Database Applications Database Administration Database administration procedures
· Graphic Design K72T001M03 11	Introduction to graphics Drawing Tools Image Types & File formats Import and Export functions in graphic applications Printing Technology Graphic Industry and business Copyrights, Ethics and Plagiarism Preparation of Estimates and Budgets Planning Project Proposal Managing Graphic Projects
· Software Programming K72T001M04 14	Identify Basic Syntax Identify Class & Object Object Oriented Concepts Graphical User Interface ( GUI ) Stream and exception handling Database Processing IDE, Source code management tool (eg. Visual Source Safe [VSS])
· Software Testing K72T001M05 16	Identify Test needs Identify Basic test process Identify Software Test life cycle Test design technique Test design and administration Test supportive tools
· System Analysis and Design K72T001M06 18	Definition of a system Introduction to System Analysis and Design Requirement gathering and fact finding techniques Data Modeling Techniques Object oriented system design System Requirement Specification Prototype Development and presentation
· Web Programming K72T001M07 21	Web contents development 1 (HTML) Cascaded Style Sheets(CSS) Web contents development 2(XML) ASP. NET1/PHP (Basic syntax) ASP. NET2/PHP, ASP.NET3/PHP, ASP.NET4/PHP Multimedia application Role of a web server Install, configure and maintain web server Publishing a web site
· Local Area Networks (LAN)	Functionality of LAN Analyze hardware and software requirements for Local Area Networks Develop and design Local Area Network Structure Prepare hardware and software specifications Create a final proposal for a LAN
· Workplace Information Management EMPM01	Identification of documentation requirements Selecting and/or collecting required documentation Documentation procedures and methods Completing / perfecting documentation Reading, interpreting and using equipment/ system manuals and specifications Interpretation of all applicable laws, policies and procedures relevant to enterprise Computer and information system usage Forecasting Techniques, Forecasting Software Mathematical Modeling Data Collection Techniques for Market Research The range of analytical techniques appropriate for analysis of information The influence of human factors on information analysis, e.g. Prejudices and biases Conducting and recording of performance evaluations
· Workplace Communication Management EMPM02	Basic communication models - (Reference to 2 typical models) Principles of effective, interactive communication Barriers to effective communication and distortions in the communication process Personal values and communication Policies of the organization relevant to information and communication function Protocol and Procedures of the organization Importance of ICT tools in promoting the efficiency and effectiveness of the organization Common computer applications Importance of networking in day to day activities of the organization
· Planning and Scheduling Work at Workplace EMPM03	Goals and Objectives of the organization Planning priorities Plans related to work and related activities at workplace Systems, procedures and processes relevant to the organization Quality and continuous improvement processes applied within the organization Company specific performance standards Industry/Workplace Codes of Practice /Codes of ethics Frontline management roles applicable to team management Manufacturer’ s specifications and product specifications Standard specifications of commonly used materials Simple planning techniques/methods - ( two to three common techniques/methods) Forecasting Techniques /methods Time management techniques Competency assessment methods

W107- Workshop on E-Government & E-Governance

Overview of e-Government
E-Government Maturity models
Benefits & Impact of E-Government
E-Government Applications

Front office delivery
Back office delivery

E- Governance?
Difference between
Trends in E- Government
Need of Information Security
Information Security Trends and Directions
Protection of Privacy
CSIRT Establishment and Operation
SMART cities in IOT environment
Currently where we are & where to go?

W108- Workshop on Right to Information (RTI) and IT related Laws

Main Subject Areas	Content Outline
· (Day 1) Introduction to RTI	Overview of RTI act Importance/ Need of RTI Benefits of RTI How to apply Right to information Complications of implementation E-Government & RTI impacts
· (Day 2) Laws and regulations on ICT	E Laws and Policy E Government Policy The Electronic Transactions Act No. 19 of 2006 The Computer Crimes Act No. 24 of 2007 The Information and Communication Technology Act No. 27 of 2003 The Intellectual Property Act No. 36 of 2003 Payment and Settlement Systems Act No.28 of 2005 Payment Devices Frauds Act No. 30 of 2006

W109 - Training of Trainers (TOT) workshop on Smart Class Room Concept & Applications for Teachers

How to use Interactive Whiteboard
How to use All-in-One Interactive Digital Touch Panel
How to use LinkGO E-Class Software
Class Room Management Software’s
POE Technology, Scanning Basics, Printing, Email, Efaxing
Remote Control, Desktop Sharing, Device technologies
Using App Store, Device configurations
Cloud Services, Using Google apps / Drive as effective learning tool
Creation of PDF, Multi-languages, Math Calculation tools
Voice and video recording, Using YouTube for education
Scanning A4,A3 Documents, Image Editing & Processing
Introduction about OCR Technology
Introduction about Technologies, Configuring Network Devices, Troubleshooting Network Devices
Creating Wi-Fi Hotspots

W110 - Workshop on Management Information Systems (MIS) for office Administration

Role of the CIO
Applications and limitations of popular IT management practices
models and frameworks
Decision Support Systems, Executive Support Systems,
An overview of Enterprise Information Systems
Enterprise Resource Planning (ERP).
Manufacturing Resource Planning (MRP)
Customer Relationship Management (CRM)
Supply Chain Management (SCM)
Accounting Information Systems (AIS)
Knowledge Management System (KMS)
Content Management System (CMS)
Management Information Systems Best Practices Ex. In Sri Lankan context, Discussion
Planning and controlling, MIS implement process