IBA- PUBLIC SCHOOL SUKKUR
Computer Portfolio
Class – XI
(According to Aga Khan University Examination Board Computer HSSC-I Syllabus 2023-24)
NAME: __________________________________________
FATHER’S NAME:__________________________________
SECTION:________________________________________
ROLL NO:________________________________________
Page PAGE 15 of NUMPAGES 18
IBA- PUBLIC SCHOOL SUKKUR
CERTIFICATE OF COMPLETION
SESSION (_____-_____)
This is to certify that Mr. _________________________________________________________
S/O __________________________ Roll No _____________ Class _____________________
has successfully carried out the necessary practical work as prescribed by the Aga Khan
University Examination Board.
_____________________________ ___________________
Teacher’s Initial Head Teacher’s Initial
Date: _____________
Page PAGE 15 of NUMPAGES 18
INDEX
S. SLO No. Practical Activity Date Teacher’s Signature
No.
1. 8.2.1 Creating different tables in design view and
wizard.
2. 8.2.2 Assign appropriate data types to the fields in a
table.
3. 8.2.6 Sorting records in a table.
4. 8.2.4 Create relationship among tables using primary
and foreign key.
5. 8.3.1; 8.3.2 Create simple forms using wizards and design
view.
6. 8.2.5 Navigating through records in a form.
7. 8.3.6; 8.3.7; 8.3.8 Using forms to add, delete or modify a record.
8. 8.4.1; 8.4.2; 8.4.3; Create simple queries (select, update, delete and
8.4.4; 8.4.5 append) using wizard and design view.
9. 8.5.1; 8.5.2 Write simple SQL (DDL and DML) queries.
10. 8.5.1 Create reports using wizard.
11. 8.5.4 View and print reports.
Page PAGE 15 of NUMPAGES 18
IBA- PUBLIC SCHOOL SUKKUR
Senior Section
Subject: Computer– XI
Date: _____________________
Practical No. 1
SLO#8.2.1: Creating different tables in design view and wizard.
Table #1 – Student Table
Page PAGE 15 of NUMPAGES 18
Table #2 – Result Table
Page PAGE 15 of NUMPAGES 18
IBA- PUBLIC SCHOOL SUKKUR
Senior Section
Subject: Computer– XI
Date: _____________________
Practical No. 2
SLO#8.2.2: Assign appropriate data types to the fields in a table.
Student Table
Page PAGE 15 of NUMPAGES 18
Result Table
Page PAGE 15 of NUMPAGES 18
IBA- PUBLIC SCHOOL SUKKUR
Senior Section
Subject: Computer– XI
Date: _____________________
Practical No. 3
SLO#8.2.6: Sorting records in a table.
Sorting In Student Table
Sorting In Result Table
Page PAGE 15 of NUMPAGES 18
IBA- PUBLIC SCHOOL SUKKUR
Senior Section
Subject: Computer– XI
Date: _____________________
Practical No. 4
SLO#8.2.4: Create relationship among tables using primary and foreign key.
Page PAGE 15 of NUMPAGES 18
IBA- PUBLIC SCHOOL SUKKUR
Senior Section
Subject: Computer– XI
Date: _____________________
Practical No. 5
SLO#8.3.1; 8.3.2: Create simple forms using wizards and design view.
Student Table Form
Result Table Form
Page PAGE 15 of NUMPAGES 18
IBA- PUBLIC SCHOOL SUKKUR
Senior Section
Subject: Computer– XI
Date: _____________________
Practical No. 6
SLO#8.3.5: Navigating through records in a form.
Page PAGE 15 of NUMPAGES 18
IBA- PUBLIC SCHOOL SUKKUR
Senior Section
Subject: Computer– XI
Date: _____________________
Practical No. 7
SLO#8.3.6; 8.3.7; 8.3.8: Using forms to add delete or modify a record.
IBA- PUBLIC SCHOOL SUKKUR
Page PAGE 15 of NUMPAGES 18
Senior Section
Subject: Computer– XI
Date: _____________________
Practical No. 8
SLO#8.4.1; 8.4.2; 8.4.3; 8.4.4; 8.4.5: Create simple queries (select, update, delete and append) using
wizard and design view.
Update Query
Delete Query
IBA- PUBLIC SCHOOL SUKKUR
Page PAGE 15 of NUMPAGES 18
Senior Section
Subject: Computer– XI
Date: _____________________
Practical No. 8
SLO#8.5.1;8.5.2: Write simple SQL(DDL and DML) queries
Creating Employees Table
Adding Column
Creating Index
Page PAGE 15 of NUMPAGES 18
Drop A Table
IBA- PUBLIC SCHOOL SUKKUR
Senior Section
Subject: Computer– XI
Page PAGE 15 of NUMPAGES 18
Date: _____________________
Practical No. 8
SLO#8.5.1: Create reports using wizards.
IBA- PUBLIC SCHOOL SUKKUR
Senior Section
Subject: Computer– XI
Page PAGE 15 of NUMPAGES 18
Date: _____________________
Practical No. 8
SLO#8.5.4: View and print reports.
Page PAGE 15 of NUMPAGES 18
Page PAGE 15 of NUMPAGES 18
