Suggested Duration: Total 72 hrs for theory & practice.
To learn about computers and office applications that can be handled using the computer.
Prepare various types of office documentation such as letters, memos, newsletters and booklets, collect and display information in the form of tables, analyse the information and prepare charts and graphs, send and receive email, create simple presentations with sound and pictures and store and retrieve office information in a database such as MS Access.
Target Audience: Undergraduate students (of Engineering, MCA and Arts/Science streams) and working executives.
Prerequisites: No prior knowledge is required. This is an entry-level course.
Coverage: Computers an introduction, Hardware, software, Input-process-output cycle, different peripherals.
Basics of Virus, different types of virus, Anti-virus programmes, precautions to be taken to keep the computer virus free, Computer Crime, precautions to be taken, Personal fire-walls, anti-spy software.
Windows Operating System, Windows Explorer, Folders and files, Finding files, Cutting/ Copying and pasting files, Commonly used utilities – Scandisk, Defragmenter, Notepad, Wordpad, Calculator, Paintbrush, Zipping and unzipping files, WinZip. Control panel, Other Operating systems and introduction to Linux.
Network of computers, LAN/WAN, Logging into network, using network resources.
Word Processing, MS WORD, features, formatting and editing in WORD, working with multiple documents, adding pictures to a document, designing a table, mail merge and macros.
What is a spread sheet, MS Excel, features, entering and editing data, presenting and formatting data, formulae and functions in Excel, BODMAS rule, Cut or copy and paste options, autofill, autosum options, drawing charts and graphs in Excel, Pivot tables.
What are presentations, why presentations, presentations on a computer, creating Powerpoint presentations, adding slides, adding pictures to slides, adding cliparts, wordart, adding animation and sound, slide transition, slide show, editing slides, and formatting.
Internet, equipment required to connect, Interenet service providers, World Wide Web, browsers, Search engines and how to use them to search for information in the Internet, Web based Email, Email address, creating a emailId, sending and receiving mail, attachments to mail, using MS Outlook Express and Chatting.
Database concepts and MS Access, editing records in a table, Queries, forms, views and reports.
Office suite – all applications highly integrated, same gui for all applications, increased productivity due to wizards, Office Email with facility to send documents in different ways, integration with the web – save as web page option, web discussions, clip gallery for adding multimedia content to documents.
Project work along with hints.