Skip to content
Office AdministrationCertificationNCS standard

Certifyd Digital Essentials Practitioner (CDEP)

The Certifyd Digital Essentials Practitioner (CDEP) is the entry point for office workers who want to produce professional documents, spreadsheets and presentations, and use computers, the web and email safely and ethically.

Or start with one core course. It counts toward the CDEP once you finish it.

Sample
Certifyd

This certifies that

Nur Aisyah binti Ahmad, CDEP

has completed the certification

Certifyd Digital Essentials Practitioner (CDEP)

CFY-2026-000000

Sample certificate
Verified

Certifyd Digital Essentials Practitioner (CDEP) is a Certifyd certification for Office Administration professionals in Malaysia, aligned to NCS competency standards. You earn it by completing 3 core courses, 3 days in total, live online, each assessed by an online test and a work document. It starts with a free 10-minute online Readiness Check.

Duration
3 days
Level
NCS standard
Price
From RM 1,770.00

Why earn the CDEP?

Most office work now lands in a document, a spreadsheet or a slide deck, and a broken formula or a misplaced file costs time and trust. Handling files, online information and personal data properly also matters under the Personal Data Protection Act 2010.

As a CDEP you can prepare and format documents and mail merges, build spreadsheets with formulas, functions and charts, develop presentations, organise files and folders, and search, communicate and handle data safely online.

What will you be able to do as a CDEP?

The Certifyd Digital Essentials Practitioner (CDEP) is the entry point for office workers who want to produce professional documents, spreadsheets and presentations, and use computers, the web and email safely and ethically.

The Certifyd Digital Essentials Practitioner (CDEP) brings together 3 core courses, 3 days in total, aligned to NCS competency standards. You can start with any core course, and each one counts the moment you pass its online test and work document. When every course is credited, you submit the certification assessment and earn the CDEP title.

  • Create, format and finalise word processing documents, including tables, objects and mail merge
  • Build spreadsheets with formulas, functions, formatting and charts, and prepare accurate outputs
  • Develop and finalise presentations with formatted text, charts and graphical objects
  • Manage files and folders and keep devices and data secure
  • Search online ethically, respect copyright and data protection, and manage email well

Who is the CDEP for?

  • Clerks, receptionists and admin assistants
  • Staff moving into office or desk roles
  • Employers who want a common digital baseline
  • Not sure you are ready? The free readiness check shows where you stand before you pay anything.

Which core courses lead to the CDEP?

Take them in any order, live online. Each one earns its own certificate and transcript.

What does the CDEP cover?

Each unit is a national competency standard.
Two office administrators counting stationery stock with a clipboard and a tablet in a neat supply room
  • Digital EssentialsNational competency unit
  • Effective Word Processing1 day: Produce clean, consistently formatted letters and documents, and manage the files behind them.
  • Effective Spreadsheet Usage1 day: Build accurate spreadsheets with formulas, functions and charts, and keep the data in them safe.
  • Effective Presentation Development1 day: Develop clear presentations with well formatted text, charts and graphics, using online sources properly.

How do you earn the CDEP?

Free Readiness Check first, a verifiable certificate at the end.
  1. Check your readiness, freeTake Digital Skills Readiness Check online. It scores each area and names the core course to take first.
  2. Finish the core coursesTake 3 core courses in any order, live online. Each one is credited the moment you pass its test and work document.
  3. Pass the certification assessmentSubmit your certification assessment online. An assessor reviews it and a verifier checks the result. If more evidence is needed, you can resubmit.
  4. Use your titleReceive your certificate with a QR code and use CDEP after your name. Anyone can verify it online.
  5. Go for the JPK microcredentialJoin the one-day in-person Portfolio Development Workshop to organise your evidence, then apply for Microcredential in Digital Essentials through PPT.
  • The final assessment opens once every core course is credited and the certification is bought.

Which JPK microcredentials does the CDEP prepare you for?

Assessed separately through PPT against these units. Certifyd courses help you understand each unit and build the evidence.

Microcredential in Digital Essentials

NCS-006:2017

Prepared by: Effective Word Processing, Effective Spreadsheet Usage, Effective Presentation Development.

