IS 101 Exam 1 Study Guide

file extensions

-the endings of file names that indicate to the computer the format for how the underlying bits are organized. how to open things such as a word doc in microsoft word, etc. - (.docx, .xlsx, .pdf, etc.) -only one application can be set as the default application to open each type of extension

Common CTRL Shortcuts

Ctrl + C -- Copy selected text. Ctrl + X -- Cut selected text. Ctrl + V — Paste selected text. Ctrl + Z — Undo selected text. Ctrl + Home — Beginning of text Ctrl + End — End of text

Header/Footer

Data that appears at the top of every page or at the bottom of every page in a document. contextual tab (date, time, names, page #'s, document info)

Themes in Microsoft Word

Design Tab —> Themes Home Tab —> Theme colors (in current theme) Design Tab —> colors/fonts screen tips turned on

Examples of utility programs

File Manager- hard drive management Search Tool - find files & applications Disk Cleanup - removes unused files Disk Defragment - reorganize hard drive Backup Tool - schedules file backups Recovery Utility - system restore Safe Mode- minimize programs

style sets (word)

Home tab —> style sets

What is an ISP (Internet Service Provider)?

It is an organization that enables individuals and businesses to connect to the Internet.

web pages

Linked documents, or pages of information, on the Web.

Examples of application software

Microsoft Word - Word Processing Microsoft Excel - Spreadsheet Microsoft Outlook - Email, Contact, Calendar Management Microsoft Access, SQL Server, MySQL - Database Adobe Photoshop - Photo Editing Microsoft PowerPoint, Keynote - Presentation Internet Explorer, Chrome, Firefox, Safari - Web Browsing Quickbooks - Accounting WordPress, Adobe Dreamweaver - Website Authoring McAfee, Symantec, AVG - Virus Protection

device drivers

Provide specific interfaces between the OS running a computer and hardware devices. used to communicate with installed hardware

What is the World Wide Web (WWW)?

The information system that enables documents and other web resources to be accessed over the Internet by hyperlinks enabling the user to search for information by moving from one document to another. includes web pages and web browsers

CPU (Central Processing Unit)

The internal operating unit or "brain" of a computer. processes all commands and instructions, and can do billions of tasks per second

Table styles

allow you to easily add formatting to your table by using preset combinations insert —> table tables tool design tab tables tool layout tab layout —> formula (sums and averages) design tab —> table styles (colors, etc.)

ribbon

an area at the top of an office program window that contains commands for working with the open file; the commands are organized under tabs.

Router

connected to modem, all other devices connects to this. -wireless -local or private IP addresses

Modem

connected to wire (telephone lines, coax cable) coming into home from outside. connects you to the internet

Operating System (OS)

coordinates and directs the flow of data and information through the computer system

How to perform a mail merge

indicate type merge, select data source, sort&filter recipients, insert merge fields (<<First Name>>), finalize merge to create new document.

IS flow

input —> process (classify, arrange, calculate, store) —> output

Alt Menu

keyboard shortcuts

processor speed of CPU

measured in Hertz, Megahertz, and Gigahertz

Public IP address

once connecting to the internet you are assigned this. it identifies each device that connected (ex: 74.14.207.99)

Information System (IS)

organized digital system used for the collection, organization, storage and communications of information

Plug and Play

software that facilitates communication between the Operating System and a specific hardware device

RAM (Random Access Memory)

stores the computer's programs and data temporarily while power is on. a computer can have several of these, but it is temporary storage

utility programs ____

support your OS

contextual tabs

tabs that display when you perform certain tasks or work with objects such as pictures or tables

Bandwidth

the maximum amount of data that can be sent in a fixed amount of time, usually measured in megabits or gigabits per second.

application software allows you to _____

work or play

local storage

1. hard disk drives: magnetic disks to store 2. solid state drives (SSD): faster & more durable. found in laptops & high-performance computers 3. USB flash drives: portable, small, storage used to transfer files between computers

common network types

1. personal area network (PAN): connection using bluetooth 2. Local Area Network (LAN): connection between devices in office/school 3. Wide Area Network (WAN): connection in a large geographic distance (internet)

iCloud storage

1. public cloud services: google drive, onedrive, dropbox 2. private cloud services: hosted on own servers and for security and control

examples of IS systems in society today

1. the internet 2. google search engine 3. social media platforms 4. airline reservation systems 5. online retail platform 6. smartphones 7. smart home systems

what is necessary to build a website?

1. web server 2. web browsers 3. domain name (example.com) 4. web page (assigned a URL) 5. URL (Uniform Resource Locator) (www.example.com/services)

status bar

A bar at the bottom of the program window that provides information about the current file and process.

Motherboard

A circuit board that contains all of the computer system's main hardware components and allows them to communicate (CPU, RAM, hard drive, mouse, graphics card, monitor, keyboard, printer, etc.)

What is a computer network?

A collection of computing devices connected so that they can communicate and share resources -high speed internet connection -peripheral devices -files & common communications

Mail Merge

A process that inserts variable information into a standardized document to produce a personalized or customized document.

Web Browser

A program used to view Web pages. -edge, chrome, firefox, safari

utility program

A small program that performs many of the general housekeeping tasks for the computer, such as system maintenance and file compression. supports your OS

Backstage view

A tool that offers quick access to commands for performing many file management tasks all displayed in a single navigation pane that can be customized to meet users' needs.

Quick Access Toolbar

A toolbar that contains commands that users use more often, such as Save, Undo, and Redo.

Dialog Box Launcher

An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.