ICT 110: IT for Business - Course Materials

Complete course materials for ICT 110 IT for Business including syllabus notes and presentation slides

67 Chapter Notes
41 Slide Decks
13 Video Lessons
2 Podcasts
2 Model Sets

Unit 1: Introduction to Information Technology in Business (6 hours)

1

Overview of Computer System

Summarizes the key concepts of computer systems, focusing on the interaction between hardware, software, and users in a business context.

2

Definition and Scope of IT

Explores the definition of IT and its expansive role in modern organizations, from operational support to strategic enablement.

3

1.3 Role and Importance of IT in Modern Businesses

Analyzes the critical role and importance of IT in modern business, highlighting its impact on efficiency, innovation, and competitiveness.

4

1.4 Key IT Trends Transforming Businesses

Identifies key IT trends such as cloud computing, AI, and IoT that are currently transforming business models and operations.

5

1.5 Overview of IT Applications in Various Business Functions

Overviews the application of IT across various business functions, including marketing, finance, human resources, and supply chain management.

6

1.6 Digital Transformation and Its Impact on Business

Discusses the concept of digital transformation and its profound impact on business strategy, customer experience, and operational agility.

7

1.7 The Future of IT in Business

Speculates on the future of IT in business, considering emerging technologies and their potential to reshape industries.

Unit 2: Computer Hardware (10 hours)

8

2.1 Basic Components: Input, Output, Processing, Storage

Details the four basic functions of a computer system: input, processing, output, and storage, and how they work together.

9

2.2 Types of Computers (Desktops, Laptops, Servers, Mobile Devices)

Categorizes types of computers relevant to business, including desktops, laptops, servers, and mobile devices, based on performance and use case.

10

2.3 Hardware Components

Provides an in-depth look at computer hardware components, explaining the function and importance of the motherboard, CPU, and peripherals.

11

2.4 Central Processing Unit (CPU)

Focuses on the Central Processing Unit (CPU), explaining its architecture, function as the 'brain' of the computer, and performance metrics.

12

2.5 Memory (RAM, ROM)

Distinguishes between RAM (Random Access Memory) and ROM (Read-Only Memory), explaining their roles in computer performance and startup.

13

2.6 Storage Devices (Hard Drives, SSDs, External Storage)

Compares different storage technologies, including Hard Disk Drives (HDDs), Solid State Drives (SSDs), and external storage solutions.

14

2.7 Input and Output Devices (Overview)

Gives an overview of input and output devices, explaining how they facilitate interaction between the user and the computer system.

15

2.7.1 Keystroke Devices

Examines keystroke devices, primarily keyboards, detailing their types, mechanisms, and importance for data entry in business.

16

2.7.2 Touch Devices

Explores touch-based input devices like touchscreens and touchpads, highlighting their intuitive interface and widespread use in modern business.

17

2.7.3 Voice-Controlled Devices

Discusses voice-controlled devices and voice recognition technology, examining their role in hands-free operation and accessibility.

18

2.7.4 Movement-Controlled Devices

Covers movement-controlled input devices, such as motion sensors and gesture recognition systems, and their niche applications.

19

2.7.5 Brain-Computer Interface (BCI)

Introduces Brain-Computer Interfaces (BCI), an emerging technology that allows direct communication between the brain and external devices.

20

2.7.6 Wearables

Examines wearable technology in business, from smartwatches to fitness trackers, and their impact on employee productivity and health monitoring.

21

2.7.7 Haptic Feedback Gloves

Details haptic feedback technology, specifically gloves, and its application in virtual reality training and remote operation.

22

2.7.8 Biosensors

Explains the function of biosensors in capturing biological data and their growing importance in healthcare and security sectors.

23

2.7.9 Data Scanning Devices

Reviews data scanning devices like barcode scanners and RFID readers, essential for inventory management and logistics.

24

2.7.10 Digitizers

Discusses digitizers and graphic tablets, focusing on their use in creative industries and digital signature capture.