Computer Essential Usage (NCS-006:2017-C01)

  1. Work activity 1: Operate computer and devices

    Performance criteria

    • Key concepts relating to ICT, computers, devices and software identified
    • Computers start up and shut down carried out

    Related knowledge

    • The term Information and Communication Technology (ICT)
    • Types of ICT services/uses:-
      • Internet services
      • Mobile technology
      • Office productivity applications
    • The term hardware. Main types of computer:-
      • Desktops, laptops, tablets
    • Main types of digital devices:-
      • Smart-phones
      • Media players
      • Digital cameras
    • The terms processor, Random Access Memory (RAM), storage and the impact on performance when using computers and devices
    • Main types of integrated and external peripherals:-
      • Printers
      • Screens
      • Scanners
      • Keyboards
      • Mouse/track-pad
      • Webcam
      • Speakers
      • Microphone
      • Docking station
    • Common input/output ports such as USB and HDMI
    • Types of software licensing
      • Proprietary
      • Open source
      • Trial version
      • Shareware
      • Freeware
    • The term software and the main types of software such as:-
      • Operating systems
      • Applications.
      • Locally installed versus online software
    • The term operating system and common operating systems for computers and devices
    • Common examples of applications such as:-
      • Office productivity
      • Communications, Social networking
      • Media, design
      • Mobile applications
    • The term End-User License Agreement (EULA) and licensing of software before use
  2. Work activity 2: Configure desktop and icons setting

    Performance criteria

    • Icons and windows used effectively
    • Main operating system settings applied
    • Built in help features used

    Related knowledge

    • Desktop and Icons:-
      • The purpose of the desktop and the task bar
      • Common icons such as those representing: files, folders, applications, printers, drives, shortcuts/aliases, recycle bin/wastebasket/trash
    • Window
      • The different parts of a window: title bar, menu bar, toolbar, ribbon, status bar, scroll bar
    • Tools and Settings
      • Available help functions
      • Computer's basic system information: operating system name, version number and installed RAM
      • Knowledge of desktop configuration settings (date and time, volume settings, background, resolution)
      • Keyboard language. Changing default language
      • Shutting down a non-responding application
      • Installing, uninstalling an application
      • Connecting a device (USB flash drive, digital camera, media player) to a computer
      • Disconnecting a device using an appropriate routine
      • Capturing a full screen, active window
  3. Work activity 3: Produce text documents/ files

    Performance criteria

    • Text document created
    • Text document saved and named
    • Text document printed

    Related knowledge

    • Working with Text:-
      • Opening, closing a text document application
      • Opening, closing files
      • Entering text into a document
      • Copying, moving text within a document, between open documents Pasting a screen capture into a document
      • Saving and name a document
    • Printing:-
      • Installing and uninstalling a printer
      • Printing a test page
      • Setting the default printer from an installed printer list
      • Printing a document from a word processing application
      • Viewing, pausing, restarting, and cancelling a print job
  4. Work activity 4: Manage computer file and folders

    Performance criteria

    • Knowledge of file management applied
    • Files and folders organised efficiently
    • Knowledge of storage concepts applied
    • Large files compressed and extracted using utility software

    Related knowledge

    • Introducing files and folders:-
      • How an operating system organises drives, folders, files in a hierarchical structure
      • Common file types such as: word processing, spreadsheet, presentation, portable document format, image, audio, video, compressed, executable files
      • Good practice in folder, file naming: use meaningful names for folders and files to help with searching and organisation
    • Organising files and folders:-
      • Selecting individual, adjacent, non-adjacent files, folders.
      • Sorting files in ascending, descending order by name, size, type, date modified.
      • Copying, moving files, folders between folders, drives.
      • Deleting files, folders to the recycle bin/ wastebasket/ trash and restore to original location.
      • Emptying the recycle bin/ wastebasket/ trash
    • Storage and Compression:-
      • Main types of storage media (Internal hard disk, external hard disk, network drive, CD, DVD, Blu-ray disc ,USB flash drive, memory card, online file storage)
      • File size, folder size, storage capacity measurements such asKB, MB, GB, TB
      • The purpose of file and folder compression
  5. Work activity 5: Access network connection.

    Performance criteria

    • Knowledge of network concepts applied
    • Connections to network established

    Related knowledge

    • Network concepts:-
      • The term network. The purpose of a network: to share, access data and devices securely
      • The term Internet. And some of its main uses such as: World Wide Web (WWW), VoIP, e-mail, IM
      • The terms intranet, virtual private network (VPN) and their main uses
      • Transfer rate and how it is measured: bits per second (bps), kilobits per second(kbps), megabits per second (mbps), and gigabits per second (gbps)
      • The concepts of downloading from, uploading to a network
    • Network access:-
      • Different options for connecting to the Internet such as: phone line, mobile phone, cable, Wi-Fi, WiMAX, satellite
      • The term Internet Service Provider (ISP)
      • Considerations when selecting an internet subscription option such as: upload speed, download speed and quota, cost
      • The status of a wireless network: protected/secure, open
  6. Work activity 6: Confirm security and well-being of users and devices

    Performance criteria

    • User data and devices protected
    • User computer data back-up performed
    • Considerations relating to green IT indentified
    • Considerations relating to accessibility identified
    • Considerations relating to user health identified

    Related knowledge

    • Protecting data and devices:-
      • Good password policies such as: create with adequate length, adequate character mix, do not share, change regularly
      • The term firewall and outline its purpose
      • The purpose of regularly backing up data to a remote location
      • The importance of regularly updating software such as: anti-virus, application, operating system
    • Malware:-
      • The term malware
      • Different types of malware such as: virus, worm, Trojan, spyware.
      • How malware can infect a computer or device.
    • Health and green IT:-
      • Ways to help ensure a user’s well-being while using a computer or device such as: take regular breaks, ensure appropriate lighting and posture
      • Computer and device energy saving practices: turning off, adjusting automatic shutdown, backlight, sleep mode settings
      • Recycling of computers, devices, batteries, printer cartridges and paper
      • Options available for enhancing accessibility such as: voice recognition software, screen reader, screen magnifier, on-screen keyboard, high contrast

