Csc 110 Final Review

Front 1

Spreadsheet

Back 1

An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

Front 2

Worksheet

Back 2

A single spreadsheet that typically contains label,"", values, formulas, functions, and graphical representations of data

Front 3

Workbook

Back 3

A collection of one or more related worksheets contained within a single file.

Front 4

Cell

Back 4

The intersection of a column or row in a worksheet or table.

Front 5

Cell Address

Back 5

The unique identifier of a cell, starting with the column letter and then the row number such as A9.

Front 6

Column Width

Back 6

The horizontal measurement of a column in a table or a worksheet. In Excel, it is measured by the number of characters or pixels.

Front 7

Row Height

Back 7

The vertical measurement of arrow in a table or a worksheet.

Front 8

Range

Back 8

A group of adjacent or contiguous cells in an Excel worksheet.

Front 9

Circular Reference

Back 9

A situation that occurs when a formula contains a direct or an indirect reference to the cell containing the formula.

Front 10

Syntax

Back 10

The rules that dictate the structure and components required to perform the necessary calculations in an equation or evaluate expressions.

Front 11

Argument

Back 11

A variable or constant input, such as a cell reference or value, needed to complete a function. The entire group of arguments for a function is enclosed within parentheses.

Front 12

Logical Test

Back 12

An expression that evaluates to true or false.

Front 13

Nested Function

Back 13

A function that contains another function embedded inside one or more of its arguments.

Front 14

Range Name

Back 14

A word or string of characters assigned to one or more cells. It can be up to 255 letters, characters, or numbers, starting with a letter.

Front 15

Slide show

Back 15

A collection of slides that can be used in a presentation.

Front 16

Powerpoint Presentation

Back 16

An electronic slideshow that can be edited or displayed.

Front 17

Thumbnail (in powerpoint)

Back 17

A miniature of a slide that appears in the slides tab and slide sorter view.

Front 18

Storyboard

Back 18

A visual plan of a presentation that displays the content of each slide in the slide show.

Front 19

Placeholder

Back 19

A container that holds content.

Front 20

Theme

Back 20

A collection of design choices that includes colors, fonts, and special theme effects used to give a consistent look to a presentation.

Front 21

Animation

Back 21

A movement that controls the entrance, emphasis, exit, and/or path of objects in a slide show.

Front 22

Transition

Back 22

A specific animation that is applied as a previous slide is replaced by a new slide while displayed in slide show view or reading view.

Front 23

Annotation

Back 23

A written note or drawing on a slide for additional commentary or explanation.

Front 24

Object

Back 24

A main component in an Access database that is created and used to make the database.

Front 25

Field

Back 25

The smallest data element contained in a table, such as first name, last name, address, and phone number.

Front 26

Record

Back 26

A group of related fielda, representing one entity, such as data for one person, place, event, or concept.

Front 27

Table (in access)

Back 27

An object in a database that stores related information. Organizes information in a series of records (rows), with each record made up of a number of fields (columns).

Front 28

Database

Back 28

Consists of one or more tables to store data, one or more forms to enter data into the tables, and one or more reports to output the table data as organized information.

Front 29

Primary key

Back 29

The field (or combination of fields) that uniquely identifies each record in a table.

Front 30

Form

Back 30

A database object that enables you to enter, modify, or delete table data.

Front 31

Query

Back 31

A question that you ask about the data in the tables of your database.

Front 32

Criterion

Back 32

An expression used to filter the records in a table.

Front 33

Report

Back 33

An Access database object that displays professional looking formatted information from underlying tables or queries.

Front 34

Filter

Back 34

Specifies criteria for including records that meet certain conditions, and displays a subset of records based on specified criteria.

Front 35

Relationship

Back 35

A connection between two tables using a common field.

Front 36

Foreign key

Back 36

A field in one table that is also the primary key of another table.

Front 37

Response

Back 37

Code that responds to input from the mouse, keyboard and other devices has to run continuously.

Front 38

Frame

Back 38

one execution of the draw function.

Front 39

Boolean

Back 39

A data type that has only two possible values true or false.

Front 40

String

Back 40

A sequence of characters.

Front 41

What are the four types of data in Excel?

Back 41

1. Text
2. Value
3. Date
4. Formula (results)

Front 42

What is the difference between a relative cell reference and absolute cell reference?

Back 42

