Inf Erettzségi Hun

7/27/2019 Inf Erettzsgi Hun

1/16

Informatika angol nyelven kzpszint gyakorlati vizsga 1112

Nv: ........................................................... osztly:......

INFORMATIKAANGOL NYELVEN

KZPSZINTGYAKORLATI VIZSGA

2012. mjus 21. 8:00

A gyakorlati vizsga idtartama: 180 perc

Beadott dokumentumok

Piszkozati ptlapok szma

Beadott fjlok szma

NEMZETI ERFORRSMINISZTRIUM

A beadott fjlok neve

RETTS

GIVIZSG

A

2012

.mjus2

1.


2/16

gyakorlati vizsga 1112 2 / 16 2012. mjus 21.

Informatika angol nyelven kzpszint Nv: ........................................................... osztly:......


3/16


4/16


5/16



16.Create a header and type text Quick report of the Hungarian Central Statistical Officeinto it. In the footer display the page number. Format the text of the header and the footer

according to the instructions above and align it according to the example.

17.The created document should not contain unnecessary spaces and blank paragraphs. Usehyphenation in the whole text.

Example:

40 marks


6/16



2. Lszl Br

Create a webpage according to the following description and example to introduce Lszl

Br, a journalist of Hungarian origin and the inventor of the ballpoint pen.

The files to be created arebiro.html

,structure.html

andball.html

. All threepages should have the same structure and tone according to the description and the example.

The text of the pages can be found in the UTF-8 encoded file birosource.txt.

The pictures required for the solution of the exercise are pen.png,photo.jpg,

struc.pngandmagnified.jpg. When using the pictures pay attention to displaying them

correctly even after moving the exam directory.

Common properties

