ALS 3203 - Lesson 10
Introducing Spreadsheets
Lesson Objectives:
- To Introduce you to a few basic spreadsheet operations (data and formula
entry, cell addresses)
- Learn how to enter formulas into a spreadsheet (this varies with version
of your spreadsheet application).
- Learn how to display formulas in worksheet. Again, this will vary according to your application. Search your program HELP menu for information on any/all of these techniques as you go along.
- Understand the difference between Relative and absolute cell address (see Glossary)
Lesson Tasks:
- Read overview of spreadsheets.
- If this is all new to you, take the time to look at your spreadsheet application
tutorial and help menu to quickly learn some of the basics.
- Fill out and submit Metric
Measurements Conversion spreadsheet (When you do this, your formulas
will be evaluated, but they may not agree with the ones that have been
stored in a grading script, so DO
NOT BE CONCERNERD with your score). There are several ways
to enter the formulas. The grading script will only recognize
one of them, so go ahead and enter your formulas into
designated cells (red borders) to complete the exercise. Be sure
you Do not enter actual values, in formulas, instead use cell
references!
Learn to use the power of a spreadsheet using cell references.
- Reproduce the Metric Conversion Spreadsheet in
MS Excel or another spreadsheet, including all formulas and information
as presented (this means text content, column labels..), and save it to your als3203 folder. Later you will send it to
me as an email attachment. Be sure to name the filewith yourlastname_firstname_lesson10 and
the appropriate filename extension. This means that you will actually
produce a functional spreadsheet with formatted cells.
- When you have finished, be sure to Complete and submit Lesson
Completion Certification
Lesson Resources:
- Introduction to spreadsheets - be sure to look at this
- Glossary of lesson terms - Look at this!
- Web site with Spreadsheet information
Today is:
|
