Creative projects combining apps and data
Big creative projects rarely use just one app — they combine tools for collecting data, analysing it and presenting the result.
Part of your national curriculum
- Creativity and digital literacy: Undertake creative projects that involve selecting, using and combining multiple applications to achieve challenging goals, including collecting and analysing data
Lesson overview
What you'll learn in this lesson
Undertake creative projects that involve selecting, using and combining multiple applications to achieve challenging goals, including collecting and analysing data
Key learning points
- • Choosing the right tool for each job
- • Collecting and analysing data
- • Planning across applications
This lesson at a glance
- 28 minutes
- 17 parts to scroll through
- 3 quick checks
- Marked quiz at the end
- Gentle pace: short sittings with pauses
Words to know
Scroll down — the lesson carries on below
Watch & discover
Part 1 of 17
Visual introductionPicture this
Creative projects combining apps and data
Big creative projects rarely use just one app — they combine tools for collecting data, analysing it and presenting the result.
In a nutshell
Undertake creative projects that involve selecting, using and combining multiple applications to achieve challenging goals, including collecting and analysing data
Learning cycle
Part 2 of 17
Learning cycle 1 of 2
Part 1 · Choosing the right tool for each job
A short piece of teaching, then a check to make sure it has landed.
Explore the idea
Part 3 of 17
Learn
Choosing the right tool for each job
A survey app can collect responses, a spreadsheet can calculate averages and draw charts, and a presentation app can showcase the findings. Picking the right combination avoids forcing one app to do a job it is bad at.
Reset break
Part 4 of 17
Pause
That's sitting 1 of 4 done
Stretch, get a drink, look out of the window. There is no timer and nothing is counting down — your place is saved, so you can come back in five minutes or tomorrow.
Explore the idea
Part 5 of 17
Learn
Collecting and analysing data
When surveying classmates about screen time, plan your questions first, collect responses in a form, then use spreadsheet functions such as AVERAGE and COUNTIF to summarise the data before drawing conclusions.
Quick check
Part 6 of 17
Quick check
Part 7 of 17
Reset break
Part 8 of 17
Pause
That's sitting 2 of 4 done
Stretch, get a drink, look out of the window. There is no timer and nothing is counting down — your place is saved, so you can come back in five minutes or tomorrow.
Learning cycle
Part 9 of 17
Learning cycle 2 of 2
Part 2 · Planning across applications
A short piece of teaching, then a check to make sure it has landed.
Explore the idea
Part 10 of 17
Learn
Planning across applications
Good projects start with a plan: what data is needed, which app collects it, which app analyses it, and which app presents it. Exporting data (for example as a CSV file) lets one app's output become another's input.
Quick check
Part 11 of 17
Reset break
Part 12 of 17
Pause
That's sitting 3 of 4 done
Stretch, get a drink, look out of the window. There is no timer and nothing is counting down — your place is saved, so you can come back in five minutes or tomorrow.
Challenge round
Part 13 of 17
Game · Sort it
Which of these are true?
Drag each card into the right column. Tap a card first if dragging is fiddly.
True
Not true
Challenge round
Part 14 of 17
Game · Fill the gaps
Finish the sentences
Choose the word that belongs in each gap.
Good ____ start with a plan: what data is needed, which app collects it, which app analyses it, and which app presents it.
Challenge round
Part 15 of 17
Game · Recall cards
Why combine several applications in one project?
Card 1 of 3
Mastery quiz
Part 16 of 17
Marked quiz
End of lesson quiz: Creative projects combining apps and data
3 questions, marked with the reasoning shown. No timer.
1. Why combine several applications in one project?
2. Which spreadsheet function would find an average screen-time value?
3. What file format commonly moves data from one app into another?
Lesson round-up
Part 17 of 17
Lesson round-up
Ready when you are
Quiz score
Not sat
Games
Not played
Points this lesson
0
Best run
0 in a row
Luna: 0 out of 3 on the practice checks. Only if you feel up to it — one more?
Ask LunaPart 1 of 17 · Watch & discover
How this is going
- Not looked at yet
Undertake creative projects that involve selecting, using and combining multiple applications to achieve challenging goals, including collecting and analysing data