Want to make creations as awesome as this one?

Transcript

LESSON IVADMINISTRATION

ENGLISH FOR INFORMATION AND TECHNOLOGY

PREVIEW

WHAT IS A DATABASE?HOW OFTEN ARE IN CONTACT WITH DATABASES?WHAN ARE SOME EXAMPLES OF THEM?

  • Match sentences 1 - 4 to sums a - d.
  • Then, rewrite the sentences using the words in brackets.

LISTENING PRACTICE

Listen to your teacher questions, write your sums and calculate the result.
  • Listen to a trainer explaining a formula in this spreadsheet.
  • Match the letters to the numbers.
  • What does the formula do?

SPREADSHEETS

  • Look at this example
  • Listen and write / type the formula you hear.

DATABASES

Listen to four employees expalining their problems with spreadsheers. complete the chart.

What were the solutions for the previous problems?

EVALUATION

Use the previous knowledge to present a spreadsheet to sell any product. You can take the example and explain the cost of getting the licence for 3 new computers.

MENTION 10 WORDS FROM THE PREVIOUS CLASS

5.

4.

10.

3.

2.

9.

8.

1.

7.

6.

Listen to a database administrator describing the structure of a company database to a trainee.Match these words to the pictures A, B, C.1. REPORT 2. TABLE 3. FORM

listen again, which option best describes what the databAse keeps track of:

A) CLIENTS AND ORDERS B) STOCK AND ORDERS C) ORDERS AND FULL ACCOUNTS
fields form objects primary key report uniquequery the database record retrieve a record

Complete the text with the words in the box.

  • FOLLOW THE EXAMPLE...
  • ASK AND ANSWER HOW TO DO THE FOLLOWING THINGS IN A DATABASE.

0. ENTER DATA IN A DATABASE (OPEN / ENTER)A: HOW DO YOU ENTER DATA IN A DATABASE?B: YOU CAN DO THAT BY OPENING AND ENTERING THE DATA INTO THE FIELDS.1. FIND INFORMATION IN A DATABASE (QUERY)2. ADD A COLUMN OF NUMBERS IN A SPREADSHEET (TYPE)3. MAKE SURE EACH RECORD IN A DATABASE IS UNIQUE (USE / PRIMARY KEY)4. PRINT INFORMATION FROM A DATABASE (RUN / REPORT)

GIVE SOLUTIONS TO THE PROBLEMS.FOLLOW THE EXAMPLE: YOU CAN SOLVE YOUR PROBLEM BY...

  • LISTEN TO A SYSTEM ADMINISTRATOR ASKING A TECHNICIAN ABOUT THE STATUS OF THE COMPANY'S COMPUTER SYSTEMS.
  • MARK THE CORRECT COLUMN IN THIS TABLE.
  • Use BEFORE, AFTER AND WHILE TO CREATE NEW SENTENCES:

BEFORE, AFTER, WHILE

INSTALL AN OPERATING SYSTEM / THE COMPUTER MAY REBOOT SEVERAL TIMES.DEPLOY MAJOR SOFTWARE UPGRADES / TRAIN THE USERS.REPLACE THE HARD DRIVE / EVERYTHING WILL GO SMOOTHLY.FORGET THE PASSWORD / RESET IT.

  • Use BEFORE, AFTER AND WHILE TO SHOW THE ORDER OF EVENTS.
  • WE CAN USE AN -ING VERB AFTER THESE WORDS.
BEFORE INSTALLING THE NEW SOTFWARE, DO A FULL BACKUP.

WHAT WOULD YOU DO OR CHECK.... BEFORE, AFTER OR WHILE THESE ACTIONS:

  • UPGRADE SOME SOFTWARE
  • SWITCH OFF A SERVER' WITH USERS' COMPUTERS NETWORKED TO IT
  • Use these prompts to help you!
  • EVALUATION:

WHAT WILL BE A RESPONSE TO THIS PROBLEM?GIVE SOME SOLUTIONS USING BY/AFTER/BEFORE/WHILE +ING VERB

Do you have an idea?

With Genially templates, you can include visual resources to leave your audience speechless. You can also highlight specific phrases or data that will stay ingrained in the memory of your audience and even embed external content that surprises: videos, photos, audios... Whatever you want! Need more reasons to create dynamic content? Well: 90% of the information we assimilate comes through our sight, and we retain 42% more information when the content moves.