COURSE OF STUDY FOR PGDCA STUDENT 

[According to Syllabus Choose any 2Core Course FROM 2 GROUP  for your study ]

******************************************************************************************************************************

GROUP A :-* HTML & * MS-ACCESS / *Visual Basic & Oracle / HTML (PROFESSIONAL ) WITH A PROJECT

GROUP B :-* INTERNET & * RETAIL MANAGEMENT / * ODIYA LANGUAGE & *C / TALLY 9 (BASIC)

********************************************************************************************************************************

HTML (Basic) Training :-

Introduction

• The World Wide Web (WWW) and history of HTML

• Hypertext and Hypertext Markup Language

• Why HTML

• Prerequisites

• Objective of this HTML course

HTML Documents

1. Dividing the document into 2 parts. ✔ Headers tags ✔ Body tags

2. Paragraphs

3. Formattings

4. Elements of an HTML Document ✔ Text Elements ✔ Tag Elements

5. Special Character elements

6. Image tags

7. HTML Table tags

8. Lists ✔ Numbered list ✔ Non-Numbered lists ✔ Definition lists

9. Anchor tag, Name tag etc.

10. Hyperlinks - FTP/HTTP/HTTPS

11. Links with images and buttons

12. Links to send email messages

13. Text fonts and styles

14. background colors/images

15. Marquee Behavior

16. Forms related tags (action, method,name,input,submit etc)

HTML  (PROFESSIONAL ) ** FOR APGDCA

OBJECTIVES

This material offers the student the fundamental knowledge of application development for the internet using HTML

• After completing the course, the student should be able to :
• Create an HTML Documents, and establish adequate formatting for presentation purposes
• Import, insert and modify images
• Insert and manipulate tables
• Establish and maintain internal and external link to available resources
• Use special effect to make the expressive, evocative documents
• Insert and manipulate multi-media objects
• Manager forms (Create forms, call programs)

MS-ACCESS 

Course Description:-

Microsoft Access 2010 is an information management tool that allows you to store, report, and analyze information within a relational database.  If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you.   Access  makes it easy to keep track, organize, and sort your data.    It can be the back-end of a business, keeping your records for you.

It is this course's purpose to teach you the important features of Access 2010 and how to use them.  This course was designed for beginners so that even if you've never so much as opened the program before, you can learn how to use it.    Once we cover the basics, we'll move on to advanced features.  If you've used Access before, perhaps prior versions, the first few lessons will be a refresher and introduce you to some of the updates you'll encounter in the newest version of Microsoft Access.  

You'll learn:

• All about databases and how they work
• An understanding of how Access works to make even its complex inner workings seem simple
• How to navigate Access
• How to create tables, forms, reports, and queries
• How to enter criteria into your data
• How to form expressions and create functions
• How to customize the appearance of forms and reports
• How to use Access for home-record keeping or for a business

And much, much more

If you're not familiar with Access 2010, it can be overwhelming.   The program is large and navigating it without any help or experience can seem impossible.   This course takes its time and shows you around Access.   We'll break everything down into small chunks so that Access 2010 is just as easy for the beginner to use as it is someone who's been using it for years.   And if you've used Access before, don't worry.   We have plenty of updates to show you – and a few more things to teach you as well.

Course Topics:-

Lesson 1: Microsoft Access 2010 Introduction

Lesson 2: Access 2010 Requirements and Setup

Lesson 3: About Databases and Normalization

Lesson 4: Access 2010 Database Objects

Lesson 5: Navigating MS Access 2010

Lesson 6: Creating a Database and Adding Tables

Lesson 7: Object Views

Lesson 8: Creating Simple Forms

Lesson 9: Introduction to Controls and Formatting Forms

Lesson 10: Queries

Lesson 11: Using Criteria, Operators, and Wildcards

Lesson 12: Parameter Queries

Lesson 13: Relationships and Joins

Lesson 14: Creating Calculated Expressions

Lesson 15: Summarizing Data

Lesson 16: PivotTables

Lesson 17: PivotCharts

Lesson 18: Reports

Lesson 19: Designing Your Report

Lesson 20: Advanced Formatting for Reports

Lesson 21: Macros

Lesson 22: Printing and Exporting Reports

Lesson 23: Importing and Exporting Data

Learning Outcomes :-

By successfully completing this course, students will be able to:

• Define what MS Access is and why it is useful
• Describe about databases and normalization.
• Summarize database objects.
• Demonstrate navigatipm
• Demonstrate creating a database and adding tables.
• Summarize object views.
• Demonstrate creating simple forms.
• Summarize controls and formatting forms.
• Demonstrate query usage and using criteria, operators, and wildcards.
• Demonstrate parameter queries.
• Demonstrate relationships and joins.
• Demonstrate creating calculated expressions.
• Describe summarizing data.
• Demonstrate pivot tables usage
• Demonstrate designing, creating and printing reports.
• Determine macro usage.
• Summarize importing and exporting data, and
• Demonstrate mastery of lesson content at levels of 70% or higher. 

Retail Management Course of Study

• What is Retail and Retail Management?
• What is Business ? Describe its type.
• What is Marketing & Describe its type.
• Sales Vs. Marketing
• Business Environment Study
• Business Communication Letter.
• Business Data Representation through Graph.
• Tax
• Invoice & Profit
• Business Social Activities   

tally BASIC COURSE OF STUDY:-

Outline Syllabus :-

1.  Accounting Concept

2.  Company Setups & Configuration

3.  Accounts Classification

4.  Basic Inventory in Tally 

5.  Advanced Inventory in Tally 

6.  Advanced Accounting in Tally 

7.  Statutory & Taxation

8.  Payroll

9.  System Administration & Other Utilities

10. Tally.NET & Remote Capabilities

‘C’ Language

1. Introduction of C Language
2. Programme Structure of C
3. Programming in C Language
4. Graphics use in C Language
5. Arrya in C Programming
6. Data Structure in C Language

‘ODIYA’ Language

Typing  Barnabodha , Typing Sentence in Odiya Language. Checking the Correctness of Language Typing. etc