Ethical Online Essential Practices (NCS-006:2017-C02)

  1. Work activity 1: Apply web browsing skills and online security concepts

    Performance criteria

    • Connection to internet established
    • Web browsing concepts applied
    • Online security concepts applied

    Related knowledge

    • Understand the internet:-
      • The terms World Wide Web (WWW)
      • Uniform Resource Locator (URL)
      • Hyperlink
    • Connecting to the Internet
    • Web Browsing Concepts:-
      • Outline different Internet activities such as information searching, shopping, learning, government services, entertainment, and communication
    • Understand the structure of a web address:-
      • Identify common types of domains such as: geographical, organisation (.org, .edu, .com, .gov)
    • Browsing internet
    • Security and safety:-
      • Recognise ways to protect our self when online such as purchase from secure reputable websites, avoid unnecessary disclosure of personal and financial information, log off from websites, etc
    • The term encryption
    • Secure websites:-
      • Identify a secure website such as HTTPS, lock symbol
    • Controlling internet use such as:-
      • Supervision, web browsing restrictions, downloads restrictions
    • Copyright and intellectual property data protection
  2. Work activity 2: Use the web browser, tools, and settings

    Performance criteria

    • Web browser used to display web content
    • Web browser’s tools effectively utilised
    • Web browser setting customised to user’s needs

    Related knowledge

    • Technique of navigating the web browser:-
      • The address bar
      • Navigation buttons
      • New tabs
      • Tabbed browsing
      • Hyperlinks
      • History
      • Web based form
    • Usage of tools and settings:-
      • Use a web tool to translate a web page, text
      • Set a web browser home page
      • Manage pop-ups
      • Manage cookies
      • Use help functions
      • Manage toolbars and ribbon
      • Manage history, temporary internet files, saved form data
    • Usage of bookmarks:-
      • Adding and deleting a bookmark/ favourites
      • Show bookmarks/ favourites
      • Manage bookmarks/ favourites folder
      • Adding, deleting a bookmark folder
      • Add web pages to a bookmarks/ favourites folder
    • Web Outputs:-
      • Downloading files
      • Copy text, image, URL to another location such as document, e-mail, etc
      • Preview, print a web page, selection from a web page
      • Complete, submit, and reset a web based form
  3. Work activity 3: Conduct online search

    Performance criteria

    • Skills to search and evaluate online information applied
    • Online information searched ethically
    • Regulations involving key copyright and data protection issues complied with

    Related knowledge

    • Using search engines:-
      • The term search engines and common search engines
      • Differences of search engines
      • Advanced search
      • Search a web-based encyclopaedia, dictionary
    • Critical evaluation:-
      • Critical evaluation of online information
      • Purpose of different sites such as information, entertainment, opinion, sales
      • Factors that determine the credibility of a website such as author, referencing, up-to-date content, etc.
    • Knowledge of Copyright, data protection:-
      • The terms copyright, intellectual property (sources and permission)
      • Data protection rights and obligations
    • Online browsing etiquette – Introduction to netiquette
  4. Work activity 4: Utilise communication concepts

    Performance criteria

    • Good online communication practice applied
    • Communications tools utilised
    • Personal data protected when publishing and sharing online information

    Related knowledge

    • Understand online (virtual) communities:-
      • The concept of an online community, including social networking websites, internet forums, web conferencing, chat, online computer games, etc.
      • Ways that users can publish and share content online such as blogs, micro-blogs, podcasts, images, audio and video clips, etc.
      • Knowledge of self-protection when using online communities such as privacy settings, personal information, private messaging, location information, unknown users, etc.
    • Knowledge of communication tools:-
      • The term instant messaging (IM)
      • The term short message service (SMS), multimedia message service (MMS)
      • The term Voice over Internet Protocol (VoIP)
      • Good practice of electronic communication such as accuracy and brevity, clear subject headings, protection of personal details, circulation of appropriate content only, check content spelling, etc.
    • E-mail concepts:-
      • The term e-mail and its main uses
      • E-mail address structure
      • Possible problems when sending file attachments such as file size limits, file type restrictions
      • Difference between the To, Copy (Cc), Blind copy (Bcc) fields and their appropriate use
      • Possibility of fraudulent and unsolicited e-mail and possibility of virus transmission via e-mail.
      • The term Phishing
  5. Work activity 5: Manage user email essentials

    Performance criteria

    • Email user settings configured
    • Emails sent and received
    • Skills to search emails applied
    • Calendars organised

    Related knowledge

    • Sending E-mail:-
      • Accessing an e-mail account
      • Main purpose of standard e-mail folders (inbox, outbox, sent, deleted/ trash items, draft, spam/ junk)
      • Creating an e-mail
      • Entering one or more e-mail addresses, distribution list in the To, Copy (Cc), Blind copy (Bcc) fields
      • Entering an appropriate title in the subject field and entering, pasting text into the body of an e-mail
      • Adding, removing a file attachment
      • Sending an e-mail with, without priority
    • Receiving E-mail:-
      • Opening, closing an e-mail
      • Using the reply, reply to all function, and identify when these should be used
      • Forwarding an e-mail
      • Opening, saving a file attachment to a location
      • Previewing, printing a message using available printing options
    • Using tools and settings:-
      • Help functions
      • Built-in toolbars
      • Ribbon
      • Automatic reply
      • E-mail status as read, unread
      • Flag e-mails
    • Technique of organising e-mails:-
      • Adding, removing message inbox headings such as sender, subject, and date received etc.
      • Searching for an e-mail by sender, subject, e-mail content
      • Sorting e-mails by name, by date, by size
      • Creating, deleting an e-mail folder/label
      • Moving an e-mails to e-mail folder/label
      • Deleting an e-mail
      • Restoring a deleted e-mail
      • Emptying the e-mail bin/ deleting items/trash folder
      • Moving a message to, removing a message from a junk folder
    • Using Calendars:-
      • Creating and cancelling meetings in a calendar
      • Adding and removing invitees, resources to a meeting in a calendar
      • Accepting and declining an invitation

