COPA Practical List 1. Introduction To Computer And Visit COPA Lab2. Safety symbols and hazard detection3. Use of fire extinguishers4. Practice safe methods of fire fighting in case of electrical fire5. Identify Computer peripherals and internal components6. Assemble a desktop computer7. Windows 10 interface and navigation8. Manage files and folders in Removable Drives9. Customize desktop settings10. Setting And Manage User Accounts11. Control Panel Details and System Properties12. Work With Keyboard Shortcuts & Commands13. Print & Scan Documents Using Different Commands14. 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 system25. 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 LINUX28.1 Manage user accounts in LINUX29. View system properties and manage system setting in Linux.30. Navigate within documents31. Format documents32. Save and share documents33. Inspect documents for issues34. Insert text and paragraphs35. Format text and paragraphs36. Create and configure document sections37. Create tables38. Modify tables39. Create and modify lists40. Create and manage reference elements41. Create and manage reference tables42. Insert illustrations and text boxes43. Format illustrations and text boxes44. Add text to graphic elements45. Modify graphic elements46. Add and manage comments47. Manage change tracking48. Perform mail merge49. Open files in MS Excel50. Import data51. Navigate within workbooks52. Format worksheets and workbooks53. Customize options and views54. Configure content for collaboration55. Manipulate data56. Format cells and ranges57. Define and reference named ranges58. Create and format tables59. Manage tables and table data60. Filter and sort table data61. Insert references62. Calculate and transform63. Format and modify text64. Create Charts65. Modify Charts66. Format Charts67. Create Pivot Tables68. Open files in MS PowerPoint69. Format PowerPoint Presentations70. Modify slide masters, handout masters, and note masters71. Change presentation options and views72. Save and share PowerPoint Presentations73. Configure and present slide74. Prepare presentations for collaboration75. Insert text and paragraphs76. Format text and paragraphs77. Create and configure sections78. Create tables79. Modify tables80.Create and modify bulleted text80.1 Create and manage reference elements (hyperlinks)81. Insert illustrations and text boxes82. Format illustrations and text boxes83. Add and modify text in graphic elements84. Add Audio elements85. Add Video elements86. Add slide transitions87. Add animations88. Add and manage comments89. 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 Functions99.2 Using the Number, Date and Character functions. Joins and Functions99.3 Using the Number, Date and Character functions. Joins and Functions100. Joins, Group by, Having Sub Queries101. 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 socket104. 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 Wireless111. Set up Internet access & communication112. Use the Internet113.1 html basic program113.2 html first program113.3 Paragraph tag in html113.4 Heading tag in html113.5 Pre tag in HTML113.6 Tag properties in html113.7 Table Tag in html113.8 text combo and check box in html113.9 form tag in html113.10 Listing tag in html113.11 Use of audio tag in html113.12 Use of Video Tag in html114.1 Simple program using CSS in html114.2 Hyperlink like a button in html with CSS114.3 Create image gallery with css in html114.4 Create table with CSS in html115. create simple program using javascript116.1 Embeded javascript in html116.2 Simple Calculator in Javascript117.1 prime number using javascript in html117.2 leap year or not check using java script in html118.1 Create simple dynamic pyramid in html118.2 calculate sum of given number using html in html119.1 create dynamic triangle pyramid119.2 check given character is vowel or not120. Develop dynamic HTML pages using JavaScript121 .Deploy web project using IIS.122. Create and modify simple macros123. 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 queries129. Use Power BI for simple data visualizations.130. Demonstrate E-Commerce Site131. 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 processing137. Identify common security issues.138. Protect information, computers and networks from viruses, spyware and other malicious code139. Explain compliance with IT Act140. Practice with IaaS using free cloud services.141. Practice with PaaS using free cloud services.142. Practice with SaaS using free cloud services143. Host a website in a free cloud.144. Identify Phases of the Application Development Life Cycle145. Describe Roles in each of the phases of Application Development Life Cycle.146. Install, set up the environment & run Python147. Use Command Line and IDE to create and execute a python program148. Write and test a python program to demonstrate print statement,comments, different types of variables149. Write and test a python program to perform data and data type operations, string operations, date, input and output, output formatting and operators150. 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 comprehensions155. Perform basic operations using built-in modules and tools
