Thursday, January 30, 2014

MS POWERPOINT:
Microsoft PowerPoint is a proprietary commercial presentation programdeveloped by Microsoft. It was officially launched on May 22, 1990, as a part of the Microsoft Office suite, and runs on Microsoft Windows and Apple's Mac OS X operating system.

History[edit]

Originally designed for the Macintosh computer, the initial release was called "Presenter", developed by Dennis Austin[not in citation given] and Thomas Rudkin[not in citation given] of Forethought, Inc.[2] In 1987, it was renamed to "PowerPoint" due to problems with trademarks, the idea for the name coming from Robert Gaskins.[3] In August of the same year, Forethought was bought by Microsoft for $14 million USD ($28.8 million in present-day terms[4]), and became Microsoft's Graphics Business Unit, which continued to develop the software further. PowerPoint was officially launched on May 22, 1990, the same day that Microsoft released Windows 3.0.
PowerPoint introduced many new changes with the release of PowerPoint 97. Prior to PowerPoint 97, presentations were linear, always proceeding from one slide to the next. PowerPoint 97 incorporated the Visual Basic for Applications(VBA) language, underlying all macro generation in Office 97, which allowed users to invoke pre-defined transitions and effects in a non-linear movie-like style without having to learn programming.
PowerPoint 2000 (and the rest of the Office 2000 suite) introduced a clipboard that could hold multiple objects at once. Another change was that the Office Assistant was changed to be less intrusive.[5]
As of 2012, various versions of PowerPoint claim ~95% of the presentation software market share, with installations on at least 1 billion computers. Among presenters world-wide, this program is used at an estimated frequency of 350 times per second.[6]

Operation[edit]

PowerPoint presentations consist of a number of individual pages or "slides". The "slide" analogy is a reference to the slide projector. A better analogy would be the "foils" (or transparencies/plastic sheets) that are shown with an overhead projector, although they are in decline now. Slides may contain text, graphics, sound, movies, and other objects, which may be arranged freely. 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:
  1. Entrance, emphasis, and exit of elements on a slide itself are controlled by what PowerPoint calls Custom Animations.
  2. Transitions, on the other hand, are movements between slides. These can be animated in a variety of ways.
  3. Custom animation can be used to create small story boards by animating pictures to enter, exit or move.
PowerPoint provides numerous features that offer flexibility and the ability to create a professional presentation. One of the features provides the ability to create a presentation that includes music which plays throughout the entire presentation or sound effects for particular slides. In addition to the ability to add sound files, the presentation can be designed to run, like a movie, on its own. PowerPoint allows the user to record the slide show with narration and a laser pointer. The user may customize slide shows to show the slides in a different order than originally designed and to have slides appear multiple times. Microsoft also offers the ability to broadcast the presentation to specific users via a link and Windows Live.

Saturday, January 25, 2014

Identification:
_______________1.  A programmable machine :
_______________2.  Where all of the components are stored.
_______________3.   It is basically the brain of your computer.
_______________4.  Memory that attaches to the motherboard. A hardware used to temporarily store and access data.
_______________5. The most important component in a computer system.
_______________6.  sends power to all of the other hardware so they can operate.
_______________7.  used for permanently storing files and programs.
_______________8.  can be a floppy drive, CD drive, DVD drive or other possible file storage devices that are used in a computer.
_______________9.  The part of a computer that allows you to see what the computer is processing.
_______________10. allows a computer user to enter text commands into a computer system.
_______________11. allows a computer user to use a point and click interface to enter commands.
_______________12. the part of a computer system that converts binary code from the CPU so you can view it on a monitor.
_______________13. Two ways of connecting a keyboard to a system unit 
_______________14. The application or window at the front (foreground) on the monitor.
_______________15  a program in which you do your work.
_______________16. on the right side of the screen header. Lists running applications.
_______________17. to start up a computer.
_______________18.  a programming error that causes a program to behave in an unexpected way.
_______________19. information processed by a computer.
_______________20. a file you create, as opposed to the application which created it.
_______________21. A connection socket or jack
_______________22. A protocol for fast communication and file transfer across a network.
_______________23. A large capacity storage device made of multiple disks housed in a rigid case.
_______________24. An electronic subdirectory which contain files.
_______________25. A gigabyte =    ? megabytes.

