ICT 8/11/24 Excel

• Computing
• Lower Secondary (Key Stage 3)

Excel

Recap and go over Excel.

Next lesson we will start the new topic of animation

Think 

How is data stored in a spreadsheet useful?

Thinking points:

What can we do to the data?

How does the data look?

How is data stored in a spreadsheet useful?

Uses for a spreadsheet

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.

What is a cell?

1. One line going along.
2. One line going down.
3. A calculation.
4. One box.

What is a column?

1. One line going along.
2. One line going down.
3. A calculation.
4. One box.

What is a row?

1. One line going along.
2. One line going down.
3. A calculation.
4. One box.

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

CTRL-N

1. Opens a new Excel workbook
2. Copies a cell to the clipboard
3. Prints the worksheet
4. Pastes the clipboard into a range of cells

Which Short cut Key Prints the WorkBook

1. CRTL-T
2. CRTL-X
3. CRTL-V
4. CRTL-S

=SUM

1. Find the largest number in a group of numbers.
2. Show the Average of a group of numbers.
3. Find the smallest number in a group of numbers
4. Add a group of numbers together.

How do you start a calculation?

1. Enter a grid reference
2. Type the question then press =
3. =
4. +

=AVERAGE

1. Find the largest number in a group of numbers.
2. Show the Average of a group of numbers.
3. Find the smallest number in a group of numbers
4. Add a group of numbers together.

=MAX

1. Find the largest number in a group of numbers.
2. Show the Average of a group of numbers.
3. Find the smallest number in a group of numbers
4. Add a group of numbers together.

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: