100%(3)3 out of 3 people found this document helpful
This preview shows page 34 - 37 out of 61 pages.
There is a difference between influence and trustworthiness ofinformation Reputation Capital o The worth of your reputation – your intentions, capabilities, and values – across communities and marketplaceso How can you aggregate/monitor your reputation?o When we get it right, it will create a massive, positive disruption on who has power,influence and trustCredit history will not be the only ranking of us anymoreReputation will become a currency that will say “you can trust me”StackOverflow...o Platform where experienced programmers can askother experienced programmers highlydetailed questions on things such as tinypixels, etc.80% of these are accurate answers (they have to convince their peers that theyknow what the hell they’re talking about)Svac 19Users were putting their reputation scores on the top of their resumesValue exists beyond the medium from which it was designed
Having a high reputation unlocks a sense of your own power (allows people with real talent to ride to the top) “A good reputation can be used to buy cooperation from others, even people we have never met.” Cases Case 1 Open a new database file using MS Access Create Tables using Table Design View o Create fields, setting field name and data type and descriptions o Designate primary keyo Go through fields and set any validation ruleso Add lookup wizard fieldso Be sure you have common fields among tables for joinsAdd joins using database tools relationships Create forms for each table o Use wizard to get fields in formo Use form design view to add command buttons and calculated fieldsAdd data to tables using their respective form, sometimes data added prior to form development via imports Case 6 ToDo: o Build a table in Datasheet View o Define table relationshipso Create a single table queryo a query in SQL Viewo Create a Multi-Table Queryo Add Calculated Field to Queryo Create a Report using Report WizardCase 10Obtain Payroll Data and Assumptions Format Data for Readability Compute Regular Pay Compute Retirement
Contribution Computer Pay After Pretax Deductions Compute Social Security & Compute Federal Tax Compute Net Pay Generate Statistical summaries Perform Additional Analysis and Data Visualization Flowchart from Tutorial 2A o (Start) [Format Data] [Compute Regular Pay] [Compute RetirementContribution] [Compute Pay after Pre-Tax Deductions] [ComputeSocial Security] [Compute Federal Tax] [Compute Net Pay] [Generate Statistical Summaries] (Stop)Inputso Hours workedo Tax assumptionso Retirement contribution assumptions o Hourly wageOutputso Net PaySvac 20o Taxes (federal and SS)o Retirement contributiono Pay after pre-tax deductions o Regular payCase 13Quarterly and annual projections based on various revenue streams Learn how to create a Basic Budget Model Ultimate Goal is to determine Projected profit and the