How many QCAA Digital Solutions questions cover Real-world problems and solution requirements?

AusGrader has 18 QCAA Digital Solutions questions on Real-world problems and solution requirements, all with instant AI grading and detailed marking feedback.

QCAA (QCE) Digital Solutions — Real-world problems and solution requirements Questions & Answers | AusGrader

Q7

2020

QCAA

1 mark

Q7

1 mark

An application accesses an API that obtains data relating to books read by users. The data that needs to be stored locally includes:

• one or more images of each book’s cover

• book recommendation notes

• a comment on each book.

Book data is located using the ISBN — a unique identifier for each published book. When searching for a book, the returned JSON data is outputted:

{
 "volumeInfo":{
 "title": "Designing Relational Databases",
 "subtitle": "A beginner’s guide",
 "authors": [
 "Joan Janson",
 "Katy Pratt"
 ],
 "isbn": "1440569239562",
 "publisher": "Books Ltd",
 "publishedDate": "2016-05",
 "pageCount": 367,
 "imageLinks": {
 "smallThumbnail": "http://books.abcd.com/books?id=jedfoYprny465&image=1&source=gbs _ api",
 "thumbnail": "http://books.abcd.com/books?id=jedfoYprny465&image=3&source=gbs _ api"
 }
 }
}

What is the most appropriate method to store the data in local tables so it can be easily retrieved for display?

A

Table: book

Field	Type
ISBN	Text
title	Text
pages	Integer
authors	Text
comments	Text
recommendation	Boolean

Table: images

Field	Type
type	Text
image_link	Jpg
ISBN	Integer

B

Table: books

Field	Type
ISBN	Text
title	Text
pages	Integer
comments	Text
recommendation	Text
image_link	Text

Table: authors

Field	Type
ISBN	Text
name	Text

C

Table: book

Field	Type
ISBN	Integer
title	Text
pages	Integer
comments	Text
recommendation	Boolean

Table: images

Field	Type
ISBN	Integer
image_type	Text
image_link	Text

Table: authors

Field	Type
ISBN	Integer
name	Text

D

Table: books

Field	Type
ISBN	Integer
title	Text
pages	Text
comments	Text
recommendation	Text
publisher	Text
published_date	Text

Table: authors

Field	Type
title	Text
name	Text

Table: images

Field	Type
ISBN	Integer
image_link	Text

Q9

2022

QCAA

1 mark

Q9

1 mark

Which algorithmic statement determines the value of y between 10 and 50 inclusive?

A

IF 10 > y OR y > 50

B

IF 10 > y AND y < 50

C

IF y >= 10 OR y <= 50

D

IF y >= 10 AND y <= 50

Q12

2022

QCAA

8 marks

Q12

Refer to Stimulus 1 in the stimulus book.

Q12a

6 marks

Describe the listed algorithm constructs and identify one example of each from the stimulus. Use corresponding line numbers to identify examples.

Assignment:

Example:

Condition:

Example:

Iteration:

Example:

Assignment: A value (stated or calculated) stored in a variable/memory location.
Example: Line 13, value = 0.04.

Condition: A comparison that retrieves a true or false value (or the value of a Boolean variable).
Example: Line 12, IF depositAmount <= 10000.

Iteration: A group of algorithmic statements that are repeated while a condition is met.
Example: Lines 25–27

FOR i = 0 TO years
deposit = depositAmount + depositAmount x interestRate
NEXT i

Marking Criteria

Descriptor	Marks
Describes assignment	1
Describes iteration	1
Describes condition	1
Identifies an example of assignment	1
Identifies an example of condition	1
Identifies an example of iteration	1

Q12b

2 marks

Explain the purpose of modularisation and identify an example of how it is used in the stimulus. Use corresponding line numbers in your response.

Modularisation breaks sections of code into smaller chunks so the algorithm is easier to understand, and allows the same code to be used in different parts of the application. For example, calculateInterestRate is a separate module (lines 11–22) and is called/used at line 5. It returns a value (line 21) which is stored in interestRate (line 5).

Marking Criteria

Descriptor	Marks
Explains the purpose of modularisation	1
Identifies an example of how modularisation is used	1

Q12

2024

QCAA

8 marks

Q12

8 marks

An esports club records player details and results for playing a popular online game. The data is stored in JSON format. The club wants to display the gamer tag of each player, their age and the percentage of games won. A sample of the JSON data is shown.

{
'players': [
 {
 'name': 'Brandon Rioli',
 'gamerTag': 'Madskills',
 'dateOfBirth': '22/12/2007',
 'gamesPlayed': 10,
 'gamesWon': 4
 },
 {
 'name': 'Chloe Pezer',
 'gamerTag': 'PezerGirl',
 'dateOfBirth': '03/04/2007',
 'gamesPlayed': 58,
 'gamesWon': 55
 }
 ]
}

