Training Series for the Middle-Aged: Spreadsheet Basics

Title	Training Series for the Middle-Aged: Spreadsheet Basics
Course code	CM302-10-2014-C
Objective	Using spreadsheets we can let a computer perform various calculations and make charts, e.g., invoices, receipts, statistics on the quantities of goods, sales charts and etc. On completion the students will be able to use Excel spreadsheets to perform basic calculations and make simple charts.
Content	Create a new spreadsheet Enter text and numbers information into a cell Edit the content of a cell Save and open a spreadsheet Perform addition, multiplication, subtraction and division Calculate the sum and average of a range of cells Format cells: font, size, color, bold, italic, alignment, border, background color Copy, cut, paste and delete cells Insert and delete rows or columns Set column width and row height Print preview Print a spreadsheet Create a simple bar chart
Assessment	The average score of assessment practice in the class must reach 60. The average score of home assignment must reach 60.
Target audience	Elderly people or people who rarely use computers but would like to learn to use spreadsheets. Only will be given to people aged 40 or above.
Prerequisite	Basic operation of computer, such as keyboard and mouse. Or having attended Training Series for the Middle-Aged :Computer Operation & Word Processing create an e-learning account and then do the self-assessment to check.
Class size	12 Full
Instructor	10 years' experience in teachingcomputer in high schools. Macau University of Science and Technology graduate.
Instruction language	Cantonese
Handout language	Handouts in Chinese (traditional)
Duration	18 hours in 6 sessions
Schedule	19:00-22:00, from Oct 7, 2014 to Oct 22, 2014 every Tuesday, Wednesday.
Fee	MOP580
Venue	Cyber-Lab (Rua Comandante Mata Oliveira, Ed. Associacao Industrial, 3-andar Macau)
Certificate	Certificate of Completion/Merit issued by CPTTM (with at least 80% attendance and passed the assessment).
PDAC code	---
Remark	Approved Course under the SAR Government "Continuing Education Development Program", Code: 1405320599 Supporting Unit: Microsoft Macau Students who join this course will automatically grant the right to CPTTM for using their assignments and final projects as course promotion purpose.