Limited time offer 20% OFF StudySoup Subscription details

Virginia Tech - ACIS 1504 - Chapter 6 -10 - Study Guide

Created by: Dena Notetaker Elite Notetaker

> > > > Virginia Tech - ACIS 1504 - Chapter 6 -10 - Study Guide

Virginia Tech - ACIS 1504 - Chapter 6 -10 - Study Guide

School: Virginia Polytechnic Institute and State University
Department: Accounting
Course: Intro to Bus Analytics & BI
Professor: Eric Martin
Term: Fall 2016
Tags:
Name: Chapter 6 -10
Description: This study guide covers all of the lectures on exam #2
Uploaded: 10/29/2017
0 5 3 84 Reviews
This preview shows pages 1 - 3 of a 8 page document. to view the rest of the content
background image   ACIS Intro to BA and BI  Exam​ ​#2  INSTRUCTOR:​ ​Eric​ ​Martin  Chapters​ ​6-10     Chapter​ ​6  Verifiability  Easy​ ​to​ ​understand  Range​ ​names​:​ ​are​ ​absolute​ ​references​ ​=​ ​always​ ​refer​ ​back​ ​to​ ​the 
specific​ ​cells​ ​you​ ​defined 
Metadata:​​ ​Cell​ ​Comments   No​ ​errors   Data​ ​Validation​ ​feature:​ ​​allows​ ​you​ ​to​ ​specify​ ​rules​ ​limit​ ​data​ ​entry​ ​to 
reasonable​ ​values​ ​(only​ ​on​ ​data​ ​cells) 
Don’t​ ​make​ ​rules​ ​too​ ​restrictive  Data​ ​Validation​ ​decisions:   Which​ ​data​ ​cells​ ​may​ ​require​ ​data​ ​validation?​ ​(​all​ ​data​ ​entry 
cells​​ ​should​ ​be​ ​good​ ​candidates,​ ​​not​​ ​on​ ​headings, 
calculations...)  
What​ ​rules​ ​can​ ​I​ ​establish​ ​to​ ​identify​ ​incorrect​ ​data?  Is​ ​this​ ​rule​ ​accurate​ ​100%​ ​of​ ​the​ ​time?  What​ ​should​ ​my​ ​error​ ​message​ ​be?​ ​(must​ ​be​ ​descriptive)  Either​ ​1)​ ​set​ ​up​ ​rules​ ​that​ ​validate​ ​100%​ ​of​ ​your​ ​data​ ​OR​ ​2)​ ​specify​ ​the 
data​ ​validation​ ​error​ ​message​ ​style​ ​as​ ​a​ ​warning​ ​message​ ​so​ ​it​ ​alerts 
you​ ​but​ ​you​ ​can​ ​continue 
Warning​ ​DV​ ​type​ ​allows​ ​for​ ​“bad”​ ​data​ ​to​ ​be​ ​entered​ ​only​ ​after​ ​asking 
the​ ​user​ ​if​ ​they​ ​want​ ​to​ ​proceed 
Information​ ​DV​ ​type​ ​also​ ​allows​ ​for​ ​entering​ ​of​ ​“bad”​ ​data​ ​but​ ​is 
merely​ ​an​ ​information​ ​message 
  1  
background image       DV​ ​rules​ ​only​ ​apply​ ​to​ ​the​ ​answering​ ​of​ ​new​ ​data,​ ​pre​ ​existing​ ​bad 
data​ ​does​ ​not​ ​trip​ ​the​ ​rule​ ​(circle​ ​invalid​ ​data) 
Protection-​​ ​turn​ ​on​ ​and​ ​entire​ ​worksheet​ ​will​ ​be​ ​frozen,​ ​restricts​ ​entry 
into​ ​cells​ ​containing​ ​headings​ ​and​ ​calculations  
1st-​ ​Unlock​ ​data​ ​entry​ ​cells​ ​(cell​ ​formating)  2nd-​ ​Turn​ ​on​ ​sheet​ ​protection  After​ ​both​ ​steps​ ​are​ ​completed,​ ​data​ ​can​ ​be​ ​changed​ ​but​ ​non 
data​ ​entries​ ​cannot​ ​be​ ​changed​ ​and​ ​a​ ​warning​ ​message​ ​will 
alert​ ​you  
One​ ​of​ ​the​ ​last​ ​steps​ ​performed​ ​in​ ​the​ ​developmental​ ​phase 
since​ ​it​ ​limits​ ​design​ ​changes  
​ ​Worksheet​ ​Protection​ ​Decisions:  Which​ ​cells​ ​require​ ​protection?​ ​Headings​ ​and 
calculations 
Which​ ​cells​ ​need​ ​to​ ​be​ ​unlocked?​ ​Data​ ​cells   Chapter​ ​7   Data​ ​Mining:​​ ​predictive​ ​analytics​ ​(Insurance​ ​Industry)  Software​ ​that​ ​searches​ ​vast​ ​amount​ ​of​ ​data  Use​ ​complex​ ​statistical​ ​calculations   Outputs:​ ​Trends,​ ​Patterns,​ ​Correlations,​ ​Exceptions  Implementing​ ​Accuracy  Six​ ​steps  1.​ ​Know​ ​the​ ​order​ ​of​ ​operations  2.​ ​Select​ ​the​ ​correct​ ​function​ ​or​ ​correct​ ​formula   3.​ ​Choose​ ​a​ ​function​ ​over​ ​formula​ ​whenever​ ​possible  4.​ ​Isolate​ ​Assumptions  5.​ ​Check​ ​mixed,​ ​relative,​ ​and​ ​absolute​ ​cell​ ​references  6.​ ​Double​ ​check​ ​all​ ​calculations  Formulas:​​ ​Calculations​ ​created​ ​by​ ​you   Functions:​​ ​Predetermined​ ​calculations​ ​created​ ​by​ ​microsoft   Common​ ​Functions:​​ ​SUM,​ ​AVERAGE,​ ​MIN​ ​and​ ​MAX,​ ​COUNT​ ​and 
COUNTA**(applied​ ​exam​ ​question​ ​between​ ​COUNT​ ​and​ ​COUNTA) 
 
