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
error: Content is protected !!
Scroll to Top