Computer Applications

Quick Links:
How to Download MS Office at Home
Click on the links below to jump to the unit we are on!
Word Excel Access PowerPoint Other Projects Resources
Ch. 1 Ch. 1 Ch. 1 Ch. 1 Search Engines GMetrix Guide
Ch. 2  Ch. 2 Ch. 2 Ch. 2 Digital Citizenship Setting Up Printers
Ch. 3 Ch. 3 Ch. 3 Mapping Network Drives

Wednesday
Aug. 30

Who am I?  Teacher Sway

What's Happening?

Introduction:

Read over the Syllabus

  • The signoff page must be returned by Friday; however, if you return it tomorrow with both sets of signatures you will receive extra credit.

  • If I do not receive your signoff sheet, you will receive zeros on assignments until I receive your sheet!

Discuss the structure of the course (GMetrix, Certifications in Adv. Apps, Homework, Testing, etc.)

Skyward passwords and assignments--Guidance Office or Ask me :)

Permanent seating arrangements TOMORROW!--Keep in mind I lecture from the back of the room

Thursday
Aug. 31

Getting to know each other activity

Permanent seating arrangement

File Management & Getting Started:

Log into your computers

Mapping Network Drives--we will do this together the first time

Setting Up Printers--Install sh108 K3920 printer--Update to default printer--duplex printing enabled

Friday
Sept. 1

Cover Student Handbook

File Management & Getting Started:

Create a folder within rm108users (Last Name First Name)

Create a shortcut to your rm108users drive on the desktop

Create folders within your rm108user folder

Create a class website link on your Desktop

Add the class website as a Favorite

Pin Word, Excel, Access, PowerPoint, & GMetrix to the Start Menu

Setup GMetrix Account--either online or the desktop application at school--Need by TUESDAY

Syllabus Due

If I do NOT receive a signed syllabus today, you will not be able to complete the following assignments

   

Monday
Sept. 4

No School for Everyone

Tuesday
Sept. 5

 PreTest

  • Administered through a computer program called GMetrix

  • Must be made-up if absent or newly transferred.

  • A student account will be created in class.

Wednesday
Sept. 6

 PreTest

Thursday
Sept. 7

Operating Systems

OS X vs. Windows

What is an Operating System?

 

Standards:

FT5.1-Demonstrate knowledge of features in the operating system

FT5.2-Analyze operating system capabilities and restrictions

Learning Target:

Students will understand differences between operating systems.

Students will create a presentation showcasing the capabilities, restrictions and features of the different operating systems.

 

Assignment:

Operating Systems Project

Friday
Sept. 8

Operating Systems

OS X vs. Windows

Standards:

FT5.1-Demonstrate knowledge of features in the operating system

FT5.2-Analyze operating system capabilities and restrictions

Learning Target:

Students will understand differences between operating systems.

Students will create a presentation showcasing the capabilities, restrictions and features of the different operating systems.

 

Assignment:

Operating Systems Project

Monday
Sept. 11

Operating Systems

OS X vs. Windows

Standards:

FT5.1-Demonstrate knowledge of features in the operating system

FT5.2-Analyze operating system capabilities and restrictions

Learning Target:

Students will understand differences between operating systems.

Students will create a presentation showcasing the capabilities, restrictions and features of the different operating systems.

 

Assignment:

Operating Systems Project

Tuesday
Sept.
12

 Word Chapter 1 Training using GMetrix

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to identify and demonstrate how to format various elements of text.

Wednesday
Sept. 13

Word Chapter 1 Training using GMetrix--DUE

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to identify and demonstrate how to format various elements of text.

 

Word Chapter 1 Application Project

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to identify and demonstrate how to format various elements of text.

Assignment:

In The Lab #1

Save As: LastName Commodity Trading Flyer

Save Location: rm108users Word Chapter 1 folder

Picture Location: rm108shared | Classes | Computer Applications | Word | Chapter 1 | Harvest

 

Thursday
Sept. 14

Word Chapter 1 Application Project

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to identify and demonstrate how to format various elements of text.

Assignment:

In The Lab #1

Save As: LastName Commodity Trading Flyer

Save Location: rm108users Word Chapter 1 folder

Picture Location: rm108shared | Classes | Computer Applications | Word | Chapter 1 | Harvest

 

Word Chapter 1 Enrichment Assignment

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to create a flyer, incorporating the various formatting elements covered in the training, for a school|community club, activity, or event.

Assignment:

School|Community Flyer

Save As: LastName "Name of Event|Activity|Club" Flyer

Save Location: rm108users Word Chapter 1 folder

 

Friday
Sept. 16

Word Chapter 1 Application Project--DUE drop at the beginning of class & complete Rubric

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to identify and demonstrate how to format various elements of text.

Assignment:

In The Lab #1

Save As: LastName Commodity Trading Flyer

Save Location: rm108users Word Chapter 1 folder

Picture Location: rm108shared | Classes | Computer Applications | Word | Chapter 1 | Harvest

 

Word Chapter 1 Enrichment Assignment--DUE drop by the end of class

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to create a flyer, incorporating the various formatting elements covered in the training, for a school|community club, activity, or event.

Assignment:

School|Community Flyer

Save As: LastName "Name of Event|Activity|Club" Flyer

Save Location: rm108users Word Chapter 1 folder

 

 

Monday
Sept. 18

Word Chapter 1 Exam using GMetrix

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to identify and demonstrate how to format various elements of text.

 

Start Word Chapter 2 Training using GMetrix

 

Tuesday
Sept. 19

Word Chapter 2 Training using GMetrix

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to edit and insert citations, sources, footnotes and a header/footer.

Wednesday
Sept. 20

Word Chapter 2 Training using GMetrix--DUE with greater than 85% accuracy

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to edit and insert citations, sources, footnotes and a header/footer.

 

Word Chapter 2 Application Project

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to edit and insert MLA citations and sources, footnotes and a header/footer.

Assignment:

In The Lab #2

Save As: LastName Two-Step Verification Paper

Save Location: rm108users | Word | Chapter 2 folder

Adjustments: Step #1--Use your name, our class information and today's date.

Thursday
Sept. 2
1

Word Chapter 2 Application Project

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to edit and insert MLA citations and sources, footnotes and a header/footer.

Assignment:

In The Lab #2

Save As: LastName Two-Step Verification Paper

Save Location: rm108users | Word | Chapter 2 folder

Adjustments: Step #1--Use your name, our class information and today's date.

 

Friday
Sept. 22

Word Chapter 2 Application Project--DUE drop & complete Rubric

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to edit and insert MLA citations and sources, footnotes and a header/footer.

Assignment:

In The Lab #2

Save As: LastName Two-Step Verification Paper

Save Location: rm108users | Word | Chapter 2 folder

Adjustments: Step #1--Use your name, our class information and today's date.

 

   
Monday
Sept. 25

Word Chapter 2 Extended Thinking Project

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.5-Create and use features of word processing software

FT1.7-Use Help features

Learning Target:

Students will analyze and compare footnotes and endnotes.

Students will examine the document and rewrite to increase readability statics.

Students will be able to differentiate between APA and MLA sources and citations.

Assignment:

Extend Your Knowledge

Save As: LastName Databases Paper Modified

Save Location: rm108users | Word | Chapter 2 folder

Data file location:  rm108shared | Classes | Computer Applications | Word | Chapter 2

 

Tuesday
Sept. 26

Word Chapter 2 Extended Thinking Project--DUE drop & complete Rubric

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.5-Create and use features of word processing software

FT1.7-Use Help features

Learning Target:

Students will analyze and compare footnotes and endnotes.

Students will examine the document and rewrite to increase readability statics.

Students will be able to differentiate between APA and MLA sources and citations.

Assignment:

Extend Your Knowledge

Save As: LastName Databases Paper Modified

Save Location: rm108users | Word | Chapter 2 folder

Data file location:  rm108shared | Classes | Computer Applications | Word | Chapter 2

 

REVIEW Word Chapter 2 Training using GMetrix

 

Wednesday
Sept. 27

Word Chapter 2 Exam using GMetrix

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.3-Customize document formatting

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to edit and insert citations, sources, footnotes and header/footer.

Thursday
Sept. 28

Word Chapter 3 Training using GMetrix

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.2-Use table to enhance documents

FT1.3-Customize document formatting

FT1.4-Create a mail merge document (extra credit option)

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.

Friday
Sept. 29

Word Chapter 3 Training using GMetrix--DUE with greater than 85% accuracy

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.2-Use table to enhance documents

FT1.3-Customize document formatting

FT1.4-Create a mail merge document (extra credit option)

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.

 

Word Chapter 3 Application Project

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.2-Use table to enhance documents

FT1.3-Customize document formatting

FT1.4-Create a mail merge document (extra credit option)

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.

Assignment:

In The Lab #2

Save As: LastName Rosewood Letter

Save Location: rm108users Word Chapter 3 folder

Picture Location: rm108shared | Classes | Computer Applications | Word | Chapter 3 | Rose

   
Monday
Oct. 2

