COPA WEEK WISE NSQF SYLLABUS (SPILT UP)

WEEK. NO. 29 

1. Reference Learning Outcome :- Create workbooks with advanced formulas, macros, charts, pivot tables
2. Duration :- Professional Skill 73 Hrs.; Professional Knowledge 17  Hrs.(for above learning out come)

TRADE THEORY (Professional Knowledge ) :- 

• •  Excel Linkage Custom Format and Excel Protection
  •  Tips and tricks
  •  Pivot table and Pivot chart

TRADE PRACTICAL (Professional Skills  With Indicative Hours) :- Job no. & Name of the Practical

Manage advanced charts and tables (21 hrs)

• 126. Create and modify advanced charts. (10 Hrs)
• 127. Create and modify PivotTables. (11 Hrs)

WEEK. NO.  30

1. Reference Learning Outcome :- Create workbooks with advanced formulas, macros, charts, pivot tables
2. Duration :- Professional Skill 73 Hrs.; Professional Knowledge 17  Hrs.(for above learning out come)

TRADE THEORY (Professional Knowledge ) :- 

• •  Conditional formatting
  •  Advanced Graphs
  •  Power Queries

TRADE PRACTICAL (Professional Skills  With Indicative Hours) :- Job no. & Name of the Practical

• 128. Create a Power Query, Power Query Function. Invoking the Power Query function and combining queries. Organize the workbook queries (12 Hrs)
• 129. Use Power BI for simple data visualizations. (12 Hrs)
  Make a dashboard in Excel (4 Hrs)

WEEK. NO. 31  

1. Reference Learning Outcome :- Browse, select, and transact using E-commerce websites(NOS: SSC/N9403) 
2. Duration :- Professional Skill 25 Hrs.; Professional Knowledge 10  Hrs.(for above learning out come)

TRADE THEORY (Professional Knowledge ) :- 

• •  Introduction to E Commerce and advantages.
  •  Building business on the net.
  •  Payment and Order Processing, Authorization, Chargeback and other payment methods.
  •  Security issues and payment gateways.

TRADE PRACTICAL (Professional Skills  With Indicative Hours) :- Job no. & Name of the Practical

• 130. Demonstrate e-Commerce sites. (1.5 Hrs)
• 131. List features of e-commerce sites. (2 Hrs)
• 132. Use e-commerce sites to source an item. (3 Hrs)
  Shop online (4.5 Hrs)
• 133. Undertake transactions on an e-commerce site. (4.5 Hrs)
  Manage e-commerce operations (14 Hrs)
• 134. Add products to an ecommerce website. (4 Hrs)
• 135. Practice order processing. (3 Hrs)
• 136. Practice payment processing. (4.5 Hrs)
• 137. Identify common security issues. (3.5 Hrs )