CGS1100 Microcomputer Applications - Fall 2013
Instructor - Andrew Pond
|Week #||Topics & Objectives||Assignments||Notes|
(August 23, 1013)
| Book chapter: Introduction to Technology
8/27 - Updated Textbook information:
You can also purchase the printed or digital copy directly from the publisher.
Students can also get great deals on Microsoft software. Before you buy any software, I recommend you "Google" student discounts for that software. For Microsoft, visit TheUltimateSteal.com
----------- Update # 2 ---------------
Here is a link specifically for PBSC students to be able to purchase the book and SAM directly from the publisher.
From the e-mail I received....
[Your students can also purchase the stand alone Instant SAM 2013 code with the full MindTap reader eBook if they prefer not to purchase a physical text. They can also choose to purchase the discounted bundle with the text. Please feel free to forward this link and cover to your students so that they purchase the correct course materials. The bundle in the bookstore is actually $35 less than the stand alone Shelly Office 2013 text, so I would encourage you to have them purchase the bundle that includes the SAM access and a full eBook as well.]
Purchase book - class assignments and assessments will require the textbook and SAM. ISBN numbers are on syllabus.
|2 (Aug. 30)||
1) Office 2013 and Windows 8: Essential Concepts and Skills
2) Office 365 Essentials
|SAM online task: Training 1 - Essential Concepts and Skills||Lab 2|
|3 (Sept. 6)||Creating, Formatting, and Editing a Word Document with a Picture (MS Word)||
SAM online task: Word Training
SAM online task: Word Project 1a (available 9/4 thru 9/15)
Create an online storage account. Microsoft offers SkyDrive; Google has iDrive; Apple iCloud; Amazon and others also offer this service. Google online or "cloud" storage. ALL of these offer FREE space - typically 2 to 8 Gigabytes for just signing up. My recommendation would be to go to Microsoft's outlook.com site and create an 'outlook' e-mail address that will be your sign-on for a Skydrive account.
|4 (Sept. 13)||Creating a Research Paper with References and Sources (MS Word)||Complete project 1a and 1b for this chapter from the SAM assignments.|
|5 (Sept. 20)||Creating a Business Letter with a Letterhead and Table (MS Word)||Complete project 1a and 1b for this chapter from the SAM assignments.||
Several students are encountering problems submitting Word Chapter 2 Project 1b. The tech people at CENGAGE are trying to resolve. I will make adjustments for this project.
We covered in class examples of setting tabs, margins and working with tables in Word.
|6 (Sept. 27)||Creating and Editing a Presentation with Pictures (MS PowerPoint)||Complete project 1a and 1b for this chapter from the SAM assignments.|
|7 (Oct. 4)||Enhancing a Presentation with Pictures, Shapes, and WordArt (MS PowerPoint)|
|8 (Oct. 11) *||Mid-term Assessment|
|9 (Oct. 18)
||Reusing a Presentation and Adding Media and Animation (MS PowerPoint)|
|10 (Oct. 25)||Creating a Worksheet and a Chart (MS Excel)|
|11 (Nov. 1)||Formulas, Functions, and Formatting (MS Excel)|
|12 (Nov. 8) *||
Managing Email Messages with Outlook
Complete the Outlook Training on SAM
Complete extra credit Word assignment on SAM - optional.
by Jinha Lee
|13 (Nov. 15)||Working with Large Worksheets, Charting, and What-If Analysis|
|14 (Nov. 22)||Databases and Database Objects: An Introduction (MS Access)|
|Thanksgiving (Nov. 29)||No class meeting|
|15 (Dec. 6)||Querying a Database (MS Access)||Study for Final|