syllabus in tle 7 (computer 1) first quarter7 syllabus in tle 7 second quarter grade level standard...

1

SYLLABUS IN TLE 7 (COMPUTER 1)

FIRST QUARTER

Grade Level Standard

The learner demonstrates understanding of the Internet and web standards for design and

planning; demonstrates competence in performing basic typing operations using word

processing application by creating and formatting documents.

Content Standard

The learner demonstrates understanding of how networking and the Internet works; describe the

internet etiquette and copyright law; consider the important characteristics of a good web site in

creating a web site design and development; demonstrates understanding of Ms Word in

preparing documents.

Performance Standard The learner transfers learning by: Demonstrating proper conduct in various online activities and complete preproduction design requirements and tasks prior to developing a web site; Preparing documents according to user requirements.

Time Frame

Topics Learning Competencies Assessment

Week 1

Orientation

Rules and Regulations in the computer laboratory

Student Activity Program/Seat Plan/groupings

Grading System

Pre-test

Week 2

CREATING CONTENT USING PRODUCTIVITY TOOLS – MS WORD

Microsoft Word and MS Word Application Window

Entering Text, Saving the document/Opening the saved document

VALUING: Using user-friendly application

The learner:

Identifies the different parts of Ms Word screen.

Recognizes basic commands and functions,

Demonstrates how to create, save, open and close documents.

Follows the steps in saving, opening, renaming, preview, and closing document.

Creates/types a simple document

Formative:

Picture analysis

Summative:

(Icons of the HOME tab). To become familiar with the different icons of the HOME tab.

2

Programs using MS Word.

Week 3

EDITING DOCUMENT

Moving and Selecting Text

Copying, Moving, and Pasting

Inserting/Deleting Text

Undoing Mistakes

Finding text

VALUING:

Using user-friendly application Programs

The learner:

Identifies the methods in moving around the document and selecting text.

Inserts text using basic commands such as cut, copy, paste, redo, and undo.

Demonstrates how to find specific words in the document

Formative:

Locate errors in the document game

Summative:

Activity #1: Typing the first document about “Understanding Entrepreneurship”

To explore the Ms Word environment and prepare the first document in Ms Word.

Activity #2: Trees To edit a file with misspelled words.

Week 4

FORMATTING DOCUMENTS using FONT, PARAGRAPH, and STYLES group in the HOME tab

Inserting clip art, Pictures or graphics.

PAGE LAYOUT formatting commands

Drop cap (INSERT TAB)

The learner:

Applies the different commands of the FONT group of the HOME tab like font, font size, font style, etc.

Changes font face and font size.

Emphasizes words with font styles bold, italic, and underline.

Applies special font effects like strikethrough, subscript, and superscript.

Uses font colors and highlight

Formative:

One stray, team stay about formatting documents ”

Summative:

Activity 3:Format the file “Understanding

3

VALUING:

Improves the readability of documents with graphics, and formatting commands.

colors.

Changes the paragraph alignment.

Changes the line spacing.

Adds borders and shading to selected paragraphs.

Enumerates and demonstrates the steps in inserting bullets and numbering

Indents paragraphs.

Determines how to insert pictures, clip art, and word art.

Arranges pictures inside the document.

Demonstrates how to wrap text around the picture.

Changes the margins, paper size, and orientation of the document.

Inserts page border and page color.

Creates newspaper style layout using columns in MS Word.

Designs newspaper style columns with drop cap letter at the beginning of the paragraph.

Entrepreneurship”

Summative:

Activity 4: Song and Poem

Week 5 FIRST MID-QUARTER EXAM

4

Week 6

Chapter 1 - The Internet And Internet Etiquette

Headers and footers

Page numbers

Word Art

Textbox VALUING:

Show creativity in preparing documents

Respect for Intellectual Property

The learner:

Describes through a diagram how networking and the internet work.

Identifies the classification of the given network based on coverage and availability using given examples.

Follows Internet Etiquette.

Obeys Intellectual Property rights.

Applies the copyright law on a given set of situations.

Enumerates the steps in creating columns, headers, footers, and page numbers.

