Students in this unit will work with Microsoft Excel, Access, PowerPoint, the accounting package MYOB and a data analysis Excel add-in, EcStat. These will be used to investigate methods by which business data can be collected, interpreted and accessed in a systematic way. Links between the various packages will be discussed. Power Point will be used to explore ways in which the results of business analysis can be communicated to management for decision making. The unit considers database management, computer based analysis of results/data and report writing. Students will also learn the basics of Web page design using HTML. The final two weeks are devoted to an introduction to the popular business software package, Mind Your Own Business (MYOB).

Topics

• Microsoft Excel
• Summary measures and graphical presentation of data in Excel
• P-values, confidence intervals and hypothesis tests using Excel and EcStat
• Microsoft Access
• Designing a database
• Microsoft PowerPoint
• Setting up Web pages using HTML
• MYOB