Computer Science LearnITWithMrC ⛯ Year 7 Year 8 Year 9 GCSE
Responsive image

Intro - Spreadsheets

What do I need to Learn?

I need to learn how to identify the different parts of a spreadsheet eg. row, column, worksheet etc.
I need to learn how to save and share workbooks
I need to learn how to adjust and modify cells and use the fill handle

Knowledge Organiser

×

Lesson

Task 1 - Getting Started Click to see more

Learning Activities

Getting Started with Excel

Introduction

Excel is a spreadsheet program that allows you to store, organize, and analyze information. While you may think Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data.


Elements of a Spreadsheet

How spreadsheets work

A spreadsheet appears as a grid - each row has its own number and each column its own letter. This labelling of rows and columns is used to give each cell a cell address or reference, for example, C5 means column C, row 5.

It is also possible to refer to a range of cells collectively, ie E4:E12 includes E4, E12 and all of the cells in-between.

Cells can contain numbers, text or formulae.

Note: Make sure that you memorise this as there will be a test on it at the end.


Task 2 - Saving and Sharing Workbooks Click to see more

Working with Spreadsheets

Saving and Sharing Workbooks

Whenever you create a new workbook in Excel, you'll need to know how to save it in order to access and edit it later. As with previous versions of Excel, you can save files locally to your computer. You can also save a workbook to the cloud using OneDrive, as well as export and share workbooks with others directly from Excel.

Click on the link below complete the exercise in Saving and Sharing Excel Workbooks and then complete the challange at the end.


Task 3 - Cell basics Click to see more

Cell basics

Whenever you work with Excel, you'll enter information—or content—into cells. Cells are the basic building blocks of a worksheet. You'll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel.

Click on the link below and complete the exercise in Cell Basics and then complete the challange at the end.


Task 4 - Modifying Spreadsheet Cells Click to see more

Modifying Spreadsheet Cells

By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells.

Click on the image below to complete the Modifying Worksheets challenge.


Task 5 - Test your understanding Click to see more

Exercise - Check your understanding

Click on the Image below to start the spreadsheet quiz
Click on the Image below to start the mini quiz


Task 6 - Reviewing it all Click to see more


Summing it all up

Lets look at the learning outcomes and decide which one best describes our current level of understanding :

Tick the one you feel is closest to your level

Learning Outcomes I need to learn how to identify the different parts of a spreadsheet eg. row, column, worksheet etc.

  • I have a basic understanding of how I can identify the different parts of a spreadsheet eg. row, column, worksheet etc. with a little help from my teacher
  • I can show my teacher that I can identify the different parts of a spreadsheet eg. row, column, worksheet etc. without their help.
  • I can identify the different parts of a spreadsheet eg. row, column, worksheet etc. independently and I can also explain it to others and can complete any extension tasks I am given.

🠜 Now update your learning objectivesClick on the Assessment image


My Notes: modelling

Student_Comment_1 not found

Task Notes/Comments - Add here Click to see more

Comments/Notes