25

2.7.11 Microphones

Covers microphones as essential input devices for communication, audio recording, and voice command systems in business.

26

2.7.12 Electronic Cards Based Devices

Examines electronic card readers, including smart cards and magnetic stripe readers, used for secure access and payments.

27

2.7.13 Speech Recognition Devices

Explores speech recognition systems, including voice assistants and dictation software, highlighting their business applications.

28

2.7.14 Vision-Based Devices

Explores vision-based input systems, such as cameras and facial recognition, used for security and user authentication.

29

2.8 Output Devices (Monitors, Printers, Projectors, Audio, Tactile)

Provides an overview of output devices, explaining how they present processed data to users in visual, audio, and physical forms.

Unit 3: Computer Software (8 hours)

30

3.1 Software and its Characteristics

Defines computer software and outlines its key characteristics, distinguishing it from hardware and explaining its intangible nature.

31

3.2 System Software (Operating Systems and Utility software)

Details system software, focusing on operating systems and utilities that manage computer resources and provide a platform for applications.

32

3.3 Application Software (Word Processors, Spreadsheets, Business Applications)

Covers application software types, including general-purpose tools like word processors and spreadsheets, and their business uses.

33

3.4 Application of Software Across Industries

Discusses industry-specific software applications in healthcare, finance, retail, and manufacturing.

34

3.5 Enterprise Software (ERP, CRM, SCM)

Focuses on enterprise software systems like ERP, CRM, and SCM, explaining their role in integrating business processes.

35

3.6 Web Based Software Applications

Discusses web-based applications (SaaS), highlighting their accessibility, scalability, and cost-effectiveness for modern businesses.

36

3.7 Mobile Applications

Explores the mobile app ecosystem, detailing how mobile software enhances customer engagement and employee mobility.

37

3.8 Custom vs. Off-the-Shelf Software

Compares custom (bespoke) software with off-the-shelf solutions, evaluating their pros and cons for different business needs.

38

3.9 Off-the-Shelf Solutions for General Use

Reviews popular off-the-shelf software solutions available for general business functions.

39

3.10 Choosing the Right Software for Business

Provides guidelines and factors to consider when choosing the right software tools for specific business requirements.

40

3.11 Software License Types and Legal Use of Software

Explains different software licensing models (proprietary, open source, subscription) and the legal importance of compliance.

Unit 4: Computer Networks (8 hours)

41

4.1 Introduction to Computer Networks

Introduces the fundamental concepts of computer networks, explaining their purpose and benefits in a business environment.

42

4.2 Basic Elements of a Communication System

Breaks down the basic elements of a communication system: sender, receiver, message, medium, and protocol.

43

4.3 Data Transmission Modes (Simplex, Half Duplex, Full Duplex)

Details data transmission modes (Simplex, Half-Duplex, Full-Duplex), explaining how data flows in different communication setups.

44

4.4 Data Transmission Media

Covers the physical media used for data transmission, including twisted pair, coaxial cable, fiber optics, and wireless channels.

45

4.5 Types of Computer Network (PAN, LAN, CAN, MAN and WAN)

Categorizes networks by geographical scope (PAN, LAN, MAN, WAN) and explains the typical use cases for each type.

46

4.6 Network Topologies

Illustrates various network topologies (bus, star, ring, mesh, tree) and discusses their advantages, disadvantages, and typical use cases.

47

4.7 Introduction to IP Addressing (IPv4, IPv6)

Explains the fundamental concepts of IP addressing, detailing the structure and differences between IPv4 and IPv6 protocols.

48

4.8 Role of IP in Security Networks

Discusses the critical role of IP addresses in network security, including how they are used for identification, access control, and traffic monitoring.

49

4.9 Static and Dynamic IP Addressing

Compares static and dynamic IP addressing, explaining the role of DHCP and when to use each method in a business network.

50

