DIU-BLC
Management Information System (LAB), Spring-2024
0%
Previous
Course data
General
Management Information Systems (LAB)
Chapter 1 : Foundational Spreadsheet Skills
Learning Objectives
Learning Outcomes
Learning Contents
What functions have you learned from this class?
Conditional Formatting
Lesson 2
Range Name
Lesson 3 :IF Statement
IF statement
Class Practice File
Lab Assessment IF Statement
Class Practice 2
Lesson 4: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions & The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
SUMIF
Average-IF
Class Practice SUMIF
Class Practice SUMIF AVERAGEIF
Practice Quiz
Lesson 6 : TEXT Function, Dates & Date Function
Practice File
Lesson 5 : Introduction to PivotTables and basic functions
Learning Objectives
Learning Outcomes
Learning Contents
What functions have you learned from this class?
Pivot Table
Pivot Table practice File
Lesson 8: Sensitivity Analysis
Sensitivity Analysis
Class Practice File
Sensitivity Analytics can not accommodate continuous change in data table
Goal Seek
Chapter 3: What If analysis, Goal Seek, and Solver
Learning Objectives
Learning Outcomes
Learning Contents
What functions have you learned from this class?
What-if analysis
Chapter 4 : Excel Add Ins and Extensions
Learning Objectives
Learning Outcomes
Learning Contents
What functions have you learned from this class?
Excel Adds-In
Course Ending Message
DATASET
Scenarios
Guidelines
Report Submission 65 A
File Submission 65 A
File Submission 65 B
Report Submission 65 B
LAB FINAL 65 A
FILE SUBMISSION
Dataset
LAB FINAL 65 B
EXCEL FILE SUBMISSION
DBMS File Submission
DATASET
Next
DIU-BLC
Side panel
Guidelines
For Teachers
For Students
Search
Close
Search
Toggle search input
Log in
Username
Password
Remember username
Forgot Password?
Log in
Create new account
Site Navigation
0611-127 (MI-241)
Home
Skip to main content
Course info
Home
Courses
DIU
Faculty of Business & Entrepreneurship
Business Administration
BA Spring 2024
0611-127 (MI-241)
Summary
Management Information System (LAB), Spring-2024
Teacher:
Maria Islam Roshny
Skill Level
:
Beginner