Be able to articulate how to use the various functionalities in Excel in order to mathematically

calculate values

$$ Be able to articulate how one might use Excel functionality to answer basic business financial

questions like the ones we discussed in class.

$$ Understand the nature of entities, attributes, and relationships; and how they work together to form a

theoretical model of a database

$$ Understand how cardinality and the various relationships $(1$:$1,1$:M$,$ M:N$)$ between entities can be

diagrammed

$$ Understand and be competent in the creation, modification, and diagnosis of potential problems with

entity relationship diagrams.

$$ Understand the various keys in database design and how they interrelate to create a physical model of

a database

$$ Understand and be able to articulate the issues associated with siloed departmental IT infrastructure

$$ Be conversant in the barriers and benefits of centralizing IT infrastructure under an enterprise system

$$ Understand and be able to discuss the means by which professionals manage the construction and

installation of enterprise systems

$$ Understand the principles of scientific management

$$ Understand the various implementation schedules and the conditions under which a custom product

would be preferable to a commercial solution

$$ Understand the pillars underpinning business intelligence and business analytics as well as the

methods these pillars lean on

$$ Be aware, the course is cumulative, so stylized questions from the mid$-$term may also return.