TPT
Total:
$0.00
5 results

End of Year computer science scaffolded notes for Microsoft Excel

Preview of Excel Spreadsheet Basics

Excel Spreadsheet Basics

Typically I go through these notes as I demonstrate it using the software on my projector. It gives them a visual to help learn the material better than it would reading from a textbook.These notes include the following topics:What are spreadsheets used for?What is the purpose of a worksheet?Parts of a worksheetWorking with a spreadsheet (moving around, entering data, formulas, formatting)Entering data (difference between values and labels, formatting cells)Editing data (moving, copying, removi
Preview of Spreadsheets Lesson 2

Spreadsheets Lesson 2

Created by
Lubna Sorour
A 9 sheet stimulating workbook containing lots of explanation and exercises covering the following topics:Printing areas and worksheetsMove, copy and paste cellsCreating worksheetsUsing the fill handle (4 exercises)Suitable for independent learning with minimal guidance.
Preview of Spreadsheets: Basic Functions and Formatting

Spreadsheets: Basic Functions and Formatting

Created by
Lubna Sorour
An Excel file with different activities to train the students on basic formatting and the four functions SUM, AVERAGE, MAX and MIN
Preview of Spreadsheets: Count Functions

Spreadsheets: Count Functions

Created by
Lubna Sorour
A comprehensive resource to train students on the use of the COUNT, COUNTA and COUNTIF functions. Prior knowledge: Using basic Excel functions e.g. SUM and AVERAGE
Preview of Spreadsheets: Lesson 3 - Absolute references and Formulas across worksheets

Spreadsheets: Lesson 3 - Absolute references and Formulas across worksheets

Created by
Lubna Sorour
In this lesson, students will learn how to create formulas across worksheets in a fun activity. They will also learn how to use absolute referencing.
Showing 1-5 of 5 results