Basic Computer (National Certificate End-User Computer)

A person credited with this unit standard is capable of: Importing and exporting text files. Consolidating and linking data within spreadsheets. Applying filters and use forms in a spreadsheet. Creating and using macros. Combining and comparing large sets of data in a spreadsheet.

A person credited with this unit standard is capable of: Demonstrating an understanding of and use master and sub documents. Using outline options. Creating and use fields. Creating and use forms. Creating and automate tasks using macros.

This unit standard will be useful to people who aim to achieve recognition at some level in Further Education and Training or to meet the Fundamental requirement of a wide range of qualifications registered on the National Qualifications Framework. People credited with this unit standard are able to: Use mathematics to plan and control personal and/or household budgets and income and expenditure. Use simple and compound interest to make sense of and define a variety of situations including investments, stokvels, inflation, appreciation and depreciation. Investigate various aspects of financial transactions including costs, prices, revenue, cost price, selling price, loss and profit.

People credited with this unit standard are able to: Explain the principles of the internet and the world-wide-web Explain how the world-wide-web incorporates the various internet applications The performance of all elements is to a standard that allows for further learning in this area

People credited with this unit standard are able to: Convert numbers between the decimal number system and binary number system Work with numbers in different ways to express size/magnitude. Demonstrate the effect of error in calculations.

Learners credited with this unit standard are able to: interact successfully with audience in oral communication use strategies that capture and retain the interest of an audience identify and respond to manipulative use of language

Learners credited with this unit standard are able to: write for a specified audience and purpose use language structures and features to produce coherent and cohesive texts for a wide range of contexts draft own writing and edit to improve clarity and correctness

A person credited with this Unit Standard is capable of: Inserting and deleting sections within a document while maintaining document integrity. Inserting, editing and deleting headers and footers within a document. Facilitating online review of documents using comments and tracking changes. Creating and using Styles in a document. Creating, editing and/or deleting references in a document. Creating, editing and using electronic links in a document.

This Unit Standard is intended for people who are required to perform routine financial transactions and calculations. Individuals who are credited with this Unit Standard will be able to apply the processes and procedures necessary to initiate the recording of disbursements and revenues, and to understand the financial implications to the organisation of each element in the transaction.

Learners competent at this level will be able to deal with learning materials, to access and use useful resources, to seek clarification and help when necessary, and apply a range of learning strategies. They do this with an understanding of the features and processes of the workplaces of the workplaces and occupations to which their learning programmes refer. Learners credited with this standard are able to: access and use suitable learning resources use learning strategies manage occupational learning programme materials conduct basic research and analyse and present findings function in a team reflect on how characteristics of the workplace and occupational context affect learning

The qualifying learner is capable of: Relating the purpose, content, form, frequency and recipients of a range of reports to the information needs of a selected business Identifying information sources and organisational procedures for obtaining and distributing information relevant to a selected business function. Compiling reports related to a selected business function, ensuring content and format are appropriate to information requirements and that reporting deadlines are met Liasing with relevant parties and verifying that reported information is in accordance with requirements and purpose of the report.

People credited with this unit standard are able to: describe problem analysis and program design techniques describe different data representations used in computer programs describe basic programming principles described the principles used in designing a computer program The performance of all elements is to a standard that allows for further learning in this area

A person credited with this unit standard is capable of: Demonstrating an understanding of and use master and sub documents. Using outline options. Creating and use fields. Creating and use forms. Creating and automate tasks using macros.

A person credited with this unit standard is capable of: Analysing the use of forms and reports. Designing a form with all the necessary controls for ease of use in an end user environment. Creating a report for meaningful interpretation of data.

A person credited with this unit standard is capable of: Outlining data in a spreadsheet. Modifying the display of spreadsheet data. Applying conditional formatting to data. Creating and use templates. Working with comments.

People credited with this unit standard are able to: Describe data communication. Demonstrate knowledge of main features of LAN`s Demonstrate knowledge of main features of WAN`s. The performance of all elements is to a standard that allows for further learning in this area.

People credited with this unit standard are able to: Create and edit a table. Create and edit columns in a document. Format columns in a document.Format a table according to given requirements.

Each person should contribute to the smooth running of the office and as such should help others wherever possible. The right attitudes will lead to more efficient operations with greater respect for others. All staff should be able to do basic maintenance and replenishment of consumables.

