IS 101 Exam #1

File Extensions

(.docx, .xlsx, .pdf, etc.) Every application gives users the ability to save a file with the extension of you choice but only one application can be set as the default application to open each type of extension

Ribbon

-A feature that replaces the traditional file menu -Gives you quick access to the commonly used commands that you need to complete a task home, insert, design, layout

Common CTRL Shortcuts

-Ctrl+C (Copy) -Ctrl+X (Cut) -Ctrl+V(Paste) -Ctrl+Z(Undo) -Ctrl+Home (Beginning) -Ctrl+End (End)

Internet vs The Web

-The Internet is the physical network -The web is a multimedia interface to the resources available on the Internet

How to create a mail merge

1. Document type 2. Starting document 3. Recipients 4. Write the letter 5. Preview the letter 6. Complete the merge

Search Engine Organic Results

Based on unpaid, natural rankings determined by search engine algorithms

Bit

Binary digit (0 or 1)

Alternatives to Wired Connections

Bluetooth, Wi-Fi and NFC (Near Field Communications)

Hierarchy of Data Storage

Byte Kilobyte Megabyte Gigabyte Terabyte Petabyte Exabyte Zetabyte

CPU

Central Processing Unit or processor "Brains" of the computer Processes all commands and instructions Billions of tasks for second

Web Hosting

Companies that rent out their services and technologies to host websites on the internet

Motherboard

Connects all computer hardware such as CPU, RAM, hard drive, graphics card, network card, mouse, keyboard, monitor, printer, etc that allows them all to communicate

Operating System

Coordinates and directs the flow of data and information through the computer system (system software)

DNS Server

Domain Name System A database system that translates an IP address into a domain name. A name given to a host computer on the internet.

Utility Program Examples

File Manager Search Tool Image Viewer Disk Cleanup Disk Defragment Backup Tool Recovery Utility Safe Mode

Hierarchy Directory Structure of Hard Drive

Folders organized like a tree structure The C drive, which is called the 'root' because it is a container that doesn't sit inside any other container

Hard Drive vs Solid State Drive

HD: permanent storage, in the computer SD: No moving parts, No noise, Emits little heat, Requires little power, Less likely to fail

Types of Storage Media

Hard Disk Solid-State Drive USB Flash Drive Memory Card Optical Disc Cloud Storage

Dialog Box Launcher

In some command groups on the Ribbon, a small icon that opens a dialog box related to that group. little arrow at the bottom right of each group

Mail Merge

Insert Merge Fields, then combines content from main document and data source -Letters -Emails -Envelopes -Labels -Directory

IP Address

Internet Protocol A sequence of numbers that uniquely identifies each computer or device connected to the Internet

ISP

Internet service provider is a business that provides individuals and organizations access to the Internet free or for a fee

Alt Menu

Keyboard shortcuts

Input Devices

Keyboard, mouse, microphone built into phone, wireless headset, webcam, touchpad, gamepad, joystick, pedals and wheels, guitar

Data source

List merged with main document

Application Software Example

Microsoft word Microsoft excel Microsoft outlook Microsoft access Adobe photoshop Microsoft powerpoint Internet explorer, chrome, firefox, safari Quickbooks Wordpress, adobe dreamweaver Mcafee, symantec AVG

Themes

Open a template, apply a theme Search for budget workbooks, and budget templates

Non-Volatile

Permanent memory, cannot be lost (the backup)

Style Sets

Predefined styles with fonts and paragraph spacing defined Styles and formatting table contents enable you to enhance the appearance of a table

Output Devices

Printer, smartphone display, digital camera display, tablet display, laptop display, monitor display

CPU Performance Measures

Processor speed measured in hertz (Hz), Megahertz (MHz), or gigahertz (GHz), number of cores: single, dual, quad, eight

Status Bar

Provides information about the current file and process very bottom, words, page number

Bandwidth

Represents the amount of data that travels over a network, i.e. Megabits (Mbps), Gigabits (Gbps)

One Drive Account (Cloud Storage)

Simple way to store, sync and share various types of files, with other people and devices on the internet one place to store stuff that is accessible from multiple places

Application Software

Software framework that provides both facilities to create web applications and a server environment to run them The majority of the apps you download from app store, google play or from other content providers, assuming they allow users that ability to "work and play"

Utility Program

Software that supports your operating system (system software)

RAM

Stores instructions and data for quick retrieval by CPU Computer can have one or several RAM chips Temporary (volatile) storage

Volatile

Temporary memory, can be lost

Quick Access Toolbar

The customizable toolbar that contains a set of commands that are independent of the tab on the ribbon that is currently displayed very top left, save, undo

Evolution of the Internet

The internet originated as ARPANET (Advanced Research Projects Association) in September 1969 and had two main goals 1) Allow scientists at different physical locations to share information and work together 2) Function even if part of the network were disabled or destroyed In 1984 ARPANET has more than 1,000 individual computers linked as hosts Today Millions of hosts connect to the Internet

How does windows use file extensions

They tell your computer what icon to use for the file, and what application can open the file For example, in letter.docx the filename is letter and the extension is docx. This example tells the computer that the file is a Microsoft word file

System Software

Type of computer program that is designed to run a computers hardware and application programs Operating system Utility programs

Operating System Examples

Windows Mac OS X Linux (Open Source)

Ways to Connect to the Internet

Wired: -Cable Internet -DSL (Digital Subscriber Line) -Fiber -T1 Lines Wireless: -Wi-Fi (Wireless Fidelity) -Mobile Broadband -Satellite Internet Service

Port

a connection point or interface between a computer and an external or internal device

Main document

document that contains information that stays the same

Crowdfunding (kickstarter)

gain funding through raising small amounts of funding from a large number of people, typically through the internet

Merge Record

group of related fields representing one entity -Person - last name, first name, street address, city, state, zip code -Concert - artist, title, location, ticket prices

File Paths

it specifies a unique location in a file system.it follows the directory tree /desktop/pictures/summer2016

Crowdsourcing

obtaining information by enlisting the services of a large number of people, either paid or unpaid typically through the internet

Merge Field

placeholder for variable data smallest data element in a table -First Name - John -Course ID - CIS 400

C Drive (Root of Hard Drive)

the primary hard drive of the system and is used for storing the operating system, system files and other applications and their related files

Byte

8 bits Unique combinations of 8 bits of 0s and 1s form letters, numbers, and special characters

Server Farm (Server Cluster)

A collection of computer servers -- usually maintained by an organization to supply server functionality far beyond the capability of a single machine

Server

A computer with higher reliability / quantity parts that is dedicated to providing one or more services to other computers or devices on a network

Data Center

A facility used to house management information systems and associated components, such as telecommunications and storage systems

Web Server

A program that uses HTTP to serve the files that form Web pages to users, in response to their requests, which are forwarded by their computers' HTTP clients.

Connector

A simple device that physically links, couples, or connects, two things together joins a cable to a port

Backstage View

After you click the File tab, you can see the Microsoft Office Backstage view This is where you manage your files and the data about them

Paid Results

Allows you to pay to have your website displayed on the search engine results page when someone types in specific keywords or phrases

Switch Between Programs

Alt + Tab

Basic Types of Software

Application software, system software