WorksheetsSTEM
Total questions: 67
Worksheet time: 1hrs 24mins
finds causes of problems, And Fixes Broken Computer Hardware?
An Applications Programmer is also referred to as a:
Computer Programmer.
Software Engineer.
Both Computer Programmer AND Software Engineer.
Game engine programming involves:
developing the computer engines that run simulated cars, planes, and boats.
creating the programming modules that control computer players.
developing the engines that the game player will use in the game.
creating the base engine of the game, including the simulated physics and graphics.
The Lead Programmer:
writes the code for the program.
organizes, schedules, and reviews the work of other programmers.
leads the programming team in developing the game.
Leads the songs and dance routines at the game launch party.
A Video Game Designer:
creates the concept of the video game.
creates the characters, levels, and rules of the game.
writes code and acts as a project manager for the development of the game.
The duty of the Game Designer is to:
design the images and colors used in the game.
work with the end users or players of the game.
design the game manual.
ensure that the entire development team understands the concept of the game.
The operating system is
the hardware that operates the computer.
the set of computer instructions that tell the computer how to work.
the system that operates the user interface.
the system that repairs software problems.
What coding language does Amazon CoderZ use?
SQL
C++
Block
Java
What does the M in S.T.E.M. stand for?
Medicine
Mathematics
Machine
Money
What block uses the Touch sensor?
Wait until luminity
Wait until gyroscope
Wait until ultrasonic
Wait until touch
Computers have become an essential part of how the world does business.
True
False
Which of the following will NOT become the future of information technology?
Artificial Intelligence
Robotics
3D Printing
Abacus
Which of the following are advantages of having a STEM career?
the potential for earning high wages
working in an innovative industry
highly valued benefits
all of the above
What are some of the skills that are common in the field of STEM?
problem solving
critical thinking
communication
all of the above
Which of the following is a four year degree?
Associate Degree
Bachelor's Degree
Master's Degree
Professional Degree
Which of the following is a two year degree?
Associate Degree
Bachelor's Degree
Master's Degree
Professional Degree
What do you call a piece of code that repeats itself, so that the same piece of code does not have to be entered multiple times?
Hercules
Loops
Block
Movement
What do you call a list of steps that are followed to complete a task?
Debug
Direction
Algorithm
Value Block
What do you call the repetition of a process in order to generate a sequence of outcomes?
Command
Variable
List
Iteration
Who creates code and scripts, then modifies and tests the code to ensure the program are able to run?
Network Administrator
Computer Programmer
Information Security Analyst
Business Systems Analyst
Who checks for vulnerabilities in computer and network systems?
Business Operations Manager
Digital Designer
Cyber Security Analyst
Surgeon
What is the median salary for a Computer Systems Analyst?
$99,270
$29,990
$27,009
$50,970
Backing up - data can be backed up to the cloud automatically
Advantage
Disadvantage
Compatibility - documents and files on the cloud are designed to work across different browsers
Advantage
Disadvantage
Cost - many cloud systems are free
Advantage
Disadvantage
Independence - users can access and work on their files from different computers
Advantage
Disadvantage
Software updates - cloud software and browsers are updated online, meaning the user does not need to download latest updates
Advantage
Disadvantage
Connection - users can only access their data if they have an internet connection
Advantage
Disadvantage
Copyright - the user may lose the legal rights to their original material if it stored online.
Who owns the copyright of content on apps like Instagram and TikTok?
Advantage
Disadvantage
Security - data stored online may be vulnerable to security attacks
Advantage
Disadvantage
Software - Web apps (like Google Slides) usually have less functions compared to a full software package (PowerPoint)
Advantage
Disadvantage
Storage - Although cloud providers let you store for free, this is a relatively low amount of storage. To increase this you have to pay monthly or annual fees.
Advantage
Disadvantage
What is cloud computing?
Cloud computing means that your computer is stored remotely
Cloud computing is the provision of computing services over the internet. These services are accessed by the user locally on the hard drive of the user's computer
Cloud computing is the provision of computing services over the internet. The data and applications provided are accessed by the user remotely from the host company's servers.
Cloud computing is the provision of computing services over the internet. The data is stored remotely on the network of the user.
Cloud storage can be provided as a service by allowing your data to be stored...
remotely on the host company's servers
remotely on your local computer
locally on your network
locally on your remote computer
A cloud computing company (for example AWS and Microsoft Azure) usually provides...
Storage as a service
Software as a service
Infrastructure and processing as a service
Storage, software, processing and infrastructure as a service
Cloud computing services such as storage and software...
Can be accessed on any device
Are always free
Can be accessed by any device that is connected to a LAN
Can be accessed on any device that is connected to the internet
An advantage of cloud software is that...
It is always free
It cannot be hacked
It is updated automatically
It is only ever stored locally on your computer
A disadvantage of cloud storage is that..
Your data will always be hacked because your data can be accessed from any device with an internet connection
Your data is vulnerable to hacking because your data can be accessed from any device with an internet connection
Your data can easily be hacked because there is no system security provided by the host
Your data is vulnerable to hacking because it is stored locally on your computer
An advantage of cloud storage is...
It is easy to increase the amount of storage available
It is always free to increase the amount of storage available
An internet connection is not needed to access your data
An internet connection is needed to access your data
Cloud processing could be used as a service if...
You need more storage space
You need more hardware
You need to run complicated programs with many complex mathematical calculations
You want to stop hackers
An advantage of cloud storage is...
It is not possible for hackers to breach the host's security
Backups are stored locally on your computer
Security is managed by your own IT staff
Security and backups are managed by the host company
A disadvantage of cloud computing is...
You need an internet connection to access the data or software
You need an internet connection to access your LAN
You cannot use a device that is connected to the internet
You need local storage to manage the data backups
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
An Excel file format extension is
doc
xls
txt
mp3
The numbers in Excel represent the...
Rows
Columns
Cells
Data
When creating a chart in Excel, what is the first thing you need to do?
Select the data to be graphed.
Select the Insert Tab
Choose a chart from the ribbon
Double click the active cell
To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.
&
=
#
*
What function adds all of the numbers in a range of cells?
Calculate
Compute
Sum
Max
To sort data in Excel, go to the __________ ribbon.
Home
Data
Insert
View
What does the mouse look like in a spreadsheet?
Arrow
Pointer
Two headed arrow
Selection cross
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
What is this icon?
Sum
AutoSum
Insert Function
Object
What is this icon?
Sum
AutoSum
Insert Function
Object
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
Which of the following methods cannot be used to enter data in a cell
a. Pressing an arrow key
b. Pressing the Tab key
c. Pressing the Esc key
d. Clicking on the formula bar
When a label is too long to fit within a worksheet cell, you typically must
a. Shorten the label
b. Increase the column width
c. Decrease the column width
d. Adjust the row height
In MS-Excel numeric value can be treated as a label value if it precedes with
A. Apostrophe (')
B. Exclamation (!)
C. Hash (#)
D. None of these
What is the shortcut key to hide entire column?
A. CTRL + −
B. CTRL + 0
C. CTRL + H
D. CTRL + C
The advantage of using a spreadsheet is:
A. calculations can be done automatically.
B. changing data automatically updates calculations
C. more flexibility
D. All of the above
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Labels
Row Labels
What is the icon for Microsoft Excel?