Absolute Cell references do not change prefixed by the $symbol where as relative cell references indicates a cells relative location

Front 43

Name 3 functions provide by Excel.

Back 43

Date & time
Financial
Math & Trig
Text
Statistical
Logic

Front 44

What is the difference between a primary key and a foreign key?

Back 44

A primary key is a field or combination of fields in a table that uniquely identify a record. A Foreign key is a field in a table that is also a Primary key in another table.

Front 45

What are 3 delivery tips for presenting (as noted in our lecture)?

Back 45

Practice material and delivery

Set up early

Have a backup plan

Eye contact

Front 46

When is it better to use Excel? When is it better to use Access? (2 reasons each)

Back 46

Access; large amounts of data, retrieve data from external DB, multiple users to one data source.

Excel; mostly numeric data, only one work sheet needed, charts or graphs needed.

Front 47

What is the difference between an int and a float?

Back 47

Data type int is of the form of an integer. Float allows the use of decimals.

Front 48

What variables from processing allow you to access the location of the mouse?

Back 48

mouseX and mouseY

Front 49

What is the difference between = and ==?

Back 49

== is a Boolean operator that asks the question is one thing equal to another. = is an assignment operator. The possible values for == is true or false

Front 50

Set window size.

Back 50

size(240,120);

Front 51

Draw ellipse.

Back 51

stroke(225,0,0);
strokeWeight(10);
ellipse(25,25,25,25);

Front 52

Draw line.

Back 52

stroke(225,0,0);
strokeWeight(10);
line(50,50,100,100);

Front 53

Draw rectangle.

Back 53

stroke(225,0,0);
strokeWeight(10);
rect(25,200, 25,25);

Front 54

Draw points.

Back 54

stroke(225,0,0);
strokeWeight(10);
point(25,25);
point(50,50);
point(25,200);

Front 55

Turn smoothing on and off.

Back 55

smooth();
noSmooth();

Front 56

Set the stroke weight.

Back 56

strokeWeight(50);

Front 57

Set background, fill and stroke colors.

Back 57

background(100);// 0-255 from black to white
background(255, 0, 0); /*rgb values 0,0,0, = black 255,0,0 = red etc. */

Front 58

Add transparency in colors.

Back 58

fill(255,0,0,50); //(v1,v2,v3,alpha)
stroke(0,255,0,75); //same as above

Front 59

Declare and use variables.

Back 59

int a = 10
float b = 10.5

Front 60

Create for loops.

Back 60

size(480, 120);
smooth();
strokeWeight(2);//power of a loop
for(int ln = 20; ln < 300; ln += 20){
line(ln, 0, ln + ln/2, 80);
line(ln + ln/2, 80, ln *1.2, 120);
}

Front 61

Use arithmetic operators.

Back 61

int a = 5 + 3 * 5 / 8

Front 62

Create setup and draw functions.

Back 62

void setup(){
Size (240,100);
Background(0,0,255);
strokeWeight(12);
smooth();
}

void draw(){
stroke(255);
line(25,25,215,75;
}

Front 63

Use mouseX, mouseY, pmouseX, pmouseY, mousePressed and mouseButton variables

Back 63

void setup(){
size(240,120);
strokeWeight(12);
smooth();
}
void draw(){
background(204);
stroke(255);
line(120, 60, mouseX,mouseY);
stroke(0);
line(120, 60, mouseX, mouseY);
}

Front 64

Use a map function.

Back 64

void setup(){
size(240,120);
strokeWeight(12);
smooth();
}
void draw(){
background(204);
stroke(255);
line(120, 60, mouseX,mouseY);
stroke(0);
float mx = map(mouseX,0,width,60,180);
line(120, 60, mx, mouseY);
}

Front 65

Create if and else statements.

Back 65

void setup(){
size(240,120);
strokeWeight(12);
smooth();
}
void draw(){
background(204);
stroke(255);
line(40, 0, 70, height);
if(mousePressed == true){//any thing in this block of code will only be run if the condition is true.
stroke(0);
}
line(0, 70, width, 50);
}

Front 66

Use fonts to write text to the screen

Back 66

PFont font;
void setup(){
size(520, 120);
smooth();
font = createFont("Arial",16,true);
textFont(font);
}
void draw(){
background(102);
textSize(36);
text("That's one small step for man!", 25, 60);
textSize(18);
text("That's one giant step for mankind!", 27, 90);
}