Type: Individual
| Tools & Equipment | Materials |
|---|---|
| Computer with Microsoft Windows 10 or later | Microsoft Excel Software |
| External USB Flash Drive 16GB | Microsoft Word Software |
| S/N | Item | Quantity |
|---|---|---|
| 1 | Computer with Microsoft Windows 10 or later | 1 Pc per Candidate |
| 2 | External USB Flash Drive 16GB | 1 Pc per Candidate |
| 3 | Microsoft Excel Software | 1 License per Candidate |
| 4 | Microsoft Word Software | 1 License per Candidate |
| Items to be Evaluated | Marks Available | Marks Obtained | Comments |
|---|---|---|---|
| TASK 1: Observe Safety and Preparation | |||
| Appropriately prepared workstation with no hazards (Award 1 mark for safe and clean workstation setup or zero) | 1 | ||
| Proper use and handling of computer and USB flash drive (Award 1 mark for correct equipment handling or zero) | 1 | ||
| Sub-Total | 2 | ||
| TASK 2: Create Folder Structure | |||
| Created main folder named 'Q3_Sales_2024' in Documents directory (Award 2 marks for correct folder creation and naming or zero) | 2 | ||
| Created three subfolders named 'January', 'February', and 'March' inside main folder (Award 1 mark each for correct subfolder creation and naming or zero) | 3 | ||
| Sub-Total | 5 | ||
| TASK 3: Create and Save Data Files | |||
| Created and saved 'January_Sales.xlsx' with sample data in January folder (Award 2 marks for correct file creation and saving or zero) | 2 | ||
| Created and saved 'February_Sales.xlsx' with sample data in February folder (Award 2 marks for correct file creation and saving or zero) | 2 | ||
| Created and saved 'March_Sales.xlsx' with sample data in March folder (Award 2 marks for correct file creation and saving or zero) | 2 | ||
| Sub-Total | 6 | ||
| TASK 4: Create and Save Summary Report | |||
| Created Word document named 'Q3_Sales_Summary.docx' in main folder (Award 2 marks for correct document creation and saving or zero) | 2 | ||
| Included brief summary text referencing the three months’ sales data (Award 3 marks for relevant and clear summary content or zero) | 3 | ||
| Sub-Total | 5 | ||
| TASK 5: Organize and Backup Files | |||
| Correctly copied main folder 'Q3_Sales_2024' to external USB flash drive (Award 3 marks for successful backup or zero) | 3 | ||
| Properly ejected USB flash drive from computer (Award 1 mark for correct ejection or zero) | 1 | ||
| Sub-Total | 4 | ||
| PRODUCT CHECKLIST | |||
| Folder structure and file names match specifications exactly (Award 3 marks for correct folder and file naming or zero) | 3 | ||
| Data files contain accurate sample data with correct file format (.xlsx) (Award 3 marks for data accuracy and file format or zero) | 3 | ||
| Summary report contains clear and relevant content saved as .docx (Award 2 marks for content relevance and correct format or zero) | 2 | ||
| Backup on USB flash drive is complete and accessible (Award 2 marks for successful backup and accessibility or zero) | 2 | ||
| Sub-Total | 10 | ||
| GRAND TOTAL | 32 | ||
Type: Individual
| Tools & Equipment | Materials |
|---|---|
| Laptop computer | Sample member data sheet (printed) |
| Spreadsheet software (Microsoft Excel or LibreOffice Calc) |
| S/N | Item | Quantity |
|---|---|---|
| 1 | Laptop computer | 1 Pc per Candidate |
| 2 | Spreadsheet software (Microsoft Excel or LibreOffice Calc) | 1 License per Candidate |
| 3 | Sample member data sheet (printed) | 1 Pc per Candidate |
| 4 | Internet access (optional for help resources) | 1 connection per Candidate |
| Items to be Evaluated | Marks Available | Marks Obtained | Comments |
|---|---|---|---|
| TASK 1: PREPARE AND SET UP THE WORK ENVIRONMENT | |||
| Correctly powered on the laptop and opened the spreadsheet software (Award 1 mark for correct start-up and software launch) | 1 | ||
| Opened a new spreadsheet and saved it with an appropriate filename (Award 1 mark for correct file naming and saving) | 1 | ||
| Set up appropriate column headers as per the data sheet (Award 1 mark for accurate headers matching data sheet) | 1 | ||
| Sub-Total | 3 | ||
| TASK 2: DATA ENTRY | |||
| Accurately entered all member data from the printed sheet into the spreadsheet (Award 1 mark for every 25% of data accurately entered) | 4 | ||
| Sub-Total | 4 | ||
| TASK 3: APPLY DATA VALIDATION RULES | |||
| Applied data validation to the 'Phone Number' column to accept only 10-digit numbers (Award 2 marks for correct validation rule applied) | 2 | ||
| Applied data validation to the 'Date of Birth' column to accept only dates before 01/01/2005 (Award 2 marks for correct date validation) | 2 | ||
| Applied drop-down list validation to the 'Membership Type' column with options: 'Farmer', 'Trader', 'Supplier' (Award 2 marks for correct drop-down list creation) | 2 | ||
| Applied data validation to the 'Email Address' column to accept only text containing '@' symbol (Award 2 marks for text validation implementation) | 2 | ||
| Sub-Total | 8 | ||
| TASK 4: REVIEW AND SAVE THE SPREADSHEET | |||
| Reviewed the spreadsheet for any data entry errors (Award 2 marks for thorough review) | 2 | ||
| Saved the final spreadsheet correctly and closed the application (Award 1 mark for saving and closing correctly) | 1 | ||
| Sub-Total | 3 | ||
| PRODUCT CHECKLIST | |||
| Spreadsheet contains all member data accurately entered as per the data sheet (Award 5 marks for complete and accurate data entry) | 5 | ||
| All specified data validation rules correctly applied and functional (Award 7 marks for correct and functional validation rules) | 7 | ||
| Spreadsheet file saved with the correct filename and format (Award 2 marks for correct file saving) | 2 | ||
| Sub-Total | 14 | ||
| GRAND TOTAL | 32 | ||