Excel I

Modules >>
Excel I

Students will need to use Microsoft Excel software to complete this module. Other software may be used if approved by the instructor and arrangements are made as to how to submit the assignment so it is readable by the instructor. The Word I module should be completed before students begin to work on this Excel module, so that a familiarity with formatting is obtained.

Introduction

Excel is a spreadsheet software program by Microsoft. It can be used to perform simple calculations and create student lists, but can also allow users to incorporate advanced formulas and graphics.

In this introductory module, you will learn the basic features in Excel. In addition to using the instructional material provided in this module, students are expected to take advantage of the linked resources provided at the bottom of this webpage. You are encouraged to post any questions to the listserv or email them to the coordinator.

Objectives

In this module, you will create an Excel spreadsheet that includes:

one electronic spreadsheet containing mock student data as shown in the lessons
cells that are formatted using colour and line
font formatted with colour and various sizes and styles
font formatted so that the number of decimal places displayed are consistent
formulas that perform simple calculations (i.e., Average)
absolute referencing to calculate weighted mark
protection so only the spreadsheet creator will be able to change marks

Lesson

Review the following sections by clicking on the links. Please follow the instructions within each section.

Click on these links to review each section

Assignment

Compose an email message addressed to compined@uvic.ca
Include your personal email address in the "Cc" field to send a copy of the message to yourself
The subject line of your email should be the three initials of *your* name followed by a short abbreviation of the module name. For example, Valerie Margit Irvine would use the subject line: VMIexcel1
In the body of the email, identify the computer platform (Mac/Win) and the version of Excel (97, 2000, etc.) you used to create your presentation.
Attach your Excel file to the email. To check that you have met all of the requirements, please review the objectives at the top of this page.
Send the email

Congratulations on completing the fifth module of level one!

Resources

Excel 2002 (Office XP) Tutorial by Microsoft (Windows)
(Download Word doc, 802KB)
http://www.microsoft.com/education/DOWNLOADS/tutorials/ioc/OfficeXP/Excel.doc

Excel 2001 Tutorial by Microsoft (Macintosh)
http://www.microsoft.com/education/downloads/tutorials/classroom/macoffice/Excel.doc

Excel 97 or Excel 2000 Tutorial by Canterbury Christ Church University College (Windows)
http://computing-services.cant.ac.uk/title/onlinetutorials.htm
- Acrobat Reader required to view this .pdf file
- select "Excel" from the drop-down menu to view the tutorial

In and Out of the Classroom with Excel 97 Tutorial by Microsoft (Windows)
http://www.microsoft.com/education/?ID=Excel97Tutorial

Analyzing Data with Excel Tutorial by Microsoft (Windows)
- learn to track student progress
http://www.microsoft.com/education/?ID=ExcelTutorial

Excel 97 Tutorial by Acadia Institute for Teaching and Technology (Windows)
http://aitt.acadiau.ca/tutorials/Excel97/index.htm

Excel Simulation by Acadia Institute for Teaching and Technology (Windows)
http://aitt.acadiau.ca/tutorials/Excel2000/Excel2000simulations/index.htm

Excel Tests by Acadia Institute for Teaching and Technology (Windows)
http://aitt.acadiau.ca/tutorials/Excel2000/Excel2000tests/index.htm

Excel Tutorial by the University of South Dakota
http://www.usd.edu/trio/tut/excel/

Excel Tutorial by Memphis Schools
http://www.memphis-schools.k12.tn.us/admin/tlapages/on-line_excel.htm

To add another resource, please email your suggestion to compined@uvic.ca.