Introduction to Computer Applications

IntroductionExploring Microsoft Office 2013, Volumes1  to  Computer  Applications

Introduction  to  spreadsheets and  databases  for  problem solving  in disciplines  such  as math, science, engineering,  business,  social sciences,  behavioral  sciences,  and  environment; using  computer applications  to  create  technical  reports  and  presentations.

Textbook: Exploring Microsoft Office 2013, Volumes 1 and 2 Published by Pearson; Volume 1 ISBN 978-0-13-314267-9 Volume 2 ISBN 978-0-13-341212-3

Textbook: MyITLab for Exploring Office 2013 Published by Pearson

 

Day 1 – Course Introduction

– Presentation

Day 2 – Scientific Method & Office Introduction

– Presentation

Day 3 – Excel Chapter 1

– Rows, Columns, Cells & Formulas

Day 4 – Excel Chapter 1 & 2

– Excel Tables, Formulas & Functions

– Project 1

Day 5 – Excel Chapter 1, 2 & 4

– Formatting and Functions

– Project 2

Day 6 – Excel Chapter 2

– Advanced Functions

– Project 3

Day 7 – Excel Chapter 3

– Charts (demo)

– Project 4

Day 8 – Excel Chapter 3, 4 & 5

– Sparklines & Subtotals

– PivotTables & PivotCharts

Day 9 – Excel Chapter 5 & 9

– 3D formulas, Pivot Charts & Tables

– Project 5

Day 10 – Excel Chapter 7 & 8

– Logical Functions, Conditional Math functions

– Demo

Day 11 – Excel Chapter 6

– What-If Analysis

2/19/2015: Day 12 – Excel Review

– Basketball Hall of Fame Problem

Day 13 – Exam 1

Day 14 – Access Chapter 1

– Databases Introduction

– Sample Database

 Day 15 – Access Chapter 1 & 2

– Planning a database

– Project 6 (Student Enrollment Database)

  • Tables

Day 16 – Access Chapter 2

– Importing Tables, Relationships

– Project 7a

 Day 17 – Access Chapter 2

– Queries

– Project 7b

Day 18 – Access Chapter 3 & 4

– Calculated Fields

– Project 7c

Day 19 – Access Chapter 4

– Forms & Reports

– Project 8

 Day 21 – Access Chapter 5,6 & 7

– Advanced Queries

– Project 9

Day 22 – Access Review

– Project 10

Day 24 – Word Chapter 1, 2, 3 & 4

– Styles, Insert Equations and other illustrations

– Project 11a

Day 25 – Word Chapter 5, 6 ,7 & 8

– Project 11b

Day 26 – Powerpoint

– Project 12

4/28/2015: Day 27 – Final Exam Review

– Project

 

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *