MFA-107 Information Technology Management Notes for GGSIPU MBA FA Sem 1 - cover image
Notes MFA 107

MFA-107 Information Technology Management Notes for GGSIPU MBA FA Sem 1

Programme
Master of Business Administration

MFA-107 Information Technology Management Notes cover all 4 units of the GGSIPU MBA (Financial Analysis) Semester 1 paper in a 62-page printed book: 40 figures, 11 worked SQL, Excel and HTML examples, 2 case studies and 87 exam questions. They follow the MBA (FA) scheme and syllabus applicable from the 2021-22 session.

Written by Prateek Talwar, Founder, Unnati Educations · Reviewed by Ritik Rawat, B.Tech, Senior Full Stack Developer · Checked against MBA (FA) Scheme and Syllabus 2021-22 onwards (ipu.ac.in) · Updated 14 October 2026 · Editorial policy

Scheme: MBA (Financial Analysis) Scheme and Syllabus, 2021-22 onwards | Applies to: w.e.f. 2021-22 academic session | Verified against: nt0722536 (9).pdf on ipu.ac.in, 14 October 2026

MFA-107 Information Technology Management at a glance: GGSIPU MBA FA Sem 1 credits, units and exam pattern

MFA-107 is the only skill enhancement theory paper in GGSIPU MBA (FA) Semester 1. It sits with eight other GGSIPU MBA FA Semester 1 papers.

MFA-107 snapshot from the official MBA (FA) scheme and syllabus
Code and titleMFA-107 Information Technology Management
Course and semesterMBA (Financial Analysis), Semester 1
Category and creditsSkill Enhancement · L-3, no T/P · 3 credits
Marks100: 50 internal (Class Test I 15, Class Test II 15, assignments or viva 20) + 50 end-term
Applies toMBA (FA) scheme w.e.f. 2021-22 session
End-term patternUniversity written exam, 50 marks; paper-setter instructions not printed in the official PDF
Units4 units, 42 hours (6 + 14 + 12 + 10)
Paired labMFA-119 IT Management Lab · Skill Enhancement · T/P-2 · 1 credit · 40 internal + 60 external
View complete table: MFA-107 snapshot from the official MBA (FA) scheme and syllabus

This view preserves the original alignment. Scroll within it if needed to read the complete content.

MFA-107 snapshot from the official MBA (FA) scheme and syllabus
Code and titleMFA-107 Information Technology Management
Course and semesterMBA (Financial Analysis), Semester 1
Category and creditsSkill Enhancement · L-3, no T/P · 3 credits
Marks100: 50 internal (Class Test I 15, Class Test II 15, assignments or viva 20) + 50 end-term
Applies toMBA (FA) scheme w.e.f. 2021-22 session
End-term patternUniversity written exam, 50 marks; paper-setter instructions not printed in the official PDF
Units4 units, 42 hours (6 + 14 + 12 + 10)
Paired labMFA-119 IT Management Lab · Skill Enhancement · T/P-2 · 1 credit · 40 internal + 60 external

Unit 2 alone carries 14 of the 42 hours. Pass and re-appear rules sit in GGSIPU Ordinance 11.

MFA-107 Information Technology Management Notes unit-wise: 40 figures and 11 worked SQL, Excel and HTML examples across 4 units

These GGSIPU MBA FA Sem 1 Information Technology Management notes follow syllabus order from page 4 to page 61, and each unit ends with a Quick Revision table and exam questions. Notes for the other papers sit under GGSIPU MBA FA notes.

MFA-107 Unit 1: Information Technology

Also covered as "Information Technology, Computer Architecture and Cloud Computing" (pages 4 to 18, 8 sections, 11 figures). It explains the six components of an IT system through an ATM withdrawal, classification of computers, the Von Neumann block diagram and the machine cycle.

Memory types, RAID, NAS and SAN, the NIST cloud model and data centre challenges follow, with a case study on a 2021 stock exchange outage. Exam list: 15 short, 7 long.

