Get the most out of the Teacher Learning Community. Sign in now. Not a member? Click here to get started for free!

COURSE - Using Spreadsheets In The Classroom

$97
Buy Now

Overview

This course discusses electronic spreadsheets and how they might be used in a classroom environment. It provides examples of how spreadsheets can be used as instructional tools, as well as how they can be used to perform administrative tasks. The course also covers how to use a spreadsheet application to create a grade book, including entering, formatting, and sorting data. It discusses functions and how they might be applied in general within the classroom environment and, in particular, how they might be used within a grade book. In this course, functions are used to calculate sums, compute grade point averages, determine the lowest scores, and find the highest scores.

Details

Subject: Integrating Technology In The Classroom
Categories:
Duration: 1 hour
Credit Hours: 1

Contents

  • COURSE - Using Spreadsheets In The Classroom
Introduction - Using Spreadsheets In The Classroom
Contains a course description and a brief overview of the objectives covered in this course.more... 
Why Use Spreadsheets?
Discusses spreadsheets and how they can be used in a classroom environment.more...
Points out some of the administrative tasks that can be performed using spreadsheets.
Covers several ways in which spreadsheets can be used as instructional tools. 
Enter Data In An Excel Grade Book
Discusses why you might want to use a spreadsheet application to create a grade book.more...
Explains how you can create grade books in Microsoft Office Excel.
Shows how to enter class data into Excel grade books. 
Format Grade Book Cells
Explains that formatting cells can make worksheets more readable.more...
Shows how to wrap text so that it is visible on more than one line in a cell.
Demonstrates how to apply bold formatting.
Covers how to enhance readability by applying a fill color as shading.
Applies a number format to selected cells. 
Sort Lists
Steps through sorting data entered in a spreadsheet.more...
Demonstrates how to sort in descending order and in ascending order.
Explores using the Sort dialog box and the Sort buttons. 
Understand Functions
Discusses some of the uses of functions.more...
Explains the structure, or syntax, of functions. 
Calculate Totals Using Functions
Discusses the advantages of using a SUM function.more...
Shows how to insert a SUM function to quickly add a range of numbers.
Covers how to copy that function so that it can be reused in other cells.
Demonstrates how to select a range of cells to add if the SUM function does not select the correct range. 
Calculate Grade Averages
Discusses the Average function and what it does.more...
Illustrates how to calculate student and class grade point averages using the Average function.
Teaches how to change the cell range suggested by Excel. 
Determine Minimum Scores
Describes the MIN function and explains what it might be used for.more...
Demonstrates how to use the MIN function to find the lowest grade in a range of grades.
Covers how to copy and paste the function into other cells. 
Find Maximum Scores
Describes the MAX function and provides examples of when it might be used.more...
Demonstrates how to use the MAX function to find the highest score in a particular range in a grade book.
Covers how to copy that function to other cells, without copying the formatting. 
Workbook - Using Spreadsheets In The Classroom
Contains a printable workbook that includes a list of the lesson names and objectives covered in this course; a variety of real-life examples showing how the ideas and concepts discussed in this course could be used in a classroom, either as teaching tools or administrative aids; and exercises that provide additional practice and reinforcement of the skills and concepts covered in the course.more... 
Quiz - Using Spreadsheets In The Classroom
Assesses the user's knowledge of the concepts covered in the Using Spreadsheets In The Classroom course.more... 
Feedback - Using Spreadsheets In The Classroom
This survey contains six brief questions pertaining to your educational role and computer experience, as well as to how you would rate your knowledge of this subject before and after this course.more...
 

Reviews (3)

Full Member
+6
 
If you're having a technical problem, please see the Help tab (upper right of the toolbar) for FAQs and also the ability to put in a support ticket. We'll be happy to help you! Thank you.
Basic Member
 
Five times baby!!!
Basic Member
 
Nice!
more reviews ...