Word Chapter 3 Application Project

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.2-Use table to enhance documents

FT1.3-Customize document formatting

FT1.4-Create a mail merge document (extra credit option)

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.

Assignment:

In The Lab #2

Save As: LastName Rosewood Letter

Save Location: rm108users Word Chapter 3 folder

Picture Location: rm108shared | Classes | Computer Applications | Word | Chapter 3 | Rose

Tuesday
Oct. 3

Word Chapter 3 Application Project--DUE drop and complete Rubric

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.2-Use table to enhance documents

FT1.3-Customize document formatting

FT1.4-Create a mail merge document (extra credit option)

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.

Assignment:

In The Lab #2

Save As: LastName Rosewood Letter

Save Location: rm108users Word Chapter 3 folder

Picture Location: rm108shared | Classes | Computer Applications | Word | Chapter 3 | Rose

Wednesday
Oct. 4

Word Chapter 3 Enrichment Assignment

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.2-Use table to enhance documents

FT1.3-Customize document formatting

FT1.4-Create a mail merge document (extra credit option)

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.

Assignment:

Personal Cover Letter

Save As: LastName My Cover Letter

Save Location: rm108users Word Chapter 3 folder

 

Thursday
Oct. 5

Word Chapter 3 Enrichment Assignment

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.2-Use table to enhance documents

FT1.3-Customize document formatting

FT1.4-Create a mail merge document (extra credit option)

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.

Assignment:

Personal Cover Letter

Save As: LastName My Cover Letter

Save Location: rm108users Word Chapter 3 folder

 

REVIEW Word Chapter 3 Training using GMetrix

Friday
Oct. 6

Word Chapter 3 Exam using GMetrix

Standards:

FT1.1-Modify and manipulate paragraphs and paragraph formatting

FT1.2-Use table to enhance documents

FT1.3-Customize document formatting

FT1.4-Create a mail merge document (extra credit option)

FT1.5-Create and use features of word processing software

FT1.6-Format characters

FT1.7-Use Help features

Learning Target:

Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.

   
Monday
Oct. 9
No School for Everyone
Tuesday
Oct. 10
No School for Students
Wednesday
Oct. 1
1

PowerPoint Chapter 1 Training using GMetrix

Standards:

FT3.1-Create a presentation using presentation software

FT3.2-Modify a presentation

FT3.4-Add visual elements

Learning Target:

Students will be able to create a professional presentation using themes, bullets, Word Art, images, visual elements and transitions.

Thursday
Oct. 12

PowerPoint Chapter 1 Training using GMetrix

Standards:

FT3.1-Create a presentation using presentation software

FT3.2-Modify a presentation

FT3.4-Add visual elements

Learning Target:

Students will be able to create a professional presentation using themes, bullets, Word Art, images, visual elements and transitions.

Friday
Oct. 13

PowerPoint Chapter 1 Exam using GMetrix

Standards:

FT3.1-Create a presentation using presentation software

FT3.2-Modify a presentation

FT3.4-Add visual elements

Learning Target:

Students will be able to create a professional presentation using themes, bullets, Word Art, images, visual elements and transitions.

   
Monday
Oct. 16

PowerPoint Chapter 2 Training using GMetrix

Standards:

FT3.1-Create a presentation using presentation software

FT3.2-Modify a presentation

FT3.3-Add visual appeal and animation to a presentation

Learning Targets:

Students will be able to modify and enhance a professional presentation using themes, Word Art, images, visual elements and transitions.

Students will be able to print a presentation using various print options.

Tuesday
Oct. 17

PowerPoint Chapter 2 Exam using GMetrix

Standards:

FT3.1-Create a presentation using presentation software

FT3.2-Modify a presentation

FT3.3-Add visual appeal and animation to a presentation

Learning Targets:

Students will be able to modify and enhance a professional presentation using themes, Word Art, images, visual elements and transitions.

Students will be able to print a presentation using various print options.

Wednesday
Oct. 18

PowerPoint Chapter 3 Training using GMetrix

Standards:

FT3.1-Create a presentation using presentation software

FT3.3-Add visual appeal and animation to a presentation

FT3.4-Add visual elements

FT3.5-Share and present professional presentations

Learning Target:

Students will be able to customize and enhance a professional presentation using custom slide show settings, images, visual elements, audio and visual elements and animations.

Thursday
Oct. 19

PowerPoint Chapter 3 Training using GMetrix

Standards:

FT3.1-Create a presentation using presentation software

FT3.3-Add visual appeal and animation to a presentation

