Search Course IDs and descriptions for:
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
Areas of Study
| BOFF230 syllabus
|COURSE NUMBER: ||BOFF230|
|COURSE TITLE:||Advanced Spreadsheet Applications|
|SEMESTER CREDIT HOURS:||3|
|STUDENT ENGAGEMENT HOURS:||135|
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.
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.
TEXTBOOK / SPECIAL MATERIALS:Benchmark Series – Excel 2016 Level 2
- Advanced formatting techniques
- Advanced functions and formulas
- Working with tables and data features
- Creating and working with Pivot Tables
- Summarizing data with Sparklines
- Performing What-if analysis
- Using auditing tools within the workbook
- Protecting and sharing workbooks
- Creating, running, and managing macros
- Customizing the Excel program
- Presenting data in a professional manner
Seguin & Davidson
EMC Paradigm Publishing
SNAP 2016 Access Code
See bookstore website for current book(s) at https://www.dacc.edu/bookstore
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
|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.|