Revision notes

AI Tools for Productivity: Practice

The key points, rules to remember, tables and diagrams from all 5 lessons, on one page for quick revision. To keep a copy, use your browser's Print and choose "Save as PDF".

Lesson 1

Research and summaries with AI: notes, flashcards and checking against the original

The routine for AI summaries

  1. Give the text Paste the text and say 'use only this text'.
  2. Ask narrowly Ask for page references and 'not stated' for gaps.
  3. Check against the original Check every date, figure and condition before you rely on it.

Use only the text below. If something is not stated in it, write 'not stated'. Give each point with the paragraph or page it comes from.

Common research tasks
TaskGood prompt ideaWhat you still check
Chapter summaryUse only this text; 8 bullet points; plain languageNothing added, nothing important dropped
Key facts from a noticeTable with page numbers; 'not stated' if missingEvery date, figure and condition against the PDF
FlashcardsOne fact per card; short answersEach answer against the chapter
Simpler explanationExplain this paragraph for a beginner with one exampleThat simplifying did not change the meaning

Checking a source an AI names

  1. Open it
  2. Confirm it exists
  3. Confirm the publisher It should be the official or original publisher.
  4. Read what it says It must actually say what the AI claimed.
If you cannot find it, the claim is unsupported.

Key takeaways: paste the text and say 'use only this text'; ask for page references and 'not stated' for gaps; check every date, figure and condition against the original before you rely on it. Flashcards are checked once against the book. Every source an AI names is opened and read, and AI search answers point you to the original - they never replace it.

Read the full lesson

Lesson 2

Drafting letters, applications, emails and reports with AI

A useful drafting prompt

  • Who Who is writing to whom.
  • Why The purpose of the letter or email.
  • Which facts Facts that must appear; placeholders such as [date] for any not yet known.
  • What tone
  • How long
Building a drafting prompt
Part of the promptExample
Writer and readerFrom a junior assistant to the section officer
PurposeRequest two days of casual leave
Facts to includeDates [from] to [to]; reason: a family function; work handed over to a named colleague
ToneFormal and polite
Length and formatStandard leave application, under 120 words
GapsLeave square brackets for anything not given; do not invent details

Weak and strong leave-application prompts

  • Weak prompt
    • 'Write a leave application.'
    • The tool invents a reason, a date and perhaps a name.
  • Strong prompt
    • Names the writer, the reader, the leave and the reason.
    • Mentions the colleague the files were handed to.
    • Sets a word limit and asks for brackets for anything not given.
    • The draft holds only her facts and two clear gaps.

The AI writes a draft. You supply the facts, check every detail and sign. Your name on it means you checked it.

Key takeaways: give who, why, which facts, tone and length; make the tool use placeholders instead of guessing; ask for listed changes when proof-reading; check names, dates and numbers yourself; keep confidential material out. Whatever the tool drafted, the person who signs is responsible for every word.

Read the full lesson

Lesson 3

Spreadsheets with AI help: formulas, clean data, charts and testing by hand

Getting a formula you can trust

  1. Describe your data Say where the columns and rows are.
  2. Let AI write the formula Or explain one you do not understand.
  3. Work out rows by hand Two or three rows you can calculate yourself.
  4. Compare the answers If the sheet and your hand answer differ, the formula is wrong until proved otherwise.
Common functions
FunctionWhat it doesExample
SUMAdds a range=SUM(B2:B6)
AVERAGEArithmetic mean of a range=AVERAGE(B2:B6)
IFReturns one value if a condition is true, another if false=IF(B2>=40,"Pass","Fail")
COUNTIFCounts cells meeting one condition=COUNTIF(B2:B6,">=40")
VLOOKUPFinds a value in the first column of a table and returns a value from another column=VLOOKUP("Ravi",A2:B6,2,FALSE)
XLOOKUPNewer lookup: search one range, return from another=XLOOKUP("Ravi",A2:A6,B2:B6)

Before you trust a formula, work out two or three rows by hand. If the sheet and your hand answer differ, the formula is wrong until proved otherwise.

Cleaning a fee register

  • Extra spaces TRIM removes them.
  • The same receipt entered twice A remove-duplicates step or a COUNTIF test finds repeats.
  • Dates written in different ways Choose one consistent date format.
  • Amounts stored as text Convert them to numbers.
Work on a copy, and count the rows before and after.
Choosing a chart
PurposeUsual chart
Compare categories, such as offices or subjectsColumn or bar chart
Show change over timeLine chart
Show parts of one whole, with few partsPie chart
See whether two measures move togetherScatter chart

Key takeaways: describe where your data is; let AI write or explain the formula; then test it on rows you can calculate by hand. Watch for missing rows, > versus >=, exact-match lookups and fixed references. Clean data on a copy and count rows before and after. Choose the chart that fits the question, and label it.

Read the full lesson

Lesson 4

Presentations with AI: outlines, one idea per slide, images and checked figures

Building a presentation with AI

  1. Audience, goal and time Decide these before opening any slide software.
  2. Outline AI drafts it; you edit, reorder and add what only you know.
  3. One idea per slide A short headline with a few points or one picture.
  4. Speaker notes Rewritten in your own words.
  5. Check figures and images Every number matched to its source; images you have the right to use.
  6. Practice run With a timer.
From crowded to clear
Crowded slideBetter
Title 'Data security' with 12 bullet pointsThree slides: passwords, sharing files, phishing - each with three points
A full table of 40 numbersThe one comparison that matters, as a simple chart
Paragraph copied from a circularThe key rule in one line; the circular's reference in the notes

Percentage change = (new − old) ÷ old × 100. Every number on a slide is checked against its source before the meeting.

Images for a presentation

  • Safer choices
    • Your own photographs
    • Images your office owns
    • Images whose licence allows reuse, following its conditions
    • Simple diagrams you draw
  • AI-generated images: care points
    • May contain errors, such as wrong map borders or misspelt text
    • Never show real people doing things they did not do
    • Say that the image is AI-made
    • A map of India comes from an authoritative source, not an image generator

Key takeaways: start with audience, goal and time, then an outline; one idea per slide; speaker notes in your own words; images you have the right to use, with AI images checked and labelled; every number recalculated and matched to its source. A presentation is your claim in front of an audience, whatever tool drafted it.

Read the full lesson

Lesson 5

Workflow automation: triggers, actions and keeping a person in charge

Every automation

  1. When: trigger Something happens.
  2. If: condition Certain conditions hold.
  3. Then: action Do something.
Automations written as trigger, condition, action
TriggerConditionAction
A new email arrivesThe subject contains 'Invoice'Move it to the Accounts folder
Every Monday at 9 a.m.NoneSend yourself a reminder to update the weekly register
Someone submits a formNoneAdd the answers as a new row in a spreadsheet
A new row is added to the sheetThe 'Urgent' column says YesNotify the section in-charge

Automate what is frequent, repetitive and rule-based. Test before you trust. A person approves anything that goes to other people.

Who sends what

  • Internal and reversible: little risk
    • Sorting
    • Copying
    • Reminding yourself
  • Goes to other people: a person approves
    • Replies to citizens and letters
    • Payment or approval messages
    • Posts on social media
    • The automation prepares a draft; a person reviews and sends it

Key takeaways: write the task as trigger, condition, action; automate frequent, rule-based work whose setup time pays back; build on a copy and test with known inputs; keep a person approving anything sent to others; grant minimum access and never enable macros from unknown files.

Read the full lesson

Privacy · Terms · Refunds · Delivery