FT3.4-Add visual elements

FT3.5-Share and present professional presentations

Learning Target:

Students will be able to customize and enhance a professional presentation using custom slide show settings, images, visual elements, audio and visual elements and animations.

Friday
Oct. 20

PowerPoint Chapter 3 Exam using GMetrix

Standards:

FT3.1-Create a presentation using presentation software

FT3.3-Add visual appeal and animation to a presentation

FT3.4-Add visual elements

FT3.5-Share and present professional presentations

Learning Target:

Students will be able to customize and enhance a professional presentation using custom slide show settings, images, visual elements, audio and visual elements and animations.

 

Search Engines

Standards:

FT6.1-Demonstrate advanced search techniques within a search engine

FT6.2-Analyze different search engines

Learning Targets:

Students will apply various search techniques while using different search engines to solve an Internet Scavenger Hunt.

Students will be able to distinguish and apply key elements of search engines.

Assignment:

Internet Scavenger Hunt

Develop an understanding by reading through the Introduction to Searching PowerPoint

Assignment: Internet Scavenger Hunt.docx or Internet Scavenger Hunt.pdf

Save As: LastName Internet Search

Save Location: rm108users Search Engines folder

Additional Resources: Google Search Modifiers, Understanding/Comparing Different Search Engines, Search Booleans and Restrictors

 

   
Monday
Oct. 2
3

Search Engines

Standards:

FT6.1-Demonstrate advanced search techniques within a search engine

FT6.2-Analyze different search engines

Learning Targets:

Students will apply various search techniques while using different search engines to solve an Internet Scavenger Hunt.

Students will be able to distinguish and apply key elements of search engines.

Assignment:

Internet Scavenger Hunt

Develop an understanding by reading through the Introduction to Searching PowerPoint

Assignment: Internet Scavenger Hunt.docx or Internet Scavenger Hunt.pdf

Save As: LastName Internet Search

Save Location: rm108users Search Engines folder

Additional Resources: Google Search Modifiers, Understanding/Comparing Different Search Engines, Search Booleans and Restrictors

Tuesday
Oct. 24

Search Engines

Standards:

FT6.1-Demonstrate advanced search techniques within a search engine

FT6.2-Analyze different search engines

Learning Targets:

Students will apply various search techniques while using different search engines to solve an Internet Scavenger Hunt.

Students will be able to distinguish and apply key elements of search engines.

Assignment:

Internet Scavenger Hunt

Develop an understanding by reading through the Introduction to Searching PowerPoint

Assignment: Internet Scavenger Hunt.docx  or Internet Scavenger Hunt.pdf

Save As: LastName Internet Search

Save Location: rm108users Search Engines folder

Additional Resources: Google Search Modifiers, Understanding/Comparing Different Search Engines, Search Booleans and Restrictors

EXTRA CREDIT Assignment:

Search Challenge

Apply your understanding...Test your new found knowledge!

Assignment: Web Search Challenge

Use the snipping tool to screenshot each screen when you have the correct answer submitted and paste into a Word document.

  • You may work with a partner.

Save As: LastName(s) Web Challenge

Save Location: rm108users Search Engines folder

Wednesday
Oct. 25
GUEST SPEAKER! Computer Forensic Examiner & Internet Crimes Against Children (ICAC)
Students will report to the Library and be IN THEIR SEATS when the bells rings. 
Please check in with me prior to taking your seat so I can take attendance. If you do not check in with me you will be counted absent. 

Standards:

FT9.2-Analyze the effect of technology on relationships and communication.

FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations.

FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications.

Assignment:

Reflection Paper

Write a 1 page reflection paper on the speaker.--Due Monday 10/30

There will not be class time to work on the reflection paper.

Thursday
Oct. 26

Search Engines--DUE

Assignment:

Reflection Paper over yesterday's speaker

Write a 1 page reflection paper on the speaker.--Due Monday 10/30

There will not be class time to work on the reflection paper.

 

Introduction to Digital Citizenship

Cyberbullying Video

Assignment:

Guided Movie Questions

Assignment: Guided Movie Questions

Assignment Location: Handout located on my desk.

Turning in the assignment: You will turn in the completed questions at the end of the movie for grading.

Friday
Oct. 27

Introduction to Digital Citizenship

Cyberbullying Video

Assignment:

Guided Movie Questions

Assignment: Guided Movie Questions

Assignment Location: Handout located on my desk.

Turning in the assignment: You will turn in the completed questions at the end of the movie for grading.

   
Monday
Oct. 30

Digital Citizenship

Standards:

FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools.

