Advanced Computer Skills for Adults
Build a reliable workflow for a fictional community workshop: organise and recover files, produce structured documents and presentations, calculate and check spreadsheet results, and review evidence and access. Practise privacy, secure decisions, and troubleshooting entirely offline using existing software or paper models.
Overview
Your learning journey
Build a reliable workflow for a fictional community workshop: organise and recover files, produce structured documents and presentations, calculate and check spreadsheet results, and review evidence and access. Practise privacy, secure decisions, and troubleshooting entirely offline using existing software or paper models.
Who this is for
Adult learners who can already open an application, type short text, and save a file.
What you will learn
- Organise named versions and demonstrate a safe restore without overwriting originals.
- Structure, revise, and check an accessible document and a three-slide presentation.
- Build and audit spreadsheet formulas using relative and absolute references, percentages, ROUND, IF, SUMIF, and SUBTOTAL.
- Sort complete records, filter deliberately, and communicate numerical evidence accurately.
- Evaluate sources and plan collaboration with minimal information and appropriate access.
- Recognise suspicious requests and document a controlled troubleshooting process.
Before you begin
- Basic typing, selecting text, opening an application, and saving files.
- An already available offline editor or office application; LibreOffice examples are labelled, but installation, paid software, and accounts are not required.
- Paper and a pencil can replace every software task: draw folders, pages, slides, and cell grids, and annotate the intended commands.
01 · Files you can find and recover
Create a small, understandable workspace, choose useful formats, and prove that a saved copy can be recovered.
- Build a searchable project folder
- Choose formats without losing your source
- Plan backups and test a restore
02 · Documents people can use
Turn workshop notes into structured pages, make deliberate revisions, and present a clear recommendation.
- Build a document with meaningful structure
- Revise carefully and check readability
- Create a three-slide recommendation
03 · Spreadsheets you can explain
Separate inputs from calculations, copy formulas intentionally, and use conditions without losing sight of the source records.
- Enter clean data and calculate totals
- Copy references and calculate percentages
- Use conditions and understand filtered totals
04 · Evidence and responsible teamwork
Keep records intact when comparing them, assess claims against sources, and plan a controlled handover with minimal information.
- Sort complete records and make an honest chart
- Verify a claim and record its limits
- Plan collaboration without oversharing
05 · Secure habits and confident problem solving
Recognise unsafe requests, investigate errors methodically, and combine the course skills in a checked fictional project.
- Make secure decisions under pressure
- Diagnose one problem at a time
- Complete a checked workshop handover
Sources and review notes
Official Microsoft, LibreOffice, W3C, government cyber-security/privacy, and University of Sydney Library pages were opened and checked on 23 October 2026. Source IDs link each lesson to the specific factual support; examples and teaching wording are original. LibreOffice Help uses English function names, decimal points and semicolon argument separators here. Other locales may use different names or separators; use existing application help without changing system settings. Source links are optional reference material, not required learner browsing or downloads. Software menus and security guidance can change. Model workflows and fictional arithmetic are educational examples, not legal, financial, or accessibility certification.
- No WordPress installation, publication, completion award, account or live collaboration is part of this content.
- Every lesson has a paper route. Existing local applications may differ; a teacher should check menus and assistive-technology behaviour in the delivery environment.
- Validation completed: 57 independent Decimal-based formula and arithmetic checks passed, including original and revised budgets, 5% and 10% rates, ROUND, IF boundaries, SUMIF categories, filtered SUBTOTAL and zero-denominator handling. The supplied course validator passed. Native office-engine execution and renderer/accessibility inspection were not performed; menu and locale compatibility still need delivery-environment review.
- The fictional 10% contingency is a planning assumption, not a tax rate. No personal financial, legal or security advice is provided.
- Official SUMIF examples contain inconsistent range labels in places; this course uses independently checked, equal-sized ranges and simple category labels without wildcards.
Curriculum
Curriculum
- 5 Sections
- 15 Lessons
- 10 Weeks
- 01 · Files you can find and recover3 ItemsCreate a small, understandable workspace, choose useful formats, and prove that a saved copy can be recovered.
- 02 · Documents people can use3 ItemsTurn workshop notes into structured pages, make deliberate revisions, and present a clear recommendation.
- 03 · Spreadsheets you can explain3 ItemsSeparate inputs from calculations, copy formulas intentionally, and use conditions without losing sight of the source records.
- 04 · Evidence and responsible teamwork3 ItemsKeep records intact when comparing them, assess claims against sources, and plan a controlled handover with minimal information.
- 05 · Secure habits and confident problem solving3 ItemsRecognise unsafe requests, investigate errors methodically, and combine the course skills in a checked fictional project.







