Class History: Management Information System (Fall 2019)

Course: Management Information System (Fall 2019)

Class 1

September 21, Room: Computer Lab, Time: 18:50 - 20:40

Course overview; system and information system; characteristics of system; cybernetic system; architecture of information system; activities, resources, and components of an information system.

Announcement: MCQ quiz on chapter -1 in the next class.

Class 2

October 5, Room: 603, Time: 18:25 - 20:45

What is software? Application software and system software. General purpose application software, special purpose application software, system management software, and system development software. Commonly used business application software. Email programs, IMAP, and SMTP. Functions of an operating system. EULA and open source software.

1st class test: MCQ quiz.

Class 3

October 12, Room: 602, Time: 18:15 - 20:35

Software suite. Pros and cons of software suite. BIOS and POST.

Network and data communication. How data is sent in a network (postal mail example). The OSI model and its features. Seven layers of the OSI model. The TCP/IP model. Differences between OSI and TCP/IP models. Bandwidth and its measurement units. Calculating download time (math). Finding true bandwidth (math).

Announcement: Class test on the next class. Topic: mathematical problems on bandwidth.

Class 4

October 19, Room: 603, Time: 18:15 - 20:30

Types of network: LAN, WAN, MAN, VPN, network computing, and P2P. Nodes, number of connections, and usefulness of a network. Math: Usefulness of a network. Math: Facebook group members. Governing body of the internet: ICANN and W3C. The last mile problem.

Review of the midterm syllabus.

2nd class test (20:00 - 20:30).

Announcement: Training workshop on Excel, on November 9 at 4:00 PM, in the computer lab.

Midterm Exam

Syllabus: Chapter 1, 2, 3.

Date, time, room: 2019-10-26 @19:00 in 701

Class 5, Class 6 (Extra), Class 7 (Extra)

November 9, Room: Computer lab.

Time: 

16:15 - 18:30 (Class 5)

18:30 - 19:30 (Class 6)

19:30 - 20:20 (Class 7)

Job specification of MIS officer. The basics of Excel formulas.

Training workshop 1: Data analysis with Excel.

Announcement: Class test on Excel formulas in reverse (Topic G of chapter 4), in the next class.

Class 8

November 16, Room: 603, Time: 18:15 - 20:30

Database and DBMS. Necessity of database. Various types of database users. Most popular databases. Database models. Relational database management system.

Class test 3.

Class 9 (Extra)

November 16, Room: 603, Time: 20:30 - 21:10

Structured query language. Block diagram of a typical SQL database system. DDL and DML commands. Data types in SQL. Database IDE: MySQL Workbench and HeidiSQL.

Announcement: 2nd training workshop -- Data retrieval with SQL, on November 21 at 5:50 pm in the computer lab.

Class 10, Class 11 (Extra)

November 21, Room: Computer lab.

Time: 

17:50 - 20:30 (Class 10)

20:30 - 21:30 (Class 11)

Training workshop 2: Data retrieval with SQL.

Announcement: Assignment to be submitted on or before November 30.

Class 12

November 30, Room: 603, Time: 18:30 - 20:45

Efficiency vs. effectiveness. Downsizing. Change management. Planned obsolescence and reality distortion field. Security of password. Security of emails. Social engineering. Spoofing and phishing. DBMS: Question format for final exam.

Class 13

December 7, Room: 602, Time: 18:30 - 20:45

Compiled vs. Interpreted programming language. Why Python? Python vs. Java vs. C. The print function. Variables. The input function. Types of variables and converting from one type to another. Data structure: list, tuple, set, and dictionary. Conditional statements. For loop with range. For loop with list. File handling: reading and writing.

Class 14, Class 15 (Extra)

December 14, Room: Computer Lab, 

Time: 

18:15 - 20:30 (Class 14)

20:30 - 21:30 (Class 15)

Python for business, part 1.

Announcement about the project.

Class 16

December 21, Room: 603, 

Time: 18:45 - 21:00

Python basics: How to build a program that calculates the future value? How to filter values obtained by input function? Creating a menu-based command line interface. Functions. Error handling. Final exam question pattern and marks distribution. Details about the project.

Final Exam

December 28, Room: 301 and 302

Time: 19:00 - 21:00

Syllabus: Chapter 4 - 7.

Related Links