4.10 Securing IP Networks, Firewalls, IPSec and VPNs

Covers essential network security technologies, including firewalls, IPsec, and VPNs, used to protect IP networks from threats.

Unit 5: Database Management System (8 hours)

51

5.1 Introduction to Databases

Introduces the concept of databases, explaining their purpose, structure, and importance in managing large volumes of business data.

52

5.2 Importance of Data in Business Decision Making

Analyzes how data-driven decision-making improves business outcomes, highlighting the value of accurate and timely information.

53

5.3 Types of Data: Structured vs. Unstructured

Differentiates between structured and unstructured data, providing examples of each and discussing the challenges of managing them.

54

5.4 Database Management Systems (DBMS)

Explains the function and architecture of Database Management Systems (DBMS), detailing how they facilitate data creation, retrieval, and management.

55

5.5 Relational Databases (Tables, Queries, Reports)

Focuses on the relational database model, explaining key components like tables, records, fields, and relationships.

56

5.6 Introduction to SQL (Structured Query Language)

Introduces SQL (Structured Query Language) as the standard language for interacting with relational databases, covering basic commands.

57

5.7 Basics of Data Storage and Retrieval

Discusses the fundamental principles of data storage and retrieval, ensuring data is saved securely and accessed efficiently.

58

5.8 Introduction to Big Data and Its Business Applications

Explores the concept of Big Data, its 3Vs (Volume, Velocity, Variety), and how businesses leverage it for strategic advantage.

59

5.9 Data Security and Ethical Considerations

Addresses the critical issues of data security, privacy, and ethics, emphasizing the legal and moral responsibilities of handling data.

Unit 6: Computer Tools in Data Processing and Application (8 hours)

60

6.1 Basics of Data Analysis (Spreadsheets, Power BI)

Introduces basic data analysis techniques using widely used tools like Microsoft Excel and Power BI for business intelligence.

61

6.2 Data Visualization (Charts, Graphs, Scatter Plots)

Covers the principles of effective data visualization, demonstrating how to use different chart types to communicate insights clearly.

62

6.3 Collaboration Tools (Google Workspace, Microsoft Teams)

Reviews major collaboration platforms like Google Workspace and Microsoft Teams, highlighting features that enhance teamwork and communication.

63

6.4 Using Computer Tools for Business Scenarios (Overview)

Provides an overview of how various computer tools are applied in real-world business scenarios to solve problems and improve efficiency.

64

6.4.1 Tools for Creating Business Reports and Summaries

Discusses software tools designed for creating professional business reports and summaries, essential for communication and documentation.

65

6.4.2 Tools for Financial Data Analysis and Business Analytics

Examines specialized tools for financial analysis and business analytics, enabling organizations to monitor performance and forecast trends.

66

6.4.3 Tools for Market Trends Analysis and Visualization

Focuses on tools used for analyzing market trends and visualizing complex market data to support strategic planning.

67

6.4.4 Tools for Scheduling and Monitoring

Details tools for project scheduling and performance monitoring, helping businesses manage time and resources effectively.

Unit 1: Introduction to Information Technology in Business (6 hours)

Overview of Computer System

Introduces computer system components and functions, analyzing their role in supporting key business operations.

Definition and Scope of IT

Defines IT and its core components, analyzing its scope from transforming raw data to enabling strategic business decisions.

Role and Importance of IT in Modern Businesses

Examine how IT serves as a strategic asset, driving efficiency and innovation across key business functions like finance, HR, and marketing.

Key IT Trends Transforming Businesses

Examine major IT trends and their strategic impact on business functions and competitive advantage.

IT Applications in Business Functions

Analyze how IT applications in Finance, HR, and Operations drive efficiency, better decision-making, and strategic business advantage.

Digital Transformation & The Future of IT

Comprehensive analysis of Digital Transformation, emerging IT trends (AI, IoT, Big Data, Blockchain), and their strategic impact on business.

Unit 2: Computer Hardware (10 hours)

