Wednesday, July 15, 2026

Microsoft Excel Training Notes (Basic to Advanced) | Hands-On Guide 2026 tutorial, Excel formulas, VLOOKUP, Pivot Tables, Excel Dashboard, Data Validation, Excel training notes, Basic to Advanced

📊 Microsoft Excel Training Notes

Basic to Advanced | Hands-on Examples & Step-by-Step Exercises

📚 About this guide: A complete, structured Microsoft Excel course progressing from beginner to advanced levels. Covers formulas, cell references, VLOOKUP/XLOOKUP, Pivot Tables, Data Validation, and Interactive Dashboards. Perfect for a 20–30 hour instructor-led training or self-paced learning with practical exercises after every topic.
Module 1

Introduction to Excel

What is Excel? Spreadsheet software used to store data, perform calculations, analyze information, and build dashboards.

Key Interface Parts: Workbook (file), Worksheet (sheet), Row (horizontal, 1,2,3), Column (vertical, A,B,C), Cell (intersection), Formula Bar, Ribbon, Name Box.

🛠️ Hands-on Exercise 1 Create a Student Marks Sheet with columns: Student, Maths, Science, English. Enter sample data and save as Student_Marks.xlsx.
Module 2

Formatting

Learn to make data professional: Font styles, Borders, Fill Color, Text Color, Merge & Center, Wrap Text, and Alignment.

🛠️ Hands-on Exercise Format a "Product & Price" table: Blue heading, white text, bold, borders, and apply Currency Format to prices.
Module 3

Basic Formulas

Rule: Every formula starts with =.

OperatorMeaningExample
+Add=A2+B2
-Subtract=A2-B2
*Multiply=A2*B2
/Divide=A2/B2
^Power=A2^2
Module 4

Common Functions

  • =SUM(B2:B10) → Total of a range.
  • =AVERAGE(B2:B10) → Mean value.
  • =MAX(B2:B10) → Highest value.
  • =MIN(B2:B10) → Lowest value.
  • =COUNT(B2:B10) → Counts cells with numbers.
  • =COUNTA(B2:B10) → Counts non-empty cells.
Module 5

Cell References

  • Relative (A2): Changes automatically when copied.
  • Absolute ($A$2): Never changes (locks row & column). Use for fixed rates like VAT.
  • Mixed (A$2 or $A2): Locks either the row or the column only.
🛠️ Hands-on Exercise Calculate VAT (18%). Price in A2, VAT Rate in $D$1. Formula: =A2*$D$1
Module 6

AutoFill

Use the small square at the bottom-right of a cell to drag and automatically fill numbers, months, days, or copy formulas.

🛠️ Hands-on Exercise Type "January" in a cell and drag the fill handle down. Observe how Excel automatically fills February, March, etc.
Module 7

Sorting & Filtering

Sort: A-Z, Z-A, Smallest to Largest, Largest to Smallest.
Filter: Temporarily hide data to view specific criteria (e.g., show only "IT Department" or "Salary > 50000").

Module 8

Conditional Formatting

Automatically highlight cells based on rules: Duplicate values, Greater/Less than, Top 10, or Color Scales.

🛠️ Hands-on Exercise Select a column of student marks. Apply Conditional Formatting to highlight all marks greater than 75 in green.
Module 9

IF Function

Syntax: =IF(condition, value_if_true, value_if_false)

Example: =IF(B2>=50, "Pass", "Fail")

🛠️ Hands-on Exercise If a student's mark is >75, display "Excellent". Otherwise, display "Average".
Module 10

AND & OR Functions

  • =AND(A2>50, B2>50) → True only if BOTH conditions are met.
  • =OR(A2>50, B2>50) → True if AT LEAST ONE condition is met.
Module 11

Date Functions

  • =TODAY() → Current date.
  • =NOW() → Current date and time.
  • =YEAR(A2), =MONTH(A2), =DAY(A2) → Extract specific parts of a date.
Module 12

Text Functions

  • =LEFT(A2,3) → Extracts first 3 characters.
  • =RIGHT(A2,2) → Extracts last 2 characters.
  • =MID(A2,2,5) → Extracts 5 characters starting from position 2.
  • =LEN(A2) → Counts total characters.
  • =TRIM(A2) → Removes extra spaces.
  • =UPPER(), =LOWER(), =PROPER() → Change text case.
🛠️ Hands-on Exercise Convert "john smith" into "John Smith" using the =PROPER() function.
Module 13

Lookup Functions

  • VLOOKUP: =VLOOKUP(lookup_value, table_array, col_index_num, FALSE). Searches vertically.
  • XLOOKUP (Excel 365): =XLOOKUP(lookup_value, lookup_array, return_array). More flexible, searches any direction.
  • HLOOKUP: Searches horizontally across the first row.