Write the shortcuts keys:
1.    Save
2.    Print
3.    Shutdown
4.    Copy
5.    Paste
6.    Undo
7.    Bold
8.    Open file
9.    Delete
10.  Upper case (Capital)
Enumerations:
1.    List down at least 10 basic components  of a computer.
2.    What are the 4 functions of a computer?
3.    Give at least 5 internal parts of a computer.
4.    What are the applications of computers? At least 6.
5.    List 10  key types  in a keyboard.

ESSAY: WRITE THE SUMMARY OF  INFORMATION & COMMUNICATION TECHNOLOGIES IN TEACHER EDUCATION

Saturday, January 18, 2014

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3as the industry standard for spreadsheets. Excel forms part of Microsoft Office.

Early History[edit]

Microsoft originally marketed a spreadsheet program called Multiplan in 1982. Multiplan became very popular on CP/M systems, but on MS-DOS systems it lost popularity to Lotus 1-2-3. Microsoft released the first version of Excel for the Macintosh on September 30, 1985, and the first Windows version was 2.05 (to synchronize with the Macintosh version 2.2) in November 1987.[61] Lotus was slow to bring 1-2-3 to Windows and by 1988 Excel had started to outsell 1-2-3 and helped Microsoft achieve the position of leading PC software developer. This accomplishment, dethroning the king of the software world, solidified Microsoft as a valid competitor and showed its future of developing GUI software. Microsoft pushed its advantage with regular new releases, every two years or so.

Microsoft Windows[edit]

Excel 1.0 was not released for Windows or MS-DOS. As a result, Excel 2.0 for Windows is the first version of Excel for Intel platform.

Excel 2.0 for Windows (1987)[edit]

The first Windows version was labeled "2" to correspond to the Mac version. This included a run-time version of Windows. [62]

Excel 3.0 (1990)[edit]

Included toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features. [63]

Excel 4.0 (1992)[edit]

Introduced auto-fill.[64]
Also, an easter egg in Excel 4.0 reveals a hidden animation of a dancing set of numbers 1 through 3, representing Lotus 1-2-3, which was then crushed by an Excel logo.[65]

Excel 5.0 (1993)[edit]

