Computer Applications Olympiad Second Round Questions Paper 2017

Name of the Organization : Computer Olympiad South Africa
Examination Name : Applications Olympiad Exam
Announcement : Applications Olympiad School Second Round Questions
Year : 2017
Type : Past Papers
Website : http://olympiad.org.za/applications-olympiad/past-papers/school-rounds/
AO School Round 2 : https://www.southafricain.com/uploads/10038-AORound-2.pdf
AO R2 Solutions : https://www.southafricain.com/uploads/10038-AORound2Sol.pdf

Applications Olympiad Second Round Questions Paper

** Download 2017 School Round 1 Applications Olympiad Questions AO School Round 1 Question paper from the above pdf Links

Related / Similar Question Paper :
Computer Programming Olympiad Round 2 Question Paper 2017

** Not to be used before 8 May 2017

Instructions To The Candidates

1. All answers must be typed or pasted in the document AnswerSheet.
2. You may do the questions in any order, but you have to make sure the answers are placed correctly on the answer sheet. Save the answer sheet as instructed by your teacher.

3. The files you need to answer the questions have been provided to your school. Ask your teacher/invigilator where to find them.
4. The paper must be completed under “examination conditions”. No communication (oral, electronic or any other form) with other contestants is permitted.

5. You may use the application of your choice and, if necessary, convert the data as it suits you.
6. You have one hour (60 min.) to complete this paper. After one hour you may be given time to print your answer sheet, but no additions or alterations to the answers or files will be allowed.

7. All marking is done from hard copy, i.e. from the printed answer sheet.
8. Each correct answer counts four (4) marks.

9. You need to store your files where you found them and where your teacher can access them in case the judges want to see how you obtained the answer. Do not delete any of the files. Do not attempt to modify any files after the end of the contest.
10. For all questions, if the answer is a number just give the number without any units.

Section A

A. Word Processing :
Over the years, there have been numerous studies to show how playing different types of background music can influence shopping behaviour. Everything from music volume to tempo can all play a part in how consumers spend money and behave in shops. The document file Music in Retail Stores discusses some of the issues that owners need to consider. Use word processing features to answer the following questions. For all questions, if the answer is a number just give the number without any units.

A1. Style :
Use the document-file Music in Retail Stores and word processing features to answer the question.
A1. What percentage style shading is used in the top row of the table? Give the number only e.g. 17 or 93

A2. Height :
Use the document-file Music in Retail Stores and word processing features to answer the question.
A2. What is the exact height (in cm) of the image near the heading ‘Four key elements of effective retail music’? Give the number only e.g. 27

A3. Line Number :
Use the document-file Music in Retail Stores and word processing features to answer the question.
A3.What word is at the beginning of the 50th line of the whole document? Give the word exactly as it is in the text. You may copy and paste e.g. Music

Section B

Spreadsheet :
Note :
Sections B and C use very similar data but some of the fields and data are different. All answers to Section B must come from the HotHits sheet of the Excel spreadsheet file.

The Billboard Hot 100 is a chart that ranks the best-performing songs of the United States in any given year. Its data, published by Billboard magazine and compiled by Nielsen SoundScan, is based collectively on each song’s weekly physical and digital sales, as well as airplay and streaming.

The spreadsheet file BBHot100HitsR2 contains information on the songs which made it into the Billboard Hot 100 hits between 2001 and 2016. For all questions, if the answer is a number just give the number without any units.

B1. No Length :
Use the spreadsheet file BBHot100HitsR2 to answer the question.
B1. How many songs do not have a value for the length of the song? Give the number only e.g. 131

B2. Cat & Dog :
Use the spreadsheet file BBHot100HitsR2 to answer the question.
B2. What is the title of the song which contains both ‘cat’ and ‘dog’ in the name of the artist(s)? Give the title of the song exactly like in the spreadsheet. You may copy and paste.

B3. Lil Wayne :
Use the spreadsheet file BBHot100HitsR2 to answer the question.
B3. How many songs contain ‘Lil Wayne’ in the artist field? Give the number only e.g. 131

B4. Same Number :
Use the spreadsheet file BBHot100HitsR2 to answer the question.
B4. How many songs have the same number for the track and hit number? Give the number of songs only e.g. 131

B5. Record Date :
Use the spreadsheet file BBHot100HitsR2 to answer the question.
B5. On which date ( ddmm) were the most Billboard Hot 100 hits played? If more than one date, give the most recent date. Give the date in the exact format specified e.g. 3 August would be 0308

B6. Hash :
Use the spreadsheet file BBHot100HitsR2 to answer the question.

B6. What is the ‘hash’ total for the number 1 song of 2015?
To create a ‘hash’ total, use column I, and add together the following four values:
a) the value in the year field (column B),
b) the value in the no field (column C),
c) the length of the artist field (column D), and
d) the length of the title field (include all characters – a space counts as a character) (column E).
For example the song ‘Most Girls’ by ‘Pink’ which was number 97 in 2001 has a hash total of 2112. Do not delete this column (I) or your working in this column. Give the number only e.g. 2112

Section C

Database :
Note :
Sections B and C use very similar data but some of the fields and data are different. All answers to Section C must come from the Access database file.

The Billboard Hot 100 is a chart that ranks the best-performing songs of the United States in any given year. Its data, published by Billboard magazine and compiled by Nielsen SoundScan, is based collectively on each song’s weekly physical and digital sales, as well as airplay and streaming.

The database Hot100R2 contains some details of all the songs for the period 2001-2012. In the questions below a ‘solo performing artist’ is an artist who performs by themselves and so only their name appears in the database as the artist.

C1. Released :
Use the database file Hot100R2 to answer the question.
C1. How many songs in the database were first released in 2000? Give the number only e.g. 131

C2. Pop songs :
Use the database file Hot100R2 to answer the question.
C2. How many songs categorised as ‘pop’ songs appear in the database? Give the number only e.g. 131

C3. Alicia Keys :
Use the database file Hot100R2 to answer the question.
C3. In which year did Alicia Keys appear three times as a solo performing artist? Give the year only e.g. 2017

C4. Same Name :
Use the database file Hot100R2 to answer the question.
C4. How many songs have the same name as the album on which they appear and are the first track on the album? Give the number only e.g. 131

C5. Taylor Swift :
Use the database file Hot100R2 to answer the question.
C5. In how many of the country music songs that reached the Billboard Hot 100 in 2008 did Taylor Swift appear? Give the number only e.g. 131

Section D

WebQuest :
D1. Play :
A famous poet and playwright wrote the words “If music be the food of love, play on.” Use the web to find the answer to the question.
D1. What is the name of the play from which the quote is taken? Give the answer exactly as it appears on the web e.g. King Lear. You may copy and paste.

D2. How old? :
A famous poet and playwright wrote the words “If music be the food of love, play on.” Use the web and arithmetic to find the answer to the question.
D2. If this playwright were still alive today (7 June 2017), how old, in completed years, would he be? Give the number only e.g. 131

D3. Mother :
A famous poet and playwright wrote the words “If music be the food of love, play on.” Use the web to find the answer to the question.
D3. What was the first name of his mother? Give the first name exactly as you find it on the web e.g. Susan. You may copy and paste.

D4. Children :
A famous poet and playwright wrote the words “If music be the food of love, play on.” Use the web to find the answer to the question.
D4. To how many children did his wife give birth? Give the number only e.g. 131