Current Timeframe Course Overview

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:
   • Finished Lab 4
   • Read Practical PC chapter 11, Making Spreadsheets
   • Review Excel from your Office book, as needed

Reminder: Did you check your TC WebMail? Did you check the Quarantine folder?
Did you check the D2L Dropbox, to View feedback? Did you check D2L Grades for feedback? (You may have to scroll down)

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)

•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 4 (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 4 Respond in the class D2L Discussion forum to the following:
      How can you use Excel's 'What if' when you are planning a budget?
• Using D2L Discussions    • Using D2L dropbox       • Using D2L Quizzes      • Logon to D2L

              •You may click on Discussions, Dropbox, or Quizzes below, for more info
D2L navigation

• to Checklist

For the next time frame:
• Read Practical PC chapter 6, Protecting your files
• Review PowerPoint from your Office book, as needed
•Each test has a review; you may wish to write out pertinent information from the readings and activities
•After completing this overview, you may wish to start on the next Overview material, and preview Lab 7

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