ClassX — Lecture Resources

e-learning platform

Resources for
every lecture

Pre-recorded videos, slides, notes, and practice problems for courses taught at Southeast University — organized by class, built for self-paced learning during the COVID-19 pandemic.

Computer Fundamentals

Number systems, binary arithmetic, IEEE-754 floating point, memory, data communication, and introductory programming concepts.

23 Classes Videos Slides Worksheets

Computer Architecture

MIPS ISA, instruction encoding, pipelining, hazard resolution, floating point instructions, and datapath design.

22 Classes Videos Notes Classwork

Database Design Lab

Hands-on MySQL lab covering table creation, retrieval queries, constraints, joins, and subqueries with practical worksheets.

10 Labs Videos Worksheets Project

Database Design

ER modeling, EER modeling, relational constraints, schema mapping, normalization (1NF–3NF), and SQL query writing.

23 Classes Videos Slides Classwork

Class 1 Course Overview

Students are given an overview of what this course is about and how it will be conducted.

Class 2 Introduction

Slides

📄 Introduction

Videos

▶ Introduction (22 min)

Quiz

📝 Test Your Knowledge

Class 3 Computer Generations & Components

Slides

📄 Computer Generations 📄 Computer Components

Videos

▶ Computer Generations (27 min) ▶ Computer Components (9 min)

Quiz

📝 Test Your Knowledge

Class 4 Creating Presentations (Microsoft PowerPoint)

Videos

▶ Creating Presentations Using MS PowerPoint (39 min) ▶ Sample Undergraduate Presentation

Quiz

📝 Test Your Knowledge

📌 Classwork: Create a presentation covering how you have been participating in online classes. Include device details (processor, memory, OS) and at least 2 applications that helped you (Google Classroom, Gmail, MS PowerPoint, etc.).

Class 5 Classes of Computers & Number System (Part 1–3)

Slides

📄 Classes of Computers 📄 Number System

Videos

▶ Classes of Computers (20 min) ▶ NS Part 1: Introduction (17 min) ▶ NS Part 2: Base R to Decimal (6 min)

Class 6 Number System (Part 3–5): Conversions

Slides

📄 Number System (continued)

Videos

▶ NS Part 3: Sum of Weights Method (9 min) ▶ NS Part 4: Repeated Division/Multiplication (12 min) ▶ NS Part 5: Binary ↔ Octal/Hex (24 min)

Quiz

📝 Test Your Knowledge

Class 7 Number System (Part 6–8): Addition & Multiplication

Notes

📝 Binary Addition 📝 Base-R Addition 📝 Multiplication

Videos

▶ NS Part 6: Binary Addition (15 min) ▶ NS Part 7: Base-R Addition (15 min) ▶ NS Part 8: Hex Multiplication (12 min) ▶ NS Part 9: Multiplication Exercises (5 min) optional

Quiz

📝 Test Your Knowledge

Worksheet Number System Sample Quiz

Files

📎 Sample Quiz

Videos

▶ Online Exam Guidelines

⚠️ Students must submit their work to be eligible for future exams.

Class 8 BCD, Sign & Magnitude, 1's Complement

Slides

📄 Number System (continued) 📄 BCD (Binary Coded Decimal) 📄 Sign & Magnitude, 1s Complement

Notes

📝 Subtraction

Videos

▶ NS Part 10: Subtraction (13 min) ▶ Binary Coded Decimal (16 min) ▶ Sign & Magnitude Representation (10 min) ▶ 1's Complement (16 min)

Quiz

📝 Test Your Knowledge

Class 9 ⭐ Quiz 1

Syllabus: Computer Generations · Number System (everything covered up to Class 7)

Class 10 2's Complement

Notes

📝 2's Complement

Videos

▶ 2's Complement — Conversions From/To Decimal (16 min) ▶ Range of 2's Complement Number System (21 min)

Quiz

📝 Test Your Knowledge

Class 11 Quiz 1 Review

Quiz 1 marks are revealed amongst the students and the answers discussed.

Class 12 Zero & Sign Extension · 2's Complement Arithmetic

Slides

📄 Zero & Sign Extension 📄 2's Complement Arithmetic

Videos

▶ Zero Extension & Sign Extension (28 min) ▶ 2's Complement Arithmetic (22 min)

Quiz

📝 Test Your Knowledge

Worksheet Signed Numbers

Files

📎 Signed Numbers Worksheet

Videos

▶ Signed Numbers Worksheet Tutorial (25 min) optional

Midterm ⭐ Midterm Exam

Syllabus: Everything covered so far.

Class 13 IEEE-754 Floating Point Representation (Single Precision)

Notes

📝 Introduction to IEEE-754 FP Rep

Videos

▶ Floating Point Numbers (11 min) ▶ IEEE-754 Single Precision Representation (37 min)

Class 14 IEEE-754 to Decimal Conversion

Notes

📝 Decimal to IEEE-754 Review 📝 IEEE-754 to Decimal

Videos

▶ Decimal to IEEE-754 Single Precision (Review) (13 min) ▶ IEEE-754 Single Precision to Decimal (19 min)

Quiz

📝 Test Your Knowledge

Worksheet IEEE-754 Floating Point Conversions

Files

📎 IEEE-754 Conversions Worksheet

Class 15 Midterm Review

Midterm marks are disclosed and the answers discussed.

Class 16 Memory

Covers registers, cache (SRAM), primary memory (DRAM), secondary memory (HDD, SSD, flash), and various types of ROMs.

Slides

📄 Memory

Videos

▶ Memory Part 1 (22 min) ▶ Memory Part 2 (15 min)

Quiz

📝 Test Your Knowledge

Class 17 Understanding Performance

Introduces clock cycles and calculating CPU execution time from instruction count, CPI, and clock speed.

Slides

📄 Understanding Performance

Videos

▶ Understanding Performance (47 min)

Quiz

📝 Test Your Knowledge

Class 18 Spreadsheet Functions

Demonstrations for spreadsheet functions: SUM, COUNT, COUNTA, AVERAGE, IF, VLOOKUP, ROUND.

Videos

▶ Using Functions in a Spreadsheet

Quiz

📝 Test Your Knowledge

Assignment Spreadsheet Assignment

Files

📎 Assignment Questions 📎 Cars Dataset (Excel) 📎 Cars Dataset (Google Sheets)

Class 19 ⭐ Quiz 2

Syllabus: IEEE-754 · Understanding Performance · Memory

Class 20 Data Communication (Part 1–2)

Part 1 introduces elements of communication; Part 2 covers various network topologies.

Slides

📄 Data Communication

Videos

▶ Data Communication Part 1 (12 min) ▶ Data Communication Part 2 (23 min)

Quiz

📝 Test Your Knowledge

Class 21 Data Communication (Part 3) & Quiz 2 Review

Textual and image data interpretation, parity, followed by Quiz 2 answer discussion.

Videos

▶ Data Communication Part 3 (29 min)

Quiz

📝 Test Your Knowledge

Class 22 Variables & Control Flow Statements

Introduces variables, if/else statements, and data types — connecting with 2's complement and IEEE-754, and linking the spreadsheet IF function to control flow.

Videos

▶ Variables and Control Flow Statements (33 min)

Quiz

📝 Test Your Knowledge

Class 23 Building a Portfolio Site with Google Sites

Students learn to create a personal or portfolio website using Google Sites.

Final ⭐ Final Exam

Syllabus includes:
From Midterm: Binary/Decimal/Hex conversions · 2's complement (conversion, range, arithmetic)
After Midterm: IEEE-754 · Memory · Performance · Data Communication · Variables & Control Flow

Class 1Course Overview

Students are given an overview of what this course is about and how it will be conducted.

Class 2Introduction · Moore's Law · Von Neumann vs Harvard

Slides

📄 Introduction

Videos

