Wat is LessonUp
Zoeken
Kanalen
Inloggen
Registreren
‹
Terug naar zoeken
ICT 8/11/24 Excel
Excel
Recap and go over Excel.
Next lesson we will start the new topic of animation
1 / 16
volgende
Slide 1:
Tekstslide
Computing
Lower Secondary (Key Stage 3)
In deze les zitten
16 slides
, met
interactieve quizzen
en
tekstslides
.
Lesduur is:
50 min
Start les
Bewaar
Deel
Printen
Onderdelen in deze les
Excel
Recap and go over Excel.
Next lesson we will start the new topic of animation
Slide 1 - Tekstslide
Think
How is data stored in a spreadsheet useful?
Thinking points:
What can we do to the data?
How does the data look?
Slide 2 - Tekstslide
How is data stored in a spreadsheet useful?
Slide 3 - Open vraag
Uses for a spreadsheet
Slide 4 - 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 5 - Tekstslide
What is a cell?
A
One line going along.
B
One line going down.
C
A calculation.
D
One box.
Slide 6 - Quizvraag
What is a column?
A
One line going along.
B
One line going down.
C
A calculation.
D
One box.
Slide 7 - Quizvraag
What is a row?
A
One line going along.
B
One line going down.
C
A calculation.
D
One box.
Slide 8 - Quizvraag
Common Excel Short Cut Keys
Ctrl + N
Create a new workbook.
1
Ctrl + O
Open an existing workbook
2
Ctrl + S
Save the active workbook.
3
Ctrl +W
Close the active workbook.
4
Ctrl + C
Copy the contents of the selected cells to Clipboard.
4
Ctrl + X
.Cut the contents of the selected cells to Clipboard
5
Ctrl + V
Insert the contents of the Clipboard into the selected cell(s).
5
Ctrl +P
Open the "Print" dialog.
6
Ctrl +1
Open the "Format Cells" dialog.
7
Ctrl +T
Convert selected cells to a table. You can also select any cell in a range of related data, and pressing Ctrl + T will make it a table.
Find more about Excel tables and their features.
7
Slide 9 - Tekstslide
CTRL-N
A
Opens a new Excel workbook
B
Copies a cell to the clipboard
C
Prints the worksheet
D
Pastes the clipboard into a range of cells
Slide 10 - Quizvraag
Which Short cut Key Prints the WorkBook
A
CRTL-T
B
CRTL-X
C
CRTL-V
D
CRTL-S
Slide 11 - 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 12 - Quizvraag
How do you start a calculation?
A
Enter a grid reference
B
Type the question then press =
C
=
D
+
Slide 13 - 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 14 - 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 15 - Quizvraag
Task - Open your Excel document from the last few lessons.
Using iteach:
- Go to L4 - watch the video and complete the task:
- Go to L5 - watch the video and complete the task:
Slide 16 - Tekstslide
Meer lessen zoals deze
GW_E3_F/502/0168_SS_BASICS_L4
Februari 2024
- Les met
20 slides
Computing ICT
Further Education (Key Stage 5)
Computing On Spreadsheets 1-2 Lesson Help
Augustus 2024
- Les met
12 slides
door
Science
Computing
Primary Education
Science
7 - DL Excel Introduction
Maart 2024
- Les met
15 slides
Computing
Lower Secondary (Key Stage 3)
GW_E3_F/502/0168_SS_BASICS_L1
Februari 2024
- Les met
18 slides
Computing ICT
Further Education (Key Stage 5)
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)
Excel - 14/07
Juli 2024
- Les met
14 slides
Computing
Lower Secondary (Key Stage 3)
7 - DL Excel Introduction - Improved
Mei 2024
- Les met
15 slides
Computing
Lower Secondary (Key Stage 3)