Module 14

Data Validation

Restrict what can be entered into a cell. Common uses: Drop-down lists, number limits, date limits.

🛠️ Hands-on Exercise Create a drop-down list for "Department" with options: Sales, HR, Finance, IT. (Data Tab → Data Validation → List).
Module 15

Charts

Visualize data using Bar Charts, Pie Charts, Line Charts, and Column Charts. Select data → Insert Tab → Choose Chart.

Modules 16-19

Pivot Tables, Charts & Tables

  • Pivot Tables: Summarize large datasets instantly (Insert → Pivot Table). Drag fields to Rows, Columns, and Values.
  • Pivot Charts: Visual representation of a Pivot Table.
  • Excel Tables: (Ctrl+T) Provides automatic formatting, built-in filters, and structured references.
  • Freeze Panes: (View → Freeze Panes) Keeps headers visible while scrolling.
Modules 20-22

Protection, Named Ranges & What-If

  • Protect Sheet: (Review → Protect Sheet) Prevents unauthorized edits. Can set a password.
  • Named Ranges: Assign a name (e.g., "Sales") to a range (e.g., A2:A20). Use =SUM(Sales) for readability.
  • What-If Analysis: Goal Seek (find input for a desired output), Scenario Manager, Data Tables.
Modules 23-24

Advanced & Financial Functions

  • INDEX & MATCH: Powerful alternative to VLOOKUP. =INDEX(return_range, MATCH(lookup_value, lookup_range, 0))
  • PMT: Calculate loan EMI. =PMT(rate, nper, pv)
Module 25 + Final Project

Interactive Sales Dashboard

Dataset: Date, Product, Region, Salesperson, Qty, Price.

Tasks:

  1. Format as Table & Calculate Total Sales (=Qty*Price).
  2. Apply Currency Format & Conditional Formatting (> Rs.100,000).
  3. Create Data Validation Drop-downs & Sort/Filter.
  4. Build Pivot Table (Sales by Region) & Pivot Chart.
  5. Insert Slicers (Product, Region) for an interactive Dashboard.

📝 Practice Assignments

  • Student Result Management System
  • Employee Salary Calculator (with Tax & Deductions)
  • Monthly Household Budget Tracker
  • Automated Sales Invoice Generator
  • Inventory Management System (with Low Stock Alerts)
  • Attendance Register with Conditional Formatting
  • Payroll Calculator
  • Business Expense Tracker
  • Hotel Booking Register
  • Interactive Business Sales Dashboard
  • ]

🎯 Learning Outcomes

By the end of this course, learners will be able to:

  • Navigate the Excel interface confidently.
  • Enter, edit, and format data professionally.
  • Use basic and advanced formulas and functions.
  • Analyze data using sorting, filtering, and conditional formatting.
  • Create charts, PivotTables, and PivotCharts.
  • Validate and protect worksheets.
  • Use lookup functions (VLOOKUP, XLOOKUP, INDEX/MATCH).
  • Perform What-If Analysis and basic financial calculations.
  • Design interactive dashboards for business reporting.
  • Apply Excel skills to real-world business scenarios through hands-on projects.

❓ Frequently Asked Questions (FAQ)

Q: What is the difference between Relative and Absolute Cell References? A: A Relative Reference (e.g., A1) changes automatically when copied to another cell. An Absolute Reference (e.g., $A$1) never changes, locking the specific row and column, which is useful for fixed values like tax rates.
Q: What is the difference between VLOOKUP and XLOOKUP? A: VLOOKUP searches for a value in the first column of a range and returns a value in the same row. XLOOKUP is a newer, more flexible function that can search in any direction, defaults to an exact match, and handles errors gracefully without needing column index numbers.
Q: How do you create a Drop-Down List in Excel? A: Select the target cells, go to the Data tab, click 'Data Validation', choose 'List' under Allow, and enter your source values separated by commas or select a range of cells containing the options.
Q: What is a Pivot Table used for? A: A Pivot Table is used to quickly summarize, analyze, explore, and present large datasets. It allows you to group data, calculate totals and averages, and create dynamic reports without writing complex formulas.
Q: How does the INDEX and MATCH combination work? A: MATCH finds the row or column number of a lookup value, and INDEX retrieves the value at that specific position. Together, they form a powerful, flexible alternative to VLOOKUP that can look left or right.

🎓 Expert ICT, Coding, School Classes, Digital Marketing & University Project Guidance

Struggling with your university final year project? Want to master coding, upscale your business with expert digital marketing, or learn absolute computer basics from scratch? We offer high-quality individual and group online classes conducted in English, Sinhala, or Tamil mediums. Get guaranteed academic success and professional growth with tailored guidance.


🎓 University Final Year Project Guidance & AI

