Dates: June 28 - August 9, 2011 - Tuesdays & Thursdays: 5:30 - 8:30 PM (See the Course Schedule below)
You are expected to participate in each class meeting and will be tested on text and lecture content. It is your responsibility to notify me if you miss the daily roll call and to get the lecture notes from a classmate. Bring a pencil, notepaper and a USB storage device to each class meeting. The maintenance and security of your textbook and storage media is your responsibility. The loss of these items does not exempt a student from his or her class/homework responsibilities.
Portable electronic devices such as cellular phones, pagers, PDA's, media players, etc. must not be used during class, except for taking notes or recording lectures. If you need to be reached at the college, use the following numbers:
| Instruments of Evaluation | Points |
|---|---|
| Twenty four Skillport® Learning Events. The average % score on all attempts will be multiplied by: |
100 |
| Four hands-on projects, each worth 25 points, totaling: | 100 |
| Five exams, each worth 100 points, totaling: | 500 |
| Your final grade is based on your percentage of: | 700 |
The schedule below contains deadlines for class activities. Students should read the chapters listed below prior to coming to class (and then review them after the class) to enhance their understanding of classroom discussions and activities. Reading of the online textbooks and performance of the required hands-on Learning Events in SkillPort should be completed before attempting any project or exam. An average student should expect to spend at least as much time studying outside of class as spent in class. All dates listed below should be interpreted as final deadlines for an activity. Be proactive in your study habits. Try to stay ahead of the schedule; don't just keep up with it. Contact me immediately if you cannot meet a deadline.
This schedule and any changes to it will be posted on the course web site. You also are advised to review the web pages regarding academic schedules on the .
| Date | Reading & Required Hands-on Learning Events (Practice) | Project Due |
|---|---|---|
| T 6/28 | Orientation to course and online resources:
Lecture: Basic Computer Concepts Read the Web page: Data Types & Computer Languages [Skillport] Online Book: PCs For Dummies, Windows 7 Edition: Chapters 1-12, 19, 30, and 31 (Note: all online books are accessed under the first Learning Event: "Gibson_CGS1060") [Skillport] Learning Event #1: "ECDL/ICDL 4 Module 1: Concepts of Information Technology (IT)" |
|
| Th 6/30 | Lecture: Windows 7 Operating System Web page: Windows® File Association Online viewing: [Windows 7 Basics - Tutorials 1-15] [Skillport] Online Books: Getting StartED with Windows 7: Chapters 1 and 2 Windows 7 Plain & Simple: Chapters 2 and 5 [Skillport] Learning Event #2: "Getting Started with Windows 7" |
|
| T 7/5 | Lecture and hands-on: Internet and the WWW Web pages: Internet (definition), Internet Addressing, and the World Wide Web [Skillport] Online Book: Internet for Dummies, 11th Ed.: Chapters 1, 2, 6-8 [Skillport] Learning Event #3: "Internet Explorer 8: Basic Features" Review for Exam 1 and the Quick Reference Guides on: [Computer Basics QRG], [Windows 7 QRG], and [Internet Explorer 8 QRG] |
File Management |
| Th 7/7 | Exam 1 - Windows and Internet Then Lecture & hands-on: Word 2010 - Word Processing and Web Page: How to Convert Data Files To Different Languages [Skillport] Online Books: Office 2010 All-in-One For Dummies: Book I - Common Office Tools - Chapters 1-3 Office 2010 All-in-One For Dummies: Book II - Word - Chapters 1 & 2 [Skillport] Learning Events #4-#5: "Getting Started with Word 2010" "Formatting and Working with Text in Word 2010" |
|
| T 7/12 | Lecture & hands-on: Word 2010 - Formatting and Customizing Documents [Skillport] Online Book: Office 2010 All-in-One For Dummies: Book II - Word - Chapters 3, 4 & 6 [Skillport] Learning Events #6-#8: "Structuring Word 2010 Documents" "Saving, Sharing, and Printing in Word 2010" "Reviewing Documents in Word 2010" |
|
| Th 7/14 | First: Review for Exam 2 and
[Quick Reference Guide] Then - Exam 2 - Word 2010 Finally: Introduction of Electronic Spreadsheets with Excel 2010 |
Word Processing |
| T 7/19 | Lecture & hands-on: Excel 2010: Entering, Editing and Formatting (Worksheet) Data and Using Formulas and Functions, and Charting, Themes, and Styles [Skillport] Online Books: Office 2010 All-in-One For Dummies: Book V Excel - Chapters 1 - 3 [Skillport] Learning Events #9-#13: "Getting Started with Excel 2010" "Applying Basic Data Formatting in Excel 2010" "Moving Data and Modifying Worksheets in Excel 2010" "Using Basic Formulas in Excel 2010" "Using Basic Functions with Excel 2010" |
|
| Th 7/21 | Lecture & hands-on: Excel 2010: Reviewing, and Printing [Skillport] Online Books: Office 2010 All-in-One For Dummies: Book V Excel - Chapters 4 & 5 Office 2010 All-in-One For Dummies: Book I - Common Office Tools - Chapter 6 [Skillport] Learning Events #14-#15: "Saving, Sending, and Printing Excel 2010 Workbooks" "Inserting Basic Charts in Excel 2010" |
|
| T 7/26 | First: Review for Exam 3 and
[Quick Reference Guide] Next: Exam 3 - Excel 2010 Finally: Introduction of Database Management with Access 2010 |
Excel Workbook |
| Th 7/28 | Lecture & hands-on: Access 2010: Stepping Into Access, and Creating Tables and Forms [Skillport] Online Books: Office 2010 All-in-One For Dummies: Book VI Access - Chapters 1-3 [Skillport] Learning Events #16-#18: "Getting Started with Access 2010" "Creating Basic Tables in Access 2010" "Introduction to Forms in Access 2010" |
|
| T 8/2 | Lecture & hands-on: Access 2010: Retrieving Information (Forms, Queries, and Reports) [Skillport] Online Books: Office 2010 All-in-One For Dummies: Book VI Access - Chapters 4 & 5 [Skillport] Learning Events #19-#20: "Introduction to Queries in Access 2010" "Introduction to Reports in Access 2010" |
|
| Th 8/4 | Lecture & hands-on: PowerPoint 2010: Presentation Graphics [Skillport] Online Books: Office 2010 All-in-One For Dummies: Book IV PowerPoint - Chapters 1-5 [Skillport] Learning Events #21-#24: "Getting Started with PowerPoint 2010" "Visually Enhancing PowerPoint 2010 Presentations" "Adding Images to Presentations in PowerPoint 2010" "Using Multimedia and Animations in PowerPoint 2010" |
Access Database Note: all work assigned this semester must be completed by this date to pass this course. |
| T 8/9 | 5:30-6:30 PM: Review for combined Exams: Access (Exam 4) and [2010 Quick Reference Guide] PowerPoint (Exam 5) and [Quick Reference Guide] 6:30-8:30 PM: Final - Access Exam and PowerPoint Exam. |