Application Packages

Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

After studying this, you will be able to –

MSWORD: Word processing and units of document, features of word- processing packages.

MSWORD: Creating, Editing, Formatting and saving a document in MSWORD – Features of File, Edit and Format menus.

MSEXCEL: Electronic Spreadsheets – concept, packages, creating, editing and saving a spreadsheet with MSEXCEL.

MSACCESS: Concept of Database, Units of database.

MSACCESS: creating database.

WINDOWS:GUI, Desktop and its elements, Anatomy of a window – Title Bar, Minimize, Maximize, Restore and Close Buttons, Scroll Bars, Menus and Tool – Starting and shutting down of windows.

MSEXCEL: Use of in-built Statistical and other functions and writing expressions, Creating Data Analysis option in Tools Menu, Use of Data Analysis Tools – Correlation and Regression, t-test for two samples, Creating Graphs.

PRACTICALS

MSWORD – Creating a Document, Editing and Saving

MSWORD: Use of options from the Tool Bars – Format, Insert and Tools (Spell Check), Alignment of paragraphs and Text

MSWORD: Creating a Table, Merging of Cells, Columns and Row Width

MSEXCEL: Creating a Spreadsheet, Alignment of Rows, Columns and Cells using Format Tool Bar

MSEXCEL: Entering formula expression through the formula tool brand and use of inbuilt functions – SUM, AVERAGE and STDEV

MSEXCEL: Data Analysis using inbuilt Tool Packs – Correlation and Regression

MSEXCEL: Data Analysis using inbuilt Tool Packs – tests of significance

MSEXCEL: Creating and Saving Graphs.

MSACCESS: Creating Database, structuring with different types of fields.

MSACCESS: use of Query facility for accessing the information transforming the data of WORD and EXCEL to other forms

MSEXCEL: Data Analysis using inbuilt Tool Packs – tests of significance

 

Show More

What Will You Learn?

  • MSWORD – Creating a Document, Editing and Saving
  • MSWORD: Use of options from the Tool Bars – Format, Insert and Tools (Spell Check), Alignment of paragraphs and Text
  • MSWORD: Creating a Table, Merging of Cells, Columns and Row Width
  • MSEXCEL: Creating a Spreadsheet, Alignment of Rows, Columns and Cells using Format Tool Bar
  • MSEXCEL: Entering formula expression through the formula tool brand and use of inbuilt functions – SUM, AVERAGE and STDEV
  • MSEXCEL: Data Analysis using inbuilt Tool Packs – Correlation and Regression
  • MSEXCEL: Data Analysis using inbuilt Tool Packs – tests of significance
  • MSEXCEL: Creating and Saving Graphs.
  • MSACCESS: Creating Database, structuring with different types of fields.
  • MSACCESS: use of Query facility for accessing the information transforming the data of WORD and EXCEL to other forms
  • MSEXCEL: Data Analysis using inbuilt Tool Packs – tests of significance

Course Content

WORD PROCESSING
Definition: Word-processing is essentially typing, editing, and manipulation of a document in a desired form. Units of the Document: Since word-processing is concerned with preparation of a document (in a desired form), it is essential to know the units of the document: 1. Character: It refers to the alphabets, numerical digits, punctuations and other special symbols which are commonly used in the text. 2. Word: A word is group of characters that are separated from other group of characters by some delimiters like, comma, full stop and space. 3. Sentence: A sentence is a group of words preceded and followed by appropriate delimiting characters. 4. Paragraph: It is a group of one or more sentences, paragraphs are separated by leaving blank lines between them. 5. Pages: It is the amount of text that can be printed on one page of a paper. 6. Chapters: It is a collection of pages 7. Documents and files: It is a group of chapters. Usually, a complete document may be very short such as a memo (or letter) or very long such as a book consisting of several chapters. These documents are referred as ―Files. Features of Word-processing: 1. Word-wrap 2. Cursor control 3. Editing 4. Formatting 5. Spell-check 6. Thesaurus 7. Macros 8. Printing 9. File management 10. Mail merge printing 1. Word-wrap: In word-processing packages, the text can be continuously typed and the computer automatically starts a fresh line when a line is filled up. As soon as the length of a sentence exceeds the right margin, the corresponding word is automatically adjusted in the following line. This is called ―word-wrap. A paragraph is created only when carriage control is externally given for a sentence. 2. Cursor Control: The four directional keys of the keyboard ( ) helps in locating the text for editing in much the similar manner as that of a pointer or pencil. 3. Editing: Words or lines can be entered (inserted) or deleted in any part of the text with proper alignment. Similarly, there is a facility to recover the text which is deleted by mistake or accidentally. Another important facility is that any word can be replaced by a new word throughout the file, wherever the old word appears. In addition to these, a block of text (which is frequently used) can be prepared and moved or copied wherever desired in the file. 4. Formatting: The text formatting refers to the way the text is desired to appear on a page. This includes following functions • setting left and right margins • Paragraph settings • Line spacing • setting foot-notes • number of lines per page •selecting font specifications such as underline, bold, italics, superscripts and Subscripts. •setting foot-notes • number of lines per page • printing page numbers and headings for ̳Header‘ and ̳Footer‘ • table of contents • indexing the text 5. Spell-check: Word-processing packages provide checking of spellings facility 6. Thesaurus: It provides synonyms (or words with similar meanings) 7. Macros: A macro is a character or word that represents a series of keystrokes. The ability to define macros allows us to save a lot of time by replacing common combinations of keystrokes. 8. Printing: It gives a hard copy of the text. The printing can be controlled after printing a fixed number of pages or can be resumed from any specified page number. 9. File management: This facility allows to create, delete, move & search for files. 10. Mail merge printing: This facility helps in printing same ―original‖ letter with different addresses, so that each letter is original and not a carbon copy.

  • Word Processing
    00:00

MS-WORD
MS- Word is a word processor. The extension name of MS- word is .doc. It is an application used to create, edit, print and save a document. It allows the user to insert pictures, tables, charts, drawings & features that will make the text richer & more interactive. (The term document refers to a file created using word processor)

MS -EXCEL
Spreadsheet is a software that helps to substitute the paper worksheets in the offices. Spreadsheet displays data in the form of rows and columns. An intersection of row and column is known as a cell. MS-Excel is a window based spreadsheet developed by Microsoft Corporation. It includes all features of a spreadsheet package like recalculation, graphs & functions. It also provides many Mathematical, Financial & Statistical functions. Thus it is used in many scientific and engineering environments for analyzing data. Excel can even hold graphic objects like pictures & images.

MS-ACCESS
MS-Access is a Relational Database Management System (RDBMS) that is used to store and manipulate large amount of information. The extension name of Ms-Access file is .mdb.

FIRST TEST
Complete the test and submit

Student Ratings & Reviews

No Review Yet
No Review Yet

Learning often happens in classrooms but it doesn't have to.