INTERNET AND COMPUTING FUNDAMENTALS

Introduction . iiCourse Design . iiiCourse Structure . ivCourse Delivery . viFirst YearLearning the Basics of Computers . 1Second YearWorking with Microsoft Office Word 2003 . 16Working with Microsoft Office Excel 2003 . 25Third YearWorking with Microsoft Office PowerPoint 2003 . 35Exploring the Web and Network . 45AcknowledgmentsINTERNET AND COMPUTING FUNDAMENTALSThe Strengthened Technical-Vocational Education Programi Page

Computer has become a part of our daily lives since it can store a large volume ofinformation. Nowadays, computers are used not just in businesses, transportation, communication,and education but also for personal use. In just one click, one can access information just aboutanything in a jiffy. Computers can help a person do his task easily, accurately and quickly.Computers can even help save lives especially in the field of medicine. Even disabled people can usecomputers to guide them in their normal activities. Thus, computers have now become a necessityand not just a luxury.The core of the curriculum emphasizes on achieving fundamental technical capability that isrequired to do clerical and office specialty-based work where the Internet would be extremelyutilized. Students will be geared on the idea of computer literacy and the use of general office skillsin order to pursue a career in business. Most importantly, the curriculum will make learners becomeOffice Assistants or Office Specialists.Internet and Computing Fundamentals will be useful in making the students in making thestudents learn the basics of computers, work with Microsoft Office 2003 applications, and explorethe web and network.Department of Education (DepEd) in collaboration with Innovative Training (IT) Works,Incorporated envisioned a project on computer literacy in order for students to pass the Certiport’sInternet and Computing Core Certification (IC3) needed by students to become self-employed orindustry-employed after completing the course. Thus, Internet and Computing Fundamentals (ICF) isanchored in providing skilful, knowledgeable, competent students in the field.INTERNET AND COMPUTING FUNDAMENTALSThe Strengthened Technical-Vocational Education Programii P a g e

COURSE TITLE:INTERNET AND COMPUTING FUNDAMENTALSNOMINAL DURATION:216 HOURSQUALIFICATION LEVEL:Certiport’s Internet and Computing Core Certification (IC3)COURSE DESCRIPTION: This course is designed to enhance the knowledge, skills anddesirable attitude required in learning the computerbasics. It covers the competencies such as: recognizingcomputers, using Windows XP, performing using basicword processing program, spreadsheets, PowerPointpresentation and using the Internet as a tool for searchinginformation. It also includes competencies in workplace,Internet safety, and the legality and privacy of one’s workENTRY REQUIREMENTSStudents who wish to enroll in the course must: have potential/skill as per High School Occupational Interest Inventory (HSOII) results possess desirable and healthy attitude towards skill activities have passed interview and aptitude test submit the following documents:-Form 138-Parent consent-Medical certificate issued by a government physician-Certificate of good moral characterINTERNET AND COMPUTING FUNDAMENTALSThe Strengthened Technical-Vocational Education Programiii P a g e

FIRST YEARUNIT OFCOMPETENCYMODULETITLELEARNINGOUTCOMESUGGESTEDNO. OFHOURSLEARN THEBASICS OFCOMPUTERSLearning theBasics ofComputersLO 1. Recognize the different types of computerLO 2. Identify the types and purpose of inputdevicesLO 3. Identify the parts and functions ofprocessing deviceLO 4. Identify the types and purpose of outputdevicesLO 5. Identify the types and purpose of storagedevicesLO 6. Identify the types and purposes ofsoftwareLO 7. Apply basic troubleshooting techniquesLO 8. Present criteria in buying a computerLO 9. Explore the Microsoft Windows XPenvironmentLO 10. Work with a typical windowLO 11. Browse the hierarchy structure of files,folders and drivesLO 12. Customize system settingsLO 13. Utilize common applicationsoftware72 hoursSECOND YEARWORKWorking withWITHMicrosoftMICROSOFT Office 2003OFFICEWORD 2003LO 1. Introduce Microsoft Office Word 2003applicationLO 2. Create and edit documentLO 3. Format content and paragraphsLO 4. Format documentLO 5. Organize contentLO 6. Manage documents36 hoursWORKWITHMICROSOFTOFFICEEXCEL 2003LO 1.LO 2.LO 3.LO 4.LO 5.36 hoursWorking WithMicrosoftOffice Excel2003Introduce spreadsheet applicationCreate workbook in different waysCreate and edit data in a worksheetModify table structures and cell formatsManipulate data using formulas andworksheet functionsLO 6. Draw simple conclusions and create chartsbased on tabular dataLO 7. Manage workbooksINTERNET AND COMPUTING FUNDAMENTALSThe Strengthened Technical-Vocational Education Programiv P a g e

THIRD YEARWORKWITHMICROSOFTOFFICEPOWERPOINT 2003Working WithMicrosoftOfficePowerPoint2003LO 1. Introduce Microsoft Office PowerPoint2003LO 2. Create presentation in different waysLO 3. Enter contents in a presentationLO 4. Format content of a presentationLO 5. Insert graphics and chartsLO 6. Enhance the presentationLO 7. Manage and deliver the presentationEXPLORETHE WEBANDNETWORKExploring theWeb andNetworkLO 1.LO 2.LO 3.LO 4.LO 5.LO 6.LO 7.LO 8.Recognize network fundamentals and thebenefits and risks of network computingDetermine the relationship betweencomputer networks, othercommunications networks (like thetelephone network) and the InternetUse web browsing application software inaccessing information on the InternetSearch the Internet for information usingsearch engineIdentify how e-mail works and related“netiquette”Identify how computers and Internet areused in different areasIdentify and compare the risks of usingcomputer hardware and softwareDetermine the legal, ethical, andresponsible uses of both the computersand Internet safety36 hours36 hoursINTERNET AND COMPUTING FUNDAMENTALSThe Strengthened Technical-Vocational Education Programv Page

