Computer Training Manual 2019

  • Introduction to ICT, Data & Information
  • Computer Hardware & Software
  • Security, Environment & Health Issues
  • Changing basic System settings, Handle Files & Folders.
  • Creating, Editing, Formatting quality Documents
  • Saving & Printing Documents.
  • Creating Worksheets.
  • Formula & Building Functions.
  • Creating Charts & Printing
  • Creating Presentation.
  • Introduction to Internet.
  • WWW. Searching Information.
  • E-Mail.
  • Introduction to Word Processing
  • Creating & Formatting Documents
  • Editing & Inserting Objects
  • Manipulating of Tables
  • Mail Merge & Printing Documents
  • Introduction to Electronic Spread Sheets
  • Formula & Functions
  • Sorting & Filtering Data
  • Analyzing Data, Creating Charts
  • Printing Worksheets & Charts
  • Run Macros
  • Introduction to Database & DBMS
  • Creating Desktop Databases
  • Designing Tables, Queries, Forms & Reports
  • Maintenance of Databases
  • Designing a presentation
  • Working with Slide layout and view modes, Organizing the contents
  • Add animation & Transition
  • Organizing & Publishing a presentation
  • Printing Slides & Handouts
  • Concepts of Internet, Internet Services
  • E-mail & Communication Methods
  • Using Virtual Drives
  • Creating datasheets with built in functions (Advance)
  • Data Analyzing with Excel
  • Database Designing
  • Relationships
  • Different types of Queries
  • Creating Electronic Files
  • Data Sharing
  • Creating & Editing pictures
  • Editing Video Clips
  • Maintenance Of PC
  • Introduction to Word Processing
  • Word Processing Software
  • Using Document Templates.
  • Creating, Editing & Formatting documents
  • Bulleted, numbering & multilevel list
  • Tab stop position
  • Formatting paragraphs and columns
  • Manipulating of tables
  • Inserting objects
  • Header & Footer
  • Using references & styles
  • Creating Mailing letters & Envelops
  • Spelling & Grammar, Thesaurus
  • Page layout & print documents
  • Sharing documents
  • Introduction to Spread Sheet software
  • Interface Window & moving around worksheet
  • Entering & Editing Cell contents
  • Data types of cell entries
  • Relative & Absolute cell references
  • Formula & Building Functions
  • Copying Texts, Numbers & Formula
  • Formatting Cells & worksheets
  • Working with different sheets
  • Saving worksheets with password protection
  • Sorting, Filtering & advance Filtering
  • Introduction to Database
  • Introduction to Relational database
  • Designing simple data base
  • Normalization
  • Introduction to DMBS
  • Creating data base by using DBMS
  • Designing Tables, Queries, Forms & Reports
  • Working with data entry forms
  • Using Expression Builder for doing calculations
  • Designing Update, Delete, Make table & append queries for updating a database
  • Link with other database
  • Imports objects from other database
  • Imports Excel sheets
  • Creating Macros & Interface Forms
  • Introduction to Computer Hardware
  • Assembling a PC
  • Partitioning a Computer
  • Installing and Configuring Operating System
  • Installing and Configuring application Software
  • Introduction to BIOS
  • BIOS Update Using Firmware
  • Introduction about Dual Booting
  • Windows System Recovery Methods
  • System Backup and Restore
  • Create System Restore points
  • Downloading Software/Firmware and Drivers from internet
  • Diagnosing and trouble shooting
  • Upgrading the Computer
  • Introduction to FOSS
  • Installing FOSS packages
  • Fundamentals & Principles of Graphic Designing
  • Introduction to Vector graphic software
  • Concept & features of vector Graphic software
  • Basic task of Vector graphic software
  • Save an artwork with suitable format (AI,EPS,PDF)
  • Shape tool and lines, techniques in vector graphics software
  • Apply colors and effects for the Art work
  • Uses Libraries
  • Introduction of the Raster graphic software
  • Basic tasks of Vector graphic Software
  • Save an artwork with suitable format (PSD, TIFF, JPEG, PNG)
  • Retouch image and color replacement
  • Basic tasks in Page layout software
  • Designing and Enhancing Documents
  • Page Elements and Managing objects
  • Table & Tab setting
  • Finalizing Documents
  • Introduction to Autodesk 3Ds Max
  • Manipulating objects
  • Modeling 3D Assets
  • Introduction to WWW
  • Introduction to Web designing
  • Web site types and technologies used to build
  • Photoshop Essentials for web Designing
  • Creating Animations by using Photoshop
  • Introduction to HTML
  • HTML Structural Elements
  • HTML Layout Elements
  • HTML Forms
  • Introduction to CSS
  • Using CSS for better Optimization
  • Introduction to CMS
  • Developing Self Manageable Web site with Word press / Joomla
  • Government Domain Name Registrations
  • Introduction to Web Hosting
  • Introduction to computer Aided Drafting
  • CAD Software
  • Introduction to auto CAD
  • Introduction Drawing
  • Draw tools, Object Snap and Dynamic Input
  • Zoom, pan and Templates
  • The Modify Tools
  • Dimensions and Text
  • Orthographic and Isometric
  • Hatching
  • Blocks and Inserts
  • Other Types of File format
  • Printing & Plotting
  • 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
  • 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…
  • 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)
  • 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
  • Advance Excel Functions
  • If Analysis
  • Advance Filtering
  • Pivot Table & Chart
  • Using analyzing tools
  • Introduction to Database Designing
  • Relationship Diagrams
  • Normalization concepts
  • Create Forms/Reports
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
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
  • 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?
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
  • 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
  • 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