Lesson plan

Topicm3cec5a0f8a493624_1528449000663_0Topic

Formatting cells in a spreadsheet

Levelm3cec5a0f8a493624_1528449084556_0Level

Second

Core curriculumm3cec5a0f8a493624_1528449076687_0Core curriculum

Grade IV - VI

II. Programming and solving problems by using the computer and other digital devices. The student:

3) develops and presents solutions to problems by using basic applications (a text and image editor, a spreadsheet, a programme for creating a multimedia presentation) on the computer or in a cloud to demonstrate the following skills:

c) using a spreadsheet for solving tasks associated with simple calculations, entering data into a worksheet, formatting cells, defining simple formulas and selecting appropriate charts for the data and the objectives of calculations.

Timingm3cec5a0f8a493624_1528449068082_0Timing

45 minutes

General objectivem3cec5a0f8a493624_1528449523725_0General objective

To use a spreadsheet to solve tasks.

Specific objectivesm3cec5a0f8a493624_1528449552113_0Specific objectives

- To use a spreadsheet to solve tasks.
- To present data by using a spreadsheet.

Learning outcomesm3cec5a0f8a493624_1528450430307_0Learning outcomes

1. Student formats cells.

2. Student selects an attractive and clear format suitable for the presented content.

Methodsm3cec5a0f8a493624_1528449534267_0Methods

Learning through observation

Forms of workm3cec5a0f8a493624_1528449514617_0Forms of work

Individual work.

Laboratory classes with elements of a lecture and demonstrations.

Lesson stages

Introductionm3cec5a0f8a493624_1528450127855_0Introduction

Formatting a spreadsheet aims at improving its readability.

Apart from data, tags can also be entered into cells. Tags precisely describe the operations done in the spreadsheet.

Procedurem3cec5a0f8a493624_1528446435040_0Procedure

Discussion

The teacher talks with the students about their previous experience with formatting cells in a spreadsheet. They discuss the role of formatting spreadsheets.

A document theme is a predefined set of colours, fonts and effects (such as line styles and fill‑in effects) which will be available in order to format the data in a spreadsheet or other elements, such as tables, pivot tables and charts.m3cec5a0f8a493624_1527752263647_0A document theme is a predefined set of colours, fonts and effects (such as line styles and fill‑in effects) which will be available in order to format the data in a spreadsheet or other elements, such as tables, pivot tables and charts.

Before formatting data in a spreadsheet, a suitable document theme can be applied so that colours, fonts and effects defined by this document theme could be used for formatting data in the spreadsheet.m3cec5a0f8a493624_1527752256679_0Before formatting data in a spreadsheet, a suitable document theme can be applied so that colours, fonts and effects defined by this document theme could be used for formatting data in the spreadsheet.

A style is a predefined format, often based on the theme, which can be applied in order to change the way in which data are displayed. If the predefined styles do not meet the specified requirements, one of them can be adjusted to our own needs.

In Excel, styles can be applied for cells and tables.

Manual data formatting includes:

- formatting texts in cells,
- highlighting data with borders and colours,
- changing data alignment and orientation,
- changing the width of the column and the height of the row,
- changing data formats or the accuracy of displaying numbers.

[slideshow]

Task Create a spreadsheet containing any data (e.g. a timetable, a calendar) in which you will apply manual methods of formatting the data.

You will find most of the tools in the tool ribbon. All options will be available in the pop‑up menu of the ‘Format Cells’ dialog box. There you will find the following options: Wrap Text, Merge Cells and Orientation.

In the case of formatting the whole spreadsheet we can hide unwanted rows or columns.

Task

Hide column B and row 2 in the spreadsheet. Do the reverse: show column B and row 2.

Copy the formatting to other cells.

You can use ‘Paste Special’ command to copy formatting from selected cells. This is similar to Format Painter option.

Automatic formatting of adjacent cells. The formats of data ranges are automatically applied for new rows and columns entered at the end of the data range which has already been formatted, and the formats are displayed in at least three of the previous five elements. These values can be changed in programme settings.m3cec5a0f8a493624_1527712094602_0Automatic formatting of adjacent cells. The formats of data ranges are automatically applied for new rows and columns entered at the end of the data range which has already been formatted, and the formats are displayed in at least three of the previous five elements. These values can be changed in programme settings.

Lesson summarym3cec5a0f8a493624_1528450119332_0Lesson summary

An unformatted spreadsheet is seldom readable. Not only is Excel useful for doing calculations, but is also an ideal tool for attractive data presentation.

Selected words and expressions used in the lesson plan

themethemetheme

stylestylestyle

formattingformattingformatting

manual formattingmanual formattingmanual formatting

borderborderborder

cell mergecell mergecell merge

text wrappingtext wrappingtext wrapping

fillfillfill

m3cec5a0f8a493624_1527752263647_0

m3cec5a0f8a493624_1527752256679_0

m3cec5a0f8a493624_1527712094602_0

m3cec5a0f8a493624_1528449000663_0

m3cec5a0f8a493624_1528449084556_0

m3cec5a0f8a493624_1528449076687_0

m3cec5a0f8a493624_1528449068082_0

m3cec5a0f8a493624_1528449523725_0

m3cec5a0f8a493624_1528449552113_0

m3cec5a0f8a493624_1528450430307_0

m3cec5a0f8a493624_1528449534267_0

m3cec5a0f8a493624_1528449514617_0

m3cec5a0f8a493624_1528450135461_0

m3cec5a0f8a493624_1528450127855_0

m3cec5a0f8a493624_1528446435040_0

m3cec5a0f8a493624_1528450119332_0

border1

cell merge1

fill1

formatting1

manual formatting1

style1

text wrapping1

theme1

Scenariusz

Topicm3cec5a0f8a493624_1528449000663_0Topic

Lesson stages

Selected words and expressions used in the lesson plan