Mr. Madison's Summer School

Microsoft Excel 2010

Testimonials

• Instructor: Bob Madison
• Prerequisite: None
• Required Software: Microsoft Excel 2010
• Book required! Pay close attention to the ISBNs. NOTE: Do NOT buy both of these books! The CD that comes with the book is NOT the MS Excel software. It contains all of the files you need to complete the projects and assessments in the book. If you do NOT receive the CD, I will provide you with a link to get the files. NOTE: The image of the required book is shown on the left side of this page.
• If you want an actual book, get the following:
• Benchmark Series: Microsoft Excel 2010 Levels 1 & 2 Nita Rutkosky et al, EMCParadigm Publishing.
  ISBN: 978-0-76383-833-1.
• If you want an eBook, get the following:
• Benchmark Series: Microsoft Excel 2010 Levels 1 & 2 Nita Rutkosky et al, EMCParadigm Publishing.
  ISBN: 978-0-76383-067-0.

Required Software

You must have the 2010 version of Microsoft Excel. The MS Office Student Edition comes with:

1. Word 2010
2. Excel 2010
3. PowerPoint 2010
4. Outlook 2010

Microsoft Office 2010 Professional comes with:

1. Word 2010
2. Excel 2010
3. PowerPoint 2010
4. Access 2010 Needed for the continuation course!
5. Outlook 2010 with Business Contact Manager
6. Publisher 2010
7. Accounting Express 2010

Course Content Information

We will cover one chapter per class period from the text book. For each class there will be assessments for the students to do and to submit to me via email. Every four chapters, there will be a performance evaluation which is a timed, open-book set of assessments that will be monitored by a parent. There will be four of these timed performance evaluations.

Level 1 Excel 2010 Topics (Eight Chapters)

• Creating and Manipulating Data
• Formatting Data and Content
• Creating and Modifying Formulas
• Presenting Data Visually
• Collaborating and Securing Data

Level 2 Excel 2010 Topics (Eight Chapters)

• More on Creating and Manipulating Data
• More on Formatting Data and Content
• More on Creating and Modifying Formuals
• More on Presenting Data Visually
• More on Collaborating and Securing Data

When the students finish Excel, they will have used all of the skills necessary to take the official Microsoft Office Specilaist (MOS) exam in Excel. The MOS exam is optional. For more information on certification exams, click here.

How Much Time Will You Spend Per Week in This Course?

This is the most popular question that I get. The honest answer is I don't have a clue. The reason is that all of you are different in the way that you learn. Some of you will need more time than others, and some will need less. But, if I really needed to put an amount of time to this, I would say you will spend 2 to 4 hours per week in this course outside of class.

Hope to "See" you in June! God Bless!