CSCI100: Intro to Computers

Updated 2019-08-20

Syllabus     Catalog Description     BCU's Academic Integrity Statement     Email Guidelines     Grades Online     Windows Resources     Internet Resources     Word resources     PowerPoint Resources     Excel Resources     Email resources      Finals Schedule       Academic Calendar     Personal gradebook

Final Test:

8:00 class: Wed, 12/11/19, 8:00-9:50. 9 :00 class: Mon, 12/09/19, 8:00-9:50. 10:00 class: Tue, 12/10/19, 10:00-11:50.
All students are expected to take the final at the day and time scheduled for their class. Make travel plans accordingly.

Day #01. Monday, 8/19/2019. Security

·          Interesting tech: the future of football?

·          Syllabus

·          BCU IT Competency: Requirement, Objectives

·          Getting Office: Office 365 University is now free. Go to It comes with a terabyte of storage on OneDrive.

·          OneDrive

·          Skills needed in the workplace, 2015-2020

·          How secure is your password? Check it. Don’t use these: Worst passwords.

·          Useful software: LastPass password manager. For Android. For iPhone.

·          Can you multitask? (no)

Homework due at class time Wednesday:

·          FREE homework assignment: This is an assignment: Computer experience survey, Word Processing skills survey, Spreadsheet skills survey. There is nothing to hand in. I will look at your survey online.

·          Class policies for assignments and tests (print a hard copy, READ, sign, and bring to next class).

·          Memorize Windows keyboard shortcuts (nothing to hand in) in preparation for a quiz next class. The quiz will begin promptly at the class starting time.

Interesting stuff:

·Dorm tech 1, Dorm tech 2


Earlier classes are below…















Check password, password manager (Last pass)



Set "Do Not Disturb" on iPhone while in class:

f you don't want to be bothered while you're at work, at an event, or even working out, you can now turn on Do Not Disturb based on your location.

Do Not Disturb helps you be more productive by keeping you off your phone and focused on the task at hand. And by enabling the location setting, you won't have to remember about turning the feature off later on.



Day #02. Wednesday, 8/21/2019. Windows, the Internet

·Quiz over Windows keyboard shortcuts

·Interesting tech: LastPass on iPhone

·Using the Briar Cliff Network

·BCU Email: Using Briar Cliff Email from the web, Emailing guidelines & file naming conventions, on your iPhone, on your Android phone

·Using the Internet: Internet Resources

Homework due next class at class time:

Day #03. Monday, 8/26/2019. XL 1. Formatting

·Interesting tech: a "knowledge engine": Wolfram Alpha

Homework due next class at class time:

Day #04. Wednesday, 8/28/2019. XL 2. Formulas, Functions, and Relative Cell References

Homework due next class at class time:

9/02/2019: Labor Day.

Day #05. Wednesday, 9/04/2019. XL 3. Formulas with Absolute/Mixed Cell References

Homework due next class at class time:

Day #06. Monday, 9/09/2019. XL 4. Databases: Sorting and Filtering

Homework due next class at class time:

Day #07. Wednesday, 9/11/2019. XL 5. Charts

Homework due next class at class time:

Day #08. Monday, 9/16/2019. XL 6. Logical Functions

Homework due next class at class time:

Day #09. Wednesday, 9/18/2019. XL 7. Databases: Pivot Tables, Pivot Charts

Homework due next Wednesday at class time:

Review for test:

Day #10. Wednesday, 9/25/2019. Excel Test 1

Day #11. Monday, 9/30/2019. XL 8: 3D Workbooks

Homework due next class:

Day #12. Wednesday, 10/02/2019. XL 9. VLOOKUP, another way to make decisions

Homework due next class:

Day #13. Monday, 10/07/2019. XL 10. Databases: Advanced Filters and "D" Functions

Homework due next class:

Day #14. Wednesday, 10/09/2019. XL 11. Dates and Times

Homework due next class:

Day #15. Monday, 10/14/2019. XL 12: Financial functions

Homework due next class:

Review for Excel test:

Day #16. Wednesday, 10/16/2019. Programming!

Homework due (Wednesday, 3/27/2019):

Take a screen shot (press the PrtScr key). This will copy it to the clipboard. Open a Word document. Paste your image from the clipboard into your Word document. Save and submit the Word document in the drop box.

Day #17. Monday, 10/21/2019. Excel Test #2

Day #18. Wednesday, 10/23/2019. Word 1. Short documents.

Homework due next class:

Day #19. Monday, 10/28/2019. Word 2. Skills for writing a term paper

·Today's files: Lincoln (find/replace), Red-Headed League (find/replace), Christmas Carol.

Homework due next class:

Day #20. Wednesday, 10/30/2019. Word 3. Positioning text with tabs

Homework due next class:

Day #21. Monday, 11/04/2019. Word 4: Tables

Homework due next class:

Day #22. Wednesday, 11/06/2019. Word 5: Pics, text boxes, WordArt, etc.

Homework due next class:

Day #23. Monday, 11/11/2019. Word 6: Newsletter skills

Homework due next class:

Day #24. Wednesday, 11/13/2019. Word 7: Styles and themes

Homework due next class:

Day #25. Monday, 11/18/2019. PowerPoint 1.

Homework due next class:

Day #26. Wednesday, 11/20/2019. PowerPoint 2.

Homework due next class:

Day #27. Monday, 11/25/2019. PowerPoint 3.

Homework due Friday at 11:59 p.m.:

Day #28. Monday, 12/02/2019. Word/Excel: Mail Merge

Day #29. Wednesday, 12/04/2019. Review for Final


Final "Homework" assignment:

Click on the links below and complete all three questionnaires. This is an assignment. If you answer all questionnaires, you will get 100 on the final assignment. If not, you will get a 0. Please consider answering the long questions on the BrightSpace questionnaire.

Practice tests

Day #29. Monday, 11/25/2019

Day #30. Monday, 12/02/2019

Day #31. Wednesday, 12/04/2019

Final Test


Earlier classes are below…















Monday, 4/22/2019. NO CLASS. Easter Monday.

Day #25. Wednesday, 4/24/2019. Word 8: Mail merge

Homework due next class:


Bell ringers


·          Virtual Reality in medicine

·          Interesting tech: Mini-drones


·        Interesting tech: Sprout

·        Interesting tech: Microsoft Continuum

·        Interesting tech: Falcon Heavy

·        Today's robots

·        Interesting tech: How the Internet works (a packet's tale)

·        Interesting tech: Where is the "cloud"?






·          Bud logs in


Augmented reality

·          Interesting tech: Volvo and Hololens

·          Interesting tech: Getting started with Hololens

·          Interesting tech: Augmented Reality (IKEA)


·          Interesting tech: Amazon's robots

·          Interesting tech: Humanoid robots

·          Interesting tech: Robot swarm

·          Interesting tech: Androids


·          Interesting tech: Apple pencil

·          Interesting tech: Surface Pro

·          Interesting tech: Raspberry Pi Zero


·          Interesting tech: Space-X, May 2016. Space-X, May 2016 Day landing

·          Interesting tech: Space-X.

Language translation

·          Interesting tech: Star Trek: Universal translator

·          Interesting tech: Skype: Universal translator

·          Interesting tech: Black Friday.

·          Interesting tech: Star Trek is here!


·          Interesting tech: Bubba's hovercraft


·          Interesting tech: Flying with Oculus Rift

·          Interesting tech: Virtual Reality in medicine


·          Interesting tech: Singlecue

·          Interesting tech: 3D Printing

·          Interesting tech: Flexible LEDs

·          Interesting tech: 3D printer in action, 3D printer products

·          Computer Hardware

·          Computer myths from TV and the movies

·          Inexpensive smart phone

·          Johns Hopkins closes medical library

·          Pope Benedict vs. Pope Francis: Change in cell phone use in 8 years. Pic

·          Ten things everybody should know how to do in a word processor.

·          Top 5 soon-to-be-obsolete technologies

·          Interesting tech: Samsung batteries

·          Interesting tech: Transformer

Useful software

* Norton Eraser

*       Pixlr: Online photo editor

·          LastPass: password manager. Also: DashLane

·          Audacity: powerful audio editor

· powerful photo editor

·          Office Lens

·          Office online, Office on your phone

·          Awesome Internet application: OneDrive

·          Other search engines: Ixquick, DuckDuckGo, Blekko

·          Free computer security. Don't pay for it.

·          PhotoStory

·          IrfanView

·          Libre Office

·          Lightworks (video editor)

·          Windows 10 User Interface, Windows 10 Edge browser


Word file. PowerPoint file.