Get specialized, end-to-end mentoring and technical support to pass your degree or master's program with flying colors:

  • 🏫 Targeted Institutes: Expert guidance tailored for BIT UCSC, UoM, SLIIT, NIBM, and other leading universities.
  • 🔬 Postgraduate Support: Comprehensive assistance for MSc Software Final Year Projects.
  • 🤖 AI & Smart Applications: Step-by-step implementation of AI, Machine Learning (ML), and automation modules.
  • Guaranteed Success: Help with documentation, system architecture, coding, and viva preparation.

🏫 School ICT & Corporate Beginner Classes

  • 💻 Non-IT Staff Computer Basics: Absolute beginner-friendly online classes covering essential computer skills, office tools, and internet operations.
  • 🎒 Primary & Secondary (Grades 1-10): Interactive online ICT classes tailored to build strong foundations from early ages.
  • 📝 Exam Prep: Dedicated training packages for GCE O/L, GCE A/L ICT, and GIT exams.
  • 🌍 Global Syllabuses: Complete curriculum coverage for Local, Edexcel, and Cambridge in English & Tamil Mediums.

📢 Software Development & Digital Marketing Services

  • ⚙️ Software & Web Development: Professional custom software application and website development built using PHP & MySQL.
  • 🎯 Social Media Management: Content creation, publishing, and channel management for Facebook, Instagram, TikTok, and YouTube.
  • 📈 Ad Boosting: Highly targeted paid advertising campaigns to drive leads, traffic, and sales to your business.

📞 Connect With Us Instantly

Book your slot for online classes or get a premium tech service quote today!

💬 WhatsApp: +94 729622034

📧 Email: ITClassSL@gmail.com


🌐 Explore Our Resources & Communities

Stay updated with our latest tutorials, project ideas, and student guides across all our official platforms:

Monday, July 13, 2026

IP Addressing, IPv4, IPv6 & Subnetting | A/L ICT Chapter 06 Complete guide to Internet Protocol (IP) for Sri Lankan A/L ICT. Covers IPv4 Classes, Subnet Masks, CIDR, DHCP (DORA), NAT, IPv6, DNS, ARP & Routing

🌐 Internet Protocol (IP) Masterclass

A/L ICT Chapter 06 | Data Communication & Networking

📚 About this guide: Complete theory guide for the Internet Protocol (IP) covering IPv4 Addressing, Classes, Subnet Masks, CIDR, DHCP (DORA), NAT, IPv6, DNS, ARP, and Routing. Designed specifically for the Sri Lankan G.C.E. Advanced Level ICT syllabus with simple explanations, real-world examples, and exam tips!
Concept 1

What is an IP Address?

Theory: A unique logical address assigned to every device on an IP network. It allows devices to identify each other and communicate.

Example: Just like your house has a postal address (No. 25, Main Street) for the post office, a computer has an IP (e.g., 192.168.1.20) for routers to deliver data.

Concept 2

IPv4 Structure (32-bit)

Theory: IPv4 is a 32-bit logical address divided into 4 equal parts called octets (8 bits each). Each octet ranges from 0 to 255 in decimal.

192 . 168 . 10 . 25
│      │     │    │
Oct1  Oct2  Oct3 Oct4

Binary: 11000000.10101000.00001010.00011001

Concept 3

Network ID vs Host ID

Network ID: Identifies the specific network (like the street name). All devices on the same LAN share this.

Host ID: Identifies the individual device (like the house number).

Example: In 192.168.1.20, if the network is 192.168.1, then the Host ID is 20.

Concept 4

Rules for Valid IPv4

  • Must contain exactly four octets.
  • Each octet must be between 0 and 255.
  • Must be unique within the same network (otherwise, IP conflict occurs).
Concept 5

Special IPv4 Addresses

  • Network Address: Host ID is all 0s (e.g., 192.168.1.0). Represents the network itself.
  • Broadcast Address: Host ID is all 1s (e.g., 192.168.1.255). Sends data to all devices.
  • Loopback: 127.0.0.1. Used to test the local TCP/IP stack.
  • Unspecified: 0.0.0.0. Represents an unknown address during startup.
Concept 6

Types of Communication

  • Unicast: One-to-One (e.g., Sending an email).
  • Broadcast: One-to-All (e.g., ARP request in a LAN).
  • Multicast: One-to-Many/Selected Group (e.g., Live online lecture).
Concept 7

IPv4 Address Classes

Class1st OctetDefault MaskUse
A1 – 126255.0.0.0 (/8)Large Networks
B128 – 191255.255.0.0 (/16)Medium Networks
C192 – 223255.255.255.0 (/24)Small Networks
D224 – 239N/AMulticast
E240 – 255N/AExperimental
Concept 8

Subnet Mask & CIDR

Theory: A 32-bit number that separates the Network ID (1s) from the Host ID (0s).

