Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

MIS Exam Three Study Guide - Introduction to Problems Solved and Programming | MIS 304, Study notes of Introduction to Business Management

The University of Texas at AustinIntroduction to Business Management
Prof. Kathryn L. Gray

MIS Exam Three Study Guide Material Type: Notes; Professor: Gray; Class: INTRO PROB SOLV & PROGRAMMING; Subject: Management Information Systems; University: University of Texas - Austin;

Typology: Study notes

2011/2012

Uploaded on 05/13/2012

nehageereddy
nehageereddy 🇺🇸

1 document

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
MIS 304: Exam Three Study Guide
Ch. 10: “Arrays and Structures – Organizing Data”
Not on the Exam:
Binary Search (Pages 392-395)
Sorting an Array (Pages 395-406)
Terms:
Array
Element
Index
Member
Populate
Structure
Subscript
Two-dimensional array
Zero-based
Concepts:
An array is a series of related variables.
All variables in an array share a common name and data type.
Array variables are distinguished by their index. The unique number for each element in an array is called a
subscript.
Arrays are zero-based.
All arrays must be declared before they can be used.
Arrays are easily manipulated with loops.
Arrays can be populated from a file or through user input.
An array can be resized at any time using ReDim. However, unless you use the Preserve keyword, the
existing data will be lost when you resize the array.
A two-dimensional array works well for sets of related data.
Structures are similar to records in a database – they store multiple types of related data in a single
container. Unlike arrays, the data types in a structure do not have to be the same.
A structure MUST be declared outside of other subs, functions and event handlers.
Use s as the prefix for a structure to make recognition easier.
An array of type structure can be used to work with multiple records.
Programming Requirements:
Be able to declare an array with a specified number of elements. Remember that array indexes start at zero,
so Dim intNumberTransactions(10) as Integer will actually give you 11 elements.
Be able to populate an array with values, either from InputBoxes or from values given in the instructions.
Be able to use an array that has been populated with values.
Be able to use the GetLowerBound, GetUpperBound and Length methods to determine the size of
an array.
Be able to use a loop and array(s) to perform a linear search (start at the first record to see if it matches). Be
able to notify the user if a match is not found.
Be able to create, populate and read from 2 dimensional arrays. You do NOT need to know how to use
arrays with 3+ dimensions.
Be able to declare, populate and use a structure.
Be able to declare, populate and use arrays of structures.
pf2

Partial preview of the text

Download MIS Exam Three Study Guide - Introduction to Problems Solved and Programming | MIS 304 and more Study notes Introduction to Business Management in PDF only on Docsity!

MIS 304: Exam Three Study Guide

Ch. 10: “Arrays and Structures – Organizing Data”

Not on the Exam: Binary Search (Pages 392-395) Sorting an Array (Pages 395-406) Terms: Array Element Index Member Populate Structure Subscript Two-dimensional array Zero-based Concepts: An array is a series of related variables. All variables in an array share a common name and data type. Array variables are distinguished by their index. The unique number for each element in an array is called a subscript. Arrays are zero-based. All arrays must be declared before they can be used. Arrays are easily manipulated with loops. Arrays can be populated from a file or through user input. An array can be resized at any time using ReDim. However, unless you use the Preserve keyword, the existing data will be lost when you resize the array. A two-dimensional array works well for sets of related data. Structures are similar to records in a database – they store multiple types of related data in a single container. Unlike arrays, the data types in a structure do not have to be the same. A structure MUST be declared outside of other subs, functions and event handlers. Use s as the prefix for a structure to make recognition easier. An array of type structure can be used to work with multiple records. Programming Requirements: Be able to declare an array with a specified number of elements. Remember that array indexes start at zero, so Dim intNumberTransactions(10) as Integer will actually give you 11 elements. Be able to populate an array with values, either from InputBoxes or from values given in the instructions. Be able to use an array that has been populated with values. Be able to use the GetLowerBound, GetUpperBound and Length methods to determine the size of an array. Be able to use a loop and array(s) to perform a linear search (start at the first record to see if it matches). Be able to notify the user if a match is not found. Be able to create, populate and read from 2 dimensional arrays. You do NOT need to know how to use arrays with 3+ dimensions. Be able to declare, populate and use a structure. Be able to declare, populate and use arrays of structures.

Ch. 12: “Objects and Classes – Objects Are in a Class By Themselves”

Terms: Base (parent) class Business Logic Tier (controller) Data Tier (model) Derived (child) class Encapsulation Exposed Inheritance Instance property Instantiate Methods Object (instance of a class) Presentation tier (view) Property Shared property Concepts: There are three tiers in most business applications. This architecture is sometimes referred to as a model- view-controller pattern. The presentation (view) tier contains all the logic for interacting with the user (controls on the form, etc.). The business logic (controller) tier contains all of the logic related to business rules (calculations, workflows, etc.). The data (model) tier contains all of the logic related to reading, writing, updating and deleting data (presumably in a database). Object-oriented programming creates a “filing system” for your code, which allows you to separate code into the three tiers. This is useful, since most IT professionals are more skilled with some tiers than others. When the code is separated in this way, it is easy for subject matter experts to work on separate pieces of the code. Classes can be exposed in several ways, using Public, Private, and Friend. Classes have properties that are used to store data. Property values are stored (written) with a Set command and accessed (read) with a Get command. When a property is ReadOnly, there is a Get with no Set. When a property is WriteOnly, there is a Set with no Get. An instance property is a property where each object created from the class has a separate occurrence of the property. A shared property is a property that is used by all instances (objects) of a class. Only one copy of a shared property exists for all instances (objects) of the class. Shared properties are generally used for counters and accumulators. Class methods are similar to procedures (subs) and functions. Instantiation creates a new instance of a class. Classes must be instantiated before they can be used. (Put the pig on the farm!) All classes should be documented so a programmer can figure out how to use them. Programming Requirements: Be able to define a custom class and create all the required parts (properties and methods). Be able to use an existing user-defined class when given the class definition. You should be able to instantiate the object, call a method and use a property.