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

Class Practice Test Calculations -Univariate Data Analysis

LinkedIn Lessons

LINKEDIN INTRODUCTION: WHY HAVE A PROFILE?

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

LinkedIn Profile Checklist (Good Overview For High School Students)

Build Your Personal Brand on LinkedIn

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)

CTE Business Pathway Calendar 2017-8

FALL FINAL SCHEDULE

Section 1: Bivariate Data Analysis (Wednesday December 6)

#1 Practice Midterm Excel Spreadsheet

#1 Practice Bivariate Midterm PDF Answers Practice Bivariate Midterm PDF

#2 Practice Midterm Excel Spreadsheet

#2 Practice Bivariate Midterm PDF Answers Practice Bivariate Midterm PDF

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)

#1 Basic Probability Rules, Normal Curves, & Expected Value (Stock)

#1 Answers for Basic Probability, Normal & EV (Excel File)

#1 Answers for Basic Probability, Normal & EV (PDF File)

#2 Basic Probability Rules, Normal Curves, & Expected Value (Stock)

#2 Answers for Basic Probability, Normal & EV (Excel File)

#2 Answers for Basic Probability, Normal & EV (PDF File)

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.

Practice Financial Functions Practice Test #1

(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

NEW Financial Functions Practice Exam #2 Questions

Answers Exam #2 EXCEL File Answers Exam #2 PDF Version

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 Practice Test #A5

Practice Financial Functions Test #A5 Annotated Answers

**Practice Financial Functions Test #A5 Answers PDF Format**

Practice Financial Functions Practice Test #A6

Practice Financial Functions Test #A6 Annotated Answers

**Practice Financial Functions Test #A6 Answers PDF Format**

Practice Financial Functions Practice Test #A7

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: Lesson One Lesson Two Lesson Three Lesson Five

Lesson Four Lesson Six Lesson Seven Lesson Eight

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

Past Year Class Notes On Univariate Data Analysis (Excel File)*

Univariate Graphic Display Practice Problems

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

Best of Class Notes - Thank You To Sofia, Victor, Peter & Israel

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 (Excel)

Normal Probability Test Annotated Answers (PDF)

EARN 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.

Progress Grade Dates: TBD

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.

Progress Grade Dates: TBD

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

Section IV Investopedia Reading

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.

Your Web Tools Are Abundant!!

Forex & Stock Trading Library: Chart Patterns

CNBC Stock Screener 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.

Ameritrade Fund Comparison Tool : 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

Video Showing How To Download Historical Stock Price Data

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