CGS 2100 Computer Fundamentals and Applications
Summer 2016 (Online) Term B |
||||
6/21/2016 - 8/2/2016 | ||||
Go to Blackboard for the SAM Assignments | ||||
Week | Dates | Assignment | Assignment/Exam Due Date | |
1 |
|
INFORMATION
TECHNOLOGY: Read "Essential Computer Concepts" (pg ECC1) & "Exploring the Basics of Microsoft Windows 8" (pg WIN1) "Managing your Files" (FM 1) & "Internet Basics and Information Literacy" (BEB 1) from the eBook in BLACKBOARD |
(4) EXAMS DUE in SAM: Essential Computer Concepts, Internet Basics and Information Literacy Exam, Managing Your Files Exam, Exploring the Basics of Windows 8 Exam DUE by 6/29/2016 by 11:59 pm (10 pts deducted for each day it's late) |
|
Review chapters Word tutorial 1 (WD 1) "Creating a Document" and Word tutorial 2 (WD 1) Word tutorial 2 "Navigating and formatting a document" | GO TO BLACKBOARD
FOR: Word Exam T1 & T2 Word 2013 Tutorial 1- 1a Word 2013 Tutorial 2- 1a Due 6/29/2016 by 11:59 pm (10 pts deducted for each day it's late) |
|||
(2) After you have finished reviewing the chapters go to Blackboard to access the SAM Assignment and take Word Exam 1 and 2. (All exams have a optional training component that will help you prepare for the exam) | ||||
(3) CASE PROBLEM: When you have completed the training and exam download New Perspectives Word 2013 Tutorial 1a and New Perspectives Word 2013 Tutorial a instructions and start files. When have completed the case problem, upload the file to back SAM. The assignment will be graded through SAM. Click on Reports tab, download your submitted project, make the necessary changes and re-submit for a higher grade. | ||||
Response to Topic 1 "Bridging the IT Generation Gap" due in Blackboard | 6/26/2016 by 11:59 pm | |||
Dates | Assignment | Assignment/Exam Due Date | ||
2 |
|
(1)Review chapters PowerPoint tutorial 1 (PPT 1) "Creating a Presentation" and PowerPoint tutorial 2 (PPT 41) "Applying and Modifying Text and graphic objects" | PPT 1 and PPT 2 Exams Powerpoint 2013
Tutorial 1- 1a Powerpoint 2013
Tutorial 2- 1a Due 7/3/2016 by 11:59 pm (10 pts deducted for each day it's late) |
|
(2) After you have finished reviewing the chapters go to Blackboard to access the SAM Assignment and take PPT 1 and PPT 2 Exams. (All exams have a optional training component that will help you prepare for the exam) | ||||
(3) CASE PROBLEM: When you have completed the training and exam download New Perspectives Powerpoint 2013 Tutorial 1 and New Perspectives Powerpoint 2013 Tutorial 2 instructions and start files. When have completed the case problem, upload the file to back SAM. The assignment will be graded through SAM. Click on Reports tab, download your submitted project, make the necessary changes and re-submit for a higher grade. | ||||
Response to Topic 2 "Permission before Posting Photos of Others" due in Blackboard | 7/3/2016 by 11:59 pm | |||
Week | Dates | Assignment | Assignment/Exam Due Date | |
3 |
|
(1) Read and complete Excel tutorial 1 (EX 1) "Getting started with Excel" and Excel tutorial 2 (EX 67) "Formatting a Workbook" | EX1
and EX2 Excel exam Excel 2013 Tutorial 1- 1a Excel 2013 Tutorial 2- 1a Due 7/10/2016 by 11:59 pm (10 pts deducted for each day it's late) |
|
(2) After you have finished reviewing the chapters go to Blackboard to access the SAM Assignment and take EX1 and EX2 Exams. (All exams have a optional training component that will help you prepare for the exam) | ||||
(3) CASE PROBLEM: When you have completed the training and exam download New Perspectives Excel 2013 Tutorial 1 and New Perspectives Excel 2013 Tutorial 2 instructions and start files. When have completed the case problem, upload the file to back SAM. The assignment will be graded through SAM. Click on Reports tab, download your submitted project, make the necessary changes and re-submit for a higher grade. | ||||
Response to Topic 3 "Using Mobile Devices while Driving?" due in Blackboard 7/10/2016 | ||||
Week | Dates | Assignment | Assignment/Exam Due Date | |
4 |
|
(1) Read and complete Excel tutorial 3 (EX 131) "Calculating Data with Formulas and Functions" and Excel tutorial 4 (EX 189) "Analyzing and Charting Financial Data" | EX3
and EX4 Exams Excel 2013 Tutorial 3- 1a Excel 2013 Tutorial 4- 1a Due 7/17/2016 by 11:59 pm (10 pts deducted for each day it's late) |
|
(2) After you have finished reviewing the chapters go to Blackboard to access the SAM Assignment and take EX3 and EX4 Exams . (All exams have a optional training component that will help you prepare for the exam) | ||||
(3) CASE PROBLEM: When you have completed the training and exam download New Perspectives Excel 2013 Tutorial 3 and New Perspectives Excel 2013 Tutorial 4 instructions and start files. When have completed the case problem, upload the file to back SAM. The assignment will be graded through SAM. Click on Reports tab, download your submitted project, make the necessary changes and re-submit for a higher grade. | ||||
Response to Topic 4 "Email Scanning" due in Blackboard 7/17/2016 | ||||
Week | Dates | Assignment | Assignment/Exam Due Date | |
5 |
|
(1) Begin Access tutorial 1 (AC 1) "Creating a Database" (This is the beginning of the working database called "Chatham", do not submit this tutorial, this is your lesson. Continue on to Access tutorial 2 (AC 51) "Building a database and defining Table Relationships" | Go to
SAM for AC1 and AC2 Exams and Access 2013 Tutorial 1- 1a Access 2013 Tutorial 2- 1a Due 7/24/2016 by 11:59 pm (10 pts deducted for each day it's late) |
|
(2) After you have finished reviewing the chapters go to Blackboard to access the SAM Assignment and take AC1 and AC2 Exams . (All exams have a optional training component that will help you prepare for the exam) | ||||
(3) CASE PROBLEM: When you have completed the training and exam download New Perspectives Access 2013 Tutorial 1 and New Perspectives Access 2013 Tutorial 2 instructions and start files. When have completed the case problem, upload the file to back SAM. The assignment will be graded through SAM. Click on Reports tab, download your submitted project, make the necessary changes and re-submit for a higher grade. | ||||
Response to Topic 5 "Track Your Location" due in Blackboard 7/24/2016 | ||||
Week | Dates | Assignment | Assignment/Exam Due Date | |
6 |
|
(1) Continue Access tutorial 3 (AC 115) "Maintaining and Querying a Database" and Access tutorial 4 (AC 179) "Creating forms and reports" (This is the continuation of the working database called "Chatham", do not submit this tutorial, this is your lesson. | Go to
SAM for AC3 and AC4 Exams Access 2013 Tutorial 3- 1a Access 2013 Tutorial 4- 1a Due 7/31/2016 by 11:59 pm (10 pts deducted for each day it's late) |
|
(2) After you have finished reviewing the chapters go to Blackboard to access the SAM Assignment and take AC3 and AC4 Exams . (All exams have a optional training component that will help you prepare for the exam) | ||||
(3) CASE PROBLEM: When you have completed the training and exam download New Perspectives Access 2013 Tutorial 3 and New Perspectives Access 2013 Tutorial 4 instructions and start files. When have completed the case problem, upload the file to back SAM. The assignment will be graded through SAM. Click on Reports tab, download your submitted project, make the necessary changes and re-submit for a higher grade. | ||||
Response to Topic 6 "Cloud Storage" due in Blackboard 7/31/2016 | ||||
Work on Final Project (Will be available from 7/25/2016 -8/1/2016 |
||||
FINAL DUE 8/1/2016 by 11:59 PM |