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
.
Create a folder on your desk top.
Download the 2016 Students spread sheet in to the folder you created.
Create a Database with "Your Name & School Name".
.
Import the data in spread sheet in to your Database you created.
Step 1 : External Data from Menu
Step 2 : Select Excel
Step 3 : Browse = Select 2016 Students Excel file. Then - Ok
Step 4 : Check - First row contains Column Headings Then - Next, Then - Next,
Step 5 : Choose Primary Key - Student No.Then - Next,
Step 6 : Give Name to the Table , Then - Finish.
..............Screen shot the table in Design View.

Create a Query : To find only your grade , your section , boys / girls only.
Step 1 : Select Create from menu -
Step 2 : Select Query Wizard -
Step 3 : Select Simple Query Wizard. OK
Step 4 : Select All fields - Then Next.
Step 5 : Name the Query - Select Modify the query design - Then Finish.
Step 6 : Add the Criteria - in Class and Gender - Run.
(Class - 8A or 8B or 8* - Gender - M or F)
............. Screen shot the Query in Design View with all criteria visible.

Create a Report
Step 1 : Select Create from menu
Step 2 : Select Report Wizard.
Step 3 : Select all the fields - Then Next -
Step 4 : If we want Grouping Select - Then Next.
Step 5 : If we want Sort order Select - Then Next.
Step 6 : We Choose Layout & Orientation - Next.
Step 7 : Name the Report - Choose Modify - Finish.
Step 8 : Add Your name to page header on top right.
Step 9 : Print Preview - Check & Print Report.
............. Screen shot the print preview or report.
.
Modify the table design - if needed.
add a new field with Photo to add Student's Photo. Date of Birth, Etc.,
Print the form with one student data in it.

Create an attractive Form
To enter Photo & data for new students.
Showing Photo in left side and other data right side to photo.
Print The report.
.


Video Demo

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




1. Create a Database
2. Design a Table
3. Design a Form
4. Enter Data using Form
5. Design a Query
6. Design a Report
7. Print a Report




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


Yewwah Logo
YWIES-YT_Logo-4C-SS-Eng_2016.jpg

YWIES-YT_Logo-RC-SS-Eng_2016.jpg



Using the above file please calculate the profit for the whole year.

Grand Total Number of Cars Sold , Total Cost, Total Sales & Total Profit.

Prepare a Chart showing Monthly Cars Sold.

Prepare a Chart showing Monthly Cars Sold & Profit.

Your name , class name & school name appear in the header.
File name , page number, Date & Time appear in the footer.
These particular should appear on all the following reports.

Print the report showing values .

Print the report showing the formula.

Print the Chart showing Monthly Cars Sold.





Sophia Study Tools


2016 April Mid Term Examination Supporting File:


Weebly

https://app.schoology.com/register.php CODE - C7C5F-HJC7D


Major JOBS & Average Salaries in USA

Schoology Login.... Edmodo Login Submit your work

& mail to ravurupaul@hotmail.com , ravurupaul@zoho.com ,


Free Excel Spread Sheets

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

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

Formulas - Functions - Charts.

World Population .......................

Screen Shot 2016-03-20 at 11.03.18 PM.png


EXCEL Limits Formula Functions.

Use Sum, Average, Count, Countif, Sumif, Etc.,

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

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

January 2016 End Term Support Material :

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


Book - 1 Resource Book - 2 Resource Book - 3 Resource

Book we are using now for this Class:

http://www.hoddereducation.co.uk/Product?Product=9780340940976

.

Current Topic: Desk top Publishing: Using MS Publisher.


Pad Let ( Web Top Publisher )


Connect China Project 2015. Skype Classes, Edmodo, Voice Thread & Project Design.


Skype Group Link: https://join.skype.com/qUqgxY7HCoh6



Codding : Hour of Code - For this class.
http://studio.code.org/join/LRGLLX

EDMODO for submission ( Turn in )

Today's Task.

Supporting Files

Required Output

Submission Process.

Remarks

Using The Supporting files
Make an Attractive Presentation

Header & Footer
Date & Time
Slide Number
Hyperlinks
Action Buttons
Voice Attachement.
Send in E-Mail.
Turin in through Edmodo.
Upload to Zoho Docs.
Add to Prezi for Zooming
Show this on Wikispaces

Connect China 15 Join Code : vsdy8v

Grade 8 A .. Code : uy9mv4

Grade 8 B .. Code : 7a3hxs




Task

Decide what you like and don't like about a presentation.

Use as many tools and objects as possible.

Make a Presentation - start introduce yourself then proceed with ideas you have.

Slide Show
Use Microsoft PowerPoint.
Learn to Use & Present.
..Remarks..
Slide Layout
Choose appropriate Slide Layout.
Title, Sub Title, Running Text , Points Bullets ,

Title Slide, Title and Content, Section Header
Two Content, Comparison, Title Only, Blank,
Content with Caption, Picture with Caption,
Title and Vertical Text, Vertical Title and Text.

Regular
Text: Font & Paragraphs
It is important to keep information
in points rather than paragraph
Font,
Size, Style, Color , Alignments , Levels,
Bullets & Numbers

Insert
Images, Clip Arts , Photos & Screenshots Etc,.
Inserting Image, Clips, Photos & Screenshots Etc.,

