Management Information System (MIS)
Duration : 6 Months / Type : Diploma / Mode : Part Time
Objective The objective of the course is to enable a student to acquire the advance knowledge pertaining to Management Information System (MIS). DICS Computer Institute is the best computer institute in delhi for Management Information System (MIS) course.
Eligibility/Prerequisite Basic Computer Concepts
Course Structure & Syallabus for MIS Course in Delhi
Advance Excel
- Lookup and Reference Functions – MATCH(),INDEX(),Combine VLOOKUP() & MATCH()
- Financial Functions – PMT(),IPMT(),FV(),PV(),NPV(),Combine PV() & NPV()
- Text Functions- LEFT(), RIGHT(), MID(), FIND(), LEN(), VALUE(), CONCATENATE(), TEXT(), TRIM(), Text Joins, Combining Text Functions
- Information Functions- Displaying Errors, Error Trapping, Combining IF,ERROR AND VLOOKUP Functions
- Advance Database Features- Advanced Filter, Nested Subtotals, Further Features of PIVOT Tables.
- Data Validations – Overview and Restriction of Use, Validation Criteria, Input & Error Alerts,, Find Validated Cells, Extend Validation Settings, Remove Validation Settings
- Worksheet Protection– Locking and Hiding Cells, Protecting a Worksheet, Removing Protection
- Data Analysis Tools – Goal Seek, Scenario
- Customizing Excel – Custom Views, Custom Formats, Conditional Formatting
- Templates – Create and Delete Custom Templates, Create a Custom Template Directory, Open a Workbook based on Template
- Styles –Create Custom Styles, Modify Existing Styles, Merge Styles, Create a Template with Custom Style
Structured Query Language (SQL)
- Introduction to SQL
- SQL DDL Commands - CREATE, ALTER, DESCRIBE, and DROP
- SQL DML Command - INSERT, UPDATE, DELETE, SELECT
- SQL Transaction Command - COMMIT, ROLLBACK
- Sorting & Filtering Data
- Grouping Data
- Nested Query
- Joining Tables
- Managing Tables
- Create and Use Views
- Stored Procedure & Functions
- Creating & Using Cursors and Triggers
Visual Basic for Application (VBA)
- Introduction to VBA - How to use Visual Basic Editor (VBE)? ,The Excel Macro Recorder
- Excel Objects- Introduction to Object, Properties & Methods, Using Input box & Message box, Sheets, Ranges & Offset, Excel VBA Variables
- Conditions & Loops - Using IF Statement in VBA, Using SELECT CASE Statement ,Using Do While Loop & FOR NEXT Loop in Excel
- Functions & Sub routine - Working with User Defined Functions (UDF) ,Theory on Variables, Scoping etc. ,Working With Dates
- Exceptions - Error Handling Methodologies, Worksheet & Workbook Events ,Excel Object Model usage, Learning various ways of referring – Ranges, Sheet & Workbook
- Forms – Introduction to Excel VBA User Form , User Form Order of Events Procedures
- Controls – Filling User Form Control , Filling a List box & Combo box using loops, User Form Multipage Control
- Validations - Validating user input into a user form, Textbox and spin buttons user form controls, Passing user form control values back to a spreadsheet, Passing range values to user form controls, Option buttons and checkboxes user form controls, Finding the active control on a user form
- Array - Method of storing multiple data in Array, Defining holding capacity of an Array, Storing Tabular data in Array
- Chart- Creating Chart in Excel using VBA , Customizing the chart
- PIVOT - Pivot Tables & VBA , Generating Multiple Pivot Table Reports using VBA
- Database
MS-Outlook
- Customize Outlook Settings - Customize the appearance of the program window, Configure program options, Set defaults for outgoing messages, Create and assign automatic signatures, Configure options for multiple accounts
- Automate Outlook - Automatically reply to messages , Automatically process messages, Create and manage Quick Steps
- Print & Save Information in Outlook - View and save messages and attachments , Print Outlook items
- Search in Outlook - Search for items, Use Search Folders
- Manage Messages - Create messages, Create and send messages, Configure message options, Respond to messages, Delegate access
- Format Messages - Format text, Apply themes and styles, Apply styles, Create hyperlinks, Insert images, Manage schedules, Insert memorized content, Insert signatures
- Organize Messages - Categorize messages, Flag messages for follow-up, Manage conversations, Organize messages in folders, Manage junk emails
- Create and Manage Calendar - Configure calendar settings, Work with multiple calendars, Share calendar information
- Create ,Organize and Manage appointments, meetings, and events - Create appointments and events, Create meetings, Manage calendar items, Configure settings for calendar items, Manage meeting options
- Create and manage notes, tasks, and journals - Create tasks, Manage tasks, Create and manage notes, Create journal entries
- Create and manage notes, tasks, and journals - Create tasks, Manage tasks, Create and manage notes, Create journal entries
Career Prospects :-MIS professionals can find the opportunities in any of the following category-
- MIS Specialist
- Data Scientist