CIT105P


Overview of CIT 105P

CIT 105P
Topic of Class:
How to use software tools & understand PCs.
Type of Class:
HW/SW, Hands-on Lab Class
Homework:
MS Office Pro Software
Type of Homework:
(100 pts, 10%) Lab Assignments
Final Segment:
(100 pts, 10%) Final Project
Quizzes:
(800 pts, 80%) Quizzes, 80 Questions
Total%:
(1000 pts Total, 100%)
Extra Credit:
Yes; See Assignments Page
   
  • People usually take both CIT105P & CIT106P together (as recommended), since they are offered as part of the CIT PACE Block of classes (although it is no longer required to take them together).
      • If you are taking these classes together remember that you are enrolled in two different classes that have two different perspectives on computers:
        • CIT 105P: A Hardware/Software View of Computers (Hands-on Lab Assignments - practical work).
        • CIT 106P: A Societal View of Computers (Reading & Writing Assignments - concepts and issues).
  • See the Orientation video on tips to get started.
    • Look at the Calendar Schedule and the Weekly Info for more details of how to coordinate the assignments.
    • The Assignments Page for more detail on the Assignments themselves.
    • See the Syllabus Page for more info about getting the textbook.
    • See the Email HW Page for info on how to submit Homework Assignments.
  • The software for CIT105P, Microsoft Office Pro, is available in the UMKC Computer Labs. Educational and Home versions are available commercially for less that $100, though without the database. The Pro will run a couple of hundred dollars per year via subscription depending on how many computers are being licensed to run it. The campus bookstore has discounted student versions. It is not required to purchase the software, but you are expected to use this particular software.
  • Microsoft Office Pro provides the various software tools used in the CIT105P class:
    • Word Processing (Word),
    • Spreadsheet (Excel),
    • Database (Access), - - - (Note, the database is not available for Macs.)
    • Presentation software (Power Point).
    • Also these applications, though they are not covered in the course:
      • Publisher (desktop publishing)
      • Outlook (email client)
      • One Note (general purpose information holder)
  • No book is listed for the software and most of what you need will be on these pages and available by exploring the program. However, the Dummies books for Microsoft Office give a good reference source for a low price (around $35). If you are working with MS Office and need a reference, this is a good book to keep around.
  • Course Materials and Quizzes can be found on the Blackboard Course Content link on the left side of your screen.
  • Grades are available on the Blackboard My Grades link (or on the Tools link), also on the left side of your screen.

Estimated Work Hours (for an 8-week session*)

CIT105P is a 4 credit hr class. Each credit requires 45 student work hrs per session.
This figures out to 4 * 45 = 180 work hrs per course.
To plan your class work hours for this course, use the following guidelines.

(*Based upon an 8-week session; Double your weekly time for 4-week session.)
Reading time is based upon an average of 25 pages per hour.

CIT105P Student Work Hours

Activity:
Weekly
Total
Online Engagement: (~8 hours per week)
Read Website, read instruction docs 2.5 20
Take Quizzes (1-3 Chapters weekly) 1 8
Online Practice Exercises 4 32
Offline Preparation: (~16 hours per week)
Skim & Study Chapters (1-3 Chapters weekly) 5 40
Study for Quizzes (1-3 Chapters weekly) 4 32
Homework Assignments 4 32
Final Project 2 16
TOTAL HOURS 22.5 180
   

 


Online Helpers

Below is a set of starting links to various YouTube tutorials on the software programs used above. This is just a starting set. You will see large numbers of such videos of various usefulness.

Remember, the most useful tutorial is your own, very personal, experience on the keyboard, simply trying out every nook and cranny and keystroke you can find. Too much reading or too much viewing before actually typing away on the keyboard will impede your progress. The best way to learn is to jump in. You won't blow up your compter.

The actual physical experience of working in the programs and exploring the programs will make more sense faster. The experience helps you make sense of the "instructions" because that physical experience gives you a working context in your head. That in turn will help your keyboarding experiences. Move back and forth between reading/viewing and working to retain the most information.

 

Hints and Tips and Tutorials (A Starting Point, ONLY!)

 

Microsoft Access Tutorials on YouTube (a starter list only)

Just Google for "Microsoft Access tutorial" for more (hint, there are tons of these)

Access - making a database - Access 2016
https://www.youtube.com/watch?v=PBhftKTmdHI

Tutorial for Beginners - Access 2016
https://www.youtube.com/watch?v=qaQflNwD4hc

Beginners MS Access 2007 Database Tutorial 1 - Introduction and Creating Database
https://www.youtube.com/watch?v=BUE-XJEHp7g

Beginners MS Access 2007 Database Tutorial 2 - Table Filter, Sort & Introduction Forms
https://www.youtube.com/watch?v=_PZAqojDEIw

Beginners MS Access 2007 Database Tutorial 3 - How To Create Forms with Buttons and Charts
https://www.youtube.com/watch?v=8PiD4awKjQw

Beginners MS Access 2007 Database Tutorial 4 - Creating Queries
https://www.youtube.com/watch?v=XQ6ixJc8Q_Y

How to Create a Stock Management Database in Microsoft Access 2010
https://www.youtube.com/watch?v=9HRmSRR29fY

Same, without the distracting background music
https://www.youtube.com/watch?v=049IlFNcrl0&t=0s

 

A Few YouTube links for Microsoft Excel (a starter list only)

Just Google for "Microsoft Excel tutorial"

Excell 2016 tutorial
https://www.youtube.com/watch?v=HacWD9HSww0

Excel 2016 Tutorial: Learn Excel in 30 Minutes - Just Right for your New Job Application
https://www.youtube.com/watch?v=7RCdzTpKO0A

Excel Tutorial | 20 Tricks & Shortcuts That Can Make Anyone An Excel Expert
https://www.youtube.com/watch?v=MLz1gjnQfes

 

A few YouTube links for Microsoft Word (a starter list only)

Just Google for "Microsoft Word tutorial"

Microsoft Word 2016 - Full Tutorial for Beginners [+General Overview]* - 13 MINS!
https://www.youtube.com/watch?v=2bQSJPQhafg

Introduction to Microsoft Word 2016 - Getting Started Tutorial for Beginners
https://www.youtube.com/watch?v=eDEVNcSArlc

Word Basics - Tutorial for Beginners - Microsoft Word 2010, 2013, 2016 Office 365, Getting Started
https://www.youtube.com/watch?v=prpVvtHB24M

 

A few YouTube links for Microsoft PowerPoint (a starter list only)

Just Google for "Microsoft PowerPoint tutorial"

PowerPoint 2016 Tutorial - A Complete Tutorial on Using PowerPoint - Full HD 1080P
https://www.youtube.com/watch?v=lbc1HX8Jccw

10 Things PowerPoint Beginners Want to Know How to Do
https://www.youtube.com/watch?v=Xv2x2c-Zmrg

How to avoid death By PowerPoint | David JP Phillips | TEDxStockholmSalon
https://www.youtube.com/watch?v=Iwpi1Lm6dFo

Microsoft PowerPoint 2016 - Full Tutorial for Beginners [ 14 MINUTES! ]*
https://www.youtube.com/watch?v=tQicwstinOA