Comprehensive Assurance & Systems Tool (CAST) — Computerized Practice Set

Description

For courses in auditing.

An integrated learning opportunity that encompasses financial statement assurance and accounting info systems

Computerized Practice Set for Comprehensive Assurance & Systems Tool (CAST) uniquely exposes students to these issues at The Winery at Chateau Americana, a hypothetical company that is based on an actual domestic winery. Unlike traditional projects and assignments that may offer little to no context, students develop a rich knowledge and understanding of Chateau Americana and its industry as they provide assurance on the company’s financial statements and address a variety of challenging accounting info systems issues. The 4th Edition has been updated in response to changes that have occurred in technology and the field of accounting, so that students have the latest information and tools they need to prepare them for their future careers.

Spreadsheet Applications Using Microsoft^® Excel 2016

1. Learning Objectives
2. Background
3. Download the File
4. Protecting the Data
5. Formula Auditing
6. Data Integrity
7. Simple Data Analysis
8. What-If Analysis
9. Information Needs
10. Macros
11. More Advanced Macros
12. Database Functions
13. Introduction to PivotTable Reports
14. Detail in Reporting
15. Flexible Budgeting Using PivotTables
16. Creating Charts From PivotTables
17. Wrap-Up                                                          

General Ledger Applications Using Sage 50^® 2018

1. Learning Objectives
2. Requirements
3. Setting Up a New Company
4. Setting Up the General Ledger
5. Setting Up Beginning Account Balances
6. Setting Up User Security                                                          
7. Setting Up Accounts Receivable
8. Setting Up Accounts Payable
9. Setting Up Inventory
10. Setting Up Payroll
11. Entering Transactions
12. Transaction Set A
13. Month-End Procedures
14. Year-End Procedures
15. Transaction Set B
16. Transaction Set C                                                     

Database Applications Using Microsoft^® Access 2016              

1. Learning Objectives
2. Background
3. Requirements
4. Creating a New Database and New Table
5. Creating a Form
6. Ensuring Sequential Integrity
7. Creating Relations
8. Integrating Forms within Forms
9. Creating a Query
10. Creating a Report
11. Summary

Hallmark features of this title

• 3 components make up this module: spreadsheets, general ledger software and databases.
• Each component may be completed individually. But, the module is written so that each component strengthens the knowledge learned in the previous one.
• CAST is suited for simultaneous integration across assurance and information systems classes.
• The module can be completed either as an in-class or out-of-class assignment.

New and updated features of this title

• UPDATED: The spreadsheet application is now Excel 2016 and contains additional screenshots and more complete instructions.
• UPDATED: The general ledger package has been updated to the 2018 version of Sage 50 Accounting.
• UPDATED: The database application is now Access 2016 and provides additional screenshots and instructions.

For courses in auditing.

An integrated learning opportunity that encompasses financial statement assurance and accounting info systems

Computerized Practice Set for Comprehensive Assurance & Systems Tool (CAST) uniquely exposes students to these issues at The Winery at Chateau Americana, a hypothetical company that is based on an actual domestic winery. Unlike traditional projects and assignments that may offer little to no context, students develop a rich knowledge and understanding of Chateau Americana and its industry as they provide assurance on the company’s financial statements and address a variety of challenging accounting info systems issues. The 4th Edition has been updated in response to changes that have occurred in technology and the field of accounting, so that students have the latest information and tools they need to prepare them for their future careers.