CIS105: Computer Appls&Info Technology (2024 Spring) ​

REQUIRED

TEXTBOOKS:

• Applied Business Computing Concepts Textbook
• Excel/SQL Textbook

Week 1

• Lecture - Tue, Jan 9th 
• How to Access Textbook Instructions

• Lab - Thu, Jan 11th
• Excel Add-in DirectionsLinks to an external site.
• Click here for MyEducator add-in installer for WindowsLinks to an external site.
• Click here for MyEducator add-in installer for Mac iOSLinks to an external site.
• Due Date(s): Sunday, Jan 14th, 2024 by midnight

Week 2

• Lecture - Tue, Jan 16th 
• Knowledge Check 1 | Information Systems
• Due Date(s): Sunday, January 21st, 2024 by midnight

• Lab - Thu, Jan 18th
• 0.4 Getting Started Excel/SQL Educator
• Due Date(s): Sunday, January 21st, 2024 by midnight

Week 3

• Lecture -  Tue, Jan 23rd 
• Knowledge Check 2 | Application Software
  
• Due Date(s): Sunday, January 28th, 2024 by midnight

• Lab - Thu, Jan 25th 
• 1.3 Cells and Worksheets Practice
• 1.5 Formatting Cells and Sheets Practice
• 1.7 Sorting and Filtering Practice
• 1.8 Excel Basics Assessment
• Due Date(s): Sunday, January 28th, 2024 by midnight

Week 4

• Lecture - Tue, Jan 30th 
• Knowledge Check 3 | Inside the Computer
  
• Due Date(s): Sunday, February 4th, 2024 by midnight

• Lab - Thu, Feb 1st
• 2.2 References and Calculations Practice
• 2.4 Summary Statistics Practice
• 2.6 Financial Functions Practice
• 2.8 Formula Auditing Practice
• 2.9 Formulas and Functions Assessment
• Due Date(s): Sunday, February 4th, 2024 by midnight

Week 5

• Lecture - Tue, Feb 6th
• Knowledge Check 4 | Operating Systems
  
• Due Date(s): Sunday, February 11th, 2024 by midnight

• Lab - Thu, Feb 8th
• 3.2 Boolean Functions Practice
• 3.4 If Functions Practice
• 3.6 Conditional Functions Practice
• 3.8 Reference Functions Practice
• 3.9 Logic and Reference Functions Assessment (Alternative Lookups)
• Due Date(s): Sunday, February 11th, 2024 by midnight

Week 6

• Lecture - Tue, Feb 13th
• Knowledge Check 5 | Business Storage
  
• Due Date(s): Sunday, February 18th, 2024 by midnight
• ZOOM Exam One Review: TBA

• Lab - Thu, Feb 15th
• 4.2 Date and Time Functions Practice
• 4.4 Text Functions Practice
• 4.5 Date, Time, and Text Functions Assessment
• Due Date(s): Sunday, February 18th, 2024 by midnight

Exam 1: February 22nd - 23rd

Week 7

• Lecture - Tue, Feb 20th
• Knowledge Check 6 | System Software
  
• Due Date(s): Sunday, February 25th, 2024 by midnight

• Lab - Thu, Feb 22nd
• 5.3 Column Charts Practice
• 5.5 Stacked Column Charts Practice
• 5.7 Pie Charts Practice
• 5.9 Line Charts Practice
• 5.10 Charting Assessment
• Due Date(s): Sunday, February 25th, 2024 by midnight

Week 8

• Lecture - Tue, February 27th
• Knowledge Check 7 | Green Business Computing
• Knowledge Check 8 | Computer Networks
• Due Date(s): Sunday, March 3rd, 2024 by midnight

• Lab - Thu, Feb 29th
• 6.2 Building Spreadsheet Models Practice
• 6.4 What-if Analysis Practice
• 6.5 Basic Modeling Assessment
• Due Date(s): Sunday, March 3rd, 2024 by midnight

Mar 4th - 10th

SPRING BREAK

Week 9

• Lecture - Tue, Mar 12th
• Knowledge Check 9 | Internet
• Due Date(s): Sunday, March 17th, 2024 by midnight

• Lab - Thu, Mar 14th
• 9.2 PivotTable Practice
• 9.3 PivotTable Assessment
• Due Date(s): Sunday, March 17th, 2024 by midnight

Week 10

• Lecture - Tue, Mar 19th
• Knowledge Check 10 | Business Websites
• Due Date(s): Sunday, March 24th, 2024 by midnight

• Lab - Thu, Mar 21st
  
• 11.4 Practice Designing Database Tables
• 11.6 Practice Working with Airtable
• 11.7 Design and Build a Database Assessment
• Due Date(s): Sunday, March 24th, 2024 by midnight

Week 11

• Lecture -  Tue, Mar 26th
  
• Knowledge Check 11 | Computer Security
• Due Date(s): Sunday, March 31st, 2024 by midnight
• ZOOM Midterm Review(s) TBA

• Lab - Thu, Mar 28th
• 12.4 Select Clause Practice
• 12.5 Distinct Keyword Practice
• 12.7 Order By Clause Practice
• 12.9 Limit Clause Practice
• 12.10 Introduction to SQL Assessment - Simpsons
• Due Date(s): Sunday, April 7th, 2024 by midnight

Week 12

• Lecture - Tue, Apr 2nd
• Knowledge Check 12 | Information Systems in Business
  
• Due Date(s): Sunday, April 7th, 2024 by midnight

• Lab - Thu, Apr 4
• 13.3 Simple Where Clause Practice
• 13.5 Where Clause with Null Practice
• 13.8 Compound Where Clause Practice
• 13.10 Where Clause with Wildcards Practice
• 13.11 Queries with Restrictions Assessment
• Due Date(s): Sunday, April 14th, 2024 by midnight

Week 13

• Lecture - Tue, Apr 9th
• Knowledge Check 13 | Business System Reporting
• Knowledge Check 14 | Information Technology Careers
  
• Due Date(s): Sunday, April 21st, 2024 by midnight

• Lab - Thu, Apr 11th
• 14.2 Joining Two Tables Practice
• 14.4 Joining Three or More Tables Practice
• 14.6 Queries with Join and Where Practice
• 14.7 Join Queries Assessment
• Due Date(s): Sunday, April 21st, 2024 by midnight

• Lecture - Tue, Apr 16th
• Knowledge Check 15 | Database
  
• Due Date(s): Sunday, April 28th, 2024 by midnight

• Lecture - Thur, Apr 18th
• Final Exam Review