We begin this unit with a record keeping task. Please note that you should choose the task below based on your experience with spreadsheets. Also note that this task is a recommended Portfolio Task and should be prepared for submission.
Work through this MS Excel tutorial, which introduces new users to a spreadsheet program and helps them create a simple mark book to record and store student marks. It looks at basic formatting, calculating the sum and average of a set of numbers, and writing formulas to determine term marks. Make sure you use the names from one of your real classes.
Task 1b [Intermediate]
Creating a Class Mark Book in Excel (2 Hours)
Work through this MS Excel tutorial, which introduces intermediate users of MS Excel to some cool, advanced features to improve your mark book. It includes training in Autofill, AutoFilters, Conditional Formatting, Customising Toolbars and the VLOOKUP function.
120 min |