Tuesday 10 January 2017

COURSE OF CONTENT

Course Outline

Week 1-2: Computer basics
  • Computer overview
  • History of Computers
  • Types of  Computers
  • Hardware parts of computer (inputs,outputs,processing,and storage)
  • Software parts of computer (System and applicaiton software)
  • Computer impact and application

Week 2-3: Computer system software
  • Operating system concept
  • Types of operating systems
  • Utility software
  • Compler,interpreter,linker,loader
  • Functions of operating system
  • DOS operation
  • Virtualization of operating system 
Week 4-5: Working in Microsoft Windows Environment

Week  5-6 : Basic linux Operation

Week 7-8:Internet and World Wide Web
  • Brief history of the Internet
  • Web browser
    • internet explore/Mozila Firefox
    • Home page
  • internet address (URL)
  • Internet service
    • World wide web
    • Email
    • Chat
    • Social networking
  • Surfing the internet
  • Using search engines
Week 9-11 Word processor
  • Introduction to Microsoft word
  • Basic Editing
  • Formatting
  • Moving and Copyng
  • More Editing Features
  • Paragraph Formatting
  • Insert table (mege cells,spilit cell,table properties)
  • Bullets and Numbering
  • Boarder and shading
  • Inserting clipart and image
  • Drawing
  • Page break and creating Document
  • Mail mege
  • Page Set Up and Printing
  • Document protection
Week 12-14: Spread sheets
  • Introduction to Microsoft Excel 2007
  • Excel environment
  • Working with workbook and worksheet
  • Entering data (text,Number) 
  • Formatting (Font,number) and customizing data
  • Editing spreadsheets
  • Formulas and function
    • Creating / copying formulas
    • Cell referencing
    • Using insert function button
    • Using nested functions
    • Using SUM/COUNT/MIN/AVERAGE/RANK
    • IF statement and nested IF
  • Working with charts
  • Sourting and querying data
  • Freeze pane
  • Data validation
  • Linking worksheets
  • Importing and Exporting data
    • Export to Ms word
    • Import a word table
    • Import a text file
Week 15:
  • Installing Windows Operating System (Windows Xp or 2007)
  • Installing Office package (office 2003 or 2007,etc)

No comments:

Post a Comment