Topicmd9d7f09d98fcf1a3_1528449000663_0Topic

Sorting text in a table

Levelmd9d7f09d98fcf1a3_1528449084556_0Level

Second

Core curriculummd9d7f09d98fcf1a3_1528449076687_0Core curriculum

Grade VII and VIII

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

2) creates documents and presentations, including those in a cloud in order to solve problems and create papers from various fields (subjects), adjusts the format and the appearance of the research papers to their content/purpose and demonstrates the following skills:

b) creating various documents: formatting and merging texts, inserting symbols, images and tables, using document templates and dividing longer documents into pages.

Timingmd9d7f09d98fcf1a3_1528449068082_0Timing

45 minutes

General objectivemd9d7f09d98fcf1a3_1528449523725_0General objective

Creating text documents.

Specific objectivesmd9d7f09d98fcf1a3_1528449552113_0Specific objectives

1. Converting text to a table and a table to text.

2. SortingsortingSorting data in a table.

Learning outcomesmd9d7f09d98fcf1a3_1528450430307_0Learning outcomes

The student:

- creates a table by converting text,

- sorts data in a table in an ascending and descending order.

Methodsmd9d7f09d98fcf1a3_1528449534267_0Methods

1. Sentence completion.

2. Learning through observation.

Forms of workmd9d7f09d98fcf1a3_1528449514617_0Forms of work

1. Individual work.

2. Class work.

Lesson stages

Introductionmd9d7f09d98fcf1a3_1528450127855_0Introduction

The task of the students is to revise the information about sorting. The students, using the sentence completion method, order the information about sorting.

SortingsortingSorting consists in ordering data according to _______ (e.g. specified criteria).

You can sort _______ (e.g. numerical digits, numbers, letters, words, dates).

Sorting numbers from the largest to the smallest is _________________ (descending sort).

Sorting numbers from the smallest to the largest is _________________ (ascending sort).

Alphabetical sorting from Z to A is _________________ (descending sort).

Alphabetical sorting from A to Z is _________________ (ascending sort).

Proceduremd9d7f09d98fcf1a3_1528446435040_0Procedure

During your work with a text document it may turn out that the text ordered with the use of tabs must be represented in the form of a table. Text editors offer a convenient tool which enables to quickly change text to a table. The option Convert Text to Table is used for this purpose. It places the text in the appropriate cells of the table based on separators, i.e. characters that separate text. Not only tab characters, but also paragraph marks, semicolons or any other character entered with the keyboard, e.g. the space or any letter, can be separator characters.

To convert text to a tableconvert text to a tableconvert text to a table, first click the Show/Hide paragraph mark on the Home tab to see how the text is separated in your document. Select the text you want to convert, and then click Insert > Table > Convert Text to Table. In the Convert Text to Table box, choose the appropriate options. Make sure the numbers under Table size correspond to the number of columns and rows you want to create. Under Separate text at, select the separator character which has been used in the text.

[Illustration 1]

Under AutoFit behavior in the Convert Text to Table box, the following options are available:

- Fixed columncolumncolumn width – to specify a width for all the columns,
- AutoFit to contentsautofit to contentsAutoFit to contents – to resize the columns automatically to fit the width of the text in each column,
- AutoFit to windowautofit to windowAutoFit to window – to resize the table automatically to fit the width of the available working area.

Every table can be converted to text separated by separator characters in place of the column boundaries.

Task 1

Download the file with an example including the text with the data on the selected set books. Convert the text to a table. On the internet find the first names of the writers and change the initials into the first names.

[file to download]

[Interactive graphics]

SortingsortingSorting text in a table

If data in a table need ordering in an ascending or a descending order, use the Sort command. You can sort by any column, according to text or number. You can also sort only the part of the table.md9d7f09d98fcf1a3_1527752256679_0If data in a table need ordering in an ascending or a descending order, use the Sort command. You can sort by any column, according to text or number. You can also sort only the part of the table.

[Illustration 2]

SortingsortingSorting by only one columncolumncolumn often turns out to be not enough. In such a case multi‑level sort must be performed, which is sorting by more than one column.

In order to sort the contents of a table, follow these steps:

- select the table (or its part),
- on the Table Tools tab, choose Layout, and then Sort,
- in the Sort dialogue box, select the following options:
- click the Header rowrowrow box under My list has, if your table has a header rowrowrow,
- choose the name of the column you want to sort the table by,
- specify the type of the data in the column,
- select a sort order,
- if you want to perform a second level sort, you enter thi information under Then by.

[Illustration 3]

Task 2

Sort the data in the table used in the previous task:

- alphabetically by the columncolumncolumn Surname,
- alphabetically by the columns Surname and First name,
- alphabetically by the columns Surname and First name separately for all grades.

Task 3

Convert the table used in the previous task to text.

Lesson summarymd9d7f09d98fcf1a3_1528450119332_0Lesson summary

Apart from the contents of tables, Word can also sort the contents of bulleted and numbered lists. In this case you must use the Sort tool on the Home tab.md9d7f09d98fcf1a3_1527752263647_0Apart from the contents of tables, Word can also sort the contents of bulleted and numbered lists. In this case you must use the Sort tool on the Home tab.

Selected words and expressions used in the lesson plan

autofit to contentsautofit to contentsautofit to contents

autofit to windowautofit to windowautofit to window

columncolumncolumn

convert text to a tableconvert text to a tableconvert text to a table

in a descending orderin a descending orderin a descending order

in an ascending orderin an ascending orderin an ascending order

rowrowrow

sortingsortingsorting