StudyPath

OTM 214 Information Communications Technology 2

ND2 levelManagement & Administration12 topics

OTM 214 covers 12 topics. StudyPath paces them into daily study sessions that finish before your exam date, with practice questions and worked answers for each one.

Study OTM 214 on StudyPath

Free for every student. No card.

Course outline

The topics this course covers, in teaching order.

  1. Introduction to spreadsheets
  2. Uses and importance of spreadsheets
  3. Spreadsheet structure and planning
  4. Data entry, editing and cell operations
  5. Spreadsheet formatting and appearance
  6. Formulas, functions and recalculation
  7. Replicating formulas and linking worksheets
  8. Problem solving with spreadsheets
  9. Printing, saving and managing spreadsheets
  10. Numeric keyboarding techniques
  11. Charts and graphs in Excel
  12. Visual presentations using a computer

A sample from this course

One topic, as StudyPath teaches it.

Introduction to spreadsheets

Spreadsheets are electronic tables that allow users to store, organise, and analyse data through cells, rows, columns, and worksheets. Mastering basic operations—cell referencing, formula creation, and data formatting—enables efficient data handling, crucial for the NUC CCMAS, NBTE, and NCCE exams where practical data manipulation is often tested.

What you get for OTM 214