Content Area: Technological Literacy

 

Index: 8.1A Grade 8 CPI 7

 

Standard:8.1 - Computer and Information Literacy

 

Strand: A - Basic Computers Skills and Tools

 

Cumulative Progress Indicator: 7 - The student will construct a simple spreadsheet, enter data, and interpret the information.

 

Grade: 8

 

Sample Activities:

 

·     A school wide unity day to celebrate diversity is being planned by the school. As part of the celebration, a mini-Olympics will be held. A plan needs to be developed and implemented to include opening exercises, main events, and closing ceremonies. A small budget has been allocated but will need to be supplemented.

 

·     Mr./Ms. Z's company has decided to relocate the employee and the family overseas. The employment opportunities exist in Australia, Brazil, China, Kenya, and Switzerland. Your family must make the decision as to the country of preference with a backup alternative. Provide a justification to the human resource department. Be prepared to negotiate a contract that meets career, financial, and personal needs.

 

·     Create a spreadsheet of students’ running times from physical education class.

 

·     Create a spreadsheet organizing the populations of the counties within the state. Interpret information found by creating a pie chart and bar chart. A modification could be organizing the populations in the school by ethnicity. Interpret information by creating a pie chart or bar chart.

 

·     Student will follow the stock market and show rises and falls on a line graph for a specific stock. This could be coordinated with the social studies teacher/s so students select one blue chip and another stock and follow it for a month, graphing the changes in value. Each student would be assigned a uniform amount to invest like $2000.00.

 

·     Checkbook

 

·     Telemarketing for the “New” Local Phone Company

 

·     Surveying: Can My Input Make a Difference?

 

·     Resources:
Spreadsheet Activities: http://teach.fcps.net/trt10/spreadsheets.htm

      Lesson Plans and Ideas: http://www.manassas.k12.va.us/round/classweb/volz/excelweb/sslplan.htm

      Design Your Own Bedroom: http://cnets.iste.org/students/pf/pf_design_bedroom.html

 

 

 

 

Click on the House to Return to the CD-ROM Home Page

 

New Jersey Core Curriculum Content Standards (NJCCCS)

CD-ROM (Version 1.0)

 

Project done in Cooperation with Newark Teachers Union (NTU) and Seton Hall University (SHU)

Copyright © 2006 - All Rights Reserved

 

For feedback, more information, or recommendations for future versions of this resource,

contact Mitchel Gerry - mg@ntuaft.com or Mike Maillaro - mm@ntuaft.com.

 

Local 481

AFT/ AFL-CIO