ACNT-1313 Computerized Accounting Applications

Christopher O'Donnell

Credit Fall 2025

Section(s)

ACNT-1313-002 (26609)
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) PROJECTS
Excel DA Project
Tableau DA Project

Student Learning Outcomes/Learning Objectives

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) 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 - EXCEL

Case Learning Objectives

  1. Create and format pivot tables and charts
  2. Create slicers to filter pivot table data
  3. Build an interactive dashboard in Excel
  4. Analyze sales data using the dashboard

Excel Learning Objectives

  1. Create a table
  2. Create a pivot table and chart
  3. Insert a slicer
  4. Link and unlink slicers to pivot tables and charts
  5. Filter pivot tables
  6. Add the camera tool to Excel
  7. Create dynamic screenshots with the camera tool
  8. Format chart titles
  9. Create a dashboard

DATA ANALYTICS - TABLEAU

Case Learning Objectives

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

Office Hours

Office Hours

Published: 06/26/2025 19:58:45