CGS 2100 Computer Fundamentals and Applications
Summer 2016 (Online) Term A |
| 5/9/2016 - 6/20/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 5/15/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 5/18/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 |
5/15/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 5/22/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 |
5/22/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 5/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 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
5/29/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 6/5/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 6/5/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 6/12/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
6/12/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 6/19/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 6/19/2016 |
| |
6/13/2016 - 6/19/2016 |
Work on Final Project
(Will be available from 6/13/2016 - 6/19/2016 |
|
| |
|
FINAL DUE 6/20/2016 by 11:59
PM |
|
|
|
|
|