Basic Components and Types of Computers

Explores the fundamental components of computer systems and categorizes different types of computers used in business environments.

Hardware Components and CPU

Details the internal hardware components of a computer, focusing on the Central Processing Unit (CPU) and its role in processing data.

Memory and Storage Devices

Examines memory hierarchy and various storage devices, distinguishing between volatile RAM and non-volatile storage solutions.

Input Devices: Keystroke and Touch

Covers primary input devices including keyboards and touch interfaces, explaining their applications in modern business operations.

Input Devices: Voice and Movement Control

Discusses advanced input technologies such as voice recognition and motion control systems for hands-free business interaction.

Input Devices: BCI, Wearables, and Haptics

Explores emerging input technologies including Brain-Computer Interfaces (BCI), wearable devices, and haptic feedback systems.

Input Devices: Biosensors, Scanners, and Digitizers

Reviews data capture technologies like biosensors, scanners, and digitizers used for converting physical data into digital formats.

Input Devices: Microphones, Cards, Speech, and Vision

Focuses on audio and visual input devices, including microphones, smart cards, and computer vision systems for automated data entry.

Output Devices: Monitors, Printers, and Projectors

Details standard output devices such as monitors, printers, and projectors, essential for visual data presentation in business.

Output Devices: Audio and Tactile

Covers audio and tactile output devices, explaining how sound and physical feedback enhance user interaction and accessibility.

Unit 3: Computer Software (8 hours)

Software Characteristics and System Software

Introduces the characteristics of software and distinguishes between system software and application software.

Application Software and Industry Applications

Explores various application software and their specific use cases across different industry sectors.

Enterprise Software: ERP, CRM, and SCM

Examines enterprise-level software solutions including ERP, CRM, and SCM systems for integrating business processes.

Web-Based and Mobile Applications

Compares web-based and mobile applications, highlighting their advantages and deployment strategies in a mobile-first world.

Custom vs Off-the-Shelf Software

Analyzes the trade-offs between custom-built software and off-the-shelf solutions for meeting specific business requirements.

Choosing Software and Licensing

Provides a guide for selecting appropriate software and understanding different software licensing models and legal implications.

Unit 4: Computer Networks (8 hours)

Introduction to Networks and Communication Elements

Introduces the fundamentals of computer networks and the essential elements required for a communication system.

Data Transmission Modes and Media

Explains data transmission modes (simplex, duplex) and the physical media used for wired and wireless communication.

Types of Computer Networks

Categorizes computer networks by scale and purpose, including PAN, LAN, MAN, and WAN.

Network Topologies

Illustrates different network topologies (bus, star, ring, mesh) and their impact on network performance and reliability.

IP Addressing: IPv4 and IPv6

Explains the structure and function of IP addresses, comparing IPv4 and IPv6 protocols and their role in network communication.

Network Security: Firewalls, IPSec, and VPNs

Discusses essential network security measures, including firewalls, IPsec, and VPNs, to protect business data from unauthorized access.

Unit 5: Database Management System (8 hours)

Introduction to Databases and Business Data

Introduces the concept of databases and their critical role in managing and organizing business data for efficient retrieval.

Types of Data and DBMS

Categorizes different types of data (structured, unstructured) and explains the function of Database Management Systems (DBMS).

Relational Databases and SQL

Focuses on relational database models and the use of Structured Query Language (SQL) for data manipulation and querying.

Data Storage and Retrieval

Examines methods for storing and retrieving data efficiently, ensuring data integrity and availability for business operations.

Big Data and Its Business Applications

Explores the concept of Big Data, its characteristics (Volume, Velocity, Variety), and its transformative applications in business analytics.

Data Security and Ethical Considerations

Addresses the critical importance of data security and the ethical considerations surrounding data privacy and protection in business.

Unit 6: Computer Tools in Data Processing and Application (8 hours)

Basics of Data Analysis with Spreadsheets and Power BI

