Create a website add your activities , Submit your assignments & share through the following

Schoology Login EDMODO LOGIN Engrade, Haiku Class, Sophia Class, Udemy Classes Talent LMS

Submit your work : in Schoology & to ravurupaul@hotmail.com , ravurupaul@zoho.com ,

1

Database Management Systems



Video Demo

........................................................................................




1. Create a Database
....
2. Design a Table
....Alternatively Import Data form external source.
....Modify the Design of the Table structure.

3. Design a Form
.
4. Enter Data using Form
.
5. Design a Query
.
6. Design a Report
.
7. Print a Report
.
8. Export Queries output & Reports.
.




Students are requested to design a form to input data
for a set of class students and generate report.
Use the Student Application Form.
http://www.ywies-yt.com/en/admissions/how-to-apply
Student Registration Form Employee Registration Form

Sample Data Entry Form

S2 S3

April Mid - Term Exam Supporting Files :


.

MAJOR JOBS & Salaries in United States of America


Using the above file Calculate Average Salary of US Employees.
Place the screen shots with formula and charts in your website.
Print the report Clearly & Fully showing formula and Value fits in one page.
Make sure your name, class name, Date and Time appear on all the reports as header.
Print a chart showing Bar & Line with Number of Employees & Average Salary.
Print a 3D Pi Chart Showing Share in Percentage Employees for each type of Job. Separate one of your interested type of Job.
Print a 3D Pi Chart Showing Share in Percentage Amount for each type of Job - Separate the Biggest Highest Share of amount Arc.

Spread Sheets : MS Excel 2010 : Default Name Book , with 255 Sheet ,

Each Sheet with 16,384 Rows & 1,048,576 Columns , Cells , Cell address: Navigation.

Formulas - Functions - Charts. Richest Countries in the World Some Stat

Free Excel Spread Sheets World Population ..Use this for for various Excel operations . Population.xls


EXCEL Limits Formula Functions. Use Sum, Average, Count, Countif, Sumif, Etc.,

http://www.techonthenet.com/excel/formulas/ https://exceljet.net/formulas

http://data.worldbank.org/indicator/SP.URB.TOTL.IN.ZS Free Excel Spread Sheets


Data from World Bank

Basing on the Chart & Population file - Find How many people living Overseas

36104e57-9fca-49d2-867a-7dc71b8ceae1-original.jpeg



Sophia : https://www.sophia.org/groups/7957 ......... Group Code: b705bd



Web 2.0 Tools : Microsoft,Windows , Word, PowerPoint, Publisher, Excel,

Google( Docs, sites., ),Zoho( Docs, wiki, sites.,) ,

Edmodo, Skype, Voice Thread, Prezi, Pad lets Wikispaces,Weebly, Issuu Books .,

.

: http://ywewahict.collaborizeclassroom.com can be linked with Gmail.


Web Designing :

Weebly: http://www.weebly.com/
..
Wikispaces
1.Creating Website with Weebly


Creating website with wikispaces




2. Adding Pages


3. Adding Images.


No
Name
Zoho Site
Weebly Site
Wordpress Site

Lucy




Audry




Anna




Wendy




Jun




Kei




Stefan



Computer Programming through Visual Blocks

CODDING:


http://studio.code.org/join/YFYYHB





..Today's Task.

..Supporting Files..

..Required Output..

..Submission Process..

..
Using The Supporting files
Make an Attractive Presentation
Session 1_8.zip
Session 1_8.zip
Session 1_8.zip
Smart Art
Header & Footer
Date & Time
Slide Number
Hyperlinks
Action Buttons
Voice Attachment.
Send in E-Mail.
Turin in through Edmodo.
Upload to Zoho Docs.
Add to Prezi for Zooming
Show this on Wikispaces



Use MS Office Power Point Tools.
Student Need to learn to Find and Presenting Information.
1.1: Evaluating Information found on websites.
Websites.
Website ownership.
Trusting the information.
Facts and Opinions.
1.2: Checking the validity of information.
Checking validity.
Bias.
Up-to-date information.
1.3: Choosing a search engine.
How search engines work.
Sponsored links.
1.4: Presenting information using a slideshow.
Adding Hyperlinks.
Creating an interactive presentation.
1.5: Presenting information using audio.
News reporting.
Gathering information.
Recording the report.

Every Student need to Master to use.
1. Different Font Styles - Smart art - Drawing Tools.
2. Tables - Screenshots - Charts - Hyperlinks - Action Buttons.
3.
Microsoft Office Free For Students

No

Task

Demo


Activity : Sign Up with Zoho - Create , Upload Presentations - Share & Work with group projects.
Step 1: https://www.zoho.com/signup.html Enter e-mail address & Password - Click on Sign Up.
Step 2: Open you mail and click on the link provided by ZOHO for conformation.
Step 3: Click on Continue -
Step 4: Select Docs
Step 5: Create New Presentation - Types of Computer with proper Contents & Media .
.............Share presentation with others by inviting ravurupaul@zoho.com and with your partner









Task - 2
............You can Create Folders for Each Subject
............Like : English , Chinese , Mathematics , Science Etc.,
Step 6: Upload Word Documents, Power Points , Spread Sheets or PDF files
............Create New Document ( Write . Sheet, Show )
Step 7: Share presentation with others by inviting ravurupaul@zoho.com and with your partner
Step 8: Group Editing on the same Document or Presentation or Spread Sheet..Group Projects.









Task - 3

Showing your Presentation on Wiki spaces Webpage.
Step 1: http://www.wikispaces.com/ Sign in to wiki spaces & Zoho Documents.
Step 2 :Open and select the page to keep presentation.
Step 3: Edit the page and keep the cursor where you want presentation.
Step 4: Click on Widget on tool bar - choose Others.
Step 5: Open the presentation on Zoho Docs.Step
6:Click on Share available on Tool Bar.
Step 7: Select Embed - Copy the Embed code.
Step 8: Paste the Embed Code the Wiki spaces & save.
Step 9: Save the Wiki Spaces Page - we can see the presentation.



Showing Digital Book on Wiki spaces webpage.

















S No
Name
E Mail
Zoho Docs
Zoho Website
Zoho Wikis
Wikispaces
1
Catherine
1375051524@qq.com
Yes



2
Ryan
ryan777@yeah.net
ryan777@zoho.com



3
Jonathan
3089841299@qq.com




4
Shiny
1048353687@qq.com
1048353687@zoho.com



5
Ahoge
hairstyleinorder@gmail.com
hairstyleinorder@zoho.com



6
Wendy
746572139@qq.com
Yes



7
Jun
junthekoo@yahoo.com
Yes



8
Lucy
345185556@qq.com




9
Audrey
1123150002@qq.com




10
Ronald
2508302588@qq.com




11
Kei
3158173748@qq.com































































Grade 9 - Contents

Status

ICT InteracCT Book 2



Module 1 Finding and Presenting Information

1
Case Study Introduction

2
1.1 Evaluating information found on websites
Done
3
1.2 Checking the validity of information
Done
4
1.3 Choosing a search engine
Done
5
1.4 Presenting information using a slideshow
Done
6
1.5 Presenting information using audio
Done




Module 2 Web Design and creation

7
Case Study Introduction

8
2.1 Reviewing web page design
Done
9
2.2 Methods for creating web pages
Done
10
2.3 Creating a web page using HTML
Done
11
2.4 Creating a web page using specialized software
Done
12
2.5 Structuring a website
Done




Module 3 Modelling

13
Case Study Introduction

14
3.1 Creating a Spread Sheet model

15
3.2 Developing a model to improve accuracy

16
3.3 Using graphs to model data

17
3.4 Using simulations

18
3.5 Creating a simulation





Module 4 Data Handling

19
Case Study Introduction

20
4.1 Setting up a database

21
4.2 Working with forms

22
4.3 Advanced search techniques

23
4.4 Presenting results





Module 5 Control

24
Case Study Introduction

25
5.1 Creating sets of instructions to control events

26
5.2 Making control instructions more precise

27
5.3 Making control instructions more efficient

28
5.4 Monitoring and control systems





Module 6 Wider aspects of ICT

29
Case Study Introduction

30
6.1 Misuse of personal data

31
6.2 Health and safety issues

32
6.3 Plagiarism and copyright

33
6.4 The impact of ICT





Module 7 Integrated Tasks

34
Producing an e-portfolio

35
7.1 Catalog shop

36
7.2 Choose and Book

37
7.3 Predicting the weather

January 2016 End Term Support Material


-