Quick look: data centre tiers and yearly downtime (from page 16)
TierDesignUptimeMax. downtime a year
Tier ISingle path99.671%About 28.8 hours
Tier IIN+1 components99.741%About 22 hours
Tier IIIConcurrently maintainable99.982%About 1.6 hours
Tier IVFault tolerant (2N)99.995%About 26 minutes

Quick look: data centre tiers and yearly downtime (from page 16)

Tier
Tier I
Design
Single path
Uptime
99.671%
Max. downtime a year
About 28.8 hours
Tier
Tier II
Design
N+1 components
Uptime
99.741%
Max. downtime a year
About 22 hours
Tier
Tier III
Design
Concurrently maintainable
Uptime
99.982%
Max. downtime a year
About 1.6 hours
Tier
Tier IV
Design
Fault tolerant (2N)
Uptime
99.995%
Max. downtime a year
About 26 minutes

MFA-107 Unit 2: Computer Software

Also covered as "Computer Software, Excel and Database Management" (pages 19 to 34, 10 sections, 10 figures), the longest unit. It covers operating system types, GUI vs CLI, compiler vs interpreter vs assembler and the FRUEMP qualities of good software.

The Excel part gives finance functions, pivot table and Goal Seek steps. The DBMS part runs from file system problems to a banking ER diagram, integrity constraints and 5 SQL code boxes. Exam list: 13 short, 8 long.

Quick look: loan EMI with the Excel PMT function (from page 26)

Loan Rs 10,00,000 at 9% p.a. for 5 years

=PMT(9%/12, 60, -1000000)

-> Rs 20,758 per month
View preformatted content

This view preserves the original alignment. Scroll within it if needed to read the complete content.

Loan Rs 10,00,000 at 9% p.a. for 5 years

=PMT(9%/12, 60, -1000000)

-> Rs 20,758 per month

Rate and term are monthly; the loan is negative so the EMI shows positive.

MFA-107 Unit 3: Data Communication and Networks

Also covered as "Data Communication, Networks and the Internet" (pages 35 to 48, 10 sections, 8 figures). It covers transmission modes, PAN to WAN, guided and unguided media with a VSAT rural banking example, and six topologies with the mesh link formula.

Network devices, Internet vs intranet vs extranet and Web 1.0 to 3.0 follow, then HTML with a mutual fund web page. Exam list: 15 short, 7 long.

Quick look: the basic skeleton of an HTML page (from page 45)

<!DOCTYPE html>

<html>

<head><title>My First Web Page</title></head>

<body><h1>Welcome to ABC Finance Ltd</h1></body>

</html>
View preformatted content

This view preserves the original alignment. Scroll within it if needed to read the complete content.

<!DOCTYPE html>

<html>

<head><title>My First Web Page</title></head>

<body><h1>Welcome to ABC Finance Ltd</h1></body>

</html>

Only content inside <body> shows on screen; <title> shows on the browser tab.

MFA-107 Unit 4: Functional and Enterprise Systems

Also covered as "Functional and Enterprise Systems, Security and Emerging Trends" (pages 49 to 61, 9 sections, 11 figures). It starts with the DIKW hierarchy, types of decisions and the IS pyramid from TPS to ESS.

ERP, SCM and CRM with an NBFC example, the CIA triad, threats, Indian cyber laws, AI, ML and IoT follow, with a case study on an Indian bank. Exam list: 15 short, 7 long.

Quick look: Simon's model applied to rising bad loans (from page 51)

  1. Intelligence: spot rising NPAs in the loan book.
  2. Design: list options such as tighter credit norms or selling bad loans.
  3. Choice: compare them with DSS and what-if analysis.
  4. Implementation and review: act and track results in MIS reports.

MFA-107 exam corner: 58 two-and-a-half-mark and 29 twelve-and-a-half-mark exam questions by unit

Each unit ends with exam questions labelled "2.5 Marks" and "12.5 Marks". The lists print questions only, so you answer them from the topic pages of the same unit.

MFA-107 exam questions and worked examples by unit
UnitShort (2.5 Marks)Long (12.5 Marks)Worked SQL, Excel, HTML
Unit 11570
Unit 21389
Unit 31572
Unit 41570

MFA-107 exam questions and worked examples by unit

Unit
Unit 1
Short (2.5 Marks)
15
Long (12.5 Marks)
7
Worked SQL, Excel, HTML
0
Unit
Unit 2
Short (2.5 Marks)
13
Long (12.5 Marks)
8
Worked SQL, Excel, HTML
9
Unit
Unit 3
Short (2.5 Marks)
15
Long (12.5 Marks)
7
Worked SQL, Excel, HTML
2
Unit
Unit 4
Short (2.5 Marks)
15
Long (12.5 Marks)
7
Worked SQL, Excel, HTML
0

The MFA-107 notes list 58 short-answer and 29 long-answer exam questions across 4 units, plus 11 worked SQL, Excel and HTML examples.

  1. Unit 1 (2.5 Marks): Distinguish between IaaS, PaaS and SaaS. Pointer: rented servers (AWS EC2) vs ready platform (Google App Engine) vs finished app (Gmail). Page 14.
  2. Unit 2 (12.5 Marks): Limits of the file system, how DBMS overcomes them, three-schema architecture. Pointer: redundancy and inconsistency, then ACID and the three levels. Pages 28 to 29.
  3. Unit 3 (2.5 Marks): Distinguish between hub, switch and router. Pointer: layer 1 broadcast, layer 2 MAC unicast, layer 3 IP routing. Page 42.
  4. Unit 4 (2.5 Marks): What is the CIA triad? Pointer: encryption, hashing and audit trails, backup and DR. Page 55.

More practice will sit in the MFA-107 important questions.

How a blockchain transaction works in IT management: excerpt from page 57 of the MFA-107 notes

Excerpt from page 57

Blockchain is listed under emerging trends in Unit 4. Once a transaction is recorded, it cannot be changed without changing every later block and getting the agreement of most of the network. That is why banks and regulators study it for settlement and trade finance.

How a blockchain transaction works

First, A asks to transfer an asset to B. The request is broadcast to all nodes in a peer-to-peer network. The nodes then validate it through a consensus method such as Proof of Work or Proof of Stake. Verified transactions are grouped into a block, which is linked to the previous block by its hash. Finally, the ledger updates on every node, so the record becomes permanent and transparent.

Features of blockchain

  • Decentralisation: no single central authority; every node keeps a copy of the ledger.
  • Immutability: recorded data cannot be changed or deleted.
  • Transparency: participants can see transactions, as per their permissions.
  • Security: hashing and digital signatures protect the data.
  • Consensus: nodes must agree before a block is added.
  • Smart contracts: self-executing code runs automatically when conditions are met.

Types of blockchain

A public blockchain is open to anyone, as with Bitcoin and Ethereum. A private blockchain is controlled by one organisation. A consortium or federated blockchain is run by a group of organisations, such as a set of banks. A hybrid blockchain mixes public and private features.

Where it is used

In banking and payments it supports cross-border payments, faster settlement and KYC sharing among banks. In trade finance it handles digital letters of credit and bills of lading. Capital markets use it for securities settlement and tokenisation, and RBI's e-Rupee (CBDC) pilots use distributed-ledger concepts. Supply chains, insurance claims through smart contracts and government land records are other uses.

Limitations

Proof of Work uses a lot of energy. Speed and scale are limited, regulation is still unclear, errors cannot be reversed and skilled professionals are scarce.

Do the MFA-107 notes cover the full GGSIPU syllabus?

Yes. Every topic in the four official GGSIPU MFA-107 units has a section in the notes. The notes use longer unit titles that name the same topics.

Official MFA-107 topics mapped to the notes
Official unitOfficial topicsWhere in the notesStatus
Unit I: Information TechnologyIT system components, computers, architecture, memory, storage, mass storage, cloud computing, data centresSections 1 to 8, p4 to p17Covered
Unit II: Computer SoftwareSoftware types, OS, GUI, translators, languages, good software, trends, spreadsheet, presentation, Excel analysis, DBMS, data models, ER, integrity constraints, SQLSections 1 to 10, p19 to p33Covered
Unit III: Data Communication and NetworksData communication, network types, media, topologies, OSI model, devices, Internet, intranet, extranet, WWW, HTMLSections 1 to 10, p35 to p46Covered
Unit IV: Functional and Enterprise SystemsData, information, knowledge, decision making, information systems, security, blockchain, AI, ML, IoTSections 1 to 9, p49 to p60Covered

