ACNT-1313 Computerized Accounting Applications

Christopher O'Donnell

Credit Spring 2026

Section(s)

ACNT-1313-001 (27021)
LEC DIL ONL DIL

LAB DIL ONL DIL

ACNT-1313-002 (27023)
LEC DIL ONL DIL

LAB DIL ONL DIL

Course Requirements

COURSE DESCRIPTION: Use of the computer to develop and maintain accounting records and to process common business applications for managerial decision-making.

COURSE PREREQUISITE: Before enrolling in ACNT 1313, you must have completed ACNT 1311 with a C or better grade (or approval by the instructor or Dr. Reed Peoples). Basic computer skills utilizing internet, word processing, and spreadsheet (Excel) software are recommended for all accounting courses. If you have any questions, consult with an accounting advisor.

COMPUTER HARDWARE AND SOFTWARE REQUIREMENTS: This course will utilize Blackboard & Excel. Students must have access to a computer that has internet capabilities. You will also need to be able to access various internet web sites and online lecture material. Students may obtain Excel 365 for free at https://www.microsoft.com/en-us/education/products/office.

Students will use the BlackBoard learning management system for assignment instructions, submitting some assignments, etc. This course may also utilize analysis tools such as Tableau or Power BI to enrich data analysis skills and demonstrate how it relates to accounting. This software is also provided to students at no cost.

Readings

REQUIRED TEXTBOOK/MATERIALS

Title: Microsoft Excel for Accounting, 2nd Ed., with ebook & eLab ISBN-13: 978-1-64061-310-2

Author: Eric Weinstein

Course Subjects

EXCEL
Ch1 - The Accounting Equation and Recording Journal Entries
Ch2 - Financial Statements
Ch3 - Statement of Cash Flows
Ch4 - Inventory Costing and Analysis
Ch5 - Bank Reconciliation
Ch6 - Depreciation Schedule
Ch7 - Payroll Register
Ch8 - Bond Amortization
Ch9 - Financial Statement Analysis
Ch10 - Budgeting and Cost Analysis

DATA ANALYTICS (DA) PROJECT
Tableau DA Project

Student Learning Outcomes/Learning Objectives

DATA ANALYTICS (DA) PROJECTS
Excel DA Project
Tableau DA Project

Student Learning Outcomes/Learning Objectives

EXCEL

Chapter 1 Display the accounting equation Record journal entries Enter data and numbers in Excel Use Undo and Redo in Excel Print worksheets	Chapter 6 Create a depreciation schedule Create a table Convert a range to a table, and vice versa Use the SLN, SYD, and DDB functions Sort, filter, and analyze table data
Chapter 2 Create an income statement Create a statement of owner's equity Create a balance sheet Alter columns, rows, and text alignment Add, remove, and adjust worksheets	Chapter 7 Create a payroll register Use the ROUND and IF functions Distinguish between absolute cell references and mixed cell references Use VLOOKUP and HLOOKUP functions Improve worksheet layout readability
Chapter 3 Create a statement of cash flows Create formulas in Excel Use cell references in formulas Modify, copy, and correct formulas Find and replace cell contents and formats	Chapter 8 Create a bond amortization schedule Use the PV, FV, and PMT functions Protect worksheet elements Automate processes with macros
Chapter 4 Use functions in formulas to perform calculations and manipulate text Calculate inventory cost under LIFO, FIFO, and weighted average methods Apply data bars to worksheets Create PivotTables	Chapter 9 Perform a vertical analysis Perform a horizontal analysis Calculate financial ratios Create charts Insert and reply to cell comments
Chapter 5 Create a bank reconciliation Create headers and footers in a worksheet Use Format Painter Apply Quick Styles and conditional formatting Import data from multiple sources	Chapter 10 Create cost and purchases budgets Perform a cost-volume-profit (CVP) analysis Freeze rows and columns Split a worksheet window Use Goal Seek Use Solver

DATA ANALYTICS - TABLEAU

Case Learning Objectives

Build and format various visualizations in Tableau (bar, line, packed bubbles, tree map)
Create a Top 10 values filter and context filter
Create a map chart
Build and format an interactive dashboard
Analyze sales data using the dashboard