2017 FALL SEMESTER

Upcoming CSUN Events - Space is limited so sign up soon, and only pick one choice for now.  Go to survey in Socrative Room GHCDP4 .


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



Section 1: Bivariate Data Analysis

#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



Section 2: Bivariate Discrete Probability/Proportions

Conditional and Marginal Probabilities (Categorical Bivariate Data)

Answers for Conditional & Marginal Probabilities (EXCEL File)

Answers for Conditional & Marginal Probabilities (PDF File)



Section 3: Probability Rules, Normal Probability, Expected Value

#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

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






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 III Excel Vocabulary: 

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

Univariate Graphic Display Practice Problems

Mandatory Reading Assignment

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")

CLASS NOTES ON UNIVARIATE DATA ANALYSIS (Excel File)*

© Andrew Nelson 2012