CIT-105 Full Course Menu

All links open in a new window

 

Syllabus (RTF file download)

Calendar for CIT 105

Weekly information (notes) (RTF file download)

Course Overview for 105

Contact information and email

CIT-105

Assignments

Asn 0 - Introductory Bio

Asn 1 - Internet Assignment

Asns 2 - Word Processing Assignment (2 assignments: Asn#3, styles and stylesheets, is for extra credit)

Asns 3 and 4 - Spreadsheet Assignments

The two spreadsheet assignments are exercises using Microsoft Excel which is part of the Microsoft Office suite of programs.

Asn 3 - SS1 - Loan Calculator

Asn 4 - SS2 - Budget, Investment

Asn 5 - PowerPoint Assignment - Short Version, instructions for both Asn 5 and Final Proj (same as below)

Asns 6, 7 and 8 - Database Assignments

The database assignments are all based around a program in the Microsoft Office Suite, Microsoft Access. Microsoft's Access database program is only available on Windows but was chosen because it is almost ubiquitous in offices. It is the most common database program you will find in the workplace.

Those of you on Macintosh computers will not have it available. There are more than enough points available in other exercises to get you to an A so this is not crucial but if you still want to get some time on a database, to get a feel for how databases work, there are a lot of Windows machines available in computer labs on campus with Microsoft Access loaded on them. Just open up the Microsoft Office suite and pick "Access" from the pull down menu, or, depending on Windows version, click on the Window Icon in the lower right and pick "Access" from the menu, or click on the "A" for Access icon on the task bar.

Asn 6 - Database Assignment 1

Asn 7 - Database Assignment 2

Asn 8 - Database Assignment 3

Asn 9 - Integraton Assignment - Combines more than one lesson in Word Processing, Spreadsheet

Asn 10 - PC Wish List, Buying a PC

Final - Power Point assignment and Final Project

 

Video Orientation

 


* For a larger resolution (1280x720), or if you don't see the video, go to Vimeo at https://vimeo.com/199193329 for the orientation video.

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