Demonstrates how to insert headers and footers in a document.

Shows how to insert page numbers in the document.

Shows how to create word art text and textbox.

Formative:

Video Presentation about “How the Internet works”

Summative:

Activity 5: Chapter 1: Internet and Internet Etiquette To make a summary of chapter 3 with an Internet diagram

Week 7

Creating “BOOKMARKS” to be used in the Exhibit on August 29, 2016.

Inserting shapes using Illustrations group

The learner:

Draws different kinds of shapes in Word by using the Illustrations group of the INSERT tab.

Demonstrates how to draw basic shapes, lines, block arrows, callouts, stars, and banners.

Formats any object with shape fill color, shape outline color, Font, Line,

Formative: Recitation

Ask students to identify/enumerate the shapes in the given picture

Summative:

5

VALUING:


arrow, shadow effects, and 3-D effects, and dash style

Rotates the objects

Combines 2 or more objects with Group/Ungroup objects command.

Inserts symbols in the document.

Produces a document similar to those created in MS Paint or any graphic software

Transfer Goal

In line with the Nutrition Month Celebration, the TLE dept will have an activity tag as “Fiesta sa Gym: Halina at Makisaya sa TLE Day siguradong may kita”

This is to showcase talents and skills learned in different components, so students will have a chance to portray the role of an entrepreneur, baker, programmer, web designer, artists etc. This is also a way for the students to experience the real world of work.

Activity 6: Creating

“BOOKMARKS”

Activity 7: (SHAPES). To create comic strips that will show Good manners and Right Conduct using the different SHAPES of Ms Word.

Week 8

NUTRITION MONTH

Exhibit and Enterprising Day at the GYM “Fiesta sa Gym: Halina at Makisaya sa TLE Day siguradong may kita”

6

Week 9

Tables

Printing

VALUING: Organize data/information

The learner:

Creates tables in Word.

Determines how to create tables in word.

Shows how to enter and select data in a table.

Determines how to insert/delete and select rows and columns in a table.

Demonstrates how to merge and split cells in a table.

Demonstrates how to rotate text.

Formats table using the icons/commands of table tools layout and design.

Uses the different document views of word

Produces hard copies of documents.

Formative:

Picture analysis

Summative:

Activity 8: (Class

schedule).

To prepare a Class

Schedule using

tables.

Activity 9: (Calendar in Word). To create a Calendar for the present year using tables in Ms Word.

NOTE: Post-test will be

given to students

Week 10 FIRST QUARTER EXAMINATION

7

SYLLABUS IN TLE 7

SECOND QUARTER


The learner demonstrates understanding of the process of making documents, presentations,

and spreadsheets; demonstrates competence in performing basic spreadsheets operations

using Ms Excel program by creating and formatting workbooks, create formulas and functions as

well as interpret data using charts; demonstrates competence in preparing presentation.

Content Standard

The learner demonstrates understanding of the specific use of each of the featured productivity

tools; use the standard features of each productivity tools and select the appropriate command in

completing tasks.

Performance Standard The learner transfers learning by: using productivity and developmental tools in an efficient and creative way when designing web sites. Preparing presentations and worksheets according to information requirements.

Time Frame


Week 1

Microsoft PowerPoint

Ms PowerPoint Application Window

Valuing:


The learner:

Identifies the purpose of Ms PowerPoint application and its uses.

Identifies the different parts of PowerPoint

Uses the ribbon and context menus in manipulating slides.

Distinguishes the PowerPoint Panes

Views slide in different ways.

Navigates slides inside the presentation.

Opens and exit Microsoft PowerPoint.

NOTE: Pre-Test about PowerPoint and Excel will be given to students Formative:

Name the icons familiar with the students in a form of a game.

Summative:

8

Preparation of Project 1: SURVEY

Make a survey using MS Word and Ms Excel

Week 2

Ms PowerPoint Tips

Using placeholder and slides

Enter text and graphics in the placeholders

Chapter 2 - Principles Of Web Design

VALUING:

Follow standards/advice


The learner:

Applies tips in creating effective PowerPoint presentations.

Uses PowerPoint to create presentations for Chapter 2 - List down the important considerations in designing a website and generate appropriate domain names for businesses and organizations Create a new slide.

Changes the slide design.

Sorts slides.

Views the slide show presentation.

Formative:

Recitation

Summative:

Activity 1 : chapter 2 Prepare presentation about Principles of Web Design presentation

Week 3

Formatting

Animation

Transition

Emphasize test and objects using shapes.

Basic Documentation And Storyboarding Process For Website Development

The learner:

Distinguishes the four kinds of animations.

Applies animation effects to objects, texts and slides.

Discovers how to apply multiple animations to an object.

Discovers how to modify and reorder animations.

Demonstrates how to add slide

Activity 2 : Chapter 3 Storyboard Critiquing a storyboard

9

transition.

Creates slides transition.

Uses shapes to emphasize text and graphics accompanied by custom animation.

Week 4

I. Microsoft Excel

The Microsoft Excel Application Window

Workbook management

Moving around excel

Mouse pointer shapes

VALUING:


The learner:

Identifies the purpose of Ms Excel application and its uses.

Uses the ribbon and context menus in manipulating worksheets.

Identifies the basic parts and function of Ms Excel screen.

Recognizes basic commands and functions of the HOME tab

Creates a simple workbook.

Demonstrates how to create, save, open and close workbook.

Follows the steps in saving, opening, renaming, preview, and closing workbook.

Determines on how to move around worksheet.

Identifies the methods used in inserting and deleting worksheets and cells in Ms Excel.

Differentiates the mouse pointer shapes used in Excel.

Uses Auto fill feature to fill cells with data that follows a pattern

Formative:

Recitation: Identify the parts of Ms Excel screen

Activity 3:

Exercise 1

Enter data in a worksheet

10

Week 5 SECOND MID-QUARTER EXAMINATION

Week 6

Data Management

Working with worksheets

Formatting a worksheet VALUING:

Organize data/information

The learner:

Identifies the 3 types of data.

Determines on how to enter text, values, dates, and fractions.

Organizes data in the worksheet.

Applies the steps in selecting and changing data in a cell.

Defines Formatting and the common tools in formatting data.

Determines how to format text, values, and cells in a worksheet.

Demonstrates how to merge and center text.

Enumerates the steps on how to align cell contents, rotate, and wrap text in a cell.

Applies colors and borders in Excel worksheets.

Formative:

Recitation:

“one stray,

team stay”

about the

icons of the

different tabs

in Ms Excel

and formatting

commands in

MS Excel

Summative:

Activity

4:Class

schedule:

To prepare a

class schedule

using MS

Excel

Week 7

FORMULAS

FUNCTION VALUING:

Follow correct rules and

The learner:

Manipulates values/numbers in the worksheets

Defines formula and function.

Names the different mathematical

calculations and their symbols MS excel

can do.

Demonstrates how to enter formula in

Formative:

Students

perform basic

arithmetic

operations in

Math using the

game “One

stray, team

11

procedures excel.

Performs mathematical calculations in a

worksheet using addition, subtraction,

multiplication, and division.

Formats the numeric entries with $,

Comma, percent, and Phil currency.

Shows how to create functions in excel.

Calculates totals using Auto sum feature

of Excel.

Displays the lowest and highest number

in excel.

Shows how to compute average in excel.

Counts the number of cell entries in the

worksheet.

stay”.

Summative:

Activity 5:

Exercise 1 &

2:

Using

Formulas

To create

formulas in

Excel using

the basic

arithmetic

operations

Completion of

the Survey

Project:

Interpret the

data of the

survey by

preparing tally

sheet.

Week 8

CHARTS

VALUING:

Interpret data/ creativity

The learner:

Identifies the different charts used in Ms Excel.

Demonstrates the steps on how to create charts in Excel.

Modifies the chart with the chart tools design, layout, and format commands.

Demonstrates how to modify, update, and resize, change colors and patterns

Formative:

Ask students

to bring the

following:

Bread

Different kinds

