Computer application in management for thrid year degree student

Ir is used for degree sts

1. A.M.T COLLEGE DEPARTMENT OF INFORMATION TECHNOLOGY COMPUTER APPLICATION IN MANAGEMENT

2. CHAPTER TWO PC-SOFTWARE PACKAGES

3. 2.1 INTRODUCTION In this unit, we are discussing some the important software concepts and providing you the latest knowledge of some software available in the market. Here, we discuss following software packages which are required for general and special purpose : Disk Operating System Windows Word Processor Database Management Packages Spreadsheet Packages

4. 2.2 DISK OPERATING SYSTEM (DOS) An Operating System (OS) is an integrated set of specialized programs that is used to control and manage the resources and overall operation of a computer system.

5. It is a class of software, which controls the execution of other program. It is a single user operating system which means that only one application can be made to run at one time. primary file name up to 8 characters

6. DOS Commands DOS offers a variety of commands to perform various functions. With the help of DOS commands, you can display the list of files and directories that are present on the disk

7. create new files and directories , remove unwanted files and directories and much more.

8. DOS commands can be entered either in uppercase or lowercase letters. The format of a DOS command is called syntax . All DOS commands begin with command name .

9. Some of DOS commands are: Displaying and/or changing date: The DATE Command Displaying and/or changing the current time: The TIME Command Clearing screen: The CLS Command Checking a disk: The CHKDSK Command

10. All DOS commands can be classified into two categories : Internal Commands and External Commands.

11. The important internal commands are: DIR, COPY, DEL, REN, MD, CD, RD, TYPE, COPY CON, DATE, TIME, CLS, ECHO, PROMPT and PATH.

12. The commonly used external commands are: FORMAT, DISKCOPY, CHKDSK, XCOPY and LABEL.

13. 2.3 WINDOWS Windows is an another popular software. A product of Microsoft is the latest upgrade of Its earlier versions (Windows 7, 8,8.1, 10, and 11).

14. Window is a Graphical User Interface (GUI) b/c Everything is provided in the form of pictures and graphics.

15. The program files and other resources are generally accessed with the help of mouse .

16. The Windows(7, 8,8.1, 10, and 11) desktop acts as the primary media for organizing your programs, files and resources.

17. Some Features of Windows It provides a graphical operating environment. All the programs and other resources are provided in the form of Icons .

18. 3. DOS programs can be safely run on Windows. 4. It is a multi-threaded and multi-tasking operating system. 5. It supports long file names upto 255 characters ,

19. 6. The plug and play feature of Windows automatically adapts itself to the hardware it is running on. 7. It gets you organize all your work on the desktop or in folders .

20. The Windows Desktop Desktop acts as the primary media for organizing your programs, files and resources. Taskbar Taskbar is located at the bottom of the Windows desktop.

21. Cont … It contains a start button on the left side. On the extreme right side , the taskbar shows the current time .

22. S tart menu From the start menu many other menus can be seen.

23. Windows Accessories WordPad Notepad Calculator Paint e tc …

24. 2.4 WORD PROCESSOR The application software or program which helps us in processing the text is called a 'Word Processing Software , or simply a 'Word Processor '.

25. Word Processing Software helps:- type your text correct spelling mistakes and grammatical errors

26. align text within margins offer a variety of font styles and font sizes see a preview of the text that you have typed in.

27. The commonly used word processing packages are: MS-WORD WordPad Word Star Word Perfect Professional Write

28. Uses of Word Processing Normally, a word processor can accomplish the following tasks: Brochures Newsletters Reports Advertisement

29. Resumes and Cover letters Books Directories World Wide Web Pages

30. Word processing refers to the creation of documents using word processing software, such as Microsoft Word .

31. 2.5 STARTING WORD 2007 and Above To startup Word in Windows 7 , do the following steps: Click at the Start button Click at the All program Click at the Microsoft office Click at the Microsoft office Word 2007,or word 2010 or 2013, or 2016

32. To startup Word in Windows 8, 8.1, 10 and 11 , do the following steps : 1.click at the search bar 2. Type Microsoft Word 3. Click at the Microsoft office Word 2007,or word 2010 or 2013, or 2016

33. Screen Elements 1. Title Bar Located at the top of the screen; it displays the name of the application (here 'Microsoft Word') and the active document name (here 'Document l ').

34. 2. Menu Bar It shows menu options of Word and is located under title bar . 3. Standard Toolbar Located exactly below the menu bar and gives access to WORD's most frequently used commands and utilities.

35. 4. Formatting Toolbar Lies below the standard toolbar; it offers commonly used formatting commands. 5. Ruler Line Located below the formatting toolbar and provides ongoing page measurement and quick access to margins, tabs and indents.

36. 6. Status bar Located at the bottom of the screen; it displays important and varied information about the currently opened document like page number, column number, line number, etc.

37. 7. View Buttons Located towards the left side of the horizontal scroll bars(above status bar );they show the documents in different views like normal view, page layout view, outline view etc.

38. 8. Horizontal Scroll Bars Help the user to move in the left or right side of the document . 9. Vertical Scroll Bars Help the user to go up or down in the same document

39. 10. Maximize Button Located in the upper right corner of the screen; it controls the size of the application window

40. 11. Minimize Button Located in the upper right corner of the screen, towards left of maximize button; it helps to minimize the whole application and show it in the reduced form on the taskbar.

41. 12. Close Button Located in the upper right corner of the screen, towards right of maxi mize button ; it helps to shut down the opened application; it also allows the user to save the opened files before quitting Word.

