Archive for the ‘Learning’ Category

The IF Function in Excel

February 2, 2011

As part of the syllabus for the Module 4 exam in ECDL, you need to know how to use the IF Function in Excel.

The formula for the IF function is:

=IF(condition, true, false)

The following Youtube video may explain it better.

Advertisements

Domain Names

October 8, 2010
Examples of domain namesThe TY Social Networking class continue to work on their blogs.  You can now view their blogs by going to the class blog. Each blog is listed under blogroll.

Now we need to look at purchasing a domain name for your site. At present, your blog is hosted on wordpress.com. You can see this in the URL of your blog e.g., the URL of the class blog is:

http://tysocialnetworking.wordpress.com

What if you want your web address to be http://www.tysocialnetworking.com or http://www.tysocialnetworking.ie?

To do this, you need to purchase a domain name. A domain name is nothing more than the Internet equivalent of a postal address or a telephone number. Every country has its own domain name.

The domain name for Ireland is .ie and the domain name for Germany is .de. You can see a list of all country domain names here.

Can you see which country’s domain is .tv?

The most popular domain is .com which means ‘commercial’ and is the most commonly used domain in the world. While anyone can register a .com domain, there are restrictions on who can register a .ie domain.

There are lots of domain name sellers on the web. An example of an Irish domain name seller is Blacknight. Go to their website and find the cost of a .com domain for one year. Now compare the cost of a .com to a .ie

If your domain name is not available, you can find out who owns it by doing a WHOIS search. Can you find out the owner of football365.com?

You can find out the owner of a .ie by going here.

Some people also make money from registering popular domain names and then selling them on.

As of 2004, according to Guinness World Records, the most expensive domain name sales on record were:

  • Business.com for $7.5 million in December 1999
  • AsSeenOnTv.com for $5.1 million in January 2000
  • Wine.com for $2.9 million in September 1999
  • CreditCards.com for $2.75 million in July 2004
  • Autos.com for $2.2 million in December 1999

But you cannot always  register any domain name you like. A famous case was madonna.com

File Types & File Conversion

September 17, 2010

Here is a short presentation on File Types and File Conversion by students in Mr. Askin’s Technology Class.

ECDL eLearning

September 17, 2010

All Transition Year ECDL students can now access their eLearning account using the following URL:

https://www.ics-skills.net/learner

You should add this link to your Favourites.

ECDL – Transition Year

September 3, 2009

If you are considering doing ECDL in Transition Year, then you should take a look at the following websites to learn more about ECDL.

ICS Skills

Teach ICT

Download the syllabus from ICS Skills and do some questions on the Teach ICT website.

What is ECDL?

The European Computer Driving Licence (ECDL) is the world’s most successful IT skills certification programme. Almost three million people are participating in the programme today in over 60 countries worldwide. Over 125,000 secondary school students in Ireland have completed the ECDL.

In Ireland, the ECDL is administered by ICS SKILLS.

The ECDL establishes a standard for everyone who uses a computer in either a professional or personal capacity. It is a certificate that verifies competence in computer use, making the holder readily mobile within Ireland and internationally. Employers and job seekers all agree on the importance of this standard definition of practical competence in Information Technology.

The ECDL consists of 3 main components – a syllabus, a skills card and a question test base, all leading to the European Computer Driving Licence.

If you have any questions on ECDL, post them in the comments sections of this post or you can email mrhannon [at] geralds [dot] ie

Source: ICS Skills

What is Twitter?

May 10, 2009

twitterTwitter is a free social networking and micro-blogging service started by Jack Dorsey in 2006. It enables users to send and read other users’ updates known as tweets.

Tweets are text-based posts of up to 140 characters in length which are displayed on the user’s profile page and delivered to other users who have subscribed to them (known as followers). Senders can restrict delivery to those in their circle of friends or, by default, allow anybody to access them.

This video may explain it better:

Who uses Twitter?

The Los Angeles Fire Department used Twitter during the California wildfires in October 2007. NASA have used it to update the public on its various space missions. Barack Obama used it extensively during his campaign and celebrities are now using it such as Stephen Fry.

Unfortunately Twitter is blocked in schools by the NCTE but do visit the sgcbusiness.com Twitter page .

Read about some young tweeters in Ireland.

Are you on Twitter?

Computer Software in Plain English

April 9, 2009

As part of the upcoming Module 1 ECDL exam, you will need to know the different types of computer software and how an Operating System is different to other computer applications.

The following Youtube video explains Computer Software in Plain English.

ECDL Module 1

April 6, 2009
Information and Communications Technology

Information and Communications Technology

The final ECDL exam this year for Mr. Hannon’s class is Module 1 – Basic Concepts of Information Technology.

The module 1 exam in ECDL is a theory based exam and will test your knowledge of ICT terms and theory.

I have uploaded two Mind Maps that will help you prepare for the Module 1 exam. You should download and print these mind maps.

As always, the Teach-ICT website has some excellent resources for ECDL. Test your knowledge of Module 1 by doing their Revision Quiz.

Databases

March 19, 2009

DatabaseThe next exam for Mr. Hannon’s ECDL class is scheduled for Thursday April 2nd in the Computer Room. This exam is on Module 5 – Database.

As discussed in class today, a database is simply a file that stores information or data. We actually use databases every day on the web e.g., searching for the book you want on Amazon, looking for a used car on Carzone.  All businesses and organisations maintain a database of their employees and customers e.g., we have a database here in the school of all students.

You should divide Module 5 into four sections:

  1. Tables
  2. Forms
  3. Queries
  4. Reports

Use your CD and Syllabus as always to prepare for the exam and you should also look at the videos for Module 5 on Teach-ICT.com

ECDL Classes – Module 7 Exam

February 4, 2009

The next exam for Mr. Hannon’s ECDL class is on Thursday February 12th.

The exam is based on Module 7 – Internet & Communications.

There are two main areas to be studied in Module 7:

  • The Internet and the WWW.
  • Email – using Microsoft Outlook.

Revise your CD and print a copy of the Module 7 syllabus. The syllabus has been emailed to your Google Apps account and can also be downloaded from the ECDL folder on the shared student drive on the school network.

You should also view the online presentation of all the terms in Module 7 on the Teach-ICT.com website.