Certificate in Computer Application

Certificate in Computer Application
Introduction
Certificate in Computer Application Covers computer ideas and Internet aptitudes and utilization of software suite, which incorporates word handling, Spreadsheet, database, and presentation programming to exhibit abilities. Certificate in Computer Application Covers computer concepts and Internet skills and uses a software suite, which includes word processing, database, Spreadsheet, and presentation programming to demonstrate skills.

General Information
Course Industry:
Certificate in Computer Application
Course duration:
240 credit hours (45 days)
Instructor:
Mr. Tahir Ahmed Khwaja, Mr. Fahad Mehmood Khan
Prerequisites:
No previous knowledge is required to enroll for this course
Course availability:
Available at Rawalpindi, Lahore and Karachi campuses.
Course Fee:
7,000 PKR ($140)

Desire Learning Objective

This course will help you to:

·         Recognize and talk about the four principle elements of computer’s hardware:                      input, information handling, output and storage.

·         Recognize and describe significant hardware parts.

·         Recognize, describe and utilize correspondences and systems networking.

·         Demonstrate the operating system working.

·         To include: file management, disk management, and memory management.

·         Distinguish and talk about computer ethics and security issues.

·         Exhibit seeking, approval, and assessment of data discovered online and in library                  databases.

·         Distinguish and talk about programming improvement procedures and                                        programming languages. 

 

Instructional Techniques

We impart knowledge and Practical Training in following way:

Ethics, discipline, motivation, health and safety training:     Half an hour daily           (10%) 

Theoretical knowledge:                                                                      One (01) hour daily              (25%)

Hands on Training:                                                                                  Six (06) hour daily                (65%)

 

COURSE OUTLINE:

COMPUTER HARDWARE

Input/output

  •          Hardware definition.
  •          Different monitor and resolution types:
  •          Utilization of the keyboard and other input devices.
  •          Pointing devices (mouse, joystick, trackball, touchpad).
  •          Different print technologies.
  •          Function of hardware ports (serial, USB, parallel, firewire).

Processing

  •          CPU definition.
  •          function of the motherboard.
  •          expansion slot Definition.
  •          processing speed/system clock.
  •          function of the bus.

 Storage

  •          Differentiate types of storage (primary and secondary).
  •          Describe types of storage (dynamic and persistent).
  •          Data storage hierarchy (Bits, Bytes, Kilobytes, Megabytes, Gigabytes,
             and Terabytes).

 Communications Technologies

  •          important Telephony principles.
  •          telecommunication devices
  •          LANS, WANS, the Internet

o   Wireless
o Intranets
o  Client/Server & other architectures
o  Topologies

  •          describe the accompanying terms and utilize the capabilities within the Internet -                World Wide Web, Uniform Resource Locator, Domain Names, File Transfer,                                  Telnet and other common protocols
  •          Operations of Web servers & browsers.
  •          Search Engine and utilize a search engine to recognize relevant web sites.
  •          Evaluate a Web site for relevancy, bias and credibility.
  •          Sending & receiving email along with an attachment.
  •          Name & define the parts that make up a search engine.
  •          Web 2.0 technologies such as blogs, wikis, RSS feeds, and
             podcasting utilizing communicate and collaborate.

 Operating Systems

  •          Operating system & major operating system functions
  •          Compare and contrast operating systems

o  Windows
o  Unix/Linux
o  Apple

  •          System software & application software
  •          Command-based system & graphical user interface.(GUI)
  •          Recognize and describe the parts & use of a window in a GUI
  •          Active window and background items
  •          Using common dialog box controls:

o  (radio) buttons
o   check boxes
o   text box
o list box

  •          Various shapes & importance of mouse pointer.
  •          Concept of disk formatting
  •          Desktop management skills utilizing:

o themes, screen savers, backgrounds
o  Tiling, cascading
o  Short-cuts & icons
o   Task bar, Desktop menus, Quick Launch

  •           File management skills