Effective Word Processing (NCS-006:2017-C03)

  1. Work activity 1: Utilise the word processing application

    Performance criteria

    • Word processing application determined
    • Different file formats explored
    • Built-in functions chosen

    Related knowledge

    • Technique of creating, naming, opening, closing, and saving a document
    • Types of document such as:-
      • Text file
      • Rich Text Format
      • Templates (memo, fax, agenda)
      • Software specific file extension.
    • Method of entering text.
    • Technique of inserting symbols
    • Type of storage media used to save documents such as:-
      • External hard drive
      • Internal hard drive
      • Cloud
      • Flash drive
    • Technique of using various functions in word application such as:-
      • Help
      • Magnification/ zoom tools
      • Spell-check
    • Technique of using view functions:-
      • Toolbars
      • Display items
      • Ribbon
  2. Work activity 2: Prepare word processing documents

    Performance criteria

    • Word processing documents created
    • Documents edited and ready to be shared and distributed

    Related knowledge

    • Types of text and numbers
    • Types of symbols.
    • Types of special characters
    • Technique of entering text into a document
    • Technique of switching between page views modes
    • Technique of editing and formatting such as:-
      • Selecting character, word, line, sentence, paragraph, entire body text
      • Display or hiding non-printing formatting marks like (spaces, paragraph marks, manual line break marks, tab characters)
    • Techniques for simple search/replace command for a specific word or phrase
    • Techniques for copy, move or text deletion
    • Techniques for using function of undo/ redo command
    • Techniques to save a document as a template or in alternative file formats
    • Techniques of closing and opening an existing document
    • Techniques of selecting text
  3. Work activity 3: Apply formatting options

    Performance criteria

    • Different types formatting applied to documents
    • Documents text, paragraph and style enhanced before distribution
    • Appropriate formatting options used

    Related knowledge

    • Techniques for using text:-
      • Changing text format: font sizes, font types
      • Applying text format: bold, italic, underline, subscript, superscript
      • Applying different colours to text
      • Applying case changes to text
      • Applying automatic hyphenation
    • Technique for using paragraphs:-
      • Merging paragraph(s)
      • Inserting, removing soft carriage return (line break)
      • Technique in aligning text
      • Text justification: left, centre, right, justified
      • Paragraph spacing options
      • Indenting paragraphs: setting, removing and using tabs
      • Applying line spacing options
    • Applying bullet formats
    • Adding and formatting text boxes
    • Technique of applying styles to text and paragraphs
    • Using the copy format tool
  4. Work activity 4: Manipulate objects in documents

    Performance criteria

    • Tables and graphical objects identified
    • Tables and graphical objects customised
    • Objects imported into documents

    Related knowledge

    • Techniques of creating tables:-
      • Creating a table ready for data insertion
      • Inserting, editing data
      • Selecting rows, columns, cells, entire table
      • Inserting, deleting rows and columns
    • Techniques of formatting tables:-
      • Modifying column width, row height
      • Modifying cell border line style, width and colour
      • Add shading/ background colour to cells
    • Techniques of working with graphical objects:-
      • Inserting an object to a specified location in a document
      • Selecting an object
      • Copying, moving an object within a document/ between open documents
      • Resizing/ deleting an object.
  5. Work activity 5: Perform mail merge

    Performance criteria

    • Main documents prepared for mail merge operations
    • Mail merge operations carried out

    Related knowledge

    • Techniques of preparing document for mail merge:-
      • Selecting a mailing list, other data file, for use in a mail merge
      • Inserting data fields in a mail merge main document
    • Techniques of generating mail merge outputs:-
      • Merging a mailing list with a letter, label document as a new file or printed output
      • Printing mail merge outputs: letters and labels.
  6. Work activity 6: Finalise word processing documents

    Performance criteria

    • Document page settings adjusted
    • Document previewed
    • Document printed

    Related knowledge

    • Techniques of setting up document:-
      • Changing document orientation: portrait, landscape. Change paper size
      • Changing margins of entire document, top, bottom, left and right
      • Recognizing good practice in adding new pages
      • Inserting, deleting a page break in a document
      • Managing headers and footers: adding, edit text in headers and footers
      • Adding fields in headers, footers: date, page number information and file name
      • Setting up page number: applying automatic page numbering to a document
    • Techniques of checking and preparing for printing:-
      • Spelling check and making changes like correcting spelling errors and deleting repeated words
      • Adding words to a built-in custom dictionary using a spell-checker
    • Procedures of printing a document from an installed printer using output options:-
      • Entire document
      • Specific pages
      • Number of copies

