Computer Training Syllabus - Intermediate (50 hrs.) |
||
|
Session No |
Module |
Topics Covered |
|
1. |
Basics | Fundamentals of computers, hardware, software |
| Intorduction to Operating System, booting process, starting of windows and desktop | ||
|
2. |
Win98 | Working with files and folders, search, control panel - mouse, display, task manager, Dos prompt, reboot |
|
3. |
Word | Word screen, typing text, setting fonts, aligning text, paragraph, page setup, saving with password |
|
4. |
Word | Working with thesarus, spell check, change case, bulllets and numbering, borders, columns, tabs |
|
5. |
Word | Working with tables, inserting pictures, autocorrect, header and footers |
|
6. |
Excel | understanding excel screen, Data types, formulas, Autoformat, columns and row settings |
|
7. |
Excel | Formatting the cells,copying formulas, paste special, absolute address, conditional formatting |
|
8. |
Excel | Woking with Database, and dates |
|
9. |
Excel | Woking with mulitple worksheets and files |
|
10. |
Excel | Functions - text, mathematical |
|
11. |
Excel | Functions - stats, logical, date |
|
12. |
Excel | Working with charts, Mail merge |
|
13. |
Access | Introduction to Database, creating the database |
|
14. |
Access | Creating tables in the database, Links, tables manipulations, properties of database structure |
|
15. |
Access | Working with forms, reports, query |
|
16. |
Powerpoint | Creating slides and setting up of slides and finish presentation |
|
17. |
Powerpoint and Networking | Pack and go and other properties, Networking Concepts |
|
18. |
Internet & Frontpage | Working with internet, intro, browser, mails, chatting, Creating simple pages using frontpage |
|
19. |
Frontpage | Enhancing the abilities of the page using front page, including setting up of forms |
|
20. |
Tally | General Discussion on basic Accounts & Accounting Concepts,Computerised Accounting Package Vs Manual Accounting, Intro to TALLY, Creation Of a Company,Groups,Ledgers & Setting Features. |
|
21. |
Tally | Creating Groups,Ledgers,Voucher Types,Stock Group,Stock Items & Units of a case study. |
|
22. |
Tally | Voucher entries (Purchase Order,Purchase & Sales Order). |
|
23. |
Tally | Sales,Payment & Receipt(Using Cost Center) & Contra |
|
24. |
Tally | Adjustment Entries,Closing Stock & Bill of materials(BOM) |
|
25. |
Tally | Reports, backup, restore, export and import of data to a new company & Feed Back. |