Wat is LessonUp
Zoeken
Kanalen
Inloggen
Registreren
‹
Terug naar zoeken
Excel - 14/07
Excel Recap pt. 2
1 / 14
volgende
Slide 1:
Tekstslide
Computing
Lower Secondary (Key Stage 3)
In deze les zitten
14 slides
, met
interactieve quizzen
en
tekstslides
.
Lesduur is:
50 min
Start les
Bewaar
Deel
Printen
Onderdelen in deze les
Excel Recap pt. 2
Slide 1 - Tekstslide
Describe what a grid reference is.
Slide 2 - Open vraag
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 - Tekstslide
How do you start a calculation?
A
Enter a grid reference
B
Type the question then press =
C
=
D
+
Slide 4 - Quizvraag
Divide
A
+
B
-
C
/
D
*
Slide 5 - Quizvraag
Multiply
A
+
B
-
C
/
D
*
Slide 6 - Quizvraag
=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 - Quizvraag
=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 - Quizvraag
=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 - Quizvraag
=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 - Quizvraag
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 - Tekstslide
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 - Tekstslide
Uses for a spreadsheet
Slide 13 - Woordweb
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 - Tekstslide
Meer lessen zoals deze
Excel - 14/07
Juli 2024
- Les met
14 slides
Computing
Lower Secondary (Key Stage 3)
Excel - 14/07
Juli 2024
- Les met
14 slides
Computing
Lower Secondary (Key Stage 3)
Unlocking the Power of Spreadsheets: A Lesson on Practical Applications
Juli 2024
- Les met
14 slides
Mastering Microsoft Excel: An Introduction to Spreadsheet Software
Februari 2024
- Les met
13 slides
Session 1
19 dagen geleden
- Les met
22 slides
Computing
Further Education (Key Stage 5)
Mastering Personal Finance
April 2023
- Les met
26 slides
PSHE
Further Education (Key Stage 5)
Excel Mastery: Professional Documentation Made Easy
Februari 2024
- Les met
13 slides
7 - DL Excel Introduction - Improved
Mei 2024
- Les met
15 slides
Computing
Lower Secondary (Key Stage 3)