COPA WEEK WISE NSQF SYLLABUS (SPILT UP)

WEEK. NO. 09

1. Reference Learning Outcome :- Create, format, edit and develop a workbook by using spreadsheet application software. (Mapped NOS: SSC/N3022)
2. Duration :- Professional Skill 72  Hrs; Professional Knowledge 18  Hrs.  (for above learning out come)

TRADE THEORY (Professional Knowledge ) :- 

• •  Introduction to various functions in all categories of Excel.
  •  Concepts of sorting, filtering and validating data.

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

• Manage tables and table data (12 Hrs.)
  58. Create and format tables (4 hrs)
   Create excel tables from cell ranges
   Apply table styles
   Convert tables to cell ranges
  59. Manage tables and table data (5 Hrs)
   Add or remove table rows and columns
   Configure table style options
   Insert and configure total rows
  60. Filter and sort table data (3 Hrs)
   Filter records
   Sort data by multiple columns
• Perform operations using formulas and functions (12 Hrs.)
  61. Insert references (3 Hrs)
   Insert relative, absolute and mixed references
   Reference named ranges and named tables in formulas
  62. Calculate and transform data (5 Hrs)
   Perform calculations using AVERAGE(), MIN(), MAX() and SUM()
•  Count cells by using COUNT(), COUNTIF() and COUNTBLANK()
   Perform conditional operations by using the IF() function
  63. Format and modify text(4 Hrs)
   Format text using RIGHT(),LEFT() and MID() functions
   Format text using UPPER(), LOWER() and LEN() functions
   Format text using CONCAT() and TEXTJOIN() functions

WEEK. NO. 10

1. Reference Learning Outcome :- Create, format, edit and develop a workbook by using spreadsheet application software. (Mapped NOS: SSC/N3022)
2. Duration :- Professional Skill 72  Hrs; Professional Knowledge 18  Hrs.  (for above learning out come)

TRADE THEORY (Professional Knowledge ) :- 

• • Analyzing data using charts, data tables, pivot tables, goal seek and scenarios

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

• Manage Charts (12 Hrs.)
  64. Create Charts (3 Hrs)
   Create charts
   Create chart sheets
  65. Modify charts (4 Hrs)
   Add data series to charts
   Switch between rows and columns in source data
   Add and modify chart elements
   Add trend lines to chart
  66. Format charts (5 Hrs)
   Apply chart layouts
   Apply chart styles
   Add alternative text to charts for accessibility
• Manage Pivot Tables (12 Hrs.)
  67. Create Pivot Tables(12 Hrs)
   Create Pivot tables from cell ranges
   Manipulate fields (columns) to get desired analysis
   Use Filters for pivot tables
   Represent data as Count, Sum, Average & % of row / column
   Group data in Columns & rows for aggregate reports

WEEK. NO. 11

1. Reference Learning Outcome :-Create and customize slides for presentation.(Mapped NOS: SSC/N3022)
2. Duration :- Professional Skill 53 Hrs; Professional Knowledge 13 Hrs.  (for above learning out come)

TRADE THEORY (Professional Knowledge ) :- 

• •  Image editing, Presentations
  •  Introduction to Open Office.
  •  Introduction to the properties and editing of images.

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

• Power point Presentations (9.5 Hrs.)
  68. Open files in MS PowerPoint (1 Hr)
•  Open MS PowerPoint
   Create a new PowerPoint file
   Create a new PowerPoint file from a template
   Open an existing PowerPoint file
  69. Format PowerPoint Presentations (1.5 Hrs)
   Add slides
   Add titles and text
   Select slide layouts
   Add PowerPoint templates
   Duplicate slides
  70. Modify slide masters, handout masters, and note masters (2 Hrs)
   Change the slide master theme or background
   Modify slide master content
   Modify slide layouts
  71. Change presentation options and views (1.5 Hrs)
   Change slide size
   Display presentations in different views
  72. Save and share PowerPoint Presentations (1.5 Hrs)
   Save presentations in alternative file formats
   Configure different Print settings
   Share presentations electronically
  73. Configure and present slide shows (1 Hr)
   Hide unwanted slides while presenting
   Configure slide show options
   Present slide shows by using Presenter View
  74. Prepare presentations for collaboration (1 Hrs)
   Protect presentations by using passwords
•  Export presentations to other formats
• Format presentations (6.5 Hrs.)
  75. Insert text and paragraphs (2 Hrs)
   Find and replace text
   Insert symbols and special characters
  76. Format text and paragraphs (2 Hrs)
   Apply text effects
   Apply formatting by using Format Painter
   Set line and paragraph spacing and indentation
   Apply built-in styles to text
  77. Create and configure sections (2.5 Hrs)
   Format text in multiple columns
   Text and image presentation styles
   Clear formatting
  Manage tables and bulleted text (8 Hrs)
  78. Create tables (3 Hrs)
   Insert tables in PowerPoint
   Apply built-in table styles
   Create tables by specifying rows and columns
  79. Modify tables (3 Hrs)
   Insert and delete table rows and columns
   Configure cell margins and spacing
   Merge and split cells
   Resize tables, rows, and columns
  80. Create and modify bulleted text (2 Hrs)
   Format paragraphs as numbered and bulleted lists
   Change bullet characters and number formats
•  Increase and decrease list indents
   Set starting number values
   Restart and continue list numbering on different slides
  Create and manage reference elements (hyperlinks) (1.25 Hrs)
   Create hyperlinks within presentations
   Create hyperlinks in presentations for files and other sources

WEEK. NO. 12

1. Reference Learning Outcome :-Create and customize slides for presentation.(Mapped NOS: SSC/N3022)
2. Duration :- Professional Skill 53 Hrs; Professional Knowledge 13 Hrs.  (for above learning out come)

TRADE THEORY (Professional Knowledge ) :- 

• •  Introduction to different formats of images and their uses.
     Introduction to Power Point and its advantages.
     Creating Slide Shows.
  • Fine tuning the presentation and good presentation technique

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

• Manage graphic elements (11.5 Hrs)
  81. Insert illustrations and text boxes (3.5 Hrs)
   Insert shapes
   Insert pictures
   Insert SmartArt graphics
   Insert screenshots and screen clippings
  82. Format illustrations and text boxes (4 Hrs)
   Apply artistic effects
   Apply picture effects and picture styles
   Remove picture backgrounds
   Crop images
   Format graphic elements
   Format SmartArt graphics
  83. Add and modify text in graphic elements (4 Hrs)
   Add and modify text in text boxes
   Add and modify text in shapes
   Add and modify SmartArt graphic text
   Create, insert and modify charts
• Manage Audio & Video elements (6.5 Hrs)
  84. Add Audio elements (2 Hrs)
   Import audio files in presentations
   Configure audio playback options
• 85. Add Video elements (4.5 Hrs)
   Import video files in presentations
   Resize video to fit slide
   Configure video playback options
• Manage transitions and animations (9 Hrs)
  86. Add slide transitions (5 Hrs)
   Add same slide transition for all slides
   Set transition effect duration
   Configure transition start and finish options
   Customise select slide transitions
  87. Add animations (4 Hrs)
   Animate text and graphic elements
   Order shapes, images, and text boxes
   Group shapes, images, and text boxes
   Configure animation effects
   Configure animation paths
   Reorder animations on a slide
• Manage collaboration (0.75 Hrs)
  88. Add and manage comments (0.75 Hrs)
   Add comments
   Review and reply to comments