CIDR Notation: A shorter way to write the mask by counting the 1s.

  • 255.0.0.0 = /8 (8 ones)
  • 255.255.0.0 = /16 (16 ones)
  • 255.255.255.0 = /24 (24 ones)
Concept 9

Public vs Private IP

Public IP: Globally unique, assigned by ISP, accessible on the Internet.

Private IP: Used only inside a LAN. Cannot be routed on the Internet.

Private Ranges:

  • Class A: 10.0.0.0 to 10.255.255.255
  • Class B: 172.16.0.0 to 172.31.255.255
  • Class C: 192.168.0.0 to 192.168.255.255
Concept 10

Static vs Dynamic & DHCP (DORA)

Static IP: Manually configured, permanent (used for servers).

Dynamic IP: Automatically assigned by a DHCP server.

DHCP DORA Process:

  • D - Discover: Client broadcasts looking for a DHCP server.
  • O - Offer: Server offers an available IP.
  • R - Request: Client requests to use that IP.
  • A - Acknowledge: Server confirms and finalizes the lease.
Concept 11

NAT (Network Address Translation)

Theory: Translates multiple Private IPs inside a LAN into a single Public IP for Internet access. Conserves public IPv4 addresses and adds security by hiding internal IPs.

Concept 12

IPv6 Structure

Theory: Uses 128-bit addresses divided into 8 groups of 16 bits, written in Hexadecimal and separated by colons (:).

Example: 2001:0db8:85a3:0000:0000:8a2e:0370:7334

Simplification Rules:

  • Remove leading zeros: 0db8db8
  • Replace continuous zeros with :: (only once): 2001:db8::1
Concept 13

IPv4 vs IPv6 Comparison

FeatureIPv4IPv6
Size32-bit128-bit
FormatDecimalHexadecimal
Addresses~4.3 BillionVirtually Unlimited
SecurityOptionalBuilt-in (IPsec)
ConfigurationManual/DHCPAuto-configuration
Concept 14

Routing, Gateway & TTL

Router: Connects different networks and forwards packets based on IP addresses using a Routing Table.

Default Gateway: The router's IP that a device uses to communicate with outside networks (e.g., the Internet).

TTL (Time To Live): A value in the IP header that decreases by 1 at each router. Prevents packets from looping endlessly. Discarded when it reaches 0.

Concept 15

DNS, ARP & ICMP

  • DNS (Domain Name System): Resolves human-friendly domain names (www.google.com) into IP addresses.
  • ARP (Address Resolution Protocol): Maps a known IP address to an unknown MAC address within a local LAN.
  • ICMP: Used for error reporting and diagnostics. Tools include Ping (tests reachability) and Traceroute (shows the path taken).
Concept 16

Complete IP Communication Journey

Example: Opening www.google.com

  • 1. DNS: Browser asks DNS for Google's IP.
  • 2. TCP: Connection established with the server.
  • 3. IP Packet: Source/Dest IPs added.
  • 4. ARP: Finds the MAC address of the Default Gateway.
  • 5. Routing: Routers forward the packet across the Internet.
  • 6. Response: Google server sends data back.

Important A/L Short Questions

Q: What is an IP address?

A: A unique logical address assigned to a device for identification and communication over an IP network.

Q: State two differences between IPv4 and IPv6.

A: 1) IPv4 uses 32-bit addresses (decimal), while IPv6 uses 128-bit addresses (hexadecimal). 2) IPv6 has built-in security, whereas it is optional in IPv4.

Q: What is the purpose of ARP?

A: ARP (Address Resolution Protocol) is used to find the physical MAC address corresponding to a known IP address within a local network.

Q: What is the function of TTL?

A: TTL (Time To Live) prevents packets from travelling indefinitely in a network by discarding them when the TTL counter reaches zero.

💡 A/L Exam Memory Sheet:
🌐 IP → Logical addressing + Routing
🏠 DNS → Domain name → IP address
🔗 ARP → IP address → MAC address
📢 DHCP → Automatic IP assignment (DORA)
🎭 NAT → Private IP ↔ Public IP translation
🛡️ ICMP → Error reporting + Ping/Traceroute

❓ Frequently Asked Questions (FAQ)

