SECTION C: Computer Application Packages
5. Word Processing Package
Topics:
(a) General Concept (b) Creating and Saving Documents (c) Editing, Formatting, and Insertion (d) Printing (e) MS Word i. Features ii. Launching MS Word iii. Basic Operations iv. Other Operations
Objectives:
Candidates should be able to:
i. Define word processing and provide examples of word processing packages (e.g., MS Word, WordStar, WordPerfect, Open Word, etc.). ii. Identify general features of word processing packages (create, save, edit, insert, print, share, etc.). iii. List the application areas of word processing packages (Office, Publishing, Journalism, Education, etc.).
Candidates should be able to:
i. Launch MS Word effectively. ii. Perform basic operations in MS Word, including creating, editing, saving, retrieving, printing, copying, moving, etc. iii. Utilize different font types and sizes. iv. Perform formatting, justification, searching, exploring, spell checking, and file merging operations in MS Word. v. Close MS Word.
6. Spreadsheet Package
Topics:
(a) General Concept (b) Creating and Saving Documents (c) Editing, Formatting, and Insertion (d) Printing (e) MS Excel i. Features ii. Launching MS Excel iii. Basic Operations iv. Other Operations
Objectives:
Candidates should be able to:
i. Define spreadsheet and provide examples of spreadsheet packages (e.g., MS Excel, VisiCalc, SuperCalc, SPSS, etc.). ii. Identify general features of spreadsheet packages (create, save, edit, insert, print, share, etc.). iii. List the application areas of spreadsheet packages (Accounting, Engineering, Statistics, Calculation, what-if scenarios, Education, etc.).
Candidates should be able to:
i. Launch MS Excel effectively. ii. Define basic terms in MS Excel (worksheet, workbook, cells, cell ranges, etc.). iii. Use MS Excel for creating, editing, saving, retrieving, and printing spreadsheet documents. iv. Utilize data types in MS Excel (Number, Labels, Formula, etc.). v. Perform basic operations in MS Excel (Data Entry, Saving, Retrieving, Moving, Copying, etc.). vi. Perform arithmetic calculations using formulas and inbuilt functions, etc. vii. Use different font types and sizes. viii. Perform additional MS Excel operations (Formatting, Editing, Printing, Drawing charts, etc.). ix. Close MS Excel.
7. Database Package
Topics:
(a) Definition of Database and Examples of Database Packages (b) Database Organizations (c) Different Features of Database Format (d) Basic Operations of Database Using MS Access (e) Create a Database Using MS Access (f) Carry Out Operations on an Existing Database Using MS Access.
Objectives:
Candidates should be able to:
i. Define a database and provide examples of database packages (e.g., Dbase, Foxbase, MS Access, Oracle, etc.). ii. Define basic database terms (File, Record, Field, Key, Form, Table, etc.). iii. List and explain different types of database organizations (Hierarchical, Network, and Relational). iv. List the application areas of databases in different organizations (Office, Home, Education, Government, Hospital, Agriculture, etc.).
Candidates should be able to:
i. Explain different features of the database format in MS Access: – Files designed as tables – Tables comprising rows and columns – Rows containing related information about a record – Columns containing specific types of information about a field ii. Carry out steps to create a database in MS Access: – Define the structure of a database – Indicate field type (numeric, character, date, text, etc.) – Enter data – Save data iii. Carry out basic operations on an already created MS Access database: – Searching, modifying, sorting, reporting, selecting, inserting, etc. iv. Close the MS Access database.
8. Graphics Package
Topics:
(a) Definitions and Examples of Graphic Packages (b) Features of CorelDraw (c) Simple Design Using CorelDraw
Objectives:
Candidates should be able to:
i. Define graphics and provide examples of graphic packages (Paint, Harvard Graphics, Photoshop, CorelDraw, AutoCAD, etc.). ii. Explain features of CorelDraw (LiveSketch Tool, Multi-Monitor Support, Healing Clone Tools, Copy Curve Segments, Gaussian Blur Feature, Touch-Friendly GUI Interface, Powerful Stylus Enhancements, Import Legacy Workspaces, Prominent Interactive Sliders, Custom Node Shapes, Font Filtering and Search, Corel Font Manager, Enhanced Vector Previews, Handles and Nodes, etc.). iii. Utilize features of CorelDraw to activate existing CorelDraw files. iv. Use CorelDraw for designing: – Business cards – School logos – National flags – Invitation cards – Certificates, etc.
9. Presentation Package
Topics:
(a) Definition of Presentation Package and Examples of Presentation Packages (b) PowerPoint i. Features of PowerPoint Environment ii. Steps in Activating an Existing PowerPoint iii. PowerPoint Operations
Objectives:
Candidates should be able to:
i. Define presentation and provide examples of presentation packages (MS PowerPoint, Windows Movie Maker, Macromedia Flash, Impress, Apple Keynote, etc.). ii. Explain features of the PowerPoint environment (Animation Painter, Video Editor, Create a Video of Your Presentation, Automatic Ribbons Toolbars, Transitions, Sections, Cropped Tool, Mask Feature, Effective Preview, Screen Shot, Smart Guides). iii. Explain steps in activating a PowerPoint presentation. iv. Perform PowerPoint operations to: – Create a new presentation – Insert pictures, text, graphs, animated contents, add new slides, etc. – Save presentations, run slideshows, print presentations, close presentations, etc.
10. Web Design Package
Topics:
(a) Definition and Examples of Web Design Packages (b) Uses of Web Design Packages (c) Elements of Web Design Using Dreamweaver
Objectives:
Candidates should be able to:
i. Define and give examples of web design packages (HTML, XML, Dreamweaver, Rapidweaver, Google Web Designer, Microsoft SharePoint Designer, Net Object Fusion, Xara Web Designer, etc.). ii. List elements of web design: – Navigation – Visual design – Content – Web-friendly – Interaction Information Accessibility – Intuitiveness – Branding – Turnaround time – Conversion, etc. iii. Use Dreamweaver for: – Social Media Management – Social Media Marketing – Website Design & Web Development – Pay Per Click (PPC) Management and Advert Consulting, etc.
SECTION D: Managing Computer Files
11. Concept of Computer Files
Topics:
(a) Definitions of Basic Terms (b) File Organizations (c) Methods of Accessing Files (d) File Classifications (e) Criteria for Classifying Files
Objectives:
Candidates should be able to:
i. Define some basic terms (File, record, field, data item, etc.). ii. Identify and use basic data types (numeric, alphabetic, and alphanumeric). iii. Explain the relationship among file structure items (Data item — field – record-file-database).
Software and Application Understanding:
Candidates should be able to:
i. Distinguish between system and application software.
ii. Enumerate various types of system software, including Operating Systems, Utility Software, Middleware, Device Drivers, Translators, etc.
iii. Define an Operating System (OS).
iv. Outline the functions of an Operating System.
v. Categorize Operating System User Interfaces into Text (Command-Line and Menu) and Graphical User Interface (GUI).
vi. Provide examples of Operating Systems such as MS Windows, LINUX, UNDC, etc.
vii. Discuss different Operating Systems utilized on mobile devices like phones, iPads (Android, Blackberry, iPhone, etc.).
viii. Clearly articulate the definition of Utility Software.
ix. List functions associated with Utility Software.
x. Identify diverse types of Utility Software.
xi. Illustrate examples of Utility Software, including Editors, Anti-Virus programs, etc.
xii. Define Translators and elucidate the functions of Translator Software.
xiv. Enumerate the various categories of translators, including Interpreter, Assembler, and Compiler.
xv. Elaborate on the distinctions among these translator categories.
Candidates should also be able to:
i. Compile a list of examples of application software and expound on their usage.
ii. Discriminate between open source and proprietary software.
iii. Analyze different methods for acquiring Application software, considering options like building in-house solutions or utilizing off-the-shelf products.
iv. Clarify the distinctions between User Application programs and general-purpose Application packages.
v. Furnish examples of common off-the-shelf Application packages, including Word Processing (MS Word), Spreadsheet (Excel), Database (Access), Presentation (PowerPoint), Graphics (Adobe Photoshop), Accounting (Sage), Payroll (Sage), Government (Remita), Banking (Fusion Banking Essence), Statistics (SPSS), Educational (School Shell), Hospital (eHospital), etc.
Data and Information:
Topics:
a. Differences between Data and Information
b. Data representation.
c. Methods of Digitization
Objectives:
Candidates should be able to:
i. Clearly define data and information.
ii. Enumerate properties associated with information.
Candidates should be able to:
i. List various types of data types, such as integers, real numbers, strings, multimedia (image, audiovisual, signal, etc.).
ii. Identify methods for representing and handling data, with a focus on number bases, including binary, decimal, hexadecimal, etc.
Candidates should be able to:
i. Define digitization.
ii. Explain the process of digitalization, encompassing manual, heads-up, interactive tracing, automatic methods.
iii. Enumerate diverse formats of digitized data, including image, audio, video, motion, text, multimedia, etc.
SECTION C: Computer Application Packages
5. Word Processing Package
Topics:
(a) General Concept
(b) Creating and Saving Documents
(c) Editing, Formatting, and Insertion
(d) Printing
(e) MS Word
i. Features
ii. Launching MS Word
iii. Basic Operations
iv. Other Operations
Objectives:
Candidates should be able to:
i. Define word processing and provide examples of word processing packages (MS Word, WordStar, WordPerfect, Open Word, etc.).
ii. Identify features of Word Processing packages in general (create, save, edit, insert, print, share, etc.).
iii. List the application areas of Word Processing packages (Office, Publishing, Journalism, Education, etc.).
Candidates should be able to:
i. Launch MS Word effectively.
ii. Perform MS Word basic operations: create, edit, save, retrieve, print, copy, move, etc.
iii. Utilize different types and sizes of fonts.
iv. Execute MS Word operations such as formatting, justifying, searching/exploring, spell-checking, and file merging.
vi. Close MS Word.
6. Spreadsheet Package
Topics:
(a) General Concept
(b) Creating and Saving Documents
c) Editing, Formatting, and Insertion
(d) Printing
(e) MS Excel
i. Features
ii. Launching MS Excel
iii. Basic Operations
iv. Other Operations
Objectives:
Candidates should be able to:
i. Define Spreadsheet and provide examples of Spreadsheet packages (MS Excel, VisiCalc, SuperCalc, SPSS, etc.).
ii. Identify features of Spreadsheet packages in general (create, save, edit, insert, print, share, etc.).
iii. List the application areas of Spreadsheet packages (Accounting, Engineering, Statistics, Calculation, what-if scenarios, Education, etc.).
Candidates should be able to:
i. Launch MS Excel effectively.
ii. Define basic terms in MS Excel: worksheet, workbook, cells, cell ranges, etc.
iii. Use MS Excel to create, edit, save, retrieve, and print spreadsheet documents.
iv. Utilize data types in MS Excel (Number, Labels, Formula, etc.).
v. Perform basic operations in MS Excel: Data Entry, Saving, Retrieving, Moving, Copying, etc.
vi. Perform arithmetic calculations using formulas and inbuilt functions, etc.
vii. Use different types and sizes of fonts.
viii. Execute additional MS Excel operations (Formatting, Editing, Printing, Drawing charts, etc.).
ix. Close MS Excel.
Leave a Reply