Office and Personal Productivity Applications
Course material, tutorials and links
Scroll down for the complete course material and exercises
::: Click here for Video Tutorials and Links:::
Scroll down for the complete course material and exercises
::: Click here for Video Tutorials and Links:::
Course Material
Welcome to the course
Introduction to the unit
The outcomes explained in more detail
Student Learning Record
Form for you recording learning activity each week, briefly maintain each week for record of progress
One Drive and Backing up
Working on the cloud
Sharing work with your lecturer
All work must be backed-up every week and placed into a shared folder
Application Software - Microsoft Word
Basics - Opening and Saving a file
Formatting Text and Paragraph Formatting
Styles
Bullets and Numbering
Working with Columns, including Column Break
Page Break
Graphics, image insertion and controlling image
Tables
Password Protection
Exercises for completion
Assignments - Word Processing with research relating to legislation
Spreadsheets
Exercises and notes relating to Microsoft Excel
Spreadsheet Exercise
Complete the Spreadsheet Exercise below, following each page of the exercise booklet:
Database Exercise
Complete the Database Exercise below, following each page of the exercise booklet:
Files are provided to assist with completion
Files are provided to assist with completion
Security notes
File attributes
Quick back up of folders or files
Antivirus software scan
Pre-assessments ...
Learning Outcome 3 - application software use
Word Processing ... Pre-assessment
Word Processing pre-assessment files including the pre-assessment paper:
Spreadsheets ... Pre-assessment
Spreadsheet pre-assessment files including the pre-assessment paper
Databases ... Pre-assessment
Databases pre-assessment paper
Learning Outcome 2 - security
Pre-assessment paper for Learning Outcome 2, including File Attributes, Backing up, Antivirus software use