o  Creating and identifying valid file names & folders
o  Utilizing find, move , copy, move, delete files and folders
o  deletion process and recovery methods
o  GUI tools for navigation & selection

  •          Utilize operating system Help system for finding answers to queries
             about operations and command usage

Ethics &  Security

  •          Computer viruses; worm, Trojan horse, denial of service
             attack, back door and spoofing, and discovering ways to safeguard.
  •          Explain concepts of:

o  Hacking & Cracking
o  Authorization
o  Attacks, malware, Spam, Phishing

  •          Intellectual property rights, piracy,& information theft.
  •          Plagiarism and issues linked with Web for research.
  •          Codes of conduct and privacy issues linked with computing.
  •          Discsocial, legal, and ethical issues including privacy, intellectual
             property, health concerns, green computing, and accessibility.

o  Information Literacy

  •          Identify types and purposes of resource formats (books, encyclopedias, DVDs,
             popular publications, scholarly publications, Internet websites, Wikipedia).
  •          Constructing a search strategy by means of appropriate commands for information
             retrieval system selected (phrase, truncation, Boolean operators and subject                             terms).
  •          how to assess information found online and in library databases for
             r validity, reliability, accuracy, timeliness, authority, and point of view/bias.

 

PRODUCTIVITY TOOLS

 Word Processing

  •          significant components of the word processing interface.
  •          Utilizing Help system.
  •          basic editing, text formatting, copy, move and cut and paste functions.
  •          Utilizing available view modes.
  •          Utilizing backup options and essential save.
  •          print functions.
  •          headers and footers.
  •          embedded date, time and pagination in headers and/or footers
  •          font styles, sizes, colors, margins,
             alignment, and indentation
  •          Utilingze document context manipulation functions; find, search and replace, a                        grammarian and spell checker.

Spreadsheets

  •          Significant components of the spreadsheet interface. Note:
             emphasis should be on the CUI (common user interface) shared between most
             productivity tools.
  •          Help system.
  •          Basic editing, move, copy,  data entry and cut and paste functions.
  •          Basic insertion, deletion and modifications to at the sheet/workbook level.
  •          Creating, and using formulas.
  •          Utilize built-in spreadsheet functions(basic)
  •          Utilize various addressing and referencing schemes.
  •          Utilize essential formatting features
  •          Utilize print functions.
  •          Graphs and charts.

Databases

  •          File, record, field and character
  •          Purpose and uses of:

o  Tables
o  Forms
o  Reports
o  Queries

  •          Use different GUI based configuration devices for database creation and control for                example, wizards or manual database plan.       
  •          Utilize primary and foreign keys, constraints, and
             referential integrity.
  •          Utilize simple queries for searching & manipulating datasets.
  •          Simple reports and forms using a GUI interface, along with grouping
             and sorting features.

Presentation Graphics

  •          use of presentations, along with discussion on appropriate data
             display techniques.
  •          Creating and manipulating simple slide shows along with outlines and notes.
  •          Creating slide presentation with text, animation, graphics, and
             transitions features
  •          Utilize design layouts & templates.

Web Authoring and Publishing

  •          Create a Web page using the following xhtml tags:
  •          Basic tags (head, body, title)
  •          DTD or schema
  •          Insert a graphic using the img tag.
  •          Create a link using the tag.
  •          Use table tags to create a table. (table, td, tr)
  •          Insert headings (h1...h6)
  •          Insert ordered and unordered lists (ul, ol, li)
  •          Create simple inline and embedded styles using CSS
  •          Publish a Web page on the Internet

Software Development

  •         Steps in program development cycle.
  •         Basic program design & methodologies
  •         Algorithms
  •         Structured & Object-Oriented Programming
  •         Control Structures
  •         Essentials of program development.
  •         Planning and Analysis
  •         Coding
  •         Debugging and testing
  •         Maintenance