Introduces fundamental data analysis techniques using popular tools like spreadsheets (Excel) and Power BI for business intelligence.

Data Visualization: Charts and Graphs

Covers the principles of data visualization, demonstrating how to use charts and graphs to communicate business insights effectively.

Collaboration Tools: Google Workspace and Teams

Reviews modern collaboration platforms like Google Workspace and Microsoft Teams that facilitate remote work and team productivity.

Business Reporting and Data Extraction Tools

Discusses tools and techniques for extracting data and generating comprehensive business reports to support decision-making.

Tools for Financial Data Analysis and Business Analytics

A guide to essential software for financial analysis, from spreadsheets to BI platforms, with practical business applications.

Tools for Market Trends Analysis and Visualization

Explore tools like Power BI, Google Analytics, and Excel to analyze market trends and create insightful visualizations for strategic business decisions.

Tools for Scheduling and Monitoring

Examines software tools used for project scheduling, resource management, and monitoring business performance metrics.

Unit 1: Introduction to Information Technology in Business

1.1 Overview of computer system

1.1 Overview of computer system

Watch on YouTube
1.2 Definition and Scope of Information Technology (IT)

1.2 Definition and Scope of Information Technology (IT)

Watch on YouTube
1.3 Role and Importance of IT in Modern Businesses

1.3 Role and Importance of IT in Modern Businesses

Watch on YouTube
1.4 Key IT Trends Transforming Businesses

1.4 Key IT Trends Transforming Businesses

Watch on YouTube
1.5 Overview of IT Applications in Various Business Functions

1.5 Overview of IT Applications in Various Business Functions

Watch on YouTube
1.6 Digital Transformation and Its Impact on Business

1.6 Digital Transformation and Its Impact on Business

Watch on YouTube
1.7 The Future of IT in Business

1.7 The Future of IT in Business

Watch on YouTube

Unit 2: Computer Hardware

2.1 Basic Components: Input, Output, Processing, Storage

2.1 Basic Components: Input, Output, Processing, Storage

Watch on YouTube
2.2 Types of Computers (Desktops, Laptops, Servers, Mobile Devices)

2.2 Types of Computers (Desktops, Laptops, Servers, Mobile Devices)

Watch on YouTube
2.3 Hardware Components

2.3 Hardware Components

Watch on YouTube
2.4 Central Processing Unit (CPU)

2.4 Central Processing Unit (CPU)

Watch on YouTube
2.5 Memory (RAM, ROM)

2.5 Memory (RAM, ROM)

Watch on YouTube
2.6 Storage Devices (Hard Drives, SSDs, External Storage)

2.6 Storage Devices (Hard Drives, SSDs, External Storage)

Watch on YouTube

Unit 1: Introduction to Information Technology in Business

Model Question Set 1

Model Question 1

Subject: ICT 110 (IT for Business) Time: 3 Hours

Group A: Very Short Answer Questions (10 x 2 = 20 Marks)

Attempt all questions.

  1. Define "Digital Transformation."
  2. What is the difference between Data and Information?
  3. What is a "wearable device"? Give one business example.
  4. Define Open Source Software (OSS).
  5. What is the full form of IPv6? How is it different from IPv4?
  6. What is a Primary Key in a database?
  7. Define "Cloud Computing."
  8. What is a "Smart Contract"?
  9. List any two features of an ERP system.
  10. What is "Phishing"?

Group B: Descriptive Answer Questions (6 x 10 = 60 Marks)

