Lunes, Enero 14, 2013

Types of Microsoft Office, Version History

The Microsoft Office for Windows

The Microsoft Office for Windows started in October 1990 as a bundle of three applications designed for Microsoft Windows 3.0: Microsoft Word for Windows 1.1, Microsoft Excel for Windows 2.0, and Microsoft PowerPoint for Windows 2.0.

The Microsoft Office for Windows 1.5

The Microsoft Office for Windows 1.5 updated the suite with Microsoft Excel 3.0.

The Microsoft Office for Windows 1.6

The Microsoft Office for Windows 1.6 added Microsoft Mail for PC Networks 2.1 to the bundle.

The Microsoft Office for Windows 3.0

The Microsoft Office for Windows 3.0 also called Microsoft Office 92, was released on August 30, 1992 and contained Word 2.0, Excel 4.0, PowerPoint 3.0 and Mail 3.0. It was the first version of Office also released on CD-ROM. In 1993, The Microsoft Office Professional was released, which added Microsoft Access 1.1.

Microsoft Office 4.0

Microsoft Office 4.0
Microsoft Office 4.0 was released containing Word 6.0, Excel 4.0a, PowerPoint 3.0 and Mail in 1993. Word's version number jumped from 2.0 to 6.0 so that it would have the same version number as the MS-DOS and Macintosh versions (Excel and PowerPoint were already numbered the same as the Macintosh versions).

Microsoft Office 4.2 for Windows NT

