A spreadsheet allows you to organize and analyse data by putting it in rows and columns. It also allows you to perform various mathematical computations easily and to create visual graphs.
We will be using Microsoft Excel for this course.
2. Do Basic Practice Activities: These activities will teach you some of the basics. Mr. Aldworth will check to verify that you have completed these. Save each one in your /Spreadsheet folder.
3. Do Graph Activities: These activities will teach you how to turn your tables into a variety of graphs. Mr. Aldworth will verify that you have completed these.
4. Do Assignments 1 and 2 . You will need to submit these to the HandIn folder.
5. Absolute and Relative Cell Referencing: We will go through this as a class. It is an important idea when using formulas and auto-fill.
6. Bonus Assignments: The following 3 activities are optional (unless you are done early). You may complete them and show them to Mr. Aldworth. You may save these bonus marks until later and apply them to something to improve your mark. They may not be applied to the exams or the summative project.
7. There will be a written and practical test for this unit. Make sure you know: