DYERSBURG HIGH SCHOOL CURRICULUM

 

Subject:               SPREADSHEET APPLICATIONS                                                                                         _____   Semester            

Grade:                                                                                                                                                                                                    _____   Year

 

 

TOPIC

ESSENTIAL QUESTION

AUGUST

1.   Introduction to Spreadsheet

 

 

 

 

2.  Creating a Simple Worksheet

1.       What are some advantages of using a computerized spreadsheet program?

2.       What kinds of rules would you recommend for mailing files in business?

 

1.       Why can some fields be used as either text or number data types?

2.       How can AutoCalculate help you verify data?

SEPTEMBER

1.   Enhancing a Simple Worksheet

 

 

 

2.  Designing and Printing a Worksheet

1.       What are the functions of a worksheet?

2.       Why must you check formulas if spreadsheet features automatically update formulas?

 

1.       Why is planning critical for the preparation of a worksheet?

2.       How can good documentation of a project benefit you?

OCTOBER

 

 

 

 

 

 

 

 

 

 

 

1.       Copying Data and Using Toolbars

 

 

 

2.       Range Names

 

 

 

 

3.  Spelling/Find/Replace, and File

1.         What are the functions of toolbars?

2.         What are some potential dangers posed by relative cell references when you build a worksheet?

 

1.         What are some possible disadvantages related to using range names and cell names in formulas?

2.         What are the functions of range names and file management tools?

 

1.         Describe a work situation where the replace feature would be useful.

2.         What are some implications of features such as AutoCorrect?

NOVEMBER

 

 

 

1.       Formatting Text and Numbers

 

 

2.  Changing Fonts, Patterns, Colors, and Formats

1.         What are advantages and disadvantages of hiding columns and rows?

 

1.       What is the purpose of gridlines in creating styles?

DECEMBER

 

 

 

1.          Using functions

 

 

2.          Creating Charts and Maps

1.         What is the purpose of nested functions in a spreadsheet?

 

2.         What are the essential components of charts?