This step-by-step easy to follow lesson includes 4 files which introduces the student to spreadsheets concepts and the basic formulas required to complete spreadsheet exercises.
The exercise teaches the student the following concepts:
a. Basic spreadsheet terminology
b. The SUM formula to add a range of cells
c. The MAX formula to find the highest number in a range of cells
d. The MIN formula to find the smallest number in a range of cells
e. The AVERAGE formula to find the average number in a range of cells
AS WELL AS...
a. the formula for calculating percentages
b. the formula for calculating percentage change
c. How to format a spreadsheet for appearance
d. How to create a simple graph from a calculated spreadsheet
The package includes four files:
1. teacher instructions (created in WORD)
2. Step-by-step student instructions hand-out for the student to complete the exercise (created in WORD which can be edited by the teacher)
3. The Excel answer key for the teacher
4. The Excel downloadable file for the students if the teacher chooses this option,
The Student and teacher instructions contain links to Youtube videos created by the author that assist both the teacher and student in terms of understanding the exercise. Easy-to-use for any student or teacher.
Preview the screen shot of the answer key to this exercise