|
TERM 3 |
UNIT 1
DISCLOSURES / CLASS FEE |
|
Assignment/Exam |
Date Given |
Assignment/Directions |
Web Link |
Points |
Due Date |
| DSD Disclosure |
January 19-20 |
Digital
Submission Form |
DSD Disclosure |
30 |
January 23-24 |
| WSU Disclosure |
WSU Disclosure
|
| Class Disclosure |
Class Disclosure |
| Class Fee |
Pay $30 in Business Office
for CE Class Fee |
Pay in Business Office or
Pay Online at My.DSD |
50 |
|
WSU Registration DEADLINE - Feb 1 |
January 23-24 |
We will be registering for Weber State University Concurrent
Enrollment on Monday January 23rd and Tuesday January 24th during class.
If you have never registered as a student before, then you will need to have
knowledge of your Social Security # and have a credit/debit card on hand to
complete the registration.
Registration Instructions |
Registration Link on WSU
|
N/A |
|
Create DropBox |
DROPBOX
Use your Student Email Address as your username
Use your Student Pin # as your Password
Create the following Folder and Sub Folders
1. TBE 1700
2. Subfolder - EXCEL
3. Subfolder - ACCESS
4. Subfolder - WINDOWS
5. Subfolder - POWERPOINT
6. Subfolder - WORD
-
Open your student email account at MyDSD
for messages from your instructor on joining dropbox. Join and
accept.
-
Click on the link in your email to go to http://www.dropbox.com.
-
Create your Dropbox Account using your student email account
as your log in name and you PIN # as your password.
-
Install your Dropbox software on either your H:\ or the
desktop.
-
Accept an invitation from Coach to connect to a shared folder "ADVCT".
-
Create a folder on the root of your Dropbox called
[Last name, First Name, Period #].
-
Share [Last name, First Name, Period #] folder with Coach at his email address at
cstringfellow@dsdmail.net.
Save each Assignment with the name of that assignment
as described below in the subfolder of the name of the unit currently
working on. |
25 |
UNIT 2
EXCEL |
|
Assignment/Exam |
Date Given |
Assignment/Directions |
Web Link |
Points |
Due Date |
|
Excel Pre-Test |
January 23-24 |
In-Class Excel Pre-Test |
In Class Only |
25 |
January
23-24 |
Excel Chapter 1
Creating a Worksheet and Embedded Chart
Ch1 - PowerPoint |
January 25-26 |
Do the Work for all 4
Hand in Printouts via SHARED DROPBOX FOLDER
"dropbox/lastname-firstname-period#/TBE1700/Excel/Chapter 1" |
Chapter 1 Worksheet |
100 |
February 2-3 |
Assignment #1
Download and Complete the Assignment, in Excel, Save as (assingmen1) on H:/
Drive, then submit via Shared Drop Box Folder |
Apply Your Knowledge
Apply 1-1
Instructions in Book on Page EX 54| File on Q Drive | Save as
(Apply1-1) on H:/ Drive, then submit via Shared Drop Box Folder |
Excel Chapter 2
Formulas, Functions, and Formatting
Ch2 - PowerPoint |
February 2-3 |
Do the Work for all 4
Hand in Printouts via SHARED DROPBOX FOLDER
"dropbox/lastname-firstname-period#/TBE1700/Excel/Chapter 2" |
Chapter 2 Worksheet |
100 |
February
10-13 |
|
Assignment #2 |
Apply 2-1
Instructions in Book | File on Q Drive |
Excel Chapter 3
What If Analysis, Charting, and Working with Large Worksheets
Ch3 - PowerPoint |
February 10-13 |
5 Assignments for Chapter 3
Do the Work for all 4
Hand in Printouts via SHARED DROPBOX FOLDER
"dropbox/lastname-firstname-period#/TBE1700/Excel/Chapter 3" |
Chapter 3
Worksheet |
125 |
February
22-23 |
|
Assignment #3
|
If Statement Key |
Apply 3-1
Parts 1, 2 Type answers on separate paper
Part 3 - Open from Q Drive (Apply 3-1), complete, print, submit with Parts 1
& 2 |
Excel Chapter 4
Financial Functions, Data Tables, and Amortization Schedules
Ch4 - PowerPoint |
February 22-23 |
Only Assignment 4 is assigned from Chapter 4
Do the Work for all 4
Hand in Printouts via SHARED DROPBOX FOLDER
"dropbox/lastname-firstname-period#/TBE1700/Excel/Chapter 4" |
Assignment #4
Go to Q:\ and open EX4 ASSN4 Start File
Answer Key WorkSheet
Answer Key Formulas |
25 |
February 28-29 |
APPLICATION TEST REVIEW
Excel Application
Review Test |
March 5, 7-8 |
Chitester Review Handout
TBE Concurrent 1703 Excel 2010 Practice
Save in your
SHARED DROPBOX FOLDER
"dropbox/lastname-firstname-period#/TBE1700/Excel/Test" |
Do the Review on Excel 2010, print and hand 3 printouts
(worksheet, formulas, chart) in, when finished, and Save in your SHARED
DROPBOX FOLDER Answer Keys
Page 1 |
Page 2 |
Page 3 |
Page 1 Formulas |
Page 3 Formulas |
100 |
March 9 & 12 |
|
APPLICATION TEST |
March 9 & 12 |
Take final application exam
Staple printouts and put into box
Save in your
SHARED DROPBOX FOLDER
"dropbox/lastname-firstname-period#/TBE1700/Excel/Test" |
All Tests must be finished and turned in by March 9 & 12
NO EXCEPTIONS |
50
15% of grade |
March 9 & 12 |
KNOWLEDGE EXAM REVIEW
Excel Chitester
Practice Test |
March 13-14 |
Take the Knowledge Review up to 3 times
Take [screenshot] of final score in chi-tester, Paste screen shot to MS Word
File,
Save in your
SHARED DROPBOX FOLDER
"dropbox/lastname-firstname-period#/TBE1700/Excel/Test"
Search for this practice test
"TBE Concurrent 1703 Excel 2010 Practice" |
To enter
Chitester, use the following URL:
http://www.chitester.weber.edu
Students will already have a user name and password, which were created when
they registered at Weber State University. Use that user name and password
for the Chitester exams. All TBE Concurrent exams begin with TBE
Concurrent. |
100 |
March 15-16 |
|
KNOWLEDGE EXAM |
March 15-16 |
Chi-Tester Final
Take Final Exam - Password given by instructor
Take [screenshot] of final score in chi-tester, Paste screen shot to MS Word
File, save, Name and Period, Hand in.
Save in your
SHARED DROPBOX FOLDER
"dropbox/lastname-firstname-period#/TBE1700/Excel/Test" |
http://www.chitester.weber.edu
Wildcat Username
Search for this Test
TBE Concurrent
1703 Excel 2010
Password = formula7 |
58
8% of grade |
March 15-16 |
|
EMPLOYABILITY SKILLS |
January 19-20 |
Class Attendance
(-5) Points for Every Tardy
(-10) Points for Every Un-Cleared Absence |
Employability Skills Chart |
|
March 15-16 |
EACH UNIT IS DUE ON DUE DATE
Term 1 Grades only include General Assignments & Unit 2 (EXCEL) |
|
TERM 2 |
UNIT 3
MS
WINDOWS XP/WINDOWS 7/POWERPOINT |
|
Assignment/Exam |
Date Given |
LINK |
ASSIGNMENT INSTRUCTIONS |
Points |
Due Date |
Windows 1
Intro to Computers PPT |
March 20-21 |
WIN Assignment 1 |
Windows File Setup, Email and Cloud Computing
-
COMPLETE WIN Assignment 1 and save it to
your dropbox folder [Last name, First Name, Period #].
-
Upload your completed assignment worksheet to that folder on
your Dropbox.
|
25
Submit via DropBox |
March 22-23 |
|
Windows 2 |
March 22-23 |
WIN Assignment 2 |
Computer Buying Scenarios
Complete the assignment in MS WORD, then
save to your drop box folder that is shared with Coach, this is how you hand
in your work. |
25
Submit via DropBox |
March 26-27 |
|
Windows 3 |
March 26-27 |
WIN Assignment 3 NOTES
Click on each Video to View Must have a pair of headphones
Drop your Notes into your Shared Dropbox Folder to hand in |
Videos to Watch - Use Handout to Take Notes
What is Dropbox? |
Win XP vs Win 7
Getting around the Desktop |
Finding your Files
Personalizing Your PC |
Remote Desktop |
Snipping Tool |
50
Submit via DropBox |
March 28-29 |
Windows 3
Windows 7 PPT |
March 28-29 |
Windows Quiz |
Windows Quiz
ExamView Player 6 |
25 |
March 28-29 |
| |
PowerPoint 1
PPT Review |
April 10-11 |
Apply 1-1
Pages PPT 55-56
Open File off Q:\ |
Complete the assignment and save it in your
[Last name, First Name, Period #] in DropBox
Submit via DropBox |
25
Submit via DropBox |
April 24-25 |
PowerPoint 2
PPT Review |
April 12-13 |
Apply 2-2
Pages PPT 123-124
Open File off Q:\ |
Complete the assignment and save it in your
[Last name, First Name, Period #] in DropBox
Submit via DropBox |
25
Submit via DropBox |
PowerPoint 3
PPT Review |
April 16-17 |
WPP3 ASSIGN 3 |
Complete the assignment and save it in your
[Last name, First Name, Period #] in DropBox
Submit via DropBox |
25
Submit via DropBox |
PowerPoint 4
PPT Review |
April 18-19 |
WPP4 ASSIGN4 |
Complete the assignment and save it in your
[Last name, First Name, Period #] in DropBox
Submit via DropBox |
25
Submit via DropBox |
Knowledge
Practice Exam |
April 20-23 |
http://chitester.weber.edu |
TBE Concurrent 1702 Windows
PowerPoint 2010 Practice
Complete the assignment by taking
a screen shot of your 3 test scores and save it
in your [Last name, First Name, Period #] in
DropBox
Submit via DropBox |
25
Submit via DropBox |
Application
Review |
WPP6 ASSIGN 6 |
Complete the assignment and save it in your
[Last name, First Name, Period #] in DropBox
Submit via DropBox |
25 EXTRA CREDIT
Submit via DropBox |
WIN/PPOINT
Application Exam |
April 24-25 |
TBE Windows and Power Point Application Exam |
Complete the Test - Save the test - Print the
test/hand in
Also save it in your
[Last name, First Name, Period #] in DropBox
Submit via DropBox |
Submit via Printout & DropBox |
April 24-25 |
WIN/PPOINT
Knowledge Exam |
April 26-27 |
http://chitester.weber.edu |
TBE Concurrent 1702 Windows
PowerPoint 2010
Wildcat Username
Search for this Test
TBE
Concurrent 1702 Windows PowerPoint 2010
Password = design5
Complete the Test - Take a
screen shot of your Test Score - Save the
document in your [Last name, First Name, Period
#] in DropBox and Print the test/hand in
|
Submit via Printout & DropBox |
April 26-27 |
UNIT 4
MS WORD 2010 |
|
Assignment/Exam |
Date Given |
Assignment/Directions |
Web Link |
Points |
Due Date |
|
Word 1 |
April 30-May 1 |
WD 1 ASSIGN 1 |
Complete the assignment and save it in your
[Last name, First Name, Period #] SHARED
FOLDER\WORD in DropBox -
Submit via DropBox |
25
Key
Submit via DropBox |
May 2-3 |
|
Word 2 |
May 2-3 |
WD 2 ASSIGN 2 |
Complete the assignment and save it in your
[Last name, First Name, Period #] SHARED
FOLDER\WORD in DropBox -
Submit via DropBox |
25
Key
Submit via DropBox |
May 4-7 |
|
Word 3 |
May 4-7 |
WD 3 ASSIGN 3 |
Complete the assignment and save it in your
[Last name, First Name, Period #] SHARED
FOLDER\WORD in DropBox -
Submit via DropBox |
25
Key
Submit via DropBox |
May 8-9 |
Knowledge
Practice Exam |
May 8-9 |
WD 4 Chi-Tester Practice |
TBE Concurrent 1701 Word 2010
Practice
http://chitester.weber.edu
Complete the assignment by taking
a screen shot of your 1 of your 3 test scores and save it
in your [Last name, First Name, Period #] in
DropBox
Submit via DropBox |
25
Submit via DropBox |
May 10-11 |
|
Knowledge Exam |
May 10-11 |
http://chitester.weber.edu |
TBE Concurrent 1701 Word 2010
Wildcat Username
Search for this Test
TBE Concurrent 1701 Word 2010
Password = text33
Complete the Test - Take a
screen shot of your Test Score - Save the
document in your [Last name, First Name, Period
#] SUBMIT via a printed copy and hand in and via SHARED DROP BOX |
50
8% of grade
Submit via Printout & Dropbox Shared |
May 10-11 |
|
Application Review |
May 10-11 |
WD ASSIGN 5 |
Complete the assignment and save it in your
[Last name, First Name, Period #] SHARED
FOLDER\WORD in DropBox -
Submit via DropBox |
25 EXTRA CREDIT
Key
Submit via DropBox |
May 14-15 |
|
ACCESS ACTIVITY |
|
Save in your
SHARED DROPBOX FOLDER
"dropbox/lastname-firstname-period#/TBE1700/Access" |
TBA |
TBA |
|
|
ACCESS ACTIVITY |
|
Save in your
SHARED DROPBOX FOLDER
"dropbox/lastname-firstname-period#/TBE1700/Access" |
TBA |
TBA |
|
ACCESS QUIZ |
|
Save in your
SHARED DROPBOX FOLDER
"dropbox/lastname-firstname-period#/TBE1700/Access" |
TBA |
TBA |
|
Application Exam |
|
TBE Word 2012
Final Exam |
Complete the Test and save it in your
[Last name, First Name, Period #] SHARED
FOLDER\WORD in DropBox -
Submit via DropBox
Handout |
Start File |
100
15% of grade
Submit via Dropbox Shared |
|
|
FINAL EXAMS |
|
SKILL CERT REVIEW |
|
Complete the Skills Cert Review over the weekend and turn in in January 10
for some Extra Credit (MUST BE
COMPLETELY FINISHED) |
STATE SKILLS CERT REVIEW
Download and Print
Turn in Completely Finished |
Half Grade Raise |
May 29-30 |
TBE 1700 FINAL EXAM
Application Only |
|
TBE 1700 FINAL EXAM
If your grade reflects 95% or higher, then you do not need to take this
test, otherwise you do! |
FINAL TEST HANDOUT
Start Files are on the Q Drive or can download from here
WORD
START FILE |
50
16% of grade |
|
Skill Certification Exam |
|
Every Student Must Take this Exam
If you take the exam you get +100 Points
If you don't take the exam you get 0 points |
In Class Exam will be taken on Computers
Knowledge Only...No Application
On-Line Test Link |
100 |
Skill Certification Exam
Make-up Day |
|
|
EMPLOYABILITY SKILLS |
March 20-21 |
Class Attendance
(-5) Points for Every Tardy
(-10) Points for Every Un-Cleared Absence |
Employability Skills Chart |
100 |
| |