Can start up and shut down a computer and work effectively on the computer desktop using icons and windows. Can adjust the main operating system settings. Can create a simple document and print an output. Knows about the main concepts of file management and can efficiently organise files and folders. Understands key storage concepts and use utility software to compress and extract large files. Understands network concepts and connection options and can connect to a network or wireless. Understands the importance of protecting data and devices from malware and can back up data. Understands key concepts related to ICT, computers, devices and software. Understands web browsing and online security concepts. Can use the web browser and manage browser settings, bookmarks and web outputs. Can effectively search for online information. Can send, receive e-mails and manage email settings. Understands key concepts related to green IT, accessibility and user health.
Can work with text documents and process them in his/her everyday office work: he/she can open, create small documents and save them in different file formats. Can apply different formats and styles to enhance documents and recognise good practice in choosing the appropriate formatting options. Can insert tables, pictures and drawn objects into documents. Can prepare documents for mail merge operations, adjust document page settings, check and correct spelling before printing.
Can open, create spreadsheets and save them in different file formats. Can enter data into cells and use good practice in creating lists. Can select, sort, copy, move and delete data. Can edit rows and columns in a worksheet, can copy, move, delete and appropriately rename worksheets. Can create mathematical and logical formulas using standard spreadsheet functions. Uses good practice in formula creation and recognizes error values in formulas. Can format numbers and text content in a spreadsheet, choose suitable charts, create and format charts to communicate information meaningfully. Can adjust spreadsheet page settings, check and correct spreadsheet content before printing.
Can work with presentations and save them in different file formats. Can distinguish different presentation views and knows when to use them properly. Can enter, edit and format text and tables in presentations. Recognises good practise in applying unique titles to slides. Can choose, create and format charts to communicate information meaningfully. Can insert, edit and align pictures and drawn objects. Can apply animation and transition effects to presentations. Can check and correct presentation content before printing or presenting.
Knows the online essentials and cloud computing essentials. Can set up an account and access cloud storage. Can use online calendars, plan and manage activities, schedule online meetings and is familiar with e-learning systems. Can understand mobile technology key concepts and use functions like emails, applications and synchronization of data and messages.
Can apply advanced text, paragraph, column and table formatting, by maintaining a consistent design through character and paragraph styles. Can work with referencing features like footnotes, endnotes and captions. Can manage citations and bibliography using a chosen citation style. Can create tables of contents, indexes and cross-references. Can enhance productivity by using fields, forms and templates. Can apply advanced mail merge techniques and work with automation features like macros. Can use linking and embedding features to integrate data, collaborate on and review documents locally or online. Can apply document security features. Can work with watermarks, sections, headers and footers in a document, use a thesaurus and manage spell check settings.
Can apply advanced formatting options such as conditional formatting and customised number formatting as well as handle worksheets. Can use functions such as those related to logical, statistical, financial and mathematical operations. Can create charts and apply advanced chart formatting. Can work with tables and lists to analyse, filter and sort data. Create and use scenarios, validate and audit spreadsheet data. Can create, edit, update and sort pivot and data pilot tables. Can enhance productivity by working with named cell ranges and macros. Can use linking, embedding and importing features to integrate data, compare and merge spreadsheets, apply spreadsheet security features.
Can create and modify templates, themes and work with slide master layouts. Can enhance a presentation using built-in drawing and image tools. Can use alternative text for accessibility. Can apply advanced chart formatting features, create and edit diagrams. Can insert audio and video items, create audio and screen recordings and apply built-in animation features. Can use linking, embedding, importing and exporting features to integrate data. Can use password protection to secure a presentation. Can work with custom slide shows and apply slide show settings. Can use the presenter view and control a slide show.