In Fulfillment of the Requirements of Elective Subject: - Computer Science Topic Ms-Word, Ms-Excel and Ms-PowerPoint Platform WindowsXP Professional Submitted by - Rakesh Kr. Sha Class-IX, Roll No: 40 Happy Montessori English School, Guwahati (Our Motto: Learn to be Happy) CONTENTS REPORT WORKSHEET- MY SCHOOL i REPORT WORKSHEET- HISTORY OF COMPUTER ii REPORT WORKSHEET- DIAGRAM OF COMPUTER iii REPORT WORKSHEET- WEATHER AND CLIMATE iv MS-WORD Introduction Ms-Word v Poster Ms-Word vi MS-EXCEL Introduction Ms-Excel Vii Spreadsheet with Graph Ms-Excel viii MS-POWERPOINT Introduction Ms-PowerPoint ix Presentation Ms-PowerPoint x CONCLUSION MS-WORD v INTRODUCTION OF MS-WORD Ms Word is word processing application software. By processing word we means we can type text and then edit, modify, delete or print it. The biggest advantage is that is a “electronic cut and past”. Features of MS word Wizards and templates that help in creating documents with build in style Spelling and grammar Automatic spelling correction Formatting tools that let the user to change the look and feel of document created Drawing, borders shading etc. Tools for creating web-pages To open MS-Word:- Go to start > All Programs > Ms-Word Active windows of MS-Word has following parts 1. Title Bar: This tells us which document is currently open. 2. Menu bar: This is the traditional windows style drop down. 3. Status bar: It gives information about your work current page, Selection number, current/total page in document, current cursor position, Current number line. 4. Stander tool bar: tool bar is very useful in quickly executing without going to menu 5. Formatting toolbar: This contains icons for changing look of your text. 6. Cursor: This denotes the place where text. 7. Ruler: The ruler lets us make change to margin. 8. Scroll bar: This helps us to travel with your document. Graphical view of MS-Word Screen with description is shown below:- MS-WORD vi A POSTER CREATED USING WORDART, CLIPART AND AUTOSHAPES This Christmas We Brings You Lots of Gifts and Discounts on every Purchases as on or before 25th Dec Assured Get Discount Gift on Upto 20% Purchases above On every item Rs. 500/- Address: - BIG BAZAR Guwahati, Assam Terms & Conditions Apply MS EXCEL vii INTRODUCTION OF MS-EXCEL Before the invention of personal computers and spreadsheet program, accountants and banker generally wrote their account by creating table of number and text. These tables were called worksheets or spreadsheets. The worst problem with these manual worksheets was that if one number changed, it affected all others down the line. So, a lot of erasing and rewriting was required. A dramatic change too place after the invention of electronic spreadsheet program, which presents data in rows and columns on a computer screen. So, if any number in a cell is altered, the system takes care of the corresponding changes in other rows and columns, like the total at the end of the column. Working with a spreadsheet on a computer is very simple. We can enter the data that we want in our spreadsheet and key in the type of calculations needed. The electronic spreadsheet program does all the calculations and produces the results. These programs have made the task of building and modifying worksheets easier. MS Excel is an electronic spreadsheet program that is used to create worksheets, charts, etc. It is a component of a large package called MS Office, like word and PowerPoint, but with a different purpose. Lotus and VisiCalc are some other examples of spreadsheets programs. Starting MS-Excel:- To open the Excel program on our PC we have to follow these steps:- Click on Start > Programs > Microsoft Excel. A window, like the one shown below with an empty worksheet, appears on the screen. Standard Title Bar Formula Bar Formatting Minimize Close Toolbar Toolbar Button Button Name Restore Box Button Cell Pointer (Active Cell) Column Heading s Row Heading s Scroll Bar Sheet Status Bar Num Lock Tabs On MS POWERPOINT ix INTRODUCTION OF MS POWERPOINT Ms-PowerPoint is the most powerful tool in Microsoft Office. It is used for presentation of data and documents in graphical format. To Start Ms-PowerPoint Go To Start > All Programs > MS PowerPoint:- A PowerPoint slide may contain one or more of the following components: a. Title and subtitles b. Text, c. Clipart and picture, d. Drawing object, e. Graphs, f. Header & footer g. Notes, h. Outlines. Standard Toolbar Text Title and Subtitle Picture Outline Pane Notes Status Bar Footer PRESENTATION x THE SLIDE SORTER VIEW OF A PRESENTATION: - DIAGRAM OF A COMPUTER iii DIAGRAM OF A COMPUTER SHOWING ITS EXTERNAL PARTS MONITOR CENTRAL PROCESSING UNIT (CPU) SPEAKER MOUSE KEYBOARD Input Device: - Keyboard and Mouse Output Device: - Monitor Processing Device: - Central Processing Device (CPU) HISTORY OF COMPUTERS ii HISTORY OF COMPUTERS According to a survey, at this very moment 241,037,155 computers have been sold so far this year, and it is increasing at an incredible rate. To put this in some kind of perspective, this is over half the amount of newspapers that have been circulated and more than twice the amount of bikes made. From Babbage to USB, this is the history of the PC. Taking into account that the modern definition of 'computer' refers to something that is programmable, the first primitive design of a programmable machine cold be The Jacquard Loom, invented in 1801. The design incorporated punched paper cards that would determine how the loom would weave. In 1837, Englishman Charles Babbage became the first person to invent a programmable mechanical computer, The Analytic Engine. Although it was never built, he re-modified it's designs until his death in 1871, whilst Ada Lovelace, a mathematician whom is now considered the first computer programmer, even created a program for Babbage's machine. The Z3, designed by German engineer Konrad Kuse was the first programmable automatic computer. Using a design that wasn't too far from that of The Jacquard Loom, the Z3 used a punched film stock to program it. In 1946, designers John Mauchly and J. Presper Eckert announced the arrival of the "Giant Brain", the Electronic Numerical Integrator And Computer. This prime example of the second generation of computers was the first general-purpose electronic computer. The machine took weeks to programme by a team of six women. It was huge and weighed 2 tonnes. The first minicomputer design to achieve any commercial success was the PDP-8 designed by W.A. Clark and C.E. Molnar and released in 1965. It had 4k of memory. But by 1971 Intel released the first microprocessor, the 4004 CPU. This design leap heralded the introduction of the first personal computer, a title that is shared between two machines, the Kenbak-1 and the Datapoint 2200. Throughout the remainder of the 70s and the beginning of the 80s, names such as Apple, Atari and Commodore gradually began to become household names with the latter names utilizing the typical design the primary component of a keyboard, to be connected to a TV screen and the additional tape-deck or cartridge slot. In 1985 Microsoft launched the Windows 1.0 operating system, but it wasn't until the release of version 3.0 in 1990 until this new interface became commercially popular. This coincided with an increase in home computing and the introduction of the CDROM, as well as growing popularity of the laser or ink cartridge computer printers for word processing and desktop publishing. By the late 90s the notion of plug and play technology by way of digital cameras, scanners and flash drives was introduced by the increasingly incorporated USB ports. More expensive PCs began to utilize DVD into the new millennium; whilst LCD monitors have made PCs more integral to home entertainment and WiFi has allowed users to create their own networks and pushed computing even further. PROJECT WORKSHEET iv WEATHER AND CLIMATE Some people prefer to live in places that have the same weather or climate all year long. Others like to live in areas where the weather changes several times a year. Although some people prefer to live in places that have the same climate all year long, other people like to live in areas where the weather changes several times a year. In my opinion, both scenarios have advantages and disadvantages. Doubtless, I would prefer to live in a place with a constant weather rather that a place with different seasons because I consider it is cheaper and makes me feel emotionally better. I reside in Guwahati; the city is popular by both names and is situated in the state of Assam. The climate here is sub tropical and gets very humid. Rainfall in Assam is very heavy and temperature remains quite pleasant throughout the year. The average highest temperature during the months of summer is around 30 'C and in winters the temperature drops to about 10 'C. The best time to visit Guwahati is during the months of November to April. In my opinion, both, living in places that have the same climate all year long, and places in which the weather changes several times a year, have advantages and disadvantages. Because living in a place with same climate all year long can help me save some money and also for the reason that long days filled with outside activities make me feel with energy, I would prefer to live in a place with same weather all year long. Anyway, is it not always possible to see the beautiful colors of the fall and the exiting snow in a vacation trip? PROJECT WORKSHEET i MY SCHOOL The name of my school is Happy Montessori high school. It is situated in a very cool and peaceful area in Basistha Chariali, Guwahati. It is considered to be one of the finest schools in the state, highly acclaimed for its excellent HSLC results. The school building is an impressive structure. It consists of two buildings having about four floors and twenty-five classrooms each. The school has a well-equipped library, a well-established science laboratory and an excellent computer room, all of which are situated in a peaceful area. The Principal’s office and the Staff Room are on the ground floor opposite to the entrance. The school canteen is another important part of the school complex, which provides fully hygienic foods to the students. My school has over 1500 children studying from preparatory to class X and a staff of over 30. Our headmaster is an experienced and a very efficient person. Under his able direction, the school has been obtaining cent percent HSLC results. The teachers are well experienced and well versed in their subjects. The principal celebrations in my school are School Annual Sports Days, Teacher’s Day, Children’s Day, Anniversary Day, etc., which are celebrated in a grand manner. What I like most in my school is the discipline that exists there. The headmaster as well as the teachers are disciplined and men and women of characters. They do not allow any untruly behaviour or any indisciplined activities by students. A lot of emphasis is given to character formation, moral education and acquiring good values of life. Although the school ambient is rather strict and timetable based, yet there is lot of fun and joy in the school. Matches, tournaments, cultural shows, competitions, outings, etc. make my school life lively, interesting and enjoyable. I am proud to be a student of happy Montessori English high school. As I glance back at the bygone school years, my heart swells up with gratitude and thanks giving for the wonderful years that I spent in the school. My school has profoundly shaped and moulded me more than any other factors in my life. RAKESH KR. SHA.