CST 134 - Microsoft Office

Here is where you will find information related to the class. Course documents can be accessed by using the links to the left. As the course progresses, this webpage is where I will post Powerpoints, lectures notes, assignments, and any other information relevant to the class.

Links to the lectures and assignments will be made active after they have been discussed in class.

If you have questions about the class, check out the syllabus or drop me an email. (link below)

Course Description: Surveys small computer systems used for personal, business, and industrial applications including hardware, software, and operating systems. Uses MS Office for word processing, spreadsheets, and database software as well as the evaluation and selection of systems. Credit may be earned in CST 134 or CIS 120, but not both.

To view the course objectives - click here.

Course Presentations, Lecture Notes, etc.

** This is a tentative schedule of class activities. Instructor reserves the right to make changes as course work dictates.

** Exam dates: Word Exam 9/20, Excel Exam 10/25, Access Exam 11/20

Speedlinks: (Choose Week)

Wk1, Wk2, Wk3, Wk4, Wk5, Wk6, Wk7, Wk8, Wk9, Wk10, Wk11, Wk12, Wk13, Wk14, Wk15, Wk16

Week 1 - 8/28 and 8/30

• Reading - Basics, Word Lesson 1, and Word Lesson 2
• Assessment Tracking Sheet (Template link)
• Class 1 - Course Introductions, Basics, MS Word
• Course Introductions, Syllabi, etc.
• Unit 0: Microsoft Windows XP, Vista, Internet Explorer
  Exploring Windows XP (PDF 1) (PDF 2)
  • Browsing the Internet Using Internet Explorer 7.0 (PDF)
  • Resources
• Class 2 - MS Office Word
• Unit 1: Microsoft Word - Basics
  • Section 1: Creating and Editing a Document - pg. 1-24 (PDF)
  • Activities:
    • Review #1, pg. 26, Formating a Hawaiian Specials Document
    • Assessment #2, pg. 28, Writing a Letter
    • Challenge #2, pg 30, Editing and Formatting a Travel Document
• Homework:
  • Finish section assignments.
  • Start working on your Autobiographical Paper (link) Due 9/18
• Resource Links:
  • Microsoft Word 2007 Online Courses
  • Word 2003 to Word 2007 Command Reference
  • Tutorialized (MS Word Formatting and Other)

Week 2 - 9/6

• No class, Tuesday (Labor Day Holiday - Have Fun!)
• Class 3 - Continue MS Word Activities
• Unit 2: Microsoft Word - Features
  • Section 2 : Formatting Characters and Paragraphs (PDF)
  • Activities:
    • Review #2, pg. 58-59, Formating a Vacation Package Document
    • Assessment #2, pg. 60, Preparing and Formatting a Letter
    • Challenge #2, pg 62, Creating and Formatting a Flyer about a Skiing Vacation Package
• Homework:
  • Finish section assignments.
  • Take Word Q1 (Covers Word lessons 1 and 2)
  • Continue working on your Autobiographical Paper (link) Due 9/18

Week 3 - 9/11 and 9/13

• Class 4 - Continue MS Word Activities
• Finish Word Lesson 2 (if necessary)
• Unit 3: Microsoft Word - Formatting
  • Section 3 : Formatting and Enhancing a Document (PDF)
  • Activities:
    • Review #2, pg. 90-91, Preparing and Formatting an Announcement
    • Assessment #5, pg. 93, Locating Information and Creating a Banner
    • Challenge #1, pg 93, Formatting a Costume Document
• Class 5 - Continue MS Word Activities
• Finish Word Lesson 3 (if necessary)
• Unit 4: Microsoft Word - Formatting
  • Section 4 : Formatting with Special Features (PDF)
  • Activities:
    • Review #3, pg. 126-127, Preparing, Modifying, and Formatting a Table
    • Assessment #2, pg. 129, Creating an Organization Chart
    • Challenge #1, pg 131, Formatting a Fact Sheet on Orcas Island
• Homework:
• Finish section assignments.
• Take Word Q2 (covers Word lessons 3 and 4)
• Finish working on your Autobiographical Paper (link) Due 9/18
• Reminder - Word Exam, next Thursday, 9/20

Week 4 - 9/18 and 9/20

• Class 6 - Continue MS Word Activities
• Unit 5: Microsoft Word - Working Session
  • Finish Word Lesson 4 (if necessary)
  • Finish Word Project Assignments
  • Autobiography Due
  • Exam Review/Discussion
• Class 7 - MS Word Exam
• Unit 6: Microsoft Word - Assessment
  • MS Word Exam
    • 80% Multiple Choice - Educator
    • 20% Practical Assessment (Details To Be Provided)
• Homework:
• Finish section assignments
• Look ahead at Excel Lesson 1