background image       COUNT=just​ ​numeric​ ​values,​ ​COUNTA=​ ​will​ ​count​ ​all​ ​non-blank 
cells(text​ ​or​ ​numeric) 
Function​ ​Vs.​ ​Formula  Functions​ ​are​ ​more​ ​flexible​ ​than​ ​the​ ​equivalent​ ​formula  Use​ ​the​ ​function​ ​instead​ ​of​ ​building​ ​a​ ​formula​ ​if​ ​one​ ​exists   Functions​ ​tend​ ​to​ ​adjust​ ​more​ ​accurately​ ​to​ ​spreadsheet​ ​modifications​ ​than 
formulas  
Isolating​ ​Assumptions:​​ ​storing​ ​the​ ​numbers​ ​in​ ​a​ ​calculation​ ​separately​ ​from​ ​the 
equation​ ​in​ ​cells  
Relative,​ ​Absolute​ ​and​ ​Mixed​ ​Cell​ ​References​ ​(on​ ​exam​ ​a​ ​lot)  Check​ ​relative​ ​and​ ​absolute​ ​cell​ ​references​ ​whenever​ ​formulas​ ​or​ ​functions 
are​ ​copied 
Three​ ​ways​ ​to​ ​refer​ ​to​ ​a​ ​cell​ ​in​ ​an​ ​equation  1.​ ​Relative  2.​ ​Absolute  3.​ ​Mixed  Relative​ ​cell​ ​references​​ ​=​ ​may​ ​change​ ​when​ ​a​ ​calculation​ ​is​ ​copied  Default​ ​in​ ​excel   Absolute​ ​cell​ ​references​​ ​=​ ​will​ ​not​ ​change​ ​when​ ​a​ ​calculation​ ​is​ ​copied  Have​ ​“$”​ ​before​ ​row​ ​and​ ​column​ ​name   Mixed​ ​cell​ ​references​​ ​=​ ​only​ ​the​ ​character​ ​with​ ​“$”​ ​in​ ​front​ ​of​ ​it​ ​may​ ​change​ ​when 
calculation​ ​is​ ​copied 
Either​ ​the​ ​row​ ​or​ ​column​ ​may​ ​have​ ​a​ ​“$”​ ​in​ ​front​ ​of​ ​it    

This is the end of the preview. Please to view the rest of the content
Join more than 18,000+ college students at Virginia Polytechnic Institute and State University who use StudySoup to get ahead
8 Pages 66 Views 52 Unlocks
  • Better Grades Guarantee
  • 24/7 Homework help
  • Notes, Study Guides, Flashcards + More!
Join more than 18,000+ college students at Virginia Polytechnic Institute and State University who use StudySoup to get ahead
School: Virginia Polytechnic Institute and State University
Department: Accounting
Course: Intro to Bus Analytics & BI
Professor: Eric Martin
Term: Fall 2016
Tags:
Name: Chapter 6 -10
Description: This study guide covers all of the lectures on exam #2
Uploaded: 10/29/2017
8 Pages 66 Views 52 Unlocks
  • Better Grades Guarantee
  • 24/7 Homework help
  • Notes, Study Guides, Flashcards + More!
Join StudySoup for FREE
Get Full Access to Virginia Tech - ACIS 1504 - Study Guide - Midterm
Join with Email
Already have an account? Login here
×
Log in to StudySoup
Get Full Access to Virginia Tech - ACIS 1504 - Study Guide - Midterm

Forgot password? Reset password here

Reset your password

I don't want to reset my password

Need help? Contact support

Need an Account? Is not associated with an account
Sign up
We're here to help

Having trouble accessing your account? Let us help you, contact support at +1(510) 944-1054 or support@studysoup.com

Got it, thanks!
Password Reset Request Sent An email has been sent to the email address associated to your account. Follow the link in the email to reset your password. If you're having trouble finding our email please check your spam folder
Got it, thanks!
Already have an Account? Is already in use
Log in
Incorrect Password The password used to log in with this account is incorrect
Try Again

Forgot password? Reset it here