People credited with this unit standard are able to: Describe past, present and emerging developments in data communication. Describe synchronous and asynchronous data communication. The performance of all elements is to a standard that allows for further learning in this area.

Monitor and control the maintenance of office equipment

People credited with this unit standard are able to: Plan the research of a computer topic Conduct the research of a computer topic using computer technology, and to Present the results of research of a computer topic using computer technology.

The qualifying learner is capable of: Demonstrating an understanding of project management tools. Using a range of project management tools.

People credited with this unit standard are able to: Demonstrate an understanding of the principles of spreadsheets. Create, open and save spreadsheets. Produce a spreadsheet from a given specification. Edit a spreadsheet. Format a spreadsheet. Check spelling in a spreadsheet. Print a spreadsheet using features specific to spreadsheets.

People credited with this unit standard are able to: Measure, estimate, and calculate physical quantities in practical situations relevant to the adult in life or the workplace Explore describe and represent, interpret and justify geometrical relationships and conjectures to solve problems in two and three dimensional geometrical situations

This unit standard is intended for people who need a fundamental understanding of the concepts of Information and Communication Technology (ICT) either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry. People credited with this unit standard are able to: Describe the components of Information and Communication Technologies. Describe the hardware components of a personal computer. Describe software for personal computers. Describe information networks in relation to ICT. Describe ergonomic principles for computer workstations. Explain health and safety when working with computers. Setup a computer workstation taking ergonomic principles and health and safety issues into account.

People credited with this unit standard are able to: Work with multiple documents. Format text. Format paragraphs. Format pages. Format a document. Templates are used and created.

People credited with this unit standard are able to: Prepare and produce a presentation according to a specified brief. Adjust settings to customise the view and preferences of the presentation application. Work with multiple presentations. Format a presentation. Use special presentation effects. Apply special formatting to a presentation. Customise a presentation for a specified purpose. Evaluate a presentation produced for a specified purpose.

People credited with this unit standard are able to: Understand the concepts and terms of the Internet. Explain legal and ethical issues in relation to Internet use. Use a GUI-based browser to display a given Web Page. Adjust settings to customise the view and preferences of the browser application. Navigate on the Internet. Use a Search Engine to locate given information specifications. Obtain information from a Web site.

People credited with this unit standard are able to: Explain legal, ethical and organisational issues in relation to the use of E-mail. Work with multiple E-mail messages. Manage E-mail messages. Use the address book facilities of an electronic mail application.

A person credited with this unit standard is capable of: Creating and using templates in a GUI based presentation application. Manipulating graphics/images and drawn objects. Using charts/graphs to enhance presentations. Using sound and video to enhance presentations. Customising and controlling a slideshow.

People credited with this unit standard are able to: Prepare and produce a spreadsheet to provide a solution to a given problem. Adjust settings to customise the view and preferences of the spreadsheet application. Work with multiple worksheets. Apply formulae to worksheets to provide alternative solutions to a problem. Apply simple built-in functions of the spreadsheet application to the given problem. Apply formatting to a spreadsheet applicable to the given problem. Use special effects to improve the presentation of the spreadsheet. Evaluate a spreadsheet.

People credited with this unit standard are able to: Create a graph in a presentation. Create an organisational chart in a presentation. Create a drawing in a presentation. Import images into a presentation. Images and objects are manipulated in presentation. Animation effects and transitions are applied or added to a presentation. Master Slides are customised within a presentation.

eople credited with this unit standard are able to: Understand the principles of databases. Open and save a simple existing database. Produce and edit a simple database from given specifications. Data is entered into a simple database table from given specifications. Modify the design of a database table. Sort and search for records in a database table.

eople credited with this unit standard are able to: Understand the concepts and terms of electronic messaging. Create and send an E-mail message. Receive and respond to e-mails. Work with multiple E-mail messages. Adjust settings to customise the view and preferences of the E-mail application.

People credited with this unit standard are able to: Create and edit a graph/chart. Load data from an external data source to produce a given spreadsheet result. Insert and edit objects in a spreadsheet.

People credited with this unit standard are able to: Describe the uses of merged documents. Create a merged document.

A person credited with this unit standard is capable of: Using the desktop of a Graphical User Interface (GUI)-based operating system. Using the features of a GUI Window. Using of the Help facility in a GUI environment. Using a pointing device in a GUI environment. Using generic print options in a GUI environment.

