Preview Workflow

Viewing: ACC 561 : Database Management in Tax

Last approved: Mon, 28 Aug 2017 12:30:08 GMT

Last edit: Mon, 28 Aug 2017 12:30:06 GMT

Change Type
Major
ACC (Accounting)
561
032479
Dual-Level Course
No
Cross-listed Course
No
Database Management in Tax
Database Management in Tax
Poole College of Management
Accounting (20ACC)
Term Offering
Fall, Spring and Summer
Offered Every Year
Spring 2018
Previously taught as Special Topics?
No
 
Course Delivery
Distance Education (DELTA)
Online (Internet)

Grading Method
Graded/Audit
1
8
Contact Hours
(Per Week)
Component TypeContact Hours
Lecture2.5
Course Attribute(s)


If your course includes any of the following competencies, check all that apply.
University Competencies

Course Is Repeatable for Credit
No
 
 
Kathy Krawczyk
Full Professor
assoc

Open when course_delivery = campus OR course_delivery = blended OR course_delivery = flip
Open when course_delivery = distance OR course_delivery = online OR course_delivery = remote
Delivery FormatPer SemesterPer SectionMultiple Sections?Comments
LEC5050NoAll Distance Learning
R: Graduate Standing or PBS

Is the course required or an elective for a Curriculum?
No
In this course, we will teach the skills needed to understand and identify many aspects of the state income tax apportionment process. Focus will be placed on the calculations and analyses required to present the state and local tax information in such a manner as to assist upper management in the business-expansion decision-making process. The tax apportionment process requires a solid understanding of database management. To assist us in this, we will utilize database management tools that are considered required knowledge by today's tax departments. After a brief review of introductory database management topics, we will focus on more advanced database management topics which will be reinforced with tax-focused examples and assignments specifically created to allow students to see these featured database management topics when applied to tax scenarios. An undergraduate degree and basic tax and accounting knowledge required.

The accounting profession is increasingly requiring its new staff to be up to date on the latest technology.  This is especially true for accounting tax professionals.  This course will provide students a combination of innovative technology skills and comprehensive tax knowledge.


No

Is this a GEP Course?
GEP Categories

Humanities Open when gep_category = HUM
Each course in the Humanities category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

 
 

 
 

Mathematical Sciences Open when gep_category = MATH
Each course in the Mathematial Sciences category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

Natural Sciences Open when gep_category = NATSCI
Each course in the Natural Sciences category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

Social Sciences Open when gep_category = SOCSCI
Each course in the Social Sciences category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

 
 

 
 

Interdisciplinary Perspectives Open when gep_category = INTERDISC
Each course in the Interdisciplinary Perspectives category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

 
 

 
 

 
 

 
 

Visual & Performing Arts Open when gep_category = VPA
Each course in the Visual and Performing Arts category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

 
 

 
 

Health and Exercise Studies Open when gep_category = HES
Each course in the Health and Exercise Studies category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

 
&
 

 
 

 
 

 
 

Global Knowledge Open when gep_category = GLOBAL
Each course in the Global Knowledge category of the General Education Program will provide instruction and guidance that help students to achieve objective #1 plus at least one of objectives 2, 3, and 4:
 
 

 
 

 
Please complete at least 1 of the following student objectives.
 

 
 

 
 

 
 

 
 

 
 

US Diversity Open when gep_category = USDIV
Each course in the US Diversity category of the General Education Program will provide instruction and guidance that help students to achieve at least 2 of the following objectives:
Please complete at least 2 of the following student objectives.
 
 

 
 

 
 

 
 

 
 

 
 

 
 

 
 

Requisites and Scheduling
 
a. If seats are restricted, describe the restrictions being applied.
 

 
b. Is this restriction listed in the course catalog description for the course?
 

 
List all course pre-requisites, co-requisites, and restrictive statements (ex: Jr standing; Chemistry majors only). If none, state none.
 

 
List any discipline specific background or skills that a student is expected to have prior to taking this course. If none, state none. (ex: ability to analyze historical text; prepare a lesson plan)
 

Additional Information
Complete the following 3 questions or attach a syllabus that includes this information. If a 400-level or dual level course, a syllabus is required.
 
Title and author of any required text or publications.
 

 
Major topics to be covered and required readings including laboratory and studio topics.
 

 
List any required field trips, out of class activities, and/or guest speakers.
 

College(s)Contact NameStatement Summary
Poole College of ManagementFrank Buckless
We will use the premium tuition generated to cover the cost of the faculty.

Teach students tax technical content related to state and local tax issues, including apportionment.


Ensure that students understand the power and importance of, and develop proficiency in, utilizing database management skills in the performance of tax analysis.


Student Learning Outcomes

Identify and evaluate many aspects of the state income tax apportionment process.


Utilize intermediate and advanced database management tools to calculate income apportioned to states and develop planning strategies.


Evaluation MethodWeighting/Points for EachDetails
Other50 pointsStudents will be asked to create and import tables related to sales and property into a data management system
Other100 pointsStudents will be asked to import payroll information into a table and develop relationships between the tables for future income tax apportionment to states.
Other100 pointsStudents will be asked to develop queries to calculate apportioned income to each state.
Other100 pointsStudents will be asked to create reports showing apportioned income to each state.
Other100 pointsStudents will be asked to create forms to apportion income to each state.
Other150 pointsStudents will be asked to use queries and forms to evaluate different state income tax strategies.
TopicTime Devoted to Each TopicActivity
Access50%Lecture and videos
State and Local tax apportionment50%Reading and exercises
mlnosbis 4/19/2017:
1) The learning outcomes should be labeled as outcomes, not objectives, in the syllabus to prevent confusion. Objectives are the larger goals for the course, not the measurable outcomes.
2) Assignment breakdown should be listed the same way on the CIM form, instead of 1 assignment for 100% of the grade.
3) Length of course is shown as 6 weeks. The length is 8 weeks for the shorter, not the regular academic, courses. https://studentservices.ncsu.edu/calendars/academic/#fall

pjharrie 5/3/2017 The last outcomes pretty much mirrors the objectives - as Melissa points out, they should actually be different things. Also, no mention of how many times students may resubmit work. If the Q&A discussions are so important, why aren't they part of the course's grade. Something is screwy in the syllabus related to the C and C- grades

mlnosbis 7/27/2017: The evaluation methods should use the same weight or point value on both the syllabus and CIM form. The syllabus lists point values, while the CIM form lists percentages. Choose one method and use that in both places. Everything else has been addressed.

ABGS Reviewer Comments:
-No Comments
krawczyk (Wed, 04 Jan 2017 12:33:02 GMT): Rollback: Changes to description and syllabus as we discussed.
sgallen (Tue, 14 Feb 2017 19:58:16 GMT): Rollback: Needs revisions; see message sent to KK
krawczyk (Mon, 20 Mar 2017 20:02:05 GMT): Rollback: As discussed
krawczyk (Wed, 12 Apr 2017 17:48:25 GMT): Rollback: As discussed
mlnosbis (Thu, 24 Aug 2017 18:13:32 GMT): Syllabus updated as suggested by ABGS
Key: 11220