Purchase Solution

Spreadsheets and Charts/Graphs

Not what you're looking for?

Ask Custom Question

Use this spreadsheet template for the Spreadsheet and Charts/Graphs
On the Data worksheet, include the following information in the appropriate columns from the students'
Technology Biography and Self-Assessments
a) Student Last Name
b) Student First Name
c) Years Teaching
d) Proficiency Number (Enter actual number [1, 2, 3, 4, or 5] provided by student)
1) Word Processing
2) Database
3) Spreadsheet
4) Graphics
5) Presentation
6) Internet
7) Computer Instruction
8) Troubleshooting
e) Write formulas to calculate each of the following:
1) Average of each numeric column to two decimal places
2) Median of each numeric column
3) Mode of each numeric column
f) Copy all information on the Data worksheet and place it on the Ascending by LName worksheet
Sort the information in ascending order by last name
g) Copy all information on the Data worksheet and place it on the Descending by FName worksheet
Sort the informatory in descending order by first name
h) On the Graph/Chart Worksheet, create a Clustered Column bar chart displaying the Average of the Proficiency Numbers
Include a title and the legend. On the bar chart legend, change:
1) Word Processing to WP
2) Database to DB
3) Spreadsheet to SS
4) Graphics to GR
5) Presentaton to PR
6) Internet to INT
7) Technology Instructon to TI
8) Technology Troubleshooting to TT
i) On the Graph/Chart Worksheet, under the bar chart, create a 3D pie chart displaying the percentage of numbers assigned in the Computer Instruction column. Include a title and the legend

Purchase this Solution

Solution Summary

This solution constructs examples of spreadsheets and charts/graphs.

Purchase this Solution


Free BrainMass Quizzes
IFSPs, Early Intervention Services

Brief introduction to Individualized Family Service Plans. Do you know the mission of the Early Intervention Program?

Reading Skills

What are some pre-requisites to teach reading? This quiz offers a brief description for a few literacy skils.

Mindfulness Techniques

Incorporating mindfulness techniques throughout all fields is an important area to explore. Many people have experienced trauma and may require assistance to remain calm.

Trauma Introduction

Providing trauma-informed practice is an integral component to providing services to children and families. Understanding the effects of crisis will be beneficial for all fields, including education.

Importance of Exploratory Play for Early Learning

Research indicates that young children require the freedom to safely explore their environment to build cognitive skills. This quiz will introduce some play-based early intervention techniques to promote learning.