With version 5.0, Excel has included Visual Basic for Applications (VBA), a programming language based on Visual Basic which adds the ability to automate tasks in Excel and to provide user-defined functions (UDF) for use in worksheets. VBA is a powerful addition to the application and includes a fully featured integrated development environment (IDE). Macro recording can produce VBA code replicating user actions, thus allowing simple automation of regular tasks. VBA allows the creation of forms and in‑worksheet controls to communicate with the user. The language supports use (but not creation) of ActiveX (COMDLL's; later versions add support for class modules allowing the use of basic object-oriented programming techniques.
The automation functionality provided by VBA made Excel a target for macro viruses. This caused serious problems until antivirus products began to detect these viruses. Microsoft belatedly took steps to prevent the misuse by adding the ability to disable macros completely, to enable macros when opening a workbook or to trust all macros signed using a trusted certificate.
Versions 5.0 to 9.0 of Excel contain various Easter eggs, including a "Hall of Tortured Souls", although since version 10 Microsoft has taken measures to eliminate such undocumented features from their products.[66]

Excel 95 (v7.0)[edit]

Microsoft Excel 95
Released in 1995 with Microsoft Office for Windows 95, this is the first major version after Excel 5.0, as there is no Excel 6.0.
Internal rewrite to 32-bits. Almost no external changes, but faster and more stable.

Excel 97 (v8.0)[edit]

Included in Office 97 (for x86 and Alpha). This was a major upgrade that introduced the paper clip office assistant and featured standard VBA used instead of internal Excel Basic. It introduced the now-removed Natural Language labels.
This version of Excel includes a flight simulator as an Easter Egg.

Excel 2000 (v9.0)[edit]

Included in Office 2000. This was a minor upgrade, but introduced the upgrade to the clipboard where it can hold multiple objects at once. The Office Assistant, whose frequent unsolicited appearance in Excel 97 had annoyed many users, became less intrusive.

Excel 2002 (v10.0)[edit]

Included in Office XP. Very minor enhancements.

Excel 2003 (v11.0)[edit]

Included in Office 2003. Minor enhancements, most significant being the new Tables.

Excel 2007 (v12.0)[edit]

Microsoft Excel 2007
Included in Office 2007. This release was a major upgrade from the previous version. Similar to other updated Office products, Excel in 2007 used the new Ribbon menu system. This was different from what users were used to, but the number of mouse-clicks needed to reach a given functionality were generally fewer (e.g., removing gridlines only required two mouse-clicks instead of five). However, most business users agreed that the replacement of the straightforward menu system with the more convoluted ribbon dramatically reduced productivity.[67]
Added functionality included the SmartArt set of editable business diagrams. Also added was an improved management of named variables through the Name Manager, and much improved flexibility in formatting graphs, which allow (x, y) coordinate labeling and lines of arbitrary weight. Several improvements to pivot tables were introduced.
Also like other office products, the Office Open XML file formats were introduced, including .xlsm for a workbook with macros and .xlsxfor a workbook without macros.[68]
Specifically, many of the size limitations of previous versions were greatly increased. To illustrate, the number of rows was now 1,048,576 (220) and columns was 16,384 (214; the far-right column is XFD). This changes what is a valid A1 reference versus a named range. This version made more extensive use of multiple cores for the calculation of spreadsheets; however, VBA macros are not handled in parallel and XLL add‑ins were only executed in parallel if they were thread-safe and this was indicated at registration.

Excel 2010 (v14.0)[edit]

Microsoft Excel 2010 running on Windows 7
Included in Office 2010, this is the next major version after v12.0, as version number 13 was skipped.
Minor enhancements and 64-bit support,[69] including the following:
  • Multi-threading recalculation (MTR) for commonly used functions
  • Improved pivot tables
  • More conditional formatting options
  • Additional image editing capabilities
  • In-cell charts called sparklines
  • Ability to preview before pasting
  • Office 2010 backstage feature for document-related tasks
  • Ability to customize the Ribbon
  • Many new formulas, most highly specialized to improve accuracy[70]

Excel 2013 (v15.0)[edit]

Included in Office 2013, along with a lot of new tools included in this release:
  • Improved Multi-threading and Memory Contention
  • FlashFill[71]
  • PowerView
  • PowerPivot[72]
  • Timeline Slicer[73]
  • Windows App
  • Inquire[74]
  • 50 new functions[75]

Formulas are what helped make spreadsheets so popular. By creating formulas, you can have instantaneous calculations whenever changing any information in cells the formula is looking at.

The basics

  • All spreadsheet formulas begin with =
  • After the equal symbol either the cell or formula function is entered. The function tells the spreadsheet what kind of formula it's dealing with.
  • If a function is being performed the math formula or cells being dealt with are surrounded in parentheses.
  • Using the colon (:) will allow you to get a range of cells for a formula.

Formula examples

Note: The functions listed below may not be the same in all languages of Microsoft Excel. All these examples are done in the English version of Microsoft Excel.
=
= will create a cell equal to another. For example, if you were to put =A1 in B1 what ever was in A1 would automatically be put in B1. You could also create a formula that would make one cell equal to more than one value. For example, if you have a first name in cell A1 and a last name in cell B1, you could put in cell A2 =A1&" "&B1 which would put cell A1 in with B1 with a space between.
=AVERAGE(X:X)
Display the average amount between cells. For example, if you wanted to get the average for cells A1 to A30, you would type: =AVERAGE(A1:A30)
=COUNTIF(X:X,"*")
Count the cells that have a certain value. For example, if you had =COUNTIF(A1:A10,"TEST") put in cell A11 then anywhere between A1 through A10 that has the word test would be counted as 1, so if you had 5 cells that had the word test A11 would say 5.
=IF(*)
The syntax of the IF statement are =IF(CELL="VALUE" ,"PRINT OR DO THIS","ELSE PRINT OR DO THIS"). So a good example of the syntax would be =IF(A1="","BLANK","NOT BLANK"), this would make any cell besides cell A1 say "BLANK" if a1 had nothing within it, and "NOT BLANK" if any information was within it. The if statement can, of course, become a lot more complicated but can be reduced if following the above structure.
=MEDIAN(A1:A7)
Find the median of the values of cells A1 through A7. For example, four is the median for 1, 2, 3, 4, 5, 6, 7.
=MIN/MAX(X:X)
Min and Max represent the minimum or maximum amount in the cells. For example, if you wanted to get the minimum value between cells A1 and A30 you would put =MIN(A1:A30) or if you wanted to get the Maximum about =MAX(A1:A30).
=Product(X:X)
Multiples multiple cells together. For example =Product(A1:A30) would multiple all cells together, so A1 * A2 * A3, etc.
=SUM(X:X)
The most commonly used function to add, subtract, multiple, or divide values in cells. Below are some examples.
=SUM(A1+A2)
Add the cells A1 and A2.
=SUM(A1:A5)
Add cells A1 through A5.
=SUM(A1,A2,A5)
Adds cells A1, A2, and A5.
=SUM(A2-A1)
Subtract cell A2 from A1.
=SUM(A1*A2)
Multiply cells A1 and A2.
=SUM(A1/A2)
Divide cells A1 and A2.
=SUMIF(X:X,"*"X:X)
Perform the SUM function only if there is a specified value in the first selected cells. An example of this would be =SUMIF(A1:A6,"TEST",B1:B6) which only adds the values B1:B6 if the word "test" was put somewhere in between A1:A6. So if you put TEST (not case sensitive) in A1, but had numbers in B1 through B6, it would only add the value in B1 because TEST is in A1.
=TODAY()
Would print out the current date in the cell entered. This value will change to reflect the current date each time you open your spreadsheet. If you want to enter a date that doesn't change hold down CTRL and ; to enter the date.
=TREND(X:X)
To find the common value of cell. For example, if cells A1 through A6 had 2,4,6,8,10,12 and you entered formula =TREND(A1:A6) in a different cell, you would get the value of 2 because each number is going up by 2.
=VLOOKUP(X,X:X,X,X)
The lookup, hlookup, or vlookup formula allows you to search and find related values for returned results. See our lookup definition for a complete definition and full details on this formula.


Microsoft Word is a word processor developed by Microsoft. It was first released in 1983 under the name Multi-Tool Word for Xenix systems.[3][4][5]Subsequent versions were later written for several other platforms includingIBM PCs running DOS (1983), the Apple Macintosh running Mac OS (1985), the AT&T Unix PC (1985), Atari ST (1988), SCO UNIX (1994), OS/2 (1989), and Windows (1989). Commercial versions of Word are licensed as a standalone product or as a component of Microsoft OfficeWindows RT or the discontinued Microsoft Works Suite. Freeware editions of Word are Microsoft Word Viewer and Word Web App on SkyDrive, both of which have limited features.

Microsoft Word's native file formats are denoted either by a .doc or .docx file extension.
Although the .doc extension has been used in many different versions of Word, it actually encompasses four distinct file formats:
  1. Word for DOS
  2. Word for Windows 1 and 2; Word 4 and 5 for Mac OS
  3. Word 6 and Word 95 for Windows; Word 6 for Mac OS
  4. Word 97 and later for Windows; Word 98 and later for Mac OS
The newer .docx extension signifies the Office Open XML international standard for Office documents and is used by Word 2007, 2010 and 2013 for Windows, Word 2008 and 2011 for Mac OSX, as well as by a growing number of applications from other vendors, including OpenOffice.org Writer, an open source word processing program.[39]
Microsoft Word for Windows release history
Year ReleasedNameVersionComments
1989Word for Windows 1.0
1990Word for Windows 1.11.1Code-named Bill the Cat
1990Word for Windows 1.1a1.1aFor Windows 3.1
1991Word for Windows 2.02.0Code-named Spaceman Spiff
1993Word for Windows 6.06.0Code-named T3 (renumbered 6 to bring Windows version numbering in line with that of DOS version, Mac OS version and also WordPerfect, the main competing word processor at the time; also a 32-bit version for Windows NT only)
1995Word 957.0Included in Office 95
1997Word 978.0Included in Office 97
1998Word 988.5Only sold as part of Office 97 Powered By Word 98, which was only available in Japan and Korea.
1999Word 20009.0Included in Office 2000
2001Word 200210.0Included in Office XP
2003Office Word 200311.0Included in Office 2003
2006Office Word 200712.0Included in Office 2007; released to businesses on November 30, 2006, released worldwide to consumers on January 30, 2007
2010Word 201014.0Included in Office 2010
2013Word 201315.0Included in Office 2013
ShortcutDescription
Ctrl + 0Adds or removes 6pts of spacing before a paragraph.
Ctrl + ASelect all contents of the page.
Ctrl + BBold highlighted selection.
Ctrl + CCopy selected text.
Ctrl + DOpen the font preferences window.
Ctrl + EAligns the line or selected text to the center of the screen.
Ctrl + FOpen find box.
Ctrl + IItalic highlighted selection.
Ctrl + JAligns the selected text or line to justify the screen.
Ctrl + KInsert link.
Ctrl + LAligns the line or selected text to the left of the screen.
Ctrl + MIndent the paragraph.
Ctrl + POpen the print window.
Ctrl + RAligns the line or selected text to the right of the screen.
Ctrl + TCreate a hanging indent.
Ctrl + UUnderline highlighted selection.
Ctrl + VPaste.
Ctrl + XCut selected text.
Ctrl + YRedo the last action performed.
Ctrl + ZUndo last action.
Ctrl + Shift + LQuickly create a bullet point.
Ctrl + Shift + FChange the font.
Ctrl + Shift + >Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ]Increase selected font +1pts.
Ctrl + Shift + <Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [Decrease selected font -1pts.
Ctrl + / + cInsert a cent sign (¢).
Ctrl + ' + <char>Insert a character with an accent (grave) mark, where <char> is the character you want. For example, if you wanted an accented รจ you would use Ctrl + ' + e as your shortcut key. To reverse the accent mark use the opposite accent mark, often on thetilde key.
Ctrl + Shift + *View or hide non printing characters.
Ctrl + <left arrow>Moves one word to the left.
Ctrl + <right arrow>Moves one word to the right.
Ctrl + <up arrow>Moves to the beginning of the line or paragraph.
Ctrl + <down arrow>Moves to the end of the paragraph.
Ctrl + DelDeletes word to right of cursor.
Ctrl + BackspaceDeletes word to left of cursor.
Ctrl + EndMoves the cursor to the end of the document.
Ctrl + HomeMoves the cursor to the beginning of the document.
Ctrl + SpacebarReset highlighted text to the default font.
Ctrl + 1Single-space lines.
Ctrl + 2Double-space lines.
Ctrl + 51.5-line spacing.
Ctrl + Alt + 1Changes text to heading 1.
Ctrl + Alt + 2Changes text to heading 2.
Ctrl + Alt + 3Changes text to heading 3.
Alt + Ctrl + F2Open new document.
Ctrl + F1Open the Task Pane.
Ctrl + F2Display the print preview.
Ctrl + Shift + >Increases the highlighted text size by one.
Ctrl + Shift + <Decreases the highlighted text size by one.
Ctrl + Shift + F6Opens to another open Microsoft Word document.
Ctrl + Shift + F12Prints the document.
F1Open Help.
F4Repeat the last action performed (Word 2000+)
F5Open the find, replace, and go to window in Microsoft Word.
F7Spellcheck and grammar check selected text or document.
F12Save as.
Shift + F3Change the text in Microsoft Word from uppercase to lowercase or a capital letter at the beginning of every word.
Shift + F7Runs a Thesaurus check on the word highlighted.
Shift + F12Save.
Shift + EnterCreate a soft break instead of a new paragraph.
Shift + InsertPaste.
Shift + Alt + DInsert the current date.
Shift + Alt + TInsert the current time.
In addition to the above shortcut keys users can also use their mouse as a method of quickly do something commonly performed. Below some are examples of mouse shortcuts.
Mouse shortcutsDescription
Click, hold, and dragSelects text from where you click and hold to the point you drag and let go.
Double-clickIf double-click a word, selects the complete word.
Double-clickDouble-clicking on the left, center, or right of a blank line will make the alignment of the text left, center, or right aligned.
Double-clickDouble-clicking anywhere after text on a line will set a tab stop.
Triple-clickSelects the line or paragraph of the text the mouse triple-clicked.
Ctrl + Mouse wheelZooms in and out of document.