GujjuSkills

 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 charcter functions. Joins and Functions

 

99.2 Using the Number functions. Joins and Functions

 

99.3 Using the Date 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