COPA_Trade Practical_First Year

Course Instructor

FREE

To enroll in this course, please contact the Admin

Course Overview

Schedule of Classes

Course Curriculum

1 Subject

COPA_TRADE_PRACTICAL_FIRST_YEAR_2022

204 Learning Materials

MODULE 1 - SAFE WORKING PRACTICES

Exercise 1 - Visit COPA Lab. of the institutes and locate the electrical connections with computer

Exercise 2 - Identifying safety symbols and hazard identification

Exercise 3 - Practice safe methods of fire fighting in case of electrical fire

Exercise 4 - Use of fire extinguishers

MODULE 2 - ASSEMBLE A DESKTOP PC

Exercise 5 - Identify computer peripherals and internal components of a desktop computer

Exercise 6 - Assemble components of desktop computer

MODULE 3 - USING WINDOWS OPERATING SYSTEMS

Exercise 7 - Practice on Windows interface and navigating windows

Exercise 8 - Practice on managing files and folders using removable drives

Exercise 9 - Customize the desktop

Exercise 10 - Settings and manage user accounts

Exercise 11 - View system properties and control panel details

Exercise 12 - Work with keyboard shortcut commands

Exercise 13 - Print and scan document using different commands

MODULE 4 - COMPUTER BASICS AND SOFTWARE INSTALLATION

Exercise 14 - View the BIOS settings and their modifications

Exercise 15 - Install Windows operating system

Exercise 16 - Format hard disk and create partition

Exercise 17 - Identify and rectify common hardware and software issues during OS installation

Exercise 18 - Install necessary application software for Windows i.e.

Exercise 19 - Configure Bluetooth and Wi-Fi settings

Exercise 20 - Install Drivers for printer, scanner, webcam and DVD etc

Exercise 21 - Burn data, video and audio files on CD/DVD using application software

MODULE 5 - INSTALL UBUNTU LINUX OPERATING SYSTEM AND EXECUTE BASIC LINUX COMMANDS

Exercise 22 - Use basic DOS commands for directory listing

Exercise 23 - Manage files and folders using DOS commands

Exercise 24 - Installation of Ubuntu Linux operating system

Exercise 25 - Install necessary application software for Linux i.e.

Exercise 26 - Use Basic Linux commands for directory listing, file and folder management

Exercise 27 - Use the Linux graphical user interface for file and folder management

Exercise 28 - Customize desktop settings and manage user accounts in Linux

Exercise 29 - View system properties and manage system setting in Linux

MODULE 6 - USING WORD PROCESSING SOFTWARE

Exercise 30 - Navigate within documents

Exercise 31 - Format documents

Exercise 32 - Save and share documents

Exercise 33 - Inspect documents for issues

Exercise 34 - Insert text and paragraphs

Exercise 35 - Format text and paragraphs

Exercise 36 - Create and configure document sections

Exercise 37 - Create tables"

Exercise 38 - Modify tables

Exercise 39 - Create and modify lists

Exercise 40 - Create and manage reference elements

Exercise 41 - Create and manage reference tables

Exercise 42 - Insert illustrations and text boxes

Exercise 43 - Format illustrations and text boxes

Exercise 44 - Add text to graphic elements

Exercise 45 - Modify graphic elements

Exercise 46 - Add and manage comments

Exercise 47 - Manage change tracking

Exercise 48 - Perform mail merge

MODULE 7 - SPREAD SHEET APPLICATION

Exercise 49 - Open files in MS Excel

Exercise 50 - Import data

Exercise 51 - Navigate within workbooks

Exercise 52 - Format worksheets and workbooks

Exercise 53 - Customize options and views

Exercise 54 - Configure content for collaboration

Exercise 55 - Manipulate data

Exercise 56 - Format cells and ranges

Exercise 57 - Define and reference named ranges

Exercise 58 - Create and format tables

Exercise 59 - Manage tables and table data

Exercise 60 - Filter and sort table data

Exercise 61 - Insert references

Exercise 62 - Calculate and transform data

Exercise 63 - Format and modify text

Exercise 64 - Create Charts

Exercise 65 - Modify charts

Exercise 66 - Format charts

Exercise 67 - Create Pivot Tables

MODULE 8 - POWER POINT PRESENTATIONS

Exercise 68 - Open files in MS PowerPoint

Exercise 69 - Format PowerPoint Presentations

Exercise 70 - Modify slide masters, handout masters, and note masters

Exercise 71 - Change presentation options and views

Exercise 72 - Save and share PowerPoint Presentations

Exercise 73 - Configure and present slide shows

Exercise 74 - Prepare presentations for collaboration

Exercise 75 - Insert text and paragraphs

Exercise 76 - Format text and paragraphs

Exercise 77 - Create and configure sections

Exercise 78 - Create tables

Exercise 79 - Modify tables

Exercise 80A - Create and modify bulleted text

Exercise 80B - Create and manage reference elements

Exercise 81 - Insert illustrations and text boxes

Exercise 82 - Format illustrations and text boxes

Exercise 83 - Add and modify text in graphic elements

Exercise 84 - Add Audio elements

Exercise 85 - Add Video elements

Exercise 86 - Add slide transitions

Exercise 87 - Add animations

Exercise 88 - Add and manage comments

MODULE 9 - CREATE AND MANAGE DATABASE FILE BY USING MYSQL

Exercise 89 - Installation of MySQL

Exercise 90 - Troubleshooting basic installation issues

Exercise 91 - Creation and use of database

Exercise 92 - Designing of tables

Exercise 93 - Applying data integrity rules

Exercise 94 - Using the DDL, DCL and DML statements

