Welcome to the COPA Trade Online Tutorials. Here is a full details of 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