Q: What is an IP Address and why is it needed? A: An IP (Internet Protocol) address is a unique logical address assigned to every device on a network. It is needed to uniquely identify devices, allow routers to determine where to send data, and enable communication across networks and the Internet.
Q: What is the difference between a Public IP and a Private IP? A: A Public IP is globally unique, assigned by an ISP, and accessible directly over the Internet. A Private IP is used only within a local network (LAN), is not accessible directly from the Internet, and can be reused across different private networks.
Q: What is the DHCP DORA process? A: DORA is the process DHCP uses to assign dynamic IP addresses: Discover (client broadcasts for a server), Offer (server offers an IP), Request (client requests the offered IP), and Acknowledge (server confirms the assignment).
Q: What is the difference between IPv4 and IPv6? A: IPv4 uses 32-bit addresses (decimal format, ~4.3 billion addresses) while IPv6 uses 128-bit addresses (hexadecimal format, virtually unlimited addresses). IPv6 also has built-in security and better routing efficiency.
Q: What is the purpose of ARP and DNS? A: DNS (Domain Name System) converts human-readable domain names (like www.google.com) into IP addresses. ARP (Address Resolution Protocol) converts known IP addresses into physical MAC addresses within a local network.

🎓 Expert ICT, Coding, School Classes, Digital Marketing & University Project Guidance

Struggling with your university final year project? Want to master coding, upscale your business with expert digital marketing, or learn absolute computer basics from scratch? We offer high-quality individual and group online classes conducted in English, Sinhala, or Tamil mediums. Get guaranteed academic success and professional growth with tailored guidance.


🎓 University Final Year Project Guidance & AI

Get specialized, end-to-end mentoring and technical support to pass your degree or master's program with flying colors:

  • 🏫 Targeted Institutes: Expert guidance tailored for BIT UCSC, UoM, SLIIT, NIBM, and other leading universities.
  • 🔬 Postgraduate Support: Comprehensive assistance for MSc Software Final Year Projects.
  • 🤖 AI & Smart Applications: Step-by-step implementation of AI, Machine Learning (ML), and automation modules.
  • Guaranteed Success: Help with documentation, system architecture, coding, and viva preparation.

🏫 School ICT & Corporate Beginner Classes

  • 💻 Non-IT Staff Computer Basics: Absolute beginner-friendly online classes covering essential computer skills, office tools, and internet operations.
  • 🎒 Primary & Secondary (Grades 1-10): Interactive online ICT classes tailored to build strong foundations from early ages.
  • 📝 Exam Prep: Dedicated training packages for GCE O/L, GCE A/L ICT, and GIT exams.
  • 🌍 Global Syllabuses: Complete curriculum coverage for Local, Edexcel, and Cambridge in English & Tamil Mediums.

📢 Software Development & Digital Marketing Services

  • ⚙️ Software & Web Development: Professional custom software application and website development built using PHP & MySQL.
  • 🎯 Social Media Management: Content creation, publishing, and channel management for Facebook, Instagram, TikTok, and YouTube.
  • 📈 Ad Boosting: Highly targeted paid advertising campaigns to drive leads, traffic, and sales to your business.

📞 Connect With Us Instantly

Book your slot for online classes or get a premium tech service quote today!

💬 WhatsApp: +94 729622034

📧 Email: ITClassSL@gmail.com


🌐 Explore Our Resources & Communities

Stay updated with our latest tutorials, project ideas, and student guides across all our official platforms:

Saturday, July 11, 2026

HCI/UX Syllabus Notes UCSC (University of Colombo School of Computing) HCI/UX syllabus, below is a theory explanation with exam-style answers for every question in your paper. This is suitable for revision and writing in exams

✨ UCSC HCI/UX Syllabus Notes ✨

Distinguish between UX Design and HCI

Theory

Both UX Design and HCI are related to designing interactive systems, but they focus on different areas.

What is HCI?

Human-Computer Interaction (HCI) is the scientific study of how people interact with computers. It combines Computer Science, Psychology, Design, and Ergonomics.

Main Goal:

  • Improve usability & efficiency
  • Reduce user errors
  • Make systems easy to learn

What is UX Design?

User Experience (UX) Design is the process of creating products that provide meaningful, enjoyable, and satisfying experiences to users, focusing on emotions and satisfaction.

Differences

HCIUX Design
Academic disciplinePractical design process
Studies interaction between humans & computersDesigns better user experiences
Research-basedProduct-oriented
Focuses on usability and interactionFocuses on emotions, satisfaction, branding
Includes evaluation and experimentsIncludes wireframes, prototypes, testing

Exam Answer Summary

HCI is an academic field studying human-computer interaction to improve usability and safety. UX Design focuses on designing products that provide enjoyable experiences. Difference: HCI explains how people interact, while UX applies this to create products users enjoy using.

Double Diamond Model

Theory

Introduced by the UK Design Council, it divides the design process into four stages. The first diamond represents understanding the problem; the second represents finding the best solution.

Stage 1 – Discover

Research stage. Collect info via interviews, surveys, observations. Goal: Understand users & identify problems.

Stage 2 – Define

Analyze info to identify the real problem. Goal: Create a clear problem statement.

Stage 3 – Develop

Generate solutions via brainstorming, sketching, wireframes. Goal: Find the best possible solution.

Stage 4 – Deliver

