Recommended Subjects of Examination:- This level tests advanced knowledge and skills in optional subjects related to Information and Communication Technology (ICT): Word Processing, Spreadsheet Management, Database Management, Power Point Presentation Principles Of Programming, Desktop Publishing, Web Designing
The Web Designing course (WD3) equips students with foundational skills in HTML and web technologies. It enables learners to create, structure, and style web pages using HTML while understanding essential internet concepts. Upon completion, students will be able to develop functional, structured, and visually appealing websites. 🧑🎓 Target Audience: Beginners in web design and development ICT diploma students Junior developers Career switchers entering the tech industry 📅 Course Duration: 8 to 10 weeks (flexible based on institution schedule) 📂 Prerequisites: Basic computer literacy and familiarity with file management
The Level 3 Spreadsheet Management course is designed to build on the knowledge acquired in Levels 1 and 2, providing students with a deeper and more advanced understanding of Microsoft Excel. This curriculum begins with a brief review of foundational concepts from the previous levels, ensuring that all students are well-prepared before progressing into more advanced topics. Throughout this course, students will explore both the theoretical and practical aspects of electronic spreadsheets, including their advantages and limitations in real-world application Key Areas Covered:-Introduction to Microsoft Excel (Advanced Overview), Advantages and Disadvantages of Electronic Spreadsheets Recap of Navigation and Worksheet Management, Advanced Formulas and Functions, Data Analysis Techniques Data Validation and Error Handling, Charts and Data Visualization, Practical Projects and Real-Life Applications This course is highly practical and focuses on equipping students with industry-relevant skills needed for data handling, reporting, and decision-making. By the end of this program, students will be able to confidently use Excel for advanced data processing, analysis, and professional reporting. Target Audience:- Students who have completed Level 1 & 2, Individuals looking to advance their Excel skills, Professionals seeking to improve productivity and data management Outcome:- Graduates of this course will be equipped with the skills required to handle complex spreadsheet tasks and will be prepared for higher-level ICT applications and certification.
The Database Management Lessons offers a thorough exploration of database fundamentals and practical skills in database development and management. Students will learn how to create, query, and manipulate databases using Microsoft Access for Windows, along with essential techniques for data entry, field properties, validation checks, sorting, forms, queries, and report generation.
This lesson provides a practical, step-by-step introduction to database creation using Microsoft Access, using a sports company employee database as the practical case study.
Before creating the database, students will learn the importance of database planning—understanding the purpose of the database, identifying the information that needs to be stored, determining the appropriate fields, and considering the type of information or reports that will eventually be produced.
The lesson then introduces the fundamental concepts required to design and create a database, including tables, entities, attributes, fields, field names, data types, database objects, and field properties.
Students will also explore the different Microsoft Access views and understand how each view is used when creating, entering, modifying, displaying, and preparing database information for printing.
At the end of this lesson, students should be able to:
Explain the purpose of planning before creating a database.
Identify the information required for an employee database.
Define a database table and explain its purpose.
Explain the meaning of an entity.
Identify attributes and fields within a database.
Explain what a field name is and how it identifies stored information.
Describe the purpose of data types in Microsoft Access.
Explain field properties and their importance.
Understand the purpose of Field Size and Format.
Identify common Microsoft Access database objects.
Explain the different views available in Microsoft Access.
Determine appropriate fields for an employee database.
Apply basic database planning concepts to a practical scenario.
In this practical exercise, we consider employee information maintained by a sports company. The database is designed to organize important personnel information such as:
Employee ID
Date Hired
Last Name
First Name
Street
City
State
Zip Code
Phone Number
Birth Date
Students will use this information to understand how real-world records can be organized into a structured database.
1. Creating a Database
Understanding database planning, purpose, information requirements, and expected output.
2. What Is a Table?
Understanding rows, columns, entities, and how tables organize related information.
3. What Is an Attribute or Field?
Understanding the individual categories of information stored in a database table.
4. Database Objects
Introduction to objects such as tables, queries, forms, and reports.
5. Microsoft Access Views
Understanding Design View, Datasheet View, Form View, Print Preview, and Layout Preview.
6. Field Names
Understanding how field names identify the information stored in each field.
7. Data Types
Understanding how Microsoft Access uses data types to determine what kind of information can be entered into a field.
8. Field Properties
Understanding the characteristics that control how individual fields behave and display information.
9. Field Size
Understanding how Field Size controls the maximum amount of data that can be entered into a field.
10. Format
Understanding how Format controls the way information is displayed and printed.
This lesson establishes a strong foundation for students who are beginning Microsoft Access and Database Management. It prepares students for the practical stages of database development, where they will create tables, enter records, design queries, create forms, generate reports, and work with database information. Students are encouraged to follow each step carefully and apply the concepts discussed in the lesson while working on their own database projects.