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