Course Descriptions & Syllabi

Course Descriptions & Syllabi

Search Course IDs and descriptions for:

Find complete words only

Note: some or all of the courses in the subjects marked as "Transfer" can be used towards a transfer degree: Associate of Science and Arts or Associate of Engineering Science at DACC. Transferability for specific institutions and majors varies. Consult a counselor for this information.

Areas of Study | | BOFF230 syllabus




COURSE NUMBER: BOFF230
COURSE TITLE:Advanced Spreadsheet Applications
DIVISION:Business
IAI CODE(S):
SEMESTER CREDIT HOURS:3
CONTACT HOURS:60
STUDENT ENGAGEMENT HOURS:135
DELIVERY MODE:Hybrid

COURSE DESCRIPTION:
This course is an advanced course designed to develop skills in maintaining and enhancing worksheets and reports. Students will work in both Microsoft Excel and Google Sheets. Topics include special effects, working with tables and data features, protecting workbooks, data validation, as well as Pivot Tables and Charts. Consolidating data, outlines, macros, analysis tools, collaborating tools, and integrating applications will also be introduced.

PREREQUISITES:
BOFF225

NOTES:

STUDENT LEARNING OUTCOMES:
Upon completion of this course, students will be able to:
  • Understand the functionality of advance formatting and functions.
  • Develop efficient skills with spreadsheet analysis tools.
  • Create professional spreadsheets using advance features to consolidate and summarize data.
  • Develop a mock business report using advance analysis and integration tools.
  • Evaluate spreadsheets for their level of professionalism and functionality.

TOPICAL OUTLINE:
  1. Advanced formatting techniques
  2. Advanced functions and formulas
  3. Working with tables and data features
  4. Creating and working with Pivot Tables
  5. Summarizing data with Sparklines
  6. Performing What-if analysis
  7. Using auditing tools within the workbook
  8. Protecting and sharing workbooks
  9. Creating, running, and managing macros
  10. Customizing the Excel program
  11. Presenting data in a professional manner

TEXTBOOK / SPECIAL MATERIALS:
Benchmark Series – Excel 2016 Level 2
Seguin & Davidson
EMC Paradigm Publishing
SNAP 2016 Access Code

See bookstore website for current book(s) at https://www.dacc.edu/bookstore

EVALUATION:
Quizzes – 20%
Discussion Posts – 10%
Assignments – 25%
Presentation – 15%
Final Project – 30%

The following percentages will be used in determining grades:

90-100% = A

  80-89% = B

  70-79% = C

  60-69% = D

  00-59% = F


BIBLIOGRAPHY:

STUDENT CONDUCT CODE:
Membership in the DACC community brings both rights and responsibility. As a student at DACC, you are expected to exhibit conduct compatible with the educational mission of the College. Academic dishonesty, including but not limited to, cheating and plagiarism, is not tolerated. A DACC student is also required to abide by the acceptable use policies of copyright and peer-to-peer file sharing. It is the student’s responsibility to become familiar with and adhere to the Student Code of Conduct as contained in the DACC Student Handbook. The Student Handbook is available in the Information Office in Vermilion Hall and online at: https://www.dacc.edu/student-handbook

DISABILITY SERVICES:
Any student who feels s/he may need an accommodation based on the impact of a disability should contact the Testing & Academic Services Center at 217-443-8708 (TTY 217-443-8701) or stop by Cannon Hall Room 103. Please speak with your instructor privately to discuss your specific accommodation needs in this course.

REVISION:
Fall 2019

Upcoming Events