CSCI100: Intro to Computers
Updated 2025-01-07
Syllabus Email Guidelines Word resources PowerPoint Resources Excel Resources Finals Schedule
· Getting Office: Office 365 University is now free. Go to www.office.com. It comes with a terabyte of storage on OneDrive.
· Excel formatting: Basketball box score. Instructions. Data file. Your result should look like this.
· Excel formulas: Payroll Instructions. Data file. Result should look like this.
· Sample file. Go to the 3.1 Budget worksheet.
· Sales. Instructions. Data file. Your file should look like this.
· Sample file: Advising.txt
· Sorting and filtering: Iowa Counties. Directions are in the workbook.
· Practice Test is on Monday, 02/03/2025.
· Excel Test 1 is on Wednesday, 02/05/2025 over Excel topics 1-6.
· Sample file. Go to the 5.1 Football worksheet.
· Create a line chart: Instructions. Data file. Result should look like this.
· Logical functions: Employee Retirement. Instructions. Data file. Your result should look like this
No class today
· Practice Test.
o Practice test. No submission is required.
· Test 1: Excel topics 1-6. Class attendance is mandatory.
Day #11. Friday 2/7/2025. Word 1. Short documents.
·
Today's sample
file
Homework due at the end of class today:
·
Launch Week. Instructions. Unformatted File. Your result should
look like this.
No class today
No class today
Day #14. Friday 2/14/2025. Word 2. Skills for writing a term paper
·
Today's file: sample
file
Homework due next class:
·
The Bayou. Instructions. Unformatted file. The first
three pages of your document should look like this.
No class today
·
Roger Williams Concert. Instructions.
Create from scratch. Your result should look similar to this.
Homework due next class:
·
Web Hosting. Instructions.
Unformatted file.
Your result should look like this.
·
Sample file: Alice in
Wonderland
·
Cliff News. Instructions.
Unformatted file.
Your result should look like this.
· Practice test: date: Monday, March 10th, 2025
· Word test: date: Wednesday, March 12th, 2025
·
Today's sample files: Styles: User's Guide, Table of contents,
index: The
Wonderful Wizard of Oz
·
Instructions. Use
this file. Your result should
look like this.
Homework due next class:
·
Instructions. Use
this file. Your result should
look like this.
· Word: Instructions. File. Your result should look like this. No submission is required.
No class today
· An open book Word Test: topics 1-6. Class attendance is mandatory on the test day.
· Online HTML editor: CodePen.
· Downloadable HTML editors: Visual Studio Code, Notepad++ (and many others).
· Online HTML validator: W3 HTML validator.
· Shortcuts: HTML shell:!<tab> Free filler: lo<tab>. HTML comment shortcut: <ctrl>+/
Read about the following tags/elements.
1.HTML text fundamentals: Basic, Elements, Attributes, headings, paragraphs, links
2.More text formatting (i, em, b, strong, small, mark, del, ins, sub, sup), computer code (kbd, samp, code, var, pre),entities, quotations, comments
3.HTML Lists: Unordered lists, Ordered lists, Description lists
· HW-HTML 01 (Basic HTML): Today's problem description, data file, CSS file, solution.
· HTML Tables
· The HTML test will be on Friday, March 28.
· HW-HTML 02 (Tables): Create a Table. Your result should look like this
· HTML Review (this class is optional).
· HTML Test. Class attendance is mandatory on the test day.
· 3D Workbooks: Instructions. Use this Excel File. Your summary page should look like this when done.
· Pivot tables. Orders. Instructions are in the Data File.
· Test 2: Excel topics 7-11, Test 2 date: Friday, April 11th, 2025
· Gradebook: Instructions. Data file. Your result should look like this.
Day #32. Monday 4/7/2025. XL 10: Dates and Times
Homework due next class:
·
Dates and Times: Employee instructions.
Employee spreadsheet.
· Practice test solution part 1, part 2 (videos)
· Advanced Filters, "D" functions: Real Estate (instructions are included in the spreadsheet).
· Test 2: Excel topics 7-11. Class attendance is mandatory.
· HW-PPT01 - Volcano Tour. Instructions. Begin with this template. Use this pic. Result should look like this.
· Final test: PowerPoint topics 1 - 3, Test date: April 28th, Monday.
·
HW - PPT02 - Vikings: Instructions.
Use this file. Your result should look
like this.
No class today
· PowerPoint Practice Test: Heelan Construction. Instructions. Use this file. Result should look like this, video solution
· HW-PPT03 - Vikings Football. Instructions. Use this file. Here is the video. Result should look like this.
· Final test: PowerPoint topics 1 - 3
