Session 1

Understanding the Power of Spreadsheets
Session 1
1 / 23
suivant
Slide 1: Diapositive
ComputingFurther Education (Key Stage 5)

Cette leçon contient 23 diapositives, avec quiz interactifs et diapositives de texte.

time-iconLa durée de la leçon est: 120 min

Éléments de cette leçon

Understanding the Power of Spreadsheets
Session 1

Slide 1 - Diapositive

Cet élément n'a pas d'instructions

Introduction
  • In this unit you will learn about what spreadsheets are and how they are used in education and business.

  • You will develop a good understanding of the tools and techniques used to create efficient spreadsheet solutions.

Slide 2 - Diapositive

Cet élément n'a pas d'instructions

Today's objectives
  • Know what a spreadsheet is and why they are used
  • Be able to start entering simple data into a spreadsheet
  • Use simple formulae to perform a few calculations. 

Slide 3 - Diapositive

Cet élément n'a pas d'instructions

Time to enrol in Google Classroom
Type this code in to join Unit 9

Slide 4 - Diapositive

Cet élément n'a pas d'instructions

What do you already know about spreadsheets?

Slide 5 - Question ouverte

Cet élément n'a pas d'instructions

Why do you think an organisation would use a spreadsheet?

Slide 6 - Carte mentale

Cet élément n'a pas d'instructions

Why do you think it's important to learn about spreadsheets?

Slide 7 - Question ouverte

Transferable Skill

Spreadsheet proficiency is highly valued in many professions, such as finance, marketing, education, and engineering. Learning spreadsheets early equips individuals with a universally applicable skill, improving their employability and adaptability in the job market.
Reasons for using a spreadsheet
  • Improves productivity and accuracy
  • Supports decision making
  • Presents information clearly and effectively
  • Performs calculations
  • Helps with analysing data
  • Manipulates large data sets

Slide 8 - Diapositive

Cet élément n'a pas d'instructions

What do I mean by analyse?

Slide 9 - Question ouverte

Cet élément n'a pas d'instructions

What activities would you use a spreadsheet for?

Slide 10 - Carte mentale

Cet élément n'a pas d'instructions

Activities where they can be used
  • Cost modelling - to predict what will happen to profits if they raise their prices
  • Analysis of large data sets - scientific experiments
  • Tracking progress and recording results - learner progress
  • Creating timetables and results - fixture lists for sports clubs
  • Stock control - number of items in stock have decreased and need to be re-ordered

Slide 11 - Diapositive

Cet élément n'a pas d'instructions

Slide 12 - Diapositive

Cet élément n'a pas d'instructions

Small Shop Stock Control
GOOGLE SHEETS ACTIVITY

Slide 13 - Diapositive

The orange traffic light means that students can ask questions during this activity
Now have a go at identifying some of the features you have just used in the Shop Stock Control Activity

Slide 14 - Carte mentale

Cet élément n'a pas d'instructions

Features Used in the Shop Stock Control
The main feature of a spreadsheet is its capacity to perform complex sets of calculations along with its ability to convert the numeric data into graphical formats.

  • Formulas & Functions: Automate calculations like SUM, AVERAGE, and IF statements 
  • Cell Referencing: Use absolute and relative cell references to create dynamic calculations
  • Data Validation: Ensure data integrity by restricting input types (e.g., dates, currencies)
  • Conditional Formatting: Highlight cells that exceed budget limits to quickly identify overspending.
  • Charts & Graphs: Visualise spending patterns and compare budget vs. actual expenses

Slide 15 - Diapositive

Cet élément n'a pas d'instructions

What is a spreadsheet?
A
Software program used for word processing
B
Digital tool used to organise, analyse and store data in tabular form
C
Graphic design software
D
Web browser feature

Slide 16 - Quiz

Cet élément n'a pas d'instructions

Which of the following is an example of spreadsheet software?
A
Microsoft Word
B
Adobe Photoshop
C
Google Sheets
D
Mozilla Firefox

Slide 17 - Quiz

Cet élément n'a pas d'instructions

In a spreadsheet, what is a cell?
A
Group of text in a paragraph
B
Intersection of a row and a column
C
Button on the toolbar
D
File storage location

Slide 18 - Quiz

Cet élément n'a pas d'instructions

What is the formula to add the values in cells B1, B2 and B3?
A
=ADD(B1+B2+B3)
B
=SUM(B1:B3)
C
=B1+B2+B3
D
Both B and C

Slide 19 - Quiz

Cet élément n'a pas d'instructions

What does a formula always begin with in a spreadsheet?
A
Letter
B
Number
C
Equal Sign (=)
D
Hashtag (#)

Slide 20 - Quiz

Cet élément n'a pas d'instructions

A spreadsheet cell can only contain text?
A
TRUE
B
FALSE

Slide 21 - Quiz

Cet élément n'a pas d'instructions

Conclusion
  • Spreadsheets are versatile tools for a wide range of activities
  • Understanding and utilising spreadsheet features can greatly enhance productivity and accuracy in tasks like budgeting and project management

Slide 22 - Diapositive

Cet élément n'a pas d'instructions

SUMMARY
In this lesson, you...
Next lesson, you will...
Homework
Learnt about the uses of spreadsheets

Produced a spreadsheet of your own using some key features
Learn more about the uses of spreadsheets

Learn and use some further key features
Give 3 reasons why a business might use spreadsheets

Slide 23 - Diapositive

Cet élément n'a pas d'instructions