New User Special Price Expires in

Let's log you in.

Sign in with Facebook


Don't have a StudySoup account? Create one here!


Create a StudySoup account

Be part of our community, it's free to join!

Sign up with Facebook


Create your account
By creating an account you agree to StudySoup's terms and conditions and privacy policy

Already have a StudySoup account? Login here

ACIS 1504 - Test 2 Study Guide

by: Gavin B

ACIS 1504 - Test 2 Study Guide ACIS 1504

Gavin B
Virginia Tech
GPA 4.0

Preview These Notes for FREE

Get a free preview of these Notes, just enter your email below.

Unlock Preview
Unlock Preview

Preview these materials now for free

Why put in your email? Get access to more of this material and other relevant free materials for your school

View Preview

About this Document

This study guide covers the most important ideas for test 2 material. It is very in depth and it helped me get a great grade on the test! Good luck on the test!
Intro to Bus Analytics & BI
Jean M. Lacoste
Study Guide
VT, Virginia Tech, ACIS, 1504, Test 2, Exam 2, business, Analytics
50 ?




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.

Similar to ACIS 1504 at Virginia Tech


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.  


Buy Material

Are you sure you want to buy this material for

50 Karma

Buy Material

BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.


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'

Why people love StudySoup

Steve Martinelli UC Los Angeles

"There's no way I would have passed my Organic Chemistry class this semester without the notes and study guides I got from StudySoup."

Jennifer McGill UCSF Med School

"Selling my MCAT study guides and notes has been a great source of side revenue while I'm in school. Some months I'm making over $500! Plus, it makes me happy knowing that I'm helping future med students with their MCAT."

Bentley McCaw University of Florida

"I was shooting for a perfect 4.0 GPA this semester. Having StudySoup as a study aid was critical to helping me achieve my goal...and I nailed it!"

Parker Thompson 500 Startups

"It's a great way for students to improve their educational experience and it seemed like a product that everybody wants, so all the people participating are winning."

Become an Elite Notetaker and start selling your notes online!

Refund Policy


All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email


StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here:

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.