Student Resources for Information Systems for Business, Edition 3.0

by France Bélanger, Craig Van Slyke, and Robert E. Crossler

Spreadsheets for Chapter 6 Additional Learning Activities

• ALA 6.4: Car-Buying-Spreadsheet-ALE-6.4.xlsx
• ALA 6.5: Monthly-Commission-Spreadsheet-ALE-6.5-1.xls

eText of Appendices A-K

The appendices are included in the eTextbook and made available here for users of the paperback:

• Appendices A-K in EPUB format (.epub): Belanger-3e-Appendices-A-K-EPUB.epub
• Appendices A-K in PDF format (.pdf): Belanger-3e-Appendices-A-K-PDF.pdf

To view EPUB files, you may use one of the following:

• Adobe Digital Editions: http://www.adobe.com/solutions/ebook/digital-editions/download.html
• Apple iBooks app for iPad, iPhone, and Mac: https://itunes.apple.com/us/app/ibooks/id364709193
• Microsoft Edge browser: https://www.microsoft.com/en-us/windows/microsoft-edge
• Readium extension for the Google Chrome browser: readium.org

Video Tutorials for Appendix F

Links will open in Vimeo.

Excel Fundamentals Videos

• XL01 Interface (10:11)
• XL02 Navigation (3:32)
• XL03 Rows Columns Ranges (7:09)
• XL04 Text Numeric Data Dates (9:06)
• XL05 Basic Data And Formula (8:41)
• XL06 Cut Copy Paste (6:53)

Editing and Formatting Worksheets Videos

• XL07 Formatting Cells (8:58)
• XL08 Insert Delete Cells Rows Columns (4:41)

Functions and Formulas Videos

• XL09 Formulas Functions Overview (8:08)
• XL10 Cell References Absolute Relative (6:26)
• XL11 Insert Function Wizard (5:57)
• XL12 Functions Examples (5:43)

Charts Videos

• XL13 Chart Basics (5:51)
• XL14 Chart Data and Formatting (6:04)

Printing Video

• XL 15 Printing (5:40)

Spreadsheets for Appendix F Additional Learning Activities

• ALA 1: ExcelFundamentals_Activity_Coffee.xlsx
• ALA 2: ExcelFundamentals_Activity_Coffee_MultiYear.xlsx
• ALA 3: ExcelFundamentals_Activity_ProductQuantitySold_Trend.xlsx
• ALA 4: ExcelFundamentals_Activity_ProductSalesEstimates.xlsx
• ALA 5: ExcelFundamentals_Activity_EmployeeOverhead.xlsx

Spreadsheets for Appendix G

• Figure G.1: PivotTable_Example_InChapter.xlsx
• Figure G.12: Fun Parks.xlsx

Spreadsheets for Appendix G Learning Activities

• LAs 1-6: Bike_Sales.xlsx
• LA 7: Fun4Pups.xlsx
• LA 8: MailCampaign.xlsx