FOUNDATION COURSE LINGAYEN

ST COLUMBANS COLLEGE LINGAYEN : 

ST COLUMBANS COLLEGE LINGAYEN ICDL FOUNDATION Aldric Brooks Cert Ed, ICDL Expert, AMBCS

Europe : 

Europe

United Kingdom : 

United Kingdom 4 countries England Scotland Wales Northern Ireland

Lancashire : 

Lancashire Home of the Beatles Liverpool FC

Royal Navy 1976 - 1980 : 

Royal Navy 1976 - 1980

1980 - 1985 : 

1980 - 1985

Gaymer Group 1985 - 1994 : 

Gaymer Group 1985 - 1994 Wine Maker Started with Computers

Mindoro 1994 - 1995 : 

Mindoro 1994 - 1995 Started teaching Windows Oriental Mindoro Research and Development Foundation

Action For Blind People1995 - 2001 : 

Action For Blind People1995 - 2001

Preston College / UCLAN 2001 - 2007 : 

Preston College / UCLAN 2001 - 2007

Philippines 2007 - ? : 

Philippines 2007 - ? http://globalicttraining.ning.com

TOPICS - AM : 

TOPICS - AM HISTORY & TERMINOLOGY FILE MANAGEMENT - EXPLORER USING WINDOWS – SYSTEM MAINTENANCE HEALTH & SAFETY DANGERS - DEFENSE

TOPICS - PM : 

TOPICS - PM INTRODUCTION TO INTERNET AND EMAIL INTRODUCTION TO WORD 2003 INTRODUCTION TO EXCEL 2003 INTRODUCTION TO POWERPOINT 2003 INTRODUCTION TO ACCESS 2003

History of Computing & Terminology : 

History of Computing & Terminology

Inventor of the Computer : 

Inventor of the Computer Bill Gates? Charles Babbage 1791 – 1871 Difference Engine made of brass, wood, weighed 15 tons NOT the first laptop!

Difference Engine : 

Difference Engine Babbage never finished it, it was finally built in 1991 in London

First Programmer ? : 

First Programmer ? Ada Lovelace Born: London, England, December 10, 1815 Died: London, England, November 27, 1852 Analyst, Metaphysician, and Founder of Scientific Computing Quiz fact: she was the daughter of the poet Lord Byron Must have been the 1st real NERD!

Analytical Engine : 

Analytical Engine Started 1833 Used Punch Cards to Programme.

The Transistor : 

The Transistor "The Transistor was probably the most important invention of the 20th Century, and the story behind the invention is one of clashing egos and top secret research.“

The Integrated Circuit : 

The Integrated Circuit Conceived in 1951 in the UK First built in 1958 in the US Evolved into Microproccessors The Central Processing Unit (CPU) Computer Hardware

Hardware – Types of Computer : 

Hardware – Types of Computer The plastic boxes – anything you can touch (or kick!) is known as hardware. DESKTOP

The Future : 

The Future Pen PC Computer Table

Software : 

Software The Programs that run, making the plastic boxes into a computer system. Operating System Application Software

Microsoft : 

Microsoft Microsoft registered in 1976 Developed PC-DOS for IBM in 1980 1985 – Windows 1 released – Xerox – GUI 1990 – Windows 3.1 – the first stable GUI Windows continues to develop XP, VISTA

The Competition : 

The Competition Open Source Software Linux, Redhat – OS Star Office, Open Office – application suites Shareware Freeware

Copyright and Software Piracy : 

Copyright and Software Piracy License to use Single User End License Multi User End License Site License

Peripherals and Networks : 

Peripherals and Networks Peripherals – Attached to the Base or System Unit Networks – used to share resources Local Area Network (LAN) Wide Area Network (WAN) Server Dumb Terminals – do not have an operating system of their own

Input/Output Devices : 

Input/Output Devices Input – you are telling the machine what to do Keyboard, Mouse, Scanner, Microphone, Joystick etc. Output – the result Monitor, Printer, Headphones or Speakers, etc. Touch Screen?

Printers : 

Printers Ink Jet – high quality, relatively cheap, cant handle long print runs, use ink cartridges (expensive to replace and limited life) Laser – fast, high quality, can handle long print runs, expensive, use powder technology. Give off Ozone and the powder is carcinogenic – must be placed in well ventilated area. Cartridges should be recycled

Legislation : 

Legislation Data Protection Act Computer Misuse Act Health and Safety

Memory : 

Memory Volatile (or Temporary) – RAM – Random Access Memory Permanent – ROM – Read Only Memory Storage Media – Drive Terminology HDD, Floppy Disk Flash Drive CD-ROM, CD-R, CD-RW

Bits and Bytes : 

Bits and Bytes 8 Bits make 1 Byte 1024 Bytes make 1 Kilobyte (Kb) 1024Kb make 1 Megabyte (Mb) 1024Mb make 1 Gigabyte (Gb) 1024Gb make 1 Terrabyte (Tb) Why 1024? - 210

Extensions : 

Extensions Link the file to the Application .doc – Word .xls - Excel .mdb – Access .ppt – Powerpoint Gif, jpg, bmp – graphics Htm – web page Txt, rtf – text Zip - compressed Exe - program or executable

