COPA

V E S R N TECHNOLOGIES

COPA
Sno	Module	Question Bank (Bharath Skills)	Assessment	Practical (Record Work)	Theory (Record Work)
1	Install and setup operating system and related software in a computer following safety precautions.	Test your knowledge	Assessment - 1	Apply Safe Working Practice 1) Visit COPA Lab of the Institue and locate the electrical connections with computer setup 2) Identify Safety Symbols and hazard identification and practice safe methods of fire extinguishers. 3) Identify Computer peripherals and internal components and disassemble and assemble components of desktop computer	1) Safe Working Practice 2) Introduction to Computer Components
2	Install and setup operating system and related software in a computer.	Test your knowledge	Assessment - 1	Install and setup operating system and related software in a computer. 4) Practice on Windows Interface and navigating windows and practice on managing files and folders using drives 5)Customize the desktop settings and manage user accounts and view system properties and control panel details	Introduction to Windows Operating System
3	Install and setup operating system and related software in a computer.	Test your knowledge	Assessment - 1	Install and setup operating system and related software in a computer. 6) Install Windows Operating System 7)Install necessary application software for Windows and configure Bluetooth and Wi-Fi Settings 8)Burn data, video and audio files on CD/DVD using application software	Introduction to Windows Operating System
4	Install and setup operating system and related software in a computer.	Test your knowledge	Assessment - 1	Install and setup operating system and related software in a computer. 9)Use basic DOS commands for directory listing and manage files and folders using DOS Commands 10)Install Linux Operating System and use basic Linux commands for directory lising, file and folder management.	Introduction to DOS Command Line Interface Linux Operating System
5	Create, format and edit document using word processing application software	Test your knowledge	Assessment - 1	Create, Format and edit document using Word processing application software 11) Navigate within documents, Format documents, Save and Share documents. 12)Inspect documents for issues, insert text and paragraphs, create and configure document sectons.	Word Processing Software
6	Create, format and edit document using word processing application software	Test your knowledge	Assessment - 1	13) Create & Modify Tables in Microsoft Word 14) Create and manage lists 15) Insert illustrations and text boxes, add text to graphic elements and modify graphic elements. 16) Manage change tracking and perform mail merge.	Microsoft Excel
7	Create, format and edit document using word processing application software	Test your knowledge	Assessment - 1	17. Open MS Excel, import data, navigate within workbooks, format worksheets and workbooks. 18. Customize options and views, configure content for collaboration, and manipulate data.	Microsoft Excel
8	Create, format, edit and develop a workbook using spreadsheet application software.	Test your knowledge	Assessment - 1	19. Format cells and ranges, define and reference named ranges in spreadsheet application	Microsoft Excel
9	Format cells and ranges, define and reference named ranges. Create and format charts and tables in a spreadsheet application.	Test your knowledge	Assessment - 1	20. Create and format charts, manage data and tables in Excel. Calculate and sort data, transform data format and modify content.	Microsoft Excel
10	Create and customize slides for presentation.	Test your knowledge	Assessment - 1	21. Open files in MS PowerPoint, modify masters, handouts, and notes. 22. Create charts, modify templates and themes. 23. Change presentation options and views. 24. Save and share PowerPoint slideshows, prepare presentations for collaboration.	Microsoft Excel
11	Create and manage database file by using MySQL.	Test your knowledge	Assessment - 1	25. Add audio elements, add video elements, add transitions and animations, add timings 26. Installation of MySQL, troubleshooting basic database issues, creation and use of database.	Database Management System
12	Create and manage database file by using MySQL.	Test your knowledge	Assessment - 1	27. Designing of tables, applying DML statements, enforcing constraints. 28. Insert and update data using DDL, DML, and DCL statements.	Database Management System
13	Install, setup, configure, and secure computer network including Internet.	Test your knowledge	Assessment - 1	29. Create queries using SQL commands with clauses like WHERE, GROUP BY, HAVING, and SUBQUERY.. 30. View network connections, connect a computer to network and share devices like printers, files, folders, and drives.	Database Management System
13	Install, setup, configure, and troubleshoot computer network including Internet.	Test your knowledge	Assessment - 1	31. Work with various network devices, connectors, and cables. Create straight and cross cables and punch UTP cable in patch socket. 32. Configure Hub and Switch, set up and configure wired and wireless LAN computers in a lab within at least three computers. 33. Use patch panel and I/O box for wired LAN.	Database Management System
14	Install, setup, and configure Internet connections and browse the Internet.	Test your knowledge	Assessment - 1	34. Set up dial-up connections using open-source software and configure proxy server or DHCP server with firewall. 35. Browse and use the Internet, send and receive emails, and use social media and other online activities.	Database Management System
15	Develop static web pages using HTML.	Test your knowledge	Assessment - 1	36. Practice with basic HTML tags and attributes. Format text, manage color, and insert pictures in a web page.	Database Management System