Effective Spreadsheets Usage (NCS-006:2017-C04)

  1. Work activity 1: Utilise the spreadsheet application

    Performance criteria

    • Spreadsheets created
    • Different file types saved
    • Skills of using built-in options applied

    Related knowledge

    • Understanding the concept of spreadsheets and navigating within the spreadsheet application:-
      • Start and exit the spreadsheet application
      • Navigate the user interface
      • Work with the built-in options
      • Create, open, save and close a workbook
      • Work with worksheets
      • Use and hide the ribbon
      • Use magnification/ zoom tools
      • Use built-in help function and resources
  2. Work activity 2: Work with spreadsheet cells

    Performance criteria

    • Data correctly entered into cell
    • Cell content edited
    • Basic cell operations applied

    Related knowledge

    • Techniques of working with workbooks:-
      • Use the keyboard to select cells
      • Use the mouse to scroll
      • Use the scroll bar shortcut menu
      • Use Go To
      • Enter text
      • Enter numbers
      • Use shortcuts for data entry
      • Edit data
      • Perform spell-check
      • Save the workbook with another name
    • Techniques of working with spreadsheet cells, worksheets and list creation:-
      • Select a cell
      • Select a range of adjacent cells
      • Select a range of non-adjacent cells
      • Select the entire worksheet
      • Select a row
      • Select a range of adjacent rows
      • Select a range of non-adjacent rows
      • Select an entire column
      • Select a range of columns
      • Select a range of non-adjacent columns
  3. Work activity 3: Work with rows, columns and worksheets

    Performance criteria

    • Columns and rows in worksheet manipulated according to user requirement
    • Worksheet managed as per user requirement
    • Data in worksheet manipulated according to user requirement

    Related knowledge

    • Techniques of managing worksheets and manipulating columns and rows:-
      • Adjust column width
      • Adjust the row height
      • Automatically adjust column
      • Insert columns and rows
      • Delete columns and rows
      • Freeze and unfreeze columns and rows
    • Techniques of managing worksheets:-
      • Switch between worksheets.
      • Insert a new worksheet
      • Delete a worksheet
      • Use meaningful worksheet names
      • Copy, move and rename a worksheet within a spreadsheet
    • Techniques of manipulating data in a worksheet:-
      • Copy and paste data
      • Cut data
      • Copy formulas
      • Paste options
      • Paste list
      • Fill cells
      • Drag-and-drop edit
      • Undo and redo
      • Sort data
      • Find data
      • Replace data
      • Find and replace cell formats
  4. Work activity 4: Apply spreadsheet formulas and functions

    Performance criteria

    • Arithmetic formulas using standard spreadsheet functions created
    • Logical formulas using standard spreadsheet functions created
    • Relative and absolute cell referencing in formulas demonstrated

    Related knowledge

    • Techniques of creating mathematical and logical formulas using standard spreadsheet functions including good practice in formula creation e.g. refer to cell references rather than type numbers into formulas:-
      • Using basic formulas
      • Entering formulas
      • Basic functions
      • Using the AutoSum button
      • Using the AutoSum list
      • Using AutoComplete
      • Editing functions
      • Using Auto Calculate
      • Modify formulas using range borders
      • Check errors
      • Create an absolute reference
      • Use the IF function
  5. Work activity 5: Utilise cell formatting features

    Performance criteria

    • Numbers in spreadsheet correctly formatted
    • Formatting of text in cell applied
    • Formatting of cells content correctly applied

    Related knowledge

    • Techniques of formatting numbers in spreadsheet cells:-
      • Apply number formats
      • Apply accounting number style
      • Apply percent style
      • Apply comma style
      • Apply decimal places
    • Techniques of formatting text in spreadsheet cells:-
      • Format text
      • Change the font
      • Change font size
      • Apply bold and italic style
      • Underline text
      • Change font colour
      • Rotate text
      • Apply text wrapping
      • Change cell alignment
    • Techniques of formatting cell content in a spreadsheet:-
      • Merge cells
      • Vertical alignment
      • Split cells
      • Add borders
      • Draw borders
      • Add fill colour to cells
      • Format painter
      • Insert cut or copied cells
      • Delete cells
  6. Work activity 6: Develop charts

    Performance criteria

    • Charts created according to prepared data
    • Charts format customised to convey information meaningfully

    Related knowledge

    • Techniques of choosing, creating and formatting charts to communicate information meaningfully:
      • Insert a column chart
      • Insert a line chart
      • Insert a bar chart
      • Insert a pie chart
      • Move and resize a chart
      • Add chart title
      • Change the chart background
      • Format a chart title, chart axis, chart legend
      • Change a column, bar, line or pie slice colours
      • Change the chart type
      • Add data labels to a chart
      • Change the chart layout
      • Copy and move charts
      • Delete a chart
  7. Work activity 7: Prepare spreadsheet outputs

    Performance criteria

    • Spreadsheet page settings configured
    • Spreadsheet content checked and printed

    Related knowledge

    • Techniques of adjusting the spreadsheet page settings:
      • Change worksheet margins
      • Change worksheet orientation
      • Change worksheet page size
      • Change headers and footers
      • Change header and footer fields
      • Scale the worksheet to fit the page(s)
      • Repeat row and column labels
      • Change sheet options
    • Techniques of checking and correcting the spreadsheet content before finalising for printing:
      • Print preview
      • Print the current worksheet
      • Apply automatic title rows to all printed pages
      • Print a selected range
      • Print a page range
      • Print multiple copies

Effective Presentation Development (NCS-006:2017-C05)

  1. Work activity 1: Utilise the presentation application

    Performance criteria

    • Presentation application determined
    • Built-in options of presentation application selected

    Related knowledge

    • Technique of working with presentation application:-
      • Open, close a presentation application
      • Create a new presentation based on default template
      • Save a presentation to a location on a drive
      • Saving a presentation under another name.
      • Save a presentation as another file type: Rich Text Format (.RTF), template, show, image file format, version number
      • Switching between open presentations
    • Technique of enhancing presentation output:-
      • Set user preferences in the application (such as user name, default folder to open and save files)
      • Use available Help functions
      • Use magnification/zoom tools
      • Display, hide built-in toolbars.
      • Restore and minimize the Ribbon
  2. Work activity 2: Develop a presentation

    Performance criteria

    • Presentation contents determined
    • Presentation views selected
    • Slide layouts and designs chosen

    Related knowledge

    • Presentation views customization:-
      • Use a different title for each slide to distinguish it in outline view, when navigating in slide show view
      • Change between presentation views modes: normal view, slide sorter view and slide show view
    • Slides layout:-
      • Choose a different built-in slide layout for a slide
      • Apply an available design template to a presentation
      • Change background colour on specific slide(s), all slides
      • Add a new slide with a specific slide layout like: title slide, chart and text, bulleted list, table/spreadsheet
      • Copy and move slides within the presentation, between open presentations.
      • Delete slide(s)
    • Master slide layout:-
      • Insert a graphical object (picture, image, drawn object) into a master slide
      • Remove a graphical object from a master slide
      • Enter text into footer of a specific slide and all slides in a presentation
      • Apply automatic slide numbering, automatically updated date, non-updating date into footer of a specific slide and all slides in a presentation
  3. Work activity 3: Apply text formatting option

    Performance criteria

    • Suitable text format used in presentation
    • Effective text format applied

    Related knowledge

    • Technique of handling Text:-
      • Enter text into a placeholder in standard, outline view
      • Edit text in a presentation.
      • Copy and movetext within, between presentations
      • Delete text
      • Use the undo and redo command
    • Technique of formatting text:-
      • Change text formatting: font sizes, font types
      • Apply text formatting: bold, italic, underline and shadow
      • Apply different colours to text.
      • Apply case changes to text
      • Align text left, centre and right in a text frame
      • Indent bulleted text.
      • Remove indent from bulleted text
    • Technique of formatting bullets and numberings:-
      • Adjust line spacing before and after bulleted, numbered lists
      • Switch between the different standard bullet, number styles in a list
    • Technique of editing tables:-
      • Enter and edit text in a table slide
      • Select rows, columns, entire table
      • Insert, delete rows and columns
      • Modify column width, row height.
  4. Work activity 4: Apply charts formatting options

    Performance criteria

    • Suitable charts chosen
    • Effective chart format applied

    Related knowledge

    • Technique of using charts:-
      • Input data to create built-in charts in a presentation: column, bar, line, pie
      • Select a chart
      • Change the chart type
      • Add, remove and edit a chart title
      • Add data labels to a chart: values/numbers, percentages
      • Change the background colour of a chart
      • Chang the column, bar, line, pie slice colours in a chart
    • Technique of developing and customizing organization charts:-
      • Create an organization chart with a labelled hierarchy by using a built-in organization chart feature
      • Change the hierarchical structure of an organization chart
      • Add/remove co-workers and subordinates in an organization chart
  5. Work activity 5: Apply graphical objects

    Performance criteria

    • Suitable graphical objects chosen
    • Effective graphical objects format applied
    • Pictures inserted and edited
    • Drawn objects created and edited

    Related knowledge

    • Techniques of manipulating graphical objects such as:-
      • Insert a graphical object (picture, image, drawn object) into a slide
      • Select a graphical object
      • Copy and move graphical objects, charts within the presentation, between open presentations
      • Resize and delete graphical objects, charts in a presentation
      • Rotateand flip a graphical object
      • Align a graphical object relative to a slide: left, centre, right, top, bottom
      • Add different types of drawn object to a slide: line, arrow, block arrow, rectangle, square, oval, circle, text box
      • Enter text into a text box, block arrow, rectangle, square, oval, circle
      • Chang drawn object background colour, line colour, line weight, line style
      • Chang arrow start style, arrow finish style
      • Apply a shadow to a drawn object
      • Group and ungroup drawn objects in a slide
      • Bring a drawn object one level forward, one level backward, to the front, to the back of other drawn objects
  6. Work activity 6: Finalise presentation materials

    Performance criteria

    • Animation and transition effects applied to presentation
    • Presentation content checked and corrected
    • Presentation slide show previewed and printed

    Related knowledge

    • Technique of preparation and customisation of presentation output:-
      • Add and remove transition effects between slides
      • Add and remove preset animation effects for different slide elements
      • Add presenter notes to slides
      • Select appropriate output format for slide presentation like: overhead, handout, on-screen show
      • Hide and show slides
    • Procedure of spell-check and delivery of presentation:-
      • Spell-check a presentation and make changes like: correcting spelling errors, deleting repeated words
      • Change slide setup, slide orientation to portrait, landscape
      • Change paper size
      • Print entire presentation, specific slides, handouts, notes pages, outline view of slides, number of copies of a presentation
      • Start a slide show from first slide, from current slide
      • Navigate to next slide, previous slide, specified slide during a slide show

Source: NCS-006:2017 Digital Essentials. Assessed separately through PPT; Certifyd does not award the microcredential.

Where do you start?

Ten minutes, free, no sign-up.

Digital Skills Readiness Check is the free online Readiness Check for this certification. In about 10 minutes it scores each area of the job and names the core course that closes your biggest gap. No sign-up to see your result.

Start with the free readiness check, then one core course. You get a certificate for that course straight away, and it stays credited toward the CDEP whenever you continue.

How much does the CDEP cost?

Live classes by date, then the assessment.

Book each core course by date, then pay for the certification assessment that awards your title. No subscription, no hidden fees.

That is 3 core courses and a final assessment, 3 days of training in total, ending in a title you keep.

  • Live class

    A MITE trainer on set dates, live online. The Certifyd Trainer programme runs in person.

    From RM 590.00

    Duration
    3 days
  • Assessment and certificate

    Your Certifyd certification assessment and certificate. Core courses are booked by date.

    RM 1,770.00

Same track, another title.
See the Office Administration track

Frequently asked questions.

Short answers to what people ask first.

How long does the CDEP take?

The 3 core courses add up to 3 days of classes, live online. Each course ends with an online test and a work document.

Is the CDEP aligned to NOSS?

Yes. It is a Certifyd certification aligned to NCS competency standards. The certificate is issued by Certifyd by MITE, not by a government body.

Can I take one core course first?

Yes. Each core course is sold on its own with its own certificate, and it counts toward the CDEP when you continue.

Where do the classes run?

Core courses run live online with a MITE trainer, so you can join from anywhere in Malaysia. The optional one-day Portfolio Development Workshop is in person.

How much does it cost?

The current live class prices are shown above. If a price is not published yet, it shows price on request.

Is the CDEP recognised by employers?

The CDEP is a Certifyd certification, aligned to NCS competency standards. Each employer decides what it accepts, so the certificate makes checking easy: it names the units behind it, each course comes with a transcript, and any employer can verify it online in seconds.

How are you assessed?

Each core course ends with an online knowledge test (multiple choice) and a performance task: you produce a real work document. When every course is credited, you submit your certification assessment online, an assessor reviews it and a verifier checks the result. There is no oral test.

Can my employer pay for the CDEP?

Yes. When you enrol, choose My employer will sponsor me. We make a private link you send to HR, and they pay by invoice. Teams can ask for a quote on the For companies page.

When do I sit the assessments?

At the end of each core course, then the certification assessment once every course is credited. The live classes run on the dates you choose.

Does the CDEP lead to a JPK microcredential?

It prepares you for one. The JPK microcredential (Penyata Pencapaian) is assessed separately through PPT, recognition of prior achievement, against the same units. Your course certificates and transcripts become portfolio evidence, and the one-day in-person Portfolio Development Workshop helps you organise it. Certifyd does not award the microcredential.

Ready to become a CDEP?

Enrol in the full certification, or take the free readiness check and start with one course.

Or start with one core course. It counts toward the CDEP once you finish it.