Backing Up : 

Backing Up In case of HDD failure It’s a Copy, on separate media ! Full Incremental Grandfather, Father, Son System Frequency

FILE MANAGEMENT : 

FILE MANAGEMENT

DRIVES : 

DRIVES DRIVE C – THE HARD DISK DRIVE INSIDE THE BOX DRIVE A – FLOPPY DISK DRIVE DRIVE D – CD/DVD DRIVE E,F,G – EXTERNAL DRIVES, NETWORK DRIVES

GET ORGANISED : 

GET ORGANISED

WINDOWS EXPLORER : 

WINDOWS EXPLORER

OPERATIONS : 

OPERATIONS SAVE AS SAVE COPY CUT PASTE DELETE RENAME

INTERNET & EMAIL : 

INTERNET & EMAIL

Internet : 

Internet Difference between the Internet & WWW Military Origins during Cold War Universities Started to boom in the 80’s and 90’s Not controlled by anyone Care when researching – look at dates Many Applications – email most widely used

What you need to connect : 

What you need to connect Computer Modem – Modulator-Demodulator Internet Service Provider (ISP) Telephone or DSL Line Internet Browser

Threats - MALWARE : 

Threats - MALWARE Hackers Viruses Internet E-mail Unknown disks or flash drives Types: Time Bomb, Trojan Horse, Worm, E-mail Spyware, Crimeware Adware, Phishing Pop-Ups Scams

Precautions : 

Precautions Anti-Virus Software Firewall Anti Spyware Anti Adware Pop-up Blocker

Abbreviations : 

Abbreviations Http Html FTP Domain Web Browser Home Page Hyperlink URL Hypertext Transfer Protocol Hypertext Mark-up Language File Transfer Protocol acdle.com, yahoo.com Internet Explorer, FireFox Browser, Site Link Uniform Resource Locator http://globalicttraining.ning.com

Web Pages : 

Web Pages HTML – a formatting language, not a programming language Keep images small Search Engines – Google, web-bots Search Directories – Yahoo - human

E-mail Etiquette : 

E-mail Etiquette Netiquette Short Attachments Subject Capitals Emoticons Make up of an E-mail Address aldric.brooks@yahoo.com.ph

Word Processing : 

Word Processing

Covering: : 

Covering: Terminology Formatting – text, paragraph Layout Tables Pictures Copy, Cut and Paste Page Setup Word Art and Autoshapes Mail Merge

Word Processing : 

Word Processing Used to a typewriter? There is no carriage return –Word Wrap! New to Word Processing? Word Processing - Printers

OK, Lets get started : 

OK, Lets get started Double Click Test 34.doc on your Desktop. This is an article about Preston in the UK Lots of Filipino Nurses there!

Mail Merge : 

Mail Merge Write down “Make sure the Mail merge Toolbar is showing” Then write: 1 2 6 4 from the right

Mail Merge : 

Mail Merge The addresses are in the file called: Addrlst.doc on your desktop

SPREADSHEETS : 

SPREADSHEETS

Spreadsheets : 

Spreadsheets Number Crunchers First application to be developed for computers Spreadsheets have been used by accountants for hundreds of years. Computerized or electronic spreadsheets are of much more recent origin. Information Systems oral history and some published newspaper and magazine stories celebrate

Microsoft Excel : 

Microsoft Excel When Windows finally gained wide acceptance with Version 3.0 in late 1989 Excel was Microsoft's flagship product. For nearly 3 years, Excel remained the only Windows spreadsheet program and it has only received competition from other spreadsheet products since the summer of 1992.

OK, Let’s get started : 

OK, Let’s get started Start Programs Microsoft Office Microsoft Excel 2003 You will be presented with a blank spreadsheet composed of rows and columns

What we learned… : 

What we learned… Cell Referencing – Relative and Absolute Copying and selecting Cells Simple mathematic formulae Simple Functions SUM, COUNT, AVERAGE, MIN, MAX =Function Name(Range) Enter IF Statement =IF(Question, YES, NO) Enter Charting Cell Referencing.avi

PRESENTATION : 

PRESENTATION

Presentation – MS PowerPoint : 

Presentation – MS PowerPoint Designed to enhance your presentation NOT replace it! Know your audience, “Stumble Bum” Tailor to suit, don’t dumb down, spell check! Don’t use too much text on each slide! Powerpoint

OK, Lets get started…. : 

OK, Lets get started…. Double click Olympics.ppt on your Desktop

What we learned… : 

What we learned… The different Views, moving slides Creating different sorts of slides Rotating and Flipping Objects Inserting and Ordering Objects Custom Animation and Sound Slide Transition and Sound Master Slides, Outline View, Notes Page Footers, Backgrounds, Design, Bullets, Case, Hiding Slides, Print Options

DATABASE : 

DATABASE

MS-ACCESS : 

MS-ACCESS A database stores information Made up of “Objects” Tables – where the data is stored – made up of Fields and Records Queries – used to extract data depending on criteria Forms – used for inputting Reports - printouts

Simple address book : 

Simple address book Set up a table Set up an input form Input some data Set up a query Create a report

CAN GET QUITE COMPLEX : 

CAN GET QUITE COMPLEX