This Course is useful to students with adequate working knowledge of office automation tools - the primary requirement in today’s computerized office environment.
Microsoft Office is an integration of programmes, servers and services. MS Excel is used for analysis and calculation purposes, MS PowerPoint for preparing presentations, while MS Outlook is used for communication.
SALIENT FEATURES
Perform complex calculations efficiently using various functions in Excel
Organise and analyse large volumes of data
Create MIS reports
Consolidate and manage data from multiple workbooks
Create simple as well as sophisticated presentations
Format the presentations and templates for the desired appearance
Microsoft Word produce professionals looking documents by providing a comprehensive set of tools for creating and formatting your documents in user interface. It also having the features of advanced data integration ensures that documents stay connected to importance source of business information
SALIENT FEATURES
ABC's of MS Word
Crating Text and Documents
Different views of documents - Book Marks, Annotations, AutoCorrect Heading and Footer controls
Excel is an electronic spreadsheet that enables you to create worksheets for data entry, make calculations and manage a database. Excel is also a useful tool when preparing graphs detailing the results of calculations. Excel supports many types of financial, statistical and logical calculations. Excel is easy to use; it has helpful tools that effectively and quickly perform calculations that may have seemed impossible.
SALIENT FEATURES
Import data and text files from external sources
Query data from the web
Create and apply templates and styles
Use different tools like Goal Seek, Solver, etc to analyse data
Work with Macros
Use digital signatures to protect workbooks and worksheets
Configure and customise Excel
Work with shared workbooks
Consolidate and manage data from multiple documents
Microsoft PowerPoint allows you to develop computer-based presentations. It allows construction of presentations from scratch or by using the easy-to-use wizard.
C is designed to provide high-level abstracts for all the native features of a general-purpose CPU, while at the same time allowing modularization, structure, and code re-use. It is intended use as a portable systems implementation language C has also been widely used to implement end-user applications, but as applications became larger, much of that development shifted to other languages.
In Object Oriented Programming Inheritance is the process by which objects of one class acquire the properties and functionality of objects of another class. It supports the concept of hierarchical classification. Class inheritance is not just about reusing the classes at many locations, it also adds enormous flexibility to the way in which one can program his application. The object-oriented programming approach focuses on objects as the basis for application building. Objects are instances of classes, which contain a description of related data and procedures.
Java is an object-oriented language similar to C++, but simplified to eliminate language features that cause common programming errors. Java is a general purpose programming language with a number of features that make the language well suited for use on the World Wide Web. Small Java applications are called Java applets can be run on your computer.
The Java 2 Enterprise Edition includes features and services that are available as resources to all J2EE applications and modules. The Sun Open Net Environment Application Server 7, a J2EE 1.3 compliant server, provides access to these resources.
SALIENT FEATURES
Overview of J2EE
JDBC
Web Applications
Servlets
Model View Controller
RMI
Introduction to Java RMI
Create distributed applications using RMI
Implementations of Interfaces
Architecture of RMI
Advanced Concepts in RMI
JAVA Servlets
Introduction to Servlets
SSI, JDBC, Applets
Implement various Session Management techniques
Implement Inter Servlet Communication
Handle Errors and Exceptions in Servlet Application
Advanced features of Servlets
JAVA Beans
Introduction to Java Beans
Creating Java Bean Component
Reflection and Introspection
Manipulating Bean Properties
Event Handling
Property Editors and Customizers
Implement Java Beans in JSP
Advanced features of Beans
EJB
Introduction to J2EE and EJB
Create Home,remote and local interface of an EJB
Create deployment descriptor of an EJB
Define Session beans and identify its different types
Create ,deploy and access a stateless and statefull Session Bean
Define Entity Beans and identify their different types
Create, deploy and access a Bean Managed persistence entity bean
Define Container Managed Relationship (CMR)
Implement CMR in a CMP entity bean
Describe EJB QL
JSP
Introduction to JSP
Objects, Actions and Components
Develop JSP Applications
Define and implement Common JSP Tasks and Custom Tags
The .NET framework takes the class library concept a step further by supporting it across any language and extensible for future platform variances. Now BCL-supported features such as remoting, string manipulation, exception handling, and collection management construct is the same from any language conforming to the CLI.
Introduction to Dot Net
Overview of Dot Net
Features of Dot Net
OOPS Concepts
Class and Objects
Inheritance
Polymorphism and Encapsulation
Garbage Collection
Global Cache
C# Language
Introduction to the C# Language
Language Fundamentals
Exception Handling
IO Streams
Arrays & Collections
Delegates & Events
Developing C# Classes
Interconnecting Objects
Simplying component development
Implementing and enhancing C# Solutions
Windows Applications
Class Library
Versioning
Interoperability
Assemblies and Manifests
ADO.NET, COM and Web Services
ASP.NET
Create user service
Consume and manipulate data using ADO.Net
Test and debug an ASP.Net application
Create and manage components and .Net assemblies
Optimize an ASP.Net application
Create accessible Web application
Create locale aware Web applications
Manage state of an ASP.Net application
Configure and secure an ASP.Net application
Deploy a Web appication
ADO.NET
Introduction to ADO.NET
Datasets
Data Views and Exceptions
Building application with connected model
Returning disconnected data
Data Binding
XML
Create a well formed XML documents Using XMl
schemas to define the structure of XML documents
Using DTD to define XML documents
Creating XML documents and validating them against a DTD
Using XMl schemas to define the structure of XML documents
Creating XML documents and validating them against an XMl schema
Using XSL to transform XML documents and presenting the data in a Web browser
Using JavaScript and XML Document Object Model to access and manipulate data present in an XMl document
Using SQL Server 2000 to generate XML documents
Course Features
Dedicated internet facility to clarify doubts through online searching
Placement Assistance
Personality development program includes workplace skills. Here the focus is on developing soft skills such as communication, personality development & team work.