MICROSOFT OFFICE

Microsoft Office is a non-free commercial office suite of inter-related desktop applications, servers and services for the Microsoft Windowsand Mac OS X operating systems, introduced by Microsoft in August 1, 1989. Initially a marketing term for a bundled set of applications, the first version of Office contained Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. 










Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, OLE data integration and Microsoft Visual Basic for Applicationsscripting language. Microsoft also positions Office as a development platform for line-of-business software under the Office Business Applications brand.

WORD PROCESSING (MS WORD)

IMPORTANT FEATURES OF MS-WORD

Ms-Word not only supports word processing features but also DTP features. Some of the important features of Ms-Word are listed below:

Ø  Using word you can create the document and edit them later, as and when required, by adding more text, modifying the existing text, deleting/moving some part of it.

Ø  Changing the size of the margins can reformat complete document or part of text.

Ø  Font size and type of fonts can also be changed. Page numbers and Header and Footer can be included.

Ø  Spelling can be checked and correction can be made automatically in the entire document. Word count and other statistics can be generated.

Ø  Text can be formatted in columnar style as we see in the newspaper. Text boxes can be made.

Ø  Tables can be made and included in the text.

Ø  Word also allows the user to mix the graphical pictures with the text. Graphical pictures can either be created in word itself or can be imported from outside like from Clip Art Gallery.

Ø  Word also provides the mail-merge facility.

Ø  Word also has the facility of macros. Macros can be either attached to some function/special keys or to a tool bar or to a menu.

Ø  It also provides online help of any option.

ELECTRONIC SLIDESHOW PRESENTATION (MS POWERPOINT)

PowerPoint presentations consist of a number of individual pages or "slides". The "slide" analogy is a reference to the slide projector. Slides may contain text, graphics, sound, movies, and other objects, which may be arranged freely. PowerPoint, however, facilitates the use of a consistent style in a presentation using a template or "Slide Master".

The presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. For larger audiences the computer display is often projected using a video projector. Slides can also form the basis of webcasts.

PowerPoint provides three types of movements:

Ø  Entrance, emphasis, and exit of elements on a slide itself are controlled by what PowerPoint calls Custom Animations

Ø  Transitions, on the other hand, are movements between slides. These can be animated in a variety of ways

Ø  Custom animation can be used to create small story boards by animating pictures to enter, exit or move.

NUMERICAL CALCULATION AND COMPUTATION (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 you see a rectangular table or grid of rows and columns. 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.

            It is very suitable for the students and also in learning this software is not that difficult, the students could learn easily. We chose this excel because has a lot of advantages such as:

Data Types, Formulas, and Functions

The types of data that a cell can hold include numbers, text or formulas. Just as in math class, formulas are used for calculations usually involving data contained in other cells. Excel and other electronic spreadsheets include a number of built in formulas used for common tasks known as functions.

Excel and Financial Data

Spreadsheets are often used to store financial data. Formulas and functions that are used on this type of data include:

Ø  Performing basic mathematical operations such as summing columns and rows of figures.

Ø  Finding values such as profit or loss.

Ø  Calculating repayment plans for loans or mortgages.

Ø  Finding the average, maximum, or minimum values in a specified range of data.

Excel's Other Uses

Other common operations that Excel can be used for include:

Ø  graphing or charting data to assist users in identifying data trends.

Ø  sorting and filtering data to find specific information.

The information garnered in a spreadsheet can easily be incorporated into electronic presentations, web pages, or printed off in report form.

                                            THE INTERNET

Internet Definition

-The Internet, sometimes called simply "the Net," is a worldwide system of computer networks - a network of networks in which users at any one computer can, if they have permission, get information from any other computer (and sometimes talk directly to users at other computers). 

-A means of connecting a computer to any other computer anywhere in the world via dedicated routers and servers. When two computers are connected over the Internet, they can send and received all kinds of information such as test, graphics, voice, video, and computer programs. 

history of the internet

-1957 – 1978 – The advanced Research Projects Agency (ARPA) was created as a direct response to the launch of the Sputnik by the Soviet Union. 

-1964 – RAND Corporation publishes a  report describing a network that divided messages into segments, travelling independency.

-1967 – Donald Davies coined this process “packet-switching”

1969 – ARPANET facilities the first packet-switching between UCLA and SRI International. 

1972 – Email program is written by Ray Tomlison and the @ symbol is introduced

1973 – 75% of all network traffic is E-mail.

1978 – The first Bulletin Board System was created.

1979 – BBS went online to the public, allowing people to use a virtual notice board, exchanging ideas and information.

1984 – The development of Doman Name Services is implemented in order for people to easily identify and locate computers linked to the internet.

1990 – Tim Berners-Lee coined the term “World Wide Web”

1993 – Mosaic was released the first commercial software that allowed graphic access to content on the internet.

The first Internet Web Browser

1996 – Approximately 45 million people using the internet

1999 – 150 million users

2000 – 407 million users

2004 – Between 600 – 800 million

2007 – 1.3 billion people connected to the internet world wide

2011 - more than 2 billion people connected to the internet world wide.

The World Wide Web is deeply ingrained in our culture and everyday lives.

-Source of news, facts and figures.

-Communication tool

-Banking

-Shopping

-An Educational and Entertainment medium.

How the internet works?

1. Transport control Protocol (TCP)

• a protocol that operates at the transport layer and is used in combination with IP by most Internet applications.

2. Backbone

• an internet high-speed, long distance communications links (like a bus; wire that connects nodes)

3. Uniform resource locator (URL)

• an assigned address on th Internet for each computer
• E.g., http://www.yorku.ca/

How to access the Internet?

• Many schools and businesses have direct access to the Internet using special high-speed communication lines and equipment.

• Students and employees can access through the organization's local area networks (LAN) or through their own personal computers.

• another way to access the Internet is through Internet Service Provider (ISP)

• To access the Internet, an existing network need to pay a small registration fee and agree to certain standards based on the TCP/IP (Transmission Control Protocol/Internet Protocol) reference model.

• Each organization pays for its own networks and its own telephone

• The regional Internet companies route and forward all traffic, and the cost is still only that of a local telephone call.

Internet Connection

1. LAN servers

• Local servers can provide access to the Internet through normal connection (e.g., Ethernet)

2. Serial line internet protocol (SLIP) and Point-to-point protocol (PPP)

• Communications protocol software that transmits packets over telephone lines, allowing dial-up access to the Internet

3. Connection via an on-line service provider (ISP)

• Examples are America Online and Microsoft Network. These services usually require sign-up procedures.

Internet Service Provider

What/Who is the Internet service provider (ISP)?

• any company that provides individuals or companies with access to the Internet
• thousands of providers including large communications companies 
• Need an account with the ISP and softwares that links with TCP/IP
• A commercial organization with permanent connection to the Internet that tells temporary connections to subscribers.
• 
  
• Examples:

1. maxis net, Celcom, Jaring
2. America Online
3. Microsoft network
4. AT&T networks etc. 

>