▶ Introduction (21 min) ▶ Moore's Law (16 min) ▶ Von Neumann vs Harvard Architecture (13 min)

Quiz

📝 Test Your Knowledge

Class 3RISC vs CISC

Notes

📝 RISC vs CISC Handout (must read) 📝 RISC vs CISC Handwritten

Videos

▶ RISC vs CISC (31 min)

Quiz

📝 Test Your Knowledge

Class 4MIPS Memory · R Type & I/J Type Instructions

Notes

📝 Memory + R Type Instructions 📝 beq, bne, j, addi, slt (Pages 1–3)

Videos

▶ MIPS Memory: Register, Instruction, Data (14 min) ▶ R Type Instructions: and, sub, or (11 min) ▶ Translating if/else to MIPS (I, J Type) (19 min)

Quiz

📝 Test Your Knowledge

📌 Classwork: Translate the given if/else code to MIPS using the bne instruction (instead of beq) and without a jump instruction. Explanation video (attempt first!).

Class 5MIPS Register Convention · Register File Read/Write

Slides

📄 MIPS ISA (Slides 1–13)

Videos

▶ MIPS Register Convention (24 min) ▶ Register File: Read/Write Operations (30 min)

Quiz

📝 Test Your Knowledge

Class 616-bit Constants · Zero & Sign Extension

Slides

📄 MIPS ISA (Slides 18–22)

Notes

📝 beq, bne, j, addi, slt (Page 4) 📝 Zero, Sign Extension

Videos

▶ Placing Custom Values (16-bit Constants) in Registers (5 min) ▶ Zero Extension & Sign Extension (26 min)

Quiz

📝 Test Your Knowledge

Class 7Big/Little Endian · Memory Access: lw & sw

Notes

📝 Load & Store Operations

Videos

▶ Big Endian, Little Endian (20 min) ▶ Memory Access: lw, sw (I Type) (20 min) ▶ Using lw & sw to Translate to MIPS (12 min)

Quiz

📝 Test Your Knowledge

Class 8⭐ Quiz 1

Syllabus: Contents of Classes 2, 3, 4, 5 & 6

Class 9For Loops · Translating Arrays to MIPS

Notes

📝 beq, bne, j, addi, slt (Pages 5–7) 📝 Iterating Arrays in For Loops

Videos

▶ Translating a for loop Using beq & slti (29 min) ▶ Iterating Arrays in for loops (21 min)

Quiz

📝 Test Your Knowledge

📌 Classwork: Translate C for-loop with array accesses to MIPS (base address of A in $s5). Video explanation · Code solution — attempt before looking!

Class 10Encoding & Decoding Machine Language

Notes

📝 Encoding, Decoding

Videos

▶ Encoding Assembly → Machine Language (30 min) ▶ Decoding Machine Language → Assembly (20 min)

Quiz

📝 Test Your Knowledge

Class 1132-bit Constants · Shift Operations · Integer Mult/Div

Slides

📄 MIPS ISA (continued) 📄 Integer Multiplication and Division

Notes

📝 Shift Operations - sll, srl

Videos

▶ Loading a 32-bit Constant to a Register (14 min) ▶ Shift Operations - sll, srl (15 min) ▶ Integer Multiplication and Division (9 min)

Quiz

📝 Test Your Knowledge

Midterm⭐ Midterm Exam

Syllabus: Everything covered so far.

Class 12Midterm Viva

Students explain the logical reasoning behind their midterm answers. Attendance mandatory for all who took the midterm.

Class 13MIPS Addressing Modes

Slides

📄 MIPS Addressing Modes

Videos

▶ MIPS Addressing Modes (35 min)

Class 14Procedures: jal, jr · Spilling Registers

Videos

▶ Instructions for Procedures — jal, jr (16 min) ▶ Spilling Registers (30 min)

Class 15Understanding Performance

Slides

📄 Understanding Performance

Videos

▶ Understanding Performance (35 min)

Class 16IEEE-754 Floating Point Representation

Notes

📝 Introduction to IEEE-754 FP Representation