Test with users, improve based on feedback, launch final product. Goal: Deliver an effective system.

Application Example (Public Transport App)

  • Discover: Interview commuters. Problem: Bus delays, no live tracking.
  • Define: Users cannot know when buses arrive.
  • Develop: Ideas: GPS tracking, live notifications. Create prototype.
  • Deliver: Test with users, fix problems, release app.

Mental Model vs Conceptual Model

Theory

Mental Model: The understanding users develop in their minds about how a system works, based on previous experience and expectations.

Conceptual Model: The model created by designers to explain how the system actually works, shown through UI elements (buttons, icons, menus).

Difference

Mental ModelConceptual Model
Inside user's mindCreated by designer
Based on experienceBased on system design
May be incorrectShould represent actual system

Strategy to Align Both Models

1. Use Familiar Metaphors: Use objects users already know (Shopping Cart, Trash Bin, Home icon).

2. Progressive Disclosure: Show instructions gradually (e.g., Tooltips explaining buttons) to help users learn naturally.

WIMP Interface

Theory

WIMP stands for:

  • W – Windows: Rectangular area where apps run (e.g., MS Word).
  • I – Icons: Small graphical symbols for files/commands (e.g., Recycle Bin).
  • M – Menus: Lists of commands (e.g., File, Edit, View).
  • P – Pointer: Mouse cursor for selecting objects.

Simple Sketch

-------------------------------------------------
| File   Edit   Help                           |
-------------------------------------------------

 Software Installation Wizard

 [✓] Install for all users

   < Back      Next >      Cancel

                 ^
              Mouse Pointer
        

Labels: ✔ Window | ✔ Menu | ✔ Icons/Buttons | ✔ Pointer

Personas

Theory

A Persona is a fictional character created using real user research to help designers understand different user groups. Includes: Name, Age, Goals, Background, Challenges, Design Needs.

Sarah (42, Teacher)

  • Goal: Complete diploma. Studies at night.
  • Challenges: Slow internet, prefers videos.
  • Design Needs: Downloadable videos, offline learning, less text.

Scenario: Downloads lecture videos to watch offline in the evening.

Jamal (Undergraduate, Rural)

  • Goal: Complete university work via mobile.
  • Challenges: Low data, visually impaired.
  • Design Needs: Screen reader support, accessible UI, low bandwidth.

Scenario: Uses mobile screen reader to listen to course materials.

Interaction Analysis

Theory

Studies how users behave while interacting with systems. Three categories:

1. Verbal Behaviour

Communication using speech/language (e.g., Asking questions). Scenario: Guard directs user; User selects "Withdrawal."

2. Non-Verbal Behaviour

Communication without words (e.g., Facial expressions, hesitation). Scenario: User appears confused and looks nervous.

3. Interaction with Artifacts

Interaction with physical/digital objects (e.g., Touchscreen, ATM). Scenario: Presses Start button; Watches display board.

UX Evaluation

  • Obs 1: User looks confused. Problem: No guidance. Fix: Provide signs/instructions.
  • Obs 2: User hesitates. Problem: Poor interface guidance. Fix: Show welcome instructions.
  • Obs 3: English menu only. Problem: Language barrier. Fix: Provide Sinhala, Tamil, English.
  • Obs 4: Misses token number. Problem: Visual notification only. Fix: Add audio alerts & flashing displays.

How to Score High in HCI/UX Papers

  • Start each answer with a clear definition.
  • Explain the theory in 2–4 sentences.
  • Include key goals or characteristics.
  • Add a real-world example.
  • For comparison questions, use a table.
  • For design questions, explain why the method improves usability.
  • For scenario questions, relate your answer directly to the given scenario.

This approach helps you earn both knowledge marks (definitions/theory) and application marks (examples/analysis).

🎓 Expert ICT, Coding, School Classes, Digital Marketing & University Project Guidance

Struggling with your university final year project? Want to master coding, upscale your business with expert digital marketing, or learn absolute computer basics from scratch? We offer high-quality individual and group online classes conducted in English, Sinhala, or Tamil mediums. Get guaranteed academic success and professional growth with tailored guidance.


🎓 University Final Year Project Guidance & AI

Get specialized, end-to-end mentoring and technical support to pass your degree or master's program with flying colors:

  • 🏫 Targeted Institutes: Expert guidance tailored for BIT UCSC, UoM, SLIIT, NIBM, and other leading universities.
  • 🔬 Postgraduate Support: Comprehensive assistance for MSc Software Final Year Projects.
  • 🤖 AI & Smart Applications: Step-by-step implementation of AI, Machine Learning (ML), and automation modules.
  • Guaranteed Success: Help with documentation, system architecture, coding, and viva preparation.

🏫 School ICT & Corporate Beginner Classes

  • 💻 Non-IT Staff Computer Basics: Absolute beginner-friendly online classes covering essential computer skills, office tools, and internet operations.
  • 🎒 Primary & Secondary (Grades 1-10): Interactive online ICT classes tailored to build strong foundations from early ages.
  • 📝 Exam Prep: Dedicated training packages for GCE O/L, GCE A/L ICT, and GIT exams.
  • 🌍 Global Syllabuses: Complete curriculum coverage for Local, Edexcel, and Cambridge in English & Tamil Mediums.

📢 Software Development & Digital Marketing Services

  • ⚙️ Software & Web Development: Professional custom software application and website development built using PHP & MySQL.
  • 🎯 Social Media Management: Content creation, publishing, and channel management for Facebook, Instagram, TikTok, and YouTube.
  • 📈 Ad Boosting: Highly targeted paid advertising campaigns to drive leads, traffic, and sales to your business.

📞 Connect With Us Instantly

Book your slot for online classes or get a premium tech service quote today!

💬 WhatsApp: +94 729622034

📧 Email: ITClassSL@gmail.com


🌐 Explore Our Resources & Communities

Stay updated with our latest tutorials, project ideas, and student guides across all our official platforms:

UCSC HCI/UX Notes (2023 Paper) 2nd Year 2nd Semester BIT Colombo Software Projects

✨ UCSC HCI/UX Notes (2023 Paper) ✨

User-Centered Design (UCD)

Theory

User-Centered Design (UCD) is a design philosophy where users are involved throughout the software development process. Instead of designing based only on technical requirements, designers first understand the users' needs, goals, abilities, and limitations.

According to ISO 9241-210, UCD is an iterative process, meaning the product is repeatedly designed, tested, and improved based on user feedback.

Principles of UCD

  • Understand users and their environment.
  • Involve users throughout the design process.
  • Design based on user feedback.
  • Evaluate designs continuously.
  • Improve through multiple iterations.

Importance of UCD

  • Improves Usability: Products become easier to learn and use (e.g., An ATM with clear instructions reduces user mistakes).
  • Increases User Satisfaction: Users enjoy systems that match their expectations.
  • Reduces Development Cost: Finding problems early is cheaper than fixing them later.
  • Increases Product Success: Satisfied users recommend the system.

Exam Answer Summary

UCD is an iterative design approach focusing on users, their needs, and goals throughout every stage. Designers continuously gather feedback to improve the product. It improves usability, increases satisfaction, reduces costs, and achieves higher adoption rates.

Expert-Based Usability Evaluation

Theory

These are expert-based methods that do not require real users.

1. Heuristic Evaluation

Developed by Jakob Nielsen. Usability experts inspect the interface using 10 usability heuristics (e.g., Visibility of system status, Error prevention, Consistency). It is cheap, fast, and finds many problems quickly.

2. Cognitive Walkthrough

Experts imagine they are first-time users. They complete tasks step-by-step asking: Will the user know what to do? Will they notice the button? Will they understand feedback? The purpose is to find learning problems.

3. Predictive Modeling (GOMS)

Uses mathematical models instead of real users. A popular model is GOMS (Goals, Operators, Methods, Selection Rules). The purpose is to predict how long users take to perform tasks.

Exam Answer Summary

  • Heuristic Evaluation: Experts inspect the interface using usability principles.
  • Cognitive Walkthrough: Experts simulate a user's thinking while completing tasks.
  • Predictive Modeling (GOMS): Mathematical models predict user performance without involving real users.

A/B Testing

Theory

A/B Testing compares two versions of the same interface to determine which performs better. Version A is the current design; Version B is the new design. Users are randomly divided into two groups and behaviour is measured.

Steps

  • Step 1: Define objective (e.g., Increase purchases).
  • Step 2: Create two versions (e.g., "Buy Now" vs "Purchase").
  • Step 3: Split users randomly (50% A, 50% B).
  • Step 4: Collect data (Clicks, Sales, Bounce rate).
  • Step 5: Analyze results.
  • Step 6: Implement the better design.

Example

An e-commerce site tests a Green checkout button (A) against an Orange button (B). The orange button receives more purchases, so Version B becomes the final design.

Advantages

  • Data-driven decisions
  • Easy comparison
  • Improves conversion rate
  • Reduces guessing

Advantages of High-Fidelity Prototypes

Theory

High-fidelity prototypes closely resemble the final product, including colours, images, fonts, animations, and interactive buttons (created in Figma, Adobe XD, Sketch).

Advantages

  • Realistic user feedback: Users behave naturally because it looks real.
  • Better usability testing: Most interactions can be fully tested.
  • Stakeholder approval: Managers can easily visualize the final product.
  • Developer communication: Developers know exactly how the interface should look and function.

Exam Answer Summary