A person credited with this unit standard is capable of: Customising email settings. Applying security settings to messages. Creating and using contacts. Creating and using appointment/events.

Demonstrate an understanding of preventative maintenance, environmental and safety issues in a computer environment

This unit standard is intended: to provide knowledge at a proficient level, of the areas covered for those working in, or entering the workplace in the area of Information Systems & Technology Management. as additional knowledge for those wanting to understand the areas covered People credited with this unit standard are able to: Plan an investigation of the use of computer technology in an organisation Conduct an investigation of the use of computer technology in an organisation Describe the use of computer technology in an organisation Evaluate the use of computer technology in an organisation Present the results of the investigation of the use of computer technology in an organisation. The performance of all elements is to a standard that allows for further learning in this area.

Design complex tables and queries using a graphical user interface (GUI) based database to solve a given problem

The qualifying learner is capable of: Demonstrating and understanding of office equipment maintenance procedures and processes Conducting routine maintenance on designated office equipment

A person credited with this Unit Standard is capable of: Inserting and deleting sections within a document while maintaining document integrity. Inserting, editing and deleting headers and footers within a document. Facilitating online review of documents using comments and tracking changes. Creating and using Styles in a document. Creating, editing and/or deleting references in a document. Creating, editing and using electronic links in a document.

A person credited with this unit standard is capable of: Creating and using templates in a GUI based presentation application. Manipulating graphics/images and drawn objects. Using charts/graphs to enhance presentations. Using sound and video to enhance presentations. Customising and controlling a slideshow.

The qualifying learner is capable of: Demonstrating an understanding of project management tools. Using a range of project management tools.

People credited with this unit standard are able to: Describe Information and Communication Technology (ICT). Describe the use and effect of ICT on modern society. Explain the effect of the legal environment on ICT.

A person credited with this unit standard is capable to: Demonstrating an understanding of relational database theory. Analysing unstructured data not populated to a relational database model. Creating queries using specific functions. Creating different types of queries. Creating parameter queries and adding calculated fields. Creating basic select queries using simple SQL syntax.

A person credited with this unit standard is capable of: Analysing the use of forms and reports. Designing a form with all the necessary controls for ease of use in an end user environment. Creating a report for meaningful interpretation of data.

A person credited with this unit standard is capable of: Setting up a spreadsheet. Applying security. Checking input data. Checking formulas and totals. Checking output data. Auditing spreadsheets. Validating and sorting data in a spreadsheet.

People credited with this unit standard are able to: Explain and differentiate between Information Technology and Communication Technology. Explain what is risk. Describe information security problems and recommend simple solutions. Describe computer viruses and virus attacks. Describe the management of computer viruses using anti-virus software.

People credited with this unit standard are able to: Explain computer architecture elements Explain the organisation of a computer Describe the design constraints in the design of instruction sets for computers The performance of all elements is to a standard that allows for further learning in this area.

The qualifying learner is capable of: Analysing the basic elements of an income and expenditure statement. Analysing the basic elements of a balance sheet. Compiling a personal assets and liabilities statement. Using the evidence in financial statements to make a financial decision.

A person credited with this unit standard is capable of: Validating and sorting data in a spreadsheet. Applying security settings to a spreadsheet. Using a range of functions within a spreadsheet. Using formula, mixed references and named ranges to provide solutions to a problem. Auditing formula to ensure data integrity. Creating and edit scenarios.

This unit standard is intended for people who need to plan, produce, use and databases to solve problems using a Graphical User Interface (GUI)-based database application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry. People credited with this unit standard are able to: Prepare a database to provide a solution to a given problem. Create a data entry form for a new database table to solve the given problem. Retrieve information from a database. Sort data in a database query. Create a report for a database table. Perform advanced print options for a database.

The qualifying learner is capable of: Demonstrating an understanding of criteria for working as a member of a team. Working autonomously and collaborating with other team members. Contributing to building relationships between team members and stakeholders. Making a positive contribution to team coherence, image and spirit. Respecting personal, ethical, religious and cultural differences to enhance interaction between team members.

he qualifying learner is capable of: Explaining etiquette, conventions and compliance issues relating to electronic communications. Organising and setting parameters for a mailbox. Using an electronic communication system to send and receive mail. Managing the messages in an electronic mail facility on a workstation.