What is LessonUp
Search
Channels
AI tools
Beta
Log in
Register
‹
Return to search
Excel - 14/07
Excel Recap pt. 2
1 / 14
next
Slide 1:
Slide
Computing
Lower Secondary (Key Stage 3)
This lesson contains
14 slides
, with
interactive quizzes
and
text slides
.
Lesson duration is:
50 min
Start lesson
Save
Share
Print lesson
Items in this lesson
Excel Recap pt. 2
Slide 1 - Slide
Describe what a grid reference is.
Slide 2 - Open question
KO: To refresh your knowledge of Microsoft Excel spreadsheets
All: Show how to have excel do calculations for you.
Most: Be able to use Excel's formatting tools.
Some: Be able to create a spreadsheet from scratch for tracking ingoing/outgoing cash.
Slide 3 - Slide
How do you start a calculation?
A
Enter a grid reference
B
Type the question then press =
C
=
D
+
Slide 4 - Quiz
Divide
A
+
B
-
C
/
D
*
Slide 5 - Quiz
Multiply
A
+
B
-
C
/
D
*
Slide 6 - Quiz
=SUM
A
Find the largest number in a group of numbers.
B
Show the Average of a group of numbers.
C
Find the smallest number in a group of numbers
D
Add a group of numbers together.
Slide 7 - Quiz
=MIN
A
Find the largest number in a group of numbers.
B
Show the Average of a group of numbers.
C
Find the smallest number in a group of numbers
D
Add a group of numbers together.
Slide 8 - Quiz
=AVERAGE
A
Find the largest number in a group of numbers.
B
Show the Average of a group of numbers.
C
Find the smallest number in a group of numbers
D
Add a group of numbers together.
Slide 9 - Quiz
=MAX
A
Find the largest number in a group of numbers.
B
Show the Average of a group of numbers.
C
Find the smallest number in a group of numbers
D
Add a group of numbers together.
Slide 10 - Quiz
Task
Click here to Open your worksheet.
Click the viewing button and then open up in Desktop App. Save the file your Digital Literacy folder, so you can edit it.
Slide 11 - Slide
Scenario:
Your parents will give you more pocket money, if you can show them that you're spending it sensibly.
Create a spreadsheet for tracking this.
They have given you £50 as a trial for three months of spending.
Consider adding:
Name of the thing you bought
How much it cost
Calculating your total money left over (balance)
Categories of spending (toys, food, subscription, games, clothes, etc.)
The date of the transaction
Did you get it on special offer and how much was the saving?
A chart to make some data easier to read
Slide 12 - Slide
Uses for a spreadsheet
Slide 13 - Mind map
Uses
Data Analysis:
Organize and analyze large sets of data using functions, formulas, and pivot tables.
Budgeting and Financial Planning:
Track income, expenses, and create financial forecasts.
Project Management:
Plan and monitor project timelines, tasks, and resources.
Inventory Management:
Keep track of stock levels, orders, and suppliers.
Reporting:
Generate reports and visualizations to present data clearly and effectively.
Slide 14 - Slide
More lessons like this
Computing On Spreadsheets 1-2 Lesson Help
August 2024
- Lesson with
12 slides
by
Science
Computing
Primary Education
Science
Computing On Spreadsheets 1-2 Lesson Help
February 2024
- Lesson with
12 slides
by
LessonUp Inspiration
Computing
Primary Education
LessonUp Inspiration
Mental Health Matters
August 2023
- Lesson with
8 slides
by
LessonUp Inspiration
Citizenship
PSHE
+2
Lower Secondary (Key Stage 3)
Upper Secondary (Key Stage 4)
BTEC, GCSE
LessonUp Inspiration
Mental Health Matters
August 2024
- Lesson with
8 slides
by
PSHE
Citizenship
PSHE
+2
Lower Secondary (Key Stage 3)
Upper Secondary (Key Stage 4)
BTEC, GCSE
PSHE
The rediscovered church
May 2017
- Lesson with
30 slides
by
Van Gogh Museum
Art and design
Mathematics
Primary Education
Lower Secondary (Key Stage 3)
Van Gogh Museum
Toothfish Poaching (Primary)
December 2020
- Lesson with
31 slides
by
SEA SHEPHERD
Social Studies
History
+3
4-6 Grade
6th,7th Grade
SEA SHEPHERD
Toothfish Poaching (Secondary)
October 2020
- Lesson with
31 slides
by
SEA SHEPHERD
Social Studies
History
+3
7-9 Grade
9-11 Grade
SEA SHEPHERD
Case Study - Whale Defense Campaigns (Secondary)
November 2020
- Lesson with
16 slides
by
SEA SHEPHERD
Science
Geography
+4
7-9 Grade
9-11 Grade
SEA SHEPHERD