Certificate Course In Computer Operation With M.S. Office

Eligibility
12th Pass
Duration
6 months
Trainer: Mr. Prasad Shetty

Certificate Course in Computer Operation With M.S. Office is designed to introduce a students the present need of Information Technology. This course, will prepare the student to be able to carry out day to day requirement in a modern office automation process for a small organization.

COURSE SYLLABUS

1. Computer Operation With M.S. Office

2. Computer fundamentals

3. MS – Office 

 

  • Fundamentals of computers & operating systems
  • Introduction to computer : Definition of electronic digital computer & their characteristics like: speed, accuracy, storage, diligence, automation & versatility. Computers micro, mini, mainframe, super computers, pc, pc-xt, pc-at.
  • Structure of computer :- Block diagram & functions of different units of computer.
  • Computer languages :- Machine language, assemble language and high level languages, introduction to compilers and interpreters, ( definition and comparison). Overview of representation of data.
  • Input / Output devices :- Study of keyboard, VDU, printer, plotter, and mouse.
  • Secondary storage devices :- Tapes, Disks, Hard disks, Floppy Sectors, Tracks, Cylinders, Memory Capacity, Cartridge, Backup Tapes
  • Security & safety of data :- Security : Like passwords, write protections. Safety : Like monthly, weekly backup, concept of virus & preventive measures.
  • Introduction to operating systems :- Dos, introduction to LAN, windows 98 and introduction to nt, study of commonly used dos internal and external commands like dir, type, cls, date, time, copy, del, erase, disk copy, format, disk comp, md, cd, rd, backup, restore, copy con, deltree, attrib, creating simple batch file, edit command.
Introduction to Internet
 
  • Concept of Internet www, ISP, Internet protocols, TCP/IP, http, ftp, telnet, browsers, web page.
  • Web surfing, sending and receiving e-mail, sending word document as an attachment.

FoxPro 2.6 operation

Database management system ( FoxPro 2.6 operation ) :- Introduction to DBMS, difference between DBMS & RDBMS, logical concept of database, data types, creating database, adding records, viewing databases, saving databases, editing records, deleting records and files, modifying database structure sorting and indexing, label generation, report generation, queries, got, locate, seek, find, selecting records, satisfying particular conditions.

Microsoft windows 98 or NT higher

  • The windows environment :- Structure or a sample window, exploring the desktop, the start button, my computer, using help, taskbar, working with multiple windows, printing documents, menus, dialog boxes, icons, views and switching views maximizing, minimizing, restoring, resizing, moving, closing, closing window, parent & child window creating icons / shortcuts.
  • Accessories :- Notepad, WordPad, paint, character map, clipboard, viewer media player, phone dialer, calculator.
    Customizing windows :- Setting colour, patterns, wallpapers and screen savers, date and time, mouse, keyboard.
  • Managing files and folders :- Selecting multiple files/folders, using windows explorer, copy and moving flies/folders, using the recycle bin, by passing the recycle bin globally, creating / renaming files/folders, opening documents.
  • Working with programs :- Starting and closing programs, using run command, adding start menu program, using startup folder, starting programs minimized, cut, copy & paste operation, running ms-dos application.
Introduction to MS-Office

The office shortcut bar, managing files with office application, key combination, cut, copy, paste, object linking and embedding, drag & drop editing. Customizing toolbars & the menu-bar, undo / redo, spell-checking, working with dictionaries, auto-correct, templates & wizards.

A) M.S. WORD : – Working with text, graphics and text boxes inserting & sizing pictures, normal view, online layout view, page layout view, print preview, outline view, split screen view, zooming the view, character formatting, paragraph formatting, language formatting, flowing text, borders & shading, creating / applying / modifying / removing styles, using style gallery, setting margins, paper size, paper orientation, creating & deleting section, using auto-format, setting headers, footers, footnote, end note using print dialog box, printing documents. Introduction to mail-merge and tables, printing documents, auto format, using heading numbering, find and replace, auto-text,
auto-correct, automatic bullet and numbering, inserting/ updating caption, using auto-caption, using bookmarks.
 
B) M.S. EXCEL. :- Spread sheet, work sheet and work book, structure or excel screen, adding/deleting/renaming/rearranging worksheet, creating a spread sheet, entering various types of data, viewing worksheet, zoom, split freezing panes for screen view, selecting a range, naming a cell or range, formatting data- number formatting, alignment, font formatting, border formatting, using patterns and colours, protection, auto formatting, creating/ applying/ modifying/ deleting/ merging styles in worksheet, adding comments, headers and footers, printing form excel, printing range of cells, using print preview, chart terms and basics, creating / modifying / moving / resizing / deleting /
editing chart, using the chart toolbar. Basics of formulas and function, creating a formula, copying and moving formulae, using goal seek, scenarios.
 
