Domain 1 Tech Apps

In Excel, which of the following describes the IF function

• Gives you the average of the data

• Counts all cells in a given range regardless of type

• Makes sure your functions do not return errors due to unruly spaces

• Often used when you want to sort your data according to a given logic

Which accommodation would be most helpful for a ELL student presenting a PowerPoint to the class?

• Google Translate

• Video tutorials on how to use PowerPoint

• Allow them to use a microphone to voice over the PowerPoint and play for their presentation

• Use a Spanish/English dictionary

If the probability of a cholesterol test giving accurate test results in 99%, which outcome is MOST likely to occur?

• 100 out of 100 receive results

• 99 out of 100 receive results

• 98 out of 100 receive results

• 97 out of 100 receive results

A teacher wants students to learn how technology can assist them in analyzing scientific data. He decided to teach students how to input data in a spreadsheet and create a chart. Which of the following would NOT be a key vocab term, associated particularly with spreadsheets.

• cell

• column

• slide

• row

Which software application is appropriate for creating graphs from data?

• PowerPoint

• Publisher

• Excel

• Word

Which statement is true about Boolean search terms?

• Including the word "and" with two search terms will narrow the search results

• Including the word "and" with two search terms will broaden the search results

• Including the word "always" with two search terms will improve the search results

• Including the word "or " has the same result as including the word "not".

A teacher uses Google Classroom and all her students have Gmail accounts. Which of the Google software tools would be MOST appropriate, effective and efficient for the teach to use to create online quizzes?

• Google Docs

• Google Drive

• Google Sites

• Google Forms

A science and technology teacher are partnering together for some force and motion lessons. Resources are slim, they do not have access to very many lab materials/equipment. Which of the following technologies would BEST assit them in accomplishing this goal?

• Virtual lab simulations

• Virtual tour of a construction site

• Probeware

• Videos of force and motion demonstrations.

This image indicates which of the following Creative Commons License?

• Lets you use, distribute, remix, tweak and even build upon the work, even commercially, as long as you give credit to the original creation.

• Lets you remix tweak, build upon the work, even commercially, as long as you give credit to the to the original creation under the same terms.

• Lets you remix, tweak, build upon the work non-commercially if you give credit to the original creation and any of your new work created with the original.

• Allows you to donwload and share the work as long as you give credit to the original work. The work cannot be changed in any way or used commercially.

Which of the following scenarios describes an ethical acquisition and acceptable use of multimedia?

• Sampling drum hits from a record to use in an original musical production

• Creating a file-sharing service for movies that have been copied from purchased DVD's

• Posting a video online that uses a current hit song for background music

• Using highlights from a televised athletic event to sell sportswear