R. Craig Collins >
ITSE 1294 > Overview 4
R. Craig Collins >
ITSE 1294 > Overview 4
Overview 4 © R. Craig Collins, 2005/7
Items that should be accomplished before the beginning of the current time frame:Items to accomplish during the current course time frame:
•Read\Review
• How
to Study for a test
• How
to take a Collins test
• Test Two, the Mid term, topics: Chapters 1, 2, 9, 3, 4, 10, and 5; Terms and Big Picture Web page
• Review guide for Test Two, the Mid Term
• Take a practice test in D2L
• Using
D2L Quizzes
• Are you getting the best possible grade?
•Activities
•Using the Book on CD for Practical PC, work through ALL of
•Chapter 11, Making Spreadsheets
•Complete ALL parts of Lab 5 and verify (You will later transfer this information into a D2L
dropbox)
•Complete Lab 6 and
verify (You will later transfer
this information into a D2L dropbox)
 |
• Word 2007 Outlines, video |
| • Word 2007 Bibliography, video |
•Continue
•Lab
9/10, Capstone Project
•My notes duplicate my traditional class lecture, the point of which is to try to fill in the gaps left by text books.
•Your book doesn't cover the following:
Excel Key Points
Excel is a spreadsheet, a program for manipulating
numbers.
A spreadsheet is composed of tables, which
are made up of rows and columns; the intersection is a cell
Most work in spreadsheets are done using
formulas, such as =3+5, or =A1-B2
Compound or complex formulas are called
functions, such as =sum(A1:B2)
•Excel related glossary
•Keys
to Excel (pdf)
About links on my webpages
I expect you to read each linked item above at least once.
Most of these linked web pages will have links, too.
Some of these links continue the topic, some of the links are for optional, additional information, but some links refer to pages you have already read...
those links are there not to force you to re-read a page you have already seen, but simply for easy access to something related, IF you need a reminder, for examples, etc.
•Additional information you may wish to look over
Video,
similar to the Excel Lab
• Additional notes on using Excel
• Are you used to Word 2003, and trying to use to Word 2007
•Submit by 11:59 pm, Friday, of the current week (see due
dates)
• Test 2, the Mid-term
• Using
D2L Quizzes
•After taking your test, you may Calculate
your current GPA, if you like
• Lab 5 and Lab
6 as directed
• MUD 7 (My Understanding, Details) Respond
in the class D2L Discussion forum to the following:
What topics, if any, during this time frame
do you feel very comfortable with? Why?
What topics, if any, during this time frame
do you not feel comfortable with?
• Participation Discussion 7 Respond
in the class D2L Discussion forum to the following:
Questions on the review?
• MUD 8 (My Understanding, Details) Respond
in the class D2L Discussion forum to the following:
What topics, if any, during this time frame
do you feel very comfortable with? Why?
What topics, if any, during this time frame
do you not feel comfortable with?
• Participation Discussion 8 Respond
in the class D2L Discussion forum to the following:
Discuss Word's MLA features
for Labs that require files to be electronically submitted
• select all the files required, or better, select the folder that contains all the files
• zip the required
file(s) and/or folder(s)
• rename the
zipped file to reflect your name and the lab being turned in
•Example: yourname-lab1 or yourname-lab1.zip
(if your extensions are visible)
(For additional help on selecting, zipping,
or renaming files, see Windows
Crash Course)
If submitting by Temple College Desire2Learn:
•Log into D2L, scroll to the bottom, and choose the
correct course
•When the Course Home Page appears,
click on the desired tool link.
eLearning Tour; elearning Tour Tutorial on Discussions; eLearning Tour Tutorial on Dropbox; eLearning Tour Tutorial on Quizzes
• to
Checklist
Checklist
Did you:
•Take Test 2
• Submit Lab 5 and Lab 6
as directed
• Reply to Participation Discussion Topic 4 and MUD 4 in Desire2Learn
(D2L)
to Overview 4