Project CLICK

(Courses for Literacy on Internet and Computer Knowledge)

Cyber Hygiene and Digital Citizenship Training

Module 5: Introduction to Digital Productivity Tools and

Being Future Ready
 Part 1: Introduction to
This course equips adult participants with the
Digital Productivity Tools skills and knowledge to create, edit, and
on Tablet manage documents, spreadsheets, and
presentations on tablet devices. Where
Project CLICK Cyber Hygiene and Digital Citizenship Training participants can learn to collaborate
Module 5: Introduction to Digital Productivity Tools
seamlessly, ensure mobile security, and
integrate with other apps for a productive and
efficient digital experience.
Objectives:
By the end of this course, participants should be able to:
● Recall the advantages and limitations of tablet productivity tools.
● Create documents on tablets, including text formatting and
styling, and apply proofreading techniques.
● Create spreadsheets on tablets, input and format data, and
perform simple calculations using spreadsheet applications.
● Create effective presentations on tablets, design slides and
layouts, and incorporate visual elements.
Advantages of Tablet Productivity Tools

Mobility: Tablet productivity tools

allow users to work from virtually
anywhere. Whether at home, in a
coffee shop, or on the go, tablets offer
the flexibility to be productive outside
of a traditional office setting.
Advantages of Tablet Productivity Tools

Convenience: Tablets are lightweight

and compact, making them easy to
carry and use. Their touch screens
and intuitive interfaces provide a user-
friendly experience.
Advantages of Tablet Productivity Tools

Versatility: Tablet productivity apps

cover a wide range of tasks, including
document creation, spreadsheet
management, presentations, note-
taking, and more. They can replace or
supplement traditional office tools.
Limitations of Tablet Productivity Tools

Screen Size: One of the most

significant limitations of tablets is
their screen size. While compact
and portable, the smaller screen
can be a challenge for tasks that
require detailed or multitasking
work.
Limitations of Tablet Productivity Tools

Processing Power: Tablets may have

limited processing power compared to
desktop or laptop computers. This can
affect their performance, especially for
resource-intensive tasks like video
editing or complex data analysis.
Limitations of Tablet Productivity Tools

Software Compatibility: Not all

desktop software is available in
tablet versions, and this lack of
compatibility can pose
challenges.
Tablet Specifications
Tablet Specifications
Tablet Specifications
Productivity Tools Installed

Word Excel PowerPoint

Productivity Tools Installed

WPS Office Canva MUPDF Mini

WPS Office
WPS Office, available for tablets, is a
versatile and user-friendly mobile office
suite that offers a range of essential
tools for document creation, editing,
and productivity. It includes a word
processor, spreadsheet editor, and
presentation maker, enabling users to
handle various office tasks on their
tablets with ease.
Canva
Canva's tablet app allows users to
access a variety of templates, graphics,
and fonts to craft visually appealing
content effortlessly. Whether you're a
professional graphic designer or
someone looking to enhance their
social media presence, Canva on
tablets is a creative tool that empowers
users to bring their ideas to life with
convenience and flexibility.
MUPDF Mini
MuPDF Mini on tablets is a lightweight and
efficient PDF viewer that provides a
seamless experience for reading and
interacting with PDF documents. Mini allows
users to open, view, and navigate through
PDF files on their tablets with ease. It offers
features like zoom, text search, and
bookmarking for a convenient reading
experience. MuPDF Mini is an excellent MUPDF Mini
choice for those who require a
straightforward and responsive PDF viewing
solution on their tablets.
Cyber Hygiene and Digital Literacy Contents

There are also contents on Cyber

Hygiene and Digital Literacy
downloaded in your tablet. You may
read these modules after the
training for additional knowledge!
You may access these modules by
opening the MUPDF Mini app.
 Word Processing
