Learning Outcomes COPA Theory Key Learning Outcomes Practical

Learning Outcomes – COPA Theory – Key Learning Outcomes Practical – Key Learning Outcomes Knowledge of computers and Data Entry Making ppts, acessing data Knowledge of computers and Data Entry Making ppts, accessing and internet Theory- 66 hrs data and internet Practical - 330 hrs • • • Safe working practices & Introduction to Computer components Using Windows Operating System Computer basics and Software Installation Using Word Processing Software Using Spread Sheet Application Image editing and creating Presentations Create and manage database file by using MS Access. Internet Configuring Network and network devices Theory- 15 hrs • • Networking Concepts Internet Concepts • • Safe working practices Create, format and edit document using word processing application software. Create, format, edit and develop a workbook by using spreadsheet application software Create and customize slides for presentation. Image editing and creating Presentations Database Management with MS Access Introduction of Internet Configuring Network and network devices Practical - 75 hrs • • Install, setup/ configure, troubleshoot and secure computer network including Internet Introduction to www, Concept of Internet, Web Browsers, internet servers and search engines. Concepts of Domain naming Systems and E mail communication. Introduction to video chatting tools and Social Networking concepts.

Learning Outcomes – COPA Theory – Key Learning Outcomes Practical – Key Learning Outcomes Advanced Excel Concepts - Theory- 18 hrs Advanced Excel Concepts - Practical - 75 hrs • • • MS excel revision(row, columns, basic formatting, insert menu, Print setup etc Look up introduction and functions Types of references and cell naming Excel Linkage , Custom Format and Excel Protection Tips and tricks Pivot table and Pivot chart Financial Fundamentals P & L sheet and balance sheet Conditional formatting Advanced Graphs Excel with VBA and micro • • • • Numeric, Logical , Text, Data , Date and Finance Function (6 HRs) V-Lookup, H look up and Array Cross Ref & Formatting, Naming Cells or Array and Paste Special Go To Excel Linkage , Custom Format and Excel Protection Formatting, Navigation, mechanics, functions, tips and tricks Turn raw data into ‘must make’ decisions using Pivot. Tables and Power. Pivot. Financial modelling fundamentals, modelling hands on Forecasting future financials. mapping of financial P&l sheet with historical financial percentage variances and conditional formatting Building a output balance sheet, using index, match to fill balance sheet Use advanced graphs in minutes instead of wasting hours trying to figure them out Increase interactivity by automating your spreadsheets with macros and VBA Solve complex problems with superpower functions Create a simple Excel with VBA macro project using excel and VBA

Learning Outcomes – COPA Theory – Key Learning Outcomes Practical – Key Learning Outcomes E Commerce - Theory - 12 hrs E Commerce - Practical - 60 hrs • Introduction to ECommerce and advantages. • Building business on the net. • Payment and Order Processing, Authorization, Chargeback and other payment methods. • Security issues and payment gateways. Cyber Security: • Overview of Information Security, SSL, HTTPS, Security threats, information Security vulnerability and Risk management. • Introduction to Directory Services, Access Control, Security, Privacy protection, Audit and Security. • Introduction to IT Act and penalties for cyber crimes. E Commerce • Browse E-commerce websites viz. ebay, Amazon, flipkart, OLX, quikr etc • Prepare comparative statement of the main features of these sites. • Upload products for selling in E-Commerce Sites • 91. Make online purchase from E Commerce sites. • 90. Manage security issues in E-Commerce and payment operations. Cyber Security: • Protect information, computers and networks from viruses, spyware and other malicious code. • Protect the computer against various internet threats • Provide firewall security for Internet connection and Network System. • Make backup copies of important file, data and information • Secure your Wi-Fi networks using password, WEP, WPA-PSK, WPA 2 - PSK, SSID, MAC address filtering. Create individual user accounts for each member. • Limit member access to data and information, and restrict authority to install unnecessary downloads

Learning Outcomes – COPA Theory – Key Learning Outcomes Practical – Key Learning Outcomes Basic Software Programming Theory : 36 Hrs. (06 Weeks) Basic Software Programming Practical’s- 180 Hrs. Basics of it 12 Hrs ( 02 weeks ) Introduction to Computers (06 Hrs. ) Introduction to Operating systems (Windows and Linux) (06 Hrs. ) Problem Solving & program design (02 weeks) (12 Hrs. ) Concepts of Mathematical computing (06 Hrs. ) Concepts of Logical computing & logical Analysis (06 Hrs. ) Basic algorithms & application development 12 Hrs. (02 weeks) Need of an algorithm for problem solving (06 Hrs. ) Steps of an algorithm (06 Hrs. ) Employability Skills 24 hrs. Basic usage of Computer (60 Hrs. ) demonstrate basic computer and internet literacy including operating a computer (12 Hrs. ) describing its major components and how they work, using Windows and Linux OS (12 Hrs. ) operating a browser (12 Hrs. ) searching the internet (12 Hrs. ) managing mails and using social internet media. (12 Hrs. ) Basic mathematical and Cognitive Skills (60 Hrs. ) demonstrate aptitude for analysing information and making logical conclusions. (30 Hrs. ) demonstrate knowledge of the foundational mathematical concepts in computing. (30 Hrs. ) Developing Algorithms (60 Hrs. ) design algorithms to solve problems and convert them into code using the appropriate programming language constructs. (25 Hrs. ) read and execute a test case and record the outcome in the appropriate template. (25 Hrs. ) be able to communicate effectively with appropriate people (10 Hrs. )

Learning Outcomes – COPA Theory – Key Learning Outcomes Practical – Key Learning Outcomes 2. Basic Web Designing (HTML, CSS) Theory : 48 Hrs (08 Weeks) 2. Basic Web Designing (HTML, CSS) Practical : 240 Hrs. • • Introduction to HTML and its components (3 weeks) (18 Hrs. ) Concepts of static and dynamic web pages (6 Hrs) Introduction to HTML and various tags in HTML (6 Hrs) Concepts of different controls used in webpages (6 Hrs) Concepts of Cascading style Sheet (3 weeks) 18 Hrs • Concepts of CSS and applying CSS to HTML (12 Hrs) • Introduction to open source CMS(content management system) ex Word press and Web authoring tools Kompozer and Front. Page (6 Hrs) Good web designing techniques 12 Hrs. (2 weeks) • Concept of good web page designing techniques (12 Hrs. ) Employability Skills 32 hrs. • Create simple static web pages using HTML tags (90 Hrs. ) • Practice with basic HTML elements (e. g. head, title, body), tag and attributes. (10 Hrs) • Design simple web page with text, paragraph and line break using HTML tags (6 Hrs) • Format text, change background colour and insert pictures in web page (10 Hrs. ) • Design simple web page with tables and lists. (10 Hrs) • Use marquees, hyperlinks and mail to link in designing web pages (10 Hrs. ) • Create frames, add style and design layout. (10 Hrs. ) • Insert text, check and combo box in web page. (6 Hrs. ) • Design web page using password field, submit button (6 Hrs. ) • reset button and radio button etc. (6 Hrs. ) • Design a web page adding flash file, audio and video files. (10 Hrs. ) • Design web page with forms and form controls using HTML tags. (6 Hrs. ) Create simple static web pages using CSS (90 Hrs. ) Create web page using Cascading Style Sheet (CSS). (60 Hrs. ) • CSS syntax, Adding colors, fonts, backgrounds, imagesborders, text alignment, text transformation, Lists ets. , (10 Hrs) • 3 types of CSS (5 Hrs) • Adding a Navigation Bars(vertical/horizontal bars) (5 Hrs) • CSS drop downs & Forms (10 Hrs) • CSS counters and website layout, Multiple backgrounds & Putting the stylesheet in a separate file (10 Hrs) • CSS Animations & CSS Buttons (10 Hrs) • Use WYSIWYG (Kompozer) web design tools to design and edit web pages with various styles. (10 Hrs. ) Project on HTML (60 Hrs. ) • Create a simple web site of at least 5 web pages which will include Images, tables, charts, lists and hyperlink on any topic like student information system or book store etc. (60 Hrs. )

Learning Outcomes – COPA Theory – Key Learning Outcomes Practical – Key Learning Outcomes 3. Programming language (Python) Theory : 42 Hrs. ( 07 weeks) 3. Programming language (Python) Practical : (210 Hrs. ) • • Install and setup & Stepping into the world of python (6 Hrs) Program flow control in python (6 hrs) Lists and tuples (06 Hrs. ) Python dictionaries and sets, I/O in Python (06 Hrs. ) Modules and Functions in Python (06 Hrs. ) Object Oriented Python (06 Hrs. ) Using databases in Python (06 Hrs. ) Employability Skills 28 hrs. Python for windows setup & Simple Python Programs (30 Hrs) Programs on Condition and Looping statements (30 Hrs) Programss on Creating Lists (30 Hrs. ) Programs on Dictionaries and sets , Reading , Writing and Appending file (30 Hrs. ) Programs using Built-in and User defined Functions (30 Hrs. ) Object Oriented Programs, Class, Constructors etc. , (30 Hrs. ) Using Database and My. SQL in Python (30 Hrs. )