COPA SEM-1

1.Admission and trainee introduction

2.History of Computer

 

3.Fundamentals of Computer

4.Generation of Computer

5.Function of Computer

6.Application of Computer

7.Source Data Input devices

8.Out put Device

9.Computer Hardware

10.Memory Device and flace Memories

11. Introduction to basic DOS Internal and External Commands

12.Secondry memory device, Hard disk

13. Introduction to open source software

14. Introduction to Linux O.S.

15. Introduction to the various application in office

16. Introduction to Word features

17.Creating, Saving and formatting and printing Documents using word

18.Working with inserting objects,macro, mail merge, templates and other tools in word

19.Page set up and printing document using Word

20. Introduction to Excel features and Data Types

21. Cell referencing useof functions ofvarious categories,linking sheets

22. Concept of Sorting,Filtering and Validating Data

23.Analyzing data using charts, data tables, pivot tables,goal seeking and scenarios

24. Introduction to open office and power point

25. Creating Slide Show,fine tuning the presentation and good presentation practice

26.Concepts of Data, Information and Databases

27.Overview of popular databases RDBMS,OODB AND MUSQL

28.Rules for designing good tables. Integrity rules and constraints in a table

29.Introduction to various types of Queries and their uses

30. Designing Access reports and Forms

31.Concept of ISO- ISO 7 Layer model

32.Overview of various network protocols,logical and Physical addresses, classes of networks

33. NETWORK Security,firewall and DHCP Server concepts

34. Internet Concept

35. Concept of site and pages

36. Introduction to open source CMS viz,Joomla,Wordpress etc. and Web authoring tools viz. Kompozer, Frontpage etc.