Blue's Cafe

Author: Patricia Janann Nicholson
Curriculum Area: Instructional Technology
Subject Area: Computer Applications II
Sunshine State Standard Benchmark:
  • Demonstrate the use of sequential and logical planning to describe the tasks, resources, and timelines necessary for the completion of specified projects.
  • Demonstrate appropriate use of varied input and output devices, and awareness of file management and transfer concepts.
  • Set up a spreadsheet file; organize, analyze, and manipulate collected data; and produce reports for specified projects.
    • MA.D.1.4.1-describe, analyze, and generalize relationships, patterns, and functions using words, symbols, variables, tables, and graphs.
    • MA.D.1.4.2-determine the impact when changing parameters of given functions.
    • MA.E.1.4.3-analyze real-world data and make predictions of larger populations by applying formulas to calculate measures of central tendency and dispersion using the sample population data and using appropriate technology, including calculators and computers.
  • Set up several types of database files; organize and analyze collected data; and produce reports for specified projects.
    • LA.B.2.4.2-organize information using appropriate systems.
    • MA.E.1.4.1-interpret data that has been collected, organized, and displayed in charts, tables, and plots.
  • Demonstrate the use of graphics programs for specified projects.
    • LA.D.2.4.3-recognizes production elements that contribute to the effectiveness of a specific medium.
    • LA.D.2.4.4-effectively integrate multimedia and technology into presentations.
    • VA.A.1.4.2-use tools, media, processes, and techniques proficiently, knowledgeably, and in a safe and responsible manner.
  • Demonstrate effective access strategies and appropriate use of the Internet and electronic communications to gather and share information used in specified projects.
    • LA.A.2.4.6-select and use appropriate study and research skills and tools according to the type of information being gathered or organized.
  • Demonstrate the use of productivity and multimedia tools and peripherals to support personal effort, group collaboration, and learning throughout the curriculum for specified projects.
    • LA.B.2.4.4-select and use a variety of electronic media, such as the Internet, information services, and desktop-publishing software programs, to create, revise, retrieve, and verify information.

 

Grade Level: 9th-12th
Lesson Title: Blue's Cafe
Resources: Nicholson's Lesson Plan Blues:
http://neighbor.firn.edu/class/palm_beach/pahokee_ms/patricia_janann_nicholson/bluescafe/excellesson.htm
Learning Objective:

Students will:

  • become acquainted with supply and demand terminology.
  • make decisions on real life simulations that you that will directly influence the cash flow of their lemonade/hot chocolate business.
  • keep track of their daily expenditures and revenues on a daily log sheet for twenty-one days.
  • take this data and enter it into a Microsoft Excel spreadsheet where mathematical formulas will be entered to determine their profit or losses.
  • generate charts and graphs in Excel that will reflect the business operations for the twenty-one days.
  • create a Power Point presentation that will reflect what they learned from this business venture in order to help other young business entrepreneurs.
    • utilize their charts and graphs created in Excel.
    • include appropriate graphics.
    • include custom animation.
    • include slide transitions.
    • include timing so slide show will run automatically.
    • evaluate peers Power Point and offer feedback.

 

Instructions: Students will follow the instructions provided at Nicholson's Lesson Plan Blues Webpage. Finished product will included items listed in the grading rubric listed below.
Assessment Grading Rubric