of fruits

to be used in

12

of a chart. discussing

charts

Summative:

Activity 6:

To

interpret/analy

ze data in the

worksheet by

creating

charts.

Submission of

Survey project

Week 9

WEB MARKUP LANGUAGES AND DEVELOPMENT TOOLS

Writing in Another Language

Web Development Tools

Converting Documents, Presentations, and Worksheets to web pages.

VALUING:

Following appropriate formats (or standards)

The learner:

States the steps in converting documents, slide presentations, and worksheets into web pages by creating a flowchart of steps.

Identifies the significance of files that are created after the conversion process.

States the reason why documents, slide presentations, worksheets, and other files should be converted for use in the web.

Creates Web documents by converting Microsoft Office files.

Transfer Goal: The knowledge and skills acquired by the students in Ms Word and Ms Excel will

Summative:

Activity 7: Exercises #1,2, and 3

Converting documents, presentations, and worksheets into web pages:

NOTE: Post test will be given to students

13

help them in conducting a research/survey about different topics. The students will act as researchers. Suggested sample topics that they may use for the survey are the following:

1. Top 5 most viewed TV station 2. Books that students borrow in the

library 3. Favorite place of students at HAU 4. Factors that make students study

harder. 5. Favorite web sites of students 6. Favorite social networking sites of

students 7. Factors that affect the studies of

students. 8. People that inspire students to

strive harder.

If the students have in mind of what survey and research they want to work on, they may do so. They will use MS Word for the survey forms (data collection) formulating their own questions. Their respondents are selected students of all year levels of HAU. Make a tally sheet in MS Excel using spreadsheet. Interpret and analyze data using charts.

14

The survey will allow students to experience real life work situations.

Week 10 SECOND QUARTER EXAMINATION

15

SYLLABUS IN TLE 7 (COMPUTER 1)

THIRD QUARTER


The learner demonstrates understanding of the Internet and web standards for design and

planning; demonstrates competence in performing basic typing operations using word

processing application by creating and formatting documents.

Content Standard

The learner demonstrates understanding of how networking and the Internet works; describe the

internet etiquette and copyright law; consider the important characteristics of a good web site in

creating a web site design and development; demonstrates understanding of Ms Word in

preparing documents.

Performance Standard The learner transfers learning by: Demonstrating proper conduct in various online activities and complete preproduction design requirements and tasks prior to developing a web site; Preparing documents according to user requirements.

Time Frame


Week 1

Orientation

Rules and Regulations in the computer laboratory

Student Activity Program/Seat Plan/groupings

Grading System

Pre-test

Week 2

CREATING CONTENT USING PRODUCTIVITY TOOLS – MS WORD

Microsoft Word and MS Word Application Window

Entering Text, Saving the document/Opening the saved document

VALUING: Using user-friendly application

The learner:

Identifies the different parts of Ms Word screen.

Recognizes basic commands and functions,

Demonstrates how to create, save, open and close documents.

Follows the steps in saving, opening, renaming, preview, and

Formative:

Picture analysis

Summative:

(Icons of the HOME tab). To become familiar with the different icons of the HOME tab.

16

Programs closing document.

Creates/types a simple document using MS Word.

Week 3

EDITING DOCUMENT

Moving and Selecting Text

Copying, Moving, and Pasting

Inserting/Deleting Text

Undoing Mistakes

Finding text

VALUING:


The learner:

Identifies the methods in moving around the document and selecting text.

Inserts text using basic commands such as cut, copy, paste, redo, and undo.

Demonstrates how to find specific words in the document

Formative:

Ask students to locate errors in the document.

Summative:

Activity #1: Typing the first document about “Understanding Entrepreneurship”

To explore the Ms Word environment and prepare the first document in Ms Word.

Activity #1A: Trees To edit a file with misspelled words.

Week 4

FORMATTING DOCUMENTS using FONT, PARAGRAPH, and STYLES group in the HOME tab

Inserting clip art, Pictures or graphics.

PAGE LAYOUT formatting commands

