COMPUTER SCIENCE POST TEST
How would you classify these file extensions: .jpg, .gif, .png, .tiff, .bmp A - Document files B - Photo files C - Video files D - Spreadsheet files
B
Identify the task that can be accomplished using operating system software? A - Sound recording B - File management C - Document creation D - Photo editing
B
Knowledge (S7-04) What layout feature is used to display data in organized rows and columns? A - Hyperlink B - Table C - Chart D - Graphic
B
Knowledge (S7-04) What layout feature is used to create a connection between an object and another location? A - Chart B - Hyperlink C - Graphic D - Table
B
Mia is searching for the right company to create custom jerseys for her soccer team. She currently has 15 bids from companies, all with varying prices, that she has organized in a spreadsheet. She needs to quickly determine which company has the lowest bid. What spreadsheet function should she use? A - SUM B - MIN C - MAX D - AVERAGE
B
Why is it important to update your computer's anti-virus software? A - To help with file compression B - To protect against new malware C - To defragment the hard drive D - To configure the computer's settings
B
When comparing items in a sort list or set, what type of search takes the least amount of comparisons?
Binary search
What application is used to navigate the internet?
Browser
Identify the common network jargon for virtual private network. A - WAN B - DNS C - VPN D - LAN
C
In a spreadsheet, what layout feature combines two or more cells? A - Columns B - Formulas C - Merge D - Rows
C
Kim wants to create an interactive ePortfolio of her accomplishments to include with her college application. What type of software should Kim use? A - Spreadsheet B - Word processor C - Presentation D - Database
C
What is a computational thinker? A - A person who thinks like a computer B - A person who can make connections between computer hardware and software C - A person whose thought processes involve formulating a problem and expressing its solution(s). D - A person who uses a computer to think
C
What method of digital communication allows a person to see the facial expressions of the person they are communicating with? A - Email B - Texting C - Video Conference D - Instant Messaging
C
Which scenario is an internet security concern? A - A chat window pops up from customer service when you are shopping online B - An email from Facebook saying that your post has been liked C - A pop-up saying you have a virus and need to download a program to fix it D - A message from your computer saying that your software is out of date
C
Riley has been instructed to work on a document with a classmate. She decides to use her Google Apps account to share a document with her partner, Colton. This is an example of which collaborative tool?
Cloud
Based on the scenarios below, when should the document navigation command "Save As" be used?
Elizabeth needs to hand-in two versions of a document. One is a rough draft and the other is her final research project.
Which task can be accomplished by a computer?
Sorting
Daniel needs to create a visual chart for his science class based upon the results of his science experiment. What type of software should Daniel use?
Spreadsheet
Natalie needs to search and analyze the data she collected from her survey for her marketing class. What type of software should Natalie use?
Spreadsheet
What are the place values in a binary number system?
128, 64, 32, 16, 8, 4, 2, 1
What software allows the hardware to interact with the applications?
The operating system software
Critically evaluating a web page for authority means looking for
The qualifications of the author
Identify the correct sequence for the order of operations in spreadsheet formulas? A - (), ^, *, /, +, - B - *, /, +, -, (), ^ C - ^, *. /, +, -, () D - +, -, * , / , " , ()
A
Identify the largest form of computer storage. A - megabyte B - byte C - bit D - kilobyte
A
Josephine just turned on her computer and found out that all of her files are corrupted and she has lost her work. What approach should she have used to ensure that her files remained accessible? A - Backing up files to an external source B - Taking pictures of the completed documents off the screen with a smartphone C - Printing documents as soon as they are complete D - Saving frequently to the computer
A
To alphabetize a set of data without having to re-type it, what spreadsheet feature should you use? A - Sort B - Merge C - Cut & Paste D - Protect
A
What is 22 in binary? A - 00010110 B - 00001111 C - 01100110 D - 10101010
A
When buying a computer, what essential hardware component is necessary for standard computer operation? A - Processor B - Operating System C - Speaker D - External Hard Drive
A
What is the key to interpretation and pattern recognition in computer science?
Analyzing data sets
What is the shortcut keystroke for print?
CTRL+P
What is the shortcut keystroke for cut?
CTRL+X
What is a common type of intellectual property?
Copyright
Which tool allows you to remove part of a picture?
Crop
Drew's teacher sent him an email about his grade. Drew doesn't know when opening the email message that his teacher also sent the same email to his school counselor. Which email option was used by his teacher? A - Subject Line B - CC (Carbon Copy) C - Forward (New Recipient) D - BCC (Blind Carbon Copy)
D
Identify the operating system software. A - Microsoft Word, PowerPoint, Excel B - Google Chrome, Firefox, Internet Explorer C - Adobe PhotoShop, lnDesign, Illustrator D - Mac OSX, Unix, Linux, Windows 8
D
In a spreadsheet, what layout feature labels data using letters? (Examples: A, AB, MC, etc.) A - Merge B - Rows C - Formulas D - Columns
D
In your home, you have 3 tablets, 4 smartphones, 2 laptops, and 1 desktop. All of these devices can connect to the same small home network. Infer what will happen to the bandwidth when all of the devices are connected. A - Wired devices will not be able to connect B - Speed of the internet will improve C - Wireless devices will not be able to connect D - Speed of the internet will decrease
D
Javier is in ECS class and his computer monitor just went black. How should Javier begin to troubleshoot what is wrong with his monitor? A - Restart the computer B - Buy a new VGA cord C - Replace the computer's video card D - Check the monitor's power cord
D
Nina is creating a presentation for her ECS class. She wants a shape on her slide to "fly in" and then "grow and shrink". What presentation feature should she use to accomplish this task? A - Layout B - Transitions C - Timing D - Animation
D
Ricardo is creating a presentation for his ECS class. He needs to be able to show his presentation and have the slides advance automatically. What presentation feature should he use to accomplish this task? A - ransitions B - Animation C - Layout D - Timing
D
Which part of the problem-solving process includes analyzing the results of your algorithm? A - Carry out the plan B - Make a plan to solve the problem C - Understand the problem D - Review and reflect
D
Locating and correcting errors in a computer program is part of which process?
Designing algorithms
Jordan is instructed to change the font on his document to "Calibri", Bold, Size 12. What are these actions known as?
Formatting
Intelligent machine behavior is based on
Hardware
In a word processor, what layout feature should you use to add a title and a page number to the top every page?
Header/Footer
I am going to share software that I have created, and I do not care about copyrighting my work. How would this software be classified?
Open Source
The globalization of technology has affected human culture
Positively and Negatively
When citing an online source, you should include
The date you accessed the source
Adam creates a maze that uses 10 coding blocks in Scratch. Joan creates a maze that looks exactly the same, but she uses 14 coding blocks. Infer which basic computer science concept this example displays.
There are multiple solutions to the same problem
In a word processor, what layout feature should you use to move a picture to a desired location on the page?
Wrap Text
