CSCI100: Intro to Computers

Updated 2019-02-18

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: Monday, May 6, 2019, 8:00 to 9:50.
9:00 class: Wednesday, May 8, 2019, 8:00 to 9:50.
All students are expected to take the final at the time scheduled for their class. Make travel plans accordingly.

Day #09. Wednesday, 2/13/2019. XL 7. Databases: Pivot Tables, Pivot Charts

·        First test is Monday, 2/18/2019.

·        Interesting tech: Amazon Go (video). Amazon Go opens Chicago store 9/17/2018 (news story).

·        New Windows clipboard

·        Excel Resources.

Homework due Wednesday, 2/20/2019:

·        Pivot tables. Iowa Football. Instructions are in the Data File.

Review for test:

·        Practice test. Spreadsheet solution. Video solution: part 1, part 2.

Earlier classes are below…

 

 

 

 

 

 

 

 

 

 

 

 

Day #11. Wednesday, 2/20/2019. XL 8: 3D Workbooks

·        Test scores.

·        Check your grade.

·        Interesting tech: Raspberry Pi 3.

·        Excel Resources.

Homework due next class:

·        3D Workbooks: Southern Region Sales. Instructions. Excel File.

Day #10. Monday, 2/18/2019. Excel Test 1

·        Test

Day #08. Monday, 2/11/2019. XL 6. Logical Functions

·        First test is Monday, 2/18/2019.

·        Interesting tech: Ambulance drones

·        Excel Resources.

·        Sample File.

Homework due next class:

·        Logical functions: Buying olive oil. Instructions. Data file. (Spring, 2019)

Day #07. Wednesday, 2/06/2019. XL 5. Charts

·        Interesting chart: 200 countries, 200 years

·        Excel Resources.

·        Sample file.

Homework due next class:

·        Charts. Create your charts from scratch.

Day #06. Monday, 2/04/2019. XL 4. Databases: Sorting and Filtering

·        Interesting tech: Seeing AI

·        Check grades.

·        Excel Resources.

·        Sample file: Advising.txt

Homework due next class:

·        Sorting and filtering: All-time baseball hitting leaders. Directions are in the workbook.

Day #05. Monday, 1/28/2019. XL 3. Formulas with Absolute/Mixed Cell References

·        Useful Chrome extension

·        Check grades.

·        Excel Resources.

·        Sample file. Budget, addition table, loan payment table.

Homework due next class:

·        Rental income. Instructions. Data file. Your file should look like this.

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

·        Interesting TV tech from CES: LG Rollable TV, LG waterfall, Samsung 219" TV

·        Interesting tech: Font smoothing

·        Using Help in Office 2016

·        Excel Resources

·        Sample file.

Homework due next class:

·        Bookstore. Instructions. There is no data file. Result should look like this.

Day #3. Monday, 1/21/2019. XL 1. Formatting

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

·        Interesting app: Office Lens

·        Survey results

·        Excel Resources

·        Sample file

Homework due next class:

·        Excel formatting. Instructions. Data file. Your result should look like this.

Day #2. Wednesday, 1/16/2019. Windows, the Internet

·        Quiz over Windows keyboard shortcuts

·        Interesting tech: Cars

·        Useful software: Last Pass on iPhone

·        Useful software: Reader View add-on for Chrome

·        Windows: Windows 10

·        Using the Internet: Internet Resources

Homework due next class at class time:

·        (1) Web scavenger hunt (Spring, 2019). Hand in a hard copy at class time. No drop box for this assignment.

·        (2) World's easiest homework assignment: Add your pic to your Briar Cliff email: Go to web email, click on the picture placeholder on the far right (if you don't currently have a picture there, it may have your initials in it). From the drop-down menu, click on your initials (or current photo). When the Change Your Photo dialog box opens, click on the Upload a new photo link and upload a recognizable portrait of yourself (not an avatar or some celebrity or a shot of you on the football field). I am looking for a portrait, not this. To get credit, you must submit a portrait. Somebody should be able to recognize you by looking at the picture. Send me an email when you are done before class time so I can see your picture.

Day #01. Monday, 1/14/2019. Windows, the Internet

·        Interesting tech: the future of football?

·        Syllabus

·        BCU IT Competency: Requirement, Objectives

·        Getting Office: Office 365 University is now free. Go to www.office.com. It comes with a terabyte of storage on 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.

·        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

·        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…

 

 

 

 

 

 

 

 

 

 

 

 

 

Day #12. Monday, 2/25/2019. XL 9. VLOOKUP, another way to make decisions

Homework due next class:

Day #13. Wednesday, 2/27/2019. XL 10. Databases: Advanced Filters and "D" Functions

Homework due next class (Monday, 3/11/2019):

Spring Break: March 4-8, 2019

Day #14. Monday, 3/11/2019. XL 11. Dates and Times

Homework due Monday, 3/11/2019 :

Day #15. Wednesday, 3/13/2019. XL 12: Financial functions

Homework due next class:

Review for Excel test:

Day #16. Wednesday, 3/13/2019. Programming!

Homework due next class:

Day #17. Monday, 3/18/2019. XL Test #2

Day #18. Wednesday, 3/20/2019. Word 1. Short documents

Homework due next class:

Day #19. Monday, 3/25/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, 3/27/2019. Word 3. Positioning text with tabs

Homework due next class:

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

Homework due next class:

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

Homework due next class:

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

Homework due next class:

Day #24. Wednesday, 4/10/2019. Word 7: Styles and themes

Homework due next class:

Day #25. Monday, 4/15/2019. Word 8: Mail merge

Homework due next class:

Day #26. Wednesday, 4/17/2019. PowerPoint 1.

Homework due next class:

Monday, 4/22/2019: Easter Monday. No class.

Day #27. Wednesday, 4/24/2019. PowerPoint 2.

Homework due next class:

Day #28. Monday, 4/29/2019. PowerPoint 3.

Homework due next class:

Day #29. Wednesday, 5/01/2019

Final "Homework" assignment:

Click on the links below and complete all three questionnaires. This is an assignment. It is due at 5 p.m. Thursday, December 6. 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.

·Evaluation: On BrightSpace. It looks like this
https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/CSCI100/index2019_files/image001.jpg

Practice tests

Test

Bell ringers

More:

·          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"?

 

 

 

 

Passwords

·          Bud logs in

Internet

Augmented reality

·          Interesting tech: Volvo and Hololens

·          Interesting tech: Getting started with Hololens

·          Interesting tech: Augmented Reality (IKEA)

Robots

·          Interesting tech: Amazon's robots

·          Interesting tech: Humanoid robots

·          Interesting tech: Robot swarm

·          Interesting tech: Androids

Desktop/laptops

·          Interesting tech: Apple pencil

·          Interesting tech: Surface Pro

·          Interesting tech: Raspberry Pi Zero

Space-X

·          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!

Flying

·          Interesting tech: Bubba's hovercraft

VR

·          Interesting tech: Flying with Oculus Rift

·          Interesting tech: Virtual Reality in medicine

Misc

·          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

·          LastPass: password manager. Also: DashLane

·          Audacity: powerful audio editor

·          Paint.net: powerful photo editor

·          CCleaner: clean up your computer

·          MalwareBytes: clean up your computer

·          Secunia PSI: (personal software inspector) keeps programs up to date

·          Belarc Advisor: inventories your computer hardware and software

·          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.