COURSE DELIVERY: Lecture/DiscussionModularMultimedia presentationDemonstration Plan, Develop, Review and Share ApproachObservation /ExplorationHands-on /TutorialRESOURCES One (1) set of personal computer per student in the laboratory with licensedMicrosoft Windows XP, Microsoft Office Application 2003, mouse, speakers,AVR/UPSInternet connectionVideo CD/DVD of Microsoft Office PowerPoint Presentation (as provided)LCD projectorCD / DVD-R/RWFlash drive or any storage devicePrinter (networked)Bond paper 8.5” X 11”Modules/HandoutsReference booksASSESSMENT METHODS: Question and UALIFICATION OF A TEACHER: Must be Certiport’s Internet and Computing Core Certification (IC3) passerPass the required government examinationPhysically and mentally fit.INTERNET AND COMPUTING FUNDAMENTALSThe Strengthened Technical-Vocational Education Programvi P a g e

Unit of Competency :LEARN THE BASICS OF COMPUTERSModule TitleLEARNING THE BASICS OF COMPUTERS:Module Description :This module covers the knowledge, skills and attitude requiredin learning the computer basics. This module is composed oftwo major sections: (1) Recognizing Computers and (2) UsingWindows XP to facilitate a comprehensible understanding forthe students. The first section, Recognizing Computers tacklesthe individual component of Personal Computers. The secondsection, Using Windows XP focuses on developing andenhancing students’ skills and knowledge about computers.Nominal Duration:72 hoursCertification Level:Certiport’s Internet and Core Computer Certification (IC3)Pre-requisites:NoneLearning Outcomes :Upon completion of this module, the students should be able to:LO 1.LO 2.LO 3.LO 4.LO 5.LO 6.LO 7.LO 8.LO 9.LO 10.LO 11.LO 12.LO 13.recognize the different types of computer;identify the types and purposes of input devices;identify the parts and functions of processing device;identify the types and purpose of output devices;identify the types and purpose of storage devices;identify the types and purposes of software;apply basic troubleshooting techniques;present criteria in buying a computer;explore the Microsoft Windows XP environment;work with a typical window;browse the hierarchy structure of files, folders and drives;customize system settings; andutilize common application software.INTERNET AND COMPUTING FUNDAMENTALSThe Strengthened Technical-Vocational Education Program1 Page

LO1.RECOGNIZE THE DIFFERENT TYPES OF COMPUTERASSESSMENT CRITERIA:1. Computers are classified according to size, power and purpose.2. Types of microcomputers are identified, explained and differentiated.3. Other types of computing devices are enumerated and discussed.CONTENT: Classifying computers according to size, power and purposeIdentifying, explaining and differentiating the types of microcomputersEnumerating other types of computing devicesCONDITION:The following resources are needed in this learning outcome: Personal ComputerLCD ProjectorProjection screenWhiteboardDifferent computer technologies (i.e. mobile phone, calculator, etc.)All other available electronic devices (i.e. DVD player, television set, etc.)Pictures of different types of computersModules / HandoutsReference booksWhiteboard marker/eraserMETHODOLOGIES: LectureGroup discussionMultimedia presentationASSESSMENT METHODS: Oral questioningWritten examinationSmall Group workINTERNET AND COMPUTING FUNDAMENTALSThe Strengthened Technical-Vocational Education Program2 Page

LO2.IDENTIFY THE TYPES AND PURPOSES OF INPUT DEVICESASSESSMENT CRITERIA:1. Basic input devices are distinguished and explained.2. Specialized input devices are determined.CONTENT: Distinguishing and explaining basic input devicesDetermining specialized input devicesCONDITIONS:The following resources are needed in this learning outcome: Personal ComputerLCD ProjectorProjection screenWhiteboardKeyboardMouseScannerAll other available input devicesPictures of different types of computersModules / HandoutsReference booksWhiteboard marker/eraserMETHODOLOGIES: Group discussionLectureMultimedia presentationASSESSMENT METHODS: Oral examinationWritten examinationShort answer questions: True/False/Multiple Choice Questions paper-based orcomputer-aided-assessment)INTERNET AND COMPUTING FUNDAMENTALSThe Strengthened Technical-Vocational Education Program3 Page

LO3.IDENTIFY THE PARTS AND FUNCTIONS OF PROCESSING DEVICEASSESSMENT CRITERIA:1. Components and purposes of the internal parts of the system unit arerecognized.2. The roles of the central processing unit are discussed.3. The speed of the microprocessor is measured.4. The role of Random Access Memory (RAM) in processing data is explained.5. Ports that connect the input and output devices to a computer are utilized.CONTENT: Recognizing the components and purposes of the internal parts of the systemunitDiscussing the roles of the central processing unitMeasuring the speed of the microprocessorExplaining the role of Random Access Memory (RAM) in processing dataUtilizing the ports that connect the input and output devices to a computerCONDITIONS:The following resources are needed in this learning outcome: Personal ComputerLCD ProjectorProjection screenWhiteboardSystem Unit (to be disassembled)MicroprocessorMemory moduleModules / HandoutsReference booksWhiteboard marker/eraserMETHODOLOGIES: Group discussionBuzz GroupMultimedia presentationINTERNET AND COMPUTING FUNDAMENTALSThe Strengthened Technical-Vocational Education Program4 Page