CS 008 midterm 1

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

Record:

One complete entry in a database table; composed of the individual fields Can perform queries and create reports

Each (registered) file extension has a ____

Default Program Association .exe : executable program .docx : MS-Word .xlsx : MS-Excel .html : A web browser When you double-click on a file, the associated program is executed and the file loaded

8 bits =

1 byte

Bits used to measure transfer rates (such as an Internet connection) 1 Kilobit = 1 Megabit = etc.

1,000 (1 thousand) bits 1,000,000 (1 million) bits etc.

1 Kilobyte (K) = 1 Megabyte (M) = 1 Gigabyte (G) = 1 Terabyte (T) = 1 Petabyte (P) = etc.

1,000 (1 thousand) bytes 1,000,000 (1 million) bytes 1,000,000,000 (1 billion) bytes 1,000,000,000,000 (1 trillion) bytes 1,000,000,000,000,000 (1 quadrillion) bytes etc.

Gantt Chart:

A chart that shows the schedule and progress of a project Examples: Microsoft Project, Basecamp

Database:

A collection of information organized in a useful way (such as for fast retrieval of data) Examples: Microsoft Access, SQL Server, Oracle

Table:

A collection of related records in a database, arranged in rows and columns

Client:

A computer (or device) that requests services from a server

Server:

A computer that provides services to and/or share resources with client computers over a network

Folder

A container used to store and organize files on a storage device Operating systems come with some folders already created, called a hierarchy The folder structure created by an operating system Windows includes libraries

Library:

A tool used to gather files that are located in different locations Camera Roll, Documents, Music, Pictures, Saved Pictures, and Videos Path: The sequence of folders to a file or folder Example - C:\docs\classes\notes.txt (MS-Windows) Example - /docs/classes/notes.txt (Mac OSX / Linux)

Subscription

A monthly or yearly fee provides access to the software for a limited time Software updates / newer versions included

Application Software:

A program that performs a useful task for the user, such as productivity, entertainment, and education software.

Computer

A programmable (usually electronic) machine that converts raw data into useful information.

Field:

A single piece of information in a record in a database, such as a name, phone number, date, etc.

Embedded Computer

A specialized computer that is part of another device Gasoline pumps, microwave ovens, traffic lights,

Customer Relations Management (CRM) System

A system for maintaining customer information and connections Tracks interactions with customers Uses analytics (detecting patterns in data) to help make business decisions

Grace Hopper

Accidentally coined the term "computer bug" Created first compilers

Tax Preparation Software

Allows you to complete your income tax returns yourself on your computer or online (TurboTax, TaxAct)

Programs

Also known as software, applications, executable files On MS-Windows, end with ".exe"

Project Management Software:

Application designed to help complete projects, keep within budget, stay on schedule, and collaborate with others

Spreadsheet Software

Application that creates electronic worksheets composed of rows and columns Used for mathematical applications, such as budgeting, grade books, and inventory Examples: Microsoft Excel, Numbers for Mac, Google Sheets

Database Software

Application used to create and manage a database

Presentation Software

Application used to create electronic presentations, (slides) Design template (predefined colors, fonts, and layouts) Examples: Microsoft PowerPoint, Keynote for Mac, Google Slides

Accounting Software

Application used to to track your business finances and generate reports and graphs Can do expense tracking, invoicing, payroll, and inventory management Examples: Intuit QuickBooks, FreshBooks

Personal Information Manager (PIM) Software

Application used to your manage e-mail, calendar, and tasks Can share calendars and schedule meetings Examples: Microsoft Outlook, Google Calendar/Google Mail (gmail)

Ada Lovelace

Created programs (on punched cards for Analytical Engine) Considered to be the first programmer

Fourth Generation (1970s)

Basically an extension to the third generation Microprocessor: a complex integrated circuit that contains processing circuitry First microprocessors developed were as powerful as the ENIAC Central Processing Unit (CPU): The main microprocessor in a computer Faster, smaller, more reliable, and cheaper than Third Generation computers Personal computers developed

Midrange Computers / Minicomputers

Computers that are larger, more powerful, and more expensive than desktop computers but smaller, less powerful, and less expensive than mainframe computers Can have dozens or hundreds of concurrent users Primarily used by medium-sized companies As high-end desktops have become more powerful, fewer companies are using midrange computers

how do computers count (how many values are possible).

Computers use transistors and switches, which allow for only 2 possible values (i.e. digits)

Data files

Created by users (actually, by the programs they are using) Documents, images, audio, videos, etc.

Charles Babbage Designed the Analytical Engine, a mechanical computer Had all the basic components of modern day computers Never completeterm-5d... technology of the time was too limited

Designed the Analytical Engine, a mechanical computer Had all the basic components of modern day computers Never completed... technology of the time was too limited

ASCII / Extended ASCII

Developed for English, later expanded for similar "Romance" languages Uses 8 bits (1 byte) for each character Example: A = 0100 0001 Example: a = 0110 0001 Example: 0 = 0011 0000 Example: ? = 0011 1111 Cannot be used to represent characters from other languages

Unicode

Developed in early 1990's to handle other languages Uses 16 bits (2 bytes) for each character (instead of 8 bits / 1 byte) Backwards compatible with ASCII Can be used to represent characters from (almost) all languages Has been universally adopted

Distributed Computing

Distributes the processing of a task across a group of computers With distributing computing, a group of less powerful computers can often perform same tasks as more powerful (and more expensive) computers

Lossy

During compression, data (that humans typically cannot detect anyway) is removed from the file, allowing the compressed file to be much smaller than with lossless compression Media files (images, audio files, video files)

Steve Jobs

Founded Apple

Bill Gates

Founded Microsoft

Document Management System (DMS)

Enables a company to save, share, search, and audit electronic documents throughout their life cycle

Supercomputers

Fastest, most expensive computers in the world Can be a single computer or a group of computers that work together Perform complex mathematical calculations, such as those used in weather forecasting and medical research Usually found in major universities and research institutes Speeds normally measured in petaflops: 1 petaflop = one thousand million million (1015) floating-point operations per second top500.org

Alan Turing

Father of AI (Artificial Intelligence) Turing Test Helped break Nazi communication codes during World War 2

User Folders:

For each account created, a personal user folder (with sub-folders) is created By default, users are not allowed to view other users' folders and files

Volunteer Computing

Form of distributed computing that uses computers from around the world

Grid Computing

Form of distributed computing using a group of computers in one location

Donationware

Form of freeware where developers accept donations

Personal Finance Software

Helps you keep track of your bank accounts, monitor your investments, create a budget, etc. Quicken YNAB (You Need a Budget)

Cloud Computing: IaaS

Infrastructure as a Service Company uses provider's Internet servers instead of purchasing and maintaining their own Can reduce cost because u can just pay for what is needed

Cell

Intersection of a row and column Can contain text, numbers, or formulas

Joseph Marie Jacquard

Jacquard Loom Punched cards One of the first programmable machines

Mainframe Computers / Enterprise Servers

Large, very fast computers primarily used by large organizations for critical applications and bulk data processing Can have thousands of concurrent users

Open Source

License grants ownership of the software to the end user Source code must be made freely available User can modify and redistribute software (under same license)

Personal Computer Operating Systems (examples)

Microsoft Windows [Most popular (by far)] Mac OSX Linux (Chromebooks)

Updating

Need Internet connection Patch (hotfix): Addresses an individual problem (bug) when discovered Service pack: Larger, planned update that addresses multiple problems and/or adds features Software can be configured to automatically install updates, ask user for permission, or to not check for updates (not recommended)

Freemium

Mobile app that is free to download and install, but... You have to pay for additional features

Internal Storage

Mobile devices usually do not have a lot of internal storage space to store files

Download from a website

Most popular method

Installing

Most softwares use an installer, which guides user through a series of steps to install the software

examples of bits (binary digits)?

Numbers (integers and floating point) Characters Images Audio Video

Business Productivity Software

Office Application Suites or "Office Suites" Apps designed to work together and to provide a common interface and features Ex: Microsoft Office, G Suite by Google, Google Drive (free)

File Management

Opening, closing, saving, naming, copying, moving, deleting, and organizing digital files.

Cloud Computing: PaaS

Platform as a Service Provides a programming environment to develop, test, and deploy web applications Used to build, deploy, and maintain SaaS applications

Moore's Law

Prediction made in 1965 by Gordon Moore (co-founded Intel) Said that the number of transistors that could be placed on a computer chip would double every 2 years for at least a decade Actual pace was closer to every 18 months Pace actually held up until roughly 2016 (about 50 years), not just a decade More transistors on a chip --> faster and more powerful the chip is

Information Processing Cycle

Process that converts data into information Input - raw data entered Processing - raw data manipulated to create useful information Storage - information stored for later retrieval Output - information returned to the user

Boxed software

Purchase at retail stores Purchase online, shipped to you

Software Licensing

Purchasing software may not mean you own it, you may only be purchasing a license to use the software, normally on a single computer

Finder:

The tool used to navigate the file system and work with files, folders, and libraries on a Mac OSX computer

File Explorer:

The tool used to navigate the file system and work with files, folders, and libraries on a Windows computer

Freeware

Retail software that can be used at no cost for an unlimited period of time Example: Apple iTunes

Cloud Computing: SaaS

Software as a Service Involves the delivery of applications over the Internet Another name for web applications

Shareware (Trialware)

Software that can be used for free for a period of time At the end of the trial period, user is supposed to purchase or remove software

Ergonomics

Study of the relationship between workers and their workspaces Jobs involving mostly using computers can lead to health issues (over time) like: Carpal tunnel syndrome (most common), eye strain/headaches, back issues, etc.

Multiuser Computers

Systems that allow multiple simultaneous users to connect to them Advantages include centralized resources and security Much more powerful than personal computers

Ubiquitous Computing

Technology that recedes into the background and becomes part of the environment (invisible computing) all around us but has become so commonplace we don't notice

Internet of Things (IoT)

The connection of the physical world to the Internet Devices located, monitored, and controlled by embedded computers example: Smart homes

Convergence

The integration of different technologies onto multifunction devices One device can replace multiple devices example: smartphones

System Requirements

The minimum hardware and software specifications required to run an application How much storage space is needed, minimum RAM required, minimum CPU, etc.

Compression

The process of making a file smaller Conserves disk space Can be transferred more quickly

Lossless

There is no loss of data, so compressed file can later be decompressed User data files (MS-Word docs, MS-Excel spreadsheets, etc.) Zip (MS-Windows), StuffIt (Mac OSX)

general-purpose machines

Unlike other machines, most computers are general-purpose machines, meaning they can be programmed to do different things.

Uninstalling

Use uninstaller that came with software Do not just delete files

Third Generation (1960s)

Used integrated circuits (computer chips) that contain large numbers of transistors to process data Faster, smaller, more reliable, and cheaper than Second Generation computers

Second Generation (1950s)

Used transistors to process data Faster, smaller, more reliable, and cheaper than First Generation computers

First Generation (1940s)

Used vacuum tubes to store and process data Were massive in size Not reliable Programming done by manipulating switches (took days)

Retail Software

User pays a fee to use the software (pay for the license, not the software itself) Grants a proprietary software license, which means ownership of the software remains with the publisher

Formulas:

What makes spreadsheet so useful Usually start with an "=", such as =SUM(A1:A5) or =A1+A2+A3+A4+A5 Performs a calculation, with result shown in a cell Can contain functions (pre-built calculations like SUM) Automatic recalculation

File Properties

provides information about the file, form of metadata,

All data entered into a computer must be converted into ____ ?

bits (binary digits)

Back up:

copying files to another storage device or the cloud

UNIVAC

first commercially available computer, famously predicted outcome of 1952 presidential election

ENIAC

first working digital, general-purpose electronic computer

All-In-One: (example): ?

integrated monitor and system unit ex: desktop computer

If your computer's system specs do not meet the system requirements for a program, _____

it (probably) will not work

External Storage

micro SD cards Cloud storage

netbook computers

not as powerful, less expensive, been replaced by tablets mostly

Subnotebook computers

notebook computers that are smaller and lighter than ordinary notebooks (more expensive)

Storage is key:

rather than keeping files on local drives, files are stored on a server or on the web, making them more accessible and secure Examples: Microsoft Sharepoint, Dropbox, Google Drive

Cloud computing: )

takes processing and storage off your hardware and puts it in the cloud (i.e. on a provider's Internet servers

EULA (End-User License Agreement)

the agreement between the user and the software publisher User typically required to accept the EULA before software can be installed Can be lengthy and contain lots of "fine print"

binary number system

the base 2 number system - counts by 2's ( 1 or 0, True or False)

The file name:

the property that is used to identify it

Byte:

unit of measurement that equals 8 bits

Word Processing Software

used to create, edit, and format (mostly) text documents various formatting features (font style/size, page layout, etc.) spell/grammar checking] Examples: Microsoft Word, Pages for Mac, Google Docs

2 bits → 3 bits → 8 bits →

→ 4 values → 8 values → 256 values


Ensembles d'études connexes

Exponential and Logarithm Key Terms (with images)

View Set

Marketing - Test 2 - Chapter 5, 6, 7, 8

View Set

Social Problems Ch 8 Vocab and Main Points

View Set

10 Buildings that changed America

View Set

comm 10 pt 7 ethics of the mass media

View Set

PeriOperative MedSurg PREPU GOOD

View Set