174 POLYTECHNISCHE SCHULE | BERUFLICHE BILDUNG | ALLGEMEINBILDUNG Titel SBNR ISBN Preis CLIL – Content and Language Integrated Learning, EXCEL englisch 200564 978-3-7068-6318-6 € 19,90 Begleitmaterialien für Lehrpersonen sind mit Schulkennzahl und Ihrem SchulPIN über die Schulbibliothek als Download im jeweiligen Buchtitel verfügbar. CLIL Content and Language Integrated Learning in Informatics Baier Schultyp: 4100; 4600; 4710; 4730 Solving Excel Tasks in English Englisch als Arbeitssprache nutzen – der Startvorteil für aktuelle Anforderungen im Beruf! → Klare Zielvorgaben und Arbeitsanweisungen – mehr Durchblick durch strukturiertes und aktives Kompetenztraining! → An Beispielen aus unterschiedlichen Praxisbereichen arbeiten – fit im Kopf durch analytisches Denken! → Kreative Analyse-Tools ausprobieren – Daten anschaulich präsentieren und Zusammenhänge besser verstehen! → Kompakte Excel-Beispielsammlung in Englisch → Trainieren der wichtigsten Excel-Tools zum Aufbereiten und Analysieren von Daten → Beispiele aus der professionellen Praxis → Alle Übungsdateien zum direkten Download aus dem Buch → Hilfe-Dateien zur Unterstützung bei anspruchsvollen Aufgaben → Vokabelübersicht zum schnellen Nachschlagen INFORMATIK > Angewandte Informatik Instructions The company you work for needs the sales figures of its Austrian branches in the second half of the year to be calculated and displayed graphically. Open the task file “Graphical sales analysis” or create the tables below. 1. Calculate the sums and averages using a function. 2. Create a chart of the type “Line with markers”. Insert the chart below the data table. 3. Display the axis titles. Label the horizontal axis with “Second half of the year” and the vertical axis with “in thousands”. 4. Add the chart title “Sales of Austrian branches“. 5. Rearrange the legend above the graph. 6. Enlarge the plot area so that the legend can be placed. 7. Change the value axis to a minimum of 90 (the value at which the axis starts) and a maximum of 280. 8. Create another chart and compare the cities with the minimum and maximum sales in the second half of the year. Chart type: Bar 9. Label the value axis and add the chart title “Comparison Maximum Sales – Minimum Sales”. 10. Place the legend in the top left corner. 11. Color the chart area (white) and the plot area (gray). Align the data label horizontally. CLIL in Informatics 61 Unit 8: Charts MARKET SHARE Skills ■ Use simple formulas ■ Use absolute references ■ Create and format a bar chart Instructions In this example, the sales of smartphones in the first three quarters of the last year need to be calculated and displayed graphically. (Source: www.gartner.com) 1. Calculate the sums of smartphone sales using a function and calculate the absolute market shares (in %). 2. Create a bar chart with the calculated market shares and insert it below the data table. 3. Format the chart as shown below. SALES ANALYSIS Skills ■ Use simple functions ■ Format chart legends ■ Create different charts ■ Add chart titles ■ Change layouts and formatting axes 2 LINK Market share Download your work files. 3 LINK Sales analysis Download your work files. LINK Sales analysis_Help If you need help, look at this file. 60 CLIL in Informatics PRACTICE 2Functions Learn about basic functions (MIN, MAX, COUNT and AVERAGE) and get familiar with the IF function. Later on you will hear about the RANK function, COUNTIF and SUMIF. Furthermore you will practise the use of custom sort and advanced filter. MIN, MAX, COUNT, AVERAGE Skills ■ Use relative and absolute references ■ Use COUNT, MIN, MAX and AVERAGE functions Instructions A wardrobe made of solid wood is auctioned at a furniture auction. Since there are several interested parties, the auction house would like to find out a few details, e.g., the highest and lowest bids, the highest and lowest commissions per offer, etc. 1. Calculate the commission fee per offer. 2. Display the lowest and the highest bids in the table as well as the average and the total number of bids. Calculate the lowest, the highest and the average commission fees as well. Furthermore, the oldest and the youngest bidders should be displayed as well as the average age of all bidders. Compute the results by using a formula. 1 LINK Min Max Count Average Download your work files. CLIL in Informatics 13 Unit 2: Functions CHART: ZERO-ALCOHOL-LEVEL Skills ■ Create a bar chart Instructions In a new survey regarding a zero-alcohol-level approach to road traffic, the results differ in age groups. Calculate the missing data and create a chart: 10 LINK Chart zero-alcohol-level Download your work files. 12 CLIL in Informatics Blick ins Buch
RkJQdWJsaXNoZXIy Mjg5NDY1NA==