jackmyers.info

Scheduled Topics for Section 08

Monday Wednesday End of week HW Due
Saturday
1/19/2015   Overview, Syllabus, PowerPoint 1/21/2015 About Me
1/26/2015 snowflakesnow day Excel 1  Introduction to Excel   (incl. formats, autofill, cell refs, equations)
  Key pages: 3-7, 12-15
1/28/2015  
2/2/2015 Excel 1  Introduction to Excel
  (incl. copy/paste insert/delete, ranges, datatypes)
  Key pages:  25-27, 34-37, 42-45


Excel 2  Formulas/Functions
  (incl. absolute/relative, basic functions)
  Key pages:  76-78, 84-91
Excel 2:  Formulas/Functions
  Formulas/Functions
  (incl. summaries/conditonals,: if, sumifs, count)
  Key pages:  99-101
2/4/2015 E1 Ice Cream
2/9/2015 Excel 2:  Formulas/Functions:
  (incl. summaries/conditionals, VLOOKUP)
  Key pages:  99-101, 102-104

 
Excel 2:  Formulas/Functions: VLOOKUP

Excel 3:  Charts/Pivots
  Key pages:  135-156, 153-159
2/11/2015 E2 Steggell
2/16/2015

Excel 3:  Charts/Pivots
  Pivots not in text

Excel 4:  Datasets and Tables
  (incl. sort, filter, validation)
  Key pages:  204-209, Validation not in text
2/18/2015 E3 Spices
2/23/2015 Excel 4:  Datasets and Tables
   (incl. validation, cond. formatting)
  Key pages: 222-224
Excel Test 2/24/2015 E4 Pine Circle
3/2/2015 Advanced Word
  (incl. headers/footers, styles, columns, graphics, references, tables)
Presentations 3/4/2015  
3/9/2015 Lesson 1:  Introduction to Computers
  1-1, 1-2
Lesson 1:  Introduction to Computers
   Key objectives: 1-3, Snipping Tool, 1-6, 1-7
3/11/2015  
3/16/2015 Spring Break 3/18/2015  
3/23/2015 Lesson 1:  Intro to Computers:
   Key objectives: 2-5, 3-2, 3-3, 3-4, 3-6
Lesson 2:  Hardware and Software: CPU / Pipelining
   Key objecives: 4-1, 4-2
3/25/2015  
3/30/2015 Lesson 2:  Hardware and Software: OS +
   Key objectives: 4-2, 5.1, 5-4, 5-5, 5-6
Lesson 2:  Hardware and Software
   Key objectives: photo edit, graphics, YouTube
4/1/2015 Moore's Law
4/6/2015 Lesson 3:  The Internet and Networks
   Key objectives: 7-1, 7-3, 7-4
Lesson 3: The Internet and Networks
   Key objectives 9-1, 9-3, 9-4
4/8/2015 Graphics
4/13/2015 Lesson 3:  The Internet and Networks
   Key objectives:  HTML
Lesson 4:  Databases
   Key objectives: tables, datatypes, design, primary keys
4/15/2015 HTML
4/20/2015 Access 1: Introduction to Access
   Key objectives:  relationships, foreign keys
Access 1:  Introduction to Access
   Key objectives: referential integrity, relationships
4/22/2015  
4/27/2015 Access 2:  Relational Databases and Queries
   Key objectives:  detail and summary queries
Access 4/29/2015  
5/4/2015 Access Access 5/7/2015 Access Project
5/11/2014 Access Test