CIS 105 Assignment Schedule

CIS 105 - Computer Applications Information Technology Term: Fall 2021 B | SLN 94612/98293/94615/94613/96795 | Class: iCourse ASUOnline Page 1 of 6 Title Suggested Due Date Goal Due Date First Day Quiz -- Getting Started / Syllabus 10/12/2022 10/12/2022 Week 1 0.4 Getting Started Exce/SQL Test Your Skills Assessment 10/23/2022 10/16/2022 1.3 Cells and Worksheets Practice Problem 10/16/2022 1.5 Formatting Cell and Sheets Practice Problem 10/16/2022 1.7 Sorting and Filtering Practice Problem 10/16/2022 1.8 Excel Basics Test Your Skills Assessment 10/16/2022 2.2 References and Calculations Practice Problem 10/16/2022 2.4 Summary Statistics Practice Problem 10/16/2022 2.6 Financial Functions Practice Problem 10/16/2022 2.7 Formulas and Functions Test Your Skills Assessment 10/16/2022 ABCC - Quiz | Chapter 1 10/16/2022 ABCC - Quiz | Chapter 2 10/16/2022 ABCC - Quiz | Chapter 3 10/16/2022 Week 2 3.2 Boolean Functions Practice Problem 10/30/2022 10/28/2022 3.4 Functions Practice Problem 10/28/2022 3.6 Conditional Functions Practice Problem 10/28/2022 3.8 Refernce Functions Practice Problem 10/28/2022 3.9 Logic and Reference Functions Test Your Skills Assessment 10/28/2022 4.2 Date and Time Functions Practice Problem 10/28/2022 4.4 Text Functions Practice Problem 10/28/2022 4.5 Date, Time and Text Functions Test Your Skills Assessment 10/28/2022 ABCC - Quiz | Chapter 4 10/28/2022 ABCC - Quiz | Chapter 5 10/28/2022 ABCC - Quiz | Chapter 6 10/28/2022 Week 3 5.3 Column Charts Practice Problem 11/6/2022 11/5/2022 5.5 Stacked Column Charts Practice Problem 11/5/2022 5.7 Pie Charts Practice Problem 11/5/2022 5.9 Line Charts Practice Problem 11/5/2022 5.10 Charting Test Your Skills Assessment 11/5/2022 6.4 Tables Practice Problem 11/5/2022 6.5 Tables Test Your Skills Assessment 11/5/2022 ABCC - Quiz | Chapter 7 11/5/2022 ABCC - Quiz | Chapter 8 11/5/2022

CIS 105 - Computer Applications Information Technology Term: Fall 2021 B | SLN 94612/98293/94615/94613/96795 | Class: iCourse ASUOnline Page 2 of 6 ABCC - Quiz | Chapter 9 11/5/2022 Week 4 7.3 Basic Conditional Formatting Practice Problem 11/13/2022 11/11/2022 7.5 Conditional Formatting Based on Exceptional Value Practice Problem 11/11/2022 7.7 More Advanced Conditional Formatting Practice Problem 11/11/2022 7.8 Conditional Formating Test Your Skills Assessment 11/11/2022 8.2 Building Spreadsheet Models Practice Problem 11/11/2022 8.4 Multiple Worksheets Practice Problem 11/11/2022 8.6 Data Validation Practice Problem 11/11/2022 8.7 Modeling Test Your Skills Assessment 11/11/2022 ABCC - Quiz | Chapter 10 11/11/2022 ABCC - Quiz | Chapter 11 11/11/2022 ABCC - Quiz | Chapter 12 11/11/2022 Week 5 9.2 Statistics Practice Problem 11/20/2022 11/18/2022 9.3 Statistics Test Your Skills Assessment 11/18/2022 10.3 PivotTables Practice Problem 11/18/2022 10.5 Performing Calculations with PivotTables Practice Problem 11/18/2022 10.7 Filtering Data in PivotTables Practice Problem 11/18/2022 10.8 PivotTables Test Your Skills Assessment 11/18/2022 ABCC - Quiz | Chapter 13 11/18/2022 ABCC - Quiz | Chapter 14 11/18/2022 Week 6 11.4 Designing Database Tables Practice Problem 11/27/2022 11/26/2022 11.6 Working With Airtable Practice Problem 11/26/2022 11.7 Design and Build a Database Test Your Skills Assessment 11/26/2022 12.4 Select Clause Practice Problem 11/26/2022 12.5 Distinct Keyword Practice Problem 11/26/2022 12.7 Order By Clause Practice Problem 11/26/2022 12.9 Limit Clause Practice Problem 11/26/2022 12.10 Introduction to SQL Test Your Skills Assessment 11/26/2022 ABCC - Quiz | Chapter 15 11/26/2022 ABCC - Quiz | Chapter 16 11/26/2022 13.3 Simple Where Clause Practice Problem 12/1/2022 13.5 Where Clause with Null Practice Problem 12/1/2022 13.8 Compound Where Clause Practice Problem 12/1/2022 13.10 Where Clause with Wildcards Practice Problem 12/1/2022

CIS 105 - Computer Applications Information Technology Term: Fall 2021 B | SLN 94612/98293/94615/94613/96795 | Class: iCourse ASUOnline Page 4 of 6 Attempts Scoring Weight Completed Unlimited / Highest 35% 2 / Average 50% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% 2 / Average 50% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% 2 / Average 50% 2 / Highest 35% 2 / Highest 35% 2 / Highest 35% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% 2 / Average 50% Unlimited / Highest 15% Unlimited / Highest 15% 2 / Average 50% 2 / Highest 35% 2 / Highest 35% 2 / Highest 35% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% 2 / Average 50% Unlimited / Highest 15% 2 / Average 50% 2 / Highest 35% 2 / Highest 35%

CIS 105 - Computer Applications Information Technology Term: Fall 2021 B | SLN 94612/98293/94615/94613/96795 | Class: iCourse ASUOnline Page 5 of 6 2 / Highest 35% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% 2 / Average 50% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% 2 / Average 50% 2 / Highest 35% 2 / Highest 35% 2 / Highest 35% Unlimited / Highest 15% 2 / Average 50% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% 2 / Average 50% 2 / Highest 35% 2 / Highest 35% Unlimited / Highest 15% Unlimited / Highest 15% 2 / Average 50% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% 2 / Average 50% 2 / Highest 35% 2 / Highest 35% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15% Unlimited / Highest 15%