Week 5 - 9/25 and 9/26

• Class 8 - Start MS Excel Activities
• Exam Discussion
• Unit 7: Microsoft Excel
  • Section 1 : Analyzing Data Using Excel (PDF)
• Class 9 - Continue MS Excel Activities
• Unit 8: Microsoft Excel
  • Section 1 : Analyzing Data Using Excel (finish)
  • Activities:
    • Review #1, pg. 27-28, Creating Labels, Values, and Formulas
    • Assessment #1, pg. 29, Adding Values and Formulas to a Worksheet
    • Challenge #2, pg 32, Preparing a Theatre Arts Target Enrollment Report
• Homework:
• Finish section assignments.

Week 6 - 10/2 and 10/4

• Class 10 - Continue MS Excel Activities
• Unit 9: Microsoft Excel
  • Section 2 : Editing and Formatting Worksheets (PDF)
• Class 11 - Continue MS Excel Activities
• Unit 10: Microsoft Excel
  • Section 2 : Editing and Formatting Worksheets (finish)
  • Activities:
    • Review #1, pg. 60, Editing, Moving, Copying and Clearing Cells; Performing a Spell Check; Inserting and Deleting Rows.
    • Assessment #1, pg. 61, Editing Cells; Inserting Columns; Absolute References; Copying Formulas; Applying Formatting Features
    • Challenge #1, pg 63, Creating a Direct Wages Budget Report for a Film Shoot
• Homework:
• Finish section assignments.
• Take Excel Quiz 1 (complete by next class)

Week 7 - 10/9 and 10/11

• Class 12 - Continue MS Excel Activities
• Unit 11: Microsoft Excel
  • Section 3 : Using Functions, Setting Print Options, and Adding Visual Elements (PDF)
• Class 13 - Continue MS Excel Activities
• Unit 12: Microsoft Excel
  • Section 3 : Using Functions, Setting Print Options, and Adding Visual Elements (finish)
  • Activities:
    • Review #1, pg. 91, Inserting Statistical, Date, and IF Functions; Setting Print Options.
    • Assessment #2, pg. 93, Applying the PMT and PPMT Functions
    • Challenge #2, pg 96, Preparing an International Student Registration Report
• Homework:
• Finish section assignments.
• Start working on Excel Project Assignment (link)

Week 8 - 10/16 and 10/18

• Class 14 - Continue MS Excel Activities
• Unit 13: Microsoft Excel
  • Section 4 : Working with Multiple Worksheets, Tables, and Other File Formats (PDF)
  • Activities:
    • Review #1, pg. 121, Managing and Formatting Worksheets; Using 3-D References; Linking Cells; Printing Multiple Worksheets
    • Assessment #2, pg. 124, Formatting a Table; Filtering; Sorting
    • Challenge #1, pg 127, Creating a Sales Invoice by Searching and Downloading a Template
• Class 15 - Continue MS Excel Activities
• Unit 15: Microsoft Excel
  • Integrating Programs - Word and Excel
  Activities:
  • Review #3, pg. 142, Embedding an Object
• Homework:
• Finish section assignments.
• Take Excel Quiz 2 prior to next class.
• Really get to work on Excel Project Assignment (link) - Due 10/25

Week 9 - 10/23 and 10/25

• Excel Project Assignment Due 10/25!
• Class 16 - Continue MS Excel Activities
• Unit 16: Microsoft Excel Checkpoint Exam
  • 80% Multiple Choice, 20% Practical Exercise.
  • Covers Excel Lessons 1-4, Integration Activity.
• Class 17 - Start MS Access Activities
• Unit 17: Microsoft Access
  • Section 1 : Maintaining Data in Access Tables (PDF)
  • Activities:
    • Review #2, pg. 28, Sorting; Filtering; Previewing; Changing Page Orientation; Printing; Hiding Columns; Compacting and Backing Up a Database
    • Assessment #2, pg. 29, Finding, Adding, and Delteting Records; Formatting Datasheet; Compact on Close
    • Challenge #1, pg 31, Updating and Printing a Catering Event Database
• Homework:
• Finish section assignments (if necessary)

Week 10 - 10/30 and 11/01

• Class 18 - Continue MS Access Activities
• Unit 18: Microsoft Access
  • Section 2: Creating Tables and Relationships (PDF)
• Class 19 - ContinueMS Access Activities
• Unit 19: Microsoft Access
  • Section 2 : Creating Tables and Relationships (PDF)
  • Activities:
    • Review #1, pg. 57, Creating and Modifying a Table in Design View.
    • Assessment #1, pg. 59, Creating a Table in Design View; Creating a Lookup Field
    • Challenge #1, pg 63, Refining Tables in a Database; Creating Relationships