FT9.2-Analyze the effect of technology on relationships and communication.

FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations.

FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications.

FT9.5-Effectively decipher reliable information on the web.

FT3.1-Create a presentation using presentation software.

FT3.3-Add visual appeal and animation to a presentation.

FT3.4-Add visual elements to a presentation.

FT3.5-Share and present professional presentations.

Learning Targets:

Students will be able to create and deliver a professional presentation.

Students will be able to research and ascertain relevant information on a digital citizenship element.

Students will develop an improved understanding of each of the nine digital citizenship elements.

Assignment Introduction:

Digital Citizenship--9 Elements Presentation

Assignment:

Read through the Project Requirements

Select 1 of the 9 Digital Citizenship Elements that you would like to research and present to the class.

Find a partner who is also interested in researching the same element. (May be groups of 3 depending on class size.)

Remember to pick someone you trust and can work collaboratively with...that isn't always your BFF. Sometimes when choosing friends for partners you tend to spend more time off-task resulting in a lower project grade!

Now you and your partner must sign up! No duplicates!

Additional Resources: Each of the nine elements has its' own rubric. Please locate the rubrics on the shared drive

Tuesday
Oct. 31

Digital Citizenship

Standards:

FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools.

FT9.2-Analyze the effect of technology on relationships and communication.

FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations.

FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications.

FT9.5-Effectively decipher reliable information on the web.

FT3.1-Create a presentation using presentation software.

FT3.3-Add visual appeal and animation to a presentation.

FT3.4-Add visual elements to a presentation.

Learning Targets:

Students will be able to create and deliver a professional presentation.

Students will be able to research and ascertain relevant information on a digital citizenship element.

Students will develop an improved understanding of each of the nine digital citizenship elements.

Assignment Introduction:

Digital Citizenship--9 Elements Presentation

Assignment:

Research your chosen Digital Citizenship Element.

Template to help keep track of sources

Create and design your PowerPoint presentation. Professional in nature

Save your URLs to use/reference when creating your bibliography slides.

I recommend copying and pasting the URL or citing information into the Notes section of your slide

Wednesday
Nov. 1

Digital Citizenship

Standards:

FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools.

FT9.2-Analyze the effect of technology on relationships and communication.

FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations.

FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications.

FT9.5-Effectively decipher reliable information on the web.

FT3.1-Create a presentation using presentation software.

FT3.3-Add visual appeal and animation to a presentation.

FT3.4-Add visual elements to a presentation.

Learning Targets:

Students will be able to create and deliver a professional presentation.

Students will be able to research and ascertain relevant information on a digital citizenship element.

Students will develop an improved understanding of each of the nine digital citizenship elements.

Assignment:

Digital Citizenship--9 Elements Presentation

Assignment:

Continue researching your chosen Digital Citizenship Element.

Continue creating and designing your PowerPoint presentation.

Save your URLs to use/reference when creating your bibliography slides.

I recommend copying and pasting the URL or citing information into the Notes section of your slide

Thursday
Nov. 2

Digital Citizenship

Standards:

FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools.

FT9.2-Analyze the effect of technology on relationships and communication.

FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations.

FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications.

FT9.5-Effectively decipher reliable information on the web.

FT3.1-Create a presentation using presentation software.

FT3.3-Add visual appeal and animation to a presentation.

FT3.4-Add visual elements to a presentation.

Learning Targets:

Students will be able to create and deliver a professional presentation.

Students will be able to research and ascertain relevant information on a digital citizenship element.

Students will develop an improved understanding of each of the nine digital citizenship elements.

Assignment:

Digital Citizenship--9 Elements Presentation

Assignment:

Finish researching your chosen Digital Citizenship Element

Finish creating and designing your PowerPoint presentation.

Save your URLs to use/reference when creating your bibliography slides.

I recommend copying and pasting the URL or citing information into the Notes section of your slide

Friday
Nov. 3

Digital Citizenship Presentations

Standards:

FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools.

FT9.2-Analyze the effect of technology on relationships and communication.

FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations.

FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications.

FT9.5-Effectively decipher reliable information on the web.

FT3.5-Share and present professional presentations.

Learning Targets:

Students will be able to create and deliver a professional presentation.

Students will be able to research and ascertain relevant information on a digital citizenship element.

Students will develop an improved understanding of each of the nine digital citizenship elements.

Assignment:

Assignment: Complete peer evaluation for each group.

Assignment Location: Handout located on my desk.

Turning in the assignment: You will turn in each completed evaluation at the end of the class period.

   
Monday
Nov. 6

