50 PAPI KHATUN INTERRELATION WITH HISTORY

NAME: PAPI KHATUN
ROLL NO: 72

1. KALNA COLLEGE AFFILIATED TO THE UNIVERSITY OF BURDWAN B.ED. SEMESTER-IV COURSE: EPC-3 (ASSESSMENT OF THE LEARNING PROCESS) TOPIC- MS-OFFICE UNDER THE SUPERVISION OF PROF:- ANIKET SUTRADHAR DEPARTMENT OF B.ED. KALNA COLLEGE SUBMITTED BY POPY KHATUN ROLL NO:-220711130042 SESSION-2022-2024

2. MS WORD ( MICROSOFT WORD ) What is MS Word? Microsoft Word is a word processing program that allows for the creation of both simple and complex documents. With Office 365, you are able to download the application to your hard drive and will also have access to the online version. Where to find MS Word on your personal computer? Follow these simple steps to open MS Word on your personal computer: Start → All Programs → MS Office → MS Word. What are the uses of MS Word? MS Word enables users to do write-ups, create documents, resumes, contracts, etc. This is one of the most commonly used programs under the Office suite. Features of MS Word Now let us read more about the features and components of an MS Word doc file in detail.The image given below shows the different elements and categories which are available in MS Word doc:

3. Home This has options like font colour , font size, font style, alignment, bullets, line spacing, etc. All the basic elements which one may need to edit theirdocument is available under the Home option. Insert Tables, shapes, images, charts, graphs, header, footer, page number, etc. can all be entered in the document. They are included in the “Insert” category. Design The template or the design in which you want your document to be created can be selected under the Design tab. Choosing an appropriate tab will enhance the appearance of your document. Page Layout Under the Page Layout tab comes options like margins, orientation, columns, lines, indentation, spacing, etc. References This tab is the most useful for those who are creating a thesis or writing books or lengthy documents. Options like citation, footnote, table of contents, caption, bibliography, etc. can be found under this tab. Review Spell check, grammar, Thesaurus, word count, language, translation, comments, etc. can all be tracked under the review tab. This acts as an advantage for those who get their documents reviewed on MS Word.

4. Uses of MS Word Given below are the different fields in which MS Word is used and simplifies the work of an individual: In Education: It is considered as one of the simplest tools which can be used by both teachers and students. Creating notes is easier using MS Word as they can be made more interactive by adding shapes and images. It is also convenient to make assignments on MS Word and submitting them online In Workplace: Submitting letters, bills, creating reports, letterheads, sample documents, can all easily be done using MS Word Creating & Updating Resume: One of the best tools to create your resumes and is easy to edit and make changes in it as per your experience For Authors: Since separate options are available for bibliography, table of contents, etc., it is the best tool which can be used by authors for writing books and adjusting it as per the layout and alignment of your choice Also, creating a Doc file and converting it into PDF is a more suitable option, so it is highly recommended.

5. MS PowerPoint PowerPoint (PPT) is a powerful, easy-to-use presentation graphics software program that allows you to create professional-looking electronic slide shows. The image given below shows the main page of MS PowerPoint, where a person lands when the program is opened on a computer system. How to open MS PowerPoint on a personal computer? Follow the steps below to open MS PowerPoint on a personal computer: Click on the start button Then choose “All Programs” Next step is to select “MS Office” Under MS Office, click on the “MS PowerPoint” What is a PowerPoint presentation or PPT? A combination of various slides depicting a graphical and visual interpretation of data, to present information in a more creative and interactive manner is called a PowerPoint presentation or PPT.

6. What all elements can be added to a slide? Clip Art Graphs Tables Photographs ChartsMedia ClipsVideos Features of MS PowerPoint There are multiple features that are available in MS PowerPoint which can customise and optimise a presentation. The same have been discussed below. Slide Layout Multiple options and layouts are available based on which a presentation can be created. This option is available under the “Home” section and one can select from the multiple layout options provided. The image below shows the different slide layout options which are available for use:

7. Insert – Clipart, Video, Audio, etc. Under the “Insert” category, multiple options are available where one can choose what feature they want to insert in their presentation. This may include images, audio, video, header, footer, symbols, shapes, etc. The image below shows the features which can be inserted: Slide Design MS PowerPoint has various themes using which background colour and designs or textures can be added to a slide. This makes the presentation more colourful and attracts the attention of the people looking at it. This feature can be added using the “Design” category mentioned on the homepage of MS PowerPoint. Although there are existing design templates available, in case someone wants to add some new texture or colour , the option to customise the design is also available. Apart from this, slide designs can also be downloaded online. Refer to the below for slide design:

8. Animations During the slide show, the slides appear on the screen one after the other. In case, one wants to add some animations to the way in which a slide presents itself, they can refer to the “Animations” category. The different animation styles available on PowerPoint are: Uses of PowerPoint PresentationPowerPoint presentations are useful for both personal and professional usage. Given below are a few of the major fields where PPT is extremely useful: Education – With e-learning and smart classes being chosen as a common mode of education today, PowerPoint presentations can help in making education more interactive and attract students towards the modified version of studying Marketing – In the field of marketing, PowerPoint presentations can be extremely important. Using graphs and charts, numbers can be shown more evidently and clearly which may be ignored by the viewer if being read Business – To invite investors or to show the increase or decrease in profits, MS PowerPoint can be used Creating Resumes – Digital resumes can be formed using MS PowerPoint. Different patterns, photograph, etc. can be added to the resume Depicting Growth – Since both graphics and text can be added in a presentation, depicting the growth of a company, business, student’s marks, etc. is easier using PPT

9. MS EXCEL What is Excel? Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications. Microsoft Excel enables users to format, organize and calculate data in a spreadsheet. What is MS Excel? MS Excel is a spreadsheet program where one can record data in the form of tables. It is easy to analyse data in an Excel spreadsheet. The image given below represents how an Excel spreadsheet looks like: How to open MS Excel? To open MS Excel on your computer, follow the steps given below: Click on Start Then All Programs Next step is to click on MS Office Then finally, choose the MS-Excel option Alternatively, you can also click on the Start button and type MS Excel in the search option available.

10. What is a cell? A spreadsheet is in the form of a table comprising rows and columns. The rectangular box at the intersection point between rows and columns forms a cell. Given below is an image of a cell: What is Cell Address? The cell address is the name by which is cell can be addressed. For example, if row 7 is interested in column G, then the cell address is G7. Features of MS Excel Various editing and formatting can be done on an Excel spreadsheet. Discussed below are the various features of MS Excel. The image below shows the composition of features in MS Excel:

11. Home Comprises options like font size, font styles, font colour , background colour , alignment, formatting options and styles, insertion and deletion of cells and editing options Insert Comprises options like table format and style, inserting images and figures, adding graphs, charts and sparklines , header and footer option, equation and symbols Page Layout Themes, orientation and page setup options are available under the page layout option Formulas Since tables with a large amount of data can be created in MS excel, under this feature, you can add formulas to your table and get quicker solutions Data Adding external data (from the web), filtering options and data tools are available under this category Review Proofreading can be done for an excel sheet (like spell check) in the review category and a reader can add comments in this part View Different views in which we want the spreadsheet to be displayed can be edited here. Options to zoom in and out and pane arrangement are available under this category For those willing to learn more about MS Excel, can refer to the video given below and understand every small aspect of this program in detail.

12. Benefits of Using MS Excel Given below are a few important benefits of using MS Excel: Easy To Store Data: Since there is no limit to the amount of information that can be saved in a spreadsheet, MS Excel is widely used to save data or to analyse data. Filtering information in Excel is easy and convenient. Easy To Recover Data: If the information is written on a piece of paper, finding it may take longer, however, this is not the case with excel spreadsheets. Finding and recovering data is easy. Application of Mathematical Formulas: Doing calculations has become easier and less time-taking with the formulas option in MS excel More Secure: These spreadsheets can be password secured in a laptop or personal computer and the probability of losing them is way lesser in comparison to data written in registers or piece of paper. Data at One Place: Earlier, data was to be kept in different files and registers when the paperwork was done. Now, this has become convenient as more than one worksheet can be added in a single MS Excel file. Neater and Clearer Visibility of Information: When the data is saved in the form of a table, analysing it becomes easier. Thus, information is a spreadsheet that is more readable and understandable.

13. MICROSOFT ACCESS What is the definition of MS Access? Answer: Microsoft Access is a database management system (DBMS) that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. What are the uses of MS Access? Answer: MS Access can be used to develop application software and is generally used by data architects, software developers and power users. Following are the major uses of MS Access: Manage accounts and bills Store data in the form of tables and edit or customise them later as per the requirement of the user It can be used to make our websites Comparing data or finding a relationship between the existing data can be done using Access What are the major components of MS Access? Answer:ThemajorcomponentsofMSAccessareas follows: Tables Queries Relationships Macros Forms Reports Module

14. How many types of databases are there in MS Access? There are two types of database in MS Access: Flat File Database: When the data is stored in the form of a plain text file and cannot incorporate multiple tables. Relational Database: When the data is stored in a form that the data items are related to one another. It supports multiple tables which organise the text in rows and columns. Components of MS AccessThe Tables: A table in Access is similar to any other tabulated data in the form of rows and columns. However, when adding data to a program to create a table, all the information entered must be correct as if any incorrect data is entered the processing may become slow or may not give the correct answer. The appearance of the table may look similar to the one formed in Excel with column heading and titles Queries: Once a table is created and the user or programmer is looking for a calculated output, then it is called queries. This may include filtering, calculating, sorting, updating, etc. Relationships: As the name suggests, when more than one table is added, the relation or connection between them can be achieved. There three ways in which the connection between the tables can be determined:One to oneOne to ManyMany to Many Macros: The tool using which predefined actions which can automate tasks on an Access report is called macros. Multiple tasks can be assigned and they will function whenever the macros option is selected on a report Forms: A user interface for a database application can be created using forms. Forms can further be divided into two: bound and unbound forms Report: Once all the information is entered into the database, it can be reviewed or analysed using a report. A report can then be customised or modified as per the user’s requirement Module: This allows a set of pre-defined instructions to be created by a programmer in the database. They can be used throughout the database

15. Benefits and Limitations of using MS Acce ss It was Microsoft’s first database software, and came along with a lot of advantages and convenience for its users. At the same time, there were limitations to it. Discussed below are the benefits and limitations which came along with MS Access usage. Benefits: Easy to create database within lesser time duration Used a very comprehensive programming language which made it user friendly With each revised version, new options and features were made available to the users for their convenience It is easy to install and then easy to understand its working Importing data was easy Graphical user interface made it easy to use Limitations: Not too many people can use the same database at a single time. This may affect its speed and efficiency The same database was tough to use with different Operating systems Better database systems can be used for confidential data

16. Microsoft Publisher Microsoft Publisher is a desktop publishing application from Microsoft, differing from Microsoft Word in that the emphasis is placed on page layout and graphic design rather than text composition and proofreading . Example: Microsoft Publisher is an Office program that allows you to make professional documents such as newsletters, postcards, flyers, invitations, brochures, and more using built-in templates. Features of Microsoft Publisher: Technical-level effects for texts, shapes, and images. Capability to use high-quality image backgrounds. Mail merge tools. Personalization tools. Drag-and-drop picture importing and interchanging. Detailed ruler and guides for correct measurements. Document-sharing abilities. What Is Microsoft Publisher Used? Personalized birthday cards. Event posters. Newsletters for small businesses and organizations. Professional business cards. Flyers and programs. Postcards and brochures.

17. THANK YOU