Exercise 95 - Enforcing constraints, primary key and foreign key

Exercise 96 - Adding indices to Tables

Exercise 97 - Simple select queries

Exercise 98 - Insert and delete queries Update queries

Exercise 99 - Using the Number, Date and Character functions. Joins and Functions

Exercise 100 - Joins, Group by, Having, Sub query

MODULE 10 - COMPUTER NETWORK

Exercise 101 - View Network connections

Exercise 102 - Connect a computer to a network and share Devices i.e.

Exercise 103 - Work with various Network devices, connectors and cables.

Exercise 104 - Practice IP Addressing and Subnet masking for IPV4/ IPV6 and pinging to test networks

Exercise 105 - Configure Hub and Switch

Exercise 106 - Set up and configure wired and wireless LAN

Exercise 107 - Use patch panel & I/O Box for wired LAN and installing

Exercise 108 - Set up a proxy server/ DHCP Server with firewall

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

Exercise 110 - Use various tools (by open source /free)

Exercise 111 - Set up Internet access & communication

Exercise 112 - Use the Internet

MODULE 11 - CREATE SIMPLE STATIC WEB PAGES USING HTML TAGS

Exercise 113A - Practice with basic HTML elements (e.g. head, title, body), tag and attributes

Exercise 113B - Practice with basic HTML elements

Exercise 113C - Format text, change background colour and insert pictures in web page

Exercise 113D - Design simple web page with tables and lists

Exercise 113E - Use marquees, hyperlinks and mail to link in designing web pages

Exercise 113F - Create frames, add style and design layout

Exercise 113G - Display a web page within a web page using iframes

Exercise 113H - Insert text, check and combo box in web page

Exercise 113I - Design web page using password field, submit button

Exercise 113J - Reset button and radio button etc

Exercise 113K - Design a web page adding flash file, audio and video files

Exercise 113L - Design web page with forms and form controls using HTML tags

Exercise 114 - Create simple static web pages using CSS

MODULE 12 - JAVASCRIPT

Exercise 115 - Practicing the JavaScript in creating dynamic HTML pages

Exercise 116 - Embed JavaScript in HTML to Display Information in Web pages

Exercise 117 - Use error handling techniques in JavaScript

Exercise 118 - Use objects and classes in JavaScript

Exercise 119 - Describe Animation and Multimedia using JavaScript

Exercise 120A - Develop dynamic HTML pages using JavaScript

Exercise 120B - Use JavaScript Variables, Data types, Constants and Operators

Exercise 120C - Use online tool or open source software to develop and edit web pages

Exercise 121 - Deploy web project using IIS

MODULE 13 - DATA VISUALIZATION OR ANALYSIS USING EXCEL

Exercise 122 - Create and modify simple macros

Exercise 123 - Perform form controls and create simple data entry form with macros

Exercise 124 - Look up data by using functions

Exercise 125 - Use advanced date functions

Exercise 126 - Create and modify advanced charts

Exercise 127 - Create and modify PivotTables

Exercise 128 - Create a Power Query, Power Query Function.

Exercise 129 - Use Power BI for simple data visualizations

MODULE 14 - BROWSE E-COMMERCE SITES TO IDENTIFY PRODUCTS & SERVICES

Exercise 130 - Demonstrate e-Commerce sites

Exercise 131 - List features of e-commerce sites

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

Exercise 133 - Undertake transactions on an e-commerce site

Exercise 134 - Add products to an ecommerce website

Exercise 135 - Practice order processing

Exercise 136 - Practice payment processing

Exercise 137 - Identify common security issues

MODULE 15 - PROTECT INFORMATION, COMPUTERS AND NETWORKS FROM VIRUSES, SPYWARE AND OTHER MALICIOUS CODE

Exercise 138A - Explain Cyber security

Exercise 138B - Secure computers & the network

Exercise 138C - Reduce cyber security threats

Exercise 138D - Secure a Wi-Fi Network

Exercise 138E - Use Anti-Virus software

Exercise 138F - Perform back-ups of files, data & information

Exercise 139 - Explain compliance with IT Act

MODULE 16 - CLOUD COMPUTING

Exercise 140 - Practice with IaaS using free cloud services

Exercise 141 - Practice with PaaS using free cloud services

Exercise 142 - Practice with SaaS using free cloud services

Exercise 143 - Host a website in a free cloud

Exercise 144 - Identify Phases of the Application Development Life Cycle

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

MODULE 17 - ELECTIVE I - PROGRAMMING LANGUAGE (PYTHON)

Exercise 1 - Install, set up the environment & run Python

Exercise 2 - Use Command Line and IDE to create and execute a python program

Exercise 3 - Write and test a python program to demonstrate print statement, comments

Exercise 4 - Write and test a python program to perform data and data type operations

Exercise 5 - Determine the sequence of execution based on operator precedence

Exercise 6 - Construct and analyze code segments that use branching statements

Exercise 7 - Construct and analyze code segments that perform iteration

Exercise 8 - Document code segments using comments and documentation strings

Exercise 9 - Construct and analyze code segments that include List comprehensions

Exercise 10 - Perform basic operations using built-in modules

Exercise 11 - Solve complex computing problems by using built-in modules

MODULE 18 - ELECTIVE II - PROGRAMMING IN JAVA

Exercise 1 - Installing JAVA

Exercise 2 - Setting the Class path

Exercise 3 - Writing and Executing a simple JAVA Program to display “Hello"

Exercise 4 - Use of various data types in JAVA

Exercise 5 - Use various operators in JAVA

Exercise 6 - Create and use of local, Instance and class variables

Exercise 7 - Read text from the keyboard using scanner class read text from keyboard