2017 FALL SEMESTER


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 For Students

LinkedIn Building A Great Student Profile



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


Bull Ring Competition  

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


2017 DECA Pumpkin Contest


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)

IMG 5798IMG 5799

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)

Mandatory Reading Assignment

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!!!

Participation Points


Knowledge Matters On-Line Lessons

Log-In Link Here


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

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

Yahoo! Finance

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

© Andrew Nelson 2012