Digital Citizenship Game

Link to Digital Citizenship Game

Digital Citizenship

Digital Citizenship

Introduction to the topic


Link to Lesson 1 to Lesson 6 of Digital Citizenship

Creating Video Tutorials

Objectives:

Students will be able to create short video tutorials using a screen recording tool.

Activities Day 1:

1. Explore the features of Movavi Video Editing Application.
2. Watch the video "How to record screen' on 'howtos' on movavi.com.
3. Use the screen recording tool to check how does it work.
4. Share your experiences and discuss queries.

Activities Day 2:

1. Watch sample tutorials. 
2. Get approval for your tutorial idea/topic.
3. Use screen recording tool of Movavi to capture screen.
4. Explore 'Edit Video' feature to check how can you add music, voice over and captions.

Exit Poll

Teacher's Links

Cockpit
Result

Activities Day 3:

1. Get your topic of tutorial approved.
2. Start recording your video tutorial.
3. Try voice over if you prefer. You may do it as a HW also for a better sound quality.
4. Add titles, captions, credits.
5. Participate in the EXIT POLL.

Teacher's Links

Cockpit
Result

Activities Day 4:

1. Watch demonstration for how to add narration or music in the video.
2. Complete Tutorial work.
3. Participate in Reflection on the progress of Tutorial Project.

Spreadsheets - Complex Formulas

Objective:

To be able to transform an arithmetic expression into a computerized formula.

Activity 1:

1. Watch the demonstration carefully.
2. Discuss queries.

Activity 2:

1. Download the Activity file from HERE.
2.  Follow the instructions in the file.
3. Save your file in your folder on D drive.

Spreadsheets - Arithmetic Operations

Objectives:

1. To be able to use excel formulas to solve real life basic arithmetic problems.

Task 1:

1. Download Task 1 File.
2. Complete Activities on all 3 sheets.
3. SAVE file in your folder.

Task 2:

1. Download Task 2 File.
2. Make it a complete shopping bill.
3. SAVE file in your folder.
4. Hints:
• Recall what do you see on the shopping bills from any mall?

Spreadsheets - Explore more about Spreadsheets

Activity 1:

Reading 

Spreadsheets:

A spreadsheet is a computer application or program that enables the user to tabulate and collate data. This data can then be used to make calculations, show graphical representations or analysis.

• A spreadsheet comprises of a grid of ‘cells’ arranged in rows and columns and information can be inserted into each cell.
• Each cell can contain text, numbers and formulas.
• A formula is a calculation based from the contents of cells or a total of a combination of cells. The total in that formula can change if the content of the combination cells used is also amended.
• Spreadsheets can be useful for home budgeting or accounting and they make it easy to display information.
• Spreadsheets can consist of a number of different worksheets that can include different data as well as enabling cells on one worksheet to be used and referenced on other different worksheets.
• Information can also be sorted and filtered by a spreadsheet.
• The Microsoft Office spreadsheet is called Excel but there are open office spreadsheets available, including internet-based web apps such as Google spreadsheets.
• Spreadsheets have a number of tools included to support many different types of calculations and can include graphical presentations such as graphs, pie charts etc.

Activity 2:

Watch this video

Introduction to Excel

Activity 3:

Download Activity File

Sample - Outlined program for List Operations

Sample Program (for getting an idea)

Link to sample program