Drop cap and Word Art (INSERT

The learner:

Demonstrates how to format text in MS Word.

Applies the different commands of the FONT group of the HOME tab like font, font size, font style, etc.

Determines how to format paragraphs using the paragraph

Formative:

One stray, team stay about formatting documents

Compare unformatted and formatted documents

17

TAB)

VALUING:

Improves the readability of documents with graphics, and formatting commands.

group of the HOME tab.

Changes font face and font size.

Emphasizes words with font styles bold, italic, and underline. The learner:

Applies special font effects like strikethrough, subscript, and superscript.

Uses font colors and highlight colors.

Changes the paragraph alignment.

Changes the lie spacing.

Adds borders and shading to selected paragraphs.

Enumerates and demonstrates the steps in inserting bullets and numbering

Indents paragraphs.

Determines how to insert pictures and clip art.

Arranges pictures inside the document.

Demonstrates how to wrap text around the picture.

Applies the page formatting commands.

Changes the margins, paper size, and orientation of the document.

Inserts page border and page color.

Creates newspaper style layout using columns in MS Word.

Designs newspaper style columns

Summative:

Activity 2a:Format the file “Understanding Entrepreneurship”

Summative:

Activity 2b: Song and Poem

18

with drop cap letter at the beginning of the paragraph.

Inserts WordArt text in the document.

Formats the word Art text.

Week 5 THIRD MID-QUARTER EXAM

Week 6

Chapter 1 - The Internet And Internet Etiquette

Headers and footers

Page numbers

Chapter 2: Principles of Web Design

VALUING:

Respect for Intellectual Property

The learner:

Describes through a diagram how networking and the internet work.

Identifies the classification of the given network based on coverage and availability using given examples.

Follows Internet Etiquette.

Obeys Intellectual Property rights.

Applies the copyright law on a given set of situations

Enumerates the steps in creating columns, headers, footers, and page numbers.

Demonstrates how to insert headers and footers in a document.

Shows how to insert page numbers in the document.

Discovers the different tips when designing a web site.

Formative: Video Presentation about “How the Internet works” Summative:

Activity 3: Chapter 1: Internet and Internet Etiquette

19

Week 7

Inserting shapes using Illustrations group

VALUING:


The learner:

Draws different kinds of shapes in Word by using the Illustrations group of the INSERT tab.

Demonstrates how to draw basic shapes, lines, block arrows, callouts, stars, and banners.

Formats any object with shape fill color, shape outline color, Font, Line, arrow, shadow effects, and 3-D effects, and dash style

Rotates the objects

Combines 2 or more objects with Group/Ungroup objects command.

Inserts symbols in the document.

Produces a document similar to those created in MS Paint or any graphic software.

Formative:

Ask students to identify/enumerate the shapes in the given picture

Summative:

Activity 4: (SHAPES). To create comic strips that will show Good manners and Right Conduct using the different SHAPES of MS Word.

Week 8

(Basic Documentation And Storyboarding Process For Website Development)

The learner:

Identifies Site Specification and Storyboard

Determines the contents of a Site

Formative:

Picture Analysis Show different kinds of blueprints/plans for houses or

20

Exercises about formatting commands and inserting pictures

Valuing:

Follow standards/advice

Show creativity

Specification.

Creates a Site Storyboard.

Produces a functional storyboard for a web site.

Uses formatting commands that will enhance the layout of the document.

Applies different formatting commands.

Inserts appropriate pictures in the document.

storyboards when creating comic strips.

Summative:

Activity 5: Chapter 3:Storyboard Critiquing a storyboard

Activity 6: Greeting

cards

To prepare cards for

Christmas.

Week 9

Tables

Printing

VALUING: Organize data/information

The learner:

Creates tables in Word.

Determines how to create tables in word.

Shows how to enter and select data in a table.

Determines how to insert/delete and select rows and columns in a table.

Demonstrates how to merge and split cells in a table.

Demonstrates how to rotate text.

Formats table using the icons/commands of table tools layout and design.

Uses the different document views of word

Formative:

Picture analysis Show different kinds of Tables

Summative:

Activity 7: (Class

schedule).

To prepare a Class

Schedule using

tables.

Activity 8: (Calendar in Word).

21

Produces hard copies of documents. Transfer Goal: The knowledge and skills acquired by the students in MS Word will help them in preparing their written reports like research papers and projects.

The skills learned in the program enables the students to make documents like bookmarks, Calendars, greeting cards, resume, brochures, comic strips etc.

Skills acquired from the program will be used when they create questionnaires in the survey to be conducted on the fourth quarter. They will use MS Word for the survey forms (data collection) formulating their own questions.

To create a Calendar for the present year using tables in MS Word.

Activity 9:Bookmark Prepare bookmarks about Valentine’s Day

NOTE: Post-test will be

given to students

Week 10 THIRD QUARTER EXAMINATION

22

SYLLABUS IN TLE 7

FOURTH QUARTER


The learner demonstrates understanding of the process of making documents, presentations,

and spreadsheets; demonstrates competence in performing basic spreadsheets operations

using Ms Excel program by creating and formatting workbooks, create formulas and functions as

well as interpret data using charts; demonstrates competence in preparing presentation.

Content Standard

The learner demonstrates understanding of the specific use of each of the featured productivity

tools; use the standard features of each productivity tools and select the appropriate command in

completing tasks.

Performance Standard The learner transfers learning by: using productivity and developmental tools in an efficient and creative way when designing web sites. Preparing presentations and worksheets according to information requirements.

Time Frame


Week 1

Microsoft PowerPoint

Ms PowerPoint Application Window

Valuing:


The learner:

Identifies the purpose of Ms PowerPoint application and its uses.

Identifies the different parts of PowerPoint

Uses the ribbon and context menus in manipulating slides.

Distinguishes the PowerPoint Panes

Views slide in different ways.

Navigates slides inside the presentation.

Opens and exit Microsoft PowerPoint.

NOTE: Pre-Test about PowerPoint and Excel will be given to students Formative:

Name the icons familiar with the students in a

23

form of a game.

Summative:

Preparation of Project 1: SURVEY

Make a survey using MS Word and Ms Excel

Week 2

MS PowerPoint Tips

Creating presentations

Using placeholder and slides

VALUING:


The learner:

Applies tips in creating effective PowerPoint presentations.

Creates presentations

Enters Text in the placeholders.

Changes the slide design.

Sorts slides.

Views the slide show presentation.

Formative:

Recitation

Summative:

Activity No.1 Principles of Web Design Prepare a presentation about chapter 2: Principles of web design

Week 3

Formatting text in place holders

Animation

Transition

Inserting Pictures

Emphasize test and drawings using shapes supplemented by custom animations.

The learner:

Distinguishes the four kinds of animations.

Applies animation effects to objects, texts and slides.

Discovers how to apply multiple animations to an object.

Discovers how to modify and reorder

Activity 2: Photo Album. Make a photo album in PowerPoint

24

Valuing:

Show creativity and well-designed presentations

animations.

Demonstrates how to add slide transition.

Creates slides animations

Discovers the use of formatting commands in PowerPoint

Insert Pictures and graphics to make the presentation more comprehensible.

Uses shapes to emphasize text and drawings accompanied by custom animations.

Week 4

II. Microsoft Excel

The Microsoft Excel Application Window

Workbook management

Moving around excel

Mouse pointer shapes

VALUING:


The learner:

Identifies the purpose of Ms Excel application and its uses.

Uses the ribbon and context menus in manipulating worksheets.

Identifies the basic parts and function of Ms Excel screen.

Recognizes basic commands and functions of the HOME tab

Creates a simple workbook.

Demonstrates how to create, save, open and close workbook.

Follows the steps in saving, opening, renaming, preview, and closing workbook.

Determines on how to move around worksheet.

Identifies the methods used in inserting and deleting worksheets and cells in Ms Excel.

Differentiates the mouse pointer shapes

Formative:

Recitation: Group activity about MS Excel environment, moving around the worksheet and mouse pointer shapes

Activity 3:

Exercise 1

Enter data in a worksheet

25

