COPA Practical List

1. Introduction To Computer And Visit COPA Lab

2. Safety symbols and hazard detection

3. Use of fire extinguishers

4. Practice safe methods of fire fighting in case of electrical fire

5. Identify Computer peripherals and internal components

6. Assemble a desktop computer

7. Windows 10 interface and navigation

8. Manage files and folders in Removable Drives

9. Customize desktop settings

10. Setting And Manage User Accounts

11. Control Panel Details and System Properties

12. Work With Keyboard Shortcuts & Commands

13. Print & Scan Documents Using Different Commands

14. View the BIOS settings and their modifications.

15. Install Windows operating system.

16. Format hard disk and create partition.

17. Identify and rectify common hardware and software issues during OS installation.

18. Install necessary application software for Windows i.e. Office Package, PDF Reader, Media Player.

19. Configure Bluetooth and Wi-Fi settings.

20. Install Drivers for printer, scanner, webcam and DVD etc.

21. Burn data, video and audio files on CDDVD using application software.

22. Use basic DOS commands for directory listing.

23. Manage files and folders using DOS commands.

24. Installation of Ubuntu Linux operating system

25. Install necessary application software for Linux i.e. Office Package, PDF Reader, Media Player etc.

26. Use Basic Linux commands for directory listing, file and folder management, password etc.

27. Use the Linux graphical user interface for file and folder management, exploring the system etc.

28. Customize desktop settings in LINUX

28.1 Manage user accounts in LINUX

29. View system properties and manage system setting in Linux.

30. Navigate within documents

31. Format documents

32. Save and share documents

33. Inspect documents for issues

34. Insert text and paragraphs

35. Format text and paragraphs

36. Create and configure document sections

37. Create tables

38. Modify tables

39. Create and modify lists

40. Create and manage reference elements

41. Create and manage reference tables

42. Insert illustrations and text boxes

43. Format illustrations and text boxes

44. Add text to graphic elements

45. Modify graphic elements

46. Add and manage comments

47. Manage change tracking

48. Perform mail merge

49. Open files in MS Excel

50. Import data

51. Navigate within workbooks

52. Format worksheets and workbooks

53. Customize options and views

54. Configure content for collaboration

55. Manipulate data

56. Format cells and ranges

57.  Define and reference named ranges

58. Create and format tables

59. Manage tables and table data

60. Filter and sort table data

61. Insert references

62. Calculate and transform

63. Format and modify text

64. Create Charts

65. Modify Charts

66. Format Charts

67. Create Pivot Tables

68. Open files in MS PowerPoint

69. Format PowerPoint Presentations

70. Modify slide masters, handout masters, and note masters

71. Change presentation options and views

72. Save and share PowerPoint Presentations

73. Configure and present slide

74. Prepare presentations for collaboration

75. Insert text and paragraphs

76. Format text and paragraphs

77. Create and configure sections

78. Create tables

79. Modify tables

80.Create and modify bulleted text

80.1 Create and manage reference elements (hyperlinks)

81. Insert illustrations and text boxes

82. Format illustrations and text boxes

83. Add and modify text in graphic elements

84. Add Audio elements

85. Add Video elements

86. Add slide transitions

87. Add animations

88. Add and manage comments

89. Installation of MySQL.

90. Troubleshooting basic installation issues.

91. Creation and use of database.

92. Designing of tables.

93. Applying data integrity rules.

94. Using the DDL, DCL and DML statements.

95. Enforcing constraints, primary key and foreign key.

96. Adding indices to Tables.

97. Simple select queries.

98. Insert and delete queries Update queries.

99.1 Using the Number, Date and Character functions. Joins and Functions

99.2 Using the Number, Date and Character functions. Joins and Functions

99.3 Using the Number, Date and Character functions. Joins and Functions

100. Joins, Group by, Having Sub Queries

101. View Network connections.

102. Connect a computer to a network and share Devices i.e. Printers, files, folders and drives.

103. Work with various Network devices, connectors and cables. Create straight and cross cable and punch a UTP cable in the patch socket

104. Practice IP Addressing and Subnet masking for IPV4 IPV6 and pinging to test networks.

105. Configure Hub and Switch.

106. Set up and configure wired and wireless LAN in a Computer Lab within at least three computers.

107. Use patch panel & IO Box for wired LAN and installing & configuring Internet connection in a single PC and in a LAN.

108. Set up a proxy server DHCP Server with firewall.

109. Set up video conferencing using open-source software.

110. Use various tools (by open source free) for network troubleshooting, maintenance and security for both Wired and Wireless

111. Set up Internet access & communication

112. Use the Internet

113.1 html basic program

113.2 html first program

113.3 Paragraph tag in html

113.4 Heading tag in html

113.5 Pre tag in HTML

113.6 Tag properties in html

113.7 Table Tag in html

113.8 text combo and check box in html

113.9 form tag in html

113.10 Listing tag in html

113.11 Use of audio tag in html

113.12 Use of Video Tag in html

114.1 Simple program using CSS in html

114.2 Hyperlink like a button in html with CSS

114.3 Create image gallery with css in html

114.4 Create table with CSS in  html

115. create simple program using javascript

116.1 Embeded javascript in html

116.2 Simple Calculator in Javascript

117.1 prime number using javascript in html

117.2 leap year or not check  using java script in html

118.1 Create simple dynamic pyramid in html

118.2 calculate sum of given number using html in html

119.1 create dynamic triangle pyramid

119.2 check given character is vowel or not

120. Develop dynamic HTML pages using JavaScript

121 .Deploy web project using IIS.

122. Create and modify simple macros

123. Perform form controls and create simple data entry form with macros.

124. Look up data by using functions.

125. Use advanced date functions.

126. Create and modify advanced charts.

127. Create and modify PivotTables.

128. Create a Power Query, Power Query Function. Invoking the Power Query function and combining queries. Organize the workbook queries

129. Use Power BI for simple data visualizations.

130. Demonstrate E-Commerce Site

131. List features of e- commerce sites.

132. Use e-commerce sites to source an item.

133. Undertake transactions on an e-commerce site.

134. Add products to an ecommerce website.

135. Practice order processing.

136. Practice payment processing

137. Identify common security issues.

138. Protect information, computers and networks from viruses, spyware and other malicious code

139. Explain compliance with IT Act

140. Practice with IaaS using free cloud services.

141. Practice with PaaS using free cloud services.

142. Practice with SaaS using free cloud services

143. Host a website in a free cloud.

144. Identify Phases of the Application Development Life Cycle

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

146. Install, set up the environment & run Python

147. Use Command Line and IDE to create and execute a python program

148. Write and test a python program to demonstrate print statement,comments, different types of variables

149. Write and test a python program to perform data and data type operations, string operations, date, input and output, output formatting and operators

150. Determine the sequence of execution based on operator precedence.

151. Construct and analyze code segments that use branching statements.

152. Construct and analyze code segments that perform iteration.

153. Document code segments using comments and documentation strings.

154. Construct and analyze code segments  that  include  List comprehensions, tuple ,set and dictionary comprehensions

155. Perform basic operations using built-in modules and tools