Unit 9 - Session 1

What do you already know about spreadsheets?

1 / 5
volgende
Slide 1: Open_question
newEditorComputingFurther Education (Key Stage 5)

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

time-iconLesduur is: 30 min
Dit is niet oké

Onderdelen in deze les

What do you already know about spreadsheets?

Why use spreadsheets?

Add in your ideas as to why people/organisations might use a spreadsheet

Activity - Shop Stock Control - 30 mins


You can either grab a printed version of the task or you can open up the task on Google Classroom and follow the instructions.


Before we start - what are we actually aiming for?  Show example


Make sure to sign into OneDrive if the cloud in the System Tray has a line through it

Click on the cloud and then click Sign in


Open up Microsoft Excel and save this into your Documents in OneDrive.


Always remember to check that your OneDrive has synced before signing out - why?


30

minute

00

second

Identify some features that you have used in the spreadsheet you have just created

LET’S NOW HAVE A GO AT WRITING UP WHAT IS MEANT BY A SUM - 15 MINS


Open up the Explain what is meant by a SUM function activity in Google Classroom and have a go at explaining this function in your own words using sentences.  


What does it do for instance? Eg: provides a total


Add a screenshot of this function.


Then add an explanation as to what Excel is being told eg: SUM = add everything from E2 to E22


Then have a go at explaining what benefit this particular function might have for an organisation/employee



15

minute

00

second