Videos

▶ Floating Point Numbers (11 min) ▶ IEEE-754 Single Precision FP Representation (37 min)

Class 17IEEE-754 to Decimal · MIPS Floating Point Instructions

Notes & Slides

📝 IEEE-754 FP to Decimal 📄 MIPS Floating Point Instructions

Videos

▶ Decimal to IEEE-754 Review + Range (13 min) ▶ IEEE-754 Single Precision to Decimal (19 min) ▶ MIPS Floating Point Instructions (12 min)

Assignment

📎 IEEE-754 Floating Point Representation Assignment

Class 18MIPS Datapath Components

Slides

📄 Basic MIPS Architecture

Videos

▶ MIPS Datapath Components (28 min)

Class 19⭐ Quiz 2

Syllabus: Addressing Modes · Stack · Performance · IEEE-754 Floating Point Representation

Class 20Single Cycle & Multicycle Datapath

Videos

▶ Single Cycle Datapath (36 min) ▶ Multicycle Datapath (25 min)

Quiz

📝 Test Your Knowledge

Class 21MIPS Pipelining & Hazards

Slides

📄 Pipelining and Hazards

Videos

▶ MIPS Pipelining (21 min) ▶ Pipeline Hazards (25 min)

Quiz

📝 Test Your Knowledge

Class 22Identifying & Resolving Hazards

Notes

📝 Identifying & Resolving Hazards

Videos

▶ Identifying & Resolving Hazards (27 min)

Quiz

📝 Test Your Knowledge

📌 Classwork: Given 5 MIPS pipeline instructions — identify hazards, resolve using stalls only, and find the most efficient resolution for lowest CPI.

Final⭐ Final Exam

Syllabus: Everything covered after the midterm.

Lab 1Lab Overview

Students are given an overview of what this lab is about and how it will be conducted.

Lab 2MySQL Data Types · Creating & Populating Tables

Files

📎 Mini Server 📝 MySQL Data Types Notes

Videos

▶ SQL vs MySQL (9 min) ▶ MySQL Data Types (18 min) ▶ Creating a Table & Populating with Data (24 min)

📌 Lab Task: Complete Worksheet 1 tasks 1–2 (create table + insert data). Save SQL statements in a .txt file. Follow the submission format.
📎 Worksheet 1

Lab 3Data Manipulation · Retrieval Queries

Videos

▶ UPDATE, SET, WHERE, DROP, ALTER, ADD, MODIFY (22 min) ▶ DISTINCT, ORDER BY, BETWEEN, AS, NOT, AND, OR, YEAR, LIKE (37 min)

📌 Lab Task: Complete Worksheet 1, Tasks 3–6. Use the submission format. 📎 Worksheet 1

Lab 4More SQL Keywords · Aggregation · Subqueries

Notes

📝 More SQL Keywords

Videos

▶ More SQL Keywords (11 min) ▶ Aggregation (14 min) ▶ Sub Queries (18 min)

📌 Lab Task: Complete all tasks in Worksheet 2. Same submission format as Lab 3. Also, submit project name and group info (max 5 students; no duplicate projects).

Lab 5⭐ Test 1

Syllabus: Everything covered so far.

Queries written via a form field must abide by the instructions given here.

Lab 6Inserting Data Using a Web Page

Videos

▶ Inserting Data Using a Web Page (28 min)

📌 Lab Task: Worksheet 3, tasks 1–6. Also, submit the EER diagram of your project. Review ERD/EERD concepts from the Database Design course (Classes 7, 8, 10).

Lab 7Constraints · Join Operations

Notes

📝 Constraints 📝 Joins

Videos

▶ Constraints (28 min) ▶ Join Operations (17 min) ▶ Additional Info for Lab Task

📌 Lab Task: Worksheet 4, tasks 1–2. Submit the schema diagram of your project (ideally normalized). Review mapping from Database Design (Classes 14–16).

Lab 8Joining Three Tables · Joins with Subqueries

Videos

▶ Joining Three Tables (24 min) ▶ Joins Involving Subqueries (18 min)

📌 Lab Task: Worksheet 4, task 3. Edit this submission file in the format of the first solved problem. Submit the SQL features of your project.

Lab 9⭐ Test 2

Syllabus: Everything covered so far, with emphasis on Worksheet 4.

Lab 10⭐ Project Demo

Students are required to demonstrate their project.

Final⭐ Final Exam

Syllabus: Everything covered so far.

Class 1Course Overview

Students are given an overview of what this course is about and how it will be conducted.

Class 2Database & Database Users (Part 1)

Slides

📄 Intro

Videos

▶ Database & Database Users Part 1 (32 min)

Class 3Database & Database Users (Part 2)

Videos

▶ Database & Database Users Part 2 (26 min)

Class 4DB System Concepts & Architecture

Slides

📄 Concepts and Architecture

Videos

▶ Concepts and Architecture Part 1 (20 min) ▶ Concepts and Architecture Part 2 (24 min)

Class 5ER Diagram Modeling (Part 1)

Slides

📄 ERD

Videos

▶ ER Modeling Part 1 (32 min)

Class 6ER Diagram Modeling (Part 2)

Videos

▶ ER Modeling Part 2 (49 min)

Class 7ERD Review · ER Modeling (Part 3)

Notes

📝 Brief Review — ERD 📝 Detailed Review — ERD

Videos

▶ Brief Review: ER Diagram Concepts (13 min) ▶ Detailed Review: ER Diagram Concepts (42 min) ▶ ER Modeling Part 3 (14 min)

📌 Classwork — ERD from Requirements: Draw an ER diagram for a music library database from the given requirements. Explanation video — attempt first! State any assumptions made.

Class 8EER Modeling (Part 1)

Slides

📄 EERD

Videos

▶ EER Modeling Part 1 (29 min)

Class 9⭐ Quiz 1

Syllabus: Slides 2 & 3

Class 10EER Modeling (Part 2)

Videos

▶ EER Modeling Part 2 (26 min)

📌 Classwork — EERD from Requirements: Draw an EER diagram for an organization's persons database. Explanation video — attempt first! State assumptions.

Midterm⭐ Midterm Exam

Syllabus: Slides 1, 2, 3 & 4

Class 11Relational Data Model & Constraints (Part 1)

Slides

📄 Constraints

Videos

▶ Relational Model & Constraints Part 1 (31 min)

Class 12Midterm Viva

Students explain the logical reasoning behind their midterm answers. Attendance mandatory for all who took the midterm.

Class 13Relational Constraints (Part 2)

Videos

▶ Relational Model & Constraints Part 2 (60 min)

Class 14Mapping ER Diagram to Schema (Steps 1–7)

Slides

📄 Mapping

Videos

▶ Mapping ER Diagram to Schema — Steps 1–6 (35 min) ▶ Mapping N-ary Relationship — Step 7 (6 min)

Class 15Mapping EER Diagram to Schema (Step 8)

Videos

▶ Mapping EER Diagram to Schema — Step 8 (41 min)

Class 16Mapping Union Types/Categories (Step 9)

Videos

▶ Mapping Union Types/Categories — Step 9 (11 min)

📌 Classwork — ERD to Schema: Map the ER diagram here to a schema. Explanation (12 min).
Classwork — EERD to Schema: Map the EER diagrams here using all possible options. Explanation (18 min).

Class 17Normalization: Informal Guidelines & Functional Dependencies

Slides

📄 Normalization

Videos

▶ Informal Guidelines & Functional Dependencies (42 min)

Class 18Normalization: 1NF, 2NF, 3NF

Videos

▶ 1NF, 2NF, 3NF (36 min)

📌 Classwork — Normalizing BOOK relation: Determine the normal form and decompose until fully normalized. Explanation (17 min) — attempt first!

Class 19SQL: Schema Definitions · Data Types · Joins

Slides

📄 SQL