Use pseudocode to symbolise the algorithmic statements needed to display the required data.

BEGIN
    GET currentDay
    GET currentMonth
    GET currentYear
    SET playerArray = []
    READ json file into playerArray
    FOR count = 0 to playerArray.length
        DISPLAY playerArray[count].gamerTag
        SPLIT playerArray[count].dateOfBirth into birthday, birthMonth, birthYear
        SET age to currentYear - birthYear
        IF currentMonth < birthMonth THEN
            age = age - 1
        ELSE IF currentMonth = birthMonth THEN
            IF currentDay < birthDay THEN
                age = age - 1
            ENDIF
        ENDIF
        DISPLAY age
        CALCULATE percentWon = playerArray[count].gamesWon / playerArray[count].gamesPlayed * 100
        DISPLAY percentWon
    NEXT count
END

Marking Criteria

Descriptor	Marks
Symbolises, without logic errors, algorithmic statements for retrieving JSON data	1
Symbolises, without logic errors, algorithmic statements for looping through data	1
Symbolises, without logic errors, algorithmic statements for calculating age	1
Symbolises, without logic errors, algorithmic statements for calculating percentage won	1
Symbolises, without logic errors, algorithmic statements for displaying gamer tag	1
Symbolises, without logic errors, algorithmic statements for displaying age	1
Symbolises, without logic errors, algorithmic statements for displaying percentage won	1
Effectively uses pseudocode conventions	1

Q13

2020

QCAA

12 marks

Q13

A games arcade has developed a digital solution for recording members’ points. Members receive a membership card, which they scan when they play games at the arcade. The card records how many points a member receives from winning a game. A sample of the data is shown.

members

id	given_name	last_name	email	phone
24	Adalai	Akkad	adacutiepie@email.com	0491 570 006
25	Michael	McNealy	mikemcnealy@email.com	0491 571 266
26	Shruti	Flynn	shrutikins@email.com	0491 574 118
27	Adam	Steinberg	steintheman@email.com	0491 577 644
28	Julia	Wong	juliawong@email.com	0491 579 455

members_activity

id	card_number	join_date	last_visit	points_balance
24	789987	2005-08-12	2020-01-20	570
25	456654	2009-02-15	2019-12-20	80
26	753951	2010-05-05	2020-02-25	249
27	654123	2019-10-19	2020-03-10	1200

Q13a

4 marks

Develop an algorithm to list all members by name. Sort the list alphabetically by last name.

BEGIN
    DECLARE string memberNames = {last_name, given_name}
    ORDER BY last_name
    OUTPUT memberNames
END

Marking Criteria

Descriptor	Marks
solves the problem without errors	4
could have solved the problem except for 1 logic error OR could have solved the problem except for syntax errors	3
could have solved the problem except for 2 logic errors OR could have solved the problem except for 1 logic error and syntax errors	2
could have solved the problem except for 3 logic errors OR could have solved the problem except for 2 logic errors and syntax errors	1
does not satisfy any of the descriptors above.	0

Q13b

4 marks

Develop an algorithm to list member IDs and join dates for memberships of 10 or more years. Sort the list by join date in ascending order.

Response based on C#:

BEGIN
    DECLARE DateTime currentDate
    DECLARE DateTime joinDate
    DECLARE int memberId
    DECLARE int membershipYears = currentDate - joinDate
    FOR EACH int in memberId
        IF membershipYears >= 10years
            ORDER BY joinDate
            OUTPUT joinDate, memberId
        ENDIF
    ENDFOR
END

Marking Criteria

Descriptor	Marks
Solves the problem without errors	4
Could have solved the problem except for 1 logic error OR could have solved the problem except for syntax errors	3
Could have solved the problem except for 2 logic errors OR could have solved the problem except for 1 logic error and syntax errors	2
Could have solved the problem except for 3 logic errors OR could have solved the problem except for 2 logic errors and syntax errors	1
Does not satisfy any of the descriptors above.	0

Q13c

4 marks

Develop an algorithm to provide the contact details for members who currently have more than 3000 points.

BEGIN
    DECLARE string memberDetails = {given_name, last_name, email}
    DECLARE string memberPhone
    DECLARE int pointsBalance
    FOR EACH int in pointsBalance
        IF pointsBalance > 3000
        OUPUT memberDetails, memberPhone
        ENDIF
    ENDFOR
END

Marking Criteria

Descriptor	Marks
solves the problem without errors	4
could have solved the problem except for 1 logic error OR could have solved the problem except for syntax errors	3
could have solved the problem except for 2 logic errors OR could have solved the problem except for 1 logic error and syntax errors	2
could have solved the problem except for 3 logic errors OR could have solved the problem except for 2 logic errors and syntax errors	1
does not satisfy any of the descriptors above.	0

QCAA Digital Solutions Real-world problems and solution requirements

Frequently Asked Questions

Ready to practise QCAA Digital Solutions?