COPA Theory List

1.safe working practices         

2. Scope of the COPA trade

3. Safety rules and safety signs

4. Types and working of fire extinguishers

5. Concepts of Hardware and Software

6. Function of motherboard components and various processors

7. Various Input Output devices in use and their features

8. Introduction to operating System

9. Main features of Windows OS

10. Concept of various shortcut commands

11. Introduction to various types of memories and their features

12. Basic Hardware and software issues and their solutions

13. Usage of Application software and Antivirus

14. Introduction to basic DOS Internal and External Commands

15. Introduction to Open-Source Software

16. Introduction to Linux Operating System features, structure, files and processes

17. Basic Linux commands

18. Introduction to the various applications in MS office

19. Introduction to Word features, Office button, toolbars

20. Creating, saving and formatting and printing documents using Word

21. Working with objects, macro, mail merge, templates and other tools in Word

22. Introduction to Excel features and Data Types

23. Cell referencing and linking Sheets

24. Introduction to various functions in all categories of Excel

25. Concepts of sorting, filtering and validating data

26. Analyzing data using charts, data tables, pivot tables, goal seek and scenarios

27. Image editing, Presentations

28. Introduction to Open Office

29. Introduction to the properties and editing of images

30. Introduction to different formats of images and their uses

31. Introduction to Power Point and its advantages

32. Creating Slide Shows

33. Concept of DBMS, RDBMS

34. Data Models, Concept of DBA, Database Users

35. Database Schema

36. Designing Database using Normalization Rules

37. Various data types Data integrity, DDL,DML and DCL statements

38. Enforcing Primary key and foreign key

39. Adding Indices

40. Concepts of Transactions

41. ACID Property of Transaction Constraints

42. Joining of tables

43. Sub Queries

44. Functions used in query like sum, average, max, min, count etc

45. Local Networks

46. Communicating on a Local Network, Principles of Communications

47. How do Ethernet Networks Work

48. How are Networks Built

49. Routing Across Networks

50. Explain how end-user devices and local networks interact with the global Internet

51. Communicating in a Connected World Explain the concept of network communication

52. Local Networks - Explain the roles of devices in a network

53. What Does a Home Network Look Like

54. How Does Wi-Fi Work

55. Introduction to LAN Devices, Internetworking Devices    

56. Introduction to www, Concept of Internet, Web Browsers, internet servers and search engines

57. Concepts of Domain naming Systems and E mail communication

58. Introduction to video chatting tools and Social Networking concepts

59. Concepts of Static and Dynamic Web pages

60. Introduction to HTML and various tags in HTML

61. Concepts of different controls used in Web Pages

62. Concepts of CSS and applying CSS to HTML

63. Introduction to open source CMS viz, Joomla, Word press etc. and Web authoring tools viz. Kompozer, Front Page etc

64. Introduction to Programming and Scripting Languages

65. Introduction to JavaScript and its application for the web

66. Introduction to Web Servers and their features

67. JavaScript Basics – Data types, Variables, Constants and Conversion between data types

68. Arithmetic, Comparison, Logical Operators in JavaScript. Operator precedence

69. Program Control Statements and loops in JavaScript

70. Arrays in JavaScript – concepts, types and usage

71. The String data type in JavaScript. Introduction to String, Math and Date

72. Introduction to Functions in JavaScript

73. Built in JavaScript functions overview

74. Concepts of Pop-Up boxes in JavaScript

75. Introduction to the Document Object Model

76. Concepts of using Animation and multimedia files in Java Script

77. MS excel revision (row, columns, basic formatting, insert menu, Print setup, etc. ) and Look up introduction and functions

78. Types of references and cell naming

79. Excel Linkage Custom Format and Excel Protection

80. Tips and tricks

81. Pivot table and Pivot chart

82. Conditional formatting

83. Advanced Graphs

84. Power Queries

85. Introduction to E- Commerce and advantages

86. Building business on the net

87. Payment and Order Processing, Authorization, Chargeback and other payment methods

88. Security issues and payment gateways

89. Overview of Information Security, SSL, HTTPS, Security threats, information Security vulnerability and Risk management

90. Introduction to Directory Services, Access Control, Security, Privacy protection, Audit and Security

91. Introduction to IT Act and penalties for cybercrimes

92. Benefits of cloud services, different categories

93. Resources available in cloud

94. Identify Phases of the Application Development Life Cycle

95. Describe Roles in each of phases of the Application Development Life Cycle

96. Introduction to Python History

97. Features, Setting up path Basic Syntax, Comments, Variable in python

98. Different Data Types in python

99. Casting, string, Boolean in python

100. Python Operators

101. Conditional Statements in python

102. Looping in python

103. Control Statements, String Manipulation, Lists, Tuple, sets in python

104. Dictionaries in python

105. Arrays in python

106. Iterators, modules, dates, math in python

107. Modules, Input and Output in python

Post a Comment

0 Comments