Students in this course will deomstrate advanced level spreadhseet commands and functions to calcuateand manipulate data and to prepare appropriate reports and print outs in text and graphic format.
Submit assignments once you have completed all assignments in each lesson. Print each spreadsheet in landscape showing gridlines and row and column headers. All spreadsheets should print on one page (when possible) - format appropriately. In the footer place your name, lesson, and assignment number. Print the formulas for each assignment (CTRL + ~).
Headphones will be required to complete these activities.
You will find all assignments in the Spreadsheets 2 folder inside the INFO folder on the network (they are Word documents).
Lesson 1 - Review (4 assignments)
To complete the Lesson 1 assignments view the following videos at atomiclearning.com
Excel 2003 - Intro
C. Formulas and Functions
All lessons
F. Formatting Skills
10. Inserting a column or a row
13. Using the merge and center button
G. Borders and Styles
1. Using the borders button
3. Using the fill color button
Excel 2003 – Intermediate
D. Functions
Creating an IF function
Lesson 1 assignments can be found in the INFO folder.
Lesson 2
To complete Lesson 2 ask Mrs. Laturnas for handouts on the VLOOKUP and CHOOSE functions. There are also tutorials available at atomiclearning.com on these topics.
Lesson 2 assignments can be found in the INFO folder.
Lesson 3
Use videos at atomiclearning.com as necessary to complete this assignment.
Lesson 3 assignments can be found in the INFO folder.
Lesson 4
To complete Lesson 4 ask Mrs. Laturnas for handouts on Amoritization Tables.
Lesson 4 assignments can be found in the INFO folder.
Lesson 5
Use videos at atomiclearning.com as outlined in the assignment to complete this lesson.
Lesson 5 assignments can be found in the INFO folder.
The “THIS” Riddle
I can be this, and you can be this. And yes, we can be this. He can’t be this, and she can’t be this. And too, they can’t be this. Dogs can’t be this but cats can. And a kitten can’t be this but a puppy can. Givers can’t be this but beggars can. And humility can’t be this but greed can. Not even peace can be this but fear can.
What is “THIS?”