Official MFA-107 topics mapped to the notes

Official unit
Unit I: Information Technology
Official topics
IT system components, computers, architecture, memory, storage, mass storage, cloud computing, data centres
Where in the notes
Sections 1 to 8, p4 to p17
Status
Covered
Official unit
Unit II: Computer Software
Official topics
Software types, OS, GUI, translators, languages, good software, trends, spreadsheet, presentation, Excel analysis, DBMS, data models, ER, integrity constraints, SQL
Where in the notes
Sections 1 to 10, p19 to p33
Status
Covered
Official unit
Unit III: Data Communication and Networks
Official topics
Data communication, network types, media, topologies, OSI model, devices, Internet, intranet, extranet, WWW, HTML
Where in the notes
Sections 1 to 10, p35 to p46
Status
Covered
Official unit
Unit IV: Functional and Enterprise Systems
Official topics
Data, information, knowledge, decision making, information systems, security, blockchain, AI, ML, IoT
Where in the notes
Sections 1 to 9, p49 to p60
Status
Covered

Official source: MBA (Financial Analysis) Scheme and Syllabus, 2021-22 onwards (MFA-107 on PDF page 14).

These MFA-107 IT Management IPU notes also add normalisation and the TCP/IP model. Every course in GGSIPU notes is mapped to its official PDF this way.

Who writes and checks the MFA-107 IT Management notes?

  • Prateek Talwar, author. Founder, Unnati Educations; Associate Company Secretary (ACS), ICSI, membership no. 58704, since 15 May 2019; B.Com, University of Delhi (SOL), 2012. He wrote the finance angle: UPI, NSE and NBFC examples. Author profile
  • Ritik Rawat, subject reviewer. Senior Full Stack Developer, Unnati Educations; B.Tech. He checked SQL syntax, HTML tags, OSI layers and memory types. Reviewer profile

The 2026-27 edition (62 pages) is mapped to the MBA (FA) 2021-22 scheme, last updated 14 October 2026, under our editorial policy. The same team prepares GGSIPU important questions for every course.

MFA-107 and the MFA-119 IT Management lab (1 credit), plus other GGSIPU MBA FA Sem 1 papers

Paired lab: MFA-119 IT Management lab notes. The official syllabus bases this 1-credit lab on MFA-107. Theory units feed it like this:

  • Unit 2 operating systems → OS utilities.
  • Unit 2 SQL (pages 31 to 33) → SQL query exercises.
  • Unit 2 Excel (pages 25 to 27) → What-If, Goal Seek, Solver and pivot tables.
  • Unit 3 HTML (pages 44 to 46) → web pages with basic tags.

Other Semester 1 papers: MFA-101 Accounting for Management, MFA-103 Quantitative Techniques, MFA-105 Managerial Economics, MFA-109 Personal Finance, MFA-111 Financial Markets and Institutions, MFA-113 Management Process and Organizational Behaviour, MFA-115 Legal Aspects of Business, MFA-117 Communication in Organizations.

How to write MFA-107 answers: SQL queries, HTML code, labelled diagrams and twelve-and-a-half-mark theory answers

For 2.5 marks, name every point with one example; the page 5 tip asks for all six IT system components with one example each. For 12.5 marks, add a diagram (Von Neumann block, OSI layers, IS pyramid) and a banking case.

The page 56 tip gives a security answer frame: meaning, CIA triad, 8 threats, controls, Indian cyber laws. For mesh topology, links = n(n − 1)/2, so 6 branches need 15 links (page 40).

Worked example: SQL question from the Unit 2 list

Display employees earning more than ₹50,000, highest salary first. Per the page 33 tip, state the table, use capital keywords and end with a semicolon.

-- Assumed table: Employee(EmpID, Name, Dept, Salary)