Attempt any SIX questions.

  1. Explain the components of an Information System. How does an Information System (IS) support the functional areas of business like HR and Marketing?
  2. What is a Brain-Computer Interface (BCI)? Discuss the potential applications of BCI and Haptic technology in the future of business.
  3. Differentiate between Enterprise Resource Planning (ERP) and Customer Relationship Management (CRM) systems. Why are they essential for modern organizations?
  4. Study the given network topology diagram and answer the following questions:

    Image placeholder
    • a) Identify the network topology shown in the diagram.
    • b) Compare LAN, MAN, and WAN in terms of range, speed, and application.
  5. "Data is the new oil." Justify this statement. Explain the concept of Big Data and why managing it is a challenge for businesses.
  6. What is Business Intelligence (BI)? How do tools like Power BI or Tableau help managers make better decisions compared to traditional spreadsheets?
  7. Write short notes on any TWO:
    • Virtual Private Network (VPN)
    • SaaS vs. PaaS
    • Internet of Things (IoT)

Group C: Case Analysis / Applied Question (20 Marks)

Read the scenario and answer the questions:

Scenario: "Daraz Nepal handles thousands of transactions daily. They need a system to manage their inventory in real-time, track delivery trucks using GPS, and recommend products to users based on their past browsing history."
  1. Which type of Network and Transmission Media would you recommend for their delivery tracking system? (5)
  2. Explain how a Relational Database Management System (RDBMS) would help them manage orders vs. customers. (5)
  3. Discuss the security threats they might face (e.g., Hacking, Data Theft) and suggest preventive measures. (10)

Model Question Set 2

Model Question 2

Subject: ICT 110 (IT for Business) Time: 3 Hours

Group A: Very Short Answer Questions (10 x 2 = 20 Marks)

Attempt all questions.

  1. Define Green Computing.
  2. What is the function of an Output Device? Give one example of a "Soft Copy" output.
  3. Differentiate between RAM and ROM.
  4. What is RFID? Mention one area where it is used in business.
  5. What do you mean by "Open Source Software"?
  6. Define Big Data.
  7. What is a Foreign Key in a database?
  8. List any two advantages of using Fiber Optic Cables over Copper cables.
  9. What is SaaS (Software as a Service)? Give one example.
  10. Define Cyber Ethics.

Group B: Descriptive Answer Questions (6 x 10 = 60 Marks)

Attempt any SIX questions.

  1. "Information is a resource just like capital or labor." Discuss this statement. Explain the difference between TPS (Transaction Processing Systems) and DSS (Decision Support Systems) with examples.
  2. What is the Central Processing Unit (CPU)? Explain the role of the ALU and Control Unit. Why is "Clock Speed" important when buying business computers?
  3. Your company is debating whether to buy Licensed Software (like MS Office) or use Free Software (like LibreOffice). As an IT consultant, compare the advantages and disadvantages of both for a corporate environment.
  4. Explain the Client-Server Network Model. How is it different from a Peer-to-Peer (P2P) network? Which one is better for a bank, and why?
  5. Define Database Management System (DBMS). Explain the three levels of database architecture (Internal, Conceptual, and External View).
  6. Compare Microsoft Teams and Google Workspace as collaboration tools. How do these tools improve productivity in a "Work from Home" environment?
  7. Write short notes on any TWO:
    • Virtual Reality (VR) in Business Training
    • The role of Firewalls in Network Security
    • Utility Software (Antivirus, Disk Defrag)

Group C: Case Analysis / Applied Question (20 Marks)

Read the scenario and answer the questions carefully.

Scenario: The "Smart" Supermarket Upgrade
Bhat-Bhateni Supermarket wants to modernize its Pokhara branch. Currently, they face three problems:
  • Checkout lines are too long because cashiers have to manually type codes for vegetables.
  • The manager doesn't know which items are sold out until the shelf is empty.
  • They want to launch a loyalty app where customers get points automatically when they enter the store.
  1. Suggest two Input Devices that can solve the "long checkout line" problem. Explain how they work. (5 Marks)
  2. They need a system to connect the Checkout Counter to the Warehouse so inventory updates automatically. Would you recommend a LAN or WAN for inside the store? Why? (5 Marks)
  3. The manager wants to use Data Mining on customer purchase history. Explain how this could help them increase sales (e.g., "Beer and Diapers" correlation). (10 Marks)