ITN2785 – Spreadsheets (2785)
Module code
ITN2785
Module title
Spreadsheets (2785)
Prescription
In this module the student will be provided with the skills to plan and design a computer spreadsheet document to solve a business problem. The student will undertake the task of producing a computer spreadsheet file to solve a business problem.
Programmes
- EU7000
- IT1001
- SC0404
NZQA Level
Level 3
NZQA Credits
5
Delivery method
- Not Web enabled
Learning hours
- Directed hours
- 30
- Self directed hours
- 20
- Total learning hours
- 50
Resources required
- Learning Outcomes
- Students will be able to:
- plan and design a spreadsheet
- produce the spreadsheet according to the plan
- evaluate and write a user guide for a spreadsheet - Content
- Spreadsheet Design: write a brief and working plan;
Create Spreadsheets: block design, data entry, formatting, formulas;
Charts: create charts from spreadsheet data;
Templates & Macros: create test and document macros and templates
Quality Control: evaluate spreadsheets, write user documentation. - Teaching and Learning Strategy
- Tutor led discussion on principles and procedures of spreadsheet planning, production and managemnt; practical learning and exercises using step-by-step learning books.
- Learning and Teaching Resource
- Materials: handouts, workbook.
Assessment: written assessment as provided by Wintec