CSCI100: Intro to Computers

Updated 2019-11-13

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 #24. Wednesday, 11/13/2019. Word 7: Styles and themes

·          Interesting tech: Project x-ray

·          Word 2019 resources.

Homework due next class:

·          Instructions. Use this file. Your result should look like this.

 

Earlier classes are below…

 

 

 

 

 

 

 

 

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

·          Interesting tech: Computers in medicine

·          Interesting tech: Monitor innovations

·          Sample file

·          Word 2019 resources

Homework due next class:

·          Linux News. Instructions. Create from this file. Your result should look like this (your shading may vary).

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

·          Interesting tech: Apple patent application

·          Word 2019 resources.

·          Alignment: File. Pic.

·          Picture tools: Desert (remove sky), overexposed (fix exposure), underexposed (fix exposure)

Homework due next class:

·          Christmas Concert. Instructions. Create from scratch. Your result should look similar to this.

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

·          Interesting tech: A cool "printer"

·          Word 2019 resources.

·          Sample file

Homework due next class:

·          Tabs and Tables. Instructions. Unformatted file.

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

·          Interesting tech: Biometrics

·          Interesting tech: OneNote

·          OneNote notebook. Open in OneNote 2016. ˙+S, ˙+n. OneNote web clipper for Chrome

·          Word 2019 resources.

Homework due next class:

·          This is a free homework assignment. Add a profile picture to your BrightSpace account before class begins on Monday. Hint: click on the picture placeholder at the top right. Your picture must be a portrait (your face is more than half of the height of the total image). Passport photo requirements.

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

·          Interesting tech: Skype translator in the classroom

·          Word 2019 resources.

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

Homework due next class:

·          Instructions. Unformatted file. The first three pages of your document should look like this.

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

·          Interesting tech: Project Linda

·          Check your grade in Bright Space: Resources | Class Progress. Check Current, Maximum Final, Minimum Final. Personal gradebook

·          Word 2019 resources.

·          Today's sample file.

Homework due next class:

·          Film Festival. Instructions. Unformatted File. Your result should look like this.

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

·         If Test #1 is on your desktop, delete it before opening test #2.

·         Download the test. Save to your desktop. Put in the drop box when done.

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

·          Test is next Monday: 10/21/2019

·          How to acquire a superpower

·          Tutorial 1: Ice etching.

·          If you finish Tutorial 1, you can try Tutorial 2: Flappy Bird.

Review for Excel test:

·          Practice test

·          Practice test solution (Excel file)

·          Practice test solution part 1, part 2 (videos)

Homework due (Wednesday, 10/23/2019):

·          On the last step (step #20) of the Code with Anna and Elsa (Tutorial 1 above), create an image that meets the following requirements. Each is 20%.

1.    There must be 3 snowflakes,

2.    Each snowflake must be a different color. Do NOT use random colors; set your own color.

3.    All snowflakes must be completely visible on the screen.

4.    They must not overlap.

5.    There must not be a line connecting the snowflakes (use the Jump command to move from snowflake to snowflake so there is not a line on the screen connecting the snowflakes)

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 #15. Monday, 10/14/2019. XL 12: Financial functions

·          Test is one week from today: 10/21/2019

·          Ben Franklin

·          Compound Interest, 8th wonder of the world

·          Average annual stock market return

·          The millionaire next door

·          Excel Resources

·          Financial functions template

·          Financial functions examples

·          Interesting spreadsheet

Homework due next class:

·          Financial functions.

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

·          Turning off your phone.

·          Interesting tech: Microsoft's vision of the future

·          Excel Resources

·          Cool applications of Excel's date functions: Birthday, Calendar

Homework due next class:

·          Dates and Times: Employee instructions. Employee spreadsheet.

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

·          Interesting tech: Fake video

·          Excel Resources

Homework due next class:

·          Advanced Filters, "D" functions: Employee Data (instructions are included in the spreadsheet).

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

·          Interesting tech: Raspberry Pi 3.

·          Excel Resources

Homework due next class:

·          Invoice with VLOOKUP: Instructions. Data file.

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

·          Interesting tech: Foldable Galaxy (2nd try)

·          Test results

·          Excel Resources

Homework due next class:

·          3D Workbooks: Staff Expenses. Instructions. Excel File.

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

·          Test

Homework due a week from next Monday 9/30/2019 at class time:

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

Monday, 9/23/2019. NO CLASS. Campus service day.

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

·          First test is Wednesday, 9/25/2019, over Excel topics 1-6.

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

·          New Windows clipboard

·          Excel Resources

Homework due a week from next Monday 9/30/2019 at class time:

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

Review for test:

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

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

·          First test is Wednesday, 9/25/2019, over Excel topics 1-6.

·          Interesting tech: Ambulance drones

·          Excel Resources

·          Samples file

Homework due next class at class time:

·          Logical functions: Buying stocks. Instructions. Data file.

Review for test:

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

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

·          Interesting tech: 200 countries, 200 years

·          Excel Resources

·          Sample file. Go to the 5.1 Football worksheet.

Homework due next class at class time:

·          Charts. Create your charts from scratch.

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

·          Interesting tech: Cars

·          Check grades.

·          Excel Resources

·          Sample file: Advising.txt

Homework due next class at class time:

·          Sorting and filtering: BCU Sales. Directions are in the workbook.

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

·          Interesting tech: Seeing AI

·          Bright Space: Download graded Excel homework and check grades.

·          Excel Resources

·          Sample file. Go to the 3.1 Budget worksheet (its tab is orange).

Homework due next class at class time:

·          Investment. Instructions. There is no data file. Create the file from scratch. Your file should look like this.

9/02/2019: Labor Day.

Day #04. Wednesday, 8/28/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 2019

·          Excel Resources

·          Samples file

Homework due next class at class time:

·          Excel formulas: Girl Scout Cookies. Instructions. Data file. Result should look like this.

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

·          BCU Email: Using Briar Cliff Email from the web, Emailing guidelines, Drop boxes, email on your iPhone, email on your Android phone

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

·          Interesting app: Office Lens

·          Survey results

·          Excel Resources

·          Sample file

Homework due next class at class time:

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

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

·          Quiz over Windows keyboard shortcuts

·          Interesting tech: LastPass on iPhone

·          Interesting tech: What happens on the Internet in one minute

·          Useful software: Reader View add-on for Chrome

·          Set up OneDrive

·          More security:

·          Can you tell if you are being phished? Phishing quiz.

·          Protect yourself: Quad9

·          Useful software: CCleaner: clean up your computer

·          Useful software: MalwareBytes: clean up your computer

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

·          Useful software: Belarc Advisor: inventories your computer hardware and software

·          Using the Briar Cliff Network

·          Windows: Windows 10

·          Using the Internet: Internet Resources

Homework due next class at class time:

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

·          (2) Another free 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 will 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 like this (the head/face fills the circle—with such a small area, you need to zoom in on the fact to be recognizable), not like this. Somebody should be able to recognize you by looking at the picture. There is no drop box for this, so send me an email when you are done before class time so I can see your picture.

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 www.office.com. 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

 

 

 

 

 

 

 

 

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 #28. Monday, 11/18/2019. Word/Excel: Mail Merge

Day #25. Wednesday, 11/20/2019. PowerPoint 1.

Homework due next class:

Day #26. Monday, 11/25/2019. PowerPoint 2.

Homework due next class:

Day #27. Monday, 12/02/2019. PowerPoint 3.

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

Day #28. 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…

 

 

 

 

Test

 

 

 

 

 

 

 

 

 

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

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

·          Word 2019 resources.

Homework due next class:

2019

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

* Norton Eraser

*       Pixlr: Online photo editor

·          LastPass: password manager. Also: DashLane

·          Audacity: powerful audio editor

·          Paint.net: 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.