42. Working with Documents The various important concepts like : C reation of new files, Opening existing files, Saving and finally Closing them.

43. 2.6 EDITING DOCUMENTS IN WORD Editing means modifying or making changes in your document. It would involve: Inserting new text Copying text from one part of the document to another part

44. Moving text from one part of the document to another part Deleting unwanted text.

45. 2.7 FORMATTING DOCUMENTS Formatting means altering or making the written text attractive. The formatting features like F onts , B ullets and N umbering ,

46. Font type and size,color Bold Italic underline Font is a set of letters that has a common or the same typeface.

47. Changing Case of Text Word offers a quick way to change the case of your text. Lowercase characters can easily be changed to uppercase by hitting <Shift + F3> keys twice and vice versa.

48. 2.8 CLIP GALLERY Adding multimedia effects to the word like images etc …

49. 2.9 PAGE SETTING Page setting includes putting your text neatly between margins/ bounderies . Margins are nothing but an invisible frame within which the whole text appears.

50. 2.10 APPLICATION OF A WORD PROCESSOR IN CORPORATE SECTOR A word processor finds huge usage in the corporate sector . This is a software that is specially designed to help the managers to design and prepare typed documents.

51. It offers very handy tools for managers to work upon. For instance, MS-Word offers many pre-designed professional letters which can be used with little or no modification at all.

52. 2.11 SPREADSHEET PACKAGES Business applications require a lot of calculation work.

53. Popular Spreadsheet Packages MS-EXCEL Lotus 123 Supercalc Framework VP Planner Plus

54. MICROSOFT EXCEL is an application software that is designed in rows and columns with cells which is use for performing arithmetic and logical operations and analyse any financial problems.

55. On every worksheet, there are 256 columns and 65,536 Rows and 16,777,216 cells available on a work sheet.

56. IMPORTANCE OF EXCEL ) It can serve as data base (where records are kept) ) It can be use to prepare students’ results Also for preparation of budget It is use for preparation of account of an organization.

57. FEATURES OF MICROSOFT EXCEL Title Bar Menu Bar Standard Tool Bar Formatting Tool Bar

58. Status Bar Formula Bar Address Bar Drawing Bar

59. Work Sheet :- Is the entire working area in M.S. Excel Columns :-Are vertical lines running from top to down in a worksheet Rows :-Are horizontal lines running from left to right in a worksheet Cells :- Is the intersections between the columns and rows

60. APPLICATION OF A SPREADSHEET IN CORPORATE SECTOR S preadsheets contribute a lot in the day-to-day working of corporate sector. All the managerial reports, price lists, etc., are prepared with the help of electronic spreadsheets.

61. It helps the management to take quick decisions . It is able to answer the important 'what if' questions of the managers based on which they can design and develop various marketing and sales strategies . These days almost all the managers make use of spreadsheets extensively.

62. 2.12 DATABASE MANAGEMENT PACKAGES Business processes are always associated with a huge amount of data.

63. To store, manipulate and processes such data, some software packages are needed, which are collectively known as Database Management Packages/Software/Systems (DBMS).

64. DBMS is defined as a software that organizes and maintains the data in a database for providing the information . Microsoft Access is a Windows based Relational Database Management System (RDBMS ).

65. What is a Database? A database is a collection of related information.

66. It contains related information about each person like his name, address and telephone number.

67. FEATURES OF DATABASE Title Bar Menu Bar Standard Tool Bar Formatting Tool Bar

68. Design Table Task Panel Status Bar Vertical and Horizontal Scroll Bar etc

69. Components of a Database Table : A table is a collection of some specific kind of data. It is the basic element of the database. Data put in a table is organized in rows and columns.

70. Record : Each row is called a record and it contains the complete information about one particular item

71. Column : Each column is called a field. It holds information about a certain type for all records. A field could be a name, address, telephone number, etc

72. The database objects are as follows: Table : It shows the list of all the tables created in the current database. You can create new tables and modify the existing tables .

73. Queries : It shows a list of all the queries in the current database. A query is used to extract certain information from a database.

74. Forms : It displays the names of all the forms created in the current database. A form is used for entering data in the table. Forms can show data in more meaningful and structured manner.

75. Reports : It shows the reports that have been created in the current database. A report is used for showing the data put in the table in an organized manner.

76. Application of a Database in Corporate Sector The software packages called Database Management Systems provide a very high level language interface which can be learned very easily by an end-user.

77. DBMS is very handy for a manager to maintain data and prepare reports based on these data. It also allows you to create queries and provides you an answer to the manager's most difficult decision oriented questions

78. MICROSOFT POWERPOINT POWERPOINT is a graphic presentation of application program which consists of different designs use for presentation.

79. Features of powerpoint SOUND : M.S. Power Point has the facility to incorporate sound to both texts and objects or image. SLIDE : This is a page on which characters are being typed and also graphics are inserted in preparation for a presentation. SLIDE LAYOUT : This is a template on which text boxes are inserted in different format. ANIMATION : PowerPoint has the ability to make object(s) or text(s) to move as if it is dancing or tackling. SLIDE TRANSITION : The slide can be made out in different styles base on your command either by mouse click or automatic timing. CUSTOM ANIMATION : This is an option that allows the computer user to customize the effects inserted on any given object(s). SLIDE DESIGN : This is an option that allows the computer user to select any background of his or her choice for a presentation. SLIDE SHOW : The short cut key is F5. This is an option that allows a presenter to play or run his/her slides.