stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Level 10 Revision 3 Flashcards | StudBud
Explore
/
Level 10 Revision 3
Level 10 Revision 3
30 terms
·
StudBud Administration
·
108 plays
Imported from external platform
Flashcards
30 cards
F
Practice quiz
P
Host live
L
Questions
30
Answers
1
What ethical dilemma does the development of highly realistic androids most directly create?
Energy consumption concerns
Questions about android rights and human-machine boundaries
Unemployment in manufacturing sectors
Data storage requirements
2
When designing a flowchart for a complex robotic task, which element would be MOST important to include?
Colorful design elements
Company logo
Technical specifications
Clear decision points with conditional logic
3
Which Internet of Things configuration presents the most complex security concerns?
A smart lighting system
Multiple interconnected home devices linked to personal financial accounts
A standalone smart speaker
A single smart thermostat
4
What formula adds up values in column B only when the value in column A is greater than a certain number?
=SUM(B1:B100)
=SUMIF(A:A,">50",B:B)
=SUM(B:B)
=AVERAGE(B:B)
5
Which spreadsheet operator has the highest precedence in the formula =A1+B2*C3^D4?
All have equal precedence
Addition (+)
Multiplication (*)
Exponentiation (^)
6
In computational thinking, what is the most appropriate approach for solving a complex recycling sorting problem?
Trial and error until finding a solution
Breaking down the problem into smaller steps with decomposition
Applying the same solution used for a different problem
Trying every possible solution randomly
7
To decrease decimal places while keeping the cell formatted as a number, which button would you use?
Decrease Decimal
Align Right
Number Format
Decrease Indent
8
In information censorship, which method represents the most sophisticated approach?
Selective filtering of specific content
Complete blocking of websites
Internet shutdowns during protests
Internet shutdowns during protests
9
When considering robotic ethics, which principle is most fundamental?
Mimicking human behaviour
Preventing harm to humans
Minimizing production costs
Maximizing efficiency
10
Which formula would calculate the variance between the highest and lowest prices across 3 shops for a product in row 4?
=AVERAGE(B4:D4)
=SUM(B4:D4)/3
=MAX(B4:D4)-MIN(B4:D4)
=B4+C4+D4
11
In a spreadsheet, how do you use an absolute reference to apply the tax rate in D1 to amounts in column B?
=B$1*D1
=B1*$D1
=B1*D$1
=B1*$D$1
12
When using absolute references in a complex spreadsheet, which of these is TRUE?
The formula =A$1+$B2 is invalid syntax
=A$1+$B2 keeps row 1 fixed and column B fixed in the 2nd part when copied
=A$1+$B2 will maintain both column A and row 1 when copied anywhere
The formula =A$1+$B2 will only work in the original cell
13
Which scenario presents the most complex ethical AI decision?
Medical AI suggesting treatments with varying risks and benefits
A chess AI selecting the optimal move
A sorting algorithm organizing data
A home assistant deciding what temperature to set
14
Which audio format offers the best balance between high quality and reasonable file size?
MIDI
Uncompressed WAV
MP3 at high bitrate
MP3 at low bitrate
15
Which industry faces the most complex challenges from robotics automation?
Warehouse operations (organized environment)
Factory assembly (repetitive physical work)
Healthcare (involving ethical decisions and human interaction)
Fast food (routine tasks)
16
Which spreadsheet function would you use to find the second highest value in a range of cells?
=RANK(cell,range,1)
=MAX(range)
=MIN(range)
=LARGE(range,2)
17
What is the main ethical concern with robots that can learn and adapt their behaviour?
Manufacturing costs
Potential for unpredicted actions outside their programming
Maintenance requirements
Power consumption
18
Which function checks if A1 meets certain conditions and gives different results based on that?
=SUM
=AVERAGE
=VLOOKUP
=IF
19
For a digital entrepreneur developing a mobile app, which consideration combines both technical and ethical aspects?
User data privacy and security policies
Price point selection
App icon design
App store placement
20
Which scenario represents the MOST complex issue related to the Digital Divide?
Schools having outdated computers
A rural community with slow but functional internet access
Population with physical access to tech, lacking digital literacy skills
Home internet being too expensive for some families
21
What distinguishes ethical AI development from standard AI development?
Creating faster processing capabilities
Using more data for training
Using more advanced algorithms
Prioritizing fairness and transparency in decision-making
22
Which spreadsheet scenario would REQUIRE the use of absolute cell references?
Finding the average of a column
Calculating a running total
Applying a fixed tax rate to different values
Adding values in consecutive cells
23
What would be the result of the formula =AVERAGE(MAX(A1:A5),MIN(B1:B5))?
The average of column A and column B
The average of the largest value in A1:A5 and the smallest value in B1:B5
The average of all values in ranges A1:A5 and B1:B5
An error message
24
In Audacity, what is the primary purpose of metadata in digital audio files?
To enable encryption
To provide descriptive information about the content
To improve sound quality
To compress the file size
25
What is the most significant concern regarding algorithmic bias in facial recognition systems?
Higher battery consumption when analyzing diverse populations
Incompatibility with certain smartphone models
Slower processing times for certain demographics
Disproportionate error rates for underrepresented groups
26
Which of these situations is NOT considered information poverty?
A rural town with inadequate technological infrastructure
A tech advanced area where citizens choose not to use available resources
Community with internet access, content filtered by government censorship
A region where internet is available but unaffordable to most residents
27
Which Audacity process would be most effective for balancing volume levels between two speakers in a podcast?
Noise reduction
Echo effect
Fade in/out
Compression and normalization
28
Which of these statements about Artificial Intelligence is FALSE?
AI is used in multiple industries including healthcare and transportation
AI can be programmed to learn from its mistakes
AI can analyze millions of data points simultaneously
AI always uses common sense reasoning like humans do
29
Which formula would correctly calculate the total cost including 18% VAT from a subtotal in cell B9?
=B9+B9*0.18
=B9*0.18
30
When using noise reduction in Audacity, what must you do first before applying the effect?
Split the track into smaller segments
Apply a fade in effect
Select a sample of only the noise to create a noise profile
Normalize the audio track
