B6 Computing · Term 2 Week 4: INTRODUCTION TO DATABASES, ALGORITHM AND PROGRAMMING. LANGUAGES (e.g. MS- EXCEL, SCRATCH, VB DOT NET ETC.)

Lesson notes

Learning Objectives

Indicator: B6.5.1.1.9 - Operate basics SQL: querying and manipulating data.

By the end of the lesson, learners can:

Write a simple SQL query using SELECT to retrieve specific names of students from a class database.
Use the INSERT INTO command to add a new student record to a database table.
Use the DELETE command to remove a student record from a database table.
Explain what each basic SQL command (SELECT, INSERT INTO, DELETE) does in a database.
Use the CREATE TABLE command to set up a new table for storing student information.

Sign in with your phone number to read the full note and download the GES plan - free.

Sign in with phone number

Curriculum details

Strand: Programming and Databases (Strand 5)
Sub-strand: INTRODUCTION TO DATABASES, ALGORITHM AND PROGRAMMING. LANGUAGES (e.g. MS- EXCEL, SCRATCH, VB DOT NET ETC.) (5.1)
Content standard: B6.5.1.1 - Demonstrate how to manipulate data in Databases
Indicator: B6.5.1.1.9 - Operate basics SQL: querying and manipulating data.
Suggested placement: Term 2, Week 4 (Week 16 of the year)
Our suggestion, laid out in curriculum order across three terms of twelve weeks. NaCCA does not fix the week, so follow your school's scheme of learning.
Source document note: The official curriculum document has a fault in this entry, so the curriculum text above is transcribed exactly as printed:

indicator text - p.40: printed word for word the same as B6.5.1.1.8 above it, 'Operate basics SQL: querying and manipulating data.'. The two exemplars differ (CREATE DATABASE, SELECT and UPDATE against CREATE TABLE, DELETE and INSERT INTO), so they are two indicators, not one printed twice. Transcribed as printed
Curriculum reference: Computing Curriculum (Basic 4-6), 2019, p. 40
Transcribed from the official NaCCA publication. Check this page against the source.

Exemplars (from the NaCCA curriculum)

Guide learners to write simple queries to retrieve specific names of students from a database of the names of all students in class. e.g CREATE TABLE, DELETE and INSERT INTO,
NB: This is to give a foundation to the learner in computing and Computer Science which is more concerned with uses of and development of programming together with fundamental principles of problem-solving and creativity.