Earlier in the course you compared sources and noted why you trusted them. Today you put that comparison into a spreadsheet, so you can sort it, filter it and answer a question about the whole set at once.
You will:
A free school Microsoft or Google account, for Excel or Google Sheets. Either is fine — the walkthrough covers both.
In a spreadsheet, each row is one source and each column is one fact about it. Sorting and filtering beat rewriting a long list once you have more than a few sources.
You score the four tests yourself with Yes, No or Partial:
| Test | The question it asks |
|---|---|
| Purpose clear? | Can you tell why this was published? |
| Accurate? | Do the claims look careful and supported? |
| Current? | Is the date recent enough for this topic? |
| Cross-checked? | Have you seen the same idea in another solid place? |
Your research log may hold only titles and a trust note. That is fine — the log gives you candidate titles, and you re-score each source into this grid.
Follow the guided steps on screen to build a source-comparison spreadsheet in Excel or Google Sheets. Use the three sample sources below if you do not have your own from earlier work. Freeze and filter are the two skills you must hit; if time is short, skip widening columns. Save the file the class way when you finish the walkthrough.
Sample sources (topic: should secondary schools start later in the morning?). Type the short labels in the Source column so data entry stays quick:
You need a school Microsoft account (Excel) or Google account (Sheets). Both are free through school.
Grow the table by at least one row and use a filter to answer a real question about the set.
Before you finish, check: at least four source rows; headers frozen; one filter used on purpose; one clear question-and-answer beside the table; file saved where the class can find it next time.
A spreadsheet organises your judgements; it does not decide whether a source is trustworthy. You still make that call with your checklist.
What the table gives you:
What did your table show you that was hard to see in your research log?
You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.