terminology for the first midterm
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| A1 reference style | An addressing scheme used by excel to identify different cells. Uses capital letters to identify columns and numbers to identify rows. The cell address A1 refers to the cell in column A row 1
🗑
|
||||
| Absolute reference | An absolute reference will always refer to the same cell, regardless of the location of the formula.
🗑
|
||||
| Action (Simulation) | Changes in initial values, parameters, and/or state variables are often construed as actions. The simulation model is used to explore the consequences (indicator variables) of alternative actions.
🗑
|
||||
| Arithmetic expression | One or more characters or symbols associated with arithmetic, such as 1+2=3 or 8*6.
🗑
|
||||
| Arithmetic operator | The basic arithmetic operations are addition, subtraction, multiplication and division
🗑
|
||||
| ASCII | The American Standard Code for Information Interchange is a character-encoding scheme based on the ordering of the English alphabet. ASCII codes represent text in computers, communications equipment, and other devices that use text. 8 bit code.
🗑
|
||||
| Augmented style | A style in WORD that has been changed with manual formatting.
🗑
|
||||
| Auto fill button | A GUI found in the bottom right corner of the cell to be copied. Used to fill a selection with a copy of a formula.
🗑
|
||||
| AVERAGE() | A function in Excel used to calculate the arithmetic mean.
🗑
|
||||
| Binary number | A 2 digit numerical system --> 0 & 1
🗑
|
||||
| Bit | A bit or binary digit is the basic unit of information in computing and telecommunications
🗑
|
||||
| Bitmap | In computer graphics, a bitmap is a type of memory organization or image file format used to store digital images. --> Raster image --> Grid system.
🗑
|
||||
| Bitmapped graphics | In computer graphics, a raster graphics image or bitmap is a data structure representing a generally rectangular grid of pixels.
🗑
|
||||
| Browser | A web browser or Internet browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web.
🗑
|
||||
| Built in style (Word) | A Pre-programmed formatting feature that controls colours, fonts, spacing and effects.
🗑
|
||||
| Bus (computer) | In computer architecture, a bus is a subsystem that transfers data between computer components inside a computer or between computers.
🗑
|
||||
| Byte | The byte is a unit of digital information in computing and telecommunications, that most commonly consists of eight bits.
🗑
|
||||
| CCD | A charge-coupled device. Light sensor used in digital cameras.
🗑
|
||||
| Chart sheet | A sheet in Excel used to display data graphically.
🗑
|
||||
| Circular reference | When a formula refers back to its own cell, either directly or indirectly, it creates a circular reference
🗑
|
||||
| Clean Word document | A clean Word document is a document that has no ‘messy’ or ‘typewriter’ formatting.
🗑
|
||||
| Command Line Interface | A command-line interface (CLI) is a mechanism for interacting with a computer operating system or software by typing commands to perform specific tasks.
🗑
|
||||
| Compressed file | A ZIP file contains one or more files that have been compressed to reduce file size. Done by looking for redundancy and expressing it in a shorter manner.
🗑
|
||||
| Computer | A computer is a programmable machine that receives input, stores and automatically manipulates data, and provides output in a useful format.
🗑
|
||||
| Computer clock | The ‘clock’ in a computer is a tiny encased piece of quartz crystal that emits an electric signal when connected to a power source, in this case a small battery. The frequency of this signal is used to keep time.
🗑
|
||||
| Computer virus | A computer virus is a computer program that can copy itself and infect a computer. A form of malware.
🗑
|
||||
| Create from Selection command (Excel) | A command that automatically creates names from the selected cells.
🗑
|
||||
| Ctrl+↓ (Excel) | (CTRL+↓) will move the selected cell to the first empty cell or the first non-empty cell in the direction (down) of the arrow.
🗑
|
||||
| Data Table command | The data table command is a built in command that performs either a one way or two way sensitivity analyses. The table command is not a function. It is a request to Excel to follow a specific procedure and to fill in a table of values.
🗑
|
||||
| Design mode (Excel, Access) | Allows you to format the style and layout of a chart or graph.
🗑
|
||||
| Dialogue Box | In a graphical user interface of computers, a dialogue box is a type of window used to enable reciprocal communication or "dialogue" between a computer and its user. It may communicate information to the user, prompt the user for a response, or both.
🗑
|
||||
| Document | Word’s name for a Word file.
🗑
|
||||
| Domain name | A domain name is an identification label that defines a realm of administrative autonomy, authority, or control in the Internet.
🗑
|
||||
| End, → (Worksheet) | A command that takes you to the furthest cell of the worksheet in the direction of the arrow.
🗑
|
||||
| Excel formula | Formulas are equations that perform calculations on values in your worksheet. A formula starts with an equal sign (=).
🗑
|
||||
| Executable file | In computing, an executable file causes a computer "to perform indicated tasks according to encoded instructions.
🗑
|
||||
| EXP( ) | The exponent function in Excel.
🗑
|
||||
| F1 (Office) | The key shortcut that brings up the Office Help window.
🗑
|
||||
| F4 (Excel) | Changes the reference type in the name manager window.
🗑
|
||||
| Font | A complete character set of a single size and style of a particular typeface.
🗑
|
||||
| Formula bar | The formula bar displays the data or formula stored in the active cell. The formula bar can be used to enter or edit a formula, a function, or data in a cell.
🗑
|
||||
| FTP | File Transfer Protocol is a standard network protocol used to copy a file from one host to another over a TCP-based network, such as the Internet.
🗑
|
||||
| IP | The Internet Protocol is the principal communications protocol used for relaying datagrams (packets) across an inter-network using the Internet Protocol Suite.
🗑
|
||||
| Gif | The Graphics Interchange Format is a bitmap image format that has come into widespread usage on the World Wide Web due to its wide support and portability. 256 colours --> 8 bits. Not good for images with lots of colour. Lossless.
🗑
|
||||
| Gigabyte | 1 billion bytes.
🗑
|
||||
| Go To (Excel) | To move to a specific cell of the worksheet, you can use the Go To command. Home --> Find & Select --> GO TO
🗑
|
||||
| GUI | In computing a graphical user interface (GUI, sometimes pronounced gooey) is a type of user interface that allows users to interact with electronic devices with images rather than text commands.
🗑
|
||||
| Hard drive | A hard disk drive (HDD) is a non-volatile, random access device for digital data storage.
🗑
|
||||
| Header (Word) | Found at the top of the page of a document. It contains descriptive information that pertains to the following document.
🗑
|
||||
| Header row | The top row of a table in Excel that that contains labels for the columns underneath.
🗑
|
||||
| Heading (Word) | A paragraph style that has a level 1 for hierarchical style.
🗑
|
||||
| Heat sink | A heat sink is a term for a component or assembly that transfers heat generated within a solid material to a fluid medium, such as air or a liquid.
🗑
|
||||
| Hertz | The hertz (symbol: Hz) is the unit of frequency defined as the number of cycles per second of a periodic phenomenon.
🗑
|
||||
| Hierarchical file structure | Hierarchical File System (HFS) is a file system developed by Apple Inc. for use in computer systems running Mac OS.
🗑
|
||||
| HTML | HTML, which stands for Hyper Text Markup Language, is the predominant markup language for web pages. HTML is the basic building-blocks of webpages. A markup language is a set of markup tags, and HTML uses markup tags to describe web pages.
🗑
|
||||
| HTTP | The Hypertext Transfer Protocol (HTTP) is a networking protocol for distributed, collaborative, hypermedia information systems. HTTP is the foundation of data communication for the World Wide Web.
🗑
|
||||
| If function | The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.
🗑
|
||||
| Indicator variable | Indicator variables are additional variables that you might be interested in knowing about but are not actually used in computing changes in state variables.
🗑
|
||||
| Intellisense | IntelliSense is Microsoft's implementation of autocompletion. Autocomplete involves the program predicting a word or phrase that the user wants to type in without the user actually typing it in completely
🗑
|
||||
| IP address | An Internet Protocol address (IP address) is a numerical label assigned to each device (e.g., computer, printer) participating in a computer network that uses the Internet Protocol for communication.
🗑
|
||||
| Iteration | Iteration means the act of repeating a process.
🗑
|
||||
| Jpeg | Joint Photographic Expert Group. A format or set of instructions to compress a large amount of information into a file (lossy). 24 bits → Red, Green, Blue → 8 bits per colour. Good for photos.
🗑
|
||||
| Kerning | In typography, kerning is the process of adjusting the spacing between characters in a proportional font, usually to achieve a visually pleasing result.
🗑
|
||||
| Kilobyte | A kilobyte is 1000 bytes
🗑
|
||||
| Label (worksheet) | A label is text typed into a cell. Ideally, the label will be descriptive text that clarifies the meaning of a value or formula that the text is intended to 'label'.
🗑
|
||||
| Launcher | Launcher is an easy-to-use file and application shortcut manager that can launch all kinds of files and programs.
🗑
|
||||
| Limit cycle | A periodic cycle in a dynamical system such that previous states are returned to repeatedly.
🗑
|
||||
| Limit point | A limit point is a state that would persist without change over time (unstable, or stable).
🗑
|
||||
| Line type (Excel Chart) | A line chart distributes category data evenly along a horizontal (category) axis, and distributes all numerical value data along a vertical (value) axis.
🗑
|
||||
| Logical expression | A logical expression compares two arithmetic expressions. (An arithmetic expression is a formula that computes to a numerical value.)
🗑
|
||||
| Logical operator | In logic, a logical connective (also called a logical operator) is a symbol or word used to connect two or more sentences in a grammatically valid way
🗑
|
||||
| Malware | Malware, short for malicious software is software designed to secretly access a computer system without the owner's informed consent.
🗑
|
||||
| Manual Formatting | Use of either the Font set or the Paragraph set is referred to as manual formatting.
🗑
|
||||
| MAX() | An Excel function Returns the largest value in a set of values.
🗑
|
||||
| Metadata | Metadata is loosely defined as data about data.
🗑
|
||||
| Mixed reference | A mixed reference contains both a relative and absolute reference.
🗑
|
||||
| Monte Carlo simulation | Monte Carlo simulation is a simulation technique that uses random numbers to generate a range of outcomes.
🗑
|
||||
| Mother board | The mother board is the central printed circuit board that connects all of the components of the computer together.
🗑
|
||||
| Name box (Excel) | The box to the left of the formula bar that identifies the selected cell.
🗑
|
||||
| Name manager (Excel) | The name manager is a window used to create new names, edit or delete existing names, or change the reference type of named references.
🗑
|
||||
| Non-printing characters | Characters that don’t print. Such as spaces, tabs or paragraph marks.
🗑
|
||||
| Notepad | Notepad is a simple text editor for Microsoft Windows.
🗑
|
||||
| Office button | A gooey that replaced the ‘File’ menu of earlier MS Word versions. It performs tasks on the document level such as saving, or opening a new document.
🗑
|
||||
| Offline help versus online help | Offline help is saved information that was included with the software. Online help has access to the internet and therefore has access to the latest updates of help.
🗑
|
||||
| Operating system | An operating system (OS) is software, consisting of programs and data, which runs on computers and manages computer hardware resources and provides common services for efficient execution of variety application software.
🗑
|
||||
| Paragraph (Word) | A level of the hierarchical structure of Word. Paragraphs contain characters.
🗑
|
||||
| Parameter | Parameters are used, in formulas, to compute the changes in the state variables. Ex. Population growth rate.
🗑
|
||||
| Pdf file | The portable document format (PDF) is an open standard for document exchange.
🗑
|
||||
| Phishing | In the field of computer security, phishing is the criminally fraudulent process of attempting to acquire sensitive information such as usernames, passwords and credit card details by masquerading as a trustworthy entity in an electronic communication.
🗑
|
||||
| Pivot table | In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets (for example in Excel).
🗑
|
||||
| Pixel | In digital imaging, a pixel (or picture element) is the smallest addressable screen element in raster graphics; it is the smallest unit of picture that can be controlled.
🗑
|
||||
| PNG | Portable Network Graphics is a bitmapped image format and video codec that employs lossless data compression. Has a better colour range than GIF. Can’t support animations.
🗑
|
||||
| Point (fonts) | The unit for measuring font size.
🗑
|
||||
| Printed circuit | A printed circuit board, or PCB, is used to support and connect electronic components using conductive pathways, tracks or signal traces etched from copper sheets laminated onto a non-conductive substrate.
🗑
|
||||
| Procedure | A procedure is a specified series of actions or operations which have to be executed in the same manner in order to always obtain the same result under the same circumstances (for example, emergency procedures).
🗑
|
||||
| Quartile | In descriptive statistics, a quartile is one of three points that divide a data set into four equal groups, each representing a fourth of the distributed sampled population.
🗑
|
||||
| Quick Access tool bar | The Quick Access Toolbar is a customizable toolbar that contains a set of commands (GUI’s) that are independent of the tab that is currently displayed.
🗑
|
||||
| R1C1 reference style (Excel) | An addressing scheme where both rows and columns are labeled with numbers.
🗑
|
||||
| RAM | Random-access memory (RAM) is a form of volatile computer data storage.
🗑
|
||||
| Raw Image file | A camera raw image file contains minimally processed data from the image sensor of either a digital camera, image scanner, or motion picture film scanner. Raw files are so named because they are not yet processed
🗑
|
||||
| Reference (Excel) | A reference is a pointer to other cells. A formula that includes a reference computes its value or ‘answer’ by including, in its calculations, the values pointed to by the references.
🗑
|
||||
| Relative reference | A reference to a cell in a formula that is dependant on the relative position of the referred cell to the cell containing the formula.
🗑
|
||||
| Resample | Resampling is the digital process of changing the sample rate or dimensions of digital imagery by temporally analysing and sampling the original data.
🗑
|
||||
| Ribbon | The collection of GUI’s that have been arranged into logical groups found at the top of MS Office programs.
🗑
|
||||
| Row column address | A row column address is a cell’s location on a work sheet.
🗑
|
||||
| RSI | Repetitive strain injury is an injury of the musculoskeletal and nervous systems that may be caused by repetitive tasks, forceful exertions, vibrations, mechanical compression (pressing against hard surfaces), or sustained or awkward positiohns.
🗑
|
||||
| Rules for change | The rules for change are formulas that compute the expected change in each state variable over the next short interval of time.
🗑
|
||||
| Sans Serif (font) | In typography, a sans-serif, sans serif or san serif typeface is one that does not have the small features called "serifs" at the end of strokes. The term comes from the French word sans, meaning "without".
🗑
|
||||
| Scroll bar | A scrollbar is an object in a graphical user interface (GUI) with which continuous text, pictures or anything else can be scrolled including time in video applications.
🗑
|
||||
| Section (Word) | A Word document is composed of sections. Sections contain paragraphs.
🗑
|
||||
| Selection (Excel) | A ‘point’ to a specified cell.
🗑
|
||||
| Sensitivity Analysis | A sensitivity analysis explores the changes in the state variables and indicator variables in response to changes in initial values, changes to state variables, and changes in parameter values.
🗑
|
||||
| Serif font | A typeface that has serifs. Serifs are semi-structural details on the ends of some of the strokes.
🗑
|
||||
| Server | A ‘host’ computer dedicated to running services, to serve the needs of programs running on other computers on the same network.
🗑
|
||||
| Show/Hide tool/command (Word) | Toggles between showing and hiding hidden text such as paragraph marks.
🗑
|
||||
| Simulation model | A simulation model evaluates a mathematical representation of our understanding of a dynamic system.
🗑
|
||||
| Sophos | Sophos is a developer and vendor of security software and hardware.
🗑
|
||||
| Spinner | A gooey used to increase or decrease a value.
🗑
|
||||
| Stable limit point | If a disturbed system returns to its pre-disturbed levels.
🗑
|
||||
| State variable | The state variables represent the dynamic system at a particular point in time. The state variables are a list of values that change over time but at any individual point in time can be used to describe the system.
🗑
|
||||
| Status bar | Found at the bottom of MS Office programs. Indicates what options have been turned on or off. The zoom function can also be accessed on the status bar.
🗑
|
||||
| Style (Word) | A formatting style for selected text.
🗑
|
||||
| Super clean word document | A super clean Word document is a clean word document that uses a style name for each style of formatting in the document.
🗑
|
||||
| Table Styles | A formatting style for tables.
🗑
|
||||
| Template file | A template is a document type that creates a copy of itself when you open it.
🗑
|
||||
| Terabyte | 1 trillion bytes.
🗑
|
||||
| Text editor | A text editor is a type of program used for editing plain text files.
🗑
|
||||
| Title bar | In computing, the title bar consists of that part of a window where the title of the window appears.
🗑
|
||||
| Trace precedence | Shows arrows that indicate what cells affect the value of the currently selected cell.
🗑
|
||||
| Trojan Horse | A type of malware. A Trojan horse, or Trojan, is software that appears to perform a desirable function for the user prior to run or install, but (perhaps in addition to the expected function) steals information or harms the system.
🗑
|
||||
| Typewriter formatting | Typewriter formatting uses the space bar and or multiple tabs to generate horizontal spacing and multiple uses of the ‘carriage return’ to generate vertical spacing.
🗑
|
||||
| Unicode | Unicode is a computing industry standard for the consistent encoding, representation and handling of text expressed in most of the world's writing systems (universal/international character code).
🗑
|
||||
| Unstable limit point | A disturbed system would continue to move away from its pre-disturbed levels.
🗑
|
||||
| URL | In computing, a Uniform Resource Locator (URL) is a subset of the Uniform Resource Identifier (URI) that specifies where an identified resource is available and the mechanism for retrieving it.
🗑
|
||||
| USB | Universal Serial Bus a serial bus standard for connecting devices
🗑
|
||||
| User defined style | A style that has been formatted to the specific desires of the user.
🗑
|
||||
| Vector graphics | Vector graphics is the use of geometrical primitives to represent images in computer graphics.
🗑
|
||||
| Window | In computing, a window is a visual area containing some kind of user interface.
🗑
|
||||
| Word (General computers not MS Word) | A word is simply a fixed sized group of bits that are handled together by the system.
🗑
|
||||
| Worm | A computer worm is a self-replicating malware computer program, which uses a computer network to send copies of itself to other nodes (computers on the network) and it may do so without any user intervention.
🗑
|
||||
| XML | Extensible Markup Language (XML) is a set of rules for encoding documents in machine-readable form.
🗑
|
||||
| X-Y scatter type | A graph type used to compare two subjects.
🗑
|
||||
| Zip file | The ZIP file format is a data compression and archive format. A ZIP file contains one or more files that have been compressed to reduce file size, or stored as-is. The ZIP file format permits a number of compression algorithms.
🗑
|
||||
| .csv (file extension) | The comma-separated values file format is a set of file formats used to store tabular data, in which numbers and text are stored in plain textual form that can be read in a text editor. Lines seperate rows, commas seperate fields in rows.
🗑
|
||||
| Active Cell vs. ActiveCell | "ActiveCell" Is a property that returns a range object that represents that the cell is active in VBA. "Active cell" does not work in VBA.
🗑
|
||||
| Array (VBA) | Arrays are variables in VBA that can contain more than one element/number. Each data element in an array is identified with the array name and with array ‘subscripts’. Eg. Dim Block(1 To 20 , 1 To 10) As Single
🗑
|
||||
| Assignment Statement | The ‘Let’ statement is an assignment statement. It performs calculations and assigns values to memory.
🗑
|
||||
| Atomic Field (DBM) | ...Is the smallest unit of a data base. It cannot be broken into smaller parts. Hence the name ‘atomic’
🗑
|
||||
| Bandwidth | a rate of data transfer, bit rate or throughput, measured in bits per second (bps).
🗑
|
||||
| BASIC | In computer programming, BASIC (an acronym which stands for Beginner's All-purpose Symbolic Instruction Code) is a family of high-level programming languages designed to be easy to use.
🗑
|
||||
| Block (VBA) | A block is a section of code
🗑
|
||||
| Block Control Statement | Block Control Statements are a pair of statements that signify the begging and end of a block (a section of code). Eg. Sub/End sub. The first statement signifies the beginning , the second signifies the end.
🗑
|
||||
| Break point (VBA) | A break point is a feature of Visual Basic editor. A statement that has a break point will suspend just before it would have been executed. Break points can be used to segregate sections of code,
🗑
|
||||
| Call statement | The Call statement runs a procedure
🗑
|
||||
| Cartesian product | The direct product of two sets. The Cartesian Product of two sets X and Y, denoted X × Y, is the set of all possible ordered pairs whose first component is a member of X and whose second component is a member of Y (e.g. the whole of the x–y plane)
🗑
|
||||
| Class (VBA) | A Class is a template for an object. All objects belong to certain classes.
🗑
|
||||
| Class Member (VBA) | A Class member is an object that belongs to a certain class.
🗑
|
||||
| Client | A client is an application or system that accesses a remote service on another computer system, known as a server by way of a network
🗑
|
||||
| Close statement | The Close statement is the second in a pair of statements (Open/Close). After a file no longer needs to be “open”, the close statement “ closes” the file so that it can be used by the next user
🗑
|
||||
| Colour palette | The total number of colours that a given system is able to generate or manage.
🗑
|
||||
| Composite Key (DBM) | A composite Key is a key that consists of two or more attributes that uniquely identify an entity occurrence.
🗑
|
||||
| Computed field (DBM) | A computed field contains a formula that refers to the values of other elements in the data base to calculate its value.
🗑
|
||||
| Const statement | Declares and defines one or more constants
🗑
|
||||
| Control vs. Form | ActiveX controls have more design options. ActiveX controls trigger events while Form controls call macros that have been assigned to them.
🗑
|
||||
| Cookie | A cookie is a piece of text stored on a user’s computer by their web browser. A cookie can be used for authentication, storing site preferences, shopping cart contents, or anything else that can be accoplished through storing text data.
🗑
|
||||
| Data Type (VBA) | In computer programming, a data type is a classification identifying one of various types of data, such as integer, Boolean, or decimal.
🗑
|
||||
| DBM System | A Database Management System (DBM S) is a set of computer programs that controls the creation, maintenance and the use of a database.
🗑
|
||||
| Declaration statements (VBA) | In VBA, a Declaration statement declares both the name and the type of information that will be referred to by that name. Eg. Dim Number As Long.
🗑
|
||||
| Default path (Windows) | When opening or saving a file for the first time, you have to navigate through the hierarchical structure of folders to get to the location that you want to save or open in; this is known as the path. Once created, it becomes the default path.
🗑
|
||||
| Dim statement (VBA) | The Dim statement in VBA is a declaration statement that names both a variable and the type of information to be stored in reference to this name. Eg. Dim Number As Long
🗑
|
||||
| Dot notation (VBA) | Dot notation is a hierarchical structure used to reference the members (properties and methods) of objects. Eg. ActiveCell.Colourindex = 4 – would refer to the Colourindex property of the object ‘Activecell’ and assign it the value of 4.
🗑
|
||||
| Enumeration (VBA) | a data type consisting of a set of named values called elements, members or enumerators of the type. A variable that has been declared as having an enumerated type can be assigned any of the enumerators as a value. eg. the 4 suits in a deck of cards
🗑
|
||||
| Event | In computing, an event is an action that is usually initiated outside the scope of a program and that is handled by a piece of code inside the program. An example, is a ‘mouse-click’ event.
🗑
|
||||
| Event Handler | A function or method containing program statements that are executed in response to an event.
🗑
|
||||
| Excel Table Vs. Excel Data Table | An Excel Table consists of a range of cells with a header row of labels and margins of blank cells or worksheet edges. An Excel Data Table is a built in command that performs either a one way or two way sensitivity analysis.
🗑
|
||||
| Executable statement VBA | Executable statements represent specific instructions to the computer that it can carry out.
🗑
|
||||
| F5 (VBA editor) | Runs through the procedure that the cursor is on until the procedure is finished or it runs into an error
🗑
|
||||
| F8 (VBA editor) | Steps-through each executable statement line by line.
🗑
|
||||
| Field (DBM) | In Database Management columns are referred to as fields.
🗑
|
||||
| File number (VBA) | When a file name is assigned a file number, the file number acts as an alias for the file name in all subsequent input statements
🗑
|
||||
| Flat Data Base | A database that consists of one table
🗑
|
||||
| For/Next statement | A For/Next loop is a repetitive control that executes a block of statements a number of times.
🗑
|
||||
| Foreign key | A foreign key is a field in a table that is a primary key field from another table that it refers to
🗑
|
||||
| Function statement | a function procedure has an assignment (Let) statement in its block of statements that assigns a value to a variable that is the function name.
🗑
|
||||
| GIS | Geographic Information System – A GUI on top of relational data base that has data of geographic elements, features/objects.
🗑
|
||||
| Global variable | A Global Variable is a variable that is accessible in every scope. In Excel there are three levels of variables: 1) The procedural level 2) The module sheet level 3) The workbook level.
🗑
|
||||
| If/End If statement | The If/End If statement is a block control statement. It tests a logical expression that if found to be true, the block is executed. If found to be false the block is skipped.
🗑
|
||||
| Immediate window | The immediate window is a debugging tool that allows you to test out statements in the middle of stepping through a routine.
🗑
|
||||
| Input statement | An input statement reads ASCII files directly into VBA. The input statement reads one word/number/field for each variable name in the variable list. As opposed to the Line Input statement which reads an entire line at a time.
🗑
|
||||
| Instantiate an object | instantiation is the creation of a real instance of an abstraction or template such as a class of objects. For example, defining one particular variation of object within a class, giving it a name, and locating it in some physical place.
🗑
|
||||
| Invoke a procedure | To invoke a procedure is to run a procedure in its entirety. The Call statement invokes a procedure
🗑
|
||||
| Join (Access) | A join is the linking of two or more tables. They can be joined with the use of keys. The primary key of one table will be a foreign key in another. In essence the foreign key is a reference to the other table.
🗑
|
||||
| Let Statement | an assignment statement. Performs a calculation on the right hand side of an equal sign and assigns it to a name (a place in memory) on the left hand side of the equal sign. For example, Let Answer = 2*3 – would assign the value of 6 to the name ‘Answer’.
🗑
|
||||
| Line Input Statement | A line input statement will read a whole line as a single string into a string variable with a given name. For example, Line Input#1, Buffer.
🗑
|
||||
| Long (VBA) | The Long data type stores variables as a long integer (32-bit) numbers ranging in value from -2,147,483,648 to 2,147,483,648
🗑
|
||||
| Macro (VBA) | A macro is a program that executes a sequence of instructions
🗑
|
||||
| Megabyte | 1 million bytes
🗑
|
||||
| Member (VBA) | Objects have members. Members can either be methods (Sub, Function) or Properties (Colour values, dimensions, location, other objects, etc.)
🗑
|
||||
| Method (VBA) | A method is an action that an object can perform (Sub, Function procedures
🗑
|
||||
| Module Sheet | A module sheet is a sheet in Excel that a user can write VBA code on.
🗑
|
||||
| MsgBox vs. dialogue box | A MsgBox is an event that can be defined by the user ( when it pops up and what it says). A dialogue box is an object that is preprogramed into the computer that intitates a conversation between the user and the computer.
🗑
|
||||
| Nanometre | Is a unit of length in the metric system, equal to one billionth of a metre.
🗑
|
||||
| Object (object oriented programming) | An object is any entity that can be manipulated by the commands of a programming language. In object-oriented programming an object is a particular instance of a class.
🗑
|
||||
| Open statement | The open statement readies a file to be read or written into
🗑
|
||||
| Option Explicit statement | Option Explicit statement
🗑
|
||||
| Orbit | Random number generator
🗑
|
||||
| Peer to Peer | Peer to Peer (P2P) computing or networking is a distributed application architecture that partitions tasks or workloads between peers; Resources on one computer are available to other computers without the need for central coordination by host servers.
🗑
|
||||
| Phase space | A phase space is a space in which all possible states of a system are represented, with each possible state of the system corresponding to one unique point in the phase space.
🗑
|
||||
| PI() | PI() is an excel function that returns the number 3.14159..., the mathematical constant pi, accurate to 15 digits.
🗑
|
||||
| Primary key | A primary key in a table is unique indexes that can be used to identify (or index) each record in a table.
🗑
|
||||
| Print statement (VBA) | The Print (?) statement is used in the immediate window. It displays the values of variables produced in a procedure.
🗑
|
||||
| Project Explorer | Project Explorer is the window found on the right hand side of your VB window. It displays a hierarchical list of the projects and all of the items contained and referenced by each project.
🗑
|
||||
| Property (VBA) | A property is a member of an object. Properties can be thought of as attributes of an object. They can consist of values for colour, size, location, and can even be other objects
🗑
|
||||
| Pseudo random number | Pseudo randomness refers to something that appears to be random but in actuality is not. For example the RAND function in Excel only has 2^24 possible numbers it can generate.
🗑
|
||||
| Query (Access) | A query is a description of a selection (in other words, a question). It is displayed graphically as a table but its contents are a compilation of elements from the tables that were selected during the design of the query.
🗑
|
||||
| Raid Storage | Redundant Array of Independent Disks, is a technology that provides increased storage functions and reliability through redundancy.
🗑
|
||||
| Rand() versus rnd() | The rnd() function is a VB function used on a module sheet. The Rand() function is used in the cell of a worksheet. Both functions generate a pseudo random number.
🗑
|
||||
| Range (Worksheet) | A range is a selection of 1 or more cells
🗑
|
||||
| Raster Map | A raster map is a map that is developed using a grid system.
🗑
|
||||
| Record (DBM) | Rows are referred to as records in database management.
🗑
|
||||
| Referential integrity | Referential integrity ensures that all foreign keys refer to an existing record.
🗑
|
||||
| Relation (DBM) | A relation is the “table” or graphical representation that is produced in response to a query. It is a subset of the Cartesian product of all the tables used in generating a query.
🗑
|
||||
| Relational data base | A relational database is a data base that consists of two or more tables.
🗑
|
||||
| Relationships Window (Access) | The relationships window is an interface used to specify relationships between tables in your database.
🗑
|
||||
| Rem statements | The Rem (‘) statement is an non-executable statement that is used to include explanatory remarks (comments) in a program.
🗑
|
||||
| Scope (VBA) | When declaring variables in code, the nature in which it is declared determines the scope in which the variable is available. For variables there are three levels of scope: 1) Procedural level 2) Module sheet level 3) Workbook level.
🗑
|
||||
| Select statement (SQL) | Allows you to select individual fields of subsets of records in a table.
🗑
|
||||
| Set statement | Assigns an object reference to a variable or property.
🗑
|
||||
| Single (VBA) | Single is a data type for variables that you wish to be stored as decimal numbers.
🗑
|
||||
| SQL | Structured Query Language, is a database computer language designed for managing data in relational database management systems.
🗑
|
||||
| Step into (VBA) | Step into (F8) is a debugging feature that allows you to step through your code one statement at a time.
🗑
|
||||
| String (VBA) | String is a data type that allows you to store a variable as text.
🗑
|
||||
| String expression | Any expression that evaluates to a sequence of contiguous characters.
🗑
|
||||
| Sub statement | A sub statement declares the name, arguments, and code that form the body of a sub procedure
🗑
|
||||
| Subscript notation (VBA) | When using arrays the information in brackets after the name of the array are known as subscripts. For example, Test Array(i, j), refers to the location of data in the i’th row of the j’th column in the array named TestArray. i and j are both subscripts.
🗑
|
||||
| Table (access) | A table in access is an object used to store data.
🗑
|
||||
| Text file | A text file is a computer file that contains text (and possible formatting instructions).
🗑
|
||||
| User defined function | a user defined function is a function that the user creates themselves.
🗑
|
||||
| User defined type | When variables of different data types are combined as a single variable to hold several related informations.
🗑
|
||||
| Variable Declaration | A variable declaration is a statement that declares the name and data type (characteristics) of a variable.
🗑
|
||||
| Volatile function | A volatile function is re-evaluated any time any cell on a worksheet is changed or re-evaluated.
🗑
|
||||
| Volatile method | method that is re-evaluated any time the module sheet is recalculated
🗑
|
||||
| Wiki | A wiki is a website that allows the creation and editing of any number of interlinked webpages via a web browser using a simplified markup language.
🗑
|
||||
| Wikipedia | Wikipedia is a free, web-based, collaborative, multilingual encyclopaedia project.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
jrpcleer
Popular Computers sets