CSCI100 Intro to Computers

Updated 2013.05.08

Syllabus Catalog Description BCU's Academic Integrity Statement Email Guidelines Grades Online

Windows Resources Internet Resources Word resources PowerPoint Resources Excel Resources Email resources

Final test for 8:00 class: Monday, 5/13/2013 at 8:00 a.m.

Final test for 9:00 class: Thursday, 5/16/2013 at 8:00 a.m.

Day 28. Wed 5/08.

· Word practice test

· Video solution: Part 1, Part 2, Part 3

· PowerPoint practice test

· Video solution: Video, SmartArt formatting

Homework due at the end of class today.

· Questionnaire. Go to the web page and answer the questions. Rate your knowledge before this class began (THEN) and at the end of this class (NOW). Click on the Submit button when done.

Earlier classes are below…

Day 27. Mon 5/06. PowerPoint 3: Animation, tables, charts.

· PowerPoint resources. Notes.

· Sample files: New Homes, Pics.

· Sample files: Development.

· An interesting PowerPoint alternative: Prezi

Homework due Wednesday at 7:30 a.m.

· PowerPoint Commercial Development. Put a digital copy in the drop box.

Day 26. Wed 5/01. PowerPoint 2

· Useful program: Malwarebytes

· PowerPoint resources, Notes. Welcome, Pics.

· Video 1: Formatting Slide Elements

· Video 2: Formatting Pictures and Shapes

· Video 3: Transitions and SmartArt

Homework due Monday at 7:30 a.m.

· PowerPoint Sioux CitySummer. Pics. Deposit a digital copy in the drop box.

Day 25. Mon, 4/29. PowerPoint 1

· Where is the "cloud"?

· PowerPoint resources

· Notes, Bakery Expansion

Homework due Wednesday at 7:30 a.m.

· PowerPoint BCU Holidays. Deposit a digital copy in the drop box.

Day 24. Wed 4/24. Word 7: Large Documents, Mail Merge

· Microsoft Office 2019

· Word styles and large documents. Word resources

Homework due next Monday at 7:30 a.m.

· Styles: Web design document. Instructions. File to edit. Put your document in the drop box for homework #6.

· Mail Merge. Put both of your files in the Homework #7 drop box at the same time. If you do not put them in the drop box at the same time, you will be docked 10%.

Day 23. Mon 4/22. Word 6: Illustrations

· How to acquire a Superpower. No mask, tights, or cape required.

· Word: Illustrations. Word resources

· Pics: Desert, overexposed, underexposed

Homework due Wednesday at 7:30 a.m.

· Fourth of July. Instructions. Create from scratch. Your result should look like this. Put your Word document in the drop box.

Day 22. Wed 4/17. Word 5: Newsletter skills

· Useful program: Belarc Advisor

· Creating a newsletter in Word. Word resources

Homework due Monday at 7:30 a.m.

· Skiing newsletter. For instructions, see handout. File to edit.

Day 21. Mon 4/15. Word 4: Tables

· Word: tables. Word resources

Homework due Wednesday at 7:30 a.m.

· Tabs and tables. Instructions.

Day 20. Wed 4/10. Word 3: Breaks, tabs

· Another cut/paste option: source format or destination format? Doc1. Doc2.

· Word: Breaks, tabs. Word resources

Homework for Monday

· None

Day 19. Mon 4/08. Word 2: Writing a paper

Skills for writing a term paper

· Today's sample file

· Setting spacing between paragraphs

· Checking spelling and grammar

· Creating a cover page

· Headers and footers: creating and editing

· Headers and footers: inserting page numbers

· Headers and footers: inserting the current date

· Adding Citations

· Adding a Works Cited list

· Bulleted Lists

· Numbered Lists

Homework due Wednesday at 7:30 a.m.

· Instructions. File to edit. Your result should look like this.

Day 18. Wed 4/03. Word 1: Basics.

· Word: Basic skills, Word resources

Homework due Monday at 7:30 a.m.

· Letter to President. Your solution should look like this.

Monday, 4/01. Easter Monday. No class.

Day 17. Wed 3/27. XL Test, part 2

Day 16. Mon 3/25. XL Test, part 1

Day 15. Wed 3/20. XL Review

Day 14. Mon 3/18. XL 12: Date & Time Functions

· Nerd news: Leap Motion

· Date functions. Videos: Date Serial Numbers, Date Functions

· Time functions. Videos: Time Serial Numbers, Time Functions

Homework due Wednesday at 7:30 a.m.

· Employees. Deposit a digital copy in the drop box. There is no hard copy to hand in.

March 11-15: Spring Break!

Day 13. Wed 3/06. XL 11: Other ways to make decisions

· Conditional formatting. Video

· VLOOKUP. Video

Homework due Monday 3/18/2013 at 7:30 a.m.

· Gradebook. Deposit a digital copy in the drop box. There is no hard copy to hand in.

Day 12. Mon 3/04. XL 10: Database: Advanced Filters, "D" Functions

· How the Internet works

· Advanced filters. Video 1. Video 2.

· Database functions. Video: DSum, DCount, DAverage. Video: DMax, DMin, DCountA.

Homework due Wednesday at 7:30 a.m.

· Real Estate. Deposit a digital copy in the drop box. There is no hard copy to hand in.

Day 11. Wed 2/27. XL 9: Financial Functions

· Nerd news: Internet Explorer 10 on Windows 7, Portable computers, Interesting tech: CAVE2

· Financial functions: FV, PMT, PV, RATE, NPER

· Spreadsheet template

· Spreadsheet examples

· Videos: FV (savings), PMT (loan), PMT (savings), PV (loan), PV (savings), PV (lottery), RATE (savings), RATE (loan), NPER (savings), NPER (loan)

Homework due Monday at 7:30 a.m.

· Financial functions. Deposit a digital copy in the drop box. There is no hard copy to hand in.

Day 10. Mon 2/25. XL 8: 3D Workbooks

· Useful program: Secunia PSI (personal software inspector)

· 3D workbooks.

Homework due Wednesday at 7:30 a.m.

· Jewelry Sales. Deposit a digital copy in the drop box. There is no hard copy to hand in.

Day 9. Wed 2/20. XL 7: Databases: Pivot Tables and Pivot Charts

· Pivot Tables.

· Pivot Table Videos. Lists, Tables, Sorting, Filtering, Field Settings

Homework due Monday at 7:30 a.m.

· Weather Pivot Tables. Deposit a digital copy in the drop box. There is no hard copy to hand in.

Day 8. Mon 2/18. XL 6: Logical Functions

· Logical tests video

Homework due Wednesday at 7:30 a.m.

· Stocks. Deposit a digital copy in the drop box. There is no hard copy to hand in.

Day 7. Wed 2/13. XL 5: Charts

· An interesting search engine: Wolfram Alpha

· Charts: Excel Resources

· Another resource: Jon Peltier charting pages

Homework due Monday at 7:30 a.m.

· Charts. Deposit a digital copy in the drop box. There is no hard copy to hand in.

Day 6. Mon 2/11. XL 4: Database Sorting and Filtering

· How much junk is on your computer? Check it.

· XL database: import data, sort, auto-filter. Excel Resources

· Videos: Sorting—Single Key, Sorting—Compound Key, AutoFiltering Text Fields, AutoFiltering--Numeric Fields, AutoFiltering--Compound Conditions

Homework due Wednesday at 7:30 a.m.

· Football Coaches. Deposit a digital copy in the drop box. There is no hard copy to hand in.

Day 5. Wed 2/06. XL 3: Absolute Cell References

· Awesome Internet application: SkyDrive

· Sample file. Budget, addition, compound interest.

· Copying formulas: Relative vs. Absolute cell references. Excel Resources

· Absolute cell references video

Homework due Monday at 7:30 a.m.

· Budget. Deposit a digital copy in the drop box. There is no hard copy to hand in.

Day 4. Mon 2/04. XL 2: Functions, Relative Cell References

· The new version of Office.

· Sample file.

· Topics: Basic arithmetic, AutoFill, basic formulas, relative cell references.

· Excel Resources

· Videos: Autofill. Basic Formulas. Relative cell references.

Homework due Wednesday at 7:30 a.m.

· Passing Stats. Deposit a digital copy in the drop box. There is no hard copy to hand in.

Day 3. Wed 1/30. XL 1: Formatting

· Nerd news: Microsoft Office 2013 is available.

· How secure is your password? Check it.

· Google Chrome portable version. Download to your desktop.

· Excel basics. Excel Resources.

Homework due Monday 2/04/2013 at 7:30 a.m.

· Formatting: WKRP. Deposit a digital copy in the drop box. There is no hard copy to hand in.

Day 2. Mon, 1/28: Internet

· Quiz over Windows keyboard shortcuts.

· The Internet: Internet Resources

Homework due Wednesday at 7:30 a.m.

· Web scavenger hunt. Insert your answers into this Word document and put in the drop box.

Day 1. Wed 1/23: Windows

· Briar Cliff IT Competency Requirement

· Briar Cliff IT Competency Objectives

· Using the Briar Cliff Network

· Using Briar Cliff Email from the web

· Emailing guidelines, file naming conventions

· Windows keyboard shortcuts

Homework due Monday, 1/28/2013

· Computer experience survey. Fill out online before 7:30 a.m. Monday. This is an assignment.

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

· Memorize Windows keyboard shortcuts (see link above) for quiz. The quiz will begin promptly at the class starting time.

Other

·Quiz over Computer Hardware.

·Computer Hardware

·Can computers really do that stuff?

Earlier classes are below…

Use Index2 to complete.