IT
Your Score: 0/5
Question 1 of 5
Which four of these are spreadsheet software?
Microsoft Word
LibraOffice Calc
Apple Numbers
Microsoft Excel
Google Sheets
Google Slides
Corel Word Perfect
Drag and drop the words into the correct gaps
softwarecalculatevaluesspreadsheetcells
A or worksheet is a file made of rows and columns that help sort data, arrange data easily, and numerical data. What makes a spreadsheet program unique is its ability to calculate using mathematical formulas and the data in .
Which of these formulas aggregates vales from a selection of columns or rows?
IF
AVERAGE
SUM
COUNT
Which of these formulas counts all cells in a given range that contain only numeric values?
SUM
AVERAGE
COUNT
IF
Is this statement true or false? In a spreadsheet, a formula is an expression that operates on values in a range of cells or a cell.
TRUE
FALSE
Quiz Complete!
You scored: 0 out of 5
Table of Contents
- Tutorial Video
- Reading Materials
- ‘Computer software for business’ from NI Business
- ‘Productivity software’ on the Encyclopedia website
- ‘Application software 101’ from Quick Base
- ‘Guide to Data Protection’ from the Information Commissioner’s Office
- ‘Is cyber security software worth the investment?’ from IT Governance
- ‘The Importance of Social Media in Business’ from Lyfe Marketing
- Presentation
- Good Practice Example
- Good Practice Example
- Interactive Quiz
- Evidence Opportunities
- Extended Learning
- The UK government has an article called ‘How copyright protects your work’.
- BBC Bitesize has an article on ‘ICT copyright’.
- ‘How to plan a project’ is a helpful article from the Prince2 website. It looks at the different stages of the plan.
- The CIPD website has a useful section of its website about its house style. Look at the ‘Tone of voice guidelines’ and ‘Grammar and punctuation’ sections, then look at the pointers for writing effectively for digital media.
- Think And Challenge
- Tutorial Video
- Reading Materials
- Some of these resources refer to Microsoft Windows computers and others refer to Apple Macintosh computers.
- ‘Tutorial: Email Basics’ from GCF Learn Free
- ‘Tutorial: Outlook 2010’ from GCF Learn Free
- ‘Tutorial: Gmail’ from GCF Learn Free
- ‘Use Mail on your Mac’ from Apple support
- ‘iPad Basics: Mail’ from GCF Learn Free.
- ‘Google account help: Make your account more secure’ from Google
- ‘How to spot an email scam’ from Which?
- ‘Copyright and intellectual property’ on the BBC Bitesize website
- ‘Glossary of email terms’ from Laser Learning
- ‘3 message formats in Outlook and when to use which’ from the Lifewire website
- ‘Mail for MAC: Use plain or rich text in messages’ from Apple Support
- ‘The best Apple Mail tips and tricks’ from Lifewire
- ‘What is an email thread?’ from Lifewire
- Use the internet to find out how to use the functions below on your devices.
- Presentation
- Click on the icon to the left to launch this lesson's presentation on 'Managing emails'.
- Click on the icon to the left to launch this lesson's presentation on 'Using email appropriately'.
- Click on the icon to the left to launch this lesson's presentation on 'Automated mail responses'.
- Good Practice Example
- Good Practice Example
- Good Practice Example
- Good Practice Example
- Interactive Quiz
- Evidence Opportunities
- Extended Learning
- This article from Apple looks at how to ‘Set up an email account on your iPhone, iPad, or iPod touch’.
- When you are sending professional email messages, it's really important to make sure the message is perfect. Click to read ‘How to Write and Send Professional Email Messages’ from The Balance.
- This section of the Lifewire website contains ‘Microsoft Outlook tips and tricks’. Read through all the articles that relate to your role.
- This article from Apple Support looks at ‘Archive messages in Mail’.
- Extended Learning
- Extended Learning
- Extended Learning
- Think And Challenge
- Tutorial Video
- Reading Materials
- ‘Word processor’ from Computer Hope
- Find and read your organisation’s style guide and any document templates used.
- Some of these resources refer to Microsoft Windows computers and others refer to Apple Macintosh computers.
- ‘Word 2016’ from GCF Learn Free
- ‘Google Drive and Docs’ from GCF Learn Free
- ‘TextEdit User Guide’ from Apple Support
- '17 proofreading techniques’ from Instructional Solutions
- ‘Introduction to copyright’ from the UK Copyright Service (UKCS)
- ‘Popular document files and their difference’ from Online Convert.
- Presentation
- Good Practice Example
- Good Practice Example
- Interactive Quiz
- Evidence Opportunities
- Extended Learning
- Click to read ‘Frequently asked questions about grammar proofing in Word’ on the Microsoft Support website.
- This article ‘How to format a business document’ has been produced by GCF Learn Free.
- Click to read ’10 simple design rules for professional Microsoft Word documents’ written by Emma Roth on the Make Use Of website.
- Think And Challenge
- Tutorial Video
- Reading Materials
- ‘Presentation program’ on the Computer Hope website
- ‘Working with presentation software’ from the University of Hull
- Some of these resources refer to Microsoft Windows computers and others refer to Apple Macintosh computers.
- ‘Google slides’ from GCF Learn Free
- ‘PowerPoint’ from GCF Learn Free
- Presentation
- Good Practice Example
- Good Practice Example
- Interactive Quiz
- Evidence Opportunities
- Extended Learning
- Click to read ‘7 Most Popular Software for Presentations’ on the Graphicmama website.
- ‘How to create best PowerPoint presentations (with examples and templates)’ on the Hub Spot website looks at number of different example presentations.
- This article from Bates College is called ‘PowerPoint: Presentation tips’ however many of the points are relevant to other presentation software.
- The World Blind Union has issued guidelines on how to make the use of PowerPoint and other visual presentations accessible to audience members who have a vision or print impairment.
- Think And Challenge
- Tutorial Video
- Reading Materials
- ‘Spreadsheet’ on the Computer Hope website
- ‘What is the purpose of using a spreadsheet?’ from the Small Business Chronicle.
- ‘The best spreadsheet software in 2019’ on the Zapier website
- ‘A checklist for use in reviewing or inspecting spreadsheets’ webpage on website
- Some of these resources refer to Microsoft Windows computers and others refer to Apple Macintosh computers
- ‘Basic Excel formulas’ from the Corporate Finance Institute
- ‘Google sheets’ from GCF Learn Free
- ‘Excel’ from GCF Learn Free
- ‘Numbers user guide’ from Apple Support
- Presentation
- Good Practice Example
- Good Practice Example
- Good Practice Example
- Interactive Quiz
- Evidence Opportunities
- Extended Learning
- Click to read ‘Twenty principles for good spreadsheet practice’ from the Institute of Chartered Accountants in England and Wales (ICAEW).
- This article from Cluster Seven covers ‘The importance of auditing a spreadsheet’.
- Click to read this article from the European Spreadsheet Risks Interest Group highlighting horror stories caused by unchecked data in spreadsheets.
- Think And Challenge
- Tutorial Video
- Reading Materials
- ‘What is data management?’ webpage on the JotForm website
- ‘Database software 101’ on the Quickbase website
- ‘Data security’ from the UK Data Service
- ‘Guide to Data Protection’ from the Information Commissioner’s Office.
- ‘What is a CRM database?’ on the Keap website.
- ‘What is a CRM database?’ on the Keap website.
- ‘Database report’ from Techopedia
- ‘Access from GCF Learn Free
- Use the internet to find the tutorials for the data management software used by your organisation.
- ‘Database search tips: Boolean operators’ from MIT Libraries
- Presentation
- Good Practice Example
- Good Practice Example
- Good Practice Example
- Interactive Quiz
- Evidence Opportunities
- Extended Learning
- This article from Digital Ocean compares and contrasts three of the most widely implemented open-source relational database management systems (RDBMSs) - SQLite, MySQL, and PostgreSQL.
- This article from w3schools explains ‘SQL Wildcards, what they are, and the records they will find.
- This article from Microsoft Office explains how to ‘Use wildcards in queries and parameters in Access’.
- Think And Challenge
Laser Learning Ltd.
Academy House, 3 Langley Quay,
Waterside Drive, Langley,
Berkshire, SL3 6EY