# CIS105: Computer Appls&Info Technology (2024 Spring) | Toshiki's Note
Toshiki's web notebook served via Vitepress!
Author: Anda Toshiki
Keywords: Toshiki, Anda Toshiki, andatoshiki, GitHub, GitHub action, Vitepress, Vite, Notebook, Knowledge base, Programming, Programming Notes, Academic, Personal, Notebook, Productivity, Journal, Note-taking, Markdown, Notepad, Organization, Tutorial

Skip to content

####

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

Author:Anda Toshiki
Updated:a minute ago
Words:4.2k
Reading:26 min

## Courseload Overview ​

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

| Exam 2

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

| Final Exam