Limited Time Offer: Get 2 Months of ABCmouse.com for only $5!

7th Grade

BCT, Students will become independent users of technology for school and personal needs. Emphasis will also be placed on organization, following oral and written directions, independent work habits, and cooperative learning. Course Outline: • Keyboarding Skills • Ergonomics • Computer Literacy • Word Processing • Desktop Publishing • Fundamental • Document Processing (letters, memos, reports) • Databases • Spreadsheets • Telecommunications • Multimedia presentations.

  
7th grade must type with 25 gwam with 3 or fewer errors Keyboarding Grading

   

Chart 7th Grade    

100 % 

15 + Drills
98 % 14
96 % 13
9412
9211
9010
859
808
767
726
605
504 -

                       

Do not skip any drills.  Keyboarding makes up 25 % of your grade in computer science.  Remember you will get a progress grade, 4 keyboarding technique grades and one (Testing / MS Excel)  line chart grade).

       

                         

Monday, March 22, 2010 

Objectives: 

CTO4.01   Identify Advantages of Word, Desktop Publishing Software
CTO4.02   Identify and Explain Word, Desktop Publishing Terms
CTO4.03   Create basic documents
CTO4.04   Retrieve, format, and edit various documents
CTO4.05   Create advanced documents.
             

 1.  Microtype - Please check lessons completed via report link
2.  Lecture PowerPoint & Vocabulary
3.  Using a template Design a Certificate, save as certificate

                             

Tuesday, March 23, 2010 

CTO4.01   Identify Advantages of Word, Desktop Publishing Software
CTO4.02   Identify and Explain Word, Desktop Publishing Terms
CTO4.03   Create basic documents
CTO4.04   Retrieve, format, and edit various documents
CTO4.05   Create advanced documents.
  

1.  Microtype - Please check lessons completed via report link
2.  Lecture Right Tab Stop
3.  Performance Test:  Design an Awards Program - Save as Awards

 

Wednesday, March 24 - 25, 2010 

CTO4.01   Identify Advantages of Word, Desktop Publishing Software
CTO4.02   Identify and Explain Word, Desktop Publishing Terms
CTO4.03   Create basic documents
CTO4.04   Retrieve, format, and edit various documents
CTO4.05   Create advanced word processing and desktop publishing documents.
 

 1.  Microtype - Please check lessons completed via report link
2.  Lecture about Templates
3.  Creating an invitation or Greeting Card             
     Using a template of your choice, make an invitation or greeting card

                               

Friday, March 26, 2010 

CTO4.03   Create basic documents
CTO4.04   Retrieve, format, and edit various documents
CTO4.05   Create advanced word processing and desktop publishing documents.

                       

Review of lessons learned:Desktop Publishing concepts:  http://www.quia.com/ba/119865.htmlWP Battle:  http://www.quia.com/ba/119883.htmlWord Processing Terms: http://www.quia.com/cm/144970.htmlWord Processing and Desktop Publishing:  http://www.quia.com/jg/1172057Word Processing:  http://www.quia.com/hm/334438.thml

 What ways can we create a document that reflects a great city?

 Directions:
1. Change the font, and size of the Title to 24 pt and the Font of your choice.
2. The  (C) means to CENTER and () means to indent {tab}.  Erase codes when finished.
3. Bold and underline each answer.
4. Don't forget to erase the directions and do a Spell Check.

5. And add 3 graphics (text wrap all graphics!).

        

Name:  ___________             Exploratory #:  7     Date  __ - __ - __  

(C) Job1: History of Gwinnett ()Gwinnett County was created by the state in ____.  It is ____ square miles, and was named after ___________, one of Georgia’s three signers of the Declaration of Independence.  A famous name rather than a famous man, Gwinnett never set _____ in the county that bears his name. ()Elisha Winn secured the site of the county seat by purchasing 250 _____ of land for $200, which was incorporate as the city of _______.  By the end of the 1820s, Gwinnett’s population was more than 13,000. ()Gwinnett was swept into the modern era in the 1950s when Buford ____ was built.  The result was the creation of Lake Sidney Lanier in 1957, which fostered a major industry for the state of Georgia – recreational ______.  Two years later, Interstate 85, the county’s main thoroughfare, was completed to Pleasant Hill Road in Duluth. ()The 1980s was a decade of enormous growth.  With the advent of Gwinnett Place Mall in 1984, the county shifted from a rural, agricultural economy to a booming metropolis with corporate ________, major manufacturing, high-technology and service industries.  And for much of the ‘80s, Gwinnett held the title of “Fastest Growing County in the U.S.,” which Orange County, Florida (home of Disney World), had previously held. ()Even today, Gwinnett is the eighth fastest growing county in the nation, with a population estimated at 480,000.  Comprised of 15 separate ______ and bordered by seven counties, the 1990s continue to infuse prosperity and growth with the Mall of Georgia, the TPC at Sugarloaf, and unprecedented corporate and residential growth. 

                       

Monday, March 29 - April 1, 2010   

Report Formatting

     

