MIS 388

Review Areas for Test 1

Chapters 3, 4 & 5

 

 

Following are the areas that I feel are the most important for you to review for the first test.  This list is intended as a guide only and should not be taken to be an all-inclusive list of the material that might appear as a test question.  You may find that the textbook website has tools that would be helpful in your studying.

 

DO NOT SIMPLY LOOK THESE TERMS UP IN THE GLOSSARY AT THE END OF THE TEXT.  You should read and understand the material in the chapter that covers the term/concept if you wish to do well on the test.

 

BE SURE TO BRING A SCANTRON FORM 882-ES AND PENCIL WITH YOU TO THE EXAM.

 

I.  From the Textbook and/or lecture notes: (I will not ask any specific questions about the companies described in the “Real World Cases”)

 

Personal computer, microcomputer, mainframe

Components of a computer

Network server

LAN (local area network)

PDA (personal digital assistant)

Arithmetic logic unit

Control unit

Primary storage

Secondary storage

Pointing stick

Optical scanning

MICR (magnetic ink character recognition)

Kilo, mega, giga, tera, peta, exa

Bits, bytes

Radio frequency identification

Custom software versus off-the-shelf

Application software

System software

Groupware

Multitasking versus multiprocessing

Compiler

Higher level programming languages

Data hierarchy

Database

hierarchial and relational database

data administration

database administration

operational database

internal and external databases

distributed databases

data mart and data warehouse

DBMS (database management system)

 

II.  From Lab:

VLOOKUP

Data validation

Comments

Autofill handle

Copy and paste

Conditional formatting

Microsoft Access