In this module, participants will delve into
Part 1: Introduction to the world of document creation and
editing using tablet productivity tools.
Digital Productivity Tools
They will learn to apply their knowledge
on Tablet by creating documents on tablets,
Project CLICK Cyber Hygiene and Digital Citizenship Training including essential text formatting and
Module 5: Introduction to Digital Productivity Tools and Being styling techniques.
Future Ready
Through practical exercises, participants
will analyze various methods for text
formatting and styling in the context of
tablet-based document creation.
Introduction to Microsoft Word on Tablets

Microsoft Word is an incredibly

versatile tool, and the tablet
version brings its capabilities to
your fingertips, allowing you to
create, edit, and collaborate on
documents while on the go.
Introduction to Microsoft Word on Tablets

● Introduction to Microsoft Word on

Tablets
● Setting up Microsoft Office
● Navigating the Interface
● Formatting Texts
● Formatting Paragraph
● Insert
● Layout
Setting Up Microsoft Office

1. Open Microsoft Office - Word

2. Click the following buttons in
order:
a. Sign-in Later
b. Skip for Now
c. Next
d. Don’t Send Optional Data
e. Close
3. Navigate Interface Set-up
Setting Up Microsoft Office

1. Open Microsoft Office - Word

2. Click the following buttons in
order:
a. Sign-in Later
b. Skip for Now
c. Next
d. Don’t Send Optional Data
e. Close
3. Navigate Interface Set-up
Setting Up Microsoft Office

1. Open Microsoft Office - Word

2. Click the following buttons in
order:
a. Sign-in Later
b. Skip for Now
c. Next
d. Don’t Send Optional Data
e. Close
3. Navigate Interface Set-up
Setting Up Microsoft Office

You can choose templates from the

“New” option. You can also create a
document from scratch by clicking the
Blank Document.
Navigating the Interface

Ribbon*
* Ribbon: The ribbon is
a toolbar at the top of Cloud Sync
the Word window that Find
organizes commands
into tabs, such as Insertion Point
Home, Insert, Draw,
Layout, and more.

Formatting Options
Navigating the Interface

Print Layout /
The Microsoft Word Mobile View
interface on tablets
offers a user-friendly Undo
and touch-optimized
platform for convenient Save Settings
document creation and
editing on the go.
Formatting Texts

You can effortlessly change

fonts, adjust font sizes, make
text bold, italicize, underline,
and even change text color
—all with a few simple taps
and swipes.
Formatting Texts

In Microsoft Word on
a tablet, easily
change font style
and font size with a
few taps for
personalized
document formatting.
Formatting Texts

Customize text with

ease in Microsoft
Word on your tablet
by changing font color
and applying
highlights to make
your documents
visually appealing.
Formatting Paragraph
Align paragraphs effortlessly
on your tablet with Microsoft
Word, ensuring your
documents look polished and
professional with a simple tap
for alignment adjustments.
Select the paragraph to the
align by double-clicking that
paragraph and adjusting the
insertion point.
Formatting Paragraph

Center Left Right Justify

Microsoft Word Menu
Use the intuitive menu
options by clicking the
Ribbon including Home,
Insert, Draw, Layout,
Review, and View for
efficient document
creation and editing by
clicking the Home in the
prompt.
Microsoft Word Menu: Insert

The Insert menu in

Microsoft Word on your
tablet allows you to
effortlessly add various
elements such as blank
pages, table, pictures,
shapes, text box, link,
header & footer, equation.
Microsoft Word Menu: Layout

The Layout menu helps you

control page formatting,
margins, orientation, and
columns, and page breaks.
ACTIVITY
Advocacy for a Safer Online Community
Advocacy for a Safer Online Community

In this activity, participants will use Microsoft

Word on their tablets to create a persuasive
advocacy document aimed at promoting a safer
and more positive online community. They will
identify an issue related to online safety, digital
citizenship, or cyber hygiene, and craft a
compelling document to raise awareness and
propose solutions.
Advocacy for a Safer Online Community

1. Choose an Online Safety Issue: Each

student selects a specific online safety
issue that they are passionate about, such
as cyberbullying, privacy protection,
misinformation, or responsible social media
use.
2. Create a Document: In Microsoft Word on
their tablets, students create a well-
structured document.
Format/Structure

● Introduction: Describe the issue and its significance.

● Statistics and Facts: Present key data related to the issue.
● Impact: Explain how the issue affects individuals and the online
community.
● Advocacy: Propose solutions, responsible behaviors, or guidelines to
address the problem.
● Call to Action: Encourage readers to join the cause and make the
online community a better place.
● Conclusion: Sum up the main points and reinforce the importance of
the advocacy.
Advocacy for a Safer Online Community
3. Format and Design: Students should utilize formatting tools on
their tablets to enhance the document's visual appeal. The
participants can change font styles, add images, and use layout
options for a professional look.

4. Saving: Choose "Save" for an existing document or "Save As" to

save a copy. Select a storage location (tablet, cloud services, etc.)
Filename is your Surname-Activity1 (Example: DelaCruz-Activity1)
Pick the file format (e.g., .docx or PDF). Tap "Save" to save your
document. Remember to save your work regularly.
 Spreadsheet
Part 1: Introduction to Participants will dive into the art of creating
Digital Productivity Tools compelling presentations using tablet devices.
They will learn to apply their knowledge by
on Tablet crafting engaging presentations on tablets,
focusing on slide design, layouts, and the
Project CLICK Cyber Hygiene and Digital Citizenship Training
Module 5: Introduction to Digital Productivity Tools and Being seamless incorporation of visual elements.
Future Ready Through practical exercises, participants will
analyze the profound impact of visual design
on the effectiveness of tablet-based
presentations.
Introduction to Microsoft Excel on Tablets

Microsoft Excel on tablet devices

provides users with the versatility to
engage in data management and
analytical tasks while on the move.
Users can readily create, modify,
and format spreadsheets,
employing touch controls or stylus
functionality.
Introduction to Microsoft Word on Tablets

● Introduction to Microsoft Excel on

Tablets
● Navigating the Interface
● Creating a New Workbook
● Utilizing Fill Handles
● Basic Formatting
● Formulas and Functions
● Tips and Shortcuts
● Troubleshooting and Support
 Title Bar
Navigating the Interface

Formula Bar
Microsoft Excel ensures
productivity for tasks Column
such as financial Row Worksheet Area
reporting, budgeting,
and data analysis, all
within the convenience
of a tablet.
Navigating the Interface

Ribbon contains various Ribbon

tabs such as Home,
Insert, Formulas, etc.
Find

Sheets Menu contains

options such as cards
Add Worksheet
view, apply filter, and fill Worksheet Tab
color.
Sheets Menu
Cells
Each rectangle in a worksheet is
called a cell. It is the intersection of a
row and a column.
Cells are the basic building blocks of
a worksheet. It can contain a variety
of content such as:
● text
● formatting attributes
● comments
● formulas
● functions
Cells

Click on a cell to select it. When a

cell is selected, you will notice the
borders of the cell appear bold
and the column and row heading
of the cell are highlighted.
The cell highlighted in this
example is cell A1.
Selecting Multiple Cells

Click and drag the

circles in the corner of
the cells until all of the
adjoining cells you
want are highlighted.
Inserting Content in a Cell

Click on a cell to select it.

Enter content into the selected cell by
double-clicking the cell. The content
appears in the cell and in the formula
bar. You can also enter or edit cell
content from the formula bar.
Deleting Content within Cell

Select the cell containing

the content you want to
delete by double clicking
it.
Highlight the text by
clicking select all or
double click the whole
text. Press the backspace
in the keyboard of your
tablet to delete the text.
Deleting Content within Cell

You can select the cell and

click the circle in the corner to
activate the clipboard menu.
Then press CLEAR to delete
the content of that cell.
Copying and Pasting Cell Content

Select the cells you wish to copy.

You may click the circle in the
corner of the cell to activate the
clipboard menu (containing the cut,
copy, and paste functions)

Click the copy icon and select

the cell where you want the content
to be pasted.
Copying and Pasting Cell Content

Notice that the border appearance

changed (broken lines) as you click
the copy icon. Meaning, the copied
content has not been pasted to any
cell yet.

In this example, we want to copy

the content from Cell A1 to Cell A2.
Copying and Pasting Cell Content

After the selecting the destination

cell, click the paste icon
Cutting and Pasting Cell Content

Select the cell you wish to cut. You may

click the circle in the corner of the cell
to activate the clipboard menu
(containing the cut, copy, and paste
functions)
Click the cut icon and select the cell
where you want the content to be
pasted. After the selecting the
destination cell, click the paste
icon.
Dragging and Dropping Cells

Press and hold the cell that

contains the content where you
want to move to a different cell.

Release your finger as you select

the destination cell to move the
content.
Using Fill Handles
The fill handle in Microsoft Excel
is a small square at the lower-
right corner of a selected cell or
range. It's a powerful tool for
quickly populating cells with a
sequence of data. When you
drag the fill handle, Excel
automatically fills adjacent cells
based on the pattern of the initial
selection.
Using Fill Handles
For example, instead of manually typing
all the months in the year, you can use the
fill handle to make your encoding faster.

You can start with the first item in the

sequence (e.g. January). Select the cell
and then click the circle on the corner to
activate the fill handle. Once you click the
word fill, the circle will turn into a square
indicating that the fill handle is toggled.
Using Fill Handles
Click and drag the small square at the
lower-right corner of the selected cell up to
the cell where you want to apply the
sequence.

As you press and hold the square, you will

see a preview of the next value in the
sequence displayed in a tooltip.
Continue dragging and holding the square
until you reach the desired cell.
The selected cells will be automatically
filled with a sequential pattern, such as
months from January to December.
Using Fill Handles (Number Sequence)

When working with number

sequences, it's important to note that
using the fill handle in the same way as
before might not produce the desired
result. For instance, if you intend to fill
cells with sequential numbers from 1 to
a specific value, the usual process will
fill all cells with the number 1.
Using Fill Handles (Number Sequence)
To resolve the sequence issue, you
need to specify the next number in the
sequence, allowing the spreadsheet to
recognize the desired numerical
pattern.
In this example, let's assume the
sequence increments by 1, so we'll
enter the number 2. Afterward, select
both cells and click the circle in the
corner to activate the clipboard menu.
Using Fill Handles (Number Sequence)

Click the 'FILL' button to

enable the fill handle. Next,
drag the square to the target
cell where you intend to
populate the sequence, and
release your touch to
complete the action.
ACTIVITY
Utilizing Fill Handles
Utilizing Fill Handles
In this activity you can utilize the power of using
fill handles especially in populating sequences.
In the each column, you must be able to fill the
sequence of the following:

Column A: Odd Numbers from 1 to 49

Column B: Even Numbers from 2 to 50
Column C: Days of the Week (Monday to
Sunday)
Column D: Time Sequence (8:00 to 20:00)
Column E: Currency Sequence ($100 to $2000)
Column F: Serial Numbers (SN-001 to SN-030)
Example
ACTIVITY
Expense Tracker
Managing Expense Tracker
In today's digital age, managing personal finances
efficiently is crucial. Whether it's tracking daily
expenses or planning a budget, the ability to create
and maintain an expense tracker is an essential skill.
This activity in Microsoft Excel on tablets provides an
interactive and practical approach to financial
management for participants. It offers the following
benefits:
1. Practical Financial Skills
2. Digital Literacy
3. Data Entry and Organization
4. Data Security and Privacy
Managing Expense Tracker
1. Create a New Workbook
2. Set-up the Column Headers: (A1) Date, (B1) Expense, (C1) Amount, and (D1)
Category (Food, Transportation, Clothes, etc.)
3. Apply Bold and cell shading
4. Input Data for all the categories, filling out A2:D11
5. In Cell A12, type the word: SUM
6. In Cell B12, get the total expense by adding the SUM function of B2:B11.
7. In Cell A13, type the word: AVERAGE
8. In Cell B13, get the average of expense by adding the AVERAGE function of
B2:B10.
9. Save your workbook with your LASTNAME-EXCEL1.xlsx.
Example
 Presentation
Part 1: Introduction to This module focuses on the practical aspects
Digital Productivity Tools of managing spreadsheets on tablet devices.
Participants will learn to apply their knowledge
on Tablet by creating spreadsheets on tablets,
mastering data input and formatting, and
Project CLICK Cyber Hygiene and Digital Citizenship Training
Module 5: Introduction to Digital Productivity Tools and Being performing simple calculations using
Future Ready spreadsheet applications. Through hands-on
exercises, participants will evaluate the
effectiveness of tablet-based spreadsheet
applications for data management.
Introduction to Microsoft PowerPoint on Tablets

Microsoft PowerPoint on tablets offers

a user-friendly platform for creating
and delivering engaging presentations
on the go. With intuitive touch controls
and a streamlined interface, users can
easily design slides, add multimedia
elements, and incorporate animations
or transitions.
Introduction to Microsoft PowerPoint on Tablet

● Introduction to Microsoft PowerPoint

for Tablets
● Creating Presentations
● Adding and Formatting Text
● Inserting Images and Multimedia
● Slide Transitions and Animations
● Design and Layout
● Presenter View
● Saving and Sharing Presentations
Navigating the Interface
(Presenter View)

Presentation Title

Presenter View displays the Settings

current slide to the audience
while providing the presenter
with additional information.
The presenter can view
speaker notes, the next slide, Slide
and various navigation tools
in Presenter View. This Presenter Options
feature is particularly helpful
for maintaining a seamless
and professional
presentation.
Navigating the Interface
(Editing Mode)

Presentation Title

Ribbon: This is where Ribbon

you'll find various tabs,
each containing
commands for creating Start Slideshow
and editing
presentations. Common Main Presentation
tabs include Home,
Insert, Design, Slides Pane
Transitions, and more.
Themes
Themes in Microsoft PowerPoint
on tablets offer a collection of pre-
designed styles, colors, fonts, and
effects that provide a consistent
and visually appealing look to your
presentations. With themes, you
can instantly change the overall
design of your slides, creating a
polished and professional
appearance.
Ribbon
Home: Access essential formatting and layout tools, including text
styling, slide organization, and copying and pasting elements.
Insert: Add a variety of content to your presentation, such as text
boxes, images, shapes, charts, and more.
Draw: Create freeform drawings and annotations on slides using
digital ink or touch input.
Design: Choose and customize themes and templates to enhance
the visual appeal of your presentation.
Ribbon
Transitions: Apply dynamic effects to slide transitions to make your
presentation more engaging and seamless.
Animations: Add animations to objects within slides to bring your
content to life.
Slideshow: Begin your presentation in fullscreen mode and navigate
through slides with ease.
Review: Collaborate with others by adding comments, reviewing
changes, and checking for spelling and grammar errors.
View: Adjust the way you see your presentation, including normal view,
slide sorter, and reading view.
Home
You can format text by changing
fonts, styles, and sizes.
Additionally, you can apply bold,
italics, and underlining to
emphasize key points. The ribbon
provides alignment and position
tools to control the placement of
text and objects. You can also use
bullet points and numbering for
lists, manage indentation, and
customize spacing.
Insert

The insert ribbon allows you

to add various elements to
your slides, such as pictures,
shapes, charts, and tables.
You can insert text boxes and
icons to make your slides
more engaging.
Draw

With a range of drawing and

inking options, you can use your
finger to create freeform
shapes, lines, and annotations
directly on your slides. This
ribbon provides various pen
types, colors, and eraser tools
to give you complete control
over your drawings.
Transition Effects

This ribbon allows you to apply

transition animations between
your slides, enhancing the flow
and engagement of your
presentation. With a variety of
transition options, such as
fades, slides, and more, you
can control how your slides
appear and disappear during
the slideshow.
Animations

The Animations ribbon allows you

to apply animations to individual
elements within your slides, such
as text, images, or shapes. With a
range of animation options, you
can choose how these elements
enter, exit, or emphasize on the
slide. The ribbon offers various
animation effects like fades,
zooms, and more, enabling you to
control the visual impact and timing
of each animation.
Slide Show
From Beginning: Start your presentation
from the very first slide, allowing for a full,
uninterrupted experience.
From Current Slide: Begin your
presentation from the current slide, a handy
choice for when you need to jump into
specific sections.
Custom Slideshow: Tailor your presentation
to different audiences or occasions by
creating custom slideshows with selected
slides.
Hide Slide: Conceal specific slides during
your presentation, ensuring a seamless
flow without displaying certain content.
Review
Smart Lookup: Access a wealth of information
on terms or phrases using the web-based
Smart Lookup tool, enhancing your
understanding and content quality.
New Comment: Easily add comments to your
presentation slides, enabling collaborative
feedback and discussions with colleagues or
peers.
Show Comments: Toggle the visibility of
comments within your presentation, ensuring
seamless collaboration and reviewing.
Show Markup: Reveal annotations, changes,
and markup made during the review process,
helping you keep track of revisions and
improvements.
View
View Direction: Control and adjust the
direction of your presentation view, ensuring
your content displays exactly as intended.
Zoom In: Zoom in to focus on specific details,
making your content more accessible and
visually appealing.
Zoom Out: Zoom out to gain a broader
perspective of your presentation, particularly
useful for reviewing slides and structure.
Fit to Window: Optimize your presentation's
view by fitting the content within the window,
ensuring clarity and seamless navigation.
Presenter View
Playing a presentation in Microsoft
PowerPoint on tablets initiates the slide
show mode, and your presentation will
start from the beginning, allowing you
to interact with each slide through taps
or gestures. You can easily navigate
through your slides using intuitive
touch controls, making your
presentation engaging and interactive.
When you're done, a tap of the screen
exits the slide show mode and brings
you back to the regular editing view.
ACTIVITY
Advocating Cyber Hygiene and Digital Citizenship
Advocating Cyber Hygiene and Digital Citizenship
In today's digital age, promoting responsible online
behavior and advocating for cyber hygiene and digital
citizenship is of paramount importance. As technology
evolves, it becomes increasingly vital for individuals to
understand the best practices for maintaining a secure
and ethical online presence. The "Advocating Cyber
Hygiene and Digital Citizenship" activity is designed to
empower participants to be active agents of change in
their online communities.

Objective: To create an engaging and informative

presentation on cyber hygiene and digital citizenship
using Microsoft PowerPoint on tablets, while also utilizing
key features of the application.
Instructions
Part of the presentation should include the discussion
on the importance of cyber hygiene and digital
citizenship. Explain the significance of creating an
advocacy presentation to raise awareness and
promote responsible online behavior.

Participants should also choose a specific aspect of

cyber hygiene or digital citizenship that they are
passionate about or interested in advocating for
(e.g., online privacy, social media etiquette, safe online
communication).
Instructions
Participants should include a title slide, an agenda, and at
least three content slides that cover key information about
their chosen topic. Participants can use text, images, and
other multimedia elements to make their presentations
engaging.

Other key features of Microsoft PowerPoint on tablets

must also be added, such as inserting images, creating
transitions, and adding animations. Encourage them to
explore these features and use them to enhance their
presentations.

Preparation Time: 1 hour

Presentation Time: 5 mins. per presenter
QUESTIONS?
CONCERNS?
SUGGESTIONS?
 Project CLICK
(Courses for Literacy on Internet and Computer Knowledge)
Cyber Hygiene and Digital Citizenship Training

End of Module 5

Thank you for listening!

 Project CLICK
(Courses for Literacy on Internet and Computer Knowledge)
Cyber Hygiene and Digital Citizenship Training

Congratulations!