Sparks Fly
[Home] [PBS VideoDatabase] [Social Studies] [TSU] [UVA]


 Spreadsheets and Graphing

Course Syllabus


1)     Introduction (1/2 hour)

a)     Course objectives and Virginia Standards of Learning

b)     Software terminology/Hardware terminology

2)     Introduction to Spreadsheets (3 hours)

a)     Definition—What is a Spreadsheet?

b)     The software window—menu bars and tool bars

c)      Saving, Viewing, and Printing

d)     Creating Headers and Footers

e)     Using formulas to perform calculations
    i)        Using cell names in formulas
    ii)      Editing entries

f)        Using functions to perform calculations
    i)        Highlighting
    ii)      Filling adjacent cells
    iii)    Relative copying

g)     Formatting a spreadsheet

3)     Planning a Spreadsheet (3 hours)
a)     Entering formulas
b)     Inserting functions
c)      Displaying Formulas
d)     Editing commands
e)     MAX and MIN functions

4)     Expanding a spreadsheet (2 hours)
a)     Absolute copying
b)     Cut, copy, paste
c)      Inserting and deleting rows and columns
d)     Using the IF function

5)     Printing a large spreadsheet (1/2 hour)

6)     Charts (2 hours)
a)     Creating Pie Charts
b)     Selecting, moving, sizing, and deleting charts
c)      Bar and line charts
d)     Modifying a chart
e)     Adding series and labels

7)     Spreadsheet Techniques (2 hour)
a)     What if questions?
b)     Sorting
c)      Text in functions
d)      Freezing Titles
e)      Printing selected areas of a Spreadsheet

8)     Integrating spreadsheets into other applications (1 hour)
a)     Working with multiple files
b)     Copying between files
c)      Copying between word processing and spreadsheet software
d)     Copying a chart into a word processed document
        i)        Copy, paste
        ii)      Copy, paste with links

9)     Creating an integrated lesson plan (3 hour)
a)     Tips and hints
b)     Lesson planning—how to integrate spreadsheets into content

Final Activity—Lesson Plan

Final Hands-on activity—last thirty minutes of class.  Assessment is hands-on and will require demonstration of skills learned in the course.

***This class meets some of the requirements for the Technology Standards for Instructional Personnel.  

This page was updated on:  04/10/02