Spreadsheet Exams Revision

USe the links below to revise for your examinations

http://www.ictspecialist.com/9ss1.pdf

http://www.ictspecialist.com/9ss2.pdf

http://www.ictspecialist.com/9ss3.pdf

http://www.ictspecialist.com/9ss4.pdf

Web design Notes

Use the link below to write short notes in your exercise book on web design

http://www.teach-ict.com/gcse/software/webdesign/miniweb/index.htm

Class task

Create the spreadsheet in the link
Task 1
http://www.crews.org/curriculum/ex/compsci/6thgrade/party.html


Task 2
http://www.icy-tea.com/yr7/02models/league.xls

Task 3
http://www.icy-tea.com/yr7/02models/starcups.xls


Final spreadsheet project
http://icy-tea.com/yr7/02models/disco.htm

Spreadsheet Theory

Research on 8 different areas where spreadsheets are used. In each area identified

a) Describe how the spreadsheets or what within the spreadshets are used and how.
b) The benefits of using the spreadsheet in the given area
c) What are some of the limitations of spreadsheets? what are this things that spreadsheet can not do?

Spreadsheets Assignment

Please attempt the following classwork
http://www.teach-ict.com/gcse/software/spread/tasks/worksheet1.doc


http://www.teach-ict.com/gcse/software/spread/tasks/worksheet2.doc


In the tasks below two links are provided, the first link is a spreadsheet with data and next instructions acted upon the data. Attempt all the questions on the spreadsheet.

http://www.teach-ict.com/gcse/software/spread/tasks/Burgers.xls

http://www.teach-ict.com/gcse/software/spread/tasks/Burgers.doc

Spreadsheet Activities

Attempt the following spreadsheet activities in the links below

http://www.tongatapu.net.to/compstud/mmedia/ssheet/ss_pract4.pdf


http://www.abacustraining.biz/Exercises/Excel/BasicSSConcepts.htm


Each answer question should be printed out

Class Task 2 Homework

Attempt the following for homework

http://www.ictspecialist.com/9ss2.pdf

http://www.ictspecialist.com/9ssp2.pdf

http://www.ictspecialist.com/9ssp3.pdf

http://www.ictspecialist.com/9ssp4.pdf


http://www.watertown.k12.wi.us/RMS/BusEducation/spreadsheet/ss-BOWLING%20SPREADSHEET%20-04.doc



http://www.watertown.k12.wi.us/RMS/BusEducation/spreadsheet/ss-VICTOR%20assignment_06.doc



http://www.watertown.k12.wi.us/RMS/BusEducation/spreadsheet/ss-%20PASTA%20PIRATES.doc

Spreadsheet Task 1

http://mathforum.org/workshops/usi/dataproject/usi.hsdata.html

History of VisiCalc

Read the brief history of Visicalc in the link below

http://www.bricklin.com/visicalc.htm

http://inventors.about.com/library/weekly/aa010199.htm

Word Processing Activities

Attempt the following tasks
1.
http://www.watertown.k12.wi.us/RMS/BusEducation/word_processing/3%20formatting/font_alignments_spacing05.htm

2.
http://www.watertown.k12.wi.us/RMS/BusEducation/word_processing/3%20formatting/painter_replace_cut_caps05.htm

3. http://www.watertown.k12.wi.us/RMS/BusEducation/word_processing/3%20formatting/margin_borders_case05.htm

4.
http://www.watertown.k12.wi.us/RMS/BusEducation/word_processing/3%20formatting/Columns_05.htm

Powerpoint Activities

Attempt each of the following tasks

1. http://www.watertown.k12.wi.us/RMS/BusEducation/powerpoint/Ladybug%20assign07.doc

2. http://www.watertown.k12.wi.us/RMS/BusEducation/powerpoint/all%20about%20me%20ppt%20directions.doc

3. http://www.watertown.k12.wi.us/RMS/BusEducation/powerpoint/country%20ppt%20assign05.doc

PowerPoint Activity

Welcome to our CT myp class. During this period, we will cover two units. The first period will focus on PowerPoint presentation skills.

Task 1
Create an A4 cover page for your folder. The cover page should have

a) Your name

b) Only three images that identifies you,

c) No background color

d) A statement on which one learner profile are you working on and why?



Task 2
Follow the instructions in the link below to create a powerpoint presentation.
http://www.watertown.k12.wi.us/RMS/BusEducation/powerpoint/Ladybug%20assign07.doc

Final Word processing Task

http://www.watertown.k12.wi.us/RMS/BusEducation/word_processing/word_features_reviewed_2.htm

Word processings Activities

Attempt the following tasks

1.

http://www.watertown.k12.wi.us/RMS/BusEducation/word_processing/3%20formatting/font_alignments_spacing05.htm

2.

http://www.watertown.k12.wi.us/RMS/BusEducation/word_processing/3%20formatting/painter_replace_cut_caps05.htm

3. http://www.watertown.k12.wi.us/RMS/BusEducation/word_processing/3%20formatting/margin_borders_case05.htm

4.

http://www.watertown.k12.wi.us/RMS/BusEducation/word_processing/3%20formatting/Columns_05.htm

class assignment

http://www.crews.org/curriculum/ex/compsci/6thgrade/wpassign/jobs.htm

Obama Letter Project

Write a maximum of two page letter to be submitted to the President of United States of America. In your letter show the following and format you letter to look good.

• Telling him about some of his quotes and extracts from his speeches you liked
• Say what you think of him (Obama)?
• What you wish he would try to do while in office?
• How you see yourselve helping him to make a difference?
• Which areas you would want to see the US presidency get connected to help Kenyans
• If you were to ask him one question, what would it be?

Email your word document as an attachment to

serem@akam.ac.ke