Cherepovets, Vologda region. A group of educational psychologists led by L.M. Kuznetsova, Cherepovets, Vologda region Solutions ultimately

The bias against tables has deep roots. To be honest, a dozen years ago tables could not boast of convenience due to the imperfection of the program as a whole. But a lot of time has passed since then. Microsoft has done a great job fixing its mistakes and doing everything possible for the convenience of users. It’s a pity, of course, that many of those same users don’t know about this and still work in the 2003 edition of the office suite. Doesn’t it remind you of the story about hedgehogs and cacti? :)

I simply humanly recommend that anyone stuck in the past upgrade to at least the 2013 version of Microsoft Office, or better yet, immediately to the latest version, 2016. Believe me, it only seems to you that you are working in a classic environment; in fact, it has long been overgrown with moss and mold.

Use templates

Office routine is full, including tables. We take one electronic piece of paper, cut out part of it, insert it into a new document and edit the details. A good technique, but it seems to me that working with templates is a little easier and faster. By the way, in Word itself, templates are called express tables.

Click on the "Insert" tab, click on "Table" and go to "Quick Tables". Pay attention to the “Save selected fragment to collection” item.

Here you will find several quite useful options and, most importantly, you will be able to save any other table or its fragment, including those of your own production, as a template.

Draw tables

Remember the bear that, as a child, walked over your ears and hands in a rampant gypsy dance? It’s been since then that you’ve disliked singing and brushes, and it’s been since then that you’ve stubbornly ignored the “Draw Table” option in Word. Buck up, grown man! It's time to suppress the furry monster! It's easier than it seems.

Click on the “Insert” tab, click on “Table” and go to “Draw Table”.

And don’t be afraid to make a mistake: there is always an eraser at hand. Sometimes a pencil and eraser greatly simplify the creation of complex tables with small elements.

Insert rows and columns quickly

Starting with Word 2013, adding rows and columns has turned from a mind-numbing torture into an exciting fun. Don’t think about it, the archaic “Insert columns on the left/right” and “Insert rows on the top/bottom” have not gone away, but now you can forget about them.

Hover your cursor over the space between rows or columns outside the table and click on the plus sign that appears.

In the future I would like to see something similar for the delete function.

Use a ruler

Every person has favorite and disgusting numbers that he indiscriminately uses or avoids in his life. Even in the parameters of your tables. I know people like that. :)

If you are used to accurately setting the indent values, width and height of cells through table properties, try an alternative - the ruler.

Hover your cursor over the border of columns or rows, grab it, hold down the Alt key and use the convenience of a centimeter ruler.

The same trick can be done with indent and protrusion markers. Hover your cursor over them and hold down the same Alt key.

Use hotkeys

If I were a software developer, I would call hotkeys soul buttons. After all, sometimes you just want to hug your laptop just because they exist. When it comes to Word tables, the three combinations I use most often are:

1. Alt + Shift + Up/Down quickly moves the current line one position higher or lower (simply an irreplaceable thing).
2. Ctrl + Shift + A instantly turns capital letters into capital letters, which is very useful for headings.
3. Ctrl+Tab adds a tab in a cell, while normal Tab moves the cursor to the next cell.

Convert text to table

A little bit of magic that you can show off in front of an amazed audience. Instead of creating tables the traditional way, try a couple of other, more sophisticated options:

• Cell arrays copied from Excel are pasted into Word as a table with invisible borders.
• Well-structured text can be easily converted into a table using standard Word tools.

Select the text, click on the “Insert” tab, click on “Table” and select “Convert to Table”.

Pay attention to the auxiliary parameters: the quality of the conversion directly depends on them.

Control cell sizes

If you want to get to know a person, give him a table with a tyrant text. A slightly loose interpretation of a well-known opinion, of course, but it hits the mark. Just look at the screenshot, or rather at the first column and the word “philological” - an ugly thorn.

According to my observations, in such cases, people first express themselves indecently, and then resort to a less than optimal solution - reducing the font size. But it is better to place the text in a different way.

Right-click in the cell, select “Table Properties”, switch to the “Cell” tab, go to “Options” and check the “Enter text” box.

Word will strain itself and return the runaway letter to its place, and peace will reign in the world again. By the way, for clarity, the “inscribed” text will be underlined with a blue line.

And sometimes you borrow someone’s table and hum contentedly under your breath: “Only you, the fish of my dreams”! Nice work by someone else! You start filling it with your data, and then uncontrollable devilry happens: some columns spread out due to the weight loss of others. The head becomes sober, and reality ceases to please. What should I do?

