Computers Applications (Practical)

CONTENT

I: Introduction to Computers                                                          (6 Hours)

• Introduction to Computers (definition, characteristics & uses), Evolution of computers, System unit (memory, ALU & control unit), Input / Output devices, Storage devices (Memory- primary & secondary).
• Introduction to Software, its type (system, application & utility); Programming languages (machine, assembly & high-level), Language processors (assembler, compiler & interpreter), Generation of computers.
• Scanning of documents and pictures

II: Windows                                                                                     (6 Hours)

• Windows explorer; Control panel, Setting wallpaper, screen saver, background. Creating a folder, Compressing/ Zipping files (WinZip), Virus & Antivirus.

III: Microsoft Word                                                                          (20 Hours)

• Introduction to Word Processor, Features & Shortcut keys of Word processors, Working with Documents, Editing Documents in Word, Formatting Documents, Formatting Paragraphs, Formatting Page Reference Concept
• Inserting pictures, Hyperlinks & Clip Art, Understanding & creating Tables and Lists, Using Header and Footers Styles, Proofing text (Spell check, Auto correct), Mail Merge, Using Templates, Managing page formatting tools.

IV: Microsoft Excel                                                                            (24 Hours)

• Introduction to Spreadsheets & workbooks, creating, saving, editing & formatting a workbook, Features & Shortcut keys of Microsoft Excel
• Filling series, fill with drag, data sort, cell referencing (Relative, Absolute, Mixed), What-if analysis Entering formula, Using Built-in Functions, Creation of List.
• Working with Graphs, Using Chart Wizard, Using Logical Functions, Use of Macros, PIVOT Table & Chart Generation

V: Microsoft PowerPoint                                                                    (24 Hours)

• Introduction, uses & features of Microsoft Power point, Presentation tips, components of slide, using templates and wizards, choosing an auto layout, using outlines, adding subheadings, editing text, formatting text, using master slide. Adding slides, changing colour scheme, changing background and shading, adding header and footer, adding clip arts and auto shapes.
• Various presentation, working in slide sorter view (deleting, duplicating, rearranging slides), adding transition and animations to slide show, inserting music or sound on a slide, inserting action buttons or hyperlinks for a presentation, set and rehearse slide timings, viewing slide show, Printing slides.

VI:Internet                                                                                          (10 Hours)

• Internet Communication Protocols, Types of Internet Connections, ISPs, Domain Name System, Intranets, Email Concepts (receiving, sending, addressing, downloading, formatting, sending attachment).
• Sending & Receiving Secure Email, chatting, conferencing, Email mailing list, Newsgroup, IRC, ICQ, Video mail and Video Conferencing.