1. The three pages should have the same structure. For the properties of the pages set thebackground colour to a shade of blue (colour code #6EB5B8) and the text colour to dark

gray (colour code #3A414C). The link colour should be light gray (colour code #756F72)

in each state.

2. The title of the pages displayed in the title bar of the browser should be Lszl Br.3. The content of the pages should be placed into a table whose properties are as follows:

The different cell number of the rows should be created from 4 rows and 3 columns. The width of the table should be 800 pixels and it should be aligned centered

horizontally.

The background colour of the table should be green (colour code #A7FFC3). The table should not have a border, both the cell padding and the cell spacing

should be 5 pixels. The top three cells of both the first and the third column should be merged. The three cells of the fourth row should be merged. The width of the first and third columns should be 50 pixels.

4. Insert picturepen.pnginto the first and third cells of the first row of the table.5. The menu, that is the links to the other two pages and the picture belonging to the current

page, is contained in the first three cells of the second column. Type in the texts according

to the example and create the links. Format the links using style Heading 1 and align them

centered horizontally within the cells. Set the height of the two cells containing the links

to 125 pixels on each page.

biro.html

6. First create page biro.html. Insert picturephoto.jpginto the middle cell of the firstrow of the table and set a border of 1 pixel for it.

7. Insert the text of the page from file birosource.txt into the fourth row of the table.Create the paragraphs according to the example.

8. The style of subtitle The ballpoint pen Lszl Br journalist, inventor should beHeading 2.

structure.html

9. The unfinished version of the structural drawing on the next page is located in filestruc.png. Create picture explanation.pngfrom it according to the example.


7/16


8/16



Example for the Lszl Br exercise:

structure.html


9/16



Example for the Lszl Br exercise:

ball.html


10/16



3. College

In the Cube College the students are taught in small groups. The individual groups are

identified with colours. The groups are rated based on their students average after handing

out the semester reports. The statistical data are also displayed on the home page of the

institute. In the following exercise you have to create this report.

Solve the following exercises using a spreadsheet processor.

During the solution take the followings into consideration.

Whenever possible, use a formula, function or reference in the solution in order to get therequired results even if the basic data are changed.

There are parts in the exercise that use the results from a previous question. If you couldnot solve an exercise part completely, use its solution as it is, or instead of a formula

resulting in a number enter a reasonable result and work on with that. This way you can

receive marks for that exercise part as well.

You can use auxiliary cells to the right of column W if required.1. Import file coll.txt, which is a UTF-8 encoded text file tagged by tabs, into the

spreadsheet processor starting from cell A1. Save it as college in the default format of

the spreadsheet processor.

2. In column T determine the average of the marks for each student. The average of themarks is 1 if the student received a fail (1) mark from any subject, otherwise it is the

arithmetic mean of the marks.

3. In column U rate the students based on their average. The rating for an average below2.00 is fail, above 2.00 satisfactory, above 2.75 mediocre, above 3.75 good, above 4.50

exemplary and 5.00 is excellent. You may use auxiliary cells or perform auxiliary

calculations in the solution of the exercise if required.

4. In the corresponding cells of row 28 determine the average number of justified andunjustified absences, the subject averages and the college average based on the subject

averages.

5. Create the second row shown in the example in row 29 of the table. The cells fromcolumnD to column Sshould follow the changes in the first row. Type the content shown

in the example into cellsB29, C29 and T29.

6. Type the names of the groups into rangeB30:B33.7. In range C30:C33 determine the number of students in each group.8. In range D30:S33 determine the absence and subject averages of the students of eachgroup using a formula that can be copied flawlessly.9. In range T30:T33 calculate the group averages based on the subject averages.10.Format the cells of rangeB28:T33 according to the example. Display the averages of the

marks with an accuracy of two decimal digits. Upon setting the column widths and row

heights pay attention to every data being fully visible. The width of columns F:Tshould

be the same. The width of columnsB:Eshould be (approximately) twice as much. Use a

double-line border around rangesB28:T28 andB30:T33.


11/16



11.Create a chart that shows the group averages in the way shown in the example. Set thescale of the value axis according to the example. Set the colours of the columns in

accordance with the names of the groups. The width of the chart should be the same as the

width of the data above it.

30 marks


12/16



4. Traffic restriction

Road management organisations regularly publish the country-wide traffic restriction data.

The following database contains the traffic restriction data of a report in 2010.

1.

Create a new database namedtraffic

. Import the three data tables supplied(restriction.txt, naming.txt and extent.txt) into the database with tablenames that correspond to the file names (restriction, naming, extent). All three files are

UTF-8 encoded text files tagged by tabs, their first lines contain the field names. Add a

unique key named id to table restriction. Upon creation, set the suitable types and mark

the fields that are used as keys.

Table:

restriction (id, roadnumber,frompoint, topoint, settlement, fromdate, todate, namingid,

extentid, speed)

id The identifier of the place of the restriction (autonumber), this is the key

roadnumber The number of the road in the register (integer)frompoint The start of the restriction given as a kilometre (real)

topoint The end of the restriction given as a kilometre (real)

settlement The name of the settlement to which the restricted road section belongs

(text)

fromwhen The starting date of the restriction (date)

towhen The ending date of the restriction (date)

namingid The identifier of the cause of the restriction (number)

extentid The identifier of the extent or the naming of the restriction (number)

speed The speed limit in km/h (number)

naming(id, nev)id The identifier of the cause of the restriction (number), this is the key

nev The name of the cause of the restriction (text)

extent(id, nev)

id The identifier of the extent of the restriction (number), this is the key

nev The name of the extent of the restriction (text)

When solving the following exercises, save the queries and the report with the names given

in brackets. Pay attention to the queries containing exactly the required fields, do not display

unnecessary fields.


13/16



2. Display the place and the time of traffic restrictions at Miskolc using a query. Displayfields roadnumber,frompoint, topoint,fromwhen and towhen. (2miskolc)

3. Display the settlement of each traffic restriction and the number of days affected by therestriction in descending order according to the latter using a query. (3accordingtotime)

4. List the names of the settlements where junction constructions were performed. Displaythe name of each settlement only once in the list. (4junction)5. In the numbering of the road network lower-level roads are indicated by four-digit

numbers. Create a query that gives the number of restrictions where the road number has

four digits. (5four)

6. Create a query that gives the average length of the road sections affected by the differentextent restrictions. The list should display the name of the extent and the average length,

but the ones with complete closure should be omitted. (6average)

7. Create a report that contains the settlements of the traffic restrictions, the names of therestrictions and their starting and ending dates grouped according to road number and

within that according to the names of the settlements. You can create a query for thesolution of the exercise if required. Pay attention to the values being visible in each

column of the created report. (7roadreport)

20 marks


14/16



Sources:

1. Quick report

http://portal.ksh.hu/pls/ksh/docs/hun/xftp/gyor/tav/tav20912.pdf

2. Lszl Br

http://baloghpet.wordpress.com/2009/09/29/a-golyostoll-biro-laszlo-ujsagiro-feltalalo/

http://www.mypensnthings.com/pentypes.htm

4. Traffic restriction

http://internet.kozut.hu/kozlekedoknek/Lapok/default.aspx


15/16




16/16



maximum

mark

achieved

mark

Word processing1. Quick report

40

Presentation, graphics, web page

creation

2. Lszl Br30

Spreadsheet processing

3. College30

Database management

4. Traffic restriction20

Mark of the practical exam part 120

examiner

Date: .................................................

__________________________________________________________________________

elrt pontszm

egsz szmra kerektve/achieved mark rounded

to an integer

programba bert

egsz pontszm/mark written into

program as an integerSzvegszerkeszts/

Word processing

Prezentci, grafika s

weblapkszts/

Presentation, graphics and web

page creation

Tblzatkezels/Spreadsheet processing

Adatbzis-kezels/

Database management/

javt tanr / examiner jegyz / registrar

Dtum / Date: ............................................. Dtum / Date: .................................................

Inf Erettzségi Hun

Documents

Transcript of Inf Erettzségi Hun