Diploma in Office Automation

School of Engineering & Technology has introduced entrepreneurship / job-oriented skill development courses. There are total of five modules:

Automation: MS Office-Word, Excel, PowerPoint, Access & Networking.
Hardware Engineering
RDBMS
Web Development
Training

Introduction

This course deals with office automation and its allied areas. The main aim of this course is to develop relevant skills in candidates related to computer application, office management practices, and office automation techniques.
In simple terms, office automation deals with day-to-day office work/tasks and ways to automate and simplify these tasks. An office consists of different types of professionals. Different types of tasks are carried out in an office each day. Computer work, file management, material management – these are some such important tasks.
Office automation deals with automating and simplifying these tasks through relevant software. For example – office work can be automated and made easier through relevant software such as – MS Excel, Word and Google Docs, etc.
Similarly, data entry work can be carried out through word processing software such as MS Word, Rich Text Editor, or Text Editor. In short, office automation primarily deals with computer applications and software. The main aim of office automation is to simplify and automate workflow in an office. It can help improve the efficiency of workers in an office.
Computer Hardware Fundamentals training deliver the fundamentals of component-level knowledge along with the assembly of computer, troubleshooting, networking, and software installation.
Students will explore the concepts of relational databases like design, implementation, and utilization of database management systems, understanding of the role of the Structured Query Language (SQL).
Web Development training delivers the fundamentals of the front end of web applications using HTML and CSS along with the server-side technologies using PHP and MySQL. Students will explore the concepts of security over the web applications that let them secure their applications from various network attacks. The websites are required to be scaled up in case of high load; in that case, the process of migrating to the cloud for quick scaling up and down is introduced to the students.

Objectives

The students will be able to know the concepts of Office Automation program and its allied areas such as Operating System, basic computer application, components of a computer system, word processing/data entry, relevant software, Tally, MS Office, Internet Technology (ISPs, networks, e-mail), PC hardware, hardware installation, configuration, computer assembling, maintenance, and troubleshooting. This course will also provide the knowledge of networking and software installation, the hierarchy of data, E-R Diagram & Enhance E-R Diagram, database structures, the difference between a database & a database management system, understanding of database concept, understanding of the concept of Relational Algebra, structured query language, and query-by-example, understand the concept of concurrency control, understanding of current Web Technologies & their applications, hands-on practice of various web technologies for front end & back end to create useful applications, to teach students how they can begin a web project to contribute to and improve the aspects of the software that they feel are wrong. Students will also learn about some important web tools & techniques for contributing to projects and how to set up their web applications.

Collaborations

Eligibility

10 + 2 & basic knowledge of English

Duration

12 months

Fee and Scholarships (2022-23)

Rs 40000/-

Course Outline

Click here for detailed course outline

Skill Component	Contents/ Learning Domain
Automation	Introduction to Computer, History, Characteristics, Components. Concepts of Hardware and Software Representation of Data/Information. Concept of Data Processing. Applications of IECT: e-governance & Multimedia and Entertainment. Introduction to GUI Based Operating System. Basics of WINDOWS. The User Interface. File and Directory Management. Elements of Word Processing. Text Creation and Manipulation. Text Formatting - Paragraph Indenting. Bullets and Numbering, Changing case. Macros. Table Manipulation: Draw Table, Changing Cell Width and Height, Alignment of Text in Cell, Delete / Insertion of Row and Column, Border and Shading. Cross Reference, Table of Contents. Mail Merge. Spread Sheet Elements. Manipulation of Cells: Entering Text, Numbers and Dates, Creating Text, Number and Date Series, Editing Worksheet Data, Inserting and Deleting Rows, Column, Changing Cell Height and Width. Using Formulas. Working with Function and Charts. Advanced Filter, Comments, Protecting Worksheet. PowerPoint Presentations: Creation of Presentation, Preparation of Slides. Transition and Slide Timing and Automating a Slide Show. Basics of Computer Networks. Services on Internet. ISPs and examples (Broadband/Dialup/WiFi). TCP/IP and OSI layers. WWW, Web Browser and Search Engines. Basics of E-mail. Opening Email Client. Mailbox: Inbox and Outbox. Instant Messaging and Collaboration. Soft Skills: Personality Development. Writing Skills, File Handling.
Hardware Engineering	Introduction to PC Hardware Hardware Installation and Configuration PC Debugging, Troubleshooting and Maintenance Software Installation and Configuration Networking Basic and Configuration
RDBMS	Introduction, Database & Database Users, Characteristics of the Database, Data Models, Schemas & Instances, DBMS Architecture & Data Independence, Database Languages & Interfaces, Entity-Relationship & Enhanced E-R Concepts, Overview of DBMS. Relational Model Concepts & Constraints, Relational Algebra Concepts & Constraints, SQL- Data Definition in SQL, View and Queries in SQL, specifying Constraints And Indexes in SQL. Normalization for Relational Databases, Functional Dependencies, Normal Forms based on Primary Keys, (1NF, 2NF, 3NF & BCNF), Lossless Join and Dependency Preserving Decomposition (4NF, 5NF), Domain Key Normal Form Retrieve Data using the SQL SELECT Statement Table Creation, Alter, Modify the Table. Insert Values into the Table Table Creation with key Constraints Invoke Column aliases Generate a Report of Data from the Output of a Basic SELECT Statement Concatenation Operator, Literal Character Strings, Alternative Quote Operator, and the DISTINCT Keyword Use Arithmetic Expressions and NULL Values in the SELECT Statement Write the Queries for Data Definition and Data Manipulation Language Write SQL Queries using Logical Operations (=, <, >, etc.) Write SQL Queries using SQL Operators: Use the ORDER BY Clause in Set Operations Describe the UNION, UNION ALL, INTERSECT, and MINUS Operators Write SQL Query using Character, Number, Date and Aggregated Data Using the Group Functions Write SQL Queries for Extracting Data from more than One Table Write SQL Queries for Sub Queries, Nested Queries Project (Group Based) Case Studies
Web Development	Introduction, Course Organization, Cascading Style Sheets, URLs and Links, The Ruby Language Rails Introduction, Introduction to SQL, Active Record, HTTP and HTTPS Cookies and Sessions, Forms, JavaScript, The Document Object Model, Events, AJAX Network Attacks, Session Attacks, Isolation, Code Injection, Phishing Attacks Large-Scale Applications, Data-centers
Training	One Month Training in Industry

Career Prospects

After completion of this course, students will be able to find an entry-level job at places that require computer operators, office workers, receptionists, front office operators, etc. Some of the popular recruiters include MNCs, business firms, hospitality firms, etc. In these places, they may work in the following roles –