CTO4.03   Create basic documents
CTO4.04   Retrieve, format, and edit various documents
CTO4.05   Create advanced word processing and desktop publishing documents.

Review of lessons learned:

Editing a mixed up personal - Business Letter Research / Writing Skills
“It's a Bird, It's a Plane, It's Travel Time” Travel Brochure Project
Brief Project Overview
In this project, students will demonstrate their Internet research and persuasive writing skills to create colorful, informative travel brochures to popular vacation destinations, all while gaining valuable communication skills working with their peers and exploring many areas of the world they have yet to see!

Appropriate Subjects and Grade Levels
Business

7th and 8th Grade Optional: Interdisciplinary Connections - Math, Foreign Language

Length of Project
Approximately 3-4 days (55-minute class periods)
NOTE: The length of this project is an estimated minimum time needed for completion that may easily be expanded upon. The length of time will naturally increase as the project is expanded upon by the teacher as it is adapted to meet classroom and curriculum goals.

      
Travel Brochure Rubric 
Outcomes/Products Assessments and Standards Matrix
– identifies lesson outcomes, standards addressed, and ways to measure learning; includes a brief description of corresponding student activities


Student Materials Provided
Analyzing Travel Brochures student worksheet with short answer questions related to identifying attributes of an effective travel brochure

Travel Brochure Roles & Job Descriptions handout clarifying division of labor for the group’s travel brochure research and writing

Web Links handout with suggested web addresses useful for this project

 

                    

Monday, April 5th - 6th, 2010  

CTO4.03   Create basic documents
CTO4.04   Retrieve, format, and edit various documents
CTO4.05   Create advanced word processing and desktop publishing documents.
               Review of lessons learned:Editing - proofreading an unbound report

               

 Wednesday, April 7th - 9th, 2010 

CTO4.03   Create basic documents
CTO4.04   Retrieve, format, and edit various documents
CTO4.05   Create advanced word processing and desktop publishing documents. 
               Review of lessons learned:Editing - Proofreading / Leftbound Report Formatting  

Internet Article Questions  Directions: Answer each of the following questions in your own words using the article "The Internet: What's the fuss?" on the Internet.   (Title - "The Internet: What's the fuss?", three - four paragraphs that answers the questions below, second page to include two - three paragraphs that includes the information for Part II.

1.What has made the Internet so popular?
2.What does ISP stand for and give one example?
3.What does HTML, URL, and HTTP mean?
4.The speed of the Internet is measured in (bps). What does bps mean?
5.Why has publishing on the Internet attracted so many people?
6.E-mail is a big part of the Internet. What does e-mail look like and name one advantage to using e-mail?
7.How many years ago was it before the Internet got its start?
8.What was the main reason it started?
9.A browser is what?
10. What are some of the reasons (name 2) for people not connecting to the Internet?

                         

 Part II

11. Give an example of a real URL.
12. When text is in a different color on a web site, that is referred to as what?
13. What is a browser and what is the most popular browser today?
14. Name a different browser than the one in question 13.
15. How are computer messages sent across the telephone?

                  

Monday, April 12th - 16th, 2010

 
CT005.00  Utilize Spreadsheet software. 
CT05.01  Identify advantages and uses of spreadsheet software and charts/graphs.
CT05.02  Identify and explain spreadsheet terminology.
CT05.03  Create and save basic spreadsheets and apply formulas.
CT05.04  Retrieve, edit, manipulate, and print various spreadsheets.
CT05.05  Create various charts/graphs from spreadsheets.
                           

Lesson 1: Entering Text and Numbers

Microsoft Excel is an electronic spreadsheet that runs on a personal computer. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly. This tutorial teaches Microsoft Excel basics. Although knowledge of how to navigate in a Windows environment is helpful, this tutorial was created for the computer novice. This lesson will introduce you to the Excel window. You use the window to interact with Excel.

Lesson 2: Entering Excel Formulas and Formatting Data

Lesson 1 familiarized you with the Excel 2007 window, taught you how to move around the window, and how to enter data. A major strength of Excel is that you can perform mathematical calculations and format your data. In this lesson, you learn how to perform basic mathematical calculations and how to format text and numerical data.

Lesson 3: Creating Excel Functions, Filling Cells, and Printing

By using functions, you can quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number, and a count of the number of items in a list. Microsoft Excel has many functions you can use. You can also use Microsoft Excel to fill cells automatically with a series. For example, you can have Excel automatically fill your worksheet with days of the week, months of the year, years, or other types of series.

A header is text that appears at the top of every page of your printed worksheet. A footer is text that appears at the bottom of every page of your printed worksheet. You can use a header or footer to display among other things titles, page numbers, or logos. Once you have completed your Excel worksheet, you may want to print it. This lesson teaches you how to use functions, how to create a series, how to create headers and footers, and how to print.

Lesson 4: Creating Charts

In Microsoft Excel, you can represent numbers in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same no matter what type of chart you choose. As you change your data, your chart will automatically update. This lesson teaches you how to create a chart in Excel.

 Assignments / ExamplesDesigning a Survey 

Students use their peers as a sample group to ask a series of questions.  They must then take this data a create pie, bar, and line graphs.-  http://www.crews.org/curriculum/ex/compsci/6thgrade/ssassign/survey01.htm.Spreadsheet FormulasThe use of formulas is very important feature of spread sheets.  We will focus our attention on the =average, and =sum formulas.  - http://www.crews.org/curriculum/ex/compsci/6thgrade/ssassign/formula01.htmPlanning a Party Design a party for your peers.  This is an assignment that must be created using a spread sheet in ClarisWorks.  A pie chart must be used to graph your party data. - http://www.crews.org/curriculum/ex/compsci/6thgrade/party.html

    

Monday, April 19th - 30th, 2010

CT006.  Utilize database software.
CT06.01  Identify advantages and uses of database software.
CT06.02   Identify and explain database terminology.
CT06.03  Create and save basic databases.
CT06.04  Retrieve, manipulate, and print various databases.
What is Microsoft Access?

Microsoft Access is a Database Management System. It handles data management tasks the same way as Word handles document management and Excel handles statistics ...

Lesson 1 - Microsoft Access Introduction

Lesson 2 - Designing the application - tables, fields, data types, properties

Lesson 3 - Creating the database - primary key, creating tables

Lesson 4 - Defining Table relationships - referential integrity, primary and foreign keys

Lesson 5 - Entering data into Tables - data view, sorting and ordering

Lesson 6 - Creating data-entry forms - data validation, default values

Lesson 7 - Building simple Queries - sorting, selection criteria, working with dates

Lesson 8 - More complex Queries - multiple tables, linking, functions

Lesson 9 - Creating a Master/Detail form

Lesson 10 - The Microsoft Access Application Menu - the Switchboard

Lesson 11 - Creating Macros - autoexec, conditions

Lesson 12 - Writing Reports

Lesson 13 - Sales Analysis Reports with Microsoft Access

Lesson 14 - Action Queries - Updating data

                     

 Monday, May 3rd, 2010 

CT007.      Utilize multimedia / presentation graphics software.
CT07.01  Identify advantages and uses of multimedia/presentation graphics software.
CT07.02  Identify and explain multimedia/presentation graphics terminology.
CT07.03  Plan and design basic presentations.
CT07.04  Create, save, print, and present basic presentations.

     Cities of the World - Online Project
Get into teams of 4 students and decide on a city in the world to research.  Then decide on who wants to be the technologist, historian, statistician, and attractions person.  Find three facts.  Write your facts down on note cards and create a PowerPoint slide from your notes. Sim3000 Codes

See all the code for the game.City Games... Finished with your presentation and now need a challenge?  Take the CITY challenge and play some online games.  http://www.crews.org/curriculum/ex/compsci/6thgrade/city_games.htmInternet Safety Quiz
This site is fun place to learn the rules of the road or should I say (ocean) surfing.  Answer the questions found on this site and then print out your certificate (badge).  Be a safe surfer today!
  Directions: Write a one page story as if the limitations of time, money, resources, people,, etc… were not an issue and you could solve some of the most difficult problems facing life today.  Stick to the 6 areas below.  Write at least 1 paragraph under each area!  This should be an innovative or a new approach – “Think outside the box

    

1.     Population
a.     Why do people flock to certain cities and not others?
b.    How can we increase a city’s population but control how close people live together?
c. *What factors balance how many people live in a city?
   
2.     Unemployment
a.     What can be done to assist those people out of work or who have low paying jobs, or just hate their jobs and want a change?
b.  What ways can you attract and keep high paying jobs in a city?
  
3.     Crime
a.     Describe why crime is so bad now.
b.    What challenges will we face in the future with crime?
c.     What new or innovated approach do you suggest to lower crime?
d. *How did you feel about your ability to deal with crime in your sim town?
       
4.     Pollution
a.     What ways are we polluting the air?
b.    What are the alternatives to gasoline, coal, landfills, etc…?
c.     How would you stop or lower pollution of our planet?
d.    *What are the challenges to get lower pollution levels?
e. *Why is it such a challenge to change?
    
5.     Health
a.     What problems do people face concerning their health? b.    What ways can government help people live longer besides just build more hospitals? c.     *What ways can you motivate people to live healthier lives?

    

6.     Education
a.     What makes up a good school?
b.    What ways can you continue to have kids stay in school and really enjoy it and therefore learn more?
c.     *Why don’t kids like school more?
* Optional

                

 Wednesday, May 5th, 2010

 Integrated Skills Shows links to other Microsoft Applications. 

Shows the relative importance of each objective, competency, and unit.  Emphasis is placed on cognitive and performance of assignments.Edit city report created in Microsoft Word at the end of 3rd quarter, modify to include the information from the link attached.  Convert document into a web page. http://www.crews.org/curriculum/ex/compsci/6thgrade/mini/index.html

                        

 Monday, May 10th, 2010 
Vocats Review

        

 Monday, May 17th, 2010 
Vocats Review

                    

 Monday, May 24th, 2010 
Vocats Review and Exam
Get 2 Months for $5!