• Homework:
• Finish section assignments (if necessary)
• Start working on Access Project Assignment (link)

Week 11 - 11/06 and 11/08

• Class 20 - Continue MS Access Activities
• Unit 20: Microsoft Access
  • Section 3 : Creating Tables and Relationships (PDF)
  • Activities:
    • Review #1, pg. 90, Creating a Query Using the Simple Query Wizard; Sorting a Query; Creating a Calculated Field; Extracting Records.
    • Assessment #2, pg. 92, Creating a Query and Report; Modifying a Report
    • Challenge #1, pg 94, Creating Queries and a Report for a Catering Events Database
• Class 21 - ContinueMS Access Activities
• Unit 21: Microsoft Access
  • Section 4: Summarizing Data and Calculating in Forms and Reports (PDF)
  • Activities
    • Review #1, pg. 121, Creating a Crosstab, Find Unmatched, and Find Duplicates Query
    • Assessment #3, pg. 124, Creating a PivotChart
    • Challenge #1, pg 126, Summarizing Catering Event Information
• Homework:
• Finish section assignments (if necessary)
• Start working on Access Project Assignment (link) - Due 11/20

Week 12 - 11/13 and 11/15

• Class 22 - Continue MS Access Activities
• Unit 22: Microsoft Access
  • Integration : Word, Excel, and Access
  • Activities:
    • Review #5, pg. 141, Linking Data to a New Table and Editing Linked Dat
• Class 23 - ContinueMS Access Activities
• Unit 23: Microsoft Access
  • Working Session
    • Exam Prep
    • Finish section assignments
    • Work on project assignment
• Homework:
• Finish section assignments (if necessary)
• Finish working on Access Project Assignment (link) - Due 11/20

Week 13 - 11/20 and 11/22 *

• Class 24 - Continue MS Access Activities
• Unit 24: Microsoft Access Checkpoint Exam
  • 80% Multiple Choice, 20% Practical Exercise.
  • Covers Access Lessons 1-4, Integration Activity.
• No Class 11/22 - Enjoy your Thanksgiving Holiday!!!
• Homework:
• None - Just give thanks for everything good in your life...especially this class.

Week 14 - 11/27 and 11/28

• Class 25 - PowerPoint
• Unit 25: Microsoft PowerPoint
  • Section 1 : Preparing a Presentation
  • Activities:
    • Review #1, pg. 28, Creating a Presentation for Marquee Productions
    • Assessment #2, pg. 29, Preparing a Presentation for The Waterfront Bistro
    • Challenge #1, pg 31, Preparing a Presentation on Toronto, Ontario, Canada
• Class 26 - Continue MS PowerPoint Activities
• Unit 26: Microsoft PowerPoint
  • Section 2: Editing and Enhancing Slides
  • Activities:
    • Review #2, pg. 59, Formatting a Presentation for Performance Threads
    • Assessment #1, pg. 61, Formatting a Presentation for Niagara Peninsula College, Theatre Arts Division
    • Challenge #1, pg 63, Preparing a Presentation for Worldwide Enterprises
• Homework:
• Finish section assignments (if necessary)
• Take PowerPoint Quiz 1 in Educator
• Start working on PowerPoint Presentation (link) - Due 12/11

Week 15 - 12/4 and 12/6

• Class 27 - Continue with PowerPoint
• Unit 27: Microsoft PowerPoint
  • Section 3 : Customizing a Presentation
  • Activities:
    • Review #1, pg. 89, Formatting and Customizing a Biography Project Presentation
    • Assessment #1, pg. 92, Formatting a Presentation for Performance Threads
    • Challenge #1, pg 94, Preparing a Project Schedule Presentation for Marquee Productions
• Class 28 - Continue MS PowerPoint Activities
• Unit 28: Microsoft PowerPoint
  • Integration: Word, Excel, and PowerPoint
  • Activities:
    • Review #2, pg. 109, Linking and Editing an Excel Chart in a PowerPoint Slide
• Homework:
• Finish section assignments (if necessary)
• Take PowerPoint Quiz 2 in Educator
• Continue working on PowerPoint Presentation (link) - Due 12/11
• Study for PowerPoint exam - 12/13

Week 16 - 12/11 and 12/13

• Class 29 - Continue with PowerPoint
• Unit 29: PowerPoint Presentations
  • Activities:
    • In class PowerPoint presentations.
• Class 30 - PowerPoint Checkpoint Exam
• Unit 30: Microsoft PowerPoint
  • PowerPoint Exam
    • Multiple choice 80% (In Educator)
  • Practical Exam 20%
• Homework:
• Enjoy life.
• Work with MS Office often.
• Be well and keep in touch!

Back to Top