- Lower Dauphin School District
- Business
- Excel Certification
High School Curriculum
Page Navigation
- Overview
-
Art
- Fibers
- Sculpture
- Multicultural Art
- Illustration I
- Illustration II
- Illustration III
- Illustration IV
- Digital Photography I
- Digital Photography II
- Digital Photography III
- Digital Photography IV
- Pottery I
- Pottery II
- Pottery III
- Pottery IV
- Wheel Throwing
- Fine Art I
- Fine Art II
- Fine Art III
- Fine Art IV
- AP Art History
- Yearbook
- Independent Study - Art
-
Business
- Computer Applications
- Word Certification
- PowerPoint Certification
- Excel Certification
- Access Certification
- Accounting I
- Accounting II
- Advanced Accounting III
- Careers and Personal Finance
- Business Law
- Marketing
- Sports/Entertainment Marketing
- Co-Op School-to-Work
- Business Internship
- Health Careers
- Independent Study - Business
- English
- Family & Consumer Science
- Foreign Language
- Harrisburg University
- Health & Physical Education
- Library
-
Mathematics
- Applied Math 1
- Algebra 1A
- Algebra 1B
- Algebra 1
- Algebra 2
- Honors Algebra 2
- Geometry
- Honors Geometry
- Functions, Statistics & Trigonometry
- Pre-Calculus & Trigonometry
- Honors Analysis
- Senior Math
- CP Calculus
- AP Calculus AB
- Computer Programming 1
- Computer Programming 2
- AP Computer Science (Computer Programming 3)
- Cyber Security
- AP Statistics
- Advanced Math Topics
- Independent Study - Math
- Music
- Reading
-
Science
- Anatomy & Physiology
- AP Biology
- AP Chemistry
- AP Environmental Science
- AP Physics
- Biology - College Prep
- Biology - General
- Biology - Honors
- Chemistry - CP and Honors
- Disease Detectives
- Earth & Space Science - General, CP, Honors
- Environment & Ecology - General, CP, Honors
- Forensics
- Independent Study - Science
- Keystone Biology Prep
- Keystone Biology Remediation
- Organic Chemistry
- Physical Science
- Physics - College Prep
- Physics - Honors
-
Social Studies
- American Government and Economics
- AP American Government
- American Women
- AP European History
- Contemporary Problems
- HACC - American Civil War
- HACC - Military History of WWII
- HACC - Modern American History
- HACC - The Vietnam War
- History and Sports
- Impact of Social Change in American History through Music and Fashion
- Making History
- Modern World History
- Psychology
- AP Psychology
- Social Justice & Genocide
- Sociology
- Pop Culture
- The American Way of War
- Uncertainty, Revolution & Ideology
- You and the Law
- US History
- AP US History
- World History
- AP World History
- Independent Study - Social Studies
- Technology Education
- STEM
-
Lower Dauphin School District
Curriculum Guide
Course Title: Excel Certification Subject: Business Grade Level(s): 9-12 Synopsis of Curriculum
This course will provide students with a solid understanding of how to use Excel to create documents used by business professionals as well as a strong foundation of using Excel in post high school business programs. This course is a hands-on class that will give students a comprehensive study of Microsoft Excel. Excel topics will range from basic applications to advanced features such as linking files and worksheets, creating charts, working with formulas and functions, and using data and pivot tables. Microsoft Certified Application Specialist text and software will be used throughout the course.
Units of Study Titles
Creating a Worksheet and a Chart
Formulas, Functions, and Formatting
Working with Large Worksheets, Charting, and What-If Analysis
Financial Functions, Data Tables, and Amortization Schedules
Working with Multiple Worksheets and Workbooks
Creating, Sorting, and Querying a Table
Creating Templates, Importing Data, and Working with SmartArt, Images, and Screen Shots
Working with Trendlines, PivotTable Reports, PivotChart Reports, and Slicers