## 2017 FALL SEMESTER

Two practice tests shown above.  Excel file with calculations provided below.

Class Practice Test Calculations -Univariate Data Analysis

LINKEDIN  INTRODUCTION: WHY HAVE A PROFILE?

“Sharespark Media - published on Utube May 2016 - 5:18 in length"

LinkedIn Building A Great Student Profile

Fast Pitch New Venture Competition - November 14, 2017 Late Afternoon (Limit 30)

Semifinals April 3, 2018 (Limit 20x2)      &     Finals April 24, 2018 (Limit 20)

2017 DECA Pumpkin Contest

FALL FINAL SCHEDULE

Section 1: Bivariate Data Analysis (Wednesday December 6)

Review Your Midterm Exam & More Practice

Section 2: Bivariate Discrete Probability (Wednesday December 6)

Conditional and Marginal Probabilities (Categorical Bivariate Data)

Answers for Conditional & Marginal Probabilities (EXCEL File)

Answers for Conditional & Marginal Probabilities (PDF File)

Another Set of Practice Problems From Class Below

Section 3: Probability Rules, Expected Value, Normal Probability (Wednesday December 6)

Section 4: Financial Functions (Day of Finals)

Practice Test Answers December 8 Review  -  For a full explanation of each question type, see practice tests#3-7 below.

(Note Question #4 should be \$7,000 savings, not \$70,000)

Practice Financial Functions Test #1 Annotated Answers

Practice Financial Functions Test #1 Answers PDF Format

Identification of present value (PV), future value (FV), payment (PMT), rate, and number of periods (Nper).  Here's a great example of how to use color coding of the worksheets to help you match the prompts in the question with their correct interpretation.   Financial Function Color Coded Prompt Identification Example

Practice Financial Functions Practice Test #A3

Practice Financial Functions Test #A3 Annotated Answers

Practice Financial Functions Test #A3 Answers PDF Format

Practice Financial Functions Practice Test #A4

Practice Financial Functions Test #A4 Annotated Answers

Practice Financial Functions Test #A4 Answers PDF Format

Practice Financial Functions Test #A5 Annotated Answers

Practice Financial Functions Test #A5 Answers PDF Format

Practice Financial Functions Test #A6 Annotated Answers

Practice Financial Functions Test #A6 Answers PDF Format

Practice Financial Functions Test #A7 Annotated Answers

Practice Financial Functions Test #A7 Answers PDF Format

Section 5 Excel Vocabulary (Day of Finals)

Definitions will match those provided in the hand-outs.  Review all key terms for lessons 1, 2, 3, and 5.  Here's the lists.

Key Terms:

Victor’s Awesome Quizlet For Lessons 1, 2, 3 and 5

Section 6: Univariate Data Analysis (Friday December 1)

Best of Class Notes - Thank You To Alyssa, Victor, Kyla & Hayley

Section 7: Stock Market Data Analysis (Friday December 1) - PERIODS 1, 2 & 4 only

Section 8: Big Data Reading - Chapters 1 - 4 (Friday December 1- Period 3 only)

Section # Normal  Probability Distributions: Population & Sampling

Normal Probability Practice Test

Normal Probability Test Annotated Answers (PDF)

EARN PARTICIPATION POINTS!!!

Participation Points

Knowledge Matters On-Line Lessons

*********************************************************************************

IGNORE BELOW THIS LINE - HOLDING AREA

******************************************************************************************************************************************************************

Activity #1 - All students complete the accounting course.  This knowledge will allow students to better understand our subsequent inquiries into the stock market and  financial functions.

Activity #2  - Period one, two and four students must compete in one of DECA’s Virtual Business simulation competitions (period three students may compete upon request).  Starting preparing to compete now.  Each student should choose one of the business simulations (not Accounting).   Then they should complete all of the lessons and projects as preparation for fall DECA competition.  Assignment points will be awarded periodically.

Final Performance Assessed At End Of VB Round One: 10/24 - 11/3

Section II Describe A Distribution:

Students will be asked to describe the shape, central tendancy, spread, and outliers for a distribution of population data.  Students will be provided data, and a graphic display.  The "Describe A Population Distribution" form below will serve as the answer sheet.     You just need to do what we did in class together and in the assignment where you described the population of sit-up data for the three P.E. teachers.  Be sure you can find outliers by the IQR Method and Standard Deviation Method; and can interprete a SKEW statistic with a computed range.

Describe A Population Distribution Form

Our Starting Point Review From Money & Banking        Investing 101 Lessons         Weekly Company Profiles

Investopedia   Read Guide To Stock-Picking Strategies

For Tuesday, read the following five pages: 1. Introduction, 2. Fundamental Analysis,                 3. Qualitative Analysis, 10. Technical Analysis, and 11. Conclusion.

For Tuesday night homework, read the remaining six pages (#4-9) found in Guide to Stock-Picking Strategies.  There will be Socrative multiple choice questions on the first midterm.

This "search engine" identifies stocks that meet certain metrics. Preset screens apply some common investing strategies: "Solid Stocks, Solid Companies", "S&P Dogs", "High Quality, High Dividends", "Small Cap Value" and "Large Cap Growth”.  Our GHC DECA competitors will use this tool to create their own set of search parameters with high Beta being given considerable weight in the stock selection process.  Select "Create Custom Screen”. Then use the custom search settings available from the drop-down menu.  Go to “Company Overview” from the drop down options to set up Beta screening.

This search engine allows users to input an index ticker symbol, and the engine outputs a chart that compares five similar funds with the input fund.

Motley Fool: You've got to love any financial resource with such a self-depricating domain, fool.com. These guys were one of the first resources that attempted to educate the average investor in terms they could understand.  Originally, they communicated through a radio show and monthly newsletter.  Now they disseminate ther lessons through the web and social media.

YAHOO! Data Mining With Permission

Yahoo! Finance

Section V Big Data:

Chapters One & Two (Open Note) - Notes will be collected for a grade upon completion of this section of the midterm.

Section V Univariate Graphic Displays

The Excel worksheet below includes box plots, dot plots, and stem plots.  Be sure you can do all of the following skills.

BOX PLOTS: Determine shape with or without labels.  Identify the minimum, Q1, median, Q3, and maximum when labels are provided.  Calculate range and Interquartile Range (IQR).  Know how percentile ranks would apply to Q1 (25%), median (50%), and Q3 (75%).   State whether the median is (>, < or nearly = to) the mean.

STEM PLOTS: Identify all of the data values in the distribution.  Find the median.   Identify the shape of the distribution.   State whether the median is (>, < or nearly = to) the mean.

DOT PLOTS: Identify the shape of the distribution.   State whether the median is (>, < or nearly = to) the mean.

Monday Night Pg. 51 to 57

Tuesday Night Pg. 58 to 66 (Stop @ "What Can Go Wrong")

Wednesday Night Pg. 66 to Top of Pg. 71 (Stop @ "Technology Help")

A