Computer Basics 1
Computer Basics 2
Google Docs and Forms
Google Sheets
Google Slides, Gmail, and Social Media
100

What does RAM stand for?

Random Access Memory

100

What is a domain name and why do we use them?

Domain name example: google.com

Represents an IP address to access a website or communicate with a server more easily.

100

On Google Forms I want a question that has people enter their emails. What question type should I use and are there any response validations I should add?

Short answer and text response validation, "must have @" or "must be a valid email"

100

When should you use a pie chart? Give an example

When you want to compare parts of a whole, for example if we shared a pizza and wanted to compare how much each person ate

100

Which of the following is false:

1. Don’t add irrelevant information or images

2. Don’t add too much information / words

3. Have a good color scheme

4. Start a PPT by going to Slide Carnival

4. Start making a PPT by creating a plan on paper or  a whiteboard

200

Which of the following can NOT output audio? (Multiple answers possible)

HDMI, DVI, Displayport, 3.5mm Jack, USB

DVI

200

Tell me 2 differences between SSDs and HDDs

SSDs are more expensive, faster, and have no moving parts.

200

Title not a different size, page number should include last name, date and course name switched

200

What are the 4 data types we learned about in Google Sheets?

String, Array, Boolean, Number

200

What's the difference between Templates and Themes?

AND

What function is used to make a text box and a square combine into one object?

Templates: Premade slides by Google

Themes: A set of layouts that use the same color scheme and background

Group

300

Name 4 different top level domains and what they are used for

.edu (Education)

.net (Network)

.com (Commercial)

.org (Organization)

.gov (Government)

.mil (Military)

300

Which of the following would not be a part of a LAN in a home? (Modem, Server, Router, Ethernet Cable)

Server

300

What are styles? Explain their purpose.

To customize the font and size of the text styles and set your styles as defaults.

300

Let's say that I have a list of full names in one column (Ex: Daniel Kim). Tell me the steps I need to take to to sort the list by last name.

1. Split text into columns

2. Set a filter on BOTH columns

3. Sort them A-Z using the second column

300

What are the four components of an email?

Subject Line: A short summary of an email, relays important information

Salutation: Greeting your recipient

Content: Intro, Middle, Conclusion

Signature: Your sign off

400

Tell me the different parts of the following URL (File Name, Path, Protocol, SLD, TLD). Do not use acronyms and tell me what kind of protocol this is:

https://jeopardylabs.com/edit2/12157149.png

https:// = Protocol (Secure)

jeopardylabs = SLD (Second Level Domain)

com = TLD (Top Level Domain)

edit2/12157149.png = Path

12157149.png = File Name

400

Name all 7 main hardware components of a computer that are on the study guide.

CPU, RAM, Motherboard, Graphics Card, Secondary Storage, PSU, Peripherals 

400

What are four things you can change in Page Setup? 

Hints: 

>^ = O_________

[] = M______

rgb = C______

8.5x11 = S____

Orientation, Margins, Color, Size

400

What does the following output?

=INDEX(D2:D8, MATCH(H2, C2:C8, 0)) 

https://docs.google.com/spreadsheets/d/1AxlbY0dzrb27MvQyPPGs288Q7UfliYZM0N4eEvkJlHQ/edit#gid=0

39

400

How do I use speaker notes during a presentation?

Connect to the projector or TV and extend your screen. After clicking "Present", go to "Notes" in the bottom left hand corner. Move your PPT to the projector while keeping the speaker notes on your computer.

500

What are four main properties of a CPU? Do not use acronyms

Cores, IPC (Instructions per Cycle), Cache, Clock Speed

500

What does OS stand for? What does an OS do? Give 2 examples

OS = Operating System 

Manages the computer's resources, establish a user interface, execute and provide services for applications software.

Android, iOS, Windows, macOS, Linux

500

What are the 6 question types on the study guide for Google Forms? Then, give me example questions for each.

Short Answer: When's your birthday?

Paragraph: Tell me about a birthday you had

Multiple Choice: What kind of cake do you like?

Checkboxes: What presents do you want?

Dropdown: Choose your country of residence.

Linear Scale: How did you like the party?

500

Create a pivot table that shows how many binders sales Gill made in the west region

See sheet

500

VOCAB

Directing audience attention = ?

Where to go to create custom layouts = ?

The video plays on its own once you get to the slide = ?

Postpone emails and temporarily remove them from your inbox until you need them = ?

Callouts

Slide Master

Autoplay

Snooze Email

M
e
n
u