C) M.S. POWERPOINT :- Creating a presentation, using auto content wizard, using template, working with five views, creating and editing slides, entering /pasting / selecting / formatting text, promoting and demoting paragraphs,changing layout of slide, previewing slide show inserting graph / chart /picture / org chart in presentation, drawing, auto-shapes, working withboarders, fills, shadows. Setting preset / custom animation, assigning transitions and timings, creating builds slides, setting up slide show.
 

INTRODUCTION TO OPERATING SYSTEM

Disk Operating system
Internal and External DOS commands like dir, type, cls, date, time, copy, del, erase, disk
copy, format, disk comp, md, cd, rd, backup, restore, copy con, deltree, attrib, creating
simple batch file, edit command

MICROSOFT WINDOWS 98 OR NT HIGHER
The windows environment :- Structure or a sample window, exploring the desktop, the start button, my computer, using help, taskbar, working with multiple windows, printing
documents, menus, dialog boxes, icons, views and switching views maximizing, minimizing, restoring, resizing, moving, closing, closing window, parent & child window creating icons /  shortcuts


Accessories :- Notepad, WordPad, paint, character map, clipboard, viewer media player,
phone dialer, calculator


Customizing windows :- Setting colour, patterns, wallpapers and screen savers, date and
time, mouse, keyboard.


Managing files and folders :- Selecting multiple files/folders, using windows explorer, copy and moving flies/folders, using the recycle bin, by passing the recycle bin globally, creating / renaming files/folders, opening documents.

Working with programs :- Starting and closing programs, using run command, adding start menu program, using startup folder, starting programs minimized, cut, copy & paste
operation, running ms-dos application

Concept of Internet www, ISP, Internet protocols, TCP/IP, http, ftp, telnet, browsers, web
page Web surfing, sending and receiving e-mail, sending word document as an attachment.

INTRODUCTION TO MS.OFFICE

The office shortcut bar, managing files with office application, key combination, cut, copy,
paste, object linking and embedding, drag & drop editing. Customizing toolbars & the menu-bar, undo / redo, spell-checking, working with dictionaries, auto-correct, templates & wizards.

M.S. WORD : –

Working with text, graphics and text boxes inserting & sizing pictures, normal view, online layout view, page layout view, print preview, outline view, split screen view, zooming the view, character formatting, paragraph formatting, language formatting, flowing text, borders & shading, creating / applying / modifying / removing styles, using style gallery, setting margins, paper size, paper orientation, creating & deleting section, using auto-format, setting headers, footers, footnote, end note using print dialog box, printing documents. Introduction to mail merge and tables, printing documents, auto format, using heading numbering, find and replace, auto-text, auto-correct, automatic bullet and numbering, inserting/ updating caption, using autocaption, using bookmarks.

 

M.S. EXCEL. :-
Spread sheet, work sheet and work book, structure or excel screen, adding/deleting/renaming/rearranging worksheet, creating a spread sheet, entering various types of data, viewing worksheet, zoom, split freezing panes for screen view, selecting a range, naming a cell or range, formatting data- number formatting, alignment, font formatting, border formatting, using patterns and colours, protection, auto formatting, creating/ applying/ modifying/ deleting/ merging styles in worksheet, adding comments, headers and footers, printing form excel, printing range of cells, using print preview, chart terms and basics, creating / modifying / moving / resizing / deleting / editing chart, using the chart toolbar. Basics of formulas and function, creating a formula, copying and moving formulae, using goal seek, scenarios.

 

M.S. POWERPOINT :-

Creating a presentation, using auto content wizard, using , working with five views, creating and editing slides, entering / pasting / selecting / formatting text, promoting and demoting paragraphs, changing layout of slide, previewing slide show inserting
graph / chart / picture / org chart in presentation, drawing, auto-shapes, working with boarders, fills, shadows. Setting preset / custom animation, assigning transitions and timings, creating builds slides, setting up slide show.

  • Computer & Common Sense – Hunt Shelly
  • A First Course in Computer – Sanjay Saxena
  • Advance Microsoft Office 97 for windows for Dummies – Walls Wang
  • Microsoft Office 97 –  Gini Couter, Annette Marquis
  • Master Office 97 Visually – Comdex Publication
  • Office 97 Small Business Solution Rider
  • Compact Guide to MS-Office Professional – Shelly O’Hara, Deborah
    Allen BPB Publication
  • Computer Fundamental – P.K.Sinha
OUR ALUMNI WORK AT
FREQUENTLY ASKED QUESTIONS
What is the duration of the course?

This is a six month course

What is the USP of SPICE?

Great infrastructure, constant updating of curriculum based on market needs, faculty from the industry and a willingness to change based on feedback.

Great atmosphere, engaged teachers, a feeling that you have joined a family. Ask our alumni! 

Is it online or offline?

This is an offline course. You will need to come to the college

What is the fee for these courses?

Fee is Rs 10,000/-

Is this course certified?

This short-term course is accredited by Maharashtra State Board of Skill, Vocational Education and Training.

ENQUIRE NOW

Click on the Enquire Now button, fill the form & our course coordinator will help you with the admission process

Scroll to top