×

spreadsheets

A B C D E
1 Code   Item Price Quantity Total cost
2 Orange juice $6.99 $6.99
3 Chocolate bar $2.99 $2.99
4 Orange juice $6.99 $6.99
5 Honey Tea $4.50 $4.50
6 Coffee $8.25 $8.25
7 Orange juice $6.99 $6.99
8 Earl Gray Tea $8.75 $8.25
9 Orange juice $6.99 $6.99
10
11 Total $51.95

A small coffee shop allows staff to enter a menu code and a quantity into a spreadsheet. The spreadsheet will automatically update the price of the individual order and the total price of all orders.

It is Sunday morning and as you can see, only a few orders have been entered into the spreadsheet.

Play with the functionality of the spreadsheet and complete this form.

Self-check. What do you know about Spreadsheets? Follow the instructions if you can!
Things everyone should know about spreadsheets! You will be challenged to enter data into a spreadsheet and format it to look readable.
This is a review and extension of the previous task.
This is an introduction to basic functions such as SUM, AVERAGE, COUNT etc.
Let's make a graph.
This is an introduction to data validation - don't let users enter invalid data into your spreadsheet model!
This is an introduction to more powerful functions that allow us to create Summary Data more effectively with less risk.
This unit will introduce you to absolute references and a strategy for double checking your results. Oh, and clustered charts!
Learn a key concept: a strategy for limiting HUMAN DATA ENTRY ERROR!
Learn techniques to help ensure data entered into a spreadsheet is valid.
Learn how to grab bits of a string from a string!
Learn how to let the software decide what value needs to be displayed!

SUBSCRIBE

Join my mailing list to receive updates on the latest blog posts and other things.