Search this site
Embedded Files
Skip to main content
Skip to navigation
Home
DATABASE
CD115
Topic 1 : Database Concepts
1.1 Introduction to Database
1.2 Database System vs File System Data Processing
STUDENTS RESOURCES
Topic 2 : Database Design
2.1 Introduction to ANSI-SPARC Three Level Architecture (Three Levels Data
2.2 Explain ANSI-SPARC Three Level Architecture (Three Levels Data Abstract
2.3 Introduction to Database Life Cycle (DBLC)
2.4 Explain Database Life Cycle (DBLC)
2.5 Introduction to Database Language and Data Model
2.6 Differentiate Data Model
2.7 Introduce DBMS as a tool to manage database (mySQL)
STUDENTS RESOURCES
Topic 3 : Conceptual Design
3.1 ER Modelling
STUDENTS RESOURCES
Topic 4 : Logical Design (The Relational Database Model)
4.1 Concept of relational model
4.3 Data Dictionary
4.4 Relational Database System
STUDENTS RESOURCES
Topic 5 : Normalization of Database Tables
5.1 The Purpose of Normalization
5.2 Normalization Process
STUDENTS RESOURCES
QUIZ CD115
STUDENT'S RESOURCES 2025/2026
CD125
Topic 1 : Structured Query Language (SQL)
1.1 Introduction to SQL (CRUD Functions)
STUDENTS RESOURCES
1.2 Relational Database using DDL
STUDENTS RESOURCES
1.3 Mapping Relational Model to SQL Implementation
STUDENTS RESOURCES
1.4 Data manipulation Using DML
1.4.1 Import External Data into Table
STUDENTS RESOURCES
1.5 Data Retrieval Using DQL
1.5.1 Applying Data Retrieval Using DQL
STUDENTS RESOURCES
Topic 2 : Cloud Computing
2.1 Cloud Computing Service
STUDENTS RESOURCES
Topic 3 : Big Data and NoSQL
3.1 NoSQL Databases
3.2 Apply NoSQL database using DBMS
3.3 Introduction to Big Data
3.4 Big Data Technologies
3.5 Big Data Implementation for Data Science
STUDENTS RESOURCES
Topic 4 : Application of Data in Computing Project
4.1 Introduction to Various Computing Project
4.2 SDLC for project development
STUDENTS RESOURCES
COMPUTER PROGRAMMING
CP115
Topic 1 : Introduction To Programming
1.1 Identify programming concepts
1.2 1.3 List and explain five (5) steps in problem solving
1.4 Demonstrate use of design software and coding platforms
Students Resources
Topic 2 : Problem Analysis
2.1 Define IPO model - input, process and output
2.2 Identify sequence control structure
2.3 Identify selection control structure
2.4 Identify repetition control structure & apply IPO model
Students Resources
Topic 3 : Design Solutions
3.1 Define algorithm, pseudocode and flowchart
3.2 Apply the appropriate control structure in pseudocode and flowchart
3.3 Create a flowchart based on a given output using software
3.4 Convert pseudocode to a flowchart and a flowchart to pseudocode
Students Resources
Topic 4 : Python Programming
4.1 Define types, programming paradigms and translator
4.2 State available platforms for writing Python programs
4.3 4.4 Identify components in a Python program
4.5 Identify the use of assignment, arithmetic operators, construct program
Students Resources
Topic 5 : Use of Sequence Control Structure
5.1 Identify the appropriate control structures
5.2 Explain the concept of sequence control structure
5.3 Construct a Python program using sequence control structure
5.4 Apply the IPO model, pseudocode and flowchart to create coding solution
Students Resources
Topic 6 : Use of Selection of Control Structure
6.1 Identify types of selection structure (single, dual and multiple)
6.2 Explain the if, if/else and if/elif/else statements
6.3 Identify the use of relational and logical operators in selection
6.4 Use boolean expressions as conditions in selection statements
6.5 Use logical operators to combine multiple conditions
6.6 Construct a Python program to implement various selection statements
6.7 Apply the IPO model, pseudocode and flowchart to create a coding
Students Resources
Topic 7 : Use of Repetition Control Structure
7.1 Identify types of repetition
7.2 Construct the while loop and for
7.3 Apply the IPO model, pseudocode and flowchart for counter controlled
7.4 Apply the IPO model, pseudocode and flowchart for sentinel controlled
7.5 Apply counter-controlled or sentinel-controlled to implement coding
Students Resources
Topic 8 : Combination of Control Structures
8.1 Construct program by combining all control structures in problem solv
8.2 Apply the combination of all control structures in problem solving
QUIZ CP115
Students Resources
CP125
Topic 1 : Pre-defined and User-defined Functions
1.1 Identify concepts of functions
1.2 Explain the concept of functions
1.3 Identify the components of a function
1.4 Construct a function components
1.5 Construct a complete function using arguments with/without return value
1.6 Identify how to call functions and write simple user-defined functions
1.7 Apply a function using arguments with/without return values
1.8 Construct a Python program using user-defined functions with control
1.9 Write functions that use control structures
Students Resources
Topic 2 : Lists
2.1 Identify concepts of lists
2.2 Explain the concept of lists
2.3 Create lists and access elements using indexing and for loop statement
2.4 Update list elements using assignment statement
2.5 Apply list operators (+,*,in)
2.6 Identify pre-defined list functions (len( ), min( ), max( ), sum( ) and
2.7 Construct Python programs using len( ), min( ), max( ), sum( ) and appe
2.8 Apply list functions and method in problem solving
2.9 Add new elements to a list using append() method
2.10 Remove elements from a list using remove() method
2.11 Sort list in ascending or descending order using sort() method
2.12 Search element from a list using index( ) method
2.13 Apply list with control structures in problem solving
2.14 Apply list with user-defined functions in problem solving
2.15 Construct a Python program using list functions and methods with cont
Students Resources
Topic 3 : Tuples, Sets and Dictionaries
3.1 Identify concept of tuples, sets and dictionaries
3.2 Construct simple programs using tuples, sets and dictionaries
3.3 Apply tuples, sets and dictionaries in problem solving
Students Resources
Topic 4 : Files
4.1 Identify the use of input/output files using CSV and text files
4.2 Construct Python programs that read from and write to CSV or text files
4.3 Apply open() function to open a file
4.4 Apply read() function to read input data from a file
4.5 Apply write() function to save output data to a file
4.6 Apply close() method to close a file
4.7 Construct Python programs that read files and solve problems using list
4.8 Construct Python programs that read files and solve problems using list
Students Resources
Topic 5: DataFrames
5.1 Identify basic Pandas DataFrame properties and methods (shape, columns
5.2 Construct Python programs using Pandas DataFrame properties and methods
5.3 Apply Pandas with lists and CSV files in problem solving
Students Resources
Topic 6: Data Analysis and Visualisation
6.1 Identify basic Pandas methods for data analysis (indexing, describe(),
6.2 Construct a Python program using Pandas methods (indexing, describe(),
6.3 Apply data analysis on selected datasets (indexing, describe(), max(),
6.4 Construct data visualisations using Matplotlib (line chart and histogra
Students Resources
DIGITAL TECHNOLOGY
RT115
Topic 1 : Software Engineering
1.1 : Introduction to SDLC
Topic 2 : Basic Electronics
2.1 : Introduction to OHM'S LAW
2.2 : Introduction to Electronic Circuit
2.3 : Basic Electronic Circuit
2.4 : Soldering technique
Topic 3 : Embedded System,Sensor and Actuator
3.1 : Microcontroller/Microprocessor
Topic 4 : Internet of Things (IoT)
4.1 : Architecture layer of IoT (3 layers)
4.2 : Communications Infrastructure : Lightweight communication protocol
RT125
Topic 1 : Human Computer Interface
1.1 : Interaction Design and Usability
1.2 : Principles and Guidelines in HCI
1.3 : User-Centered Design in HCI
Topic 2 : Computer Networks
2.1 : Introduction of Computer Networks
2.2 : Types of Network
2.3 : Network Devices
2.4 : Network Topologies
2.5 : Network Models
Topic 3 : Cloud Computing
3.1 : Cyber Security Model
Topic 4 : Cyber Security
4.1 : Cloud Computing in IoT
4.2 : Cloud Platform in IoT Data Storage
MATHEMATICS
ENGLISH
PENDIDIKAN ISLAM DAN MORAL
PENGAJIAN AM MATRIKULASI
KO-KURIKULUM
PORTAL CERDAS
6
.
1
Identify basic Pandas methods for data analysis (indexing, describe(), max(), min() and mean())
VIDEO
What is: df.describe()
5:23 - 6:10
min
Report abuse
Page details
Page updated
Report abuse