Microsoft Office 4.2 for Windows NT was released in 1994 for i386, Alpha, MIPS and PowerPC architectures, containing Word 6.0 and Excel 5.0 (both 32-bit, PowerPoint 4.0 (16-bit), and Microsoft Office Manager 4.2 (the precursor to the Office Shortcut Bar).

Microsoft Office 4.3

Microsoft Office 4.3 was released as the last 16-bit version, containing Word 6.0, Excel 5.0, PowerPoint 4.0. Office 4.3 (plus Access 2.0 in the Pro version) is the last version to support Windows 3.x, Windows NT 3.1 and Windows NT 3.5. Windows NT 3.51 was supported up to and including Office 97.

Microsoft Office 95

Microsoft Office 95 Professional icons
Microsoft Office 95 was released on August 24, 1995. Again, the version numbers were altered to create parity across the suite—every program was called version 7.0 meaning all but Word missed out versions. It was designed as a fully 32-bit version to match Windows 95. Office 95 was available in two versions, Office 95 Standard and Office 95 Professional. The standard version consisted of Word 7.0, Excel 7.0, PowerPoint 7.0, and Schedule+ 7.0. The professional edition contained all of the items in the standard version plus Access 7.0. If the professional version was purchased in CD-ROM form, it also included Bookshelf.

Microsoft Office 97

Microsoft Office 97 Box
Microsoft Office 97 (Office 8.0), was a major milestone release. It included hundreds of new features and improvements, introduced command bars, a paradigm in which menus and toolbars were made more similar in capability and visual design. Office 97 also featured Natural Language Systems and grammar checking. Office 97 was the first version of Office to include the Office Assistant.

Microsoft Office 2000

Microsoft Office 2000 Logo
Microsoft Office 2000 (Office 9.0) introduced adaptive menus, where little-used options were hidden from the user. It also introduced a new security feature, built around digital signatures, to diminish the threat of macro viruses. Office 2000 automatically trusts macros (written in VBA 6) that were digitally signed from authors who have been previously designated as trusted. Office 2000 is the last version to support Windows 95.

Microsoft Office XP

Microsoft Office XP Logo
Microsoft Office XP (Office 10.0 or Office 2002) was released in conjunction with Windows XP, and was a major upgrade with numerous enhancements and changes over Office 2000. Office XP introduced the Safe Mode feature, which allows applications such as Outlook to boot when it might otherwise fail. Safe Mode enables Office to detect and either repair or bypass the source of the problem, such as a corrupted registry or a faulty add-in. Smart tag is a technology introduced with Office XP. Some smart tags operate based on user activity, such as helping with typing errors. These smart tags are supplied with the products, and are not programmable. For developers, though, there is the ability to create custom smart tags. In Office XP, custom smart tags could work only in Word and Excel. Microsoft Office XP includes integrated voice command and text dictation capabilities, as well as handwriting recognition. Office XP is the last version to support Windows 98, ME and NT 4.0. It was the first version to require Product Activation as an anti-piracy measure, which attracted widespread controversy.

Microsoft Office 2003

Microsoft Office Logo for 2003 and 2007
Microsoft Office 2003 (Office 11.0) was released in 2003. It featured a new logo. Two new applications made their debut in Office 2003: Microsoft InfoPath and OneNote. It is the first version to use Windows XP style icons. Outlook 2003 provides improved functionality in many areas, including Kerberos authentication, RPC over HTTP, Cached Exchange Mode, and an improved junk mail filter. 2003 is the last Office version to support Windows 2000.

Microsoft Office 2007

Microsoft Office 2007 (Office 12.0) was released in 2007. Office 2007's new features include a new graphical user interface called the Fluent User Interface, replacing the menus and toolbars that have been the cornerstone of Office since its inception with a tabbed toolbar, known as the Ribbon; new XML-based file formats called Office Open XML; and the inclusion of Groove, a collaborative software application.

Microsoft Office 2010

Microsoft Office Logo for 2010
Microsoft Office 2010 (Office 14.0) was finalized on April 15, 2010, and was made available to consumers on June 15, 2010. The main features of Office 2010 include the backstage file menu, new collaboration tools, a customizable ribbon, protected view and a navigation panel. This is the first version to ship in 32- and 64-bits. Microsoft Office 2010 also features a new logo, which is similar to the 2007 logo, except in gold, and with a slightly modified shape. Service Pack 1 for Office 2010 was released on June 28, 2011.

Microsoft Office 2013

Microsoft Office 2013 Logo
Microsoft Office 2013 (Office 15.0) was made available to consumers on July 16, 2012 as a Customer Preview version.
A Milestone 2 build of Microsoft Office 2013 Build 15.0.2703.1000 (version 15) leaked during May 2011. It sports a revamped application interface; the interface is based on Metro, the interface of Windows Phone and Windows 8. Microsoft Outlook has received the most pronounced changes so far; for example, the Metro interface provides a new visualization for scheduled tasks. PowerPoint will include more templates and transition effects, and OneNote will include a new splash screen. On May 16, 2011, new images of Office 15 were revealed, showing Excel with a tool for filtering data in a timeline, the ability to convert Roman numerals to Arabic numerals, and the integration of advanced trigonometric functions. In Word, the capability of inserting video and audio online as well as the broadcasting of documents on the Web were implemented. Microsoft has promised support for Office Open XML Strict starting with version 15, a format Microsoft has submitted to the ISO for interoperability with other office suites, and to aid adoption in the public sector. This version can read and write ODF 1.2.
As of January 30, 2012, Microsoft has released a technical preview of Office 15 Build 15.0.3612.1010 . A public preview of Office 15 was released on July 16, 2012.
On 24 October 2012, the RTM final code of Office 2013 Professional Plus has been released to TechNet and MSDN subscribers for download.
On 15 November 2012, the 60 days trial version of Office 2013 Professional Plus has been released to everyone for download.[7]

Macintosh versions

Prior to packaging its various office-type Macintosh software applications into Office, Microsoft released Mac versions of Word 1.0 in 1984, the first year of the Macintosh computer; Excel 1.0 in 1985; and PowerPoint 1.0 in 1987. Microsoft does not include its Access database application in Office for Mac.
Microsoft has noted that some features are added to Office for Mac before they appear in Windows versions, such as Office for Mac 2001's Office Project Gallery and PowerPoint Movie feature, which allows users to save presentations as QuickTime movies. However, Microsoft Office for Mac has been long criticized for its lack of support of Unicode and right-to-left languages, notably Persian, Arabic and Hebrew.

The Microsoft Office

The Microsoft Office was introduced for Macintosh in 1989, before Office was released for Windows. It included Word 4.0, Excel 2.2, PowerPoint 2.01, and Mail 1.37. It was originally a limited-time promotion but later became a regular product. With the release of Office on CD-ROM later that year, Microsoft became the first major Mac publisher to put its applications on CD-ROM.

Microsoft Office 1.5 for Mac

Microsoft Office 1.5 for Mac Box
Microsoft Office 1.5 for Mac was released in 1991 and included the updated Excel 3.0, the first application to support Apple’s System 7 operating system.

Microsoft Office 3.0 for Mac

Microsoft Office 3.0 for Mac was released in 1992. It included Word 5.0, Excel 4.0, and PowerPoint 3.0. Excel 4.0 was the first application to support the new AppleScript.

Microsoft Office 4.2 for Mac

Microsoft Office 4.2 for Mac was released in 1994. (Version 4.0 was skipped to synchronize version numbers with Office for Windows.) Version 4.2 included Word 6.0, Excel 5.0, PowerPoint 4.0, and Mail 3.2.[70] It was the first Office suite for the Power Macintosh. Its user interface was identical to Office 4.2 for Windows,[71] leading many customers to comment that it wasn't Mac-like enough.The final release for Mac 68K was Office 4.2.1, which updated Word to version 6.0.1, somewhat improving its performance.

Microsoft Office 98 Macintosh Edition

Microsoft Office 98 Macintosh Edition was unveiled at MacWorld Expo/San Francisco in 1998. It introduced the Internet Explorer 4.0 web browser and Outlook Express, an Internet e-mail client and usenet newsgroup reader. Office 98 was re-engineered by Microsoft's Macintosh Business Unit to satisfy customers' desire for software they felt was more Mac-like.[63] It included drag–and-drop installation, self-repairing applications and Quick Thesaurus, before such features were available in Office for Windows. It also was the first version to support QuickTime movies.

Microsoft Office 2001

Microsoft Office 2001 launched in 2000, was the last Office suite for the classic Mac OS; it required Mac OS 8, although version 8.5 or later was recommended. Office 2001 introduced Entourage, an e-mail client that included information management tools such as a calendar, an address book, task lists and notes.

Microsoft Office v. X

Microsoft Office v. X was released in 2001 for the new Mac OS X platform.

Microsoft Office 2004 for Mac

Microsoft Office 2004 for Mac was released in 2004.

Microsoft Office 2008 for Mac

Microsoft Office 2008 for Mac was released in 2008. It was the first Office for Mac suite that was a universal binary, running natively on both Intel- and PowerPC-based Macs, and it supported Office Open XML file formats first introduced in Office 2007 for Windows. Five months after it was released, Microsoft said that Office 2008 was "selling faster than any previous version of Office for Mac in the past 19 years" and affirmed "its commitment to future products for the Mac."

Microsoft Office for Mac 2011

Microsoft Office for Mac 2011 was released on October 26, 2010, and features a Mac version of Outlook to replace the Entourage email client. This Mac version of Outlook is intended to make the Mac version of Office work better with Microsoft's Exchange server and with those using Office for Windows. Office 2011 includes a Mac-based Ribbon similar to Office for Windows.

source: Wikipedia Free Encyclopedia

What is Standard Nine

Stanine (STAndard NINE) is a method of scaling test scores on a nine-point standard scale with a mean of five and a standard deviation of two.
Some web sources attribute stanines to the U.S Army Air Forces during World War II. Psychometric legend has it that a 0-9 scale was used because of the compactness of recording the score as a single digit but Thorndike claims that by reducing scores to just nine values, stanines "reduce the tendancy to try to interpret small score differences". The earliest known use of stanines was by the U.S. Army Air Forces in 1943.


Test scores are scaled to stanine scores using the following algorithm:
  1. Rank results from lowest to highest
  2. Give the lowest 4% a stanine of 1, the next 7% a stanine of 2, etc., according to the following table:
Calculating Stanines
Result Ranking 4% 7% 12% 17% 20% 17% 12% 7% 4%
Stanine 1 2 3 4 5 6 7 8 9
Standard score below -1.75 -1.75 to -1.25 -1.25 to -.75 -.75 to -.25 -.25 to +.25 +.25 to +.75 +.75 to +1.25 +1.25 to +1.75 above +1.75


The underlying basis for obtaining stanines is that a normal distribution is divided into nine intervals, each of which has a width of 0.5 standard deviations excluding the first and last, which are just the remainder (the tails of the distribution). The mean lies at the centre of the fifth interval.
Stanines can be used to convert any test score into a single digit number. This was valuable when paper punch cards were the standard method of storing this kind of information. However, because all stanines are integers, two scores in a single stanine are sometimes further apart than two scores in adjacent stanines. This reduces their value.
Today stanines are mostly used in educational assessment. The University of Alberta in Edmonton, Canada used the stanine system until 2003, when it switched to a 4-point scale . In the United States, the Educational Records Bureau (they administer the "ERBs") reports test scores as stanines and percentiles.

source: Wikipedia Free Encyclopedia

Don't Ever Forget What Microsoft Office Is!






Microsoft Office is an office suit of desktop applications, servers and services for the Microsoft Windows and Mac OS X operating systems, introduced by Microsoft on 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 Application scripting language. Microsoft also positions Office as a development platform for line-of-business software under the Office Business Applications brand. Office is reported to now be used by over a billion people worldwide.
The current versions are Office 2013 for Windows, released on October 11, 2012; and Office 2011 for Mac OS X, released October 26, 2010. On 24 October 2012, the RTM final code of Office 2013 Professional Plus has been released to TechNet and MSDN subscribers for download. On 15 November 2012, the 60-day trial of Office 2013 Professional Plus was released for download.


Source: Wikipedia Free Encyclopedia

Sabado, Enero 12, 2013

IF Function and Formulas

Whoa! That was an amazing lesson! but i was really confused with that veeeeeerryyy looooooonnnnngggg Formula to get that Average and Remarks without typing it many times in each cell.

Functions of AND, OR and NOT help to make shortcuts on doing the activity given to us.

In Microsoft Excel, the AND function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.

Example:
Based on the Excel spreadsheet above, the AND function would return the following:
=AND(A1>10, A1<40) would return TRUE
=AND(A1=30, A2="www.checkyourmath.com") would return FALSE
=AND(A1>=5, A1<=30, A2="www.techonthenet.com") would return TRUE


In Microsoft Excel, the NOT function returns the reversed logical value.

Example:

Based on the Excel spreadsheet above, the NOT function would return the following:
=NOT(A2="techonthenet.com") would return FALSE
=NOT(TRUE) would return FALSE
=NOT(FALSE) would return TRUE
=NOT(A1<10) would return FALSE
=NOT(A2="Microsoft") would return TRUE
=NOT(5+1=7) would return TRUE

In Microsoft Excel, the OR function returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE.

Based on the Excel spreadsheet above, the OR function would return the following:
=OR(A1<10, A1=40) would return FALSE
=OR(A1=30, A2="Microsoft") would return TRUE
=OR(A1>=5, A1=20, A2="techonthenet.com") would return TRUE

source: www.techonthenet.com


Ahh.. I took a lot of time to finish that Class Record of Mine (activity). But, with the help of the IF, it makes changes a lot easier than the others. But still, i should find out the formula in getting the STANINE of class records.


Sabado, Enero 5, 2013

References

There are 3 references in an MS Excel, he Relative, Absolute, and Mixed. I easily understand the three of these because its not as hard as the others.

Relative Reference which is the most common type of referencing a cell which a cell is called by row and column level such as A1 that means column A and row 1. These is the easiest part of a reference.

If you place dollar sign ($) in front of cell reference, cell reference will not be changed during copy, is called Absolute Reference.

Mixed Referencing is the mix of relative and absolute referencing.

That's what I learned during the discussion. Thanks

Biyernes, Enero 4, 2013

Formulas and Functions

There are lots of Formulas and functions in excel, formulas that help make a work easy and function that will help you know what does it do.

Formulas and Functions help us know that:

- there are tutorials and how to create formulas
- test to set whether the given condition is true or false
- helps find specific information in large data tables
- carry out basic math information
- logical functions can be combined with IF function or individually
- excels listed as functions include the common thing function use to find
- help you determine changes in dollar or money values

I know that the information stated is not enough but that is all I can share to you. Thanks! Hope u like this!

The Excel Parts

I listed a lot of parts of an Excel during the lesson but I wasn't able to catch up and write the meaning of those parts. There are about 13 parts listed on my notebook. I just understand a few of them, their function as a part of an Excel.

Active cells are those box or boxes which was or were selected that serves as a text box. Anything could be written in it even formulas for shortcuts. Formula Bar is I think the bar at the top which u can see the formula behind the text. Row numbers, Name Box and a lot of more that i couldn't explain all of it. (sorry)

I can't think of what to say about it so I'm sorry if this is all i could say for now.

Here it Comes! MS Office Excel Interface!

The most interesting lesson I've ever experience in Computer Science 1 is MS Office Excel!

MS Excel is the same as MS word but MS Excel is used to make graphs for their businesses, computing grades easily, population growth computation and many more. But Excel has many formulas to be memorize of just familiarize.

If MS word  is for documents, Excel is used for banking or ease computing. And, Excel has different parts than MS word. They have many functions but i can't enumerate all. I don't have enough information about excel.

That's all i can share to you. Thank you. 

Technical Paper

hmm... What's on your mind when you heard about technical paper?

According to our teacher, technical paper is a brief to-the-point document which describes a body of a technical word.

We tried to do a technical paper in our school but i took much time on making it. Even though there are instructions to be followed, I wasn't able to finish it on one period. Even the parts of technical paper, I wasn't able to understand all.

I wil review them for achievement test. I'll try to understand all.

Microsoft Office Word Interface

MS word is a very familiar and commonly used to make documents easily. MS word's interface contains a lot of parts which is needed to know of one's person so that they wouldn't have any problem while using the MS Word.

Among the Microsoft Office Interface, Microsoft Office Word is the most capable in making important documents. They always use Microsoft Office word in offices, businesses and even in school.

But did you know that Microsoft Office Word has versions? The first Version of Microsoft word is Microsoft Office Word 2003, followed by 2007 and 2010. Even though 2010 is the latest version of MS word, they still prefer to use 2007. I just don't know the reason why they use 2007 but I'm using MS Word 2007, too. Maybe because its much easier to use than MS Word 2010.

But, whatever version is it, we should know what is its importance and we should be thankful that it was created because our works were made easily with the help of MS Office.