Syllabus of Courses

Advance Basic Of Computer

• Fundamentals of computer
• Parts Identification (Computer Parts like Keyboard, Mouse, CD-ROM, Pen Drive, RAM, CD, DVD, Hard Disk Drive, Solid Disk Drive, Floppy, Motherboard, RAM, Processor, Speaker, Headphone, Mic, Web Camera)
• MS-WORD (Home, Insert , Design, Page Layout, Reference , Mailing, Review, View)
• Tasks of MS- WORD (Letter Formatting, Content of Books, ID Card, Banner Design, Index Page, Resume Formatting, Data Entry Table)
• MS-EXCEL (File, Home, Insert, Page Layout, Formulas, Data, Review, View)
• Tasks of MS-EXCEL (Mark Sheet, Salary Sheet, Electricity Bill, Discount Bill, Product Sale Bill, Pass/Fail Status, Grade, Profit/ Loss, Voting Eligibility, Chart)
• MS-POWERPOINT (Home, Insert, Design, Transition, Animation, Slide Show, Review, View)
• Tasks of MS-POWERPOINT (Cars, Thirsty Crow)
• Internet Accessing (Searching , Email and Online Form Filling)
• Digital Payment Options (Net Banking)

Office Productivity Course

• Advance Basic Syllabus (All)
• Advance MS- WORD (Admission Form, Books Front Page, Business Card Design, Happy Birthday Card, Image Collage, Mailing )
• Advance MS-EXCEL (Pivot Chart, Vlookup Advance, Library Card, Data Validation )
• Advance MS-POWERPOINT (Clock)
• Control Panel (Setting of Keyboard/ Mouse, Date/ Time Change, Font Installation, etc.)
• English Typing
• Digital Payment Options (Paytm , BHIM app)
• Teamviewer, Skype & Whatsapp Web
• Google Services( Drive, Map, Classroom , Calender, etc.)
• Online Services (PAN Card Apply)

Office Automation Course

• Office Productivity Syllabus (All)
• Advance MS- WORD (Newspaper Text Box and News in Column Setting, Create Comparison Chart of Product)
• Advance MS-EXCEL (Salary per Hour, Attendence Salary Sheet, Automatic Invoice, Data Analysis)
• Advance MS-POWERPOINT (Quiz Making)
• HTML (Introduction, Structure, Font Formatting, Table Tag etc.)
• Tasks of HTML (Design Business Card, Table Task, Different Table Layouts, Static Website)
• CSS (Introduction, Selectors, Font Formatting, Buttons, Padding, Margin, Borders)
• Tasks of CSS (Image Gallery, Advance Layouts in CSS, etc.)
• English & Punjabi Typing
• Digital Payment Options (Paypal)
• Online Services (Passport, Driving License Apply)

• Tally 9/Manual A/c’s (Day Book,Cash Book, Ledger,Trail balance)
• Final Accounts
• Trading & Profit & Loss A/c
• Balance Sheet & Annual Reports
• Basic Knowledge of Share , Mutual Funds- PAN Number, Business Accounts
• Data Backup Handling and Transfer