Size, Rotation , Flipping , location , arrangement, Cropping,
Color, Brightness, Compressing Etc.,


Tables & Charts



Shapes, Equations, Symbols



Smart Art, Word Art






Advanced
Hyperlinks



Action Buttons



Header & Footer, Date & Time , Slide Number Etc.,


Professional
Sounds, Recording voice



Animation, Transition Effects



Videos , Recording Animation with timing.


Consider purpose and audience.:

Parents , Teachers, Small Kids, Classmates, Teenagers , Boys, Girls, Sports persons Etc.,


Identify what makes a good presentation.


S No.
Task

Video or Presentation Demo







Activity :
Creating your own Website for you with Wikispaces.
Adding New Pages.
Adding Images.
Hyper Linking
Adding Files
Sharing by inviting friends.








1
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 - Parts of Computer with proper Contents & Media .
Share presentation with others by inviting ravurupaul@zoho.com and with your partner








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.







3
Showing 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.








4
Showing Digital Books on Wiki spaces Webpage
Step 1: http://www.wikispaces.com/Sign in to wiki spaces.Step 2: Edit the page and keep the cursor where you want Book.Step 3: Click on Widget on tool bar - choose Others.
Step 5: Open www.issuu.com. Search and select Book you like.
Step 6:Click on Share available below the book.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 Digital Book.














Book we are using now.
http://www.hoddereducation.co.uk/Product?Product=9780340940976
Weekly
Expectations

Grade 8 - - Contents

Status

ICT InteracCT Book 1



Module 1 Presenting Information

1
Case Study Introduction
Done
2
1.1 Evaluating a presentation
Done
3
1.2 Creating a basic presentation
Done
4
1.3 Consistency of design
Done
5
1.4 Information, images and sound
Done
6
1.5 Refining a presentation for a different audience
Done




Module 2 Selecting , Refining and using Information

7
Case study introduction
Done
8
2.1 Researching information
Done
9
2.2 Refining search techniques
Done
10
2.3 Checking information
Done
11
2.4 Designing a magazine article
Done
12
2.5Creating a magazine article using DTP software
Done
13
2.6 Working with text and images in DTP Software
Done




Module 3 Modelling

14
Case study introduction
Done
15
3.1 Working with Spread Sheet models
Done
16
3.2 Refining a Model
Done
17
3.3 Creating a simple model
Done
18
3.4 Formatting and labelling a Model
Done
19
3.5 Developing a model
Done
20
3.6 Making and testing predictions
Done
21
3.7 Creating a Graph
Done




Module 4 Data handling

22
Case Study introduction

23
4.1 Designing a questionnaire
Done
24
4.2 Creating a data structure
Done
25
4.3 Entering and checking data
Done
26
4.4 Sorting and searching a database
Done
27
4.5 Creating new information from data
Done
28
4.6 Reaching conclusions from data
Done




Module 5 Control

29
Case Study introduction

30
5.1 Introduction to control and flowcharts
Done
31
5.2 Creating a flowchart
Done
32
5.3 Using instructions that repeat
Done
33
5.4 Working with variables
Done
34
5.5 Testing instructions and using feedback
Done




Module 6 ICT in the Real World

35
Case study introduction

36
6.1 Uses of ICT in the wider world
Done
37
6.2 Using email and other methods of communication
Done
38
6.3 Staying safe online
Done





S No
Grade 8 A Name
E - Mail
Zoho Docs ..
Wikispaces..
1
Julia
496117609@qq.com


2
Maria
1053549028@qq.com


3
Ruby



4
Lucy
2042988274@qq.com


5
Vivian
13022735922@qq.com


6
Jenny
kyuri3096@naver.com


7
lidia
lidiadream@naver.com


8
Helen
helenhl@naver.com


9
Alex
marinedgarp1@naver.com


10
Jason
narniaedmond@naver.com


11
Ricky
ljsricky@naver.com


12
Ben
rgdrgw123@naver.com


13
Steven
2423926096@qq.com


14
Leo
771421292@qq.com


15
Daniel
2802933590@qq.com


16
Bob
759434040@qq.com


17
David
2691158212@qq.com


18
Davy
731329657@qq.com


19
Jack
2979408785@qq.com


20










S No
Grade 8B Names
E-Mail
Zoho Docs......
Wikispaces.........
1
Stella Wang
2594349149@qq.com
Done

2
Abigail Li
Abi0517@hotmail.com
Done

3
Jessica Shin
duri0416@naver.com
Done

4
Juri Kita
pearl24juju@yahoo.co.jp
Done

5
Sally Kim
sally030124@naver.com
Done

6
Jinny So
jinnythwlals@naver.com
Done

7
Sherry Song
1932548416@qq.com


8
Lisa Chen
2264412714@qq.com


9
Anry
anryjo258@gmail.com


10
Lucas lu
18554029905@163.com


11
Bobsun
15684058970@163.com


12
John wang
569241381@QQ.com


13
Frank Dong
1120148706@qq.com


14
Daniel Cho
sejindaniel@naver.com


15
Felix Son
felixson@naver.com
Done

16
Alex park
alex4488@naver.com
Done

17




18




19




20









YWIES-LOGO.png