Bilingualer Fachunterricht an berufsbildenden Schulen

Unterrichtsmodul

		Berufsfeld:		Wirtschaft / Verwaltung

		Beruf:	            Kaufmännischer Assistent  für Informationsverarbeitung

Spreadsheet Programmes

ACTION PROGRAMME OF THE EUROPEAN UNION
LEONARDO DA VINCI – PROJECT
PROJECT No.: 2002 LA 112 628 BILVOC
LANGUAGE COMPETENCE THROUGH BILINGUAL TEACHING AT VOCATIONAL COLLEGES

 

 

 

 
Teaching Module 

Date of Production: 
 	March 2003 	
Subject: 
 	English for Computer Users 	
Topic: 
 	Spreadsheet Programmes (Introductory lesson) 	
Title: 
 	Spreadsheet Programmes 	
Target Group: 
 	Trainees and students who will have to be able to talk about computers and what one can do with them in their future job 
 	
Prior Knowledge: 
 	Being able to use basic English words for computer hardware and software as well as a general knowledge of English 
 	
Level of Language Skills: 	Threshold/ Vantage ( B1/ B2)
 	
Follow-Ups: 
 	Forms, databases, diagrams 	
Objectives: 
 	Students should be able to understand and talk about basic ideas of spreadsheet programmes 
 	
Benefits: 
 	Students get to know the basic English vocabulary of the topic in their first lesson about spreadsheet programmes (They study the programme in detail in their mother tongue.) 

   

 

Unit Structure  
 
Time 	Contents 	Teacher’s activities 	Students’ activities 	Media 	Teaching method 	
10 minutes 	general information on the topic 	puts in the cassette 	listen and take notes 	cassette recorder, paper, pens 	presentation/  text on the cassette 	
7 minutes 	What do we need these programmes for? 	writes the results on the blackboard 	collect their results 	blackboard (appendix 1) 	discussion 	
10 minutes 	What does a spreadsheet consist of? 	points at the components and writes vocabulary and important information on the blackboard/ explains 	listen and write down what is on the blackboard 	computer, beamer, 
blackboard 
(appendix 1) 	presentation/ teacher 	
10 minutes 	simple functions of the programme  	points at and explains simple functions of the programme and writes more vocabulary on the blackboard   	listen and write down what is on the blackboard 	computer, beamer, 
blackboard 
(appendix 1) 	presentation/ teacher1	
8 minutes 	checking if students understood 	Points at the components and shows different functions 	explains (using the foreign language) 	computer, beamer, pointer 	asking the students 	

 

   
1 One of the teachers shows simple function of EXCEL and the other teacher explains them in English. 

Verlaufsplanung

Zeit 	Inhalt 	Aktivitäten der Lehrer/ des Lehrers 	Aktivitäten der Schüler 	Medien 	Methode 	
10 min 	allg. Informationen zum Thema 	legt Kassette ein 	hören zu,  
machen Notizen 	Kassettenrekorder, 
Blätter, Stifte 	Präsentation/ Hörtext 	
7 min 	Wozu braucht man diese Programme? 	hält Ergebnisse an Tafel fest 	tragen Informationen aus dem Hörtext zusammen 	Tafel 	Diskussion 	
10 min 	Woraus besteht eine Tabellenkalkulation? 	zeigen auf Bestandteile und halten Wortmaterial sowie wichtige Infos an Tafel fest/ 
erläutern 	hören zu, schreiben mit 	Computer, Beamer, 
Tafel 	Präsentation/ Lehrer 	
10 min 	Einfache Funktionen des Programms 	zeigen und erläutern einfache Funktionen des Programms und halten weiteres Wortmaterial an der Tafel fest 	hören zu und schreiben mit 	Computer, Beamer, 
Tafel 	Präsentation/ Lehrer 	
8 min 	Überprüfung des Gelernten 	zeigt auf Bestandteil oder führt Funktion vor 	erläutern in der Fremdsprache	Computer, Beamer, Zeigestab 	Schülerbefragung	

 

Appendix 1 

source: Infotech- English for Computer Users , Teacher’s Book, Cambridge University Press, 1999, p.64

Appendix 2

Possible notes on the blackboard: 

Spreadsheet programmes 

	- used for keeping records of accounts, for analysing budgets, making specific calculations ... 
 
- can hold: 	1 texts 
        	2 numbers 
               	3 formulas = functions or operations (sums, differences, products, quotients ...) 

- parts: 
 
row          -         column  (256)          →   point of intersection  =  cell   
  ↓    ↓      ↓ 
number           letter     (A1, C6 ...)