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
ComputingLower Secondary (Key Stage 3)

In deze les zitten 16 slides, met interactieve quizzen en tekstslides.

time-iconLesduur is: 50 min

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