admin, Author at Little Bytes

Bloom’s Taxonomy for Computer Applications Technology

The purpose of this document is to explore the application of Bloom’s Revised Taxonomy in the context of Computer Applications Technology (CAT). Bloom’s Taxonomy is a widely accepted framework used to classify educational objectives according to cognitive complexity. This approach can be adapted to CAT’s practical components, which involve mastering essential computer applications like Word, Excel, Access, and HTML (4).

This document aims to help educators better understand how Bloom’s levels – ranging from basic recall of concepts to higher-order critical thinking and problem-solving – can be effectively integrated into CAT instruction. By categorising tasks and skills across the six cognitive domains (Remembering, Understanding, Applying, Analysing, Evaluating, and Creating), this guide provides a platform for designing lessons and assessments that develop a broad range of learner competencies. Read More “Bloom’s Taxonomy for Computer Applications Technology”

All Excel functions

Here is a list of all the Excel functions as of September 2023

For Computer Applications Technology students, I have highlighted all the necessary functions to learn (red text). Note that I have also highlighted some functions that may not necessarily be required by CAPS but are incredibly useful and easier to use than other older functions. Using certain newer functions can replace using the older ones and are accepted when used to find a solution in Excel.

Click any function name for further information.

I’ve made a PDF of this that you can download, at the bottom of the table. Read More “All Excel functions”

Zip all folders in one directory (script)

Sometimes, when marking practical assessments, you might want to return the assessment folders to your learners. That means having to zip up every assessment as it contains many sub-folders and files. Here is a time-saving Powershell script which will automatically zip up every folder in a main folder. Copy the code below into a plain text file. Save the file as Zip.ps1 in the same folder as your learner folders. Run the script by right-clicking on it and select “Run with Powershell”. Hope that helps. Enjoy! Read More “Zip all folders in one directory (script)”

Author: admin

Bloom’s Taxonomy for Computer Applications Technology

All Excel functions

Here is a list of all the Excel functions as of September 2023

Zip all folders in one directory (script)