SELECT EmpID, Name, Salary

FROM Employee

WHERE Salary > 50000

ORDER BY Salary DESC;
View preformatted content

This view preserves the original alignment. Scroll within it if needed to read the complete content.

-- Assumed table: Employee(EmpID, Name, Dept, Salary)

SELECT EmpID, Name, Salary

FROM Employee

WHERE Salary > 50000

ORDER BY Salary DESC;

Explain WHERE and ORDER BY ... DESC in one line. Practise this across papers on GGSIPU MBA FA important questions.

MFA-107 IT Management notes FAQs

How do I get the full MFA-107 notes?

Message Unnati Educations on WhatsApp at 9899436384 and mention MFA-107. The full notes are sold as a printed book only; there is no PDF edition. Delivery takes a maximum of 5 to 7 days, and the exact time depends on your location.

Is MFA-107 a theory paper, and how is it linked to MFA-119?

MFA-107 is a 3-credit skill enhancement theory paper with a written end-term exam. MFA-119 is its separate 1-credit lab, which the official syllabus bases on MFA-107: operating system utilities, SQL queries, basic HTML and Excel tools such as Goal Seek, Solver and pivot tables. Units 2 and 3 of the MFA-107 notes prepare you for most of that lab work.

Which MFA-107 unit should I revise most?

Unit 2. The official syllabus gives it 14 of the 42 teaching hours, and the MFA-107 notes give it 16 pages, 10 figures, 5 SQL code boxes, an Excel formula box and 3 Excel step guides. It covers software, operating systems, Excel analysis, DBMS, ER modeling and SQL. Start there, then move to Unit 3 on networks and HTML.

What are the passing marks for MFA-107?

MFA-107 is marked out of 100: 50 internal (two class tests of 15 marks and 20 marks for assignments, presentations or viva) and 50 for the University end-term exam. The MBA (FA) scheme PDF does not print a pass percentage for individual papers. Minimum marks and re-appear rules are governed by GGSIPU Ordinance 11 on ipu.ac.in.

Are the MFA-107 notes written for finance students or computer students?

For MBA (FA) students, many of whom have no computer science background. Technical terms are explained in plain English, and examples come from finance: UPI and ATM transactions, a stock exchange outage, a mutual fund web page, EMI and NPV in Excel and an NBFC using ERP and CRM. Ritik Rawat, a B.Tech developer, checked the MFA-107 technical content.

Do the MFA-107 notes give answers to the exam questions?

The MFA-107 notes list 87 exam questions at the end of the units, but the lists print questions only, not model answers. Each question is answered by a topic section in the same unit, for example the RAID question by the RAID table on page 12. Exam tips in each unit show how to frame 2.5-mark and 12.5-mark answers.

Get the full MFA-107 Information Technology Management Notes on WhatsApp

These are Information Technology Management notes in English, printed as a 62-page book.

MFA-107 printed notes: pages and content per unit
UnitPagesFiguresExam questions
Unit I15 (p4 to p18)1122
Unit II16 (p19 to p34)1021
Unit III14 (p35 to p48)822
Unit IV13 (p49 to p61)1122

MFA-107 printed notes: pages and content per unit

Unit
Unit I
Pages
15 (p4 to p18)
Figures
11
Exam questions
22
Unit
Unit II
Pages
16 (p19 to p34)
Figures
10
Exam questions
21
Unit
Unit III
Pages
14 (p35 to p48)
Figures
8
Exam questions
22
Unit
Unit IV
Pages
13 (p49 to p61)
Figures
11
Exam questions
22

Printed book only, no PDF edition. Delivery: maximum 5 to 7 days; the rest depends on your location.

Order the MFA-107 printed notes on WhatsApp (4 units, 62 pages)

Unnati Educations is an independent education provider based in Vikaspuri, Delhi. We are not affiliated with, authorised by, or endorsed by Guru Gobind Singh Indraprastha University (GGSIPU). 'GGSIPU' and 'IPU' are used only to describe the syllabus our notes follow. For official information, visit ipu.ac.in.

Ready for the full notes?

Discuss coverage and delivery with our team.