Digital Citizenship Presentations

Standards:

FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools.

FT9.2-Analyze the effect of technology on relationships and communication.

FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations.

FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications.

FT9.5-Effectively decipher reliable information on the web.

FT3.5-Share and present professional presentations.

Learning Targets:

Students will be able to create and deliver a professional presentation.

Students will be able to research and ascertain relevant information on a digital citizenship element.

Students will develop an improved understanding of each of the nine digital citizenship elements.

Assignment:

Assignment: Complete peer evaluation for each group.

Assignment Location: Handout located on my desk.

Turning in the assignment: You will turn in each completed evaluation at the end of the class period.

Tuesday
Nov. 7

Digital Citizenship Presentations

Standards:

FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools.

FT9.2-Analyze the effect of technology on relationships and communication.

FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations.

FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications.

FT9.5-Effectively decipher reliable information on the web.

FT3.5-Share and present professional presentations.

Learning Targets:

Students will be able to create and deliver a professional presentation.

Students will be able to research and ascertain relevant information on a digital citizenship element.

Students will develop an improved understanding of each of the nine digital citizenship elements.

Assignment:

Assignment: Complete peer evaluation for each group.

Assignment Location: Handout located on my desk.

Turning in the assignment: You will turn in each completed evaluation at the end of the class period.

Wednesday
Nov. 8

Digital Citizenship Presentations

Standards:

FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools.

FT9.2-Analyze the effect of technology on relationships and communication.

FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations.

FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications.

FT9.5-Effectively decipher reliable information on the web.

FT3.5-Share and present professional presentations.

Learning Targets:

Students will be able to create and deliver a professional presentation.

Students will be able to research and ascertain relevant information on a digital citizenship element.

Students will develop an improved understanding of each of the nine digital citizenship elements.

Assignment:

Assignment: Complete peer evaluation for each group.

Assignment Location: Handout located on my desk.

Turning in the assignment: You will turn in each completed evaluation at the end of the class period.

Thursday
Nov. 9
No School for Students
Friday
Nov. 10
No School for Everyone
   
Monday
Nov. 13

Excel Chapter 1 Training using GMetrix

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.4-Create charts within a spreadsheet to represent data graphically

Learning Target:

Students will be able to construct a worksheet in Excel using and integrating basic formatting techniques and the SUM function.

Students will be able to represent their data graphically using the Insert|Chart features.

Tuesday
Nov
. 14

Excel Chapter 1 Training using GMetrix--Start 2nd time through

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.4-Create charts within a spreadsheet to represent data graphically

Learning Target:

Students will be able to construct a worksheet in Excel using and integrating basic formatting techniques and the SUM function.

Students will be able to represent their data graphically using the Insert|Chart features.

Wednesday
Nov. 1
5

Excel Overview

Class Demo--Download and open Class Example File

Be ready to go with the file open when class starts!

Thursday
Nov. 16

Excel Chapter 1 Application Project

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.4-Create charts within a spreadsheet to represent data graphically

Learning Target:

Students will be able to construct a worksheet in Excel using and integrating basic formatting techniques and the SUM function.

Students will be able to represent their data graphically using the Insert|Chart features.

Assignment:

In The Lab #2

Save As: LastName Davis Mobile Concepts

Save Location: rm108users Excel Chapter 1 folder

Adjustments: See rubric for printing instructions.

Friday
Nov. 17

Excel Chapter 1 Application Project --DUE drop and complete Rubric by end of class!

Assignment:

In The Lab #2

Save As: LastName Davis Mobile Concepts

Save Location: rm108users Excel Chapter 1 folder

Adjustment: See rubric for printing instructions.

Rubrics: On my desk--the sub will need to verify that your file is in the dropbox before you grab a rubric. Turn rubric and printout into assignment basket.

Excel Chapter 1 Training using GMetrix--Start 2nd time through

It is not a day for talking, playing games or working on other homework. You need to complete round 2 GMetrix training without using the light bulbs.

If you are wanting to improve your initial training score, round 2 training needs to be complete and submitted before school starts on Monday.

I will be asking the sub to document your behavior. You were amazing for me while I didn't feel good yesterday. Please extend the same courtesy to your sub. Know that I did try to make it today, but I feel a trip to the doctor and some rest will do me good. Thank you for understanding, following rules and procedures and being on your best behavior!

   
Monday
Nov. 20

Excel Chapter 1 Exam using GMetrix

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.4-Create charts within a spreadsheet to represent data graphically

Learning Target:

Students will be able to construct a worksheet in Excel using and integrating basic formatting techniques and the SUM function.

Students will be able to represent their data graphically using the Insert|Chart features.

Tuesday
Nov. 21

Excel Chapter 2 Training using GMetrix

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

Learning Target:

Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.

Wednesday
Nov. 22
No School for Everyone
Thursday
Nov. 23
No School for Everyone
Friday
Nov. 24
No School for Everyone
   
Monday
Nov. 27

Excel Chapter 2 Training using GMetrix--Formative Assessment for customized training tomorrow

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

Learning Target:

Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.

Tuesday
Nov. 28

Excel Chapter 2 Customized Training

 

Excel Chapter 2 Application Project

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

Learning Target:

Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.

Assignment:

Apply Your Knowledge

Data File Proximity Bus

Save As: LastName Proximity Bus

Save Location: rm108users Excel Chapter 2 folder

Wednesday
Nov. 29

Excel Chapter 2 Application Project--DUE drop and complete Rubric by end of class!

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

Learning Target:

Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.

Assignment:

Apply Your Knowledge

Data File Location: Proximity Bus

Save As: LastName Proximity Bus

Save Location: rm108users Excel Chapter 2 folder

Excel Chapter 2 Enrichment Assignment

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

Learning Target:

Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.

Assignment:

Enrichment Activity

Save As: LastName Internet Providers

Save Location: rm108users Excel Chapter 2 folder

Thursday
Nov. 30

Excel Chapter 2 Enrichment Activity--DUE drop & Rubric by end of class!

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

Learning Target:

Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.

Assignment:

Enrichment Activity

Save As: LastName Internet Providers

Save Location: rm108users Excel Chapter 2 folder

Friday
Dec. 1

Excel Chapter 2 Exam using GMetrix

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

Learning Target:

Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.

   
Monday
Dec. 4

Excel Chapter 3 Training using GMetrix

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

FT2.4-Create charts within a spreadsheet to represent data graphically

Learning Targets:

Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions.

Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options.

Tuesday
Dec.5

Excel Chapter 3 Training using GMetrix--Formative Assessment for customized training tomorrow

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

FT2.4-Create charts within a spreadsheet to represent data graphically

Learning Targets:

Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions.

Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options.

Wednesday
Dec. 6

Excel Chapter 3 Customized Training

 

Excel Chapter 3 Assignment/Homework/Assessment

Assignment/Homework:

Assessment Questions

Save Location: rm108users Excel Chapter 3 folder

DUE TOMORROW!!! Beginning of Class

 

 

Excel Chapter 3 Application Project

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

FT2.4-Create charts within a spreadsheet to represent data graphically

Learning Targets:

Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions.

Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options.

Assignment:

In the Lab #1

Save As: LastName August Online Technology

Save Location: rm108users Excel Chapter 3 folder

Thursday
Dec. 7

Excel Chapter 3 Application Project

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

FT2.4-Create charts within a spreadsheet to represent data graphically

Learning Targets:

Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions.

Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options.

Assignment:

In the Lab #1

Save As: LastName August Online Technology

Save Location: rm108users Excel Chapter 3 folder

Friday
Dec. 8

Excel Chapter 3 Application Project--DUE drop & Rubric by end of class!

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

FT2.4-Create charts within a spreadsheet to represent data graphically

Learning Targets:

Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions.

Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options.

Assignment:

In the Lab #1

Save As: LastName August Online Technology

Save Location: rm108users Excel Chapter 3 folder

 

Excel Chapter 3 Training using GMetrix--review for test on Monday

 

BRING HEADPHONES FOR MONDAY

 

   
Monday
Dec. 11

Excel Chapter 3 Exam using GMetrix

Standards:

FT2.1-Format a spreadsheet to enhance its appearance

FT2.2-Insert formulas into a worksheet to enhance its functionality

FT2.3-Manipulate data within and between workbooks

FT2.4-Create charts within a spreadsheet to represent data graphically

Learning Targets:

Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions.

Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options.

 

What is Access? --understanding where we are going next

 

Tuesday
Dec. 12

Access Chapter 1

Standards:

FT7.1-Create a database table

FT7.2-Create relationships between database tables

Learning Target:

Students will be able to construct a database, a table and enter in data.

Assignment:

Teacher Lead Activity

Save Database As: LastName My Classmates

Save Location: rm108users Access folder

In Class assignment--Create PDF and DROP PDF

   How to Make PDFsand submit for grading?

   We will create Last Name Class Information Table together in class

 

Wednesday
Dec. 13

Access Chapter 1

Standards:

FT7.1-Create a database table

