Saturday, March 8, 2014

10 Q&A over ICDL

Q1. Modify the heading materials into change item?
Erase the text. (Modify means change)

Q2. To move something from a place to place?
Cut and Paste

Q3. Sort.
Alphabetically (A to Z or Z to A)

Q4. How to close the file?
Close the small (x) in Microsoft Excel not the big red X which closes the whole system.

Q5. Adjust
Mean to change the size.

Q6. What does : mean and does / mean?
: means from a number to a number (select) (example: 25:27)
/ Means you pick 2 numbers (example: 26/78)

Q7. What does every formula start with?
Every formula starts with =if(___-__-__)

Q8. How to minus?
By typing - (example 23-56)

Q9.How to freeze a cell?
Select on the cell, go to View, click on "Freeze ..."

Q10. How to use Counta Function?
Type =counta(__-__-__)

What is ICDL Exam?

Why ICDL?

ICDL programmes are for anyone who wishes to become fully competent in the use of a computer and common applications. Computer skills enable people of all ages to understand and use technology to improve their personal and professional lives. ICDL modules provide a practical programme of up-to-date skills and knowledge areas which are validated by a test.

See how ICDL can match your specific needs below:

ICDL for Individuals

The ability to use a computer effectively is an essential life skill. Computer skills enable people of all ages to understand and use technology to improve their personal and professional lives. A computer skills certification can help the holder’s professional life by making them more attractive to employers, while increasing their ability to communicate and access information and services in their personal life.

ICDL for Employers

Skilled employees enable organisations to use technology more effectively, leading to increases in productivity and competitiveness and ensuring that operational objectives are achieved more efficiently. ICDL certification programmes are used to increase the value of human capital and achieve productivity gains through developing competent employees.

ICDL for Schools

Students with ICT skills enjoy an enriched educational experience and will be better prepared for life, work, and further learning. ICT skills enable teachers to use technology more effectively in the teaching process, thus achieving educational goals more efficiently, and in doing so save time and increase productivity in the classroom.

( Source http://www.icdlgcc.com )

Libre Office vs. Microsoft Office

How Does LibreOffice Compare with Microsoft Office?

LibreOffice performs remarkably well. The key differences between Microsoft Office and LibreOffice are the user interface and quality of the services.

User Interface and Graphics:

The user interface is more captivating and less cluttered. The ribbon UI in Microsoft office makes it easier to navigate through the features. On the other hand, LibreOffice’s appearance is more archaic and resembles that of older office suites such as Microsoft Office 2003 and older.

As you can see in the images below, Microsoft Office’s has a sleeker and picturesque design.

Quality and Accuracy:

LibreOffice also lags behind in the quality of the service. For example, LibreOffice Writer’s default grammar checking tool lacks accuracy and often misses syntactical errors.

As you can see in the image below, Microsoft Office detects the error However, LibreOffice fails to do so.

Fortunately, you can extend the functionality of LibreOffice by using third-party plug-ins such as Language Tool, which is a relatively accurate grammar checker for Open Office and LibreOffice.

Bundled Applications:

When you open LibreOffice, you will see a window that displays the 6 main applications or features.

LibreOffice Writer (Text Document):

This is the word processor application for LibreOffice. It is similar to programs such as Microsoft Word, AbiWord, Jarte Word Processor, etc. Writer allows you to create anything from letters to complex documents with embedded illustrations and bibliographies. Auto spell checking and auto completion make word processing much more convenient.

Unlike Microsoft Word, Writer mostly detects spelling errors and fails to detect syntactical errors. Fortunately, you can get around this issue by using an extension known as Language Tool.

Libreoffice Calc (Spreadsheet):

Calc is the spreadsheet program of LibreOffice. It is similar to programs such as Microsoft Excel, Abykus, Spread32, etc. It is an ideal alternative to Microsoft Excel. It allows you to effectively analyze and manage your data.

Calc is also a good application to use to create spreadsheets for inventories, timesheets, grade books etc. Like Excel, you can do simple math and calculate averages, multiply, and divide.

LibreOffice Impress:

Impress is the presentation software of LibreOffice. This program is extremely similar to Microsoft PowerPoint. If you are already used to using Microsoft PowerPoint to create presentations, you will have no problem using LibreOffice Impress. Impress allows you to create unique presentations to capture your audience’s intrest.

One the main differences between Impress and Microsoft Word are the template designs. PowerPoint’s templates are more picturesque and appealing. However, Impress still gives you plenty of tools to create captivating visual presentations.

LibreOffice Draw:

LibreOffice Draw is a vector graphics editor like Microsoft Visio. This program is intended for more advanced photo editors who are more accustomed to vector graphics. Microsoft Visio premium is an expensive program that nearly costs $1000. Thus, a free program like this is not only a great asset, but also saves you a fortune.

LibreOffice Database:

This is the database management program in LibreOffice. It is similar to Microsoft Access. It allows you to create the right database for your applications. You can also import your data from other database sources such as Oracle, MySQL, and Microsoft Access.

LibreOffice Math:

Math is a simple equation editor that lets you create mathematical, chemical, electrical, and other types of equations.

Is LibreOffice Really Worth Your Time?

It is certainly not worth your money because its free. While it is true that LibreOffice doesn’t provide the same quality as Microsoft Office, it still provides a plethora of useful features. The free version of Microsoft Office, Microsoft Works, doesn’t come close to it.

If you have the portable version on your USB flash drive, you can edit your documents anywhere you go. While LibreOffice is not necessarily worth your money, it is definitely worth your time!

Who is the Winner?

When it comes to pricing, LibreOffice definitely wins by a landslide. By offering an array of word processing features, it is nearly comparable to premium software.

When it comes to quality, Microsoft Office is the winner. Microsoft Office provides enhanced features that LibreOffice lack.

( Source http://www.technorms.com/9366/libreoffice-detailed-review )

Tutorial on how to install Libre Office Calc.

( Source www.youtube.com. All Credits to the channel )

Monday, March 3, 2014

Top 10 Spreadsheets Application

Top 6 Spreadsheets Applications are:

Rank #1

Microsoft Excel

Rank #2

Lotus. Software

Rank #3

Ability office Home

Rank #4

PlanMaker2010

Rank #5

Calculate

Rank #6

Resolver One

( Source http://spreadsheet-software-review.toptenreviews.com/ )

Spreadsheets

What is a Spreadsheet?

A spreadsheet is an interactive computer application program for the organization and analysis of data in tabular form. Spreadsheets developed as computerized simulations of paper accountingworksheets . The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array is a model–view–controller element that can contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

(Source http://en.wikipedia.org/wiki/Spreadsheet )