Preview lessons, content and tests

Computer Science & Programming solved. All in one platform.

1. To trial the platform and take tests, please take a few seconds to SIGN UP and SET UP FREE.
2. Searching for something specific? See our text overview of all tests. Includes 'real teacher' use videos.

Join 30000+ teachers and students using TTIO.

Introducing Speadsheets

Spreadsheets (like Microsoft Excel, Google sheets etc) are used to store information and data. Once we have our information in a spreadsheet we can run powerful calculations, make graphs and charts and analyse patterns. They are used by teachers, librarians, company directors, accountants, investment bankers and even doctors.

You may have also seen that excel was recently being used (2020) for covid tracking! Article here.about how it all went rather wrong. So let's get started!

Suggested Video

Basic Layout

Differences in Use between Calc and Excel - Apache OpenOffice Wiki

Additional Resources

You can find some useful links for learning about spreadsheets (particualrly Microsoft Excel) below. Please also watch the recommended starting video series. 

Useful links:

BBC Bitesize Spreadsheets Theory

Free Excel Tutorial (includes all features)

Suggested Video learning series

https://youtu.be/rwbho0CgEAE

Video Series and attribution: “All GCFGlobal.org® videos and content are available for free at edu.gcfglobal.org.”

www.teachyourselfpython.com