150 likes | 272 Views
Technology Today. A Professional Development Program. By : Praveen, IT Consultant . Modules. MS-Publisher.
E N D
Technology Today A Professional Development Program By : Praveen, IT Consultant Singapore International School - Indonesia
Modules Singapore International School - Indonesia
MS-Publisher Microsoft Publisher 2007 helps you create, personalize and share a wide range of professional-quality publications and marketing materials. With Publisher 2007, you can easily communicate your message in a variety of publication types, saving you time and money. Whether you’re creating brochures, newsletters, postcards, greeting cards or e-mail newsletters, you can deliver quality results without needing graphic design experience. Get the job done right the first time with Publisher 2007. The file extension of the MS-Publisher is .PUB Singapore International School - Indonesia
MS-Publisher • Task 1 : Create a brochure for the Math, IT & Science Day • Steps to create a brochure: • 1.Start , Click on MS-Office and Select MS-Publisher • 2.Choose the Brochure and select the Template • 3.To change the background click Format Menu and choose Background • 4. Add pictures, Logo, Text and save it Singapore International School - Indonesia
MS-Excel • Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data. • When you look at the Excel screen (refer to the example on this page) you see a rectangular table or grid of rows and columns. The horizontal rows are identified by numbers (1,2,3) and the vertical columns with letters of the alphabet (A,B,C). For columns beyond 26, columns are identified by two or more letters such as AA, AB, AC. • The intersection point between a column and a row is a small rectangular box known as a cell. A cell is the basic unit for storing data in the spreadsheet. Because an Excel spreadsheet contains thousands of these cells, each is given a cell reference or address to identify it. • The cell reference is a combination of the column letter and the row number such as A3, B6, AA345. • The file extension of the MS-Excel is .XLS Singapore International School - Indonesia
MS-Excel • Task 1 : Create a Spreadsheet for the student grading using formulas • Steps to create a spreadsheet: • 1.Start , Click on MS-Office and Select MS-Excel • 2. Use the field names : Sno, Sname, Sub1, Sub2, Sub3, Total, Avg, Grade • 3. Use Formulas to calculate Total, Avg, Grade • 4. Use “IF” condition for calculating Grade • 5. Insert a 3D Barograph chart. • 6. Use options Merge, Center, Wrap, Auto Sum • 7. Use functions Sort, filter, Increase decimal, decrease decimal • Try using functions : Sum, Max, Min, Round, Average Singapore International School - Indonesia
MS-Word • Microsoft Office Word is a non-free commercial word processor designed by Microsoft. It is part of the Microsoft Office Suite. Microsoft Word is currently the most common word processor on the market. And the file .doc/.docx format has become one of the popular format for text documents. • What is Microsoft Word used for: • MS Word is a popular word-processing program used primarily for creating documents such as letters, brochures, learning activities, tests, quizzes and students' homework assignments. There are many simple but useful features available in Microsoft Word to make it easier for study and work. Singapore International School - Indonesia
MS-Word • Task 1 : Create a document for IDP using the options given below • Cover Page • Shapes, smart Art • Header, Footer, Page Number • Text Box, 3D • Margins, Orientation, Columns • Page Color, • Water Mark • Page Border • Short Cuts Singapore International School - Indonesia
MS-Outlook Microsoft Outlook is used for emails and also personal management of information, and is generally part of the Office suite of applications, although it can be purchased separately as a single application. Whilst Outlook is mostly used for storing, receiving and sending emails, it is called a personal information management tool because it also includes calendar, tasks, contacts and notes as well as a journal. Often in larger organisations, Outlook is used on a server for example an exchange server so that the software can enable multiple users. With additional software, Outlook can also be integrated with mobile devices such as Blackberry phones. When using Outlook for emails, it has the usual features associated with email applications such as Inbox, Outbox, Drafts and Deleted Items. The Calendar element of outlook can be used to keep appointments and plan meetings and can synchronise with other Outlook user’s calendar. The calendar can be useful for tracking events and important dates, particularly when used with sound alerts and alarms. Tasks are also useful for remembering things you need to do with the ability to set an audible alarm. The Contacts element of Outlook can store address, email and contact details of your friends and family. Messages can also be sent directly from the contact list. Singapore International School - Indonesia
MS-Outlook • Microsoft Outlook is an e-mail client and personal information manager (PIM) that's available as part of Microsoft's Office suite. Many corporations utilize Microsoft Outlook in conjunction with Microsoft Exchange Server and Microsoft SharePoint Server for employees to coordinate meetings, calendars and shared mailboxes and folders. • A version of Microsoft Outlook for Windows Mobile devices, Outlook Mobile, enables users to synchronize their Outlook data to their smartphones. Additionally, numerous Outlook add-ons are available for integrating Microsoft Outlook with BlackBerry and other mobile smartphone devices. Singapore International School - Indonesia
MS-Outlook • Task 1 : Installing MS-Outlook • Task 2 : Configuring school E-mail to MS-Outlook Singapore International School - Indonesia
Blog • What is a Blog? • Why do we need a Blog? • Start creating a Personal blog. • Creating G-mail ID. • Sign-Up as a Blogger ( 1.Create Account ). • Create your Blog now ( 2.Name your Blog ). • Designing Blog ( 3.Choose a Template ). • Start Blogging. Singapore International School - Indonesia
Website • What is a Website? • Why do we need a Website? • What is a free website? • How to design a Website? • What is Difference between Web Designing • and Web Development ? • What is a Search Engine? • Start Creating a Small Web Program. Singapore International School - Indonesia
Any Queries ??? Singapore International School - Indonesia
Thank U Singapore International School - Indonesia