DICS Header Logo

Management Information System (MIS)


Download Syllabus Callback Request

Duration : 6 Months / Type : Certificate / 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
  • MS-Access
    • Examine Database Concepts and Explore The
    • Environment.
    • Design a Sample Database.
    • Build a New Database With Related Tables
    • Sort, Retrieve, Analyze Data
    • Manage the Data in a Table.
    • Table Creation (Designing View, Wizard, Setting Relationship)
    • Query a Database Using Different Methods.
    • Query Management (Designing View, Wizard, Sorting, Applying Condition, Formulas)
    • Query Building [Cross Tab, Unique, Duplicate, Delete, Update, Append and More...]
    • Setting up Relationships
    • Design a Forms & Generate Reports.
    • Form Building: (Designing View & Wizard View)
    • Report & Label Creation (Designing View & Wizard View)
    • Import and Export Data: Different Types Of Data Access Can Import & Export.
  • 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
  • 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
  • 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

Share It