High-fidelity prototypes produce realistic user feedback, support detailed usability testing, help gain stakeholder approval, and provide clear specifications for developers.

Laboratory vs Natural Setting Testing

Laboratory Testing

Testing is done inside a controlled environment where researchers control noise, lighting, and equipment. It allows accurate observations and controlled experiments, but users may behave differently knowing they are watched.

Natural Setting Testing

Testing occurs in the user's real environment (Home, Office, Classroom). It yields real behaviour and natural interaction, but it is harder to control distractions and observe closely.

Comparison

LaboratoryNatural Setting
Controlled environmentReal environment
High control over variablesLow control
Less realistic behaviourMore realistic behaviour
Easier data collectionHarder observation

Four Interaction Design Principles

Theory

Interaction Design Principles help create usable and intuitive systems.

  • Visibility: Users should easily see available actions (e.g., Visible Login button).
  • Feedback: System immediately informs users about actions (e.g., "Payment Successful" message).
  • Consistency: Similar functions should look and behave similarly (e.g., Same Save icon everywhere).
  • Affordance: Objects should suggest how they are used (e.g., Raised button appears clickable; door handle suggests pulling).

Exam Answer Summary

  • Visibility: Important functions should be easy to see.
  • Feedback: The system should respond immediately to user actions.
  • Consistency: Similar elements should behave similarly.
  • Affordance: Interface elements should clearly indicate how they can be used.

Choosing the Best Evaluation Method

Scenario 1: Mobile App Navigation

Best Method: Heuristic Evaluation.
Why? Experts quickly identify navigation problems using established usability principles without needing users.

Scenario 2: Online Banking Difficulties

Best Method: Cognitive Walkthrough.
Why? Experts follow each task step-by-step to discover exactly where users become confused or make mistakes.

Scenario 3: E-Learning Satisfaction

Best Method: User Surveys.
Why? Surveys gather opinions directly from many users regarding satisfaction, ease of use, and overall experience.

Exam Answer Summary

ScenarioMethodReason
Mobile app navigationHeuristic Eval.Experts identify problems using principles.
Banking difficultiesCognitive Walk.Reveals where users struggle step-by-step.
E-learning satisfactionUser SurveysCollects direct feedback on user experience.

Theory Questions Strategy

  • Begin with a definition.
  • Explain the purpose of the concept.
  • List key characteristics or steps.
  • Include a real-world example.
  • For comparison questions, use a table where appropriate.
  • For scenario questions, explain why the chosen method is the most suitable.

This structure aligns well with the marking style typically used in UCSC IT4106 examinations.

🎓 Expert ICT, Coding, School Classes, Digital Marketing & University Project Guidance

Struggling with your university final year project? Want to master coding, upscale your business with expert digital marketing, or learn absolute computer basics from scratch? We offer high-quality individual and group online classes conducted in English, Sinhala, or Tamil mediums. Get guaranteed academic success and professional growth with tailored guidance.


🎓 University Final Year Project Guidance & AI

Get specialized, end-to-end mentoring and technical support to pass your degree or master's program with flying colors:

  • 🏫 Targeted Institutes: Expert guidance tailored for BIT UCSC, UoM, SLIIT, NIBM, and other leading universities.
  • 🔬 Postgraduate Support: Comprehensive assistance for MSc Software Final Year Projects.
  • 🤖 AI & Smart Applications: Step-by-step implementation of AI, Machine Learning (ML), and automation modules.
  • Guaranteed Success: Help with documentation, system architecture, coding, and viva preparation.

🏫 School ICT & Corporate Beginner Classes

  • 💻 Non-IT Staff Computer Basics: Absolute beginner-friendly online classes covering essential computer skills, office tools, and internet operations.
  • 🎒 Primary & Secondary (Grades 1-10): Interactive online ICT classes tailored to build strong foundations from early ages.
  • 📝 Exam Prep: Dedicated training packages for GCE O/L, GCE A/L ICT, and GIT exams.
  • 🌍 Global Syllabuses: Complete curriculum coverage for Local, Edexcel, and Cambridge in English & Tamil Mediums.

📢 Software Development & Digital Marketing Services

  • ⚙️ Software & Web Development: Professional custom software application and website development built using PHP & MySQL.
  • 🎯 Social Media Management: Content creation, publishing, and channel management for Facebook, Instagram, TikTok, and YouTube.
  • 📈 Ad Boosting: Highly targeted paid advertising campaigns to drive leads, traffic, and sales to your business.

📞 Connect With Us Instantly

Book your slot for online classes or get a premium tech service quote today!

💬 WhatsApp: +94 729622034

📧 Email: ITClassSL@gmail.com


🌐 Explore Our Resources & Communities

Stay updated with our latest tutorials, project ideas, and student guides across all our official platforms: