Lab Practice
These labs are to be completed in class, but may require outside work to finish on time. Their purpose is to get you familiar with the current course material. These labs are due by the date and time specified and will be turned in using Blackboard.
LP #11: Maintaining a Database
Due: within 30 minutes into class on Mon, Nov 5 (for Sections 7 & 9);within 30 minutes into class on Tues, Nov 6 (for Section 13)
Purpose: To explore an Access and learn how to maintian a database.
Working through Chapter 3 on Access up to AC 195. Do not print any of the work and submit your final worksheet to blackboard.
LP #10: Querying a database
Due: by the start of class on Mon, Oct 29 (for Sections 7 & 9);by the start of class on Tues, Oct 30 (for Section 13)
Purpose: To explore how to query and access database.
Perform the tasks in Figure 2-1 on AC 75 by working through Chapter 2 on Access up to AC 127. Do not print any of the work and submit your final database to blackboard.
LP #9: Creating and Using a Database
Due: by the start of class on Mon, Oct 22 (for Sections 7 & 9);by the start of class on Tues, Oct 23 (for Section 13)
Purpose: To explore and create an Access Database.
Create Figure 1-1 on AC 3 by working through Chapter 1 on Access up to AC 63. Do NOT print any of the work (AC 83) and submit your final database to blackboard.
LP #8: What-if Analysis, Charting and Working with Large Worksheets
Due: 15 minutes before class on Mon, Oct 15 (for Sections 7 & 9);15 minutes before class on Tues, Oct 16 (for Section 13)
Purpose: To explore an Excel worksheet What-if Analysis, Charting and Working with Large Worksheets.
Create Figure 3-1 on Ex 163 by working through Chapter 1 on Excel up to Ex 227. Do not print any of the work and submit your final worksheet to blackboard.
LP #7: Formulas, Functions, Formatting and Web Queries
Due: 15 minutes before class on Mon, Oct 8 (for Sections 7 & 9);15 minutes before class on Tues, Oct 9 (for Section 13)
Purpose: To explore Excel worksheet Formulas, Functions, Formatting and Web Queries
Create Figure 2-1 on Ex 83 by working through Chapter 2 on Excel up to Ex 141. Do not print any of the work and submit your final worksheet to blackboard.
LP #6: Creating a Worksheet and an Embedded Chart
Due: 15 minutes before class on Mon, Oct 1 (for Sections 7 & 9);15 minutes before class on Tues, Oct 2 (for Section 13)
Purpose: To create an Excel worksheet with an embedded chart.
Create Figure 1-1 on Ex 3 by working through Chapter 1 on Excel up to Ex 65. Do not print any of the work and submit your final worksheet to blackboard.
Note: you should be submitting 3 worksheets, one for each part. When the book says "print" you should save.