CGS1100 Microcomputer Applications - Spring 2014
Instructor - Andrew Pond
|Week #||Topics & Objectives||Assignments||Notes|
(January 8, 2014)
| Book chapter: Introduction to Technology
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
----------- Publisher Resources ---------------
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 (Jan 15)||
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 (Saving Files in Folders)|
|3 (Jan 22)||Creating, Formatting, and Editing a Word Document with a Picture (MS Word)||
SAM online task: Word Training
SAM online task: Word Project 1a (available thru 1/29)
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.
Student Data file for book projects are available online from www.cengage.com
|4 (Jan 29)||Creating a Research Paper with References and Sources (MS Word)||Complete project 1a and 1b for this chapter from the SAM assignments.|
|5 (Feb 5)||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.
|7 (Feb 19)||Enhancing a Presentation with Pictures, Shapes, and WordArt (MS PowerPoint)|
|8 (Feb 26) *||Mid-term Assessment|
| No class meeting
|9 (Mar 12)||Reusing a Presentation and Adding Media and Animation (MS PowerPoint)|
|10 (Mar 19)||Creating a Worksheet and a Chart (MS Excel)|
|11 (Mar 26)||
Formulas, Functions, and Formatting (MS Excel)
by Jinha Lee
|12 (Apr 2)||Managing Email Messages with Outlook|
|13 (Apr 9)||Working with Large Worksheets, Charting, and What-If Analysis|
|14 (Apr 16)||Databases and Database Objects: An Introduction (MS Access)|
|15 (Apr 23)||Querying a Database (MS Access)||Study for Final|
|16 (Apr 30)||Final|