CLASS ACTIVITIES

Introduction & Overview of class.

• Computers as tools.
• Systems.

Computing Concepts (Chapter 1)

• Types of Computers: Supercomputer, Mainframe, Mini-Computer, Personal Computer (Desktop, notebook, handheld), Embedded Computer.
• Hardware vs. Software. Application vs System software.
• Bits and Bytes and ASCII/Unicode

Begin to use the computer to access data on the web: Syllabi, Schedule & Online Assignments.

• CPU
• RAM / ROM memory
• Secondary storage (disks)
• Input devices
  • QWERTY keyboards
  • Pointing devices
  • Scanners
• Output devices
  • Monitors / video cards
  • Printers

Computer Software (Chapter 1 continued)

• Operating System Software
• Application Software

Read Chapter 2 (Getting Started with Windows XP).

Windows XP (Chapter 2)

• The Windows XP Desktop.
• Windows, Menus and Dialog Boxes
• Files and Folders in Windows Explorer, My Computer, and the Recycle Bin.
• Learning to use disks and USB drives to store and manage files.
• Customizing, Optimizing and Securing Windows.
• Shortcuts
• Search

Assignment 1: Mini Case page 99. Complete the Paint and Wordpad case, printing both map and invitation.

Read and work through The Online Experience booklet.

The Online Experience (Chapter 3)

• Networks: LAN, WAN, and the Internet.
• Browsers and the World Wide Web
• Web Search Engines (Google, Ask, Yahoo)
• Email and Pirate Mail.

Application Programs

• The Firefox browser
• Open Office
• Portable Apps on a USB Drive
• The Open Disc

Assignment 2: Searching the Web and emailing.

Read and work through Office 2007 Fundamentals (p 1 - 53).

Review for Test 1.

Test 1, on Concepts, Operating Systems (Windows), and the Internet.
 

Read Chapter 4 through 8.

MS Office 2007 Fundamentals (Chapter 4)

• Common Interface Components, the Ribbon.
• Universal Tasks (Open, Save, Print)
• Font Type, Size and Style.
• Headers and Footers.
• Inserting and Sizing Images

Microsoft Word (Chapters 5 through 8)

A Colorful Document

• Creating a Document
• Adding Text
• Adding a Picture
• Formatting Text
• Spell/Grammar Check

Assignment 3: Creating a colorful handout in class with guidance from your instructor.

A Research Paper

• Opening and Editing a Word Document.
• Entering and advanced formatting text.
• Page Breaks.
• Auto-text.
• Adjusting spacing and margins.
• Footnotes
• Cover page
• Page Numbering
• Using the Web to research.
• Copying text from the web.
• Copying and citing an image from the web.
• Hyperlinks, Footnotes and Citations.
• Proofreading and revising work.

• Using Wizards.
• Tables.
• Styles.
• Lists: bulleted and numbered..
• Inserting lines.
• Manually placed tabs.
• Inserting dates, non-breaking spaces and symbols.

Assignment 5: Word Project 3, a resume and cover letter, completed in class with guidance from your Instructor.

Assignment 6: Capstone Word Project, create and print a resume and cover letter for yourself outside of class.

Read Chapters 14 and 15.
 

Microsoft PowerPoint (Chapters 14 and 15)

The PJC Spring Break Cruise

• Storyboards.
• Templates, themes and Wizards
• Adding Titles and bullets
• Multi-level bullets
• Views: Design, Outline, Sorter
• Inserting Clip art and tables.
• Transitions and Special Effects.
• Printing slides and handouts

Assignment 7: PowerPoint project, a slide show Presentation, created in class with guidance from your instructor.

Review for Test 2.

Test 2 on Word Processing and Presentation Software.

Read Chapters 9 through 11.

Worksheet with Chart

• Worksheets and workbooks.
• Navigating worksheets.
• Planning Worksheets.
• Entering labels, values and simple Formulas.
• Math symbols and order of operation.
• Display cell Formulas
• Insert, delete, resize rows and columns
• Copy and Fill.
• Formatting the sheet.
• Creating a simple chart.
• Headers and Footers.
• Printing.

Worksheet with functions and relative addressing.

• Formulas.
• Functions: sum (& autosum), average, if and others.
• Formatting numbers and conditional formatting.
• Relative and absolute references.
• What-if Analysis
• Wide sheets and fit to page

Veterans' Day

Assignment 9: Excel Project 2, a larger worksheet with two charts, completed in class with guidance from your instructor.

• Freeze/unfreeze rows/columns.
• Hide/unhide rows/columns.
• Protect/unprotect cells.
• Working with tables and "records."
• Data Access.
• Sorting and filtering data.
• Choosing chart types.
• Chart formatting.
• Printing charts.

Assignment 10: Excel Project 3, a larger worksheet with web access of data and database like functions (sort, filter, etc.), completed in class with guidance from your instructor.

Using One File Database

• Database concepts
  • Fields
  • Records
  • Tables
  • Keys
  • Forms, Reports and Queries (SQL)
• Opening and using a database.
• Using Design and Datasheet Views.
• Adding/Modifying data
• Adding a Form
• Adding a Report
• Printing

Assignment 11: Access Project 1, a simple database report, completed in class with guidance from your instructor.

• Creating a Database.
• Creating Tables
• Querying Databases.
• Multi-table queries.

Assignment 12: Access Project 2, a more complex database with multiple tables and queries, completed in class with guidance from your instructor.

• Using Basic (Free Basic or Dark Basic) to create a simple program
• Simple graphics

Next Steps!

Courses are available in...

• Excel
• Database
• Web Design
• Programming

Review for final

Final Exam (Test 3), on Excel and  Access and all previously covered material!

Grade Scale

Grading Percentages

Tests.………………75%

Assignments..…….25%