ACIS 1504 - Test 2 Study Guide
ACIS 1504 - Test 2 Study Guide ACIS 1504
Popular in Intro to Bus Analytics & BI
Popular in Finance
This 5 page Study Guide was uploaded by Gavin B on Wednesday March 2, 2016. The Study Guide belongs to ACIS 1504 at Virginia Polytechnic Institute and State University taught by Jean M. Lacoste in Spring 2016. Since its upload, it has received 296 views. For similar materials see Intro to Bus Analytics & BI in Finance at Virginia Polytechnic Institute and State University.
Reviews for ACIS 1504 - Test 2 Study Guide
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 03/02/16
ACIS 1504 EXAM 2 STUDY GUIDE -‐Data Analytics-‐ Trying to support fact based decision making in a data rich environment. Trying to leverage this data rich environment. Have to have more data. Today we have sales for every day for a long time as well as competitor’s sales versus a while ago when we only had yesterday’s sales. -‐Business Analytics-‐ Doing data analytics just in a business environment. -‐We are working with a much more unorganized data set because we are analyzing a lot of stuff so we need to organize it before we can do stuff with it. -‐Productivity: Want to focus on saving keystrokes. -‐E-‐commerce: Doing business electronically (over the internet or other networks). -‐Long-‐Tail Theory: A company cannot make money just selling the misses but they can by selling them in addition to the high part of the tail. • Example: Movies. Movies on the left are hit movies and movies to the right are the ones that did not quite make it. But you can still make money off of them so maybe if you bought a warehouse or digitized it cheaply then maybe you could afford it to sell it. -‐Balance Sheet: The stuff that we own has to equal the stuff that we owe. Excel Information: • CTRL + Arrow Keys: Jumps cursor to end of block or beginning of next block. • Block = contiguous occupied cells. • Excel Green Triangles: Excel thinks you have made an error for example when SID are put in that begin with a 0 if Excel treated it like a number it would delete the 0 but that 0 is important so you need to treat it like text. • Fill is pattern, copy is single repetition. • Fill: Highlight at least three cells in the pattern. • Copy: Highlight only once cell. • Double-‐click fill handle to fill to bottom of block. • Find. Big Data: • Data sets too large to process with traditional database technology. • True big data is too big to process on your laptop (with Excel). • Is not just big data, it is messy data, it has inconsistent formatting, it comes from a lot of different sources. • Often though when people refer to big data they just mean large data sets. • Big data comes from the internet. • Big data is often processed by special hardware and software and then given to us so we can put it into Excel. • Important because we can use it to analyze things that we never could before. Sources of Data: • Excel Files (xlsx). • Non-‐Excel Files (csv, txt). • Websites. Import: 1. Step 1. a. Delimiter: Is there a character that separates the columns of the data. i. If not, then fixed width. b. See where the sections start. Start import at row X. c. Does data have headers? 2. Step 2. a. Identify the delimiter if that is the option you selected. i. Example: For the name, the name was in quotes but the last and first names were separated by a comma so you need to specify that even though there is a comma there, you want it in one column because it is one idea and it is in quotes so put that in the “text qualifier”. b. If you selected fixed width, you can edit the column width during this step. 3. Step 3. a. This screen lets you select each column and and set the data format. i. General (converts numeric values to numbers, date values to dates, and all remaining values to text), Text, Date, and “Do not import column (skip)”. 4. Step 4. a. File menu, Save as, Save as type= Excel Workbook (*.xlsx). -‐Approach spreadsheet like an IS. Remember SDLC? Test based on Design decisions before you go to Excel. -‐Spreadsheet Implementation: Knowing how to and what is available when using Excel. -‐Spreadsheet Design: Decisions you make prior to implementation. Types of Spreadsheets: • Throw-‐Away Spreadsheets: Use only once. • Reusable Spreadsheet: Use more than once. Lifecycle of a Spreadsheet: • Development Phase: Determine layout, format, functionality, document, and test spreadsheet. • Use Phase: Enter data and produce outputs on a routine basis. Should be longer than development phase. Might also have to make minor modifications to the spreadsheet. All reasonable spreadsheets should be: • Simple. • Clear. • Verifiable. • Accurate. • Efficient. Simplicity: First design goal. Should be quick and easy to maneuver within the workbook. • A. If we only have one idea per column and only one idea per row, it tends to be easier adjusting the spreadsheet (have to be a little flexible on the first few columns when applying this rule). o Ensure each column in the spreadsheet contains data about only one idea. o Each row should also contain data about a single idea. • B. Numbers to be compared should align in columns. o Analyze vertically guideline: Data that will be analyzed as a unit should be placed in columns rather than rows. o Numbers that will be compared most often should be placed in columns (because we scan place value when comparing numbers and performing calculations. Example: Column A has colleges and title of whole worksheet “Median salaries of employed VT grads” and the title is not about colleges. Problem: When you expand the sheet it will still center the title and if it goes to another page it might cut off the title. Fix: You unmerge the title, insert new data, find out where page ends, insert and center title over first page and for each subsequent page. Too much work=bad! So this is not ok. Instead put the title in the header section, if you don’t you are violating simplicity. • Header and Footer: Insert the header but go to “View” and switch back to “normal view” because the header automatically takes you to the print page view. • Transpose: o Select data range and copy. o Select new sheet, then paste special, then transpose. Clarity: Four guideline you should follow to achieve the clarity design goal. 1. Unity: Place data about similar ideas in adjacent cells. 2. Delineation: Visually connect similar items and separate dissimilar items. 3. Order: a. Apply a logical order to rows and columns within unified groups. b. Place groups of cells containing similar ideas in a logical order within the worksheet. 4. Emphasis: Highlight important components. Unity: • Data about similar ideas should be visible in adjacent cells. • Tries to create 3 zones in a worksheet: Headings, Data, and Calculations. Right now we have only learned about the Headings and Data zones. • Important data is accessible with its row and column headings (use Excel Freeze Panes). • Unity can include: o Fonts o Colors o Borders o Number Formats o Freeze Panes o Print Titles • Sometimes need to consider difference when printed vs. online presentation. o Ensure unity is not degraded when printing. o Page breaks can help us. o If group of column or row split across 2 pages, inserting page break at the beginning of the group is the best way to re-‐unify the data. o Freeze Panes has no effect on printed output. “Print Titles” is the Excel feature that allows row and column headings to be printed on each page after the first. Delineation: • Similar items should be visually connected and dissimilar items should be visually separated. • Blank rows and columns within the data tend to degrade the performance of some algorithms included in Excel. When sorting it only sorts up to the blank column and not any data past the blank row or column. • Delineation can include: o Fonts o Colors o Borders o Number Formats o Indent/Wrap o Row Height/Column Width • When you make like things look alike, a lot of the time delineation is already done because by making like things look similar, they already look different from dissimilar things. • Tries to create 3 zones in a worksheet: Headings, Data, and Calculations. Right now we have only learned about the Headings and Data zones. She usually delineates them with three different colors. Within those three zones you might differentiate more things. Order: • A local organization should be applied within and among groups of cells containing related data. • Sort and Custom Sort: o Select whole range before sorting. o If you have only one heading and no subheading then highlight headers if not do not bother. Emphasis: • Encourages us to highlight important components. • Format settings like bold can help. • “Conditional Formatting” allows us to set up the emphasizing format during the development phase even though the important data may not be entered until the use phase.
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'