UNIVERSITY OF COLOMBO SCHOOL OF COMPUTING

1
UNIVERSITY OF COLOMBO SCHOOL OF COMPUTING (UCSC)
DEGREE OF BACHELOR OF INFORMATION
TECHNOLOGY (EXTERNAL) WEB SITE www.bit.lk
2
IT1302 PC APPLICATIONS

• SYLLABUS REVISION
• IMPORTANT FOR
• TEACHERS REPEATERS
• CHANGE OF MODULE NAME
• LEARNING OBJECTIVE - THE USE OF PERSONAL
  COMPUTER SYSTEMS AND APPLICATIONS

3
TOPICS

• INTRODUCTION TO COMPUTERS
• MS-WINDOWS OPERATING SYSTEM
• INTERNET USAGE
• WORD PROCESSING
• SPREADSHEET APPLICATIONS
• DATABASE APPLICATIONS
• PRESENTATION APPLICATIONS
• WEB AUTHORING
• COMPUTER VIRUSES

4
INTRODUCTION TO COMPUTERS

• OBJECTIVE IDENTIFY THE
• MAIN COMPONENTS OF A
• COMPUTER SYSTEM AND
• EXPLAIN THEIR BASIC FUNCTIONS
• WHAT IS A COMPUTER?
• COMPONENTS OF A COMPUTER SYSTEM
• WHAT DOES A COMPUTER DO?
• HARDWARE AND SOFTWARE
• TYPES OF COMPUTERS
• APPLICATION AREAS OF COMPUTERS
• MULTIMEDIA APPLICATIONS AND DEVICES

REMOVED SOME FUNDAMENTALS OF COMPUTER SYSTEMS
5
MS-WINDOWSOPERATING SYSTEM

• OBJECTIVE USE THE WINDOWS OPERATING SYSTEM FOR
  HANDLING FILES AND SETTING UP BASIC HARDWARE
  COMPONENTS
• COMMON OPERATING SYSTEMS
• USING WINDOWS OPERATING SYSTEM FEATURES
• HANDLING FILES, DISK DRIVES, FILES
• AND FOLDER STRUCTURE
• SETTING UP HARDWARE COMPONENTS

REMOVED DOS
6
INTERNET USAGE

• OBJECTIVE USE THE INTERNET FOR EFFECTIVE
  COMMUNICATION AND SEARCHING FOR INFORMATION
• INTRODUCTION TO INTERNET
• INTERNET FACILITIES
• SEARCHING INFORMATION
• ON WORLD WIDE WEB

7
WORD PROCESSING

• OBJECTIVE USE THE MAIN FEATURES AVAILABLE IN
  WORD PROCESSING SOFTWARE IN EFFICIENTLY CREATING,
  EDITING AND PRINTING PROFESSIONAL QUALITY
  DOCUMENTS
• WHAT IS WORD PROCESSING
• CREATING A NEW DOCUMENT
• FORMATTING PARAGRAPHS AND TEXT
• SPELL CHECKER GRAMMAR CHECKER
• MAIL MERGE
• WORKING WITH TABLES CHARTS

8
SPREADSHEETAPPLICATIONS

• OBJECTIVE USE THE MAIN FEATURES AVAILABLE IN A
  SPREADSHEET APPLICATION PACKAGE TO ANALYZE AND
  INTERPRET DATA
• WHAT IS SPREADSHEET
• CELL ENTRIES EDITING
• USE FORMULAS AND FUNCTIONS
• CHARTS
• INTRODUCTION TO THE USE OF
• ADVANCED SPREADSHEET CONCEPTS

9
DATABASEAPPLICATIONS

• OBJECTIVE USE DESIGN, CREATE AND USE SIMPLE
  DATABASE APPLICATIONS FOR STORING, UPDATING,
  MANIPULATING AND RETRIEVING DATA
• WHAT IS A DATABASE?
• DATABASE OBJECTS
• WORKING WITH TABLES
• WORKING WITH SIMPLE QUERIES
• WORKING WITH FORMS
• CREATING A SIMPLE REPORT
• DATABASE WIZARD

10
PRESENTATIONAPPLICATIONS

• OBJECTIVE USE THE FEATURES AVAILABLE IN A
  PRESENTATION PACKAGE TO CREATE ONSCREEN
  MULTIMEDIA SLIDESHOWS
• INTRODUCTION TO PRESENTATIONS
• CREATING A NEW PRESENTATION
• DIFFERENT SLIDE VIEWS
• ADDING SPECIAL EFFECTS
• ACTION BUTTONS, HYPERLINK
• SLIDE MASTER
• PRINTING PRESENTATIONS, NOTES

11
WEB AUTHORING

• OBJECTIVE DESIGN AND DEVELOP WEB PAGES USING
  HTML BASICS AND WEB AUTHORING TOOLS
• INTRODUCTION
• TO HTML
• DESIGN AND WEB
• DEVELOPMENT
• USE OF A WEB
• DEVELOPMENT
• TOOL

12
COMPUTER VIRUSES

• OBJECTIVE EXPLAIN THE EFFECTS OF COMPUTER
  VIRUSES AND IMPLEMENT PRECAUTIONARY MEASURES
  AGAINST COMPUTER VIRUSES
• AN OVERVIEW OF COMPUTER VIRUSES
• IMPLEMENTING PRECAUTIONS

13
REFERENCES

• MAIN READING
• A FIRST COURSE IN COMPUTERS BY SANJAY SAXENA,
  VIKAS PUBLISHING HOUSE PVT LTD., 2003. ISBN
  81-259-1444-7
• http//www.archive.ncsa.uiuc.edu/General/Internet/
  WWW/
• http//www.howstuffworks.com/virus.htm

WE HAVE CHANGED SOME OF THESE REFERENCES REFER
DETAILED SYLLABUS
14
REFERENCES

• SUPPLEMENTARY READING
• (OPTIONAL)
• MICROSOFT OFFICE 2000 8 IN 1 BY JOE HUBRAKEN,
  PRENTICE-HALL OF INDIA, EASTERN ECONOMY EDITION,
  1999.
• TEACH YOURSELF HTML 4 WITH XML, DHTML
  JAVASCRIPT BY STEPHANIE COTTRELL BRYANT, 2000.
• http//www.w3.org/MarkUp/
• http//www.sophos.com/

WE HAVE CHANGED SOME OF THESE REFERENCES REFER
DETAILED SYLLABUS
15
PLATFORM

• ANY STANDARD PC WITH MS OFFICE
• WORD, EXCEL, ACCESS
• POWERPOINT, FRONTPAGE
• WITH INTERNET ACCESS,
• PREFERABLY WITH MULTIMEDIA.

16
LEARNING PROCESS

• THERE WOULD BE CONTINUOUS ASSIGNMENTS, QUIZZES
  AND GROUP WORK
• IN ADDITION TO THE FINAL EXAMINATION WHICH IS
  BASED
• ON MULTIPLE CHOICE QUESTIONS