Reference Learning Outcome :-Install and setup operating system and related software in a computer following safety precautions. (Mapped NOS: SSC/N3022)
Duration :- Professional Skill 94 Hrs; Professional Knowledge 32 Hrs (for above learning out come)
TRADE THEORY (Professional Knowledge ) :-
Introduction to DOS Command Line Interface & Linux Operating Systems (10 Hrs)
Introduction to basic DOS Internal and External Commands.
Introduction to Open Source Software
Introduction to Linux Operating System features, structure, files and processes
Basic Linux commands..
TRADE PRACTICAL (Professional Skills With Indicative Hours) :- Job no. & Name of the Practical
DOS Command Line Interface (9Hrs)
22. Use basic DOS commands for directory listing. (5 Hrs)
23. Manage files and folders using DOS commands. (4 Hrs) Install Ubuntu Linux operating system and execute basic Linux commands (27 Hrs)
24. Installation of Ubuntu Linux operating system (6 Hrs)
25. Install necessary application software for Linux i.e. Office Package, PDF Reader, Media Player etc. (4 Hrs)
26. Use Basic Linux commands for directory listing, file and folder management, password etc. (6 Hrs)
27. Use the Linux graphical user interface for file and folder management, exploring the system etc. (6 Hrs)
28. Customize desktop settings and manage user accounts in Linux. (3 Hrs)
WEEK. NO. 06 & 07
Reference Learning Outcome :- Create, format, and edit document using word processing application software. (Mapped NOS: SSC/N3022)
Duration :- Professional Skill 47 Hrs; Professional Knowledge 14 Hrs (for above learning out come)
TRADE THEORY (Professional Knowledge ) :-
Using Word Processing Software (14 Hrs)
Introduction to the various applications in MS office.
Introduction to Word features, Office button, toolbars.
Creating, saving and formatting and printing documents using Word.
Working with objects, macro, mail merge, templates and other tools in Word.
TRADE PRACTICAL (Professional Skills With Indicative Hours) :- Job no. & Name of the Practical
Manage documents (11 Hrs.) 30. Navigate within documents (2 Hrs)
Search for text
Link to locations within documents
Move to specific locations and objects in documents
Show and hide formatting symbols and hidden text 31. Format documents (4.6 Hrs)
Set up document pages
Apply style sets
Insert and modify headers and footers
Configure page background elements 32. Save and share documents (2 Hrs)
Save documents in alternative file formats
Modify basic document properties
Modify print settings
Share documents electronically 33. Inspect documents for issues (2.4 Hrs)
Locate and remove hidden properties and personal information
Locate and correct accessibility issues
Locate and correct compatibility issues
Format documents (8 Hrs.) 34. Insert text and paragraphs (2 Hrs)
Find and replace text Insert symbols and special characters 35. Format text and paragraphs (3 Hrs)
Apply text effects
Apply formatting by using Format Painter
Set line and paragraph spacing and indentation
Apply built-in styles to text
Clear formatting 36. Create and configure document sections (3 Hrs)
Format text in multiple columns
Insert page, section, and column breaks
Change page setup options for a section
Manage tables and lists (9.5 Hrs) 37. Create tables (3 Hrs)
Convert text to tables
Convert tables to text
Create tables by specifying rows and columns 38. Modify tables (3 Hrs)
Sort table data
Configure cell margins and spacing
Merge and split cells
Resize tables, rows, and columns
Split tables
Configure a repeating row header 39. Create and modify lists (3.5 Hrs)
Format paragraphs as numbered and bulleted lists
Change bullet characters and number formats
Define custom bullet characters and number formats
Increase and decrease list levels
Restart and continue list numbering
Set starting number values
Create and manage references (3 Hrs.) 40. Create and manage reference elements (1.4 Hrs)
Insert footnotes and endnotes
Modify footnote and endnote properties
Create and modify bibliography citation sources
Insert citations for bibliographies 41. Create and manage reference tables (1.6 Hrs)
Insert tables of contents
Customize tables of contents
Insert bibliographies
Manage graphic elements (8.5 Hrs.) 42. Insert illustrations and text boxes (3 Hrs)
Insert shapes
Insert pictures
Insert 3D models
Insert Smart Art graphics
Insert screenshots and screen clippings
Insert text boxes 43. Format illustrations and text boxes (3 Hrs)
Apply artistic effects
Apply picture effects and picture styles
Remove picture backgrounds
Format graphic elements
Format SmartArt graphics
Format 3D models 44. Add text to graphic elements (1 Hr)
Add and modify text in text boxes
Add and modify text in shapes
Add and modify SmartArt graphic content 45. Modify graphic elements (1.5 Hrs)
Position objects
Wrap text around objects
Add alternative text to objects for accessibility
Manage Mailings (3.5 Hrs) 48. Perform mail merge (3.5 Hrs)
Create envelopes
Create labels
Create a new mailing list
Perform mail merge using an existing list
WEEK. NO. 08
Reference Learning Outcome :- Create, format, edit and develop a workbook by using spreadsheet application software. (Mapped NOS: SSC/N3022)
Duration :- Professional Skill 72 Hrs; Professional Knowledge 18 Hrs. (for above learning out come)
TRADE THEORY (Professional Knowledge ) :-
Introduction to Excel features and Data Types.
Cell referencing and linking Sheets.
TRADE PRACTICAL (Professional Skills With Indicative Hours) :- Job no. & Name of the Practical
Manage Worksheets and Workbooks (12 Hrs.) 49. Open files in MS Excel (1.5 Hrs)
Open MS Excel
Create a new Excel file
Create a new Excel file from a template
Open an existing Excel file 50. Import data (1.5 Hrs)
Import data from txt files
Import data from csv files
51. Navigate within workbooks (2 Hrs)
Search data
Navigate to named cells, ranges or workbook elements
Insert and remove hyperlinks 52. Format worksheets and workbooks (2 Hrs)
Modify page setup
Adjust row height and column width
Customize headers and footers 53. Customize options and views (3 Hrs)
Display and modify content in different views
Freeze rows and columns
Change window views
Modify basic workbook properties
Display formulas 54. Configure content for collaboration (2 Hrs)
Set a print area
Save workbooks in alternative file formats
Configure print settings
Manage data cells and ranges (12 Hrs.) 55. Manipulate data (3 Hrs)
Paste data by using special paste options
Fill cells by using Auto Fill
Insert and delete multiple columns or rows
Insert and delete cells 56. Format cells and ranges (5 Hrs)
Merge and Unmerge cells
Modify cell alignment, orientation and indentation
Format cells using Format Painter
Wrap text within cells
Apply number formats
Apply cell formats from the Format cells dialog box
Apply cell styles
Clear cell formatting 57. Define and reference named ranges (4 Hrs)
Define a named range
Name a table
Summarize data visually Insert spark lines
Apply built in conditional formatting
Remove conditional formatting