Excel - 14/07

• Computing
• Lower Secondary (Key Stage 3)

Excel Recap pt. 2

Describe what a grid reference is.

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.

How do you start a calculation?

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

Divide

1. +
2. -
3. /
4. *

Multiply

1. +
2. -
3. /
4. *

=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.

=MIN

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.

=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

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.

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

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.