Jokes aside, it happens that they send you a table of a strict format, with which you cannot make mistakes. At the very least, don’t be lazy to send it back with the same dimensions. This way the recipient will see what he expects to see. To do this, disable auto-sizing based on content.

Right-click in any cell, select “Table Properties”, go to “Options” and uncheck the “Auto-size based on content” box.

The same option will save your table from collapse if you need to fill some cells with images: they will fit as a thumbnail instead of full-size.

Anything to add? Write in the comments.

Our brains are somewhat like muscles. In order for them to work well, they need to be trained regularly. And if you can get a workout for your muscles in the gym, then to warm up your brain you need to solve different problems from time to time.

Today we offer you another logical riddle. Look at the picture and answer what else can be used to fill the cell. Just don’t rush to answer “six”, but try to go beyond your usual thinking and come up with an original but logical answer.

Well, have you come up with your own version? Then check your answer with the correct one, or rather, with the correct ones.

In fact, the original answer to this riddle was supposed to be the Latin letter R. The author of the riddle meant that the picture illustrates the shift pattern of a manual transmission, and the empty space implies reverse gear.

But the author did not realize that there are many different gear shift patterns, and reverse does not have to be in fifth gear. What can we say about cars with 6-speed gears or automatic transmissions? Therefore, do not lose heart and come up with new versions!

Let's take a closer look at the numbers on the table again. There is not a single one among them that uses a circle in its outline. So, judging from an aesthetic point of view, the number 7 would also be the correct answer!

If you look at the picture from a mathematical point of view, you will notice that the sum of the upper numbers is nine (1 + 3 + 5 = 9). And in order for the sum of the numbers in the lower cells to also equal nine, you need to enter a three in the lower right corner.

Fans of Douglas Adams and his masterpiece “The Hitchhiker's Guide to the Galaxy” can safely enter in cell 42, which is the answer to the main question of life, the Universe and all that.

A PARALLEL WORLD

Great psychological game for high school students

A child's play is his life
he is an independent, free person in it,
developing your strength. For real life
the child still has too little spiritual material,
there are few established ideas.
He only has enough of them for GAMES.

V. Shelgunov

And the famous French scientist Louis de Brolle argued that the game, even the simplest one, has much in common with the work of a scientist. In both cases, one is first attracted by the task at hand, the difficulty that needs to be overcome, then the joy of discovery appears, the feeling of overcoming an obstacle. This is why all people, regardless of age, are attracted to the game.

Based on this, we decided to psychologically prepare 11th grade students for taking the Unified State Exam in the form of a game. Using the well-known algorithm of a large psychological game (author - M.R. Bityanova) to develop a scenario, we compiled a questionnaire for 11th grade students. We needed to find out:

Do students need help from a psychologist?

What kind of problems and difficulties do they experience when preparing for exams?

What are the main preferences when spending free time (watching TV, reading books, computer).

The following results were obtained:

89% of students need help from a psychologist when preparing for exams;

The main difficulties in preparing for the Unified State Exam: emotional stress, fear of the exam, high level of anxiety;

70% of students study on the computer in their free time.

Based on these results, it was decided to prepare a game for the 11th grade in the form of immersion in the virtual world. Moreover, knowing the peculiarities of the procedure for conducting the Unified State Exam, where the situation is quite strict, tense, excluding the help of teachers working on the exam, we decided to make the game situation “tough”. This is how the plot of the game “Parallel World” arose, where in order to save your “world” you need to use all the possibilities and activate all abilities, where help can only be received from the “guardian”, and even then insignificant, where the Council of Elders very strictly evaluates the results, and time completion of tasks is strictly limited.

To reduce emotional stress, fear of an exam, and anxiety levels, we have selected next tasks :

“Encryption” (based on the “Corrective Test”);

"The Amthauer Mysteries" (from an intelligence test);

Creating a world project (project method), which will allow high school students not to be afraid to work on tests (this is important for the exam).

In this case, students must:

Show independence in the exam;

Take responsibility for the exam result;

Follow the instructions strictly;

Monitor and check your work.

Expected Result - acquiring new experience and developing the following skills:

Adapt to a new situation;

Mobilize your strength to unlock your personal potential;

Take responsibility;

Work for a limited time;

Show your creative and intellectual potential;

Interact with other participants in group work.

If some tasks seem difficult to the game organizers or unsuitable for the student population, they can be replaced with the following.

Instead of "Encryption":

Bourdon's corrective test;

Toulouse–Pieron test;

Landolt rings.

It should be taken into account that when replacing, the accompanying task “key words” will appear.

Instead of "The Amthauer Mysteries":

Short Selection Test (STT);

Eysenck IQ test;

Cattell Intelligence Test;

Features of the game

1. Students do not know why they are invited to see a psychologist. This is necessary to create the effect of surprise.

2. Participants are not warned about the start of the game. After everyone is freely seated in the classroom (without desks), the lights go out and the text begins to sound. At this moment, the Council of Elders puts on costumes, dim lights come on, and the students find themselves in the computer world.

3. Exiting the game occurs as follows: the lights go out, the costumes are removed, the attributes are removed, and the students return to the real world.

4. It is necessary to prepare quite a lot of materials, but they are all on a floppy disk and can be easily copied.

5. Leaders must be prepared for the fact that students will not want to save their world in the finale (get the last pieces of the map); they must be given this opportunity. This is provided in the script.

6. The Council of Elders has a lot of tasks to check, so we have provided special “keys” to make checking easier.

Game time: 2 hours.

Game features: The game is designed for children aged 15–17 years. It is carried out to prepare students for passing exams.

Game objectives:

reduce the level of anxiety and emotional stress;

relieve fear of exams;

learn to act in unexpected situations;

create conditions for students’ self-realization and disclosure of creative potential.

Participants find themselves in the computer game “Parallel World”, where their world is on the verge of destruction.

Game goal - each player and each team needs to score as many points as possible at each stage of the game in order to save their world. By saving yourself, you save everyone.

Necessary materials

Sheets of colored paper, cardboard, colored cardboard, gray paper.

3 sheets of whatman paper, large paper.

Colour pencils.

Felt pens, markers, wax crayons.

Glue, scissors, tape.

Sheets of A4 paper.

Waste material: old magazines, pictures, fabric.

Presenters need to prepare:

Musical accompaniment;

Badges according to the number of participants;

A3 world map, cut into 60 pieces;

“magic boxes” or bags for putting together earned pieces of the world;

Tables for entering individual results;

Individual certificates according to the number of participants;

General certificate for “ownership of the world”;

Sheets with the task “Encryption”;

Sheets with “Amthauer Riddles”:

Questionnaires for each participant for reflection;

Riddles for finding Encryption tasks.

Participants:

Leading;

3 teams;

Guardian (for each team);

Council of Elders, including:

– three people to count points;

– one person to observe, evaluate, and hand over pieces of the map;

– one person - the Time Keeper.

If there is a shortage of people, only three people can be appointed to the Council of Elders.

Progress of the game

1. In the premises where the game will be played, you must:

Place 3 tables for teams and 1 table for the Council of Elders;

Hang dark curtains;

Decorate the room by creating an imitation of the computer world;

Install lighting equipment (spotlights, backlight lamps, etc.);

Hide the “Encryption” task in special places;

Arrange all the cards in a certain order, that is, as they enter the game;

2. The Council of Elders needs to understand in advance the system for evaluating participants and the “keys” to tasks in order to work quickly.

3. Keepers should take cards with the mottos “Human”, “Hero”, “Superhero” to help students break into teams quickly and in an organized manner.

4. Participants in the game must write their names on name tags.

System for evaluating tasks at different stages of the game

Tasks	Criteria for evaluation	Time
1. Selecting the difficulty of the game (divided into teams). Creation of your union and presentation	2 points for: originality of the idea; originality of presentation.	25 min. (preparation of presentation - 10–12 min., presentation - 2–3 min. for each team)
2. Competition "Keywords"	When calculating, the individual result is recorded separately for each participant, the team result is the average percentage of completion: if 75% is completed, 6 points are counted; 50% - 4 points; 25% - 2 points. Points are added for the difficulty level: “Human” - 0 points; “Hero” - 1 point; "Superhero" - 2 points	5 minutes. (2 minutes - for task 1, 3 min. - for task 2)
3. Intellectual stage - “The Amthauer Mysteries”	When calculating, the individual result is recorded separately for each participant, the team result is the average percentage: 75% - 6 points; 50% - 4 points; 25% - 2 points. Points are added for the difficulty level: “Human” - 0 points; “Hero” - 1 point; "Superhero" - 2 points	10 min. (1st task - 2 min. 6 sec., 2nd task - 2 min. 6 sec., 3rd task - 2 min. 48 sec.)
4. “My future world” (remember the key words, create a project “My future world” and present it)	2 points for: originality of the project; technical ideas; development of the idea; use of keywords. It is possible to accrue an additional point (DB)	20 minutes.

GAME SCRIPT

Stage 1. Immersion in a game situation

The lights go out, running lights and other lighting effects turn on, music plays, text sounds.

Leading. Good afternoon, ladies and gentlemen! You are in virtual mode. This is a parallel world, and you are its inhabitants. Many centuries ago, your world was on the verge of extinction, but heroes defended its right to exist. But now you have disappointed us, your world is cruel, unfair and not very smart. You are fragmented. Your world map has fallen into pieces. The Council of Elders decided to destroy the parallel world. Only a feat can save him, the time and place of which are named and determined by fate, but if a hero does not come, there will be no feat. You have a chance to escape and collect the card. By saving yourself, you save others! The time has come to show yourself, your personal achievements also work for the union.

Using a projector, the “destruction” of the world map is depicted on the screen. At this time, members of the Council of Elders appear. They put on red caps and sit down at the table.

Leading. Decide for yourself who you are, what potential you have. If you live by the principle: “less is more,” then you are human; if you are closer to the idea that “a smart person won’t go up the mountain, a smart person will go around the mountain,” you are a hero; If you are convinced of the correctness of the principle “only forward and not a step back” - you are a superhero. Find others like you. Organize an alliance. The Council of Elders wants to know who you are. It's not all bad, you're not alone. The Guardian will help you. The countdown has begun!

Stage 2. Representation of unions

A dim, subdued light comes on. The participants of the game are divided into three alliances: “people”, “heroes”, “superheroes”. Each union must prepare and introduce itself in 12 minutes. Presentation time is 3 minutes.

Leading. Time is over. Now you need to introduce your team. The Council of Elders is waiting! Who will be first? (If necessary, draw lots) . Thank you. The Council will appreciate your work... But this is just the beginning. Fate is in the hands of one representative from each union. Who he is, you decide. Chosen Ones, messages await you.

One representative from each team comes out. They receive cards indicating the location of the “Encryption” task.

Stage 3. Competition "Keywords"

Having opened the packages, the chosen ones receive tasks that differ for representatives of different unions.

Sample assignment
for the representative of the “Man” union

skhdavshoevmihnasisvnkhvaevktsnaizsevhvhe

unakvnkhspnaivsaerkearchvktsvdsnaiosarisn

vovkgnhisakhvmekvhoisleisnoinkakhsiokvz

naihasnlnaiksheniskveaighskeovskhainao

isdhevkhmvsoevasnskasnesrevhisakhsvkuevhe

shaskekhsakhksehkoaensnaeviseveyariktae

1. Write out all the underlined letters ________________

2. Find and write down the words __________________________

Key #1: House, light, sound, pirate, road, milk, hall, snowmobile, monarch, drying, envelope.

Sample assignment
for the representative of the “Hero” union

Participant name ______________________________

smkhavskhkevhikhnaimsoivanchuzginkhvkhvksan

laisekhvmkhrenaisnaekvhakvnzhvivsnavos

navsnaerkoahvkeksovsnaistapisnavhanr

vkmhisokkhwiekvkhoidvheiskneoinaienskp

hkikhelkavkisvkhniehakhmstkawisvekall

naisxhnekhisnasmxkskvhkaivsnavsnixa

naikaephrkisnasikrheheisondahkekhab

2. Write out all the underlined letters ________________

3. Find and write down the words__________________________

Key #2: Fur, signal, darkness, ringing, rumble, steamer, nose, planet, spring, bowl, nature.

Sample assignment
for the representative of the "Superhero" union

Participant Name: _____________________________________

vhvkpsisnaiarieneaksmkhkivhinikidsnaki

vesknaknuehsksnaitkvehlhkvikesvxinhiak

sdnaxhikhvhvekaesxenaikxnoaiehkrekh

keoihvnvhakaeisnraiakhvskhdnvieeihaoesves

hnaiseakmvshnhaleskhayamsgnaenkriskhkaehnvkh

vskineintsaeaakhekmraivkuvkchhehisknaikha

kaphenaievnikrvkehisnapieehvokvliehaioe

heahvskneeesavneuristnaeahah

2. Write out all the underlined letters __________________

3. Find and write down the words ___________________________

Key #3: Pyramid, bush, fox, sofa, cow, radio, earth, border, pen, commotion, map.

Five minutes later, representatives of the unions hand over the cards to the Council of Elders. The results are calculated according to the scoring system above. The Council of Elders issues map pieces for the 1st competition.

Stage 4. "The Amthauer Mysteries"

Leading. Now it's time to show your intellectual potential. The riddles will put everything in its place...

Those chosen are given special forms to fill out.

Name _______________

level ___________

№	1	2	3	4	5	6	7
Answer

№	1	2	3	4	5	6	7
Answer

№	1	2	3	4	5	6	7
Answer

Leading. Our next challenge is called the Amthauer Mysteries. So, the first riddle. You will be offered seven logic puzzles. Each is formulated in the form of a judgment in which part of the text or a single word is omitted. For each task below Five possible answers are given in the form of short judgments or individual words. They are marked with numbers 1, 2, 3, 4, 5. You need to read the problem, read all the answers and choose the one that seems correct, the most appropriate in meaning to reconstruct the sentence.

Example 1

A rabbit is most similar to: 1) a cat; 2) squirrel; 3) hare; 4) fox; 5) hedgehog. Answer: 3) for a hare.

Example 2

The opposite of hope is: 1) sadness, 2) anger, 3) tenderness, 4) despondency,
5) despair. Answer:5) despair.

In the empty cells of form I you must enter the answer (selected number).

You need to work as follows. If in the 1st problem you choose the answer “3”, then in the plate of form I in the empty cell under the number “ 1 » you will enter “3”. If in the 2nd problem you choose the fifth answer, then in the empty cell under the number “ 2 » Put down the number “5”. And so on: under the number of each problem you write down the number of the answer you chose. Sometimes you may feel like two or even three answers are appropriate. You must choose only one answer and enter only one number in the empty cell under the corresponding problem number.

So, get started!

Those elected work for ten minutes with the forms received from the Council of Elders.

THE FIRST RIDDLE OF AMTHAUER

FOR THE UNION "MAN"

1. The condition for the existence of living beings is...

1) movement; 2) metabolism; 3) air; 4) light; 5) nervous system.

2. Practical classes are mostly related to (with)...

1) intelligence; 2) penetration into the essence of the issue; 3) experience; 4) production work; 5) knowledge of the matter.

3. A stone in free fall falls to the ground from a height of 10 meters in... seconds

1) 0,3; 2) 0,5; 3) 1,4; 4) 2,0; 5) 3,0.

4. Each company has...

1) building; 2) warehouse; 3) profiles; 4) name; 5) products.

5. Anyone who works needs (o)...

1) ambition; 2) task; 3) boss; 4) tool; 5) intelligence.

6. The most common cause of flood is...

1) dam break; 2) rain; 3) melting ice; 4) bad weather; 5) disaster.

7. Mercury is...

1) metal; 2) mineral; 3) solution; 4) chemical compound; 5) alloy.

FOR THE UNION "HERO"

1. ... has nothing to do with the weather.

1) hurricane; 2) earthquake; 3) hail; 4) thunderstorm; 5) fog.

2. An airplane is... a means of transport

1) the largest; 2) the most expensive; 3) the most unreliable; 4) the easiest; 5) the fastest.

3. Decisions ultimately...

1) are being considered; 2) are planned; 3) accepted; 4) are complied with; 5) are being discussed.

4. Studying is first of all...

5. Analysis is...

1) result; 2) decomposition into parts; 3) planning; 4) systematization; 5) development.

6. Life is...

1) activity; 2) condition; 3) occupation; 4) development; 5) ability.

7. Most quadrupeds are...

1) mammals; 2) pets; 3) predators; 4) carnivores; 5) herbivores.

FOR THE SUPERHERO UNION

1. ... has the longest coastline.

1) Ireland; 2) Norway; 3) France; 4) Bulgaria; 5) Italy.

2. The plane always has (have)...

1) motor; 2) chassis; 3) radio; 4) passengers; 5) planes (wings).

3. The smallest area (in sq. km) has...

1) Sardinia; 2) Crete; 3) Malta; 4) Sicily; 5) Cyprus.

4. The problem is best solved by...

1) experience; 2) concentrations; 3) mind; 4) reflections; 5) getting into the essence.

5. A movie is unthinkable without...

6. ... serves to prevent accidents.

1) a box with dressings; 2) barrier; 3) emergency exit; 4) lifebuoy;
5) fire extinguisher.

7. Using a ruler, measure...

1) segments; 2) length; 3) area; 4) distances; 5) corners.

The key to the first riddle

(same for riddles of all unions)