used in Excel.

Uses Auto fill feature to fill cells with data that follows a pattern

Week 5 FOURTH MID-QUARTER EXAMINATION

Week 6

Data Management

Working with worksheets

Formatting a worksheet VALUING:

Organize data/information

The learner:

Identifies the 3 types of data.

Determines on how to enter text, values, dates, and fractions.

Organizes data in the worksheet.

Applies the steps in selecting and changing data in a cell.

Defines Formatting and the common tools in formatting data.

Determines how to format text, values, and cells in a worksheet.

Demonstrates how to merge and center text.

Enumerates the steps on how to align cell contents, rotate, and wrap text in a cell.

Applies colors and borders in Excel worksheets.

Formative:

Recitation:

“one stray,

team stay”

about the

icons of the

different tabs

in Ms Excel

and formatting

commands in

MS Excel

Summative:

Activity

4:Class

schedule:

To prepare a

class schedule

using MS

Excel

Week 7 FORMULAS

FUNCTION

The learner:

Manipulates values/numbers in the worksheets

Formative:

Students

26

VALUING:

Follow correct rules and procedures

Defines formula and function.

Names the different mathematical

calculations and their symbols MS excel

can do.

Demonstrates how to enter formula in

excel.

Performs mathematical calculations in a

worksheet using addition, subtraction,

multiplication, and division.

Formats the numeric entries with $,

Comma, percent, and Phil currency.

Shows how to create functions in excel.

Calculates totals using Auto sum feature

of Excel.

Displays the lowest and highest number

in excel.

Shows how to compute average in excel.

Counts the number of cell entries in the

worksheet.

perform basic

arithmetic

operations in

Math using the

game “One

stray, team

stay”.

Summative:

Activity 5:

Exercise 1 &

2:

Using

Formulas

To create

formulas in

Excel using

the basic

arithmetic

operations

Completion of

the Survey

Project:

Interpret the

data of the

survey by

preparing tally

27

sheet.

Week 8

CHARTS

VALUING:

Interpret data/ creativity

The learner:

Identifies the different charts used in Ms Excel.

Demonstrates the steps on how to create charts in Excel.

Modifies the chart with the chart tools design, layout, and format commands.

Demonstrates how to modify, update, and resize, change colors and patterns of a chart.

Formative:

Ask students

to bring the

following:

Bread

Different kinds

of fruits

to be used in

discussing

charts

Summative:

Activity 6:

To

interpret/analy

ze data in the

worksheet by

creating

charts.

Submission of

Survey project

28

Week 9

WEB MARKUP LANGUAGES AND DEVELOPMENT TOOLS

Writing in Another Language

Web Development Tools

Converting Documents, Presentations, and Worksheets to web pages.

VALUING:

Following appropriate formats (or standards)

The learner:

States the steps in converting documents, slide presentations, and worksheets into web pages by creating a flowchart of steps.

Identifies the significance of files that are created after the conversion process.

States the reason why documents, slide presentations, worksheets, and other files should be converted for use in the web.

Creates Web documents by converting Microsoft Office files.

Transfer Goal: The knowledge and skills acquired by the students in Ms Word and Ms Excel will help them in conducting a research/survey about different topics. The students will act as researchers. Suggested sample topics that they may use for the survey are the following:

9. Top 5 most viewed TV station 10. Books that students borrow in the

library 11. Favorite place of students at HAU 12. Factors that make students study

harder. 13. Favorite web sites of students 14. Favorite social networking sites of

Summative:

Activity 7: Exercises #1,2, and 3

Converting documents, presentations, and worksheets into web pages:

NOTE: Post test will be given to students

29

students 15. Factors that affect the studies of

students. 16. People that inspire students to

strive harder.

If the students have in mind of what survey and research they want to work on, they may do so. They will use MS Word for the survey forms (data collection) formulating their own questions. Their respondents are selected students of all year levels of HAU. Make a tally sheet in MS Excel using spreadsheet. Interpret and analyze data using charts. The survey will allow students to experience real life work situations.

Week 10 FOURTH QUARTER EXAMINATION