Candy is Dandy
Author: Patricia Janann Nicholson
Curriculum Area: Instructional Technology
Subject Area: M/J Introduction to Computers
Sunshine State Standard Benchmark:
  • Demonstrate awareness of computer systems, i.e., input, process, and
    output.
  • Identify the functions of basic computer hardware and software and
    peripheral devices.
  • Operate a computer for varied educational purposes.
    • LA.A.2.3.7 synthesize and separate collected information into useful components using a variety of techniques, such as source
      cards, note cards, spreadsheets, and outlines.
    • MA.D.1.3.2 create and interpret tables, graphs, equations, and verbal descriptions to explain cause-and-effect relationships.
    • MA.E.1.3.3 analyze real-world data by applying appropriate formulas for measures of central tendency and organizing data in a quality display, using appropriate technology, including
      calculators and computers.
  • Analyze varied tasks and problems to determine when technology is
    useful and select the appropriate tool(s) and technology resource(s) to
    address those tasks and problems.
    • MA.B.4.3.2 select and use appropriate instruments, technology, and techniques to measure quantities in order to achieve
      specified degrees of accuracy in a problem situation.
    • MA.E.1.3.1 collect, organize, and display data in a variety of forms, including tables, line graphs, charts, and bar graphs, to
      determine how different ways of presenting data can lead to
      different interpretations.
  • Demonstrate awareness of the impact of technology on careers and
    society and the need for its ethical use.
    • LA.D.2.3.6 understand specific ways that mass media can potentially enhance or manipulate information.
    • SC.H.3.3.6 know that no matter who does science and mathematics or invents things, or when or where they do it, the knowledge and technology that result can eventually become available to everyone.
    • SS.A.2.3.3 understand important technological developments and how they influenced human society.
  • Demonstrate awareness of personal and occupational uses of
    computers and other technology.
    • SC.H.3.3.7 know that computers speed up and extend people’s ability to collect, sort, and analyze data; prepare research reports;
      and share data and ideas with others.
Grade Level: 7th MYP & 7th/8th Grade Wheel
Lesson Title: Candy is Dandy
Resources: Nicholson's Lesson Plan Blues
http://pjnicholson.com/mjcomapp/excellassig.htm
Learning Objective:

Students will:

  • enter data in correct cells.
  • format indicated cells according to directions:
    • center alignment
    • bold
    • font color
    • title merged across worksheet
    • highlight applied
  • enter formulas correctly and they are in the assigned cell.
  • create charts and graphs using the chart wizard and all are included in worksheet.
  • use the spell and grammar features in Microsoft Word to correct spelling and grammar errors.
Instructions: Students will follow the instructions provided at Nicholson's Lesson Plan Blues Website.
Assessment http://pjnicholson.com/mjcomapp/lp/excelrubric.htm