FT7.2-Create relationships between database tables

Learning Target:

Students will be able to construct a database, a table and enter in data.

Assignment:

Teacher Lead Activity

Save Database As: LastName My Classmates

Save Location: rm108users Access folder

In Class assignment--Create PDF and DROP PDF

   How to Make PDFs?

   We will create Last Name Class Information Table together in class

 

Thursday
Dec. 14

Access Chapter 1 Training using GMetrix

Standards:

FT7.1-Create a database table

FT7.2-Create relationships between database tables

Learning Target:

Students will be able to construct a database, a table and enter in data.

Friday
Dec. 15

Access Chapter 1 Training using GMetrix

Standards:

FT7.1-Create a database table

FT7.2-Create relationships between database tables

Learning Target:

Students will be able to construct a database, a table and enter in data.

   
Monday
Dec. 18

Access Chapter 1 Application Project

Standards:

FT7.1-Create a database table

FT7.2-Create relationships between database tables

Learning Target:

Students will be able to construct a database, a table and enter in data.

Assignment:

Dartt Database

Save Database As: LastName Dartt Database

Database Save Location: rm108users Access folder

PDFs Save Location: rm108users Access folder | LastName Dartt Database PDFs folder

Tuesday
Dec. 19

Access Chapter 1 Application Project--DUE Drop & Rubric by end of class!

Standards:

FT7.1-Create a database table

FT7.2-Create relationships between database tables

Learning Target:

Students will be able to construct a database, a table and enter in data.

Assignment:

Dartt Database

Save Database As: LastName Dartt Database

Database Save Location: rm108users Access folder

PDFs Save Location: rm108users Access folder | LastName Dartt Database PDFs folder

Wednesday
Dec. 20

Access Chapter 1 Exam using GMetrix

Standard:

FT7.1-Create a database table

FT7.2-Create relationships between database tables

Learning Target:

Students will be able to construct a database, a table and enter in data.

Thursday
Dec. 21

Access Chapter 2 Training using GMetrix

Standards:

FT7.3-Perform queries and filter records

FT7.4-Create forms in the database

FT7.5-Create reports in the database

Learning Target:

Students will be able to create forms, reports and various queries.

Friday
Dec. 22

Access Chapter 2 Training using GMetrix

Standards:

FT7.3-Perform queries and filter records

FT7.4-Create forms in the database

FT7.5-Create reports in the database

Learning Target:

Students will be able to create forms, reports and various queries.

   
Monday
Dec. 25 thru
Friday
Jan. 5
Winter Holiday
   
Monday
Jan. 8

Access Chapter 2 Application Project

Standards:

FT7.3-Perform queries and filter records

FT7.4-Create forms in the database

FT7.5-Create reports in the database

Learning Target:

Students will be able to create forms, reports and various queries.

Assignment:

Intro to Forms, Reports and Queries

Open Database: LastName My Classmates

Open Location: rm108users Access folder

Save Location: rm108users Access folder | LastName Chapter 2 Application Project folder

Tuesday
Jan. 9

Access Chapter 2 Application Project

Standards:

FT7.3-Perform queries and filter records

FT7.4-Create forms in the database

FT7.5-Create reports in the database

Learning Target:

Students will be able to create forms, reports and various queries.

Assignment:

Intro to Forms, Reports and Queries

Open Database: LastName My Classmates

Open Location: rm108users Access folder

Save Location: rm108users Access folder | LastName Chapter 2 Application Project folder

Wednesday
Jan. 10

Access Chapter 2 Exam using GMetrix

Standards:

FT7.3-Perform queries and filter records

FT7.4-Create forms in the database

FT7.5-Create reports in the database

Learning Target:

Students will be able to create forms, reports and various queries.

Thursday
Jan. 11

Review for the final test.

Final exam will be administered in GMetrix and covers Word, Excel, Access and PowerPoint.

Friday
Jan. 12

Review for the final test.

Final exam will be administered in GMetrix and covers Word, Excel, Access and PowerPoint.

   
Monday
Jan. 15
No School for Everyone
Tuesday
Jan. 16
Period 1    8:15-9:45
Period 3    9:55-11:25
Lunch       11:25-12:35
Period 5    12:40-2:10
Make-up    2:10-3:30
Wednesday
Jan. 17
Period 2    8:15-9:45
Period 6    9:55-11:25
Lunch       11:25-12:35
Period 4    12:40-2:10
Make-up    2:10-3:30
Thursday
Jan. 18
Period 7    8:15-9:45
Period 8   
9:55-11:25
Friday
Jan. 19
No School for Students