Class History: Management Information System (Spring 2019)

http://shahed.link/21931923

Course: Management Information System (Spring 2019)

- Regular classes: 22
- Extra classes: 9
- Total classes: 31

Class 1

January 21, Room: IT Lab, Time 11:20 – 12:30

System and information system. Input, processing, and output. Cybernetic system. Components of a system.

Class 2

January 23, Room: 901, Time 11:15 – 12:20

Information system architecture, resources, and components. Review of chapter-1. Software and BIOS.

Class 3

January 28, Room: IT Lab, Time 11:30 – 12:30

Commercial software and their classifications. General purpose and special purpose application software. System management and system development software. Common business application software.

Class 4

January 30, Room: 901, Time 11:20 – 12:20

Desktop publishing software. Email software, protocols, and features. Software suite. Software license: past vs. present.

Class 5

February 4, Room: IT Lab, Time 11:45 – 12:30

Operating system user interface: GUL and CLI.

Lab test 1: Windows terminal commands:

DIR

DIR /s

DIR /s/b

DIR /s/b > “FileName.txt”

Class 6

February 6, Room: 901, Time 11:45 – 12:30

CLI of the OS. Task management (process, CPU time). Resource management. Virtual memory. Disk management (sectors, clusters, and index of files).

Class 7

February 11, Room: IT Lab, Time 11:45 – 12:40

Open source software.

Lab test 2:

Windows terminal commands:

DIR *.pdf /s/b

DIR *.pdf /s/b > “FileName.txt”

Moving to a drive: (such as, C:, D)

CD “FolderName”

Batch File concept (FileListCreator.BAT):

CD “Program Files”

DIR *.exe /s/b > “FileName.txt”

Class 8

February 13, Room: 902, Time 11:20 – 12:20

Efficiency vs. effectiveness. Downsizing. Change management.

Class 9

February 18, Room: IT Lab

Lab test 3: Creating a batch file to perform a series of tasks (copying all files of a specific type from the source to the destination folder, and then creating a list of copied files).

Class 10

February 20, Room: 902, Time 11:40 – 13:10

Reality distortion field and planned obsolescence. Planned obsolescence vs. functional obsolescence. How to protect yourself and your organization from reality distortion field?

Midterm Exam

February 25, Room B2-304/305, Time 12:00 PM

Syllabus: Chapter 1, 2, 3.

Class 11

March 11, Room: IT lab, Time 11:30 – 12:30

Network and networking. Full vs. half duplex network. LAN, WAN, MAN, network computer, and peer to peer network. Torrent.

Class 12

March 13, Room: 901, Time 11:20 – 12:25

Internet and intranet. ICANN, W3C. Nodes. Usefulness of a network (math 1).

ANNOUNCEMENT: New CR is Most Rupally Parvin.

Class 13

March 18, Room: IT lab, Time 11:10 – 12:35

Math: finding the required number of nodes to increase user engagement by two times.

How data is converted into 1s and 0s. The concept of bandwidth, bits, and bps. Relationship between bits and bytes. Relationship among kB, MB, and GB. Relationship among bps, kbps, and mbps.

Math: Calculate the required time to download a 1 GB file through 256 kbps network and 2 mbps network.

Math: it takes 1 hour and 15 minutes to download a 1.5 GB file. Find out the bandwidth of network.

Class 14

March 20, Room: 901, Time 11:15 – 12:30

The last mile problem; IP addresses; static vs. dynamic IP; IXP, NIX, and BDIX.

Announcement: Class test on the mathematical problems of Chapter-4: Next Monday at 2:30 PM.

Class 15, Class 16 (Extra)

March 25, Room: IT Lab

Time 11:15 – 12:30 (Class 15) and 12:15 - 13:30 (Class 16)

Data analysis with Excel. First part of Project-1. Functions covered: countif, sum, if, min, max, average.

Class 17 (Extra)

March 25, Room: IT Lab, Time 14:30 – 16:00

Class test (topic: mathematical problems on Chapter-4).

Class 18

March 27, Room: 901, Time 14:30 – 16:00

Basics of Excel: sorting, filtering, creating chart, linking from another sheet. Functions covered: and, or, not, count. Mathematical operators: addition, subtraction, multiplication, division, and exponent.

Announcement: On Wednesdays, classes will start at 2:20 PM from now on.

Class 19

April 1, Room: IT Lab, Time 11:15 – 12:30

The VLOOKUP function in details. The 2nd part of Project-1 (data analysis) completed.

Class 20

April 3, Room: 901, Time 14:30 - 15:50

How copy-paste changes the cell address in Excel formulas. Concatenation operator in Excel. When to use quotations in formulas. Database and DBMS. Object database and relational database. Structure of a relational database (example: students, parents, and phone tables). DML and DDL.

Class 21

April 8, Room: Computer Lab, Time 11:00 - 12:15

How to protect an Excel spreadsheet. How to make certain cells editable in a protected spreadsheet.

Class 22

April 10, Room: 902, Time 14:30 - 15:50

Why use database (Database vs. file system). Types of database users in terms of interaction with the database.

Class 23 (Extra), Class 24 (Extra)

April 13, Room: Computer lab,

Time 12:15 - 13:30 (Class 23) and 13:30 - 14:45 (Class 24)

Data types in SQL. Importing data from Excel to SQL (1st part of the 4th lab test).

Class 25

April 15, Room: Computer lab, Time 12:00 - 12:40

2nd part of the 4th lab test (Q1 and Q2).

Class 26

April 17, Room: 902, Time 14:40 - 15:55

Most popular database systems. Variants of SQL and their popularity. Components and their connections in a typical SQL database system, DML and DDL. MaridDB installation process explained.

Class 27 (Extra), Class 28 (Extra), Class 29 (Extra)

April 20, Room: Computer lab

Time:

12:30 - 13:45 (Class 27)

13:45 - 15:00 (Class 28)

15:00 - 16:00 (Class 29)

The 4th lab test, problem 3 to 14.

Class 30 (Extra)

April 23, Room: 902

Time: 12:00 - 13:15

CIA triad. How emails really work (from network perspective). Security hazards form emails. Spoofing and phishing. How do cybercriminals steal login info using spoofing and phishing.

Class 31 (Extra)