Syllabus Suggestion

Traditional 16-Week Semester

Microsoft Office 2010

Windows 7, Internet Explorer 8.0, Word, Excel, Access, and PowerPoint

Course Description

This course prepares students to work with Microsoft Office 2010 in a career setting or for personal use. Using courseware that incorporates an accelerated, step-by-step, project-based approach, students develop an introductory-level competency in Word, Excel, Access, and PowerPoint 2010 and explore the essential features of Windows 7 and Internet Explorer 8.0. Students also develop an understanding of key ethical issues they will face in the context of using information technology.

Prerequisites: None

Instructor Contact Information

Name:

Office Phone:

Office E-mail:

Office Location:

Office Hours:

Required Course Resources

  • Marquee Series Microsoft Office 2010 with Windows 7 and Internet Explorer 8.0, by Rutkosky/Seguin/Rutkosky, © Paradigm Publishing Inc.
  • Student Resources CD (provided with textbook)
  • Internet Resource Center,
  • USB flash drive

Computer Time

Approximately six to eight hours per week of computer time outside of class is recommended for successful completion of course requirements.

Grading

Final grades will be calculated as follows:

Average of all Knowledge Check assignments5%

Average of all Skills Review assignments15%

Average of all Skills Assessment assignments20%

Average of all Marquee Challenge assignments20%

Average of all Integrating Skills Review assignments10%

Average of all supplemental activities and/or tests30%

College and Course Policy Information

  • This college conforms to the provisions of the Americans with Disabilities Act. You are invited to report any special needs to your instructor.
  • Your attendance is expected at all class sessions. Excessive unexcused absences may result in withdrawal from the class.
  • We subscribe to the college policy on academic honesty found in the school catalog.

Course Schedule

Week / Class / Program, Section / Lesson Plan File*
1 / 1 / Windows 7, Section 1: Exploring
Windows 7 / Marquee10_Blueprint01_7S1.doc
2 / Windows 7, Section 2: Maintaining Files and Customizing Windows / Marquee10_Blueprint02_7S2.doc
3 / Internet Explorer 8.0, Section 1: Browsing the Internet Using Internet Explorer 8.0 / Marquee10_Blueprint03_IE8S1.doc
2 / 4 / Word, Section 1: Creating and Editing a Document / Marquee10_Blueprint04_WordS1.doc
5 / Word, Section 1: Creating and Editing a Document / Marquee10_Blueprint05_WordS1.doc
6 / Word, Section 2: Formatting Characters and Paragraphs / Marquee10_Blueprint06_WordS2.doc
3 / 7 / Word, Section 2: Formatting Characters and Paragraphs / Marquee10_Blueprint07_WordS2.doc
8 / Word, Section 3: Formatting and Enhancing a Document / Marquee10_Blueprint08_WordS3.doc
9 / Word, Section 3: Formatting and Enhancing a Document / Marquee10_Blueprint09_WordS3.doc
4 / 10 / Word, Section 4: Formatting with Special Features / Marquee10_Blueprint10_WordS4.doc
11 / Word, Section 4: Formatting with Special Features / Marquee10_Blueprint11_WordS4.doc
12 / Test / Marquee10_Blueprint12_Test.doc
5 / 13 / Excel, Section 1: Analyzing Data Using Excel / Marquee10_Blueprint13_ExcelS1.doc
14 / Excel, Section 1: Analyzing Data Using Excel / Marquee10_Blueprint14_ExcelS1.doc
15 / Excel, Section 2: Editing and Formatting Worksheets / Marquee10_Blueprint15_ExcelS2.doc
6 / 16 / Excel, Section 2: Editing and Formatting Worksheets / Marquee10_Blueprint16_ExcelS2.doc
17 / Excel, Section 3: Using Functions, Setting Print Options, and Adding Visual Elements / Marquee10_Blueprint17_ExcelS3.doc
18 / Excel, Section 3: Using Functions, Setting Print Options, and Adding Visual Elements / Marquee10_Blueprint18_ExcelS3.doc
7 / 19 / Excel, Section 4: Working with Multiple Worksheets, Tables, and Other File Formats / Marquee10_Blueprint19_ExcelS4.doc
20 / Excel, Section 4: Working with Multiple Worksheets, Tables, and Other File Formats / Marquee10_Blueprint20_ExcelS4.doc
21 / Integrating Word and Excel / Marquee10_Blueprint21_Integrating1.doc
8 / 22 / Integrating Word and Excel / Marquee10_Blueprint22_Integrating1.doc
23 / Test / Marquee10_Blueprint23_Test.doc
24 / Access, Section 1: Maintaining Data in Access Tables / Marquee10_Blueprint24_AccesS1.doc
9 / 25 / Access, Section 1: Maintaining Data in Access Tables / Marquee10_Blueprint25_AccesS1.doc
26 / Access, Section 2: Creating Tables and Relationships / Marquee10_Blueprint26_AccessS2.doc
27 / Access, Section 2: Creating Tables and Relationships / Marquee10_Blueprint27_AccessS2.doc
10 / 28 / Access, Section 3: Creating Queries, Forms, and Reports / Marquee10_Blueprint28_AccessS3.doc
29 / Access, Section 3: Creating Queries, Forms, and Reports / Marquee10_Blueprint29_AccessS3.doc
30 / Access, Section 4: Summarizing Data and Calculating in Forms and Reports / Marquee10_Blueprint30_AccessS4.doc
11 / 31 / Access, Section 4: Summarizing Data and Calculating in Forms and Reports / Marquee10_Blueprint31_AccessS4.doc
32 / Integrating Word, Excel, and Access / Marquee10_Blueprint32_Integrating2.doc
33 / Integrating Word, Excel, and Access / Marquee10_Blueprint33_Integrating2.doc
12 / 34 / Test / Marquee10_Blueprint34_Test.doc
35 / PowerPoint, Section 1: Preparing a Presentation / Marquee10_Blueprint35_PowerPointS1.doc
36 / PowerPoint, Section 1: Preparing a Presentation / Marquee10_Blueprint36_PowerPointS1.doc
13 / 37 / PowerPoint, Section 2: Editing and Enhancing Slides / Marquee10_Blueprint37_PowerPointS2.doc
38 / PowerPoint, Section 2: Editing and Enhancing Slides / Marquee10_Blueprint38_PowerPointS2.doc
39 / PowerPoint, Section 2: Editing and Enhancing Slides / Marquee10_Blueprint39_PowerPointS2.doc
14 / 40 / PowerPoint, Section 3: Customizing a Presentation / Marquee10_Blueprint40_PowerPointS3.doc
41 / PowerPoint, Section 3: Customizing a Presentation / Marquee10_Blueprint41_PowerPointS3.doc
42 / Review/Catch-up / Marquee10_Blueprint42_Review.doc
15 / 43 / Integrating Word, Excel, and PowerPoint / Marquee10_Blueprint43_Integrating3.doc
44 / Integrating Word, Excel, and PowerPoint / Marquee10_Blueprint44_Integrating3.doc
45 / Review / Marquee10_Blueprint45_Review.doc
16 / 46 / Test Week / Marquee10_Blueprint46-48_Test.doc
47 / Marquee10_ Blueprint46-48_Test
48 / Marquee10_ Blueprint46-48_Test

*Lesson Plan Blueprint files are located on the Instructor Resources disc and the Internet Resource Center.

© Paradigm Publishing, Inc.