ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Kirkwood Community College
3
Hybrid Course - Instructional/Homework Time Tracking Template
4
5
Course:
6
7
The following table documents the activities for the course (listed above) and the corresponding instructional or homework minutes associated with completing those activities.
8
9
Note that "face-to-face" refers to instructional activities that occur live with students in the physical classroom. Note that "online" refers to instructional activities that are delivered via the learning management system. Note that "homework" refers to activities that students complete in preparation for (or in response to) instruction.
10
11
DIRECTIONS: In the first column, enter the title (and/or brief description) of the activity. Then, select whether the activity is completed face-to-face, is completed online, or is homework. Finally, enter the number of minutes that the activity will take a typical student to complete. If the activity is completed face-to-face or online, enter the number of minutes in the "Instructional Minutes" column. If the activity is homework, enter the number of minutes in the "Homework Minutes" column.
12
13
Course ActivityFace-to-Face, Online, or HomeworkInstructional MinutesHomework Minutes
14
Getting Started with CourseFace-to-Face (F2F)65
15
Read: Getting to Know Office versionsHomework010
16
Watch: Getting Started with MindTapOnline30
17
Watch: Completing a SAM Training in MindtapOnline30
18
Watch: Completing a SAM Project in MindtapOnline3015
19
Watch: Completing a SAM Exam in MindtapOnline30
20
Check Your Understand SAM Getting Started ProjectHomework015
21
Course ExpectationsFace-to-Face (F2F)60
22
IntroductionsFace-to-Face (F2F)650
23
Watch: Introduction to Word Interactive VideoOnline70
24
Read: Word 02 Creating a Research PaperHomework070
25
Task Sheet: Word 02 Creating a Research PaperHomework020
26
Training: Word 02 Creating a Research PaperHomework060
27
Project: Word 02 Creating a Research PaperFace-to-Face (F2F)900
28
Read: Word 06 Using Mail MergeHomework070
29
Task Sheet: Word 06 Using Mail MergeHomework020
30
Training: Word 06 Using Mail MergeHomework060
31
Project: Word 06 Using Mail MergeFace-to-Face (F2F)900
32
Watch: Intro to Access Video SeriesOnline70
33
Read: Access 01 Databases and Database ObjectsHomework075
34
Task Sheet: Access 01 Databases and Database ObjectsHomework020
35
Training: Access 01 Databases and Database ObjectsHomework060
36
Project: Access 01 Databases and Database ObjectsFace-to-Face (F2F)900
37
Read: Access 02 Querying a DatabaseHomework070
38
Task Sheet: Access 02 Querying a DatabaseHomework020
39
Training: Access 02 Querying a DatabaseHomework060
40
Project: Access 02 Querying a DatabaseFace-to-Face (F2F)900
41
Read: Access 03 Maintaining a DatabaseHomework070
42
Task Sheet: Access 03 Maintaining a DatabaseHomework020
43
Training: Access 03 Maintaining a DatabaseHomework060
44
Project: Access 03 Maintaining a DatabaseFace-to-Face (F2F)900
45
Read: Access 04 Creating Reports and FormsHomework070
46
Task Sheet: Access 04 Creating Reports and FormsHomework020
47
Training: Access 04 Creating Reports and FormsHomework060
48
Project: Access 04 Creating Reports and FormsFace-to-Face (F2F)900
49
Read: Access 05 Multiple-Table FormsHomework070
50
Task Sheet: Access 05 Multiple-Table FormsHomework020
51
Training: Access 05 Multiple-Table FormsHomework060
52
Project: Access 05 Multiple-Table FormsFace-to-Face (F2F)900
53
Read:Access 09 Administering a Database SystemHomework070
54
Task Sheet: Access 09 Administering a Database SystemHomework020
55
Training: Access 09 Administering a Database SystemHomework060
56
Project: Access 09 Administering a Database SystemFace-to-Face (F2F)900
57
Read: Access 10 Using SQLHomework070
58
Task Sheet: Access 10 Using SQLHomework020
59
Training: Access 10 Using SQLHomework060
60
Project: Access 10 Using SQLFace-to-Face (F2F)900
61
Watch: Intro to Excel Interactive VideoOnline700
62
Read: Excel 01 Creating a Worksheet and ChartHomework070
63
Task Sheet: Excel 01 Creating a Worksheet and ChartHomework020
64
Training: Excel 01 Creating a Worksheet and ChartHomework060
65
Project: Excel 01 Creating a Worksheet and ChartFace-to-Face (F2F)900
66
Read: Excel 02 Formulas Functions and FormattingHomework075
67
Task Sheet: Excel 02 Formulas Functions and FormattingHomework020
68
Training: Excel 02 Formulas Functions and FormattingHomework060
69
Project: Excel 02 Formulas Functions and FormattingFace-to-Face (F2F)900
70
Read: Excel 03 Working with Large WorksheetsHomework070
71
Task Sheet: Excel 03 Working with Large WorksheetsHomework020
72
Training: Excel 03 Working with Large WorksheetsHomework060
73
Project: Excel 03 Working with Large WorksheetsFace-to-Face (F2F)900
74
Read: Excel 04 Financial Functions, Data Tables and AmortizationHomework070
75
Task Sheet: Excel 04 Financial Functions, Data Tables and AmortizationHomework020
76
Training: Excel 04 Financial Functions, Data Tables and AmortizationHomework060
77
Project: Excel 04 Financial Functions, Data Tables and AmortizationFace-to-Face (F2F)900
78
Read: Excel 05 Working with Multiple Worksheets and WorkbooksHomework070
79
Task Sheet: Excel 05 Working with Multiple Worksheets and WorkbooksHomework020
80
Training: Excel 05 Working with Multiple Worksheets and WorkbooksHomework060
81
Project: Excel 05 Working with Multiple Worksheets and WorkbooksFace-to-Face (F2F)900
82
Read: Excel 06 Creating, Sorting, and Querying a TableHomework070
83
Task Sheet: Excel 06 Creating, Sorting, and Querying a TableHomework020
84
Training: Excel 06 Creating, Sorting, and Querying a TableHomework060
85
Project: Excel 06 Creating, Sorting, and Querying a TableFace-to-Face (F2F)900
86
Read: Excel 08 Working with Trendlines, Pivot Table Reports, Pivit Charts Homework070
87
Task Sheet: Excel 08 Working with Trendlines, Pivot Table Reports, Pivit Charts Homework020
88
Training: Excel 08 Working with Trendlines, Pivot Table Reports, Pivit Charts Homework060
89
Project: Excel 08 Working with Trendlines, Pivot Table Reports, Pivit Charts Face-to-Face (F2F)900
90
Watch: Intro to PowerPoint interactive videoOnline700
91
Read: PowerPoint 01 Creating and Editing Presentations with PicturesHomework070
92
Task Sheet: PowerPoint 01 Creating and Editing Presentations with PicturesHomework020
93
Training: PowerPoint 01 Creating and Editing Presentations with PicturesHomework060
94
Project: PowerPoint 01 Creating and Editing Presentations with PicturesFace-to-Face (F2F)900
95
Read: PowerPoint 03 Insertig WordArt, Charts and TablesHomework070
96
Task Sheet: PowerPoint 03 Insertig WordArt, Charts and TablesHomework020
97
Training: PowerPoint 03 Insertig WordArt, Charts and TablesHomework060
98
Project: PowerPoint 03 Insertig WordArt, Charts and TablesFace-to-Face (F2F)900
99
Read: MIS 01 Information Systems